SITXFIN010 Task 2-Activity 1-Hotel Futura Budget_Forecast V2 Blank Spreadsheet QAT Resort Budget Forecast Total Revenue 2016 Room Budget Rooms Available Rooms Occupied Total Occupancy % Revenue Per Available Room Total Room Revenue Total Catering Revenue $10,965,481.52 $ 0.00 Forecasted 2017 Staff costs Other Expenses Total Expenses Expenses Analysis $ 0.00 $ 0.00 $ 0.00 $ 0.00 Forecast $ Forecast % 63875 100% COGS 51548 80.70 80.7% $ 130.00 $6,701,240.00 $4,264,241.52 Restaurant Budget Expenses Analysis Total Revenue $2,019,370.53 COGS $ 0.00 Food Revenue $1,740,112.81 86% Staff costs $ 0.00 Beverage Revenue $279,257.72 14% Other Expenses $ 0.00 Total Expenses $ 0.00 Banquet Budget Expenses Analysis Total Revenue $1,313,940.16 COGS $ 0.00 Food Revenue $876,759.95 67% Staff costs $ 0.00 Beverage Revenue $183,736.83 14% Other Expenses $ 0.00 Room Service Budget Expenses Analysis Total Revenue $417,442.15 COGS $ 0.00 Food Revenue $335,796.64 80% Staff costs $ 0.00 Beverage Revenue $34,668.69 8% Other Expenses $ 0.00 Other Revenue $46,976.82 11% Mini Bar Budget Expenses Analysis Total Revenue $146,471.02 COGS $ 0.00 Beverage Revenue / Minibar $146,471.02 100% Staff costs $ 0.00 Other Revenue $ 0.00 Other Expenses $ 0.00 Bar Budget Expenses Analysis Total Revenue $367,017.66 Food Revenue $67,191.88 18% Staff costs Beverage Revenue $299,825.78 82% Other Expenses COGS $ 0.00 $ 0.00 $ 0.00 SITXFIN010 Task 2-Activity 1-Hotel Futura Budget_Forecast V2 Blank Spreadsheet futura Hotel Futura Budget Forecast Total Revenue $11,213,138.73 $ Forecast Room Budget Rooms Available Rooms Occupied Total Occupancy % Forecast $ Forecast % 63875 100% COGS 51548 Staff costs 80.70 80.7% Revenue Per Available Room $ 134.80 Other Expenses Total Expenses Total Room Revenue $6,948,897.21 $4,264,241.52 Total Catering Revenue Food Budget Total Revenue $2,019,370.53 47% Food Revenue $1,740,112.81 86% Beverage Revenue $279,257.72 14% COGS Staff costs Other Expenses Expenses Analysis $987,555.00 14% $1,201,980.00 17% $123,457.00 6% $2,312,992.00 Expenses Analysis $601,944.02 $1,122,433.24 30% 56% $121,742.75 6% Banquet Budget Expenses Analysis Total Revenue $1,313,940.16 COGS Food Revenue $876,759.95 67% Staff costs Beverage Revenue $183,736.83 14% Other Expenses $316,564.27 $476,538.08 $63,009.20 24% 36% 5% Room Service Budget Expenses Analysis Total Revenue $417,442.15 Food Revenue $335,796.64 80% COGS Staff costs Beverage Revenue $34,668.69 8% Other Expenses $105,345.38 $228,397.17 $23,233.82 25% 55% 6% Other Revenue $46,976.82 11% Mini Bar Budget Expenses Analysis Total Revenue $146,471.02 COGS $35,781.74 24% Beverage Revenue / Minibar $146,471.02 100% Staff costs $55,510.55 38% Other Revenue $ 0.00 Other Expenses $18,897.56 13% Bar Budget Expenses Analysis Total Revenue $367,017.66 COGS Food Revenue $67,191.88 18% Staff costs Beverage Revenue $299,825.78 82% Other Expenses $114,140.20 $151,731.13 $21,902.07 31% 41% 6% Other Revenue $ 0.00