Excel Worksheets: January and February Worksheets: 1. Follow all of the tasks listed above in the Tasks to Be Performed On Each Worksheet. 2. The title for these worksheets should be "January" and "February," respectively. 3. The title on the income statement should be "Income Statement for January 2014" and "Income Statement for February 2014," respectively. These titles should also be in bold and at a slightly larger font than the rest of the information. 4. Copy and paste the basic design of the income statement from the General Information worksheet (column A) over to these worksheets. 5. You should have two additional columns: a. The numbers column-Label this column as "Amount." In these cells that correspond to the row headings, you must link back to the information you entered in the "General Information" worksheet. Do not type in these numbers. b. The percentages column - Label this column "Percentages." You must use the formula for calculating these percentages. Don't use a calculator and then type in the information. The percentages must be to the 100th decimal place. Hint: all of the percentages (except cost of sales for food and beverage) are divided by Total Sales. Use a $ sign in front of the column letter and cell # for the total sales cell to hold it constant (SAS5). 6. Bold the "Amount" and "Percentage" column headings and center them in the cell. January 2014- February 2014- Sales Food Beverage 263046.284252726.38 29328.30 18652.15 Cost of Salese Food Beverage 82649.15 5842.13 93948.06 4895.36 70600.82 17680.09. 7.50% 7776.13 3692.40 8976.31 72317.80 15679.28 7.50% 3674.11 3370.80 13704.66 Operating Expenses Salaries and wages Employee benefits Occupancye Insurance Advertising Utilities Repairs and maintenance Depreciation Linen Supplies Cash over/shorte Pest Control Interest Expensee Other Expenses Taxes 971.65 I 1 1556.981 2269.56 21.08 400.00 4745.94 15525.00 14227.90 3713.34 3791.00 829.682 4723.69 476.65. 400.00 - 7309.88 15525.00 7343.08. Excel Worksheets: January and February Worksheets: 1. Follow all of the tasks listed above in the Tasks to Be Performed On Each Worksheet. 2. The title for these worksheets should be "January" and "February," respectively. 3. The title on the income statement should be "Income Statement for January 2014" and "Income Statement for February 2014," respectively. These titles should also be in bold and at a slightly larger font than the rest of the information. 4. Copy and paste the basic design of the income statement from the General Information worksheet (column A) over to these worksheets. 5. You should have two additional columns: a. The numbers column-Label this column as "Amount." In these cells that correspond to the row headings, you must link back to the information you entered in the "General Information" worksheet. Do not type in these numbers. b. The percentages column - Label this column "Percentages." You must use the formula for calculating these percentages. Don't use a calculator and then type in the information. The percentages must be to the 100th decimal place. Hint: all of the percentages (except cost of sales for food and beverage) are divided by Total Sales. Use a $ sign in front of the column letter and cell # for the total sales cell to hold it constant (SAS5). 6. Bold the "Amount" and "Percentage" column headings and center them in the cell. January 2014- February 2014- Sales Food Beverage 263046.284252726.38 29328.30 18652.15 Cost of Salese Food Beverage 82649.15 5842.13 93948.06 4895.36 70600.82 17680.09. 7.50% 7776.13 3692.40 8976.31 72317.80 15679.28 7.50% 3674.11 3370.80 13704.66 Operating Expenses Salaries and wages Employee benefits Occupancye Insurance Advertising Utilities Repairs and maintenance Depreciation Linen Supplies Cash over/shorte Pest Control Interest Expensee Other Expenses Taxes 971.65 I 1 1556.981 2269.56 21.08 400.00 4745.94 15525.00 14227.90 3713.34 3791.00 829.682 4723.69 476.65. 400.00 - 7309.88 15525.00 7343.08