Business Finance - Management Week Three Assignment. Create excel dashboard and word doc to explain your case. Please include dashboards in word doc. Upload word doc and excel doc. Please see Instructions and follow rubric
dream86
Assignment1M1Store0RegionSalesDatabase--ExcelEXAMPLE.xlsxPivots
| Best Performing Regions by Total Revenue | Revenue | Total Revenue for each Product by Selling Period | Item Description | ||||||||
| East | $628,831.30 | Sales Period | 101 Keyboard | 17" Monitor | Desktop CPU | PC Mouse | |||||
| South | $334,301.55 | Oct | $7,241.85 | $62,975.00 | $333,180.40 | $2,953.50 | |||||
| North | $300,303.75 | Nov | $7,660.80 | $75,799.00 | $345,079.70 | $2,049.55 | |||||
| Dec | $8,179.50 | $55,647.00 | $359,528.85 | $3,141.45 | |||||||
| Best Performing Stores by Total Revenue | Revenue | ||||||||||
| 6 | $300,884.40 | Total Revenue for Each Region by Selling Period | Sales Region | ||||||||
| 7 | $203,276.35 | Sales Period | East | North | South | ||||||
| 5 | $191,569.50 | Oct | $194,176.40 | $99,734.90 | $112,439.45 | ||||||
| 8 | $124,670.55 | Nov | $215,200.85 | $103,735.90 | $111,652.30 | ||||||
| 1 | $123,516.60 | Dec | $219,454.05 | $96,832.95 | $110,209.80 | ||||||
| 3 | $123,286.75 | ||||||||||
| 4 | $108,734.25 | Total Revenue for Each Store by Selling Period | Store No | ||||||||
| 2 | $87,498.20 | Sales Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | |
| Oct | $39,588.35 | $28,449.75 | $44,401.35 | $33,548.40 | $66,186.50 | $84,221.25 | $66,992.05 | $42,963.10 | |||
| Best Selling Products by Total Revenue | Revenue | Nov | $41,622.25 | $28,449.75 | $41,580.30 | $36,634.55 | $67,101.35 | $106,845.25 | $69,083.20 | $39,272.40 | |
| Desktop CPU | $1,037,788.95 | Dec | $42,306.00 | $30,598.70 | $37,305.10 | $38,551.30 | $58,281.65 | $109,817.90 | $67,201.10 | $42,435.05 | |
| 17" Monitor | $194,421.00 | ||||||||||
| 101 Keyboard | $23,082.15 | ||||||||||
| PC Mouse | $8,144.50 |
Dashboard
Best Performing Regions by Total Revenue
Total East South North 628831.30000000005 334301.55000000005 300303.75
Best Performing Stores by Total Revenue
Total 6 7 5 8 1 3 4 2 300884.40000000002 203276.35 191569.5 124670.55 123516.6 123286.75000000001 108734.25 87498.200000000012
Best Selling Products by Total Revenue
Total Desktop CPU 17" Monitor 101 Keyboard PC Mouse 1037788.9500000001 194421 23082.15 8144.4999999999991
101 Keyboard Oct Nov Dec 7241.8499999999995 7660.7999999999993 8179.5 17" Monitor Oct Nov Dec 62975 75799 55647 Desktop CPU Oct Nov Dec 333180.40000000002 345079.7 359528.85 PC Mouse Oct Nov Dec 2953.5 2049.5499999999997 3141.45
East Oct Nov Dec 194176.39999999997 215200.85 219454.05 North Oct Nov Dec 99734.9 103735.90000000001 96832.950000000012 South Oct Nov Dec 112439.45000000001 111652.29999999999 110209.8
1 Oct Nov Dec 39588.35 41622.25 42306 2 Oct Nov Dec 28449.750000000004 28449.750000000004 30598.7 3 Oct Nov Dec 44401.350000000006 41580.300000000003 37305.100000000006 4 Oct Nov Dec 33548.400000000001 36634.550000000003 38551.300000000003 5 Oct Nov Dec 66186.5 67101.350000000006 58281.65 6 Oct Nov Dec 84221.25 106845.25 109817.9 7 Oct Nov Dec 66992.05 69083.199999999997 67201.100000000006 8 Oct Nov Dec 42963.1 39272.400000000001 42435.05
Data
| Store & 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 |
