Question: please hand write everything for wuestion 3, excel can be used on 4 3. A company has used three different methods to forecast sales for

please hand write everything for wuestion 3, excel can be used on 4

3. A company has used three different methods to forecast sales for the past five months Use MAD and MSE to evaluate the performance of the three methods, a) Which forecasting method performed best? Period 1 2 3 4 5 Actual 10 8 12 Method A 10 11 12 13 14 Method B 9 10 8 12 11 200 Method C 8 11 10 11 12 11 12 b) Which of these is actually the naive method? 4. Mop and Broom Manufacturing has tracked the number of units sold of their most popular mop over the past 24 months. This is shown. Month Sales Month Sales 1 239 9 310 2 248 10 335 3 256 11 348 4 260 12 353 5 271 13 355 6 280 14 368 7 295 15 379 8 305 16 358 use excel. a) Use Excel to find linear trend line equation. b) develop a forecast for the next period, month 25. Month 17 18 19 20 21 22 23 24 Sales 369 378 367 383 394 393 405 412 on * Intercent. A x variable is B y =-21231.1+ + 403x125)

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!

can i get a solution to this question please. Value: Document (include your file name) 15% of final grade How to complete: 1. Read the following Anniversary Party scheduling problem: As the project...

answer in excel with the correct formulas please 3. A company has used three different methods to forecast sales for the past five months. Use MAD and MSE to evaluate the performance of the three...

10.4. Sharon Johnson, sales manager for the Alvarez-Baines Company, is trying to choose between two methods for forecasting sales that she has been using during the past five months. During these...

pleases provide evaluate options for each of the issues in this case. inbox?projector=1 December 2020 Turn off Bill Pennycook, co-founder and chief executive officer (CEO) of Pennycook Power Boats,...

Background - Federal Express FedEx Corporation is a $20 billion market leader in transportation, information, and logistics solutions, providing strategic direction to the five main operating...

M3 Group Assignment Instructions Complete the Assignment, name it as GroupXX_Assign3.xls (where XX is your Group Name), and upload and submit to the instructor through Dropbox. Do not enter anything...

please do not use excel, i cannot for this assignment. all has to be hand written. 3. A company has used three different methods to forecast sales for the past five months. Use MAD and MSE to...

(Need help putting this question on excel. and what formulas to use) Excel worksheet containing all four scenarios for JC Company (Exhibits 19.3 to 19.5)., it is required that you use formulas to...

A city with a population of 200,000 people operates a 20:0 10 6 gal/day wastewater treatment plant. For every million gallons of wastewater treated, 1875 lbm of solids are generated, with 75% of the...

Describe the reasons for decline of labour unions and reasons behind their hope for renewal.

If you have two insurance policies on the same property, which of these explains how the two insurance companies will share the loss? Group of answer choices Right of subrogation Personal property...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...