New Perspectives Excel 2019 | Module 10: SAM Project 1a
Lighting Designs
ANALYZE DATA WITH POWER TOOLS
Author: Jinrui Dong
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.
Lighting Designs: Sales Summary
Year Business Year Sales ($mil)
2000 1 1.246
2001 2 2.197
2002 3 4.175
2003 4 5.221
2004 5 6.065
2005 6 5.124
2006 7 6.097
2007 8 6.214
2008 9 6.312
2009 10 7.007
2010 11 7.021
2011 12 6.927
2012 13 6.908
2013 14 7.248
2014 15 7.448
2015 16 7.239
2016 17 8.787
2017 18 8.742
2018 19 8.739
2019 20 9.119
2020 21 9.224
2021 22 10.081
690706764.xlsx Sales Summary 09/12/2023
Month Sales per Month Forecast(Sales per Month) Lower Confidence Bound(Sales per Month)
Jan $92,198 $300,000
Feb $86,470 $250,000
Mar $99,411
$200,000
Apr $145,722
$150,000
May $130,071
$100,000
Jun $173,935
$50,000
Jul $156,331
$0
Aug $172,943 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan
Sep $127,646
Sales per Month Forecast(Sales per Month)
Oct $153,012
Lower Confidence Bound(Sales per Month) Upper Confidence Bound(S
Nov $199,586
Dec $184,035 $184,035 $184,035
Jan $194,374 $153,978
Feb $202,904 $162,508
Mar $211,434 $171,037
Apr $219,964 $179,567
May $228,493 $188,096
Jun $237,023 $196,625
Jun $245,269 $204,869
Upper Confidence Bound(Sales per Month)
Oct Nov Dec Jan Feb Mar Apr May Jun
Forecast(Sales per Month)
Upper Confidence Bound(Sales per Month)
$184,035
$234,770
$243,300
$251,830
$260,360
$268,891
$277,422
$285,669
Lighting Designs: Sales 2021
Month Sales per Month
Sep $127,646 Sales per Month
Oct $153,012
$250,000
Nov $199,586
Dec $184,035
Apr $145,722 $200,000
May $130,071
Jun $173,935
Jul $156,331 $150,000
Aug $172,943
Jan $92,198
Feb $86,470 $100,000
Mar $99,411
$50,000
$0
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
690706764.xlsx Previous Year 09/12/2023
Lighting Designs: Products Sold by Store
Products Sold Stores
100%
Lighting Products Bellevue Bremerton Redmond Seattle Tacoma Grand Total
90%
Ceiling 102 133 86 114 149 584
80%
Commercial 79 110 94 125 100 508
70%
Lamps 79 77 110 134 95 495
Novelty 9 13 4 21 22 69 60%
Outdoor 14 22 29 27 22 114 50%
Wall 49 43 39 41 48 220 40%
Grand Total 332 398 362 462 436 1990 30%
20%
10%
Timeline: Works in Excel 2013 or higher. Do not move or resize.
0%
l ps
ng cia elt
y
ili er m
ov
Ce m La N
m
Co
Tacoma
Seattle
Redmond
Bremerton
Stores Bellevue
l ps y or all tal
cia elt do To
er La
m
ov u t W
m
m N O nd
ra
Co G
Lighting Designs: Products Sold by Manufacturer
Sum of ItemQty Column Labels
Row Labels Commercial Grand Total
A&R Global 67 67
Barton & Brooks 22 22
Grand Total
Curtis 53 53
Eastside Security 53 53 Midbrook Supplies
Ecolighting 72 72
Kahvee 18 18 Lightronics
Khalil & Sons 91 91
Levelite
Levelite 60 60
Lightronics 18 18 Khalil & Sons
Midbrook Supplies 54 54
Grand Total 508 508 Kahvee
Ecolighting
Eastside Security
Curtis
Barton & Brooks
A&R Global
0 100
This shape represents a
slicer. Slicers are suppo
in Excel 2010 or later.
If the shape was modifi
in an earlier version of
Excel, or if the workboo
was saved in Excel 200
earlier, the slicer cannot
used.
Commercial
Grand Total
Midbrook Supplies
Lightronics
Levelite
Khalil & Sons
Column Labels Com-
mercial
Kahvee
Ecolighting
Eastside Security
Curtis
Barton & Brooks
A&R Global
0 100 200 300 400 500 600
This shape represents a
slicer. Slicers are supported
in Excel 2010 or later.
If the shape was modified
in an earlier version of
Excel, or if the workbook
was saved in Excel 2003 or
earlier, the slicer cannot be
used.
