University of Central Florida Module 10 SAM Project B Excel Worksheet

User Generated

unbyhazvnb

Business Finance

University of Central Florida

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

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
Very useful material for studying!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags