Construct an inventory status records for all parts into an excel file.

Regular:

Part A $=5$

Part B $=7$

Part C $=10$

Part D $=3$

Deluxe:

Part A $=5$

Part B $=7$

Part C $=8$

Part D $=3$

Part E $=13$

Part A $-->$ Part F $=3$; Part G $=7$

Part B $-->$ Part F $=6$; Part H $=25$

Part C $-->$ Part G $=12$; Part H $=10$; Part I $=5$

Part D $-->$ Part F $=12$; Part I $=3$

Part E $-->$ Part F $=4$; Part G $=9$; Part H $=10$; Part I $=5$

Yield Finite Capacity

Regular $94\%250$

Deluxe $96\%225$

Part A $83\%1200$

Part B $92\%700$

Part C $73\%500$

Part D $99\%400$

Part E $94\%900$

Part F $82\%5,000$

Part G $80\%2,000$

Part H $93\%3,500$

Part I $94\%1,500$

MPS $1,2,3,4,5,6,7,8,9,10,11,12$

Regular: $6=300$; $7=300$; $8=300$; $9=300$; $10=300$; $11=300$; $12=300$

Deluxe: $7=250$; $8=250$; $9=250$; $10=250$; $11=250$; $12=250$

Inventory status record for regular

LT $=1$ week

Gross Requirements

Scheduled Receipts $2=100$; $4=100$; $6=100$; $8=100$; $10=100$; $12=100$

On hand $(500)$

Net Requirements

Planned order Releases

Inventory Status record for Deluxe

LT$=2$ weeks

Gross Requirements

Scheduled Receipts $4=300$

On Hand $(70)$

Net Requirements

Planned Order Releases

Inventory Status Record for Part A

LT $=2$ weeks

Gross Requirements

Scheduled Receipts $1$ through $10=500$

On Hand $(50)$

Net Requirements

Planned Order Releases

Inventory Status Record for Part B

LT $=3$ weeks

Gross Requirements

Scheduled Receipts $2=200$; $5=900$; $6=0$; $7=2200$; $8=4000$; $9=1500$; $10=2000$; $11=2800$

On Hand $(100)$

Net Requirements

Planned Order Releases

Inventory Status Record for Part C

LT $=1$ weeks

Gross Requirements

Scheduled Receipts $2,4=500$; $6=100$; $7=3000$; $8=4000$; $9=3500$; $10,11=4000$

On Hand $(500)$

Net Requirements

Planned Order Releases

Inventory Status Record for Part D

LT $=2$ weeks

Gross Requirements

Scheduled Receipts $2,4=500$; $6=100$; $8=1000$; $9=2000$; $11=200$

On Hand $(50)$

Net Requirements

Planned Order Releases

Inventory Status Record for Part E

LT $=2$ weeks

Gross Requirements

Scheduled Receipts $2=500$; $4=1000$; $6=1000$; $7=3000$; $8=1000$; $9,10=2000$

On Hand $(50)$

Net Requirements

Planned Order Releases

Inventory Status Record for Part F

LT $=1$ weeks

Gross Requirements

Scheduled Receipts $2,3,4=5000$; $5=10,000$; $6,7,8=15,000$

On Hand $(3000)$

Net Requirements

Planned Order Releases

Inventory Status Record for Part G

LT $=2$ weeks

Gross Requirements

Scheduled Receipts $2=5000$; $4=15,000$; $5,6,7,8,9=20,000$

On Hand $(6000)$

Net Requirements

Planned Order Releases

Inventory Status Record for Part H

LT $=1$ weeks

Gross Requirements

Scheduled Receipts $2=500$; $4,5,6,7,8=28,000$

On Hand $(20000)$

Net Requirements

Planned Order Releases

Inventory Status Record for Part I

LT $=1$ weeks

Gross Requirements

Scheduled Receipts $2=500$; $4,5,6,7,8,9=7000$

On Hand $(50)$

Net Requirements

Planned Order Releases

Please put the following information into an excel sheet Excel