Optimizing Production and Profit in Various Product Lines

School: Florida International University - Course: FIN 4345 - Subject: Accounting

Valencia Products LaserStopSpeedBuster Numbers Produced0.00333.00 Unit Profit$124.00$136.00 Used Component A18123996 <=4000 units available Component B682664 <=3500 units available TOTAL PROFIT $45,288.00

Linear solution LaserStopSpeedBuster TOTAL PROFIT Numbers Produced0 333.3333333$45,333.33

Microsoft Excel 16.0 Answer Report Worksheet: [Exercise 6 data.xlsx]14.1 Report Created: 6/26/2022 11:19:00 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.047 Seconds. Iterations: 1 Subproblems: 4 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) CellNameOriginal ValueFinal Value $A$12TOTAL PROFIT$45,288.00$45,288.00 Variable Cells CellNameOriginal ValueFinal ValueInteger $B$5Numbers Produced LaserStop0.000.00 Integer $C$5Numbers Produced SpeedBuster333.00333.00 Integer Constraints CellNameCell ValueFormulaStatusSlack $D$8Component A Used3996 $D$8<=$F$8Not Binding4 $D$9Component B Used2664 $D$9<=$F$9Not Binding836