please add any formulas needed and what cell to add that formula Inventory Control

You must do the necessary calculations in the answer cells. Simply providing a number in the answer cell will not receive any credit.

When look at the answer cell, I want to see a number, when I click on the cell I want to see the excel formula

Part $1$: Enter the requested information into the green cells. Round off to $1$ decimal point.