One day your boss enters your office and poses the question: Given our current b
ID: 448868 • Letter: O
Question
One day your boss enters your office and poses the question: Given our current budget, if we could sell them, what’s the best mix of the two cars that would produce the most profit?
Things you know about the plant:
Plant daily capacity: 1,108 vehicles (3 8hr shifts)
Plant size: 3.6 million square feet
Daily plant operating budget: $15,000,000
Things you know about the cars:
Production Cost ($)
Honda Accord $12,000
Acura TLX $19,000
Cycle Time (s)
61 s
95 s
Profit ($)
$1,300
$2,000
“Cycle Time” is the time it takes to produce a vehicle on an assembly line. When manufacturing Honda Accords, a new car is driven off the end of the line every 61 seconds. You cannot change the shipping arrangements so the daily production limit must remain 1108 vehicles.
Before you can solve the problem:
What is(are) the independent variable(s) (system inputs)? What is the objective function?
How should it be formatted? Are there upper or lower bounds?
What variables do they restrict?
What are they?
Are there any other constraints?
Time? Budget? Production?
Are the constraints linear inequality, linear equality, nonlinear inequality, or nonlinear equality?
Use one of the built-in MATLAB optimization functions to solve for the answer. For the purpose of this assignment, assume that you are not limited to integer answers (aka you can produce 0.35 cars if needed).
Display to the command window:
The number of Accords and TLXs produced. The total production costs required (in dollars). The total production time required (in hours).
Explanation / Answer
The Independent Variables are : Number of Honda Accord ( H ) & Number of Acura TLX ( A)
Objective Function: To maximize the profit by producing H numbers of Honda Accord and A number of Acura TLX
1300*H + 2000*A
Constraints:
Yes there is lower Bounds:
The constraints are Linear inequality
After using Excel solver the Answer is
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.