HRTM3203 Hotel & Hospitality Management

Assignment Due Date: November 23, 2021, at 3pm (Vancouver Time) You are planning to open a restaurant and investing a substantial amount of capital to this restaurant project. You want to have a return of investment (ROI) within five years. To run your business, you will be required to use the labor for your back of the kitchen and front of the house operations. You also need to have other disposable costs that are required to run your business smoothly. Your revenue would be generated from food, beverage, and other revenues such as selling restaurant branded products (e.g., souvenir and prepared bottled/can foods). For this assignment you have been provided a Master Worksheet (excel sheet) as an example. On the master worksheet you are required to plug-in the assumed numbers for 1st, 2nd, and 3rd years according to your business objectivity to prepare a Proforma of Cash Flow Statement, Three Year Income Projection sheet, and Balance sheet. Please submit your Excel sheet along with a statement of report separately. Report Writing Requirements You may consider writing argumentative the report by answering the following questions: • Why did you change the number of covers or why did not? • Why did increase or not increase the salary or wages for your staffs for second year, third year or kept it same for the three years consecutively. • Why did you make revenue for very quarter or making less revenue for previous quarter in relation to each year and so? • Why there are differences for every year quarters revenue? • Why do you want to change the food cost, beverage cost, other cost every year or you do not want the changes? • Provide justification for your proforma statement, Three years income statements, and balance sheet. Adhere the following format while preparing your statement of report • Prepare a report that should not be 500 words. • 12-point font double-spaced and font type: Times New Roman. • No TYPOS or spelling errors. • The report must include a title page, table of contents, introduction, results from your excel sheet for year one, two, and three, and conclusion for your projected business in a critically reflected manner.