Description
Download the instructions and start file. Also download support file(s), if available. Complete the project. Click Continue.
You are about to download project files that must be completed using a PC. To complete the project using a Mac, download the files from a Mac
Explanation & Answer
The solution and the report are attached.Final grade is 100%, please confirm.
Author:
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file
from the SAM website.
New Perspectives Excel 2019 | Module 10: SAM Project 1b
Corvallis Group Restore
ANALYZE DATA WITH POWER TOOLS
Haolun Miao
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file
from the SAM website.
py of the file
Sales History
Year
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
Business Year
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Sales
105234
115560
118424
120306
127125
129448
135725
137569
137725
139504
138992
141031
142669
146714
20200417000148np_ex19_10b_haolunmiao_2 Sales History 4/17/2020
Month
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jun
Sales per Month
$12,023
$9,429
$9,446
$15,122
$14,007
$9,935
$10,331
$9,943
$12,146
$12,312
$15,586
$16,435
Forecast(Sales per Month)Lower Confidence Bound(Sales per Month)
$25,000
$20,000
$15,000
$10,000
$5,000
$0
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sales per Month
Forecast(Sales per Month)
Lower Confidence Bound(Sales per Month)
Upper Confidence Bound(Sa
$16,435
$14,786
$15,116
$15,447
$15,777
$16,108
$16,438
$16,758
$16,435
$10,046
$10,338
$10,630
$10,922
$11,214
$11,505
$11,786
Upper Confidence Bound(Sales per Month)
Dec
Jan
Feb
Mar
Apr
May
Jun
Jun
Forecast(Sales per Month)
Upper Confidence Bound(Sales per Month)
$16,435
$19,525
$19,894
$20,263
$20,632
$21,001
$21,371
$21,729
Monthly Sales: 2021
Month
Feb
Mar
Jun
Aug
Jul
Jan
Sep
Oct
May
Apr
Nov
Dec
Sales per Month
$9,429
$9,446
$9,935
$9,943
$10,331
$12,023
$12,146
$12,312
$14,007
$15,122
$15,586
$16,435
Items Sold by Material
Fabric
463
Glass
272
Metal
384
Plastic
298
Wood
263
Sales per Month
$18,000
$16,000
$14,000
$12,000
$10,000
$8,000
$6,000
$4,000
$2,000
$0
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
20200417000148np_ex19_10b_haolunmiao_2 Monthly Sales 4/17/2020
Products Sold by Material
Products Sold
Product Material
Fabric
Glass
Metal
Plastic
Wood
Grand Total
Locations
Beaverton BremertonCorvallis Eugene Seattle Grand Total
97
83
112
98
73
463
66
66
63
38
39
272
81
61
82
68
92
384
64
55
81
60
38
298
57
64
62
43
37
263
365
329
400
307
279
1680
OrderDate
All Periods
MONTHS
2021
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
Products Sold
100%
90%
80%
SiteCity
70%
Seattle
60%
50%
Eugene
40%
Corvallis
30%
Bremerton
20%
Beaverton
10%
0%
Fabric
Material
Glass
Metal
Plastic
Wood
Products Sold by Type
Sum of ItemQty Column Labels
Row Labels
Housewares
Gra...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
The Book Thief
by Markus Zusak
Tess of the DUrbervilles
by Thomas Hardy
Dandelion Wine
by Ray Bradbury
Cant Hurt Me - Master Your Mind and Defy the Odds
by David Goggins
Flowers For Algernon
by Alice Walker
Girl Stop Apologizing
by Rachel Hollis
The Joy Luck Club
by Amy Tan
Persuasion
by Jane Austen