Please include formulas for Excel sheet

1. Calculate the actual and budget department profit margins (remember profit margins are percentages) for the following hotel departments: Budget Room Revenues $1,250,000.00 $1,200,000.00 Restaurant Revenues $215,000.00 $225,000.00 Beverage Revenues $75,000.00 580,000.00 Catering Revenues $480,000.00 $450,000.00 Total Hotel Fevens 52.620.000.00 51.955,000.00 PM PM Room Profit Restaurant Profit Beverage Profit Catering Profit Total Hotel Profit 5960,000.00 $18,000.00 $22,000.00 $170,000.00 $1,170,000.00 5910,000.00 $20,000.00 $25,000.00 $160,000.00 51,115,000.00 2. Calculate the actual retention/flow through in dollars and percent Actual retention/llow through dollars Actual retentionflow through percent 1. Calculate the actual and budget department profit margins (rem margins are percentages) for the following hotel departments: Room Revenues Restaurant Revenues Beverage Revenues Catering Revenues Total Hotel Revenues Actual $1,250,000.00 $215,000.00 $75,000.00 $480,000.00 $2,020,000.00 Budget $1,200,000.00 $225,000.00 $80,000.00 $450,000.00 $1,955,000.00 PM PM Room Profit Restaurant Profit Beverage Profit Catering Profit Total Hotel Profit $960,000.00 $18,000.00 $22,000.00 $170,000.00 $1,170,000.00 $910,000.00 $20,000.00 $25,000.00 $160,000.00 $1,115,000.00 2. Calculate the actual retention/flow through in dollars and percent Room Profit Restaurant Profit Beverage Profit Catering Profit Total Hotel Profit $960,000.00 $18,000.00 $22,000.00 $170,000.00 $1,170,000.00 $910,000.00 $20,000.00 $25,000.00 $160,000.00 $1,115,000.00 2. Calculate the actual retention/flow through in dollars and percent Actual retention/flow through dollars: Actual retention/flow through percent: t profit margins (remember profit hotel departments: From your ratios module remember: Profit Margin = Profit / Revenue Budget 200,000.00 225,000.00 $80,000.00 -450,000.00 955,000.00 PM 910,000.00 $20,000.00 $25,000.00 160,000.00 115,000.00 dollars and percent