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 executive has decided to replan the entire schedule in Q$2.$

Additional Information.

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 prevlous quarter's $3$ weeks moving average as

baseline for $Q,2.$

III$)$ The productlon 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 approprlate

table that indicates:

Inventory on hand.

Supply$-$demand schedule.

Net requirement

Required safety stock.

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

known as Master Production Schedule. Comment on your schedule.Question $2$

Production planning requires responsive supply replenishment to demand

changes. Thls is especially acute in manufacturing or service Industry adopting

bulld to stock business model. It's a challenging task to analyze demand pattems

and strateglze supply schedules.

The following scenarlo Indicates a supply$-$demand situation for company's bulld

to stock business model. Your task is to analyze and evaluate the current

demand$-$supply. You will propose a solution based on your analysls.

a$)$ Based on the situation below, analyze the demand pattem. You may use $3$

weeks moving average and visualize Into line graphs. Comment on the trend.