Modeling Analytics

Sheet1

Input Parameters
Product Name	Santa's Grotto	Advent Calendar	Fire Station	Princess' Castle	White House	Rose Bouquet	Friendship Boat	Mona Lisa	Race Car	Planet Explorer
Maximum Demand	20000	60000	110000	110000	35000	70000	45000	30000	17000	35000
Selling Price	$55	$35	$80	$80	$65	$45	$65	$75	$150	$50
Material Cost	$15	$8	$30	$30	$23	$10	$30	$10	$45	$20
Molding machine-hours required	0.01	0.002	0.007	0.01	0.01	0.007	0.005	0.003	0.03	0.006
Packing machine-hours required	0.005	0.003	0.01	0.007	0.005	0.006	0.005	0.013	0.025	0.004
	Machine-hours available	Cost per machine-hour
Molding at Plant 1	2000	$500
Packing at Plant 1	2200	$800
Molding at Plant 2	2200	$400
Packing at Plant 2	1700	$650
Decisions
	Santa's Grotto	Advent Calendar	Fire Station	Princess' Castle	White House	Rose Bouquet	Friendship Boat	Mona Lisa	Race Car	Planet Explorer
Production Quantity at Plant 1	0	0	0	0	0	0	0	0	0	0
Production Quantity at Plant 2	0	0	0	0	0	0	0	0	0	0
Objective
Profit		To be filled in