I am working on the creating operating budget and cash flow budget, but I am little confused while creating Operationg Budget $($Income$/$Expenditure$).$

In an income statement under Revenue, do we need to put forecast revenue of Forecast cash flow? for example

Forecast Revenue for the quarter from room rent is

April: $100$

May: $150$

June: $200$

Forecast cash flow:

$60\%$ revenue received in the same month and $40\%$ in the following month.

Forecast Expense is $59\%$ of room revenue in the same month. I am not sure what I need to put.

And under expenses do I need to put actual expenses such as

$59\%$ of room revenue from same month or

Forecast cash outflow which is $90\%$ pain in the same month and $10\%$ in the following month.

Below is the data I have, can you help me to understand this

Dataset $46$

Forecast Revenue

Room Revenue February $$310,000$

Room Revenue March $$310,000$

Room Revenue April $$410,000$

Room Revenue May $$400,000$

Room Revenue June $$600,000$

F&B Revenue February $35\%$ of Room Revenue

F&B Revenue March $32\%$ of Room Revenue

F&B Revenue April $21\%$ of Room Revenue

F&B Revenue May $25\%$ of Room Revenue

F&B Revenue June $20\%$ of Room Revenue

Forecast Cash Inflow

$$ The estimated Room revenue received $77\%$ in the same month and $23\%$ in the following month.

$$ The estimated F&B revenue received $90\%$ in the same month and $10\%$ in the following month.

$$

ITEM Forecast Expense Forecast Cash Outflow

Room COGS Based on $59\%$ of Room Revenue in the same month $90\%$ paid in the same month and $10\%$ in the following month

F&B COGS Based on $45\%$ of F&B Revenue in the same month $90\%$ paid in the same month and $10\%$ in the following month

Salaries for admin staff $$55,000$ per year $($apportioned and expensed equally each month$)$ Paid in equal monthly amounts.

Wages for other staff Based on $5\%$ of expected total Room and F&B Revenue for the same month Paid in the same month as expense.

Advertising Based on $2\%$ of expected total Room and F&B Revenue for the same month Paid in the same month as expense.

Stationery $$3,900$ per year $($invoice received each June$)$ Paid in July.

Rent $$205,000$ per year $($apportioned and expensed each month in equal instalments$)$ Paid each month in equal amounts.

Commission paid Fixed monthly retainer of $$2,000$ and a $2\%$ commission payment based on Room Revenue from the previous month. Retainer is paid each month in equal amounts. Commission is paid in the same month as the expense.

Electricity Paid each month based on $2\%$ of expected total Room and F&B Revenue for the same month Paid in the same month as expense.

Depreciation $$75,000$ per year $($apportioned equally each month$)$

Bank charges $$4,750$ per quarter payable at the end of each March, June, September and December Quarterly payments are made at the end of each March, June, September and December

Assume the bank balance on $1$ April to be $$110,000,$ and all expenses are paid in cash as specified.

$$

BUDGETED VS ACTUAL FOR THE QUARTER

Income Budgeted

Actual Variance $

Variance $\%$

$($

Room revenue $1,460,000$

Food & beverage revenue $327,500$

Total Income

Expenses Budgeted Actual Variance $

Variance $\%$

Room COGS $1,124,800$

Food & beverage COGS $230,500$

Salaries for admin staff $24,000$

Salaries for other staff $70,950$

Advertising $36,900$

Stationery $2900$

Rent $62,500$

Commission paid $31,200$

Electricity $54,200$

Depreciation $18,750$

Bank charges $3250$

Total Expenses $1,659,950$

Profit$/($Loss$)$