Question: I need help I keep getting errors when putting it on excel Fall 2017 ISEN 430-Deterministic Operations Research Project Assignment (No. 2) Due on 11/27/2017
I need help I keep getting errors when putting it on excel Fall 2017 ISEN 430-Deterministic Operations Research Project Assignment (No. 2) Due on 11/27/2017 at 11:59PM Projeet Question Bob's Custom Trucks has demand over the next six months shown in the table below. Currently -time workers. Cost to hire a new worker is $400 and to fire a worker is ding cost is $300 per car per month. Over the last six months, it takes an $1000. Inventory hol average of 10 worker-days to make one car. Currently, there are 180 cars in stock. Bob wants to make sure that at least a 20-car buffer at the end of each month. Bob says he will not using outsourcing or overtime. What is an optimal production plan over next 6 months that minimizes the total cost for production and workforce change? Month November December January February March April Demand Working day/month 18 378 510 558 732 1056 19 20 21 Project Requirements (1) Formulate the problem as an LP or ILP model, and then use What'sBest to solve it. (2) Write a project report that explains how you formulate the problem, presents your LP or ILP model, and reports and interpret the optimal production plan found using What'sBest. (3) Submit your project report and your What'sBest model through the Blackboard. (4) The project will be graded using the following rubric
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
