Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a sales summary The Sales summary includes the following Total sale items for each store Total Sales of all store Minimum sales of items

Create a sales summary

The Sales summary includes the following

  • Total sale items for each store
  • Total Sales of all store
  • Minimum sales of items at each store
  • Maximum sales of items at each store
  • Average Sales of each store
  • More or Less sales compare to North Store average sales

image text in transcribed

Quarterly Sales North Store Quarter 1 Quarter 4 Total Quarter 3 $218.526 $434.522 $444,522 $1,381.092 $95.297 Quarter 2 $283,522 $107,525 $128,663 $197.476 $115,852 $228,453 $547,127 Dept Clothing Cosmetics Electronics & Computers Furniture Applications Total $128,461 $244,544 $756.421 $254,753 $125,768 $96.845 $160.780 $580,869 $109.788 $94,629 $106,830 $142,645 $453,892 $864,913 $811,815 $846,532 $1,196,141 $3.719.401 Quarterly Sales South Store Total Quarter 1 $127.520 Quarter 2 $223,684 Quarter 4 $269,723 Quarter 3 $121,343 $121,374 $247,462 $98,794 $128,477 Dept Clothing Cosmetics Electronics & Computers Furniture Applications Total $126,731 $99,724 $104,241 $94,341 $247,252 $742.270 $448,369 $725,686 $419,569 $446,900 $2.782.794 $88,643 $106.251 $96,784 $133,222 $94,552 $616.542 $130,334 $122,342 $898.128 $538,472 $729.652 Quarterly Sales West Store Quarter 3 Quarter 4 Total Quarter 1 $232,672 Quarter 2 $206,411 $211,349 $343,728 $994,160 $81,475 $404.971 Dept Clothing Cosmetics Electronics & Computers Furniture Applications Total $94.731 $103,224 $94.242 $124,413 $232,224 $195,224 $104,352 $245,224 $106,678 $87,531 $97,453 $694,355 $775,896 $374,903 $417,643 $2,976,573 $86,452 $122.423 $776,861 $94,353 $592,961 $103,414 $903,396 Quarterly Sales East Store Quarter 4 Total Quarter 1 $173,942 $93,272 Quarter 2 $182,345 $227,842 $713,863 Dept Clothing Cosmetics Electronics & Computers Furniture Applications Total Quarter 3 $129,734 $103,432 $182,023 $92,963 $190,532 $258,735 $102,413 $96,348 $103.843 $123,084 $186,348 $97,324 $103,462 $662,442 $480,199 $729,519 $420,599 $473,530 $2.817,710 $96,384 $562,359 $134,342 $653,374 $139,342 $939,535

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

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

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Accounting questions