solve using excel please

Vered works in the planning department of Preston Brass Company, which manufactures brass bathroom and kitchen fixtures. She has derived the following MPS for PBC's Model 317 'for the exext The company has customer orders of 60,40,50,15, and 10 units in week 1,2,3,4, and 5 , respectively. A production lot size is 120 units, and on-hand stock is 10 units. a. Complete the following time-phased record: \begin{tabular}{|l|c|c|c|c|c|c|} \hline & \multicolumn{7}{|c|}{ Week } \\ \hline Model 317 & 1 & 2 & 3 & 4 & 5 & 6 \\ \hline Forecast & 65 & 55 & 40 & 25 & 20 & 30 \\ \hline Orders & & & & & & \\ \hline Available & & & & & & \\ \hline ATP & & & & & & \\ \hline MPS & & & & & & \\ \hline \end{tabular} b. There are additional orders. Update the MPS time-phased record. At this time, the company requires a safety stock of 15 units. Week 2: 10 units Week 3:5 units Week 4:5 units Week 5: 210 units c. When is thie earliest time the company can promise an additional order for 80 units