Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In the Sales Report sheet add and calculate the following: Add the remaining months of Sales per Company Name-July, August, Sept, Oct, Nov, Dec-make up

image text in transcribed image text in transcribed

In the Sales Report sheet add and calculate the following:

  1. Add the remaining months of Sales per Company Name-July, August, Sept, Oct, Nov, Dec-make up the numbers.
  2. Add Total Sales per month, total per quarter, total per entire year, total by name (example Petersen) You must show the formula for all.
  3. Calculate the total of sales for the month, for the first three companies and then the last three companies. Identify who has the best sales per year, per quarter and per month. Identify which month has the best sales.
  4. Calculate All sales less Rizzos for month 2,4,6,8 and 10. Show formula.
  5. Provide five Charts describing what you are showing, any combination of different information but you must explain in 25 words or more what they mean.

In the Food Sales Sheet add Morning Sales based on type, add any you would like at the top.

  1. Calculate how many beverages are sold for all three meals, and deserts per meal.
  2. Calculate the sales if this was for 7 months, (same numbers per month) show formula.
  3. Calculate all totals less deserts for 12 months.
  4. Create three charts of any information in this sheet, explain in 25 words.
  5. Create a pivot table of any information with a pivot chart.

Add another spread sheet for Paper Products

  1. Add the following:
    1. Plates
    2. Cups
    3. Bowls
    4. Platters
    5. Forks, knives, spoons
  2. Add columns by quarter, so there are four quarters in a year. Add 1467 plates sold per quarter, 2301 cups per quarter, 1209 bowls per quarter, 490 platters and 1456 sets of cutleries per quarter.

Create five charts to include:

How many plates were sold for the entire year, how many cups were sold for two quarters, how many bowls were sold for three quarters, how many platters were sold for the year and how many cutlery sets were sold every month?

  1. What was the total of all products sold in six months?
Lunch Sales Beverages 1,836 Sandwiches 8,160 Soup 3,060 Salads 4,284 Desserts 3,060 20,400 Dinner Sales Beverages 2,455 Sandwiches 8,766 Soup 3,567 Salads 4,222 Desserts 3,195 22,205 June 232 701 Nastle Traders Coffee Bean Sales Report Company January February March April May Hansen 240 560 500 123 432 Alexander 700 420 290 345 142 Parker 150 180 195 342 631 Smith 500 212 456 543 677 Petersen 545 120 389 432 199 Rizzo 239 545 498 198 675 July 382 531 420 156 August September November December 588 562 451 651 144 235 654 651 333 236 872 652 450 456 213 658 123 541 216 328 185 486 475 541 515 254 600 320 568 227 Lunch Sales Beverages 1,836 Sandwiches 8,160 Soup 3,060 Salads 4,284 Desserts 3,060 20,400 Dinner Sales Beverages 2,455 Sandwiches 8,766 Soup 3,567 Salads 4,222 Desserts 3,195 22,205 June 232 701 Nastle Traders Coffee Bean Sales Report Company January February March April May Hansen 240 560 500 123 432 Alexander 700 420 290 345 142 Parker 150 180 195 342 631 Smith 500 212 456 543 677 Petersen 545 120 389 432 199 Rizzo 239 545 498 198 675 July 382 531 420 156 August September November December 588 562 451 651 144 235 654 651 333 236 872 652 450 456 213 658 123 541 216 328 185 486 475 541 515 254 600 320 568 227

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

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

Auditing Cases An Interactive Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

4th Edition

0132423502, 978-0132423502

More Books

Students also viewed these Accounting questions

Question

1 5 8 . ' '

Answered: 1 week ago

Question

=+Construct a data- and research-driven SWOT analysis

Answered: 1 week ago

Question

=+Who are our customers?

Answered: 1 week ago

Question

=+What are our goals presently?

Answered: 1 week ago