PLEASE SOLVE USING EXCEL. THANK YOU.

14.4. Rowley Apparel, manufacturer of the famous "Race-A-Rama" swimwear line, needs help planning production for next year. Demand for swimwear follows a seasonal pattern, as shown here. Given the following costs and demand forecasts, test these four strategies for meeting demand: (a) Level production with overtime and subcontracting, as needed, (b) level production with backorders as needed, (c) chase demand, and (d) 3000 units regular production from April through September and as much regular, overtime, and subcontracting production in the other months as needed to meet annual demand. Determine the cost of each strategy. Which strategy would you recommend? \begin{tabular}{|c|c|c|} \hline & Month & Demand Forecast \\ \hline & January & 1000 \\ \hline & February & 500 \\ \hline & March & 500 \\ \hline & April & 2000 \\ \hline & May & 3000 \\ \hline & June & 4000 \\ \hline & July & 5000 \\ \hline & August & 3000 \\ \hline & September & 1000 \\ \hline & October & 500 \\ \hline & November & 500 \\ \hline & December & 3000 \\ \hline Beginning wo & rkforce & 8 workers \\ \hline Subcontractin & g capacity & unlimited \\ \hline Overtime capa & acity & 2000 units/month \\ \hline Production rat & te per worker & 250 units/month \\ \hline Regular wage & rate & $15 per unit \\ \hline Overtime wag & ge rate & $25 per unit \\ \hline Subcontractin & g cost & $30 per unit \\ \hline Hiring cost & & $100 per worker \\ \hline Firing cost & & $200 per worker \\ \hline Holding cost & & $0.50 per unit/month \\ \hline Backordering & cost & $10 per unit/month \\ \hline \end{tabular}