Creating a sales summary worksheet

Assignment:

You work for MissLexi's Baked Goods which sell

(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 :

##### Reference No:- TGS01805100

Now Priced at \$25 (50% Discount)

Recommended (98%)

Rated (4.3/5)