Question

In: Finance

Ivanka Trump after moving to Pakisatan and has purchase PC hotel Karachi in November 2020 and...

Ivanka Trump after moving to Pakisatan and has purchase PC hotel Karachi in November 2020 and renamed it Ivayana. The hotel is a 5 star luxury hotel consisting of 100 single rooms 70 double rooms and 40 Suites. The average night stay in a single room costs Rs 8000. Double bed cost Rs 19000 and suite costs Rs 35000. On average 70 single rooms, 60 double rooms and 35 suites are occupied. Besides, there are 4 ball rooms. The ball rooms are always available for booking but they only get booked on Saturdays and Sundays. Each ball room has capacity of 300 people and rental charged for each booking is RS 130,000. 10 Rooms in each category are paid by credit card. The payment is received a week later. 50% amount related to ball room are received in same month and 50% in next month. The rental charge for ball rooms was Rs 100,000 in 2020. The charge for rooms has not changes since last year and have remained same. The hotel is charged local tax of Rs 5000 each week which is paid in the same month. The hotel has a staff of 150 people. 30 kitchen staff which receive 18% of the amount received againts the bill charged for the meals. On average the kitchen staff receive 90 orders for meal with the average billing of Rs 8000 per meal. the amount of meals billed is immediately collected and the kitchen staff is paid in the 1st week of next month. The room service and the janitorial satff are 40 which are paid Rs 18000/month at last day of same month. 10 is the num of other lower staff for misc services and they are paid 15000/month at last day of same month. The remainig 20 are the senior executive staff, their remuniration details are not shared. The hotel is powered by solar panels and the, its maintenance is outsourced to a company solarex, they charge Rs 200,000 quarterly, which is paid in 2 installments. 50% is paid in the 1st month of quarter and the rest is paid in the last month of quarter. The opening cash in hand was Rs 100,000.

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

Hint: Consider reviewing the actual calendar for 2021.

Solutions

Expert Solution

Answer
5 Star Hotel
Particulars Single rooms Double rooms 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 90 days
Revenue for the Quarter
Cash 43200000 85500000 78750000
Credit Card (For 83 days) 6640000 15770000 29050000
Credit Card (For 7 days last Quarter) 56000 133000 245000
49896000 101403000 108045000
Ball Room
Has the capacity of 300 and only filled on Saturdays and sundays
There are nearly 12 weeks in a quarter
So there are 12 saturdays and sundays are there
So total no of bookings 24
So monthly bookings 8
50% received in the same month and remaining 50% will be received in the next month
Only two months amount received during the quarter
Amount received for the current quarter 8*2*130000
2080000
Amount received during the quarter relating last quarter 8*1*100000
800000
Ball rooms Rent received 2880000
Local Taxes
5000 each work which is paid in the same month 60000
Staff Salaries
Kitchen Staff -30
18% of the amount received againts the bill charged for the meals
On average the kitchen staff receive 90 orders for meal with the average billing of Rs 8000 per meal
Monthly Kitchen Billing 720000
quarter Billing 2160000
Staff Salary 388800
even though it will be paid in the 1st week of next month.
The last month of previous quarter salaries will be paid in the 1st week of current Quarter
Room service and the janitorial 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 Solar Panels
Per quarter 200000
Opening Cash 100000
Cash Received from Rooms 259344000
Ball rooms 2880000
Expenses Paid
Kitchen Staff -30 388800
Room service and the janitorial satff -40 2160000
Lower Staff - 10 450000
Maintenance of Solar Panels 200000
Cash at the end of the Quarter 259125200

Related Solutions

