a$)$ Based on the situation below, analyze the demand pattern. You may use $3$ weeks moving average and visualize into line graphs. Comment on the trend.

b$)$Based on the Q$1$ demand$-$supply schedule, comment if the production managed to fully support all demand timely. You may restructure the table.

c$)$The production executivehas decidedto replan the entire schedule in Q$2.$ Additional information.

i$)$Assuming that by end W$13,$ after realizing the production hiccups, the production has ordered additional $50$ units to clear backlog.

ii$)$Demand forecasting can never be accurate. Hence the production executive used the previous quarter$$s $3$ weeks moving average as baseline for Q$2.$

iii$)$The production planner intends to keep weekly $5$ units of safety stock.

iv$)$Demand for Q$2$ is based on the schedule below

How should the production executive analyze the production schedule and

replan accordingly. You may tabulate your demand$-$supply into appropriate

table that indicates:

Inventory on hand.

Supply$-$demand schedule.

Net requirement

Required safety stock.

The output should be a replan schedule into an appropriate table commonly

known as Master Production Schedule. Comment on your schedule.