THE HOME OF WRITERS, Get Assignment Writing Help: Task 1-Hotel Futura Budget

ASSESSMENT COVERSHEET – ASSESSMENT 2
Assessment Title Assessment 2 – Collection of Tasks
Student Name
Assessor Name
I declare that this assessment is a product of all my own work:
Student’s Signature Date
Student feedback:
No The student is able to demonstrate knowledge of / skills in: Attempt 1 Attempt 2
Yes No Yes No
Part 1 Draft Budget 1
Draft Budget 2
Draft Budget 3
Draft Budget 4
Draft Budget 5
Draft Budget 6
Part 2 Calculation 1
Calculation 2
Calculation 3
Calculation 4
Calculation 5
Calculation 6
Calculation 7
Calculation 8
Print 9
Print 10
Part 3 Scenario 1
Scenario 2
Scenario 3
Sufficient evidence provided? Yes No
Assessor Feedback
Assessor’s signature Date
Date for resubmission / demonstration: __________________
Assessment 2 – Collection of Tasks
Task
The assignment for Assessment 2 consists of 3 Tasks
Task 1
Requires you to prepare a draft budget following a meeting with all heads of department where you have finalised the details and requirements to be included for next year’s budget.
Task 2
Requires you to prepare a final budget, based on the changes made to your draft budget following a management meeting.
Task 3
Requires you to respond to 3 financial scenarios.
Assessment Requirements
To successfully complete this assignment you need:
• Computer with Microsoft excel
• Calculator
• Spread Sheets:
? “Task 1-Hotel Futura Budget_Forecast”
? “Task 2-Budget Futura_Restaurant_Bar”
To successfully complete this assignment you must:
o Complete all questions with satisfactory answers
o Submit by the due date to your assessor/trainer.
Format of presentation:
o Ensure report is word/excel (where applicable) processed on A4 pages in 12 Calibri font
o APA Referencing is mandatory: http://guides.dtwd.wa.gov.au/southwest-apa
o State your full name and unit code & name in the footnote of the document/spreadsheet
o Please submit by e-mail as an excel/word document named as per below guidelines;
o SIT50416 Diploma Of Hospitality Management - SITXFIN004 Prepare and monitor budgets - Assessment 2- YOUR NAME
o Assessment Coversheet must be e-mailed with student feedback & signature. Scanned assessment coversheet named as per below guidelines;
o SIT50416 Diploma Of Hospitality Management - SITXFIN004 Prepare and monitor budgets - Assessment 2 Coversheet- YOUR NAME
o Responses to all questions must be submitted in digital form, except when students are granted permission to submit responses in other forms in line with the TAFE’s reasonable adjustment policy.
o Students must sign a student coversheet stating that the responses provided are the product of their own work. This will support the authenticity of the evidence.
o No marks or grades are allocated for this assessment task only as Satisfactory or Not Satisfactory.
Date Due:
Task 1
Your Tasks:
You are required to complete a draft budget based on information and factors that were determined during an executive meeting at Hotel Futura.
A. Access the excel spreadsheet named “Task 1-Hotel Futura Budget_Forecast”. The first tab on this spreadsheet is labelled “Departments Small” and shows the existing budget figures for the 2017 financial year.
B. Use the template “Draft Budget” on the second tab of the spreadsheet and perform the calculations below using basic formulas.
Your forecast needs to include the Dollar Figures and the % values for these affected by changes outlined below.
The % values must be listed for each expense item shown in the Expenses Analysis for each department.
You have met with the department heads of Hotel Futura and the following details have been discussed to prepare your draft budget for 2017:
1. Rooms Division:
a. Due to renovations the rooms available have been reduced to 96%.
b. The forecasted occupancy rate has been adjusted to 80%.
c. The revenue per available room needs to be increased to $150.00
d. The COGS will increase to 15% of total room revenue
e. Staff costs need to be increased to 20% of total room revenue to allow for increases in superannuation and awards.
f. Other Expenses need to increase to 8% of total room revenue to cover electricity price rises.
2. Catering:
a. The food revenue will be increased by 15% due to a new marketing campaign and specialty menus
b. The beverage revenue will increase by 8%.
c. Staff costs need to be adjusted to 44% of the food budget.
d. Other Expenses will need to be increased to 7%.
3. Banquet:
The Banquet Division will be directly affected by the new marketing campaign which has been directed at daytime seminars and corporate functions. For this purpose the kitchen has received specialised equipment including multiple combi steamers, hold-o-mats and sous-vide equipment.
a. The new food revenue budget was set at $ 2,000,000.00 ($2 Million) and the beverage revenue was increased by 75%.
b. The COGS will increase to 26%.
c. The staff costs have been reduced to 19%.
d. Other Expenses will need to increase to 14%.
4. Room Service:
a. The room service revenue from food needs to be increased by 15%.
b. Due to a different system to clear floors and organise delivery, the staff costs will be reduced to 34%.
5. Mini Bar:
The mini bar budget remains unchanged and increased staff costs are absorbed through different processes.
6. Bar Budget:
a. The food revenue budget has been increased by 25% with the implementation of a Tapas Menu.
b. The Beverage Revenue budget has been increased 20% with the introduction of a new cocktail bar and happy hour specials.
c. Staff costs will need to be adjusted to 36%.
d. Other Expenses need to be increased to 18%.
Task 2
Your Tasks:
You have provided the chief financial controller with the draft budget for 2017. Following the recent executive meeting where the draft budget was discussed, you are now required to establish the final budget reflecting the changes based on the latest actuals and variances as well as major road works which will affect Futura Restaurant and Bar during 2017.
A. Access the excel spread sheet named “Task 2-Budget Futura_Rest.&Bar”. The first tab on this spreadsheet is labelled “Futura Restaurant and Bar” and shows the Draft budget figures for the 2017 financial year.
B. Use the template “Revised Budget” on the second tab of the spreadsheet and perform the calculations below using basic formulas based on the following changes:
Month Customer numbers Average Spend (Food) Average Spend (Beverage)
January 1850 $ 45.00 $ 9.70
February 2000 $ 37.00 $ 9.70
March 700 $ 42.00 $ 9.70
April 1200 $ 48.00 $ 9.70
May 1200 $ 36.50 $ 9.70
June 600 $ 35.00 $ 9.70
July 950 $ 34.00 $ 9.70
August 800 $ 38.00 $ 9.70
September 900 $ 29.00 $ 9.70
October 650 $ 29.50 $ 9.70
November 980 $ 35.50 $ 9.70
December 2200 $ 48.00 $ 9.70
1. Calculate the anticipated Food revenue for each month and the yearly total.
2. Calculate the anticipated Beverage revenue per month and the yearly total.
3. Calculate the Total Revenue for each month and the yearly total.
4. Calculate the overheads total for each month (at 90% of turnover for each for each month with 1000 or more customers and at 96% for each month with less than 1000 customers) and the yearly total.
5. Calculate the profit for each month and the yearly total.
6. Calculate the Cost of Goods Sold for food and beverages, given a combined percentage of 32%.
7. Calculate the staff costs for each month at 31% for each month with 1000 or more customers and at 35% for each month with less than 1000 customers.
8. Calculate the ‘Other overheads” for the operation.
9. Print a copy of the revised budget.
10. Print the revised budget showing all formulae used.
Task 3
Your Tasks:
Read the following 3 scenarios and answer the questions attached for each scenario.
Scenario 1:
The finance team has created budget forecasts for Hotel Futura based on carefully researched factors for the last 3 years and these were always very accurate. The recent budget which included all departments of the hotel was implemented 3 months ago and the forecasted figures for Food Cost and COGS/Beverages in both the Restaurant and the Bar Operations have blown out by nearly 4.5 percent.
What could be the reasons for this? List 5 examples of areas you would investigate and explain why.
Scenario 2:
Hotel Futura has successfully operated for 7 years. During this period, overall turnover has doubled, and during the past 3 budget periods annual budgets have been increased by 15% each year which was exceeded each time. During the last 6 months however, management has noticed that the opposite trend seems to be occurring now.
List 5 external factors which could contribute to this and explain which methods you would use to determine this.
Scenario 3:
You have successfully negotiated the draft budget with each department head of the Hotel which has now been approved by the director and implemented 6 weeks ago.
You have finalised the financial data of the Hotel for the next management meeting and noticed the following:
a.
Department Budget Actual Variance
Kitchen/Food Cost 28% 32% (-)$ 13467
b. The recently appointed F&B Manager has purchased 240 bottles of Hill of Blessings @ $90 each which represents a saving of $30 per bottle. However this exceeds the par stock level by 220 bottles and has created a cashflow problem, given the negative performance of the kitchen during this period as well.
1. Which reports would you need to prepare for these issues?
2. Who is it essential to involve when these matters need to be discussed?
3. Suggest options to address and rectify these issues.
4. How could the cashflow issue be addressed?
ASSESSMENT COVERSHEET – ASSESSMENT 3
Assessment Title Assessment 3 – Project
Student Name
Assessor Name
I declare that this assessment is a product of all my own work:
Student’s Signature Date
Student feedback:

