Sales Summary by Region and Store Size
Region
Number
1
2
3
4
Region Name
Number of
Stores
Northeast
South
Midwest
West
Region
Number
4
Store Size
(Square Feet)
10,000
15,000
20,000
25,000
Sales This
Year
10
4
6
4
$
$
$
$
4,997,134
2,168,316
3,020,542
1,273,208
Sales Last
Year
$
$
$
$
4,649,043
2,057,973
2,895,491
1,336,993
Change in
Sales
7.49%
5.36%
4.32%
-4.77%
Type the region number you wish to analyze in cell B9
West
Number of
Stores
1
1
1
1
Sales
This Sales
Last
Year
Year
$ 273,940 $ 301,033
$ 318,111 $ 318,111
$ 229,880 $ 252,615
$ 451,276 $ 465,233
Change
-9.00%
0.00%
-9.00%
-3.00%
Saless
GrowthTarget
10.0%
4.0%
6.0%
4.0%
Diff to Target
-2.51%
1.36%
-1.68%
-8.77%
Awais Ahmad
Reg. No. FA20-BBA-283
Section: C
Course Title: EXCEL LAB
Submitted To: Humera Faisal