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 springwater 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 Forecast The production manager has gathered the following information: Regular production cost$ per truckloadRegular production capacity truckloads per month using employeesOvertime production cost$ per truckloadHolding cost$ per truckload per monthBackorder cost$ per truckload per monthBeginning inventory The regular production can be supplemented by up to 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 wherever it is required. Negative answers should be indicated by a minus sign. PeriodMayJunJulAugSepOctTotal Forecast Output Regular Overtime Output Forecast Inventory Beginning Ending Average Backorder Costs: Regular @ $ Overtime @ $ Inventory @ $ Backorder @ $ Total $
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
