Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1.890 Beverages TOTAL REVENUE 1.095 8,826 1,296 4,662 8,180 PARTE It's the beginning of November and the following income and expenses are for October invoices
1.890 Beverages TOTAL REVENUE 1.095 8,826 1,296 4,662 8,180 PARTE It's the beginning of November and the following income and expenses are for October invoices received Patches Fruit and veg 5522 Dan Murphy's 5160 LED's Meats 5340 Olsen Laundry $400 0 1,754 1,500 1,500 0 0 EXPENSE Overhead Stock Lease Insurance Repairs/ maintenance Advertising Electricity Laundry Wages Miscellaneous TOTAL EXPEND 0 1,554 1,500 700 400 200 2,200 300 1,180 1,500 700 380 200 2,200 500 Receipts. Costco 400 200 200 5178 0 800 3,300 2,048 2.800 1,700 500 290 500 700 4 8,880 10,260 7,812 -2,835 -5,598 Cash on hand: start Cash on hand: end 9,978 7,143 11,534 5,836 878 7,143 8,021 4 Credit Card Payments (guests): c. James 5590 300 Food 230 Bey 60 F. Duniceria $1140 WADADA Apoom 600 Food 420 Bey 120 M. Tan $792 450 FOOG 286 Bey 56 1. Kelly $1074 Appam 300 Food 410 Bey 364 L. Keen 5760 Apoom 450 FOOG 310 Bey O 6. Smith 5214 Food 214 ii) 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 last two months have seen some changes. There was a major hal storm in the area which caused damage to one of the cabins. The stom caused a lot of damage and the cabin has been uninhabitable for 5 weeks across September and October. The occupancy rate has dropped to paid our company is paying for the majority of the damage but $5,000 ww need to be 1) Use the information above to update the budget in the blank cells. September September October Budget Actual Budget Ootober Actual INCOME Accommodation Food 2,940 2,028 1,228 3,780 2,520 1,890 1.890 Beverages TOTAL REVENUE 1.095 8,826 1,296 4,662 8,180 PARTE It's the beginning of November and the following income and expenses are for October invoices received Patches Fruit and veg 5522 Dan Murphy's 5160 LED's Meats 5340 Olsen Laundry $400 0 1,754 1,500 1,500 0 0 EXPENSE Overhead Stock Lease Insurance Repairs/ maintenance Advertising Electricity Laundry Wages Miscellaneous TOTAL EXPEND 0 1,554 1,500 700 400 200 2,200 300 1,180 1,500 700 380 200 2,200 500 Receipts. Costco 400 200 200 5178 0 800 3,300 2,048 2.800 1,700 500 290 500 700 4 8,880 10,260 7,812 -2,835 -5,598 Cash on hand: start Cash on hand: end 9,978 7,143 11,534 5,836 878 7,143 8,021 4 Credit Card Payments (guests): c. James 5590 300 Food 230 Bey 60 F. Duniceria $1140 WADADA Apoom 600 Food 420 Bey 120 M. Tan $792 450 FOOG 286 Bey 56 1. Kelly $1074 Appam 300 Food 410 Bey 364 L. Keen 5760 Apoom 450 FOOG 310 Bey O 6. Smith 5214 Food 214 ii) 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 last two months have seen some changes. There was a major hal storm in the area which caused damage to one of the cabins. The stom caused a lot of damage and the cabin has been uninhabitable for 5 weeks across September and October. The occupancy rate has dropped to paid our company is paying for the majority of the damage but $5,000 ww need to be 1) Use the information above to update the budget in the blank cells. September September October Budget Actual Budget Ootober Actual INCOME Accommodation Food 2,940 2,028 1,228 3,780 2,520 1,890
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started