3 4 5 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. Modify the spreadsheet to calculate the total sales revenue for each of the eight stores as well as each of the three sales regions. 6 7 8 Store and Regional Database 9 10 ID Store No. Sales Region Item No. Item Description Unit Price Units Sold Week Ending 11 1 1 South 2005 24" Monitor $229.00 28 October 12 2 1 South 2005 24" Monitor $229.00 30 November 13 3 1 South 2005 24" Monitor $229.00 9 December 14 15 16 17 18 19 20 21 11 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 4567800-2316676002222222222~232207BRTENS 1 South 3006 Wireless Keyboard $19.95 30 October 1 South 3006 Wireless Keyboard $19.95 35 November 1 South 3006 Wireless Keyboard $19.95 39 December 1 South 6050 PC Mouse $8.95 28 October 1 South 6050 PC Mouse $8.95 3 November 9 1 South 6050 PC Mouse $8.95 38 December 1 South 8500 Laptop $849.95 25 October 1 South 8500 Laptop $849.95 27 November 1 South 8500 Laptop $849.95 33 December 2 South 2005 24" Monitor $229.00 8 October 2 South 2005 24" Monitor $229.00 8 November 2 South 2005 24" Monitor $229.00 10 December 2 South 3006 Wireless Keyboard $19.95 8 October 2 South 3006 Wireless Keyboard $19.95 8 November 2 South 3006 Wireless Keyboard $19.95 8 December 19 2 South 6050 PC Mouse $8.95 9 October 2 South 6050 PC Mouse $8.95 9 November 2 South 6050 PC Mouse $8.95 8 December 2 South 2 South 8500 Laptop 8500 Laptop $849.95 18 October $849.95 18 November 2 South 8500 Laptop $849.95 20 December 3 South 2005 24" Monitor $229.00 38 October 3 South 2005 24" Monitor $229.00 30 November 3 South 2005 24" Monitor $229.00 3 December 3 South 3006 Wireless Keyboard $19.95 30 October 29 3 South 3006 Wireless Keyboard $19.95 32 November 3 South 3006 Wireless Keyboard $19.95 3 South 6050 PC Mouse $8.95 3 South 6050 PC Mouse $8.95 3 South 6050 PC Mouse $8.95 3 South 8500 Laptop $849.95 3 South 8500 Laptop $849.95 3 South 8500 Laptop $849.95 4 North 2005 24" Monitor $229.00 4 North 2005 24" Monitor $229.00 39 4 North 2005 24" Monitor $229.00 4 North 3006 Wireless Keyboard $19.95 4 North 4 North 3006 Wireless Keyboard 3006 Wireless Keyboard $19.95 $19.95 32222222 22 33 December 25 October 5 November 26 December October November December October November 4 December October November 36 December

3 4 5 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. Modify the spreadsheet to calculate the total sales revenue for each of the eight stores as well as each of the three sales regions. 6 7 8 Store and Regional Database 9 10 ID Store No. Sales Region Item No. Item Description Unit Price Units Sold Week Ending 11 1 1 South 2005 24" Monitor $229.00 28 October 12 2 1 South 2005 24" Monitor $229.00 30 November 13 3 1 South 2005 24" Monitor $229.00 9 December 14 15 16 17 18 19 20 21 11 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 4567800-2316676002222222222~232207BRTENS 1 South 3006 Wireless Keyboard $19.95 30 October 1 South 3006 Wireless Keyboard $19.95 35 November 1 South 3006 Wireless Keyboard $19.95 39 December 1 South 6050 PC Mouse $8.95 28 October 1 South 6050 PC Mouse $8.95 3 November 9 1 South 6050 PC Mouse $8.95 38 December 1 South 8500 Laptop $849.95 25 October 1 South 8500 Laptop $849.95 27 November 1 South 8500 Laptop $849.95 33 December 2 South 2005 24" Monitor $229.00 8 October 2 South 2005 24" Monitor $229.00 8 November 2 South 2005 24" Monitor $229.00 10 December 2 South 3006 Wireless Keyboard $19.95 8 October 2 South 3006 Wireless Keyboard $19.95 8 November 2 South 3006 Wireless Keyboard $19.95 8 December 19 2 South 6050 PC Mouse $8.95 9 October 2 South 6050 PC Mouse $8.95 9 November 2 South 6050 PC Mouse $8.95 8 December 2 South 2 South 8500 Laptop 8500 Laptop $849.95 18 October $849.95 18 November 2 South 8500 Laptop $849.95 20 December 3 South 2005 24" Monitor $229.00 38 October 3 South 2005 24" Monitor $229.00 30 November 3 South 2005 24" Monitor $229.00 3 December 3 South 3006 Wireless Keyboard $19.95 30 October 29 3 South 3006 Wireless Keyboard $19.95 32 November 3 South 3006 Wireless Keyboard $19.95 3 South 6050 PC Mouse $8.95 3 South 6050 PC Mouse $8.95 3 South 6050 PC Mouse $8.95 3 South 8500 Laptop $849.95 3 South 8500 Laptop $849.95 3 South 8500 Laptop $849.95 4 North 2005 24" Monitor $229.00 4 North 2005 24" Monitor $229.00 39 4 North 2005 24" Monitor $229.00 4 North 3006 Wireless Keyboard $19.95 4 North 4 North 3006 Wireless Keyboard 3006 Wireless Keyboard $19.95 $19.95 32222222 22 33 December 25 October 5 November 26 December October November December October November 4 December October November 36 December

Financial Accounting

14th Edition

ISBN:9781305088436

Author:Carl Warren, Jim Reeve, Jonathan Duchac

Publisher:Carl Warren, Jim Reeve, Jonathan Duchac

Chapter7: Inventories

Section: Chapter Questions

Problem 6CP

See similar textbooks