INFT 111
To: YourEmail@youremail
From: Food.Service@youremail
Subject: Cafeteria Data
I need your help! The cafeteria staff has given me the monthly totals for each type of
meal. Since we have to report sales to the home office for all departments, we need to do
some calculations and clean up of the data.
The Excel file contains the monthly amounts sold for each product line. The chart below
contains important information for calculating profit and loss.
I need an Excel workbook with the following:
•3 worksheets, named Totals, Cost and Pricing, and Amounts (in that
order) Worksheet “Totals” should contain the following:
•Table header centered and the width of your table with the name “Total Annual
Costs and Profits per Item”
•Column called “Item” with all items, Hotdog, Hamburger, Pizza, Chicken,
Fries, Chips, Vegetables, and Drinks listed;
•Using the data from the worksheets, Cost and Pricing and Amounts, create the
following:
