Question: A spring - water bottling company has recently expanded into flavoured water. The marketing manager is predicting an upturn in demand based on the new

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): MonthMayJunJulAugSeptOctTotal Forecast506070908070420 The production manager has gathered the following information: Regular production cost$1,000 per truckloadRegular production capacity60 truckloads per month using 20 employeesOvertime production cost$1,500 per truckloadHolding cost$200 per truckload per monthBackorder cost$5,000 per truckload per monthBeginning inventory0 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 AugustOctober. (Do not leave any empty spaces; input a "0" wherever it is required. Negative answers should be indicated by a minus sign.) PeriodMayJunJulAugSepOctTotal Forecast506070908070420 Output Regular Overtime Output - Forecast Inventory Beginning Ending Average Backorder Costs: Regular @ $1,000 Overtime @ $1,500 Inventory @ $200 Backorder @ $5,000 Total $

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!