Solve this problem in three ways; 1. Graphical (provide steps and photos) 2. Excel solver (provide steps and photos) 3.

[answerhappygod]

Solve this problem in three ways;
1. Graphical (provide steps and photos)
2. Excel solver (provide steps and photos)
3. Sensitivity analysis/ report. (provide steps and
photos)
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.
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?