Home-Style Cookies tracks monthly sales by type of cookie, see the following table. Month Chocolate Chip (000 units) Peanut Butter (000 units) Filled (000 units) Feb. 19 15 10 Mar. 18 14 9 Apr. 15 11 8 May 20 16 11 Jun. 18 14 10 Jul. 22 18 12 Aug. 20 16 10 Sep. Create a line chart in Excel showing monthly sales by type of cookies (each type will have its own line); then, forecast September sales volume for chocolate chip cookies using each of the following: the naïve approach; a 5-month moving average; a weighted average using .60 for August, .30 for July, and .10 for June; and a linear trend equation.
Home-Style Cookies tracks monthly sales by type of cookie, see the following table.
| Month |
Chocolate Chip (000 units) |
Peanut Butter (000 units) |
Filled (000 units) |
|
Feb. |
19 |
15 |
10 |
|
Mar. |
18 |
14 |
9 |
|
Apr. |
15 |
11 |
8 |
|
May |
20 |
16 |
11 |
|
Jun. |
18 |
14 |
10 |
|
Jul. |
22 |
18 |
12 |
|
Aug. |
20 |
16 |
10 |
|
Sep. |
Create a line chart in Excel showing monthly sales by type of cookies (each type will have its own line); then,
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images
Please explain (show the work) how to enter the information in EXCEL to create the chart and please answer this last question: Of the naïve approach, 5-month moving average; a weighted average, which method seems most appropriate and least appropriate? Thank you so much!
by Bartleby Expert
