Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Questions: 1. Formulate this as an optimization problem; make sure to define your decision variables, your objective function and your constraints (1 point) 2. Formulate
Questions: 1. Formulate this as an optimization problem; make sure to define your decision variables, your objective function and your constraints (1 point) 2. Formulate your objective function and your constraints as mathematical expressions (1 point) 3. Enter your data into Excel and use solver to find the optimal mix and the value of your objective function at optimality (1 point) 4. Based on the sensitivity report, how much can you reduce the profit of an SUV without changing the optimal mix? (1 point) Minnie Mouse runs a Fiat automobile factory in Europe. Minnie's factory produces four different models: the sedan, the convertible, the wagon, and the SUV. She wants to use Excel to nelp her optimize her operations. Minnie has asked you to use Excel to help her figure out the numbers of each model to produce in order to maximize the expected total factory profit. However, there are several constraints on the numbers of each model to be produced: - At least 1,000 units of each model must be produced to utilize parts inventory. - Due to contractual obligations to supply a rental car company with cars for its fleet, at least 3,000 units of the sedan, and 1,800 units of the SUVs must be produced. - The factory is not currently capable of producing more than 18,000 cars of all models combined in a year. - It is estimated that no more than 4,000 units of the wagon could be sold in a year, so no more than 4,000 wagons should be produced. - No more than 4,100 units of the convertibles should be produced because that is the most convertible tops that the supplier can guarantee to deliver for the year. Questions: 1. Formulate this as an optimization problem; make sure to define your decision variables, your objective function and your constraints (1 point) 2. Formulate your objective function and your constraints as mathematical expressions (1 point) 3. Enter your data into Excel and use solver to find the optimal mix and the value of your objective function at optimality (1 point) 4. Based on the sensitivity report, how much can you reduce the profit of an SUV without changing the optimal mix? (1 point) Minnie Mouse runs a Fiat automobile factory in Europe. Minnie's factory produces four different models: the sedan, the convertible, the wagon, and the SUV. She wants to use Excel to nelp her optimize her operations. Minnie has asked you to use Excel to help her figure out the numbers of each model to produce in order to maximize the expected total factory profit. However, there are several constraints on the numbers of each model to be produced: - At least 1,000 units of each model must be produced to utilize parts inventory. - Due to contractual obligations to supply a rental car company with cars for its fleet, at least 3,000 units of the sedan, and 1,800 units of the SUVs must be produced. - The factory is not currently capable of producing more than 18,000 cars of all models combined in a year. - It is estimated that no more than 4,000 units of the wagon could be sold in a year, so no more than 4,000 wagons should be produced. - No more than 4,100 units of the convertibles should be produced because that is the most convertible tops that the supplier can guarantee to deliver for the year
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started