Production Planning for Supply Chain Part B: MRP Spreadsheets

Assignment $3-$ Material Requirements Planning $-$ Winter $2021$

Skate Board On Week Lead Time $1$

Name: Student # Hand $123456$ Lot Size $400$

Gross Requirements $03002503004000$ Safety Stock $0$

ROLL INC makes skate boards. Scheduled Receipts On Hand $05$

In the final assembly stage the following are required to complete $1$ skate board: Projected Available Inventory $05$ Safety Lead Time $0$

$*$ Skate board $-$ quantity $1($is comprised of$)$ Planned Order Release

$*$ Board $-$ quantity of $1$

$*$ Bolts $-$ quantity of $4$ Board On Week Lead Time $1$

$*$ Wheel assembly $-$ quantity of $2$ Hand $123456$ Lot Size $500$

$*$ Each wheel assembly is comprised of: Gross Requirements Safety Stock $0$

$*$ Wheel$-$ quantity of $2$ Scheduled Receipts $300$ On Hand $550$

$*$ Shaft assembly $-$ quantity of $1$ Projected Available Inventory Safety Lead Time $0$

$*$ Bolts $($same as above$)-$ quantity of $2$ Planned Order Release

Part A: Complete the Product Structure Diagram for the Skateboard Wheel Assembly On Week Lead Time $1$

Hand $123456$ Lot Size $1000$

Part B: Complete the MRP spreadsheets $($the on hand inventory for the skateboard is the last $2$ digits of your student Number, xxx xxx xAB$).$ Gross Requirements Safety Stock $0$

Scheduled Receipts $100$ On Hand $950$

Projected Available Inventory Safety Lead Time $0$

Planned Order Release

Part A: Product Structure Diagram

Wheel On Week Lead Time $1$

Hand $123456$ Lot Size $2000$

Gross Requirements Safety Stock $0$

Scheduled Receipts $2000$ On Hand $500$

Projected Available Inventory Safety Lead Time $0$

Planned Order Release

Shaft Assembly On Week Lead Time $1$

Hand $123456$ Lot Size $700$

Gross Requirements Safety Stock $100$

Scheduled Receipts $500600$ On Hand $650$

Projected Available Inventory Safety Lead Time $0$

Planned Order Release

Bolts On Week Lead Time $1$

Hand $123456$ Lot Size $5000$

Gross Requirements Safety Stock $0$

Scheduled Receipts $5000$ On Hand $4800$

Projected Available Inventory Safety Lead Time $0$

Planned Order Release