Ivanka Trump after moving to Pakisatan and has purchase PC hotel Karachi in November 2020 and...
Ivanka Trump after moving to Pakisatan and has purchase PC hotel Karachi in November 2020 and renamed it Ivayana. The hotel is a 5 star luxury hotel consisting of 100 single rooms 70 double rooms and 40 Suites. The average night stay in a single room costs Rs 8000. Double bed cost Rs 19000 and suite costs Rs 35000. On average 70 single rooms, 60 double rooms and 35 suites are occupied. Besides, there are 4 ball rooms. The ball...
On November 1, 2020, France Corp. signed a three-month, zero-interest-bearing note for the purchase of $60,000...
On November 1, 2020, France Corp. signed a three-month, zero-interest-bearing note for the purchase of $60,000 of inventory. The maturity value of the note was $60,600, based on the bank’s discount rate of 4%. The adjusting entry prepared on December 31, 2020 in connection with this note will include a: a. debit to Note Payable for $400. b. credit to Interest Expense for $200. c. debit to Interest Expense for $600. d. credit to Note Payable for $400.
After reviewing the standards of performance, you find that the hotel has determined that the standard...
After reviewing the standards of performance, you find that the hotel has determined that the standard of performance for room cleanliness requires that 75% of customers respond “completely satisfied”. You decide that corrective action is needed in order to raise the customer satisfaction rating. You meet with your assistant managers, Katherine and Brian, to discuss the situation. They each offer a different suggestion on what you should do next. Brian thinks the housekeeping staff is doing a great job at...
On 5/17/2020, a random sample of 1007 U.S. households finds that Trump has a 49% approval...
On 5/17/2020, a random sample of 1007 U.S. households finds that Trump has a 49% approval rating. a) Use the 2SD method to find a 95% confidence interval estimate of the proportion of all U.S. households that approve of Trump on 5/17/2020. Show all work/steps to get the 2SD estimate. Round the margin of error to three decimal places. Work and Answer: b) Use your answer from part (a) to fill in the red spaces below in order to write...
The vice president has the option to purchase the company after five years. The purchase price...
The vice president has the option to purchase the company after five years. The purchase price for the company is set at 4 times earnings (profit), computed as average annual profitability over the next five years. In five years, the company is expected to be worth $5 million. On the following graph, use the green points (triangle symbols) to plot the vice president's expected profit from buying the company, for average annual profitability levels of $0, $250,000, $500,000, $750,000, and...
joe has just movec his PC to his new office. After hooking up all the cables,...
joe has just movec his PC to his new office. After hooking up all the cables, he turns on thr system, and when it asks for it passeord, the keyboard will not respond. What could posdibly be wrong?
Rivera Company has several processing departments. Costs charged to the Assembly Department for November 2020 totaled...
Rivera Company has several processing departments. Costs charged to the Assembly Department for November 2020 totaled $2,283,744 as follows. Work in process, November 1    Materials $78,600    Conversion costs 48,700 $127,300 Materials added 1,592,280 Labor 225,100 Overhead 339,064 Production records show that 35,200 units were in beginning work in process 30% complete as to conversion costs, 661,000 units were started into production, and 25,400 units were in ending work in process 40% complete as to conversion costs. Materials are entered at...
Cavalier Company has several processing departments. Costs charged to the assembly department for November 2020 totalled...
Cavalier Company has several processing departments. Costs charged to the assembly department for November 2020 totalled $2,229,000 as follows: Assign costs and prepare production cost report. Work in process, November 1 Materials $69,000 Conversion costs 48,150 $ 117,150 Materials added 1,548,000 Labour 225,920 Overhead 337,930 Production records show that 35,000 units were in beginning work in process, 30% complete in terms of conversion costs, 700,000 units were started into production, and 25,000 units were in ending work in process, 40%...
Rivera Company has several processing departments. Costs charged to the Assembly Department for November 2020 totaled...
Rivera Company has several processing departments. Costs charged to the Assembly Department for November 2020 totaled $2,282,148 as follows. Work in process, November 1    Materials $79,300    Conversion costs 48,600 $127,900 Materials added 1,590,380 Labor 226,000 Overhead 337,868 Production records show that 34,600 units were in beginning work in process 30% complete as to conversion costs, 661,100 units were started into production, and 25,300 units were in ending work in process 40% complete as to conversion costs. Materials are entered at...
Rivera Company has several processing departments. Costs charged to the Assembly Department for November 2020 totaled...
Rivera Company has several processing departments. Costs charged to the Assembly Department for November 2020 totaled $2,282,148 as follows. Work in process, November 1    Materials $79,300    Conversion costs 48,600 $127,900 Materials added 1,590,380 Labor 226,000 Overhead 337,868 Production records show that 34,600 units were in beginning work in process 30% complete as to conversion costs, 661,100 units were started into production, and 25,300 units were in ending work in process 40% complete as to conversion costs. Materials are entered at...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT