Solve it by excel for me

the second pic is example of my teacher, but idk how to apply, can you use it to solve the question ?

QUESTION 5 ANSWER (10 POINTS): a) Develop a Level Output Plan and identify the total short units in each period and overall in production cycle b) Develop Chase Output Plan(s) to address the shortage identified in the Level Output Plan. c) Recommend the most cost-effective plan