Fill Out the Following MRP Record and Calculate the Inventory

Essay

Fill out the following MRP record and calculate the inventory holding cost using end inventory values.The lot size is a multiple of 500 units and the holding cost is $20 per unit per period.
$$\begin{array} { | c | c | c | c | l | } \hline \text { Periods } & 1 & 2 & 3 & 4 \\\hline \text { Demands } & 1000 & 350 & 500 & 800 \\\hline \begin{array} { c } \text { Projected } \\\text { Availability }\end{array} & & & & \\\hline \begin{array} { c } \text { Net } \\\text { Requirements }\end{array} & & & & \\\hline\end{array}$$