logo

Assignment on Prepare and Monitor Budgets

   

Added on  2020-04-21

13 Pages2822 Words8 Views
Running head: PREPARE AND MONITOR BUDGETSPrepare and Monitor BudgetsName of the Student:Name of the University:Author’s Note:Course ID:
Assignment on Prepare and Monitor Budgets_1
1PREPARE AND MONITOR BUDGETSTable of ContentsTask 1:.............................................................................................................................................2Task 2:.............................................................................................................................................6Task 3:.............................................................................................................................................8Scenario 1:.......................................................................................................................................8Scenario 2:.....................................................................................................................................10Scenario 3:.....................................................................................................................................12a. Increment in kitchen/Food cost variance:..................................................................................12b1. Depicting the reports that need to be prepared:.......................................................................12b2. Depicting the essential authorities that need to be addressed before conducting such matters:.......................................................................................................................................................13b3. Suggesting option to address and rectify the issue:.................................................................13b4. Depicting the ways in which cash flow issue could be addressed:..........................................13References and Bibliographies:.....................................................................................................14
Assignment on Prepare and Monitor Budgets_2
2PREPARE AND MONITOR BUDGETSTask 1:2016Forecasted201720162017Amount(%)Amount(%)Expenses analysisTotalRevenue$11,212,911.92 $13,294,174.35 RoomBudgetCOGS $987,555.00 14% $1,103,760.00 15%Roomsavailable63,875 100%61,320 96%Staffcost $1,201,980.00 17% $1,471,680.00 20%Roomsoccupied51,548 49,056 Otherexpenses $123,457.00 1.78% $588,672.00 8%Totaloccupancy80.70%80.70%80%80%Totalexpenses $2,312,992.00 $3,164,112.00 Revenue peravailableroom$134.80 $150.00 Total roomrevenue$6,948,670.40 $7,358,400.00 TotalCateringrevenue$4,264,241.52 $5,935,774.35 FoodbudgetExpenses analysisTotalrevenue$2,019,370.53 47%$2,302,728.07 39%COGS $601,944.02 30% $690,818.42 30%FoodRevenue$1,740,11286%$2,001,1287%Staffcost $1,122,56% $1,013,44%
Assignment on Prepare and Monitor Budgets_3
3PREPARE AND MONITOR BUDGETS.81 9.73 433.24 200.35 Beveragerevenue$279,257.72 14%$301,598.34 13%Otherexpenses $121,742.75 6% $161,190.96 7%BanquetbudgetExpenses analysisTotalrevenue$1,313,940.16 $2,574,982.83 COGS $316,564.27 24% $669,495.54 26%FoodRevenue$876,759.95 67%$2,000,000.00 78%Staffcost $476,538.08 36% $489,246.74 19%Beveragerevenue$183,736.83 14%$321,539.45 12%Otherexpenses $63,009.20 5% $360,497.60 14%otherrevenue$253,443.38 19%$253,443.38 10%RoomServicebudgetExpenses analysisTotalrevenue$417,442.15 $467,811.65 COGS $105,345.38 25% $121,631.03 26%FoodRevenue$335,796.64 80%$386,166.14 83%Staffcost $228,397.17 55% $159,055.96 34%Beveragerevenue$34,668.698%$34,668.69 7%Otherexpenses $23,233.82 6% $65,493.63 14%otherrevenue$46,976.8211%$46,976.82 10%Mini BarbudgetExpenses analysisTotalrevenue$146,471.02 $146,471.02 COGS $35,781.74 24% $35,153.04 24%Beveragerevenue$146,471.02 100%$146,471.02 100%Staffcost $55,510.55 38%otherOther $13% $13
Assignment on Prepare and Monitor Budgets_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Budgeting for Hotel Futura: Revenue and Expense Forecast
|11
|1982
|139

Preparing and Monitor Budget Tool for an Organisation
|13
|3562
|218

Repot on Hospitality in Hotel Futura
|12
|2328
|97

(Docx) Unit 2 Managing Financial Resources Sample Assignment
|5
|679
|39

Accounting for Business: Financial Statements Analysis and Ratios
|10
|1056
|476

Managing Ffinances And Cash Flow Statement
|5
|531
|23