please solve it as soon as possible

Part 1 and 2 Forecasting the Income Statement and the Statement of Cash Flow ABC Pty Ltd offers fishing trips along the west coast of Eyre Peninsula. ABC provided the following estimates for room revenues for the 3 months April, May and June 2020. Room Revenue Actual room revenue March $40,750 Estimated Room Revenue April $60,750 Estimated Room Revenue May 20% increase on April revenue Estimated Room Revenue June 40% increase on May revenue Cash flow The cash collected from the estimated room revenue is received 70% in the current month and 30% in the following month. Food and Beverage The food revenue is estimated to be 30% of the estimated monthly room revenue with a food COGS of 35% of the monthly food revenue The beverage revenue is estimated to be 20% of the estimated monthly room revenue with a beverage COGS of 25% of the monthly beverage revenue Cash flow All the cash from food and beverage sales is collected in the same month as the estimation, ie all of April's food and beverage cash is collected in April Schedule of other expenses Salaries for admin staff $98,400 per year (apportioned equally each month) Wages for other staff $60,000 apportioned equally from May to February Advertising 1.5% of monthly room revenue Stationery $7,200 per year (apportioned equally each month) Rent $4500 per month Commission paid 2% of monthly room revenue Electricity $84,000 per year (apportioned equally each month) Depreciation $144,000 pa (apportioned equally each month) Bank charges $6000 per quarter year (apportioned equally each month) Interest charges 4.5% of total monthly revenue Assume that the bank balance at 1 April to be $30,000 and all expenses are paid in cash as specified. Assessment 2 Page 4 BBHM209 Measuring Business Financial Performance Required Use the attached sheets to: a) Prepare a operational budget (revenue and expenses) forecast for the 3 months b) Prepare a cash flow budget forecast for the 3 months c) Show your workings