1. 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? 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 L.P or IL.P model, and reports and interpret the optimal production plan found using What'sBest