Create a NEW spreadsheet using Excel that will be a forecast for a fictional hotel. The attached forecast numbers excel 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 title arial, 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 be Arial 12 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 as setupfirstlastname and 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 correctly.
[removed]