ASSIGNMENT $1$: Lesson $1,$ Lesson $2$ & Lesson $3($Assignment $1$: $\_\_\_/10)$

The purpose of Assignment #$1$ is to allow students an opportunity to apply and discuss the principles related to Master Planning of Resources discussed in Lessons $1-3.$

$$ The following assignment will be processed using Word.

$$ Full calculations are required.

$$ Partially completed assignment will not be graded.

$$ Answers will be assessed on their technical merit related to assigned readings.

Marks

$21.$ 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.

Week $123456$

Forecast sales $200300300200150150$

Projected available $300$

MPS

$22.$ Given the following data, calculate how many units are available to promise. There are $5$ units on hand.

Week $123456$

Customer orders $211783$

MPS $303030$

ATP

$33.$ 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:

Week $123456789101112$

Forecast $808080707070707070707070$

Demand $837865614951341711700$

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.

$20$ units in week $3$

$40$ units in week $5$

$120$ units in week $7$

$34.$ 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.

Week $123456789101112$

Forecast $901201108085951001109090100110$

Demand $1059793729872532117625$

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.$

$$ Develop a master schedule using the information above.ASSIGNMENT $1$: Lesson $1,$ Lesson $2$ & Lesson $3($Assignment $1$: $\_\_\_/10)$

The purpose of Assignment #$1$ is to allow students an opportunity to apply and discuss the principles related to Master Planning of Resources discussed in Lessons $1-3.$

$$ The following assignment will be processed using Word.

$$ Full calculations are required.

$$ Partially completed assignment will not be graded.

$$ Answers will be assessed on their technical merit related to assigned readings.

Marks

$21.$ 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.

Week $123456$

Forecast sales $200300300200150150$

Projected available $300$

MPS

$22.$ Given the following data, calculate how many units are available to promise. There are $5$ units on hand.

Week $123456$

Customer orders $211783$

MPS $303030$

ATP

$33.$ 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:

Week $123456789101112$

Forecast $808080707070707070707070$

Demand $837865614951341711700$

a$.$ Given this