Question: QUESTION 3 Use the following data to answer the questions below. Month 1 2 3 4 5 6 7 10 Actual Sales 106 102 131

QUESTION 3 Use the following data to answer the questions below. Month 1 2 3 4 5 6 7 10 Actual Sales 106 102 131 124 116 129 135 130 140 136 a. Use a four period moving average to compute a forecast for period 11. b. Use exponential smoothing with alpha-2 to compute forecasts for periods 2, 3 and 4. Assume that there is already a forecast of 100 for month 1. Suppose the process you are modelling is mostly constant with occasional peaks and valleys. Would an exponential model with alpha .1 or alpha3 be preferred? Why? d. If the best regression line is y= 105.67-3.5t, what is the expected monthly rate of increase in sales? What is the forecast for month 127 PLEASE SHOW YOUR WORK! For the toolbar, press ALT+F10 (PC or ALT-FN-F10 (Mac). BIS Paragraph v Arial 14px I XO Q !!! ill A *

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

We, the Supreme Court, categorically believe that pornographic films should be regulated. In particular, we believe that stemming the tide of commercialized obscenity serves legitimate state...

6 7 8 9 Use the following data to answer the questions below. Month 2 3 5 10 Actual Sales 106 102 131 124 116 129 135 130 140 136 a. Use a four period moving average to compute a forecast for period...

A student-run non-profit goods delivery company called InstaGoods, based in Tempe, AZ, provides goods delivery services to local communities with severe disabilities. The delivery service operates...

I need a 1400-1750 essay written for the case study. Prepare a 1,400- to 1,750-word response to the following case from the text:: Ch. 12: Mini-Case (p. 519), Parts a, b, c, d, & e only. I have...

44% D Thu 7:58 PM LE Q Search Sheet 8+ Share G 1 J K L M Excel File Edit View Insert Format Tools Data Window Help 31-Assignment Home Insert Draw Page Layout Formulas Data Review View C4 x fx A A B D...

I need these questions answered by 11 PM which is in 6 hours. I will give high rating and your help will be greatly appreciated. Business Finance BADM 310 Midterm - online 100 POINTS Instructions:...

a. Using Hatfield's data and its industry averages, how well run would you say Hatfield appears to be in comparison with other firms in its industry? What are its primary strengths and weaknesses? Be...

Sales Analysis A company's total sales {in millions of dollars} months from now are given by 8(t) = 0.086 + 0.58% + 28 + 3 Use this sales model to answer guestions 1-3 below. Question 1 7 pts Use the...

Problem Set 3 Use the data below to answer all of the questions. 1. (33 pts) Compute average federal funds rate over the time perios. 1.37 Compute the average value for the inflation Indexed security...

a) b) c) d) Use the following program to answer the questions: 1. //--------------------------------------------------------------------------- 2. // CSC160 Test Three - TestThree.cpp 3....

Question #2,3,4 Actual manufacturing overhead incurred during November was _____? Assume the predetermined overhead rate is $4.50 per direct labor hour. The total cost of Job 83-50 is __________ ?...

Review the two articles about bank failures and bank diversification that are found below this. Economic history assures us that the health of the banking industry is directly related to the health...

A customer discovers 60% of the total merchandise delivered from a retailer is damaged. The original purchase for all merchandise was $3,600. The customer decides to return 35% of the damaged...

Refer to the Why It Matters feature, "Situations Requiring a Modification to the Audit Report on ICFR." In which of the following situations would the auditor issue a qualified audit report on ICFR?...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...