Solve this problem in three ways; 1. Graphical 2. Excel solver 3. Sensitivity analysis/ report. a) What will happen to the optimal solution if the unit profit on x increase by 300? b) what will happen happen to the optimal solution if the unit profit on y decreases by 230? c) What will happen to the optimal solution if the unit profit on both x and y change to 700? d) Complete the sensitivity report with upper and lower limit. 1. The JAV Company manufactures two types of lamps; Special lamp and regular lamp. Each special lamp requires 4 pounds of brass and each regular lamp requires 8 pounds of brass. During each production period, the company's brass supply limited to 640 pounds. Each special lamp requires 6 hours of milling time in the machines and each regular lamp requires 2 hours of milling time in the machine, The company's machine are available only for 360 hours in each production period. Each special lamp requires 5 light bulbs that must be imported from Hongkong. The importation of these bulb is limited to 200 units. The contribution to profit of each special lamp and regular lamp are P400 and P360 respectively. How many units of the special lamp and regular lamp should be produced per production period in order to maximize the profit?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section9.5: Multistage Decision Problems

Problem 17P

See similar textbooks

Related questions

Question

100%

Solve this problem in three ways; 1. Graphical 2. Excel solver 3. Sensitivity analysis/ report. a) What will happen to the optimal solution if the unit profit on x increase by 300? b) what will happen happen to the optimal solution if the unit profit on y decreases by 230? c) What will happen to the optimal solution if the unit profit on both x and y change to 700? d) Complete the sensitivity report with upper and lower limit. 1. The JAV Company manufactures two types of lamps; Special lamp and regular lamp. Each special lamp requires 4 pounds of brass and each regular lamp requires 8 pounds of brass. During each production period, the company's brass supply limited to 640 pounds. Each special lamp requires 6 hours of milling time in the machines and each regular lamp requires 2 hours of milling time in the machine, The company's machine are available only for 360 hours in each production period. Each special lamp requires 5 light bulbs that must be imported from Hongkong. The importation of these bulb is limited to 200 units. The contribution to profit of each special lamp and regular lamp are P400 and P360 respectively. How many units of the special lamp and regular lamp should be produced per production period in order to maximize the profit?

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here