BUSINESS CASE: CAFETERIA DATA ASSIGNMENT INSTRUCTIONS OVERVIEW 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. Cost Price Hotdog $ 1.35 $ 2.69 Hamburger $ 2.54 $ 3.99 Pizza $ 2.09 $ 3.89 Chicken $ 3.10 $ 5.99 Fries $ 0.87 $ 1.49 Chips $ 0.63 $ 1.29 Vegatables $ 1.48 $ 2.15 Drinks $ 0.42 $ 1.49 INSTRUCTIONS Using the start file provided and the information from above, create an Excel workbook with the following: 3 worksheets, named Totals, Cost and Pricing, and Amounts (in that order) . You must use formulas, functions, and appropriate formatting throughout to complete the assignment. 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: o Column called "Total Cost" with the total cost for the year calculated for each item (you must use a formula that references the other worksheets); Column called "Total Price" with the total price for the year calculated for each item (you must use a formula that references the other worksheets); Column called "Total Profit" with the profit calculated for the year (Total Price less Total Cost - you must use a formula); Sum cach column "Total Cost", "Total Price", and "Profit" using the SUM function; All numbers should be formatted as Accounting Style with US Dollars; Page 1 of 2