Ivanka Trump after moving to P

Ivanka Trump after moving to Pakisatan and has purchase PC hotelKarachi in November 2020 and renamed it Ivayana. The hotel is a 5star luxury hotel consisting of 100 single rooms 70 double roomsand 40 Suites. The average night stay in a single room costs Rs8000. Double bed cost Rs 19000 and suite costs Rs 35000. On average70 single rooms, 60 double rooms and 35 suites are occupied.Besides, there are 4 ball rooms. The ball rooms are alwaysavailable for booking but they only get booked on Saturdays andSundays. Each ball room has capacity of 300 people and rentalcharged for each booking is RS 130,000. 10 Rooms in each categoryare paid by credit card. The payment is received a week later. 50%amount related to ball room are received in same month and 50% innext month. The rental charge for ball rooms was Rs 100,000 in2020. The charge for rooms has not changes since last year and haveremained same. The hotel is charged local tax of Rs 5000 each weekwhich is paid in the same month. The hotel has a staff of 150people. 30 kitchen staff which receive 18% of the amount receivedagaints the bill charged for the meals. On average the kitchenstaff receive 90 orders for meal with the average billing of Rs8000 per meal. the amount of meals billed is immediately collectedand the kitchen staff is paid in the 1st week of nextmonth. The room service and the janitorial satff are 40 which arepaid Rs 18000/month at last day of same month. 10 is the num ofother lower staff for misc services and they are paid 15000/monthat last day of same month. The remainig 20 are the senior executivestaff, their remuniration details are not shared. The hotel ispowered by solar panels and the, its maintenance is outsourced to acompany solarex, they charge Rs 200,000 quarterly, which is paid in2 installments. 50% is paid in the 1st month of quarterand the rest is paid in the last month of quarter. The opening cashin hand was Rs 100,000.

Prepare Cash budget for the 1st quarter of 2021.              (PLO 2.1, CLO1)                               13 marks

Hint: Consider reviewing the actual calendar for 2021.

Answer:

Answer
5 Star Hotel
Particulars Singlerooms Doublerooms Suites
No.of Rooms 100 70 40
Single day cost 8000 19000 35000
Occupied 70 60 35
Revenue 560000 1140000 1225000
Credit Card (10Rooms) 80000 190000 350000
Cash 480000 950000 875000
on an average quarter has 90days
Revenue for theQuarter
Cash 43200000 85500000 78750000
Credit Card (For 83 days) 6640000 15770000 29050000
Credit Card (For 7 days lastQuarter) 56000 133000 245000
49896000 101403000 108045000
Ball Room
Has the capacity of 300 and onlyfilled on Saturdays and sundays
There are nearly 12 weeks in aquarter
So there are 12 saturdays and sundaysare there
So total no of bookings 24
So monthly bookings 8
50% received in the same month andremaining 50% will be received in the next month
Only two months amount received duringthe quarter
Amount received for the currentquarter 8*2*130000
2080000
Amount received during the quarterrelating last quarter 8*1*100000
800000
Ball rooms Rent received 2880000
LocalTaxes
5000 each work which is paid in thesame month 60000
StaffSalaries
Kitchen Staff-30
18% of the amount received againts thebill charged for the meals
On average the kitchen staff receive90 orders for meal with the average billing of Rs 8000 permeal
Monthly Kitchen Billing 720000
quarter Billing 2160000
Staff Salary 388800
even though it will be paid in the 1stweek of next month.
The last month of previous quartersalaries will be paid in the 1st week of currentQuarter
Room service and thejanitorial satff -40
Per month Salary 18000
Per quarter Salary 54000
Total room staff salary 2160000
Lower Staff -10
Per month Salary 15000
Per quarter Salary 45000
Total room staff salary 450000
Maintenance of SolarPanels
Per quarter 200000
Opening Cash 100000
Cash Received from Rooms 259344000
Ball rooms 2880000
ExpensesPaid
Kitchen Staff -30 388800
Room service and the janitorial satff-40 2160000
Lower Staff – 10 450000
Maintenance of SolarPanels 200000
Cash at the end of theQuarter 259125200

 
"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"
Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with brilliantassignmenthelp.com
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
Close

Sometimes it is hard to do all the work on your own

Let us help you get a good grade on your paper. Get professional help and free up your time for more important courses. Let us handle your;

  • Dissertations and Thesis
  • Essays
  • All Assignments

  • Research papers
  • Terms Papers
  • Online Classes