You have been left in charge of planning where to shop for your family's Holiday Dinner. You will need to create an Excel spreadsheet that will analyze pricing from 2 different grocery stores to determine the following items:
Total cost of meal from two different stores
Difference in cost between the two stores
Determine which store your family should shop at
Choose which 2 flyers you would like to use for your spreadsheet.
You will be determining cost for the following items for your dinner.
18 pound turkey
2 containers gravy
1 container cranberry sauce
1 box stuffing mix
5 pounds of potatoes
3 pounds of butternut squash
2 cans corn
3 pounds of green beans
1 package rolls
1 pound of butter
1 apple pie
1 pumpkin pie
1 gallon vanilla ice cream
You will be creating a spreadsheet in Excel listing each item and the cost at two different grocery stores. You will need to enter formulas to do your calculations. You will need to calculate the following:
Total cost for each item (number of items x cost per item)
Total cost of meal from store (sum of total column)
Difference in cost between items and total cost between the two stores. (Store 1 minus Store 2)
Determine least expensive meal.
Here is a sample of the spreadsheet.
Click here to view
Top margin of 1.25" - rest can stay the same
Insert a header:
Holiday Dinner Shopping Comparison
Add the items you are shopping for from the list above
Review the flyers listed and determine which is "best buy" for your dinner.
Enter the formulas as directed on sample above.