Question$\_1$

Question$\_2$

QUESTIONS

Q $1)$ A camping site owner keeps at least $30$ motovans and $20$ tents in his camping site to rent the campers one of these spaces depending on their choices. According to his accountant he should at least rent $60$ rental space in total consisting of tents and motovans. Each tent in average bringing him a cost average TRY $250$ for maintanence, and a motovan brings cost TRY $300.$ How many motovans and tents should be kept in camping site in order to keep costs as minimum? $($Use excel solver add in in order to find the optimal solution$)(35$ p$.)$ Use the attached excel file and put your results in it$.$

Q $2)$ Your objective is to apply and compare different time series forecasting techniques including moving averages, weighted moving averages and exponential smoothing. You will also evaluate the accuracy of these methods using the Mean Absolute Deviation $($MAD$).$ Use the attached excel file and put your results in it $($You will find the data in the second page of the excel file$).$

a$.$ Calculate the $3$ month moving average for the provided data

$(10$ p$.)$

b$.$ Calculate the $3$ month weighted moving average for the provided data $($give weights as $3-2-1$ from the current to oldest$)$

$(10$ p$.)$

c$.$ Apply exponential smoothing with two smoothing constant: $0\mathrm{.}2($Take the first month's forecast as $14\mathrm{.}00)$

$(10$ p$.)$

d$.$ Apply exponential smoothing with two smoothing constant: $0\mathrm{.}52($Take the first month's forecast as $14\mathrm{.}00)$

$(10$ p$.)$

e$.$ Calculate the mean absolute deviation $($MAD$)$ for each method.

$(10$ p$.)$

f$.$ Compare the MAD values and determine the acuracy of each forecasting method. Provide a brief analysis of which method provided the most accurate forecast and why $(15$ p$.)$

Make sure that when you submit your work it should include all the calculations in excel.

Question

Question$\_2$

$\backslash$table$[[,$observation$\_$d:$,\backslash$table$[[$Total Vehicle Sales, Millions$],[$of Units, Monthly$]],\backslash$table$[[$a$.)3$ month$],[$moving$],[$average$]],\backslash$table$[[$b$.)3$ month$],[$weightedmoving$],[$average $(3-2-1)$