I have one question, I am creating an operating budget $($Income and Expnediture$)$ and I am lil bit conufsed.

when I am creating the Total Income, do I have to include the total income of the month or income recieved, like $60\%$ in the same month and $40\%$ in the follwing montDataset $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.

$$

Revenue for Quarter $($April to June$)$:

Room Revenue:

o April: $410,000$

o May: $400,000$

o June: $600,000$

Total Room Revenue for the Quarter $=1,410,000$

F&B Revenue $=$ Percentage of Room Revenue

o April: $21\%$ of $410,000=86,100$

o May: $25\%$ of $400,000=100,000$

o June: $20\%$ of $600,000=120,000$

Total F&B Revenue for the Quarter $=306,100$

Total Income for the Quarter $($Room $+$ F&B$)=1,716,100$

Expenses for Quarter $($April to June$)$:

Room COGS: $59\%$ of Room Revenue in the same month

o April: $59\%$ of $410,000=241,900$

o May: $59\%$ of $400,000=236,000$

o June: $59\%600,000=354,000$

F&B COGS: $45\%$ of F&B Revenue in the same month

o April: $45\%$ of $86,100=38,745$

o May: $45\%100,000=45,000$

o June: $45\%120,000=54,000$

Salaries for admin staff: $55,000$ per year, expensed equally each month.

o Monthly: $55,000/12=4,583$

BUDGETED VS ACTUAL FOR THE QUARTER

Income Budgeted

$($April$/$May$/$June$)$ Actual Variance $

Actual $-$ Budgeted Variance $\%$

$($Variance$/$budgeted$)*100$

Room revenue $1,410,0001,460,00050,0003\mathrm{.}54\%$

Food & beverage revenue $306,100327,50021,4006\mathrm{.}99\%$

Total Income $1,716,1001,787,50071,4004\mathrm{.}16\%$

Expenses Budgeted Actual Variance $

Actual $-$ Budgeted Variance $\%$

$($Variance$/$budgeted$)*100$

Room COGS $671,6101,124,800453,19067\mathrm{.}48\%$

Food & beverage COGS $118,616230,500111,88494\mathrm{.}32\%$

Salaries for admin staff $13,75024,00010,25074\mathrm{.}55\%$

Salaries for other staff $85,80570,950-14,855-17\mathrm{.}31\%$

Advertising $34,32236,9002,5787\mathrm{.}51\%$

Stationery $029002,900100\%$

Rent $51,25062,50011,25021\mathrm{.}95\%$

Commission paid $28,40031,2002,8009\mathrm{.}86\%$

Electricity $34,32254,20019,87857\mathrm{.}91\%$

Depreciation $18,75018,75000\%$

Bank charges $4,7503250-1,500-31\mathrm{.}58\%$

Total Expenses $1,061,5751,659,950598,37556\mathrm{.}37\%$

Profit$/($Loss$)654,525126,550-527,975-80\mathrm{.}67\%$h