Q8

hi i am posting this 3rd time . please do attempt if you can do all clearly. and fill in all boxes please. Thankyou

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, as shown below (in truckloads): Jul Month Forecast Sept May 50 Jun 60 70 Aus 90 80 Oct 70 Total 420 The production manager has gathered the following information: Regular production cost $1,eee per truckload Regular production capacity 60 truckloads per month using 20 employees Overtime production cost $1,500 per truckload Holding cost $200 per truckload per month Backorder cost $5,000 per truckload per month Beginning inventory e The regular production can be supplemented by up to 30 truckloads a month from overtime. Determine the plan that has the lowe total cost. Hint Use overtime in August-October. (Do not leave any empty spaces; input a "0" wherever it is required. Negative truer COST $5,000 per truckload per month Beginning inventory 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. (Do not leave any empty spaces; input a "0" wherever it is required. Negative answers should be indicated by a minus sign.) May 50 Jun 60 Jul 70 Aug 90 Sep 80 Oct 70 Total 420 Period Forecast Output Regular Overtime Output - Forecast Inventory Beginning Ending Average Backorder Costs: Regular $1,600 Overtime $1,5ee Inventory $200 Backorder @ 55,000 - Total 3