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? 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. NOTE: Hope you could provide excel file for this will serve as my reviewer.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter6: Optimization Models With Integer Variables

Section: Chapter Questions

Problem 51P

See similar textbooks

Related questions

Question

100%

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? 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. NOTE: Hope you could provide excel file for this will serve as my reviewer.

Expert Solution

Step by step

Solved in 6 steps with 6 images

SEE SOLUTION Check out a sample Q&A here