Question: please include excel file is possible. have posted the question multiple times and getting copy pasted answers that are incorrect. WILL UPVOTE THANK YOU! Aggregate
please include excel file is possible. have posted the question multiple times and getting copy pasted answers that are incorrect. WILL UPVOTE THANK YOU!
Aggregate Planning Practice Problem Armstrong Manufacturing Co. is preparing an aggregate production plan for next year. Its production manager, Leon Washington, has compiled the following information: - Forecast of quarterly demand in hours per quarter: 250,000;300,000; 400,000;300,000 - Beginning inventory in hours: 20,000 - Initial employment level: 500 workers - Hours worked per quarter by each worker: 400 hours of regular time, 100 hours of overtime (maximum) - Inventory holding costs in dollars per hour per quarter: $4 - Cost of regular time production per hour: $12 - Cost of overtime production per hour: $15 - Cost to hire a worker: $1000 - Cost to Layoff a worker: $1500 Formulate an LP model to identify an optimal production plan by building a decision model in EXCEL
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
