Scribd
Upload
26 views3 pages

Galaxy Industries Profit Analysis in Excel

This document contains the results of an optimization model for Galaxy Industries. The model maximized profit per week, subject to constraints on plastic use, production time, total production, and product mix. The optimal solution has 320 dozens of Space Rays and 360 dozens of Zappers per week, achieving a maximum profit of 4360. The sensitivity analysis shows how much each decision variable and constraint can increase or decrease without affecting the optimal solution.

Uploaded by

m_michael_c
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
26 views3 pages

Galaxy Industries Profit Analysis in Excel

This document contains the results of an optimization model for Galaxy Industries. The model maximized profit per week, subject to constraints on plastic use, production time, total production, and product mix. The optimal solution has 320 dozens of Space Rays and 360 dozens of Zappers per week, achieving a maximum profit of 4360. The sensitivity analysis shows how much each decision variable and constraint can increase or decrease without affecting the optimal solution.

Uploaded by

m_michael_c
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

Microsoft Excel 10.

0 Answer Report
Worksheet: [Galaxy [Link]]Input

Target Cell (Max)


Cell Name Original Value Final Value
$E$6 Profit/Week Total LHS 0 4360

Adjustable Cells
Cell Name Original Value Final Value
$C$4 Dozens/Week Space Rays 0 320
$D$4 Dozens/Week Zappers 0 360

Constraints
Cell Name Cell Value Formula Status Slack
$E$7 Plastic Total LHS 1000 $E$7<=$G$7 Binding 0
$E$8 Production Time Total LHS 2400 $E$8<=$G$8 Binding 0
$E$9 Total Production Total LHS 680 $E$9<=$G$9 Not Binding 20
$E$10 Product Mix Total LHS -40 $E$10<=$G$10 Not Binding 390
Microsoft Excel 10.0 Sensitivity Report
Worksheet: [Galaxy [Link]]Input

Adjustable Cells
Final Reduced Objective Allowable Allowable
Cell Name Value Cost Coefficient Increase Decrease
$C$4 Dozens/Week Space Rays 320 0 8 2 4.25
$D$4 Dozens/Week Zappers 360 0 5 5.666666667 1

Constraints
Final Shadow Constraint Allowable Allowable
Cell Name Value Price R.H. Side Increase Decrease
$E$7 Plastic Total LHS 1000 3.4 1000 100 400
$E$8 Production Time Total LHS 2400 0.4 2400 100 650
$E$9 Total Production Total LHS 680 0 700 1.0000E+030 20
$E$10 Product Mix Total LHS -40 0 350 1.0000E+030 390
Galaxy Industries

Space Rays Zappers


Dozens/Week 320 360
Total LHS
Profit/Week 8 5 4360
Plastic 2 1 1000 <= 1000
Production Time 3 4 2400 <= 2400
Total Production 1 1 680 <= 700
Product Mix 1 -1 -40 <= 350

You might also like