Inventory Management for Operations Management

profilejaeana
RS-T3-InventoryMangement-Student.xlsx
Home>Business & Finance homework help>Operations Management homework help>Inventory Management for Operations Management

A-Topic 3 Part 1&2

Engine Assembly Master Schedule
Week 1 2 3 4 5 6 7 8 9 10 11 12
Quantity
Gear box requirements
Week 1 2 3 4 5 6 7 8 9 10 11 12
Gross Requirements 0 0 0 0 0 0 0 0 0 0 0 0 Since Gear box 1 X Engine Assembly, use Master Engine Assembly Qty
Scheduled Receipts 5 From Problem
Projected Available Balance 17 17 0 0 0 0 0 0 0 0 0 0 Cell B10, Beg Balance of 17- Gross Requirement of 15 Cell C10 Carryover
Net Requirements Net Req=Gross Req-Projected Available Balance from prior week
Planned Order Receipt Same as row above
Planned Order Release
From E12 for 2 Weeks Lead Time
Input shaft requirements
Week 1 2 3 4 5 6 7 8 9 10 11 12
Gross Requirements 10 20 0 0 0 0 0 0 0 Since Input Shaft is 2 X Gear Box, then each week is 2 X Row 13
Scheduled Receipts 37 From Problem
Projected Available Balance 30 47 47 47 0 0 0 0 0 0 0 0 Cell B22, Beg Balance of 40- Gross requirement of 10 Week 5 and beyond 0 since no scheduled receipts
Net Requirements Net Req=Gross Req-Projected Available Balance from prior week
Planned Order Receipt Same as row above
Planned Order Release Planned Order Receipt from 3 weeks in future
From F24 for 3 Weeks Lead Time
Part 2
Gear Box
Given Information Number of orders ( count cells with values for planned order release)
Setup per order= $90.00 Set-up Costs=# of Orders X Setup Costs
Inventory Carrying Cost per unit per period $2.00 (8*90)
Inventory (2+2)*Inventory Carrying Cost
Total $0.00
Input Shaft
Given Information
Setup per order= $45.00 Setup Costs=5 orders*45
Inventory Carrying Cost per unit per period $1.00 Inventory=(30+32+32+2)*1
Total $0.00
Total Cost $0.00

A-Topic 3 Part 3

Engine Assembly Master Schedule
Week 1 2 3 4 5 6 7 8 9 10 11 12
Quantity
Lead Time 2
Gear box requirements
Week 1 2 3 4 5 6 7 8 9 10 11 12
Gross Requirements 0 0 0 0 0 0 0 0 0 0 0 0 Since Gear box 1 X Engine Assembly, use Master Engine Assembly Qty
Scheduled Receipts 5 From Problem
Projected Available Balance 17 22 0 0 0 0 0 0 0 0 0 0 Cell B10, Beg Balance of 17- Gross Requirement of 15 Next cell, Gross Req-Scheduled Receipts
Net Requirements Net Req=Gross Req-Projected Available Balance from prior week
Planned Order Receipt Planned order receipt=projected available balance +net requirements
Planned Order Release Stagger Order Releases to reduce Costs
From E12 for 2 Weeks Lead Time
Input shaft requirements
Week 1 2 3 4 5 6 7 8 9 10 11 12
Gross Requirements 30 0 0 0 0 0 0 0 Since Input Shaft is 2 X Gear Box, then each week is 2 X Row 13
Scheduled Receipts 22 From Problem
Projected Available Balance 10 32 32 0 0 0 0 0 0 0 0 0 Cell B22, Beg Balance of 40- Gross requirement of 10 Week 4 and beyond 0 since no scheduled receipts
Net Requirements Net Req=Gross Req-Projected Available Balance from prior week
Planned Order Receipt
Planned Order Release Planned Order Receipt from 3 weeks in future
From F24 for 3 Weeks Lead Time
Part 2
Gear Box
Given Information Number of orders ( count cells with values for planned order release)
Setup per order= $90.00 Set-up Costs=# of Orders X Setup Costs
Inventory Carrying Cost per unit per period $2.00 3*90)
Inventory (88)*Inventory Carrying Cost sum of projected available balance
Total $0.00
Input Shaft
Given Information
Setup per order= $45.00 Setup Costs=2 orders*45
Inventory Carrying Cost per unit per period $1.00 Inventory=(74)*1
Total $0.00
Total Cost $0.00