Reference no: EM131136182
The scenario is the same as for HW-9. The questions are from the topic "sensitivity in Linear Programming":
A refrigerator manufacturer makes 3 models: Mini, Standard, and Large. Upon selling these products, the profit realized per unit is:
Mini: $150
Standard: $200
Large: $250
In order to produce each model, the parts requirements are as follows:
Number of Number of Manufacturing
Grill covers Ice Makers Time (hours)
Mini 1 1 6
Standard 1 2 10
Large 2 2 15
During the next manufacturing cycle, the inventory department has 600 Grill Covers and 800 Ice Makers in stock. The factory has 3000 hours of manufacturing time available.
The linear programming model for the problem is:
Max (150M + 200S + 250L)
s.t. 1M + 1S + 2L < 600 Grill Covers
1M + 2S + 2L < 800 Ice Makers
6M + 10S + 15L < 3000 Manufacturing Time
M, S, L > 0
The solution to the above LP problem and the Sensitivity Report (using MS Excel) are presented on the page 3.
Questions (your answers MUST include reasons based on the Excel solution on page 3):
1. If the profit for the Large model increased to $300, would the optimal solution change?
2. If the profit for the Mini model is reduced to $125 and the profit for the Standard Model is increased to $240 simultaneously and the profit for the Large model stayed at $250, would the optimal solution change?
3. Use MS Excel to solve the modified problem in part 2 and submit a printout of your results - mark it up by hand to identify the impact (if any) to the original solution.
4. If the number of Grill Covers available in stock dropped from 600 to 550 what difference will it make to the maximum profit as long as none of the other resources change?
5. If the number of Ice Makers available in stock doubled from 800 to 1600 what difference will it make to the maximum profit as long as none of the other resources change?
6. If the company increased its capacity to 3500 manufacturing hours, without change in any other resources, will maximum profit change? By how much?
7. If the number of Ice Makers available in stock was reduced from 800 to 600, and the number of manufacturing hours increased from 3000 to 3180, what will be the impact on total profit? Assume that there is no change to the number of Grill Covers in stock.
|
Net income for the month of july
: Summarized operations for J. R. Ross Co. for the month of July are as follows.
|
|
About expectations in application interviews
: A random sample of 50 university admissions officers was asked about expectations in application interviews. Of these sample members, 28 agreed that the interviewer usually expects the interviewee to have volunteer experience doing community proje..
|
|
Describe the organization in terms of industry and history
: Describe the organization in terms of industry, size, and history. Describe how the HR program /policy / process / procedure / initiative that has been proposed should be changed. Describe three (3) reasons why this change is important to make.
|
|
Customers will arrive according to poisson process
: Mr. Chips manufactures an automated vending machine that can prepare a single order of french fries in an average of 40 seconds. The company has placed one of its machines in the Student Center, where it believes customers will arrive according to a ..
|
|
Sensitivity in linear programming
: 2. If the profit for the Mini model is reduced to $125 and the profit for the Standard Model is increased to $240 simultaneously and the profit for the Large model stayed at $250, would the optimal solution change?
|
|
Why the government must be overestimating the revenue
: Explain why the government must be overestimating the revenue it will receive from the resulting inflation tax.
|
|
What is the net income for the period
: Assuming an additional investment of $13,000 but no withdrawals during the period, what is the net income for the period?
|
|
Evelop five major goals for the information technology plan
: evelop at least five major goals for the information technology strategic plan. Justify your response. Speculate on three positive organizational impacts of implementing the strategic plan. Justify your response.
|
|
About nonverbal communication from observing
: To prepare for this module's discussion, observe a man and woman communicating in a public space, such as a shopping mall, meeting place, or sports arena. You decide the location as long as you don't know the people. Pay special attention to nonverba..
|