please create and solve LP and workout by hand 2. please solve using what's best! in...

Transcribed Image Text:

please create and solve LP and workout by hand 2. please solve using "what's best!" in excel and show all formulas used Project Question Bob's Custom Trucks has demand over the next six months shown in the table below. Currently, Bob employees 264 full-time workers. Cost to hire a new worker is $400 and to fire a worker is $1000. Inventory holding cost is $300 per car per month. Over the last six months, it takes an 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 378 510 558 732 1056 840 Working day/month 18 19 12822 20 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. please create and solve LP and workout by hand 2. please solve using "what's best!" in excel and show all formulas used Project Question Bob's Custom Trucks has demand over the next six months shown in the table below. Currently, Bob employees 264 full-time workers. Cost to hire a new worker is $400 and to fire a worker is $1000. Inventory holding cost is $300 per car per month. Over the last six months, it takes an 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 378 510 558 732 1056 840 Working day/month 18 19 12822 20 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.

Answer rating: 100% (QA)

The detailed ... View the full answer