Consider the following time series data. week 1 2 3 4 5 6value 18 13 16 11 17 14a. construct a time series plot. what type of pattern exists in the data? b. develop a three-week moving average for this time series. compute mse and a forecast for week 7.c. use a 5 0.2 to compute the exponential smoothing values for the time series. compute mse and a forecast for week 7.d. compare the three-week moving average forecast with the exponential smoothingforecast using a 5 0.2. which appears to provide the better forecast based on mse? explain. e. use trial and error to find a value of the exponential smoothing coefficient a thatresults in a smaller mse than what you calculated for a 5 0.2.

The direct labor budget of yuvwell corporation for the upcoming fiscal year contains the following details concerning budgeted direct labor-hours: 1st quarter 2nd quarter 3rd quarter 4th quarterbudgeted direct labor-hours 11,200 9,800 10,100 10,900the company uses direct labor-hours as its overhead allocation base. the variable portion of its predetermined manufacturing overhead rate is $6.00 per direct labor-hour and its total fixed manufacturing overhead is $80,000 per quarter. the only noncash item included in fixed manufacturing overhead is depreciation, which is $20,000 per quarter. required: 1. prepare the company’s manufacturing overhead budget for the upcoming fiscal year.2. compute the company’s predetermined overhead rate (including both variable and fixed manufacturing overhead) for the upcoming fiscal year.