Modeling Analytics

Answer Report 1

Microsoft Excel 16.0 Answer Report
Worksheet: [LOGO Production.xlsx]Sheet1
Report Created: 11/18/2022 3:08:50 PM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
	Engine: Simplex LP
	Solution Time: 0.016 Seconds.
	Iterations: 3 Subproblems: 0
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)
	Cell	Name	Original Value	Final Value
	$B$22	Profit Santa's Grotto	$ 2,001,000	$ 2,001,000
Variable Cells
	Cell	Name	Original Value	Final Value	Integer
	$B$18	Production Quantity Santa's Grotto	18000	18000	Contin
	$C$18	Production Quantity Advent Calendar	60000	60000	Contin
Constraints
	Cell	Name	Cell Value	Formula	Status	Slack
	$B$27	Production Quantity Santa's Grotto	18000	$B$27<=$B$28	Not Binding	2000
	$C$27	Production Quantity Advent Calendar	60000	$C$27<=$C$28	Binding	0
	$B$31	Molding Machine-hours used	300	$B$31<=$D$31	Binding	0
	$B$32	Packing Machine-hours used	270	$B$32<=$D$32	Not Binding	30

Sheet1

Input Parameters
	Santa's Grotto	Advent Calendar
Maximum Demand	20000	60000
Selling Price	$55	$35
Material Cost	$15	$8
Molding machine-hours required	0.01	0.002
Packing machine-hours required	0.005	0.003
	Machine-hours available	Cost per machine-hour
Molding	300	$500
Packing	300	$800
Decisions
	Santa's Grotto	Advent Calendar
Production Quantity	18000	60000
Objective
Profit	$ 2,001,000
Constraints
	Santa's Grotto	Advent Calendar
Production Quantity	18000	60000	<=
Maximum Demand	20000	60000
	Machine-hours used		Machine-hours available
Molding	300	<=	300
Packing	270	<=	300
Calculations
	Santa's Grotto	Advent Calendar
Selling Price	$55	$35
Material Cost	$15	$8
Assembly Machine-Hour Cost	$5.00	$1
Packing Machine-Hour Cost	$2.50	$2.40
Margin per Unit	$ 33	$ 24