Question: LP2. Construct a model with an objective function, decision variables, and constraints. Set it up on Excel Solver with values and run it. Do the

LP2. Construct a 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 liit on annual production with each vehicle having a cost and selling price. In addition to production, the company must compy 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.)

	Price	Cost	Rev	MPG	Prod time (hrs)	Line	Min demand
Corolla (X1)	24,000	15,000	9,000	42	2	1	300
Avalon (X2)	60,000	23,000	37,000	39	2	1	300
Tundra (X3)	50,000	25,000	25,000	35	3	2	300
RAV4 (X4)	35,000	20,000	15,000	41	2.5	2	750

Total Production Timeline 1			2,500
Total Production Timeline 2			2,300

PLEASE SHOW HOW TO CALCULATE THE MAX REVENUE, WHICH COULD BE $1,036,000?

PLEASE SHOW A SCREENSHOT OF SOLVER INPUTS

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!

Construct a 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...

PROVIDE A SCREENSHOT OF SOLVER INPUTS AND EXPLAIN THOROUGHLY. Construct a model with an objective function, decision variables, and constraints. Set it up on Excel Solver with values and run it. Do...

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...

QUESTIONS 120 Question 2. Use the file finalexam q2.xlsx. The Grand Prix Automobile Company manufactures cars in three plants and then ships them to four regions of the country The plants can supply...

Create a well-designed spreadsheet to address the problem statement in the description below. Your submission should be a single Microsoft Excel file containing three tabs, one for each part (a),...

(15 pts) FiberTech makes newsprint for newspapers at three mills, A, B, and C. The cost of producing newsprint is estimated to be $210 at mill A, S225 at B, and $220 at C. Five primary geographical...

(15 pts) FiberTech makes newsprint for newspapers at three mills, A, B, and C. The cost of producing newsprint is estimated to be $210 at mill A, $225 at B, and $220 at C. Five primary geographical...

(15 pts) Fiber Tech makes newsprint for newspapers at three mills, A, B, and C. The cost of producing newsprint is estimated to be $210 at mill A, $225 at B, and $220 at C. Five primary geographical...

Let i denote the annual effective rate of interest. Recall that an n-year annuity-immediate with payments 1,2,..., n has the following present value: (Ia)mi = ni nn i where is the discount factor....

The Low Knock Oil Company produces two grades of cut-rate gasoline for industrial distribution. The grades, regular and economy, are produced by refining a blend of two types of crude oil, type X100...

Offsets future taxable income with an NOL to provide a reduction of taxes payable in that future period; therefore, gives rise to a deferred tax asset because it is a future deductible amount.

you will be implementing a Lexicon class. This Lexicon class will maintain a list of words, and the user will be able to query the Lexicon as to whether or not a word is in the Lexicon, the user will...