Question 1

Zed Tech company uses a make to stock strategy. The strut Assembly (P25) is the company's main product. The forecast for P25, the accepted customer orders and the master production schedule is shown below. The company presently has 150 units on hand and a fixed master production schedule quantity of 80 units is used.

P25 Forecast	P25 Customer Orders	MPS
Week	Quantity	Week	Quantity	Week	Quantity
1	60	1	45	1
2	60	2	66	2	80
3	60	3	55	3
4	60	4	65	4
5	60	5	40	5
6	60	6	22	6
7	60	7	10	7
8	60	8	5	8
9	60	9	4	9
10	60	10	2	10

Required:

a). Help the master production scheduler to fill in the master schedule calculation table shown below, by using the forecast, the customer orders and the planned production of product P25.

	1	2	3	4	5	6	7	8	9	10
Ft
Dt
ELt-1
Pt
Elt
ATPt

b). The marketing department has accepted an order for P25 from regular customer for order of 60 units in week 6. Is this a feasible position the marketing department has taken? Explain your answer.