Question: Please provide all the formulas in excel D and E. maximum allowable inventory an hand to 800 units or less. Note: Do not produce in


Please provide all the formulas in excel
D and E. maximum allowable inventory an hand to 800 units or less. Note: Do not produce in overtime if production or inventory are adeguate to cover demand. The total overtime production cost =4 (Enter your response as a whoie number.) The total inventory holding cost for January through August = : (Enter your response as a whole number.) The total stockout cost =$ (Enter your response as a whole number.) The total cost, excluding nomal time labor costs, for Plan D= : . (Enter your response as a whole number.) The total subcontracting cost =$. (Enter your response as a whole number.) The total inventory holding cost for January through August =$. (Enter your response as a whole number.) The total cost, excluding normal time labor costs, for Plan E=!. (Enter your response as a whole number.)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
