Report
Brian_1234
M1StoreRegionSalesDatabase--ExcelTemplate.xlsxSheet1
| Row Labels | Sum of Weekly Revenue | Sum of Weekly Revenue | Column Labels | ||||
| East | $ 628,831.30 | Oct | Nov | Dec | Grand Total | ||
| South | $ 334,301.55 | ||||||
| North | $ 300,303.75 | Row Labels | |||||
| Grand Total | $ 1,263,436.60 | 101 Keyboard | $ 7,241.85 | $ 7,660.80 | $ 8,179.50 | $ 23,082.15 | |
| 17" Monitor | $ 62,975.00 | $ 75,799.00 | $ 55,647.00 | $ 194,421.00 | |||
| Row Labels | Sum of Weekly Revenue | Desktop CPU | $ 333,180.40 | $ 345,079.70 | $ 359,528.85 | $ 1,037,788.95 | |
| 6 | $ 300,884.40 | PC Mouse | $ 2,953.50 | $ 2,049.55 | $ 3,141.45 | $ 8,144.50 | |
| 7 | $ 203,276.35 | Grand Total | $ 406,350.75 | $ 430,589.05 | $ 426,496.80 | $ 1,263,436.60 | |
| 5 | $ 191,569.50 | ||||||
| 8 | $ 124,670.55 | Sum of Weekly Revenue | Column Labels | ||||
| 1 | $ 123,516.60 | Oct | Nov | Dec | Grand Total | ||
| 3 | $ 123,286.75 | ||||||
| 4 | $ 108,734.25 | Row Labels | |||||
| 2 | $ 87,498.20 | East | $ 194,176.40 | $ 215,200.85 | $ 219,454.05 | $ 628,831.30 | |
| Grand Total | $ 1,263,436.60 | North | $ 99,734.90 | $ 103,735.90 | $ 96,832.95 | $ 300,303.75 | |
| South | $ 112,439.45 | $ 111,652.30 | $ 110,209.80 | $ 334,301.55 | |||
| Row Labels | Sum of Weekly Revenue | Grand Total | $ 406,350.75 | $ 430,589.05 | $ 426,496.80 | $ 1,263,436.60 | |
| Desktop CPU | $ 1,037,788.95 | ||||||
| 17" Monitor | $ 194,421.00 | Sum of Weekly Revenue | Column Labels | ||||
| 101 Keyboard | $ 23,082.15 | Oct | Nov | Dec | Grand Total | ||
| PC Mouse | $ 8,144.50 | ||||||
| Grand Total | $ 1,263,436.60 | Row Labels | |||||
| 1 | $ 39,588.35 | $ 41,622.25 | $ 42,306.00 | $ 123,516.60 | |||
| 2 | $ 28,449.75 | $ 28,449.75 | $ 30,598.70 | $ 87,498.20 | |||
| 3 | $ 44,401.35 | $ 41,580.30 | $ 37,305.10 | $ 123,286.75 | |||
| 4 | $ 33,548.40 | $ 36,634.55 | $ 38,551.30 | $ 108,734.25 | |||
| 5 | $ 66,186.50 | $ 67,101.35 | $ 58,281.65 | $ 191,569.50 | |||
| 6 | $ 84,221.25 | $ 106,845.25 | $ 109,817.90 | $ 300,884.40 | |||
| 7 | $ 66,992.05 | $ 69,083.20 | $ 67,201.10 | $ 203,276.35 | |||
| 8 | $ 42,963.10 | $ 39,272.40 | $ 42,435.05 | $ 124,670.55 | |||
| Grand Total | $ 406,350.75 | $ 430,589.05 | $ 426,496.80 | $ 1,263,436.60 |
Data
| Store and Region Sales Database | ||||||||||
| ID | Store No | Sales Region | Item No | Item Description | Unit Price | Units Sold | Week Ending | Weekly Revenue | ||
| 1 | 1 | South | 2005 | 17" Monitor | $229.00 | 38 | 10/27/20 | $ 8,702.00 | ||
| 2 | 1 | South | 2005 | 17" Monitor | $229.00 | 40 | 11/24/20 | $ 9,160.00 | Instructions: See detailed instructions in the assignment. | |
| 3 | 1 | South | 2005 | 17" Monitor | $229.00 | 19 | 12/29/20 | $ 4,351.00 | ||
| 4 | 1 | South | 3006 | 101 Keyboard | $19.95 | 40 | 10/27/20 | $ 798.00 | ||
| 5 | 1 | South | 3006 | 101 Keyboard | $19.95 | 45 | 11/24/20 | $ 897.75 | ||
| 6 | 1 | South | 3006 | 101 Keyboard | $19.95 | 49 | 12/29/20 | $ 977.55 | ||
| 7 | 1 | South | 6050 | PC Mouse | $8.95 | 38 | 10/27/20 | $ 340.10 | ||
| 8 | 1 | South | 6050 | PC Mouse | $8.95 | 13 | 11/24/20 | $ 116.35 | ||
| 9 | 1 | South | 6050 | PC Mouse | $8.95 | 48 | 12/29/20 | $ 429.60 | ||
| 10 | 1 | South | 8500 | Desktop CPU | $849.95 | 35 | 10/27/20 | $ 29,748.25 | ||
| 11 | 1 | South | 8500 | Desktop CPU | $849.95 | 37 | 11/24/20 | $ 31,448.15 | ||
| 12 | 1 | South | 8500 | Desktop CPU | $849.95 | 43 | 12/29/20 | $ 36,547.85 | ||
| 13 | 2 | South | 2005 | 17" Monitor | $229.00 | 18 | 10/27/20 | $ 4,122.00 | ||
| 14 | 2 | South | 2005 | 17" Monitor | $229.00 | 18 | 11/24/20 | $ 4,122.00 | ||
| 15 | 2 | South | 2005 | 17" Monitor | $229.00 | 20 | 12/29/20 | $ 4,580.00 | ||
| 16 | 2 | South | 3006 | 101 Keyboard | $19.95 | 18 | 10/27/20 | $ 359.10 | ||
| 17 | 2 | South | 3006 | 101 Keyboard | $19.95 | 18 | 11/24/20 | $ 359.10 | ||
| 18 | 2 | South | 3006 | 101 Keyboard | $19.95 | 18 | 12/29/20 | $ 359.10 | ||
| 19 | 2 | South | 6050 | PC Mouse | $8.95 | 19 | 10/27/20 | $ 170.05 | ||
| 20 | 2 | South | 6050 | PC Mouse | $8.95 | 19 | 11/24/20 | $ 170.05 | ||
| 21 | 2 | South | 6050 | PC Mouse | $8.95 | 18 | 12/29/20 | $ 161.10 | ||
| 22 | 2 | South | 8500 | Desktop CPU | $849.95 | 28 | 10/27/20 | $ 23,798.60 | ||
| 23 | 2 | South | 8500 | Desktop CPU | $849.95 | 28 | 11/24/20 | $ 23,798.60 | ||
| 24 | 2 | South | 8500 | Desktop CPU | $849.95 | 30 | 12/29/20 | $ 25,498.50 | ||
| 25 | 3 | South | 2005 | 17" Monitor | $229.00 | 48 | 10/27/20 | $ 10,992.00 | ||
| 26 | 3 | South | 2005 | 17" Monitor | $229.00 | 40 | 11/24/20 | $ 9,160.00 | ||
| 27 | 3 | South | 2005 | 17" Monitor | $229.00 | 13 | 12/29/20 | $ 2,977.00 | ||
| 28 | 3 | South | 3006 | 101 Keyboard | $19.95 | 40 | 10/27/20 | $ 798.00 | ||
| 29 | 3 | South | 3006 | 101 Keyboard | $19.95 | 42 | 11/24/20 | $ 837.90 | ||
| 30 | 3 | South | 3006 | 101 Keyboard | $19.95 | 43 | 12/29/20 | $ 857.85 | ||
| 31 | 3 | South | 6050 | PC Mouse | $8.95 | 35 | 10/27/20 | $ 313.25 | ||
| 32 | 3 | South | 6050 | PC Mouse | $8.95 | 15 | 11/24/20 | $ 134.25 | ||
| 33 | 3 | South | 6050 | PC Mouse | $8.95 | 36 | 12/29/20 | $ 322.20 | ||
| 34 | 3 | South | 8500 | Desktop CPU | $849.95 | 38 | 10/27/20 | $ 32,298.10 | ||
| 35 | 3 | South | 8500 | Desktop CPU | $849.95 | 37 | 11/24/20 | $ 31,448.15 | ||
| 36 | 3 | South | 8500 | Desktop CPU | $849.95 | 39 | 12/29/20 | $ 33,148.05 | ||
| 37 | 4 | North | 2005 | 17" Monitor | $229.00 | 28 | 10/27/20 | $ 6,412.00 | ||
| 38 | 4 | North | 2005 | 17" Monitor | $229.00 | 30 | 11/24/20 | $ 6,870.00 | ||
| 39 | 4 | North | 2005 | 17" Monitor | $229.00 | 14 | 12/29/20 | $ 3,206.00 | ||
| 40 | 4 | North | 3006 | 101 Keyboard | $19.95 | 22 | 10/27/20 | $ 438.90 | ||
| 41 | 4 | North | 3006 | 101 Keyboard | $19.95 | 34 | 11/24/20 | $ 678.30 | ||
| 42 | 4 | North | 3006 | 101 Keyboard | $19.95 | 46 | 12/29/20 | $ 917.70 | ||
| 43 | 4 | North | 6050 | PC Mouse | $8.95 | 39 | 10/27/20 | $ 349.05 | ||
| 44 | 4 | North | 6050 | PC Mouse | $8.95 | 21 | 11/24/20 | $ 187.95 | ||
| 45 | 4 | North | 6050 | PC Mouse | $8.95 | 48 | 12/29/20 | $ 429.60 | ||
| 46 | 4 | North | 8500 | Desktop CPU | $849.95 | 31 | 10/27/20 | $ 26,348.45 | ||
| 47 | 4 | North | 8500 | Desktop CPU | $849.95 | 34 | 11/24/20 | $ 28,898.30 | ||
| 48 | 4 | North | 8500 | Desktop CPU | $849.95 | 40 | 12/29/20 | $ 33,998.00 | ||
| 49 | 5 | North | 2005 | 17" Monitor | $229.00 | 37 | 10/27/20 | $ 8,473.00 | ||
| 50 | 5 | North | 2005 | 17" Monitor | $229.00 | 35 | 11/24/20 | $ 8,015.00 | ||
| 51 | 5 | North | 2005 | 17" Monitor | $229.00 | 33 | 12/29/20 | $ 7,557.00 | ||
| 52 | 5 | North | 3006 | 101 Keyboard | $19.95 | 90 | 10/27/20 | $ 1,795.50 | ||
| 53 | 5 | North | 3006 | 101 Keyboard | $19.95 | 92 | 11/24/20 | $ 1,835.40 | ||
| 54 | 5 | North | 3006 | 101 Keyboard | $19.95 | 85 | 12/29/20 | $ 1,695.75 | ||
| 55 | 5 | North | 6050 | PC Mouse | $8.95 | 75 | 10/27/20 | $ 671.25 | ||
| 56 | 5 | North | 6050 | PC Mouse | $8.95 | 34 | 11/24/20 | $ 304.30 | ||
| 57 | 5 | North | 6050 | PC Mouse | $8.95 | 65 | 12/29/20 | $ 581.75 | ||
| 58 | 5 | North | 8500 | Desktop CPU | $849.95 | 65 | 10/27/20 | $ 55,246.75 | ||
| 59 | 5 | North | 8500 | Desktop CPU | $849.95 | 67 | 11/24/20 | $ 56,946.65 | ||
| 60 | 5 | North | 8500 | Desktop CPU | $849.95 | 57 | 12/29/20 | $ 48,447.15 | ||
| 61 | 6 | East | 2005 | 17" Monitor | $229.00 | 34 | 10/27/20 | $ 7,786.00 | ||
| 62 | 6 | East | 2005 | 17" Monitor | $229.00 | 95 | 11/24/20 | $ 21,755.00 | ||
| 63 | 6 | East | 2005 | 17" Monitor | $229.00 | 66 | 12/29/20 | $ 15,114.00 | ||
| 64 | 6 | East | 3006 | 101 Keyboard | $19.95 | 62 | 10/27/20 | $ 1,236.90 | ||
| 65 | 6 | East | 3006 | 101 Keyboard | $19.95 | 68 | 11/24/20 | $ 1,356.60 | ||
| 66 | 6 | East | 3006 | 101 Keyboard | $19.95 | 79 | 12/29/20 | $ 1,576.05 | ||
| 67 | 6 | East | 6050 | PC Mouse | $8.95 | 45 | 10/27/20 | $ 402.75 | ||
| 68 | 6 | East | 6050 | PC Mouse | $8.95 | 49 | 11/24/20 | $ 438.55 | ||
| 69 | 6 | East | 6050 | PC Mouse | $8.95 | 54 | 12/29/20 | $ 483.30 | ||
| 70 | 6 | East | 8500 | Desktop CPU | $849.95 | 88 | 10/27/20 | $ 74,795.60 | ||
| 71 | 6 | East | 8500 | Desktop CPU | $849.95 | 98 | 11/24/20 | $ 83,295.10 | ||
| 72 | 6 | East | 8500 | Desktop CPU | $849.95 | 109 | 12/29/20 | $ 92,644.55 | ||
| 73 | 7 | East | 2005 | 17" Monitor | $229.00 | 44 | 10/27/20 | $ 10,076.00 | ||
| 74 | 7 | East | 2005 | 17" Monitor | $229.00 | 46 | 11/24/20 | $ 10,534.00 | ||
| 75 | 7 | East | 2005 | 17" Monitor | $229.00 | 45 | 12/29/20 | $ 10,305.00 | ||
| 76 | 7 | East | 3006 | 101 Keyboard | $19.95 | 59 | 10/27/20 | $ 1,177.05 | ||
| 77 | 7 | East | 3006 | 101 Keyboard | $19.95 | 57 | 11/24/20 | $ 1,137.15 | ||
| 78 | 7 | East | 3006 | 101 Keyboard | $19.95 | 58 | 12/29/20 | $ 1,157.10 | ||
| 79 | 7 | East | 6050 | PC Mouse | $8.95 | 55 | 10/27/20 | $ 492.25 | ||
| 80 | 7 | East | 6050 | PC Mouse | $8.95 | 52 | 11/24/20 | $ 465.40 | ||
| 81 | 7 | East | 6050 | PC Mouse | $8.95 | 55 | 12/29/20 | $ 492.25 | ||
| 82 | 7 | East | 8500 | Desktop CPU | $849.95 | 65 | 10/27/20 | $ 55,246.75 | ||
| 83 | 7 | East | 8500 | Desktop CPU | $849.95 | 67 | 11/24/20 | $ 56,946.65 | ||
| 84 | 7 | East | 8500 | Desktop CPU | $849.95 | 65 | 12/29/20 | $ 55,246.75 | ||
| 85 | 8 | East | 2005 | 17" Monitor | $229.00 | 28 | 10/27/20 | $ 6,412.00 | ||
| 86 | 8 | East | 2005 | 17" Monitor | $229.00 | 27 | 11/24/20 | $ 6,183.00 | ||
| 87 | 8 | East | 2005 | 17" Monitor | $229.00 | 33 | 12/29/20 | $ 7,557.00 | ||
| 88 | 8 | East | 3006 | 101 Keyboard | $19.95 | 32 | 10/27/20 | $ 638.40 | ||
| 89 | 8 | East | 3006 | 101 Keyboard | $19.95 | 28 | 11/24/20 | $ 558.60 | ||
| 90 | 8 | East | 3006 | 101 Keyboard | $19.95 | 32 | 12/29/20 | $ 638.40 | ||
| 91 | 8 | East | 6050 | PC Mouse | $8.95 | 24 | 10/27/20 | $ 214.80 | ||
| 92 | 8 | East | 6050 | PC Mouse | $8.95 | 26 | 11/24/20 | $ 232.70 | ||
| 93 | 8 | East | 6050 | PC Mouse | $8.95 | 27 | 12/29/20 | $ 241.65 | ||
| 94 | 8 | East | 8500 | Desktop CPU | $849.95 | 42 | 10/27/20 | $ 35,697.90 | ||
| 95 | 8 | East | 8500 | Desktop CPU | $849.95 | 38 | 11/24/20 | $ 32,298.10 | ||
| 96 | 8 | East | 8500 | Desktop CPU | $849.95 | 40 | 12/29/20 | $ 33,998.00 |
