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. (E.g., the average MPG of your production must be at or below 40 MPG - the 2026 standard. Assume that each car model mileage is the same.)Here is your data to use:Corolla24,00015,0009,00060,00021,00037,000Avalon302 vsTundra50.00025.00025.00035/3 hrs 41.2.5 hrsRAVE35,00020,00015,000total production time line2500total production time line 22300The 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 hours/yearWhat 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!