Assignment:
Mode of submission: Online through your blackboard account. No email submissions will be accepted.
Assignment Description: You work for Miss Lexi's Baked Goods which sell Cookie Baskets. You are given the price and quantity sold for each item as follows
|
|
Product
|
Price ($)
|
Quantity Sold
|
|
|
Almond
|
15.95
|
559
|
|
|
Crunches
|
|
|
|
|
Cinnamon
|
15.95
|
1,026
|
|
|
Sleds
|
|
|
|
|
Coconut
|
19.95
|
1,598
|
|
|
Snowmen
|
|
|
|
Cookie
|
Molasses
|
19.95
|
2,287
|
|
|
Chews
|
|
|
|
Baskets
|
Raspberry
|
21.95
|
787
|
|
|
Bells
|
|
|
|
|
Gingerbread
|
21.95
|
1,065
|
|
|
Men
|
|
|
|
|
Chocolate
|
25.95
|
1,076
|
|
|
Delights
|
|
|
You are asked to create a sales summary worksheet in excel which contains the information in the above table and additional two columns as follow
1) First additional column to show the cost of the each product.
2) Second additional column to show the percentage of cost of the product with respect to the total cost.