dfdfsfer
05-14-2000, 04:20 AM
Here's a challenging problem if anybody has some time on their hands
AZDyemasters (AZD) is a small dye works and is part of the AZ Textiles group. As such they perform all of the dying of knitted garments produced by the AZ Textiles group.
When work is delivered to them it comes in batches. Each batch contains a number of identical garments all of which must be dyed the same colour. The batch comes with a batch card attached to
it which contains:- Batch number, Garment code and description, Quantity (i.e number of garments m the batch), Due date, Distributor to be supplied, Material, Colour, Weight per garment
Using this information, the production manager then has to plan the dying schedule for the following week~ This takes quite a long time. Firstly it is necessary to work out which of the dying vats the batch will fit into. They have 5 different vats. The smallest is capable of holding 50Kg of garments and the largest can hold 500Kg. It is very important that the whole batch is dyed in one go in order to maintain absolute consistency of colour.
Next it is necessary to work out how long each of the batches will take so that it can be seen if any of the vats are overloaded by having more hours of dying than are available in the week. in order to do this reference is made to the standard dying process book. This book contains tables that give the dying times for each of the colours that they use. This is complicated by the fact that different materials need different times. An example of the information in the standard dying process book is given below.
Material Code Description Dying time ASI2Y Cotton 2.45
ADI3Z 30%Cotton 70% Nylon 2.30
QYRl3Y 40%Cotton 60% Viscose 2.00
QBI5E Nylon 3.60
If any of the vats are overloaded there are a wide range of options to deal with the Situation
Experience and knowledge of what is actoally going on in the factory is used to choose between Overtime, using spare capacity on large (and consequently more expensive) vats, delaying orders or m extreme cases sending some of the batches to one of the local independant dyers.
Requirements:
1. Design a simple computer system that could be used by the production manager to help him work Out a schedule for the following week. Your design should be
presented as a series of menu options. You should explain briefly what will happen when each of the options is chosen by the user.
2. You should also list the tables of data that will be used by the system. For each table you must list the fields of data that must be included. It is NOT necessary to suggest field lengths or field types for these fields.
Here is a similar case study which i have done so all i would like is a little help with the above one which should be in the same format eg inputs, outputs, what each button does and a list of tables
AZ EARTHMOVERS - CASE STUDY
AZ Earthmovers (AZE) manufacture a variety of diggers and other earthmoving vehicles. Their main assembly plant has been using Just-In-Time techniques for controlling manufacture for the last five years which has brought major benefits to the company.
One aspect of this policy is that all suppliers are controlled by schedules and are required to supply batches of components to the assembly plant daily. Two types of schedule are issued. The only schedule gives target quantities that the company will require each week over the forthcoming month. Weekly schedules are then an actual order for specific amounts of components to be delivered on each day of the forthcoming week.
The suppliers are obliged to deliver the components in standard containers provided by AZE. One container only ever holds one type of components although one delivery may include several containers each holding different types of component. There are five types of standard container used by AZE and the Planning Department specify the type of container and the quantity of components to be in the container for each one of the types of component. Most suppliers manufacture more than one type of component for AZE and consequently some of them use more than one type of container.
The suppliers provide their own transport and as each daily consignment of components is delivered the lorry takes away an appropriate number of the right kind of containers for the next day's delivery.
Unfortunately AZE has lost £200,000 worth of containers in the first year of operation and they have decided to use a computer system to monitor the distribution of the containers.
Svstem Requirements
The system must be able to use the daily delivery schedules to work out the number and type of containers that should be issued to each supplier.
The system must be able to print out the numbers of containers of each type that are held by each supplier at any time.
The system must take account of the fact that suppliers may request a different number of containers than is calculated by a direct calculation so that they can produce and pack components ahead of request in order to accommodate their own production constraints.
What You Must Do
Design a simple computer system to meet these requirements. Your design should be presented as a set of menu options. You should explain briefly what will happen when each option is chosen by the user.
You must also list the tables of data that will be used by the system. For each table you must list the fields of data that must be included.
AZ Earthmovers: Container Monitoring System
INPUTS
Parts schedule
Parts per container
Numbers taken
Numbers returned
Types of containers
OUTPUTS
Containers to be issued
Location of Containers
Menu
Container Tracking
____________________________________________________
I I I I I
Schedule Location Issue Return Background
______ _________________
I I I I I
Container Supplier Part Supp Contr
1. Schedule
This option allows the user to enter a new weekly schedule, or display and modify an existing schedule. when the user selects this option the current weekly schedule is displayed on the screen and the user is asked whether he wants to replace the schedule.
If the user replies Yes, (s)he is asked to enter the start date for the new schedule and is then given the opportunity of filling in a table which has a section for each supplier. This enables the quantity of each part required on each day of the week to be entered.
If the user replies No, (s)he is presented with the current table and is able to edit it.
In either case there is an option to print sections of the table.
2. Location
This option is used to find the location of containers. When chosen, two options are available.
2.1 Container
When this option is chosen the user is prompted to enter a type of container. The system then displays the list of suppliers who hold these containers and the numbers that they hold.
The user is also given the option to print parts of this list.
2.2 Suppliers
when this option is chosen the user is prompted to enter the name of a supplier. The system will then display a list of all types of container held by the specified supplier and the quantities held.
3. Issue
This option is used to record the number of containers actually issued to a supplier. when this option is selected, the user is prompted to enter a supplier code. Using the computers date and time the system displays the number of each type of container to be issued to the supplier. For each part that they will deliver the next day, the systems calculated the number of containers needed from the number of parts per container that is recorded in the background data. The total number of containers to be issued is then the numbers for each part added together although a separate total has to be kept for each container type.
At the same time, the screen displays the number of containers held by the supplier, so that it can be seen if a supplier is keeping excess numbers of containers.
The user is then allowed to alter the number actually taken by this supplier if this is different from the calculated value for any reason.
4. Returns
This option is used to record when containers are returned. This option works in a sirnilar way to the issues option except that the computer calculates the number expected to be returned based on the schedule for the current day.
Again the user is prompted to record differences from the calculated value.
5. Background
This option is used to maintain the background data needed by the system. Three options are available
5.1 Parts
When this option is selected the user is presented with a table showing the information held about each part (see data below). The user may then add new parts, modi~ existing data, delete parts that are no longer used and print information from the table.
5.1 Supplier
When this option is selected the user is presented with a table showing the information held about each Supplier(see data below). The user may then add new suppliers, modi~ existing data, delete suppliers that are no longer used and print information from the table.
5.1 Containers
when this option is selected the user is presented with a table showing the information held about each type of containers(see data below). The user may then add new containers, modify existing data, delete containers that are no longer used and print information from the table.
DATA
SCHEDULE
supplier
part number
qty needed day 1
qty needed day 2
qty needed day 3
qty needed day 4
qty needed day 5 (assumes a 5 day working week)
PART
part number description
type of container number to fit into container
SUPPLIER
Supplier name
number of containers held type 1
number of containers held type 2
number of containers held type 3
number of containers held type 4
number of containers held type 5
CONTAINER
container type total number owned
AZDyemasters (AZD) is a small dye works and is part of the AZ Textiles group. As such they perform all of the dying of knitted garments produced by the AZ Textiles group.
When work is delivered to them it comes in batches. Each batch contains a number of identical garments all of which must be dyed the same colour. The batch comes with a batch card attached to
it which contains:- Batch number, Garment code and description, Quantity (i.e number of garments m the batch), Due date, Distributor to be supplied, Material, Colour, Weight per garment
Using this information, the production manager then has to plan the dying schedule for the following week~ This takes quite a long time. Firstly it is necessary to work out which of the dying vats the batch will fit into. They have 5 different vats. The smallest is capable of holding 50Kg of garments and the largest can hold 500Kg. It is very important that the whole batch is dyed in one go in order to maintain absolute consistency of colour.
Next it is necessary to work out how long each of the batches will take so that it can be seen if any of the vats are overloaded by having more hours of dying than are available in the week. in order to do this reference is made to the standard dying process book. This book contains tables that give the dying times for each of the colours that they use. This is complicated by the fact that different materials need different times. An example of the information in the standard dying process book is given below.
Material Code Description Dying time ASI2Y Cotton 2.45
ADI3Z 30%Cotton 70% Nylon 2.30
QYRl3Y 40%Cotton 60% Viscose 2.00
QBI5E Nylon 3.60
If any of the vats are overloaded there are a wide range of options to deal with the Situation
Experience and knowledge of what is actoally going on in the factory is used to choose between Overtime, using spare capacity on large (and consequently more expensive) vats, delaying orders or m extreme cases sending some of the batches to one of the local independant dyers.
Requirements:
1. Design a simple computer system that could be used by the production manager to help him work Out a schedule for the following week. Your design should be
presented as a series of menu options. You should explain briefly what will happen when each of the options is chosen by the user.
2. You should also list the tables of data that will be used by the system. For each table you must list the fields of data that must be included. It is NOT necessary to suggest field lengths or field types for these fields.
Here is a similar case study which i have done so all i would like is a little help with the above one which should be in the same format eg inputs, outputs, what each button does and a list of tables
AZ EARTHMOVERS - CASE STUDY
AZ Earthmovers (AZE) manufacture a variety of diggers and other earthmoving vehicles. Their main assembly plant has been using Just-In-Time techniques for controlling manufacture for the last five years which has brought major benefits to the company.
One aspect of this policy is that all suppliers are controlled by schedules and are required to supply batches of components to the assembly plant daily. Two types of schedule are issued. The only schedule gives target quantities that the company will require each week over the forthcoming month. Weekly schedules are then an actual order for specific amounts of components to be delivered on each day of the forthcoming week.
The suppliers are obliged to deliver the components in standard containers provided by AZE. One container only ever holds one type of components although one delivery may include several containers each holding different types of component. There are five types of standard container used by AZE and the Planning Department specify the type of container and the quantity of components to be in the container for each one of the types of component. Most suppliers manufacture more than one type of component for AZE and consequently some of them use more than one type of container.
The suppliers provide their own transport and as each daily consignment of components is delivered the lorry takes away an appropriate number of the right kind of containers for the next day's delivery.
Unfortunately AZE has lost £200,000 worth of containers in the first year of operation and they have decided to use a computer system to monitor the distribution of the containers.
Svstem Requirements
The system must be able to use the daily delivery schedules to work out the number and type of containers that should be issued to each supplier.
The system must be able to print out the numbers of containers of each type that are held by each supplier at any time.
The system must take account of the fact that suppliers may request a different number of containers than is calculated by a direct calculation so that they can produce and pack components ahead of request in order to accommodate their own production constraints.
What You Must Do
Design a simple computer system to meet these requirements. Your design should be presented as a set of menu options. You should explain briefly what will happen when each option is chosen by the user.
You must also list the tables of data that will be used by the system. For each table you must list the fields of data that must be included.
AZ Earthmovers: Container Monitoring System
INPUTS
Parts schedule
Parts per container
Numbers taken
Numbers returned
Types of containers
OUTPUTS
Containers to be issued
Location of Containers
Menu
Container Tracking
____________________________________________________
I I I I I
Schedule Location Issue Return Background
______ _________________
I I I I I
Container Supplier Part Supp Contr
1. Schedule
This option allows the user to enter a new weekly schedule, or display and modify an existing schedule. when the user selects this option the current weekly schedule is displayed on the screen and the user is asked whether he wants to replace the schedule.
If the user replies Yes, (s)he is asked to enter the start date for the new schedule and is then given the opportunity of filling in a table which has a section for each supplier. This enables the quantity of each part required on each day of the week to be entered.
If the user replies No, (s)he is presented with the current table and is able to edit it.
In either case there is an option to print sections of the table.
2. Location
This option is used to find the location of containers. When chosen, two options are available.
2.1 Container
When this option is chosen the user is prompted to enter a type of container. The system then displays the list of suppliers who hold these containers and the numbers that they hold.
The user is also given the option to print parts of this list.
2.2 Suppliers
when this option is chosen the user is prompted to enter the name of a supplier. The system will then display a list of all types of container held by the specified supplier and the quantities held.
3. Issue
This option is used to record the number of containers actually issued to a supplier. when this option is selected, the user is prompted to enter a supplier code. Using the computers date and time the system displays the number of each type of container to be issued to the supplier. For each part that they will deliver the next day, the systems calculated the number of containers needed from the number of parts per container that is recorded in the background data. The total number of containers to be issued is then the numbers for each part added together although a separate total has to be kept for each container type.
At the same time, the screen displays the number of containers held by the supplier, so that it can be seen if a supplier is keeping excess numbers of containers.
The user is then allowed to alter the number actually taken by this supplier if this is different from the calculated value for any reason.
4. Returns
This option is used to record when containers are returned. This option works in a sirnilar way to the issues option except that the computer calculates the number expected to be returned based on the schedule for the current day.
Again the user is prompted to record differences from the calculated value.
5. Background
This option is used to maintain the background data needed by the system. Three options are available
5.1 Parts
When this option is selected the user is presented with a table showing the information held about each part (see data below). The user may then add new parts, modi~ existing data, delete parts that are no longer used and print information from the table.
5.1 Supplier
When this option is selected the user is presented with a table showing the information held about each Supplier(see data below). The user may then add new suppliers, modi~ existing data, delete suppliers that are no longer used and print information from the table.
5.1 Containers
when this option is selected the user is presented with a table showing the information held about each type of containers(see data below). The user may then add new containers, modify existing data, delete containers that are no longer used and print information from the table.
DATA
SCHEDULE
supplier
part number
qty needed day 1
qty needed day 2
qty needed day 3
qty needed day 4
qty needed day 5 (assumes a 5 day working week)
PART
part number description
type of container number to fit into container
SUPPLIER
Supplier name
number of containers held type 1
number of containers held type 2
number of containers held type 3
number of containers held type 4
number of containers held type 5
CONTAINER
container type total number owned