tradeoffs between level and chase.xls

文档介绍：Bricks and Tiles Corporation
Current Solution For Tiles

Cost per Tile 50
Starting Production Level 200
Hiring Cost per Tile $25
Firing Cost per Tile $10
Inventory Cost per Tile $100

1 2 3 4 5 6 7 8 9 10 11 12 Totals
Production 200 200 200 200 200 200 200 200 200 200 200 200 2,400
Demand 50 100 200 300 350 50 100 50 50 500 250 400 2,400
Increase Production 0 0 0 0 0 0 0 0 0 0 0 0
Decrease Production 0 0 0 0 0 0 0 0 0 0 0 0
Start Inventory 0 150 250 250 150 0 150 250 400 550 250 200
End Inventory 150 250 250 150 0 150 250 400 550 250 200 0
Cost of Production $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $120,000
Cost of Hiring/Firing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Inventory Cost $7,500 $20,000 $25,000 $20,000 $7,500 $7,500 $20,000 $32,500 $47,500 $40,000 $22,500 $10,000 $260,000
Monthly Cost $17,500 $30,000 $35,000 $30,000 $17,500 $17,500 $30,000 $42,500 $57,500 $50,000 $32,500 $20,000 $380,000
Total Cost $380,000
Bricks and Tiles Corporation
Current Solution For Tiles

Cost per Tile 50
Starting Production Level 200
Hiring Cost per Tile $25
Firing Cost per Tile $10
Inventory Cost per Tile $100

1 2 3 4 5 6 7 8 9 10 11 12 Totals
Production 200 200 200 200 200 200 200 200 200 200 200 200 2,400
Demand 50 100 200 300 350 50 100 50 50 500 250 400 2,400
Increa