Create a NEW spreadsheet using Excelthat will be a forecast for a fictional hotel. The attachedforecast numbersexcel file is where you will get the numbers to use on your own, new spreadsheet for your fictional hotel.
The format should include the following:
• Rename worksheet one “January” and color the tab red. (If you are using a MAC this may not work, that is fine)
• Create a title for the worksheet in cell A1 “Forecast(your last name)”. Make this titlearial, bold and an 18 font size.
• Starting in cell B3 format the cells across from 1 to 31 (days in the month of January).
• Now starting in B2 enter the days of the week starting with Sunday.
• Starting in cell A4 and going down the column enter the following categories:
o Revenue
o Transient Occupied Rooms
o Transient Rate
o Transient Rooms Revenue
o Group Occupied Rooms
o Group Rate
o Group Rooms Revenue
o Total Occupied Rooms
o Occupancy %
o Food & Beverage Covers
o Average Cover
o Food & Beverage Revenue
o Expenses
o Labor
o Taxes & Benefits
o Rent
• Change the width of column A to fit the widest entry. Format all the cells (except the title) to beArial12 font.
• Freeze panes at B4.
• Insert the numbers from the attached file (forecastnumbers) in the applicable cells.
• Set up the forecast so that it will print on one page, landscape.
Save the file assetupfirstlastnameand submit.
Grading for this assignment will be:
Four points for each of the following:
• Worksheet one is “January” and the tab is red.
• The title of your worksheet is correct.
• The days of the month appear.
• The days of the week appear.
• All the row headers appear.
• Column A fits the widest entry.
• Panes have been frozen
• The numerical data has been entered correctly.
• The print layout has been set up corrctly.