I have to create an operating budget $($Income Expenditure$)$ and cash flow budget witth the below data, but I have few questions and I am super confused. Can you help me answer my questions?

Question

$1$: When creating a budgeted vs actual Income$/$Expenses for the quarter, do we only include data from April May June, since April is the new quarter?

$2$: When creating an income and expenses, to calculate the total revenue, do we use the income from the forecast revenue from the given month, for example

April has $410,000$ or do we use the revenue received for the same month$(77\%$ in the same month and $23\%$ in the following month$)$ and use remaining $\%$ as a part of

revenue for the following month?

$3$: while calculating expenses, do we calculate the revenue from the amount received in the same month? for example

Room COGS says $59\%$ of Room Revenue in the same month, so shall we do $59\%$ of $410,000$ or $59\%$ of $315,700(0\mathrm{.}77*410,000)?$

$4$:under the expense, shall we put $0\%$ of the room revenue as a part of the given month's expenses and put $10\%$ as part of the following month's expenses or shall we put $100\%$ of expenses in the given month?

Below is the data

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$)$