Creating a sales summary worksheet


Assignment:

You work for MissLexi's Baked Goods which sell

(1) Cookie Baskets,

(2) Pies and

(3) Cakes. You are given the price and quantity sold for each item as follows

 

 

 

 

 

 

 

 

Cookie

 

Baskets

Product

Price ($)

Quantity Sold

Almond Crunches

15.95

 559

Cinnamon Sleds

15.95

 1,026

Coconut Snowmen

19.95

 1,598

Molasses Chews

19.95

 2,287

Raspberry Bells

21.95

 787

Gingerbread  Men

21.95

 1,065

Chocolate Delights

25.95

 1,076

 

 

 

Cakes

Product

Price ($)

Quantity Sold

Chocolate 

18.95

 1,096

Vanilla

18.95

 543

Lemon

17.95

 227

Apple Cinnamon

19.95

 2,377

Maple Pumpkin

17.95

 4,311

 

 

 

 

 

 

 

 

 

Pies

Product

Price ($)

Quantity Sold

Mincemeat

15.95

 1,087

Pecan

19.95

 3,209

Pumpkin

15.95

 1,044

Apple

19.95

 2,054

Cherry

15.95

 3,423

Mincemeat

15.95

 1,087

Pecan

19.95

 3,209

 

 

 

 

 

 

 

You are asked to create a sales summary worksheet in excel 2013. All calculations involved in the worksheet preparation must be completed using appropriate formulae. Format your worksheet as shown below:

Miss Lexi's Baked Goods

Holiday Sales Summary






 

Product

Price

Quantity Sold

Total

Cookie Baskets

Almond Crunches

15.95

                559

 $     8,916.05

Cinnamon Sleds

15.95

             1,026

 $   16,364.70

Coconut Snowmen

19.95

             1,598

 $   31,880.10

Molasses Chews

19.95

             2,287

 $   45,625.65

Raspberry Bells

21.95

                787

 $   17,274.65

Gingerbread  Men

21.95

             1,065

 $   23,376.75

Chocolate Delights

25.95

             1,076

 $   27,922.20

Cookie Baskets Subtotal:

       8,398.00

 $ 171,360.10

 

 

 

 

 

Pies

Mincemeat

15.95

             1,087

 $   17,337.65

Pecan

19.95

             3,209

 $   64,019.55

Pumpkin

15.95

             1,044

 $   16,651.80

Apple

19.95

             2,054

 $   40,977.30

Cherry

15.95

             3,423

 $   54,596.85

 

Pies Subtotal:

          10,817

 $ 193,583.15

 

 

 

 

 

Cakes

Chocolate 

18.95

             1,096

 $   20,769.20

Vanilla

18.95

                543

 $   10,289.85

Lemon

17.95

                227

 $     4,074.65

Apple Cinnamon

19.95

             2,377

 $   47,421.15

Maple Pumpkin

17.95

             4,311

 $   77,382.45

 

Cakes Subtotal:

            8,554

 $ 159,937.30

 

 

 

 

 








Total Holiday Sales:

          27,769

 $ 524,880.55

Solution Preview :

Prepared by a verified Expert
Other Subject: Creating a sales summary worksheet
Reference No:- TGS01805100

Now Priced at $25 (50% Discount)

Recommended (98%)

Rated (4.3/5)

2015 ©TutorsGlobe All rights reserved. TutorsGlobe Rated 4.8/5 based on 34139 reviews.