Problem 3- Page 483, Q12 (use the excel template on Moodle to solve this problem) (10 marks) 12. A spring-water bottling company has recently expanded into flavoured water. The marketing manager is predicting an upturn in demand based on the new offerings and the increased public awareness of the health benefits of drinking more water. She has prepared aggregate forecasts for the next six months (in truckloads): LO2 Month May Jun Jul Aug Sept Oct Total Forecast 50 60 70 90 80 70 420 The production manager has gathered the following information: Regular production cost Regular production capacity $1,000 per truckload 60 truckloads per month using 20 employees $1,500 per truckload $200 per truckload per Overtime production cost Holding cost month Backorder cost $5,000 per truckload per month Beginning inventory 0 The regular production can be supplemented by up to 30 truckloads a month from overtime. Determine the plan that has the lowest total cost. Hint: Use overtime in August-October. Problem 4- Page 529, Q10, a, b (15 marks) 10. Assume that you are the manager of a shop that assembles power tools. You have just received an order for 50 chain saws, which are to be shipped at the start of week 8. Pertinent information on the chain saw are: LO2 & 3 Lead Time Direct Components Item (wooks) On Hand Chain saw 2 15 A (2), B(1). C (3) A 1 E (3), D (1) D (2), F (3) E (2), D (2) 1 10 2 30 a. Draw the product structure tree for the chain saw and an assembly time chart for this order. b. Develop the material requirements plan for component E and its parents using lot-for-lot ordering. TMODEN B F 1 258269 10 30 20