Its the beginning of November and the following income and expenses are for October Invoices received Patches Fruit and Veg $522 Dan Murphys $160 Lamans Meats $340 Olsen Laundry $400 Receipts Costco $178 Credit Card Payments (guests) C James $590 Accom 300 Food 230 Bev 60 F Dunkertin $1140 Accom 600 Food 420 Bev 120 M Tan $792 Accom 450 Food 286 Bev 56 J Kelly $1074 Accom 300 Food 410 Bev 364 L Keen $760 Accom 450 Food 310 Bev 0 B Smith $214 Food 214 The last two months have seen some changes There was a major hail storm in the area which caused damage to one of the cabins The storm caused a lot of damage and the cabin has been uninhabitable for 5 weeks across September and October The occupancy rate has dropped to 69 The insurance company is paying for the majority of the damage but $5,000 will need to be paid out of pocket Use the information above to update the budget in the blank cells September Budget September Actuals October Budget October Actuals INCOME Accommodation 2,940 2,028 3,780 Food 1,890 1,228 2,520 Beverages 1,995 1,296 1,890 TOTAL REVENUE 6,825 4,552 8,190 EXPENSES Overhead 0 0 0 0 Stock 1,554 1,180 1,764 Lease 1,500 1,500 1,500 1,500 Insurance 700 700 0 0 Repairs maintenance 400 380 400 Advertising 200 200 200 200 Electricity 2,200 2,200 0 0 Laundry 800 500 800 Wages 1,706 3,300 2,048 2,800 Miscellaneous 600 290 600 700 TOTAL EXPEND 9,660 10,250 7,312 2,835 5,698 878 Cash on hand start 9,978 11,534 7,143 Cash on hand end 7,143 5,836 8,021 Create a report outlining the cash flow and submit it to your assessor with an explanation of how you might recover from the deficit this month Make at least two recommendations for cash recovery in September October

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 21, 2024

Its the beginning of November and the following income and expenses are for October. Invoices received: Patches Fruit and Veg $522 Dan Murphys $160 Lamans

Its the beginning of November and the following income and expenses are for October.

Invoices received:

Patches Fruit and Veg	$522
Dan Murphys	$160
Lamans Meats	$340
Olsen Laundry	$400

Receipts:

Costco

$178

Credit Card Payments (guests):

C. James	$590
Accom	300
Food	230
Bev	60
F. Dunkertin	$1140
Accom	600
Food	420
Bev	120
M. Tan	$792
Accom	450
Food	286
Bev	56
J. Kelly	$1074
Accom	300
Food	410
Bev	364
L. Keen	$760
Accom	450
Food	310
Bev	0
B. Smith	$214
Food	214

The last two months have seen some changes. There was a major hail storm in the area which caused damage to one of the cabins. The storm caused a lot of damage and the cabin has been uninhabitable for 5 weeks across September and October. The occupancy rate has dropped to 69%. The insurance company is paying for the majority of the damage but $5,000 will need to be paid out of pocket.

Use the information above to update the budget in the blank cells.

	September Budget	September Actuals	October Budget	October Actuals
INCOME
Accommodation	2,940	2,028	3,780
Food	1,890	1,228	2,520
Beverages	1,995	1,296	1,890
TOTAL REVENUE	6,825	4,552	8,190

EXPENSES
Overhead	0	0	0	0
Stock	1,554	1,180	1,764
Lease	1,500	1,500	1,500	1,500
Insurance	700	700	0	0
Repairs/maintenance	400	380	400
Advertising	200	200	200	200
Electricity	2,200	2,200	0	0
Laundry	800	500	800
Wages	1,706	3,300	2,048	2,800
Miscellaneous	600	290	600	700
TOTAL EXPEND.	9,660	10,250	7,312

+/-	-2,835	-5,698	878
Cash on hand: start	9,978	11,534	7,143
Cash on hand: end	7,143	5,836	8,021

Create a report outlining the cash flow and submit it to your assessor with an explanation of how you might recover from the deficit this month. Make at least two recommendations for cash recovery in September/October.