Develop an S&OP plan by month for fiscal year $2024.$ Consider the use of several different production strategies. Which strategy do you recommend? An Excel file is provided for making these plans.

EXHIBIT $4$ Units of production and sales, fiscal year $2023.$Table Summary: Table has $7$ columns. Column $1$ titled Beginning Inventory lists months and years. Column $2$ reads Production and Sales. Columns $3$ to $6$ titled $18",20",20"$SP$,22"$SP and Overtime Hours respectively have numbers and blank spaces.

$18"20"20"$SP $22"$SP Overtime

Hours

Beginning Inventory $4,1203,1406,2503,100$

September $2022$ Production $3,0003,100$

Sales $210400180110$

October Production $3,4003,500$

Sales $600510500300$

November Production $3,0003,800$

Sales $1,010970860785$

December Production $4,4003,750$

Sales $1,2001,4201,0309301,000$

January $2023$ Production $4,0004,100$

Sales $1,4301,6801,1201,1201,500$

February Production $4,4003,500$

Sales $2,1402,2102,1801,8501,620$

March Production $3,0003,0002,000$

Sales $4,8705,1004,5603,2101,240$

April Production $2,0004,500$

Sales $5,1204,8505,1303,875$

May Production $3,0002,0002,000$

Sales $3,2103,3102,9802,650$

June Production $1,0002,0003,000$

Sales $1,4001,5001,320800$

July Production $2,0003,0002,000$

Sales $7109506801,010$

Aug. Production $2,0002,0002,000$

Sales $400600660960$

Total Production $21,00021,00022,20020,250$

FY $2019$ Sales $22,30023,50021,20017,600$

End inventory $(8/31/23)2,8206407,2505,750$

Nominal production rate$/$day $($one shift$)420400350300$