Question: Construct a linear programming model with an objective function, decision variables, and constraints. Set it up on Excel Solver with values and run it .
Construct a linear programming model with an objective function, decision variables, and constraints. Set it up on Excel Solver with values and run it Do the results make sense? Tell me why.You run two manufacturing lines for a car company that makes four different models. This is a mix of cars and light trucks. You want to maximize revenue while satisfying demand. The facility has a max limit on annual production with each vehicle having a cost and selling price. In addition to production, the company must comply with fuel consumption standards under various energy policies and national laws. Eg the average MPG of your production must be at or below MPG the standard. Assume that each car model mileage is the same.Here is your data to use:CorollaAvalon vsTundra hrs hrsRAVEtotal production time linetotal production time line The four models two cars lower end, two cars higher end Each model has a cost and selling price, annual demand, mpg production timeAssume that the two lines have specific operational hoursyearWhat is your set up Show your ExcelWhat is your result? $$qty of each vehicle manufactured. Show your Solver reportDo you have any slack or surplus?
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
