Qt$.$ Use the dats in the Excel File $($Mer$32$s$\_$Miterm.xlsx $-1$st sheet$)$ for this Guestion. A commercial batery has recorded demand for Cupcakes. So far, the restauraht has been selling the item for $10$ days and wants to forecast the demand on an upcorming day $($day $11).$

Time left $0,38,42$

a$.$ Construct both a natve $($nate forecast with stable time series$)$ and a moving avenge forecast. For the moving average forecast, average the previous five periods. For each technique, provide the forecasted values for day $11.$

b$.$ Calculate the Mean absolute deviation $($MAD$)$ for both naive $($naive forecast with stable time series$)$ and a moving average forecast based on previpus days' forecasts. c$.$ Based on results in b$,$ please state which forecasting technique $($naive$?$ or moving average?$)$ seems to work better for the data.

Q$2.$ Use the data in the Excel file $($MGT$325$ Miterm.xlsx $-2$nd sheet$)$ for this question. A manager must decide how many machines of a certain type to purchase. Each machine can process $500$ customers per day. One machine will result in a fixed cost of $$9,000$ per day, two machines will result in a fixed cost of $$18,000$ per day, ad three machines will result in a fixed cost of $$25,000$ per day. Variable costs will b $$15$ per customer, and revenue will be $$35$ per customer.

a$.$ Determine the break$-$even point for each range.

b$.$ If the estimated demand is $470$ to $550$ customers per day, how many machines

$\backslash$table$[[4,$A$,B,$c$],[1,$Periad,Demand,$],[2,1,45,],[3,2,26,],[4,3,27,],[5,4,23,],[6,5,22,],[7,6,28,],[8,7,29,],[9,8,20,],[10,9,14,],[11,10,18,],[12,11,m,],[13,,,],[14.,,,],[15,,,],[16,,,],[17,,,],[18,,,],[19,,,],[20,,,],[21,,,],[22,,,],[23,,,],[24,,,],[4,*,$Q$1$ Q$2,]]$

Ready