in solver exel

4 Solive w Excel's Solver The Galaxy Industries Production Problem A Prototype Example Galaxy manufactures two toy doll models - Space Ray -Zapper Resources are Simited to - 1000 pounds of special plastic -40 hours of production time per week. The Galaxy Industries Production Problem- A Prototype Example Marketing requirement - Total production cannot exceed 700 downs. - Number of dozens of Space Rays cannot exceed number of dozens of Zappers by more than 350 . Technological input - Soke Rasmures 2 pounds of 3 minutes of labor per desen - Zippers require 1 pound of plastic and 4 minutes of labor per con The Galaxy Industries Production Problem- A Prototype Example The current production plan calls for - Producing much more more product Space lay isa profie pe care - Un om et over to producences proft perdoor while remaining when the marketing The current production plan consists of Space Rays = 450 cm Zapper 100 den Prolt=54100 per week The Galaxy Linear Programming Model Decisions variables: -X - Weekly production level of Space Rays (in dozens) -X = Weekly production level of Zappers (in dozens). . Objective Function: - Weekly profit to be maximized