Description
You are creating a workbook that will analyze sales data for a regional bargains store that sells several categories of items. Follow the steps below to produce the results shown in the figures at the end of this document.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
let me know if you need any edits done.
Sunshine Bargain Center
Author
Date
Purpose
Michael Hwanampe
6/24/2019
Analyzing sales data for Sunshine
Bargain Center
Sunshine Bargain Center
Product Group
Automotive
Automotive
Automotive
Automotive
Automotive
Automotive
Automotive
Automotive
Automotive
Automotive
Automotive
Automotive
Automotive
Automotive
Automotive
Automotive
Automotive
Automotive
Automotive
Automotive
Automotive
Automotive
Automotive
Automotive
Electronics
Electronics
Electronics
Electronics
Electronics
Electronics
Electronics
Electronics
Electronics
Electronics
Electronics
Electronics
Electronics
Electronics
Electronics
Electronics
Electronics
Electronics
Electronics
Region
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Month
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Year
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2016
2016
2016
2016
2016
2016
2016
2016
2016
2016
2016
2016
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2016
2016
2016
2016
2016
2016
2016
Sales Amount
$
95,387.00
$
90,310.00
$
30,649.00
$
292.00
$
33,340.00
$
82,557.00
$
11,335.00
$
32,575.00
$
97,203.00
$
72,752.00
$
54,882.00
$
80,177.00
$
74,621.00
$
1,825.00
$
86,612.00
$
34,540.00
$
67,957.00
$
77,728.00
$
14,281.00
$
98,358.00
$
28,158.00
$
67,126.00
$
45,419.00
$
5,729.00
$
58,680.00
$
13,163.00
$
12,069.00
$
34,897.00
$
74,951.00
$
93,274.00
$
9,220.00
$
73,577.00
$
49,936.00
$
41,392.00
$
7,745.00
$
41,774.00
$
28,509.00
$
24,914.00
$
7,164.00
$
37,389.00
$
72,352.00
$
10,952.00
$
95,985.00
Sales Tax
$ 7,154.03
$ 6,773.25
$ 2,298.68
$
21.90
$ 2,500.50
$ 6,191.78
$ 850.13
$ 2,443.13
$ 7,290.23
$ 5,456.40
$ 4,116.15
$ 6,013.28
$ 5,596.58
$ 136.88
$ 6,495.90
$ 2,590.50
$ 5,096.78
$ 5,829.60
$ 1,071.08
$ 7,376.85
$ 2,111.85
$ 5,034.45
$ 3,406.43
$ 429.68
$ 4,401.00
$ 987.23
$ 905.18
$ 2,617.28
$ 5,621.33
$ 6,995.55
$ 691.50
$ 5,518.28
$ 3,745.20
$ 3,104.40
$ 580.88
$ 3,133.05
$ 2,138.18
$ 1,868.55
$
537.30
$ 2,804.18
$ 5,426.40
$ 821.40
$ 7,198.88
Disposal Fee
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
-
Sunshine Bargain Center
Product Group
Electronics
Electronics
Electronics
Electronics
Electronics
Gardening
Gardening
Gardening
Gardening
Gardening
Gardening
Gardening
Gardening
Gardening
Gardening
Gardening
Gardening
Gardening
Gardening
Gardening
Gardening
Gardening
Gardening
Gardening
Gardening
Gardening
Gardening
Gardening
Gardening
Housewares
Housewares
Housewares
Housewares
Housewares
Housewares
Housewares
Housewares
Housewares
Housewares
Housewares
Housewares
Housewares
Housewares
Region
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Oregon
Month
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Year
2016
2016
2016
2016
2016
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2016
2016
2016
2016
2016
2016
2016
2016
2016
2016
2016
2016
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2015
2016
2016
Sales Amount
$
61,790.00
$
35,272.00
$
71,298.00
$
81,092.00
$
63,382.00
$
92,278.00
$
63,723.00
$
15,616.00
$
28,281.00
$
43,694.00
$
4,457.00
$
83,193.00
$
18,312.00
$
46,462.00
$
78,372.00
$
44,218.00
$
37,113.00
$
33,490.00
$
22,405.00
$
90,890.00
$
84,284.00
$
57,828.00
$
15,975.00
$
5,396.00
$
11,288.00
$
95,795.00
$
9,898.00
$
26,091.00
$
12,965.00
$
76,984.00
$
71,295.00
$
10,311.00
$
10,037.00
$
89,337.00
$
16,252.00
$
25,091.00
$
14,164.00
$
65,010.00
$
14,233.00
$
29,180.00
$
43,474.00
$
8,621.00
$
61,521.00
Sales Tax
$ 4,634.25
$ 2,645.40
$ 5,347.35
$ 6,081.90
$ 4,753.65
$ 6,920.85
$ 4,779.23
$ 1,171.20
$ 2,121.08
$ 3,277.05
$ 334.28
$ 6,239.48
$ 1,373.40...