Question: boss has assigned you a forecasting project at work. She wants you to forecast demand for the company nd has given you a file with

boss has assigned you a forecasting project at work. She wants you to forecast demand for the company nd has given you a file with data, which is on the worksheets of the spreadsheet for you convenience.She believes future sales are related to either past sales or two associated variables: Complaint Costs and Advertising Impressions. You have been instrumental in creating your company's online strategy and recommended several process improvements that are working well.She asks you to develop sales forecasts for the organization and you show your OM prowess stating that vou will:1) Perform sales forecasts using the following methods...a)b)Moving average (use a four period MA)Weighted moving average (five period WMA with weights of: 1,2,3,4,5 Use these weights onlv.)c) d)Exponential smoothing (use a =0.35)Multiple regression using Ad Impressions, and Complaint Costs as the predictors of sales.\table[[,Sales ($1000),\table[[Ad Impressions],[(thousands)]],\table[[Complaint Costs],[($1000)
 boss has assigned you a forecasting project at work. She wants

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 Finance Questions!