Part B: Complete the MRP spreadsheets $-$ Fill the excel sheet

Part B: MRP Spreadsheets

Skate Board On Week Lead Time $1$

Hand $123456$ Lot Size $400$

Gross Requirements $03002503004000$ Safety Stock $0$

Scheduled Receipts On Hand $05$

Projected Available Inventory $05$ Safety Lead Time $0$

Planned Order Release

Board On Week Lead Time $1$

Hand $123456$ Lot Size $500$

Gross Requirements Safety Stock $0$

Scheduled Receipts $300$ On Hand $550$

Projected Available Inventory Safety Lead Time $0$

Planned Order Release

Wheel Assembly On Week Lead Time $1$

Hand $123456$ Lot Size $1000$

Gross Requirements Safety Stock $0$

Scheduled Receipts $100$ On Hand $950$

Projected Available Inventory Safety Lead Time $0$

Planned Order Release

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

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