No The student is able to demonstrate knowledge of / skills in: Attempt 1 Attempt 2
Yes No Yes No
Task Question/Action 1
Question/Action 2
Question/Action 3
Question/Action 4
Question/Action 5
Question/Action 6
Question/Action 7
Sufficient evidence provided? Yes No
Assessor Feedback
Assessor’s signature Date
Date for resubmission / demonstration: __________________
Assessment 3 – Project
Task
The assignment for Assessment 3 consists of 3 Tasks
The purpose of this assessment is to assess your ability to complete tasks outlined in elements and performance criteria of this unit in the context of the job role, and:
• prepare a budget for a business that meets the specific business’ needs
• demonstrate the following when preparing the above budget:
o consultation on components
o analysis of factors that impact on the budget
o completion of draft and final versions of budget within designated timelines
• monitor and review the above budget against performance over its life cycle.
Assessment Requirements
To successfully complete this assignment you need access to:
1. Computers, printers and accounting software packages
2. Gather & Feast Events financial and operational data and reports used to prepare budgets
3. Others with whom the individual can discuss, and negotiate draft and final budget components
To successfully complete this assignment you must:
o Complete all questions with satisfactory answers
o Submit by the due date to your assessor/trainer.
Format of presentation:
o Ensure report is word/excel (where applicable) processed on A4 pages in 12 Calibri font
o APA Referencing is mandatory: http://guides.dtwd.wa.gov.au/southwest-apa
o State your full name and unit code & name in the footnote of the document/spreadsheet
o Please submit by e-mail as an excel/word document named as per below guidelines;
o SIT50416 Diploma Of Hospitality Management - SITXFIN004 Prepare and monitor budgets - Assessment 3- YOUR NAME
o Assessment Coversheet must be e-mailed with student feedback & signature. Scanned assessment coversheet named as per below guidelines;
o SIT50416 Diploma Of Hospitality Management - SITXFIN004 Prepare and monitor budgets - Assessment 3 Coversheet- YOUR NAME
o Responses to all questions must be submitted in digital form, except when students are granted permission to submit responses in other forms in line with the tafe’s reasonable adjustment policy.
o Students must sign a student coversheet stating that the responses provided are the product of their own work. This will support the authenticity of the evidence.
o No marks or grades are allocated for this assessment task only as Satisfactory or Not Satisfactory.
Date Due:
Assessment 3 Event/Operational plan Project
Task
Prepare a budget for either one of your events or alternatively as part of your unit manage Operational plan that meets the specific business’ needs.
Business Name: ______________________________________________
Supervisor/Manager: ______________________________________________
Business Address: ______________________________________________
Type of Operation: ______________________________________________
Type of Budget: ______________________________________________
Budget Period: ______________________________________________
Budget Data provided on: G&F Budget Semester 1 & Management Report (example)
Budget Data attached 1
Draft Budget Due:
Final Budget Due:
I herewith confirm that I have received all data and information to enable me to complete the assessment task outlined in this document.
Student Signature: __________________________ Date: ________________________________
Instructions
Based on the type of budget and data provided to you, you are required to:
1. Consult with the relevant staff directly affected by the budget on the components to be included in the budget.
This requires a written report of the details that were discussed including a detailed analysis of the factors that impact on the particular budget.
? Use G&F Budget Consultation Process Template
2. Following your consultation, you are required to complete a draft budget which reflects the details you have provided in your report.
? Use G&F Opening Budget Template (G&F Business Tools Spreadsheet)
3. Present the draft budget to the staff you consulted on the budget components. Provide details of feedback and changes that were requested. This needs to include the why’s and how’s.
? Use G&F Budget Consultation Process Template
4. Based on the feedback received, complete the final budget. Obtain approval of the relevant department head(s), financial officer or person in charge of the organisation. Attach a copy and the signed, approved budget.
5. Monitor the budget against performance at intervals as instructed, this may be e.g. weekly or monthly and include the relevant reports and actions taken for each review during the budget cycle.
6. Each change/actioned taken as a result of underperformance must be documented in the variance column of your profit & loss statement per event and signed by your lecturer.
7. On completion of the budget cycle, provide a summary report for the budget performance. What are your recommendations for the next cycle based on your monitoring and reviews? Why?
Q Assessment Criteria S NYS S NYS Comments
1 Consultation
The consultation includes individuals relevant to the budget
The scope of the budget is discussed 0
0
0
0
The budget factors have been analysed 0
0
0
0
The scope of the budget has been confirmed 0
0
0
0
The report provides concise details of the consultation process:
Requirements for each budget factor
Analysis of each budget factor
Clear communication strategy for each factor
Summarised requirements and changes agreed
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2 Draft Budget
The draft budget is prepared correctly 0
0
0
0
Each factor is reflected in the draft budget 0
0
0
0
The income and expenditure is supported by valid information 0
0
0
0
The organisational objectives are reflected in the draft budget 0
0
0
0
The recommended and agreed changes are outlined in the draft budget 0
0
0
0
3 Present Draft Budget
The draft budget is presented to the relevant parties 0
0
0
0
The budget components are reviewed 0
0
0
0
Required changes are negotiated and documented 0
0
0
0
The final changes are approved by an authorised person
4 Prepare Final Budget
The final budget is prepared within agreed timeframes 0
0
0
0
All negotiated details are reflected in the final budget 0
0
0
0
The budget data is correct 0
0
0
0
The final format for the budget is professional to industry standard 0
0
0
0
The final budget is approved and signed 0
0
0
0
5 Monitoring Budget
The budget performance is monitored according to the agreed intervals 0
0
0
0
The performance of each component is reflected in the relevant reports:
Report 1: ___________________________ Date:
Report 2: ___________________________ Date:
Report 3: ___________________________ Date:
Report 4: ___________________________ Date:
Report 5: ___________________________ Date:
Report 6: ___________________________ Date:
0
0
0
0
All under-over performances have been identified correctly 0
0
0
0
6 Reviewing Budget performance targets
Actions have been suggested where deviations have been identified 0
0
0
0
The recommended actions are relevant 0
0
0
0
The recommended actions are realistic given operational aspects 0
0
0
0
Where relevant, internal factors affecting budget performance are analysed 0
0
0
0
Where relevant, external factors affecting budget performance are analysed 0
0
0
0
Changes of internal and external factors analysed are reflected in changes to the budget 0
0
0
0
Where changes are made, these are communicated to all relevant parties 0
0
0
0
Actioned changes to the budget are approved by authorised staff 0
0
0
0
7 Evaluation of Budget
The budget is evaluated reflecting performance 0
0
0
0
The budget is evaluated using feedback from relevant staff 0
0
0
0
The changes made during the cycle are reflected in the evaluation report 0
0
0
0
Suggestions are provided for future improvements, reflected in the summary report 0
0
0
0