AGGRGATE PLANNING, SYSTEMS OPERATIONS MANAGEMENT HELP

profiletaeeieee1e11
aggregateplanning_2.xls
Home>Business & Finance homework help>Operations Management homework help>AGGRGATE PLANNING, SYSTEMS OPERATIONS MANAGEMENT HELP

Template (no formulas)

Aggregate Production Planning Cost Total Total
Costs Per Unit Units Cost
Regular Time Labor Cost
Overtime/Subcontracting
Beginning Inventory Inventory Holding Cost
Beginning Workforce Backorders
Labor Standard (units/worker) Hiring
Layoff
Total Costs
Period 1 2 3 4 5 6 7 8
Demand
Cumulative Demand
Net Cumulative Demand
Production/Inventory Planning
Production
Cumulative Production
Inventory (Excess Units)
Backorders (Units Short)
Capacity Planning
Workers Hired
Workers Layed Off
Workforce Available
Regular Time Capacity (units)
Overtime/Subcontracting (units)
Total Production Capacity (units)

Template (with formulas)

Aggregate Production Planning Cost Total Total
Costs Per Unit Units Cost
Regular Time Labor Cost 0 $0
Overtime/Subcontracting 0 $0
Beginning Inventory Inventory Holding Cost 0 $0
Beginning Workforce Backorders 0 $0
Labor Standard (units/worker) Hiring 0 $0
Layoff 0 $0
Total Costs $0
Period 1 2 3 4 5 6 7 8
Demand
Cumulative Demand 0 0 0 0 0 0 0 0
Net Cumulative Demand 0 0 0 0 0 0 0 0
Production/Inventory Planning
Production
Cumulative Production 0 0 0 0 0 0 0 0
Inventory (Excess Units) 0 0 0 0 0 0 0 0
Backorders (Units Short) 0 0 0 0 0 0 0 0
Capacity Planning
Workers Hired
Workers Layed Off
Workforce Available 0 0 0 0 0 0 0 0
Regular Time Capacity (units) 0 0 0 0 0 0 0 0
Overtime/Subcontracting (units)
Total Production Capacity (units) 0 0 0 0 0 0 0 0

Template (with formulas)

0 0
0 0
0 0
0 0
0 0
0 0
0 0

Level Plan

Aggregate Production Planning Cost Total Total
Costs Per Unit Units Cost
Regular Time Labor Cost $9.60 28000 $268,800
Overtime/Subcontracting $14.40 0 $0
Beginning Inventory 2500 Inventory Holding Cost $5.00 25000 $125,000
Beginning Workforce 18 Backorders $7.50 0 $0
Labor Standard (units/worker) 250 Hiring $500.00 0 $0
Layoff $750.00 2 $1,500
Total Costs $395,300
Period 1 2 3 4 5 6 7 8
Demand 3000 6000 2000 1500 4000 5500 8500
Cumulative Demand 3000 9000 11000 12500 16500 22000 30500
Net Cumulative Demand 500 6500 8500 10000 14000 19500 28000
Production/Inventory Planning
Production 4000 4000 4000 4000 4000 4000 4000
Cumulative Production 4000 8000 12000 16000 20000 24000 28000
Inventory (Excess Units) 3500 1500 3500 6000 6000 4500 0
Backorders (Units Short) 0 0 0 0 0 0 0
Capacity Planning
Workers Hired 0 0 0 0 0 0 0
Workers Layed Off 2 0 0 0 0 0 0
Workforce Available 16 16 16 16 16 16 16
Regular Time Capacity (units) 4000 4000 4000 4000 4000 4000 4000
Overtime/Subcontracting (units) 0 0 0 0 0 0 0
Total Production Capacity (units) 4000 4000 4000 4000 4000 4000 4000

Level Plan

500 4000
6500 8000
8500 12000
10000 16000
14000 20000
19500 24000
28000 28000

Chase Plan

Aggregate Production Planning Cost Total Total
Costs Per Unit Units Cost
Regular Time Labor Cost $9.60 28000 $268,800
Overtime/Subcontracting $14.40 0 $0
Beginning Inventory 2500 Inventory Holding Cost $5.00 0 $0
Beginning Workforce 18 Backorders $7.50 0 $0
Labor Standard (units/worker) 250 Hiring $500.00 50 $25,000
Layoff $750.00 34 $25,500
Total Costs $319,300
Period 1 2 3 4 5 6 7 8
Demand 3000 6000 2000 1500 4000 5500 8500
Cumulative Demand 3000 9000 11000 12500 16500 22000 30500
Net Cumulative Demand 500 6500 8500 10000 14000 19500 28000
Production/Inventory Planning
Production 500 6000 2000 1500 4000 5500 8500
Cumulative Production 500 6500 8500 10000 14000 19500 28000
Inventory (Excess Units) 0 0 0 0 0 0 0
Backorders (Units Short) 0 0 0 0 0 0 0
Capacity Planning
Workers Hired 0 22 0 0 10 6 12
Workers Layed Off 16 0 16 2 0 0 0
Workforce Available 2 24 8 6 16 22 34
Regular Time Capacity (units) 500 6000 2000 1500 4000 5500 8500
Overtime/Subcontracting (units) 0 0 0 0 0 0 0
Total Production Capacity (units) 500 6000 2000 1500 4000 5500 8500

Chase Plan

500 500
6500 6500
8500 8500
10000 10000
14000 14000
19500 19500
28000 28000

Optimal Plan

Aggregate Production Planning Cost Total Total
Costs Per Unit Units Cost
Regular Time Labor Cost $9.60 28000 $268,800
Overtime/Subcontracting $14.40 0 $0
Beginning Inventory 2500 Inventory Holding Cost $5.00 2750 $13,750
Beginning Workforce 18 Backorders $7.50 0 $0
Labor Standard (units/worker) 250 Hiring $500.00 28 $14,000
Layoff $750.00 12 $9,000
Total Costs $305,550
Period 1 2 3 4 5 6 7 8
Demand 3000 6000 2000 1500 4000 5500 8500
Cumulative Demand 3000 9000 11000 12500 16500 22000 30500
Net Cumulative Demand 500 6500 8500 10000 14000 19500 28000
Production/Inventory Planning
Production 3250 3250 2000 1500 4000 5500 8500
Cumulative Production 3250 6500 8500 10000 14000 19500 28000
Inventory (Excess Units) 2750 0 0 0 0 0 0
Backorders (Units Short) 0 0 0 0 0 0 0
Capacity Planning
Workers Hired 0 0 0 0 10 6 12
Workers Layed Off 5 0 5 2 0 0 0
Workforce Available 13 13 8 6 16 22 34
Regular Time Capacity (units) 3250 3250 2000 1500 4000 5500 8500
Overtime/Subcontracting (units) 0 0 0 0 0 0 0
Total Production Capacity (units) 3250 3250 2000 1500 4000 5500 8500
Production -demand 2750 0 0 0 0 0 0
demand -production -2750 0 0 0 0 0 0

Optimal Plan

500 3250
6500 6500
8500 8500
10000 10000
14000 14000
19500 19500
28000 28000