Question $2$

$10$ pts

Resource Planning

Complete the Projected on Hand Inventory and Planned Order Release rows.

$\backslash$table$[[$Item A$,1,2,3,4,5],[$Gross Requirements,$20,40,35,55,30],[$Scheduled Receipts,$15,20,,,],[\backslash$table$[[$Projected on Hand Inventory$],[35]],,,,,],[$Planned Order Releases,,,,,$]]$

$Q=25,LT=2$;$SS=10$

Upload the question with your answer in a file, acceptable file formats are: Excel ${?}^{}$ and Word ${?}^{}.$Resource Planning

Complete the Projected on Hand Inventory and Planned Order Release rows.

Item A $12345$

Gross Requirements $2040355530$

Scheduled Receipts $1520$

Projected on Hand Inventory $|35$

Planned Order Releases

Q $=25,$ LT $=2$; SS $=10$