BUS 687 Assignment

profilekingstonman41
SuppyChainMgt.xlsx
Home>Business & Finance homework help>Financial markets homework help>BUS 687 Assignment

Raw Material

Raw Material
Current Plan Q1'19A Q2'19A Q3'19A Q4'19A Q1'20A Q2'20A Q3'20A Q4'20A Q1'21P Q2'21P Q3'21P Q4'21P
Material Ordered [Units] 458 562 600 600 750 1,000 1,000 1,000 900 1,825 3,550 3,000
Backorders [Units] 0 0 0 0 0 0 0 0 0 0 0 0
Raw Material Cost per Unit [$] $86.10 $86.10 $86.10 $86.10 $86.10 $86.10 $86.10 $86.10 $87.39 $87.39 $87.39 $87.39
Report Type:
Units
$
Inventory [Units] Q1'19A Q2'19A Q3'19A Q4'19A Q1'20A Q2'20A Q3'20A Q4'20A Q1'21P Q2'21P Q3'21P Q4'21P
Beginning Inventory 0 0 6 2 0 0 114 414 248 648 148 73
+ Raw Material Received 427 458 562 600 600 750 1,000 1,000 1,000 900 1,825 3,550
+ Back Ordered 0 0 0 0 0 0 0 0 0 0 0 0
Available for Production 427 458 568 602 600 750 1,114 1,414 1,248 1,548 1,973 3,623
- Production 427 452 566 602 600 636 700 1,166 600 1,400 1,900 3,400
Ending Inventory 0 6 2 0 0 114 414 248 648 148 73 223
https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation

Production

Production
Report Type:
Production Capacity
Labor Force
Costs
Production Capacity Q1'19A Q2'19A Q3'19A Q4'19A Q1'20A Q2'20A Q3'20A Q4'20A Q1'21P Q2'21P Q3'21P Q4'21P
Production BaseRequested 427 452 566 602 600 636 700 1,166 600 1,400 1,900 3,400
Maximum Production [Units] 427 458 568 602 600 688 1,011 1,170 1,248 1,548 1,973 3,588
| Raw Material Constraint 427 458 568 602 600 750 1,114 1,414 1,248 1,548 1,973 3,623
| Total Line Capacity  500 500 750 750 750 1,250 1,250 1,500 1,500 2,250 3,000 3,750
| Labor Capacity  429 507 622 662 711 688 1,011 1,170 1,415 1,589 2,164 3,588
Production Achieved 427 452 566 602 600 636 700 1,166 600 1,400 1,900 3,400
Idle Production Time 0.00% 1.30% 0.40% 0.00% 0.00% 7.60% 30.80% 0.30% 51.90% 9.60% 3.70% 5.20%
Production Ratio 100.00% 98.70% 99.60% 100.00% 100.00% 92.40% 69.20% 99.70% 48.10% 90.40% 96.30% 94.80%
https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation

Finished Goods Inventory

Finished Goods Inventory
Current Plan Q1'19A Q2'19A Q3'19A Q4'19A Q1'20A Q2'20A Q3'20A Q4'20A Q1'21P Q2'21P Q3'21P Q4'21P
Total Market Demand [Units] 1,251 1,371 1,472 1,566 1,674 1,830 2,091 2,485 3,047 3,891 5,044 6,637
x Market Share [%] 33.70% 33.30% 33.30% 33.00% 33.40% 33.40% 33.40% 33.40% 33.00% 34.00% 33.00% 33.00%
Units Sold 422 457 490 517 559 611 698 829 1,005 1,322 1,665 2,190
Report Type:
Inventory 
Inventory [Units] Q1'19A Q2'19A Q3'19A Q4'19A Q1'20A Q2'20A Q3'20A Q4'20A Q1'21P Q2'21P Q3'21P Q4'21P
Beginning Inventory 0 5 0 76 161 202 227 229 566 161 239 474
+ Production Inventory 427 452 566 602 600 636 700 1,166 600 1,400 1,900 3,400
Available Inventory 427 457 566 678 761 838 927 1,395 1,166 1,561 2,139 3,874
- Sales Inventory 422 457 490 517 559 611 698 829 1,005 1,322 1,665 2,190
Ending Inventory 5 0 76 161 202 227 229 566 161 239 474 1,684
https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation https://ashford.tri-sim.com/Simulation