Question
2 1. A furniture company assembles office tables from frames, which it makes, and glass, which it purchases from an outside supplier. The sales department
2 | 1. | A furniture company assembles office tables from frames, which it makes, and glass, which it purchases from an outside supplier. The sales department has prepared the following 6-week forecast for the "Winsor", a popular model. The tables are assembled in lots of 220, and the opening inventory is 300. Complete the projected available balance and the master production schedule.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
2 | 2. | Given the following data, calculate how many units are available to promise. There are 5 units on hand.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3 | 3. | Product A is an assemble-to-order product. It has a lot size of 150, and currently has an on-hand inventory of 110 units. There is a 2-week demand time fence and a 12-week planning time fence. The following table gives the original forecast and the actual customer orders for the next 12 weeks:
a. Given this information, develop a realistic master schedule, complete with ATP logic. b. Explain how you would respond to each of the following customer order requests. Assume these are independent requests, and do not have cumulative effects.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3 | 4. | A Heating, Cooling and Air Condition (HVAC) company has a problem. The heat pumps are fairly expensive to make and store, so the company tends to keep the inventory low. At the same time, it is important to respond to demands quickly, since a customer who wants a heat pump is very likely to get one from a competitor if HVAC doesn't have one available immediately. The current policy to produce pumps is to produce 100 per week, which is the average demand. Even this is a problem, as the production manager has pointed out, since the equipment is also used for other products and the lot size of 300 would be much more efficient. He said he is currently set up for water pump production for the next week and states that he has capacity available to produce 300 at a time next week. The following lists the forecasts and actual customer orders for the next 12 weeks.
The president of HVAC has said that he wants to consider using a formal MPS with ATP logic to try to meet demand more effectively without a large impact on inventory. HVAC has decided to use a demand time fence at the end of week 3 and has also found out that its current inventory is 25 units. HVAC will use the MPS lot size of 300 and that it will produce the first of those lots in week 1.
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started