Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item description, unit price, units sold, and month when the sales were made during the fourth quarter of last year 2 Modify the spreadsheet to calculate the total sales revenue for each of the eight stores as well as each of the three sales regions. ID Total Woody Revenue STORE NO TOTAL SALES REVENUE Store No Sales Region Item No. Item Description Unit Price Units Sok Week Ending T Bouth 2005 24" Monitor $229.00 28 October 1 South 2005 24 Monitor $220.00 30 November 3 15 2005 24 Monitor $229.00 9 December 1 South 3000 Wireless Keybow $19.95 30 October 1 South 3000 Wireless Keybow $19.95 35 November South 3000 Winess Keyboa $19.95 45 December Sot 5050 PC Mouse $8.95 28 October 0050 PC MOUS 5895 3 November 1 South COOPG Mouse 30 December 16 South 1500 Laptop 5840.05 25 October T! Sot 5500 Laptop $89.95 27 November 12 1 South 500 Laptop 640.05 December 13 2 South 2005 24 Monitor $220.00 11 October 14 250 2005 20" Monitor $220.00 8 November 15 2 South 2005 2 Monitor $220.00 10 December 16 2 South 3005/ Wes Keybom $19.95 8 October 17 2 South 3000 Wireless Keyboar $19.95 November 2. South 3000 Wireless Keyboar $10.05 December 2 South 6050 PC Mouse $8.95 9 October TOTAL SALES REVENUE SALES REGION South North East A B 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 2 South 2 South 2 South 2 South 2 South 2 South 3 South 3 South 3 South 3 South 3 South 3 South 3 South 3 South 3 South 3 South 3 South 3 South 4 North 4 North 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboar 3006 Wireless Keyboar 3006 Wireless Keyboar 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 20 9 12 8 18 18 20 38 34 3 30 32 33 25 5 26 28 27 29 18 25 October November December October November December October November December October November December October November December October November December October November December 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 4 North 4 North 4 North 4 North 4 North 4 North 4 North 4 North 4 North 4 North 4 North 5 North 5 North 5 North 5 North 5 North 5 North 5 North 5 North 5 North 5 North 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboar 3006 Wireless Keyboar 3006 Wireless Keyboar 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboar 3006 Wireless Keyboar 3006 Wireless Keyboar 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 25 4 12 24 36 29 11 38 21 24 30 27 25 23 80 82 75 65 24 55 55 November December October November December October November December October November December October November December October November December October November December October 6 7 8 9 50 51 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 5 North 5 North 5 North 6 East 6 East 6 East 6 East 6 East 6 East 6 East 6 East 6 East 6 East 6 East 6 East 7 East 7 East 7 East 7 East 7 East 7 East 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboar 3006 Wireless Keyboar 3006 Wireless Keyboar 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboar 3006 Wireless Keyboar 3006 Wireless Keyboar $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 55 57 47 24 90 56 52 58 69 35 39 44 78 88 105 34 36 35 49 47 48 November December October November December October November December October November December October November December October November December October November December A B 5 7 3 9 0 1 32 33 94 95 96 97 98 99 100 78 79 80 81 82 83 84 85 86 87 BB 89 90 91 92 93 94 95 96 7 East 7 East 7 East 7 East 7 East 7 East 7 East 8 East 8 East 8 East 8 East 8 East 8 East 8 East 8 East 8 East 8 East 8 East 8 East 3006 Wireless Keyboar 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboar 3006 Wireless Keyboan 3006 Wireless Keyboar 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop $19.95 48 $8.95 45 $8.95 42 $8.95 45 $849.95 55 $849.95 45 $849.95 55 $229.00 18 $229.00 17 $229.00 23 $19.9522 $19.95 18 $19.95 22 $8.95 14 $8.95 16 $8.95 17 $849.95 32 $849.95 28 $849.95 30 December October November December October November December October November December October November December October November December October November December The Excel file Store and Regional Sales Database provides sales data for computers and peripherals showing the store identification number, sales region, item number, item description, unit price, units sold, and month when the sales were made during the fourth quarter of last year 2 Modify the spreadsheet to calculate the total sales revenue for each of the eight stores as well as each of the three sales regions. ID Total Woody Revenue STORE NO TOTAL SALES REVENUE Store No Sales Region Item No. Item Description Unit Price Units Sok Week Ending T Bouth 2005 24" Monitor $229.00 28 October 1 South 2005 24 Monitor $220.00 30 November 3 15 2005 24 Monitor $229.00 9 December 1 South 3000 Wireless Keybow $19.95 30 October 1 South 3000 Wireless Keybow $19.95 35 November South 3000 Winess Keyboa $19.95 45 December Sot 5050 PC Mouse $8.95 28 October 0050 PC MOUS 5895 3 November 1 South COOPG Mouse 30 December 16 South 1500 Laptop 5840.05 25 October T! Sot 5500 Laptop $89.95 27 November 12 1 South 500 Laptop 640.05 December 13 2 South 2005 24 Monitor $220.00 11 October 14 250 2005 20" Monitor $220.00 8 November 15 2 South 2005 2 Monitor $220.00 10 December 16 2 South 3005/ Wes Keybom $19.95 8 October 17 2 South 3000 Wireless Keyboar $19.95 November 2. South 3000 Wireless Keyboar $10.05 December 2 South 6050 PC Mouse $8.95 9 October TOTAL SALES REVENUE SALES REGION South North East A B 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 2 South 2 South 2 South 2 South 2 South 2 South 3 South 3 South 3 South 3 South 3 South 3 South 3 South 3 South 3 South 3 South 3 South 3 South 4 North 4 North 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboar 3006 Wireless Keyboar 3006 Wireless Keyboar 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 20 9 12 8 18 18 20 38 34 3 30 32 33 25 5 26 28 27 29 18 25 October November December October November December October November December October November December October November December October November December October November December 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 4 North 4 North 4 North 4 North 4 North 4 North 4 North 4 North 4 North 4 North 4 North 5 North 5 North 5 North 5 North 5 North 5 North 5 North 5 North 5 North 5 North 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboar 3006 Wireless Keyboar 3006 Wireless Keyboar 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboar 3006 Wireless Keyboar 3006 Wireless Keyboar 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 25 4 12 24 36 29 11 38 21 24 30 27 25 23 80 82 75 65 24 55 55 November December October November December October November December October November December October November December October November December October November December October 6 7 8 9 50 51 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 5 North 5 North 5 North 6 East 6 East 6 East 6 East 6 East 6 East 6 East 6 East 6 East 6 East 6 East 6 East 7 East 7 East 7 East 7 East 7 East 7 East 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboar 3006 Wireless Keyboar 3006 Wireless Keyboar 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboar 3006 Wireless Keyboar 3006 Wireless Keyboar $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 55 57 47 24 90 56 52 58 69 35 39 44 78 88 105 34 36 35 49 47 48 November December October November December October November December October November December October November December October November December October November December A B 5 7 3 9 0 1 32 33 94 95 96 97 98 99 100 78 79 80 81 82 83 84 85 86 87 BB 89 90 91 92 93 94 95 96 7 East 7 East 7 East 7 East 7 East 7 East 7 East 8 East 8 East 8 East 8 East 8 East 8 East 8 East 8 East 8 East 8 East 8 East 8 East 3006 Wireless Keyboar 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboar 3006 Wireless Keyboan 3006 Wireless Keyboar 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop $19.95 48 $8.95 45 $8.95 42 $8.95 45 $849.95 55 $849.95 45 $849.95 55 $229.00 18 $229.00 17 $229.00 23 $19.9522 $19.95 18 $19.95 22 $8.95 14 $8.95 16 $8.95 17 $849.95 32 $849.95 28 $849.95 30 December October November December October November December October November December October November December October November December October November December

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting Chapters 1-12 With Study Guide And Working Papers

Authors: Jeffrey Slater

13th Edition

0133866300, 9780133866308

More Books

Students also viewed these Accounting questions

Question

What are numerically controlled machines?

Answered: 1 week ago

Question

Why do you want to be a clinical psychologist?

Answered: 1 week ago