Scenario Summary
Current Values: Best Case Worst_Case Most_Likely
Changing Cells:
Units Sold 100 200 100 150
Sales Price $ 30.00 $ 30.00 $ 25.00 $ 25.00
Hourly Wage $ 15.00 $ 15.00 $ 20.00 $ 15.00
Result Cells:
Production cost $ 375.00 $ 750.00 $ 500.00 $ 562.50
Net Profit $ 2,625 $ 5,250 $ 2,000 $ 3,188
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.
Bosley Scenario Summary 485695318.xlsx
Microsoft Excel 16.0 Answer Report
Worksheet: [BOSLEY_exploring_e06_grader_Capstone _Start.xlsx]Forecast
Report Created: 2/23/2020 10:37:27 PM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: GRG Nonlinear
Solution Time: 0.031 Seconds.
Iterations: 0 Subproblems: 0
Solver Options
Max Time 100 sec, Iterations 100, Precision 0.000001
Convergence 0.0001, Population Size 100, Random Seed 0, Derivatives Forward, Require Bounds
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 5%, Solve Without Integer Constraints, Assume
Objective Cell (Max)
Cell Name Original Value Final Value
$B$22 Net Profit $ 5,250 $ 5,250
Variable Cells
Cell Name Original Value Final Value Integer
$B$4 Units Sold 200 200 Contin
Constraints
Cell Name Cell Value Formula Status Slack
$B$16 Raw Materials Consumed 600 $B$16<=$B$10 Not Binding 14400
$B$17 Labor Hours Consumed 50 $B$17<=$B$13 Not Binding 1950
$B$4 Units Sold 200 $B$4<=$B$7 Binding 0
Bosley Answer Report 1 485695318.xlsx
teger Constraints, Assume NonNegative
Bosley Answer Report 1 485695318.xlsx
Delta Paint
Input
Units Sold 200
Unit Selling Price $ 30.00
Employee Hourly Wage $ 15.00
Maximum Capabilty per week 200
Limitations
Raw Materials in Units 15000
Required raw materials per unit 3
Required Labor Hours Per Gallon 0.25
Labor Hours available 2,000
Expenses
Raw Materials Consumed 600
Labor Hours Consumed 50
Total Production Cost $ 750.00
Income
Gross Profit $ 6,000
Net Profit $ 5,250
Bosley Forecast 485695318.xlsx
One-Variable Data Table: Production
Total_Costs Gross_Profit Net_Profit
10 $ 37.50 $ 300.00 $ 262.50
20 $ 75.00 $ 600.00 $ 525.00
30 $ 112.50 $ 900.00 $ 787.50
40 $ 150.00 $ 1,200.00 $ 1,050.00
50 $ 187.50 $ 1,500.00 $ 1,312.50
60 $ 225.00 $ 1,800.00 $ 1,575.00
70 $ 262.50 $ 2,100.00 $ 1,837.50
80 $ 300.00 $ 2,400.00 $ 2,100.00
90 $ 337.50 $ 2,700.00 $ 2,362.50
100 $ 375.00 $ 3,000.00 $ 2,625.00
110 $ 412.50 $ 3,300.00 $ 2,887.50
120 $ 450.00 $ 3,600.00 $ 3,150.00
130 $ 487.50 $ 3,900.00 $ 3,412.50
140 $ 525.00 $ 4,200.00 $ 3,675.00
150 $ 562.50 $ 4,500.00 $ 3,937.50
160 $ 600.00 $ 4,800.00 $ 4,200.00
170 $ 637.50 $ 5,100.00 $ 4,462.50
180 $ 675.00 $ 5,400.00 $ 4,725.00
190 $ 712.50 $ 5,700.00 $ 4,987.50
200 $ 750.00 $ 6,000.00 $ 5,250.00
Two-Variable Data Table: Production and Manufacturing Time
Wages $ 15.00 $ 20.00 $ 25.00 $ 30.00 $ 35.00 $ 40.00
10 $ 262.50 $ 250.00 $ 237.50 $ 225.00 $ 212.50 $ 200.00
20 $ 525.00 $ 500.00 $ 475.00 $ 450.00 $ 425.00 $ 400.00
30 $ 787.50 $ 750.00 $ 712.50 $ 675.00 $ 637.50 $ 600.00
40 $ 1,050.00 $ 1,000.00 $ 950.00 $ 900.00 $ 850.00 $ 800.00
50 $ 1,312.50 $ 1,250.00 $ 1,187.50 $ 1,125.00 $ 1,062.50 $ 1,000.00
60 $ 1,575.00 $ 1,500.00 $ 1,425.00 $ 1,350.00 $ 1,275.00 $ 1,200.00
70 $ 1,837.50 $ 1,750.00 $ 1,662.50 $ 1,575.00 $ 1,487.50 $ 1,400.00
80 $ 2,100.00 $ 2,000.00 $ 1,900.00 $ 1,800.00 $ 1,700.00 $ 1,600.00
90 $ 2,362.50 $ 2,250.00 $ 2,137.50 $ 2,025.00 $ 1,912.50 $ 1,800.00
100 $ 2,625.00 $ 2,500.00 $ 2,375.00 $ 2,250.00 $ 2,125.00 $ 2,000.00
110 $ 2,887.50 $ 2,750.00 $ 2,612.50 $ 2,475.00 $ 2,337.50 $ 2,200.00
120 $ 3,150.00 $ 3,000.00 $ 2,850.00 $ 2,700.00 $ 2,550.00 $ 2,400.00
130 $ 3,412.50 $ 3,250.00 $ 3,087.50 $ 2,925.00 $ 2,762.50 $ 2,600.00
140 $ 3,675.00 $ 3,500.00 $ 3,325.00 $ 3,150.00 $ 2,975.00 $ 2,800.00
150 $ 3,937.50 $ 3,750.00 $ 3,562.50 $ 3,375.00 $ 3,187.50 $ 3,000.00
160 $ 4,200.00 $ 4,000.00 $ 3,800.00 $ 3,600.00 $ 3,400.00 $ 3,200.00
170 $ 4,462.50 $ 4,250.00 $ 4,037.50 $ 3,825.00 $ 3,612.50 $ 3,400.00
180 $ 4,725.00 $ 4,500.00 $ 4,275.00 $ 4,050.00 $ 3,825.00 $ 3,600.00
190 $ 4,987.50 $ 4,750.00 $ 4,512.50 $ 4,275.00 $ 4,037.50 $ 3,800.00
200 $ 5,250.00 $ 5,000.00 $ 4,750.00 $ 4,500.00 $ 4,250.00 $ 4,000.00
Bosley Forecast 485695318.xlsx
Gross_Profit =Forecast!$B$21
Hourly_Wages2018 =Forecast!$B$6
Total_Production_Cost =Forecast!$B$18
Bosley Range Names 485695318.xlsx
