Creating a sales summary worksheet

Question

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