10a) Do customers spend more after the Promotion than they did before (i.e., their Pre versus Post Promotion spending)? Test this question with all the data, then again with only those people who accepted the offer.
10b Does the market research data match the way people really spend in this database? To answer this question, test whether High/Med High spenders actually spend more than Low/Medium Low spenders on the Pre-Promotion values (you can ignore the Average spenders in this analysis). Perform any follow-up tests as appropriate.
| Customer ID | Promotion Offer | Enrolled in Program | Pre Promotion Avg Spend | Post Promotion Avg Spend | Marketing Segment |
| 1 | Free Flight Insurance | Yes | 150.39 | 246.32 | Average Spender |
| 2 | Double Miles + Free Flight Insurance | Yes | 90.32 | 182.8 | Low Spender |
| 3 | Double Miles | Yes | 14.93 | 20.55 | Low Spender |
| 4 | Double Miles | Yes | 45.86 | 75.25 | Average Spender |
| 5 | No Offer | No | 257.89 | 397.05 | Med Low Spender |
| 6 | Free Flight Insurance | Yes | 864.59 | 1098.3 | Med High Spender |
| 7 | Double Miles | No | 137 | 94.76 | Low Spender |
| 8 | No Offer | No | 1152.27 | 781.75 | Med High Spender |
| 9 | Double Miles | Yes | 25.82 | 144.57 | Average Spender |
| 10 | Double Miles + Free Flight Insurance | Yes | 1540.66 | 1605.88 | High Spender |
| 11 | Free Flight Insurance | Yes | 253.61 | 312.15 | Average Spender |
| 12 | Double Miles + Free Flight Insurance | No | 37.4 | 47.78 | Low Spender |
| 13 | Free Flight Insurance | Yes | 1150.51 | 806.47 | Med High Spender |
| 14 | Double Miles + Free Flight Insurance | Yes | 22.34 | 545.82 | Average Spender |
| 15 | Free Flight Insurance | Yes | 179.47 | 334.25 | Average Spender |
| 16 | Double Miles | Yes | 162.42 | 678.43 | Med Low Spender |
| 17 | Double Miles + Free Flight Insurance | Yes | 24.85 | 90.83 | Low Spender |
| 18 | Double Miles | Yes | 285.45 | 121.53 | Med Low Spender |
| 19 | Free Flight Insurance | No | 3005.15 | 3012.99 | High Spender |
| 20 | Double Miles + Free Flight Insurance | Yes | 28.81 | 77.26 | Low Spender |
In: Statistics and Probability
Problem 26-01
Investment Timing Option: Decision-Tree Analysis
Kim Hotels is interested in developing a new hotel in Seoul. The company estimates that the hotel would require an initial investment of $16 million. Kim expects the hotel will produce positive cash flows of $2.72 million a year at the end of each of the next 20 years. The project's cost of capital is 12%.
In: Finance
Perry plc is a large conglomerate company structured on a divisional basis. It seeks to maximise investor wealth. Head office avoids day to day involvement in divisional affairs and only intervenes if performance is considered unsatisfactory. Divisional performance is measured by residual income.
One of Perry’s larger divisions operates a chain of high-class hotels throughout the United Kingdom. The division’s mission statement is ‘To be the hotel of the first choice for business users and tourists’. Although the chain has generally been popular with tourists it is not proving quite so popular with business users and conference organisers. Competition in the top segment of the hotel market is fierce, with customers expecting the highest standards of facilities, service, and catering. Over the last two years, the division has invested a large amount of money in modernising its hotels including the improvement of bedrooms and public rooms, installation of gymnasia and swimming pools and the information technology features required by business travelers. A large amount of money has also been spent on staff training to improve service levels and on a television advertising campaign to promote improved hotels to business users.
Head office is concerned that the performance of the hotel chain appears to have declined over the last few years despite this expenditure.
The following figures are available
|
$ millions |
$ millions |
$ millions |
|
|
2016 |
2017 |
2018 |
|
|
Capital employed |
50 |
70 |
90 |
|
Operating profit |
15 |
16 |
17 |
The cost of capital applicable to the hotel division is 20% per annum
Required:
In: Accounting
Q1. You are an audit manager of Morline & Co, a Public Accounting firm. The audit engagement partner, Joe Tan, has called you into his office to discuss a new audit client. You have been assigned to take charge of the audit for the financial year end, 31 December 2019 of Crown Hotel Group Bhd. (Crown Group) a listed company. The Group operates a chain of luxury hotels across Malaysia. As part of the expansion strategy, Crown Group has recently acquired a new hotel in Melbourne. You are very excited about auditing this luxury group of hotels, and are hoping that you may get to stay in one of the hotels during the audit.
Recently you had a meeting with Joe Tan, Datuk Paul Wong, the managing director of Crown Group, and Lisa Goh, the finance director of Crown Group. From detailed discussions with them, you note the following information:
Background information:
Crown Group owns four hotels in Malaysia namely Dolce, Corus,
Korma, Morib, one hotel, Belux in Singapore and a newly acquired
hotel in Melbourne namely Aston, which was acquired in September
2019. Each hotel operates through a separate legal entity, and
Crown Group owns 100% of each entity. The Group prepares
consolidated financial statements on an annual basis. The Head
Office is located in Petaling Jaya, Malaysia.
In 2019, the Crown Group had total revenues of RM 90 million (2018: RM 80 million), and operating profits of RM 8,500,000 (2018: RM 11,000,000).
Lisa Goh explained that all the hotels have been performing well over the last year, with the exception of Hotel Belux. See notes below
Information Technology (IT)
Lisa Goh highlighted that the Crown Group relies heavily on the use of information technology (IT) and noted that approximately 96% of bookings are made online via its website. The Group invested significantly in IT over the last six months, which resulted in an extensive upgrade of its website and the development of a user-friendly app. Datuk Paul Wong said, “We have spent a significant amount of money developing our IT systems and ensuring they are secure, as the rapid increase in cybercrime in Malaysia is frightening.” This development cost was capitalised in Financial Year 2019.
Finance team
Each hotel has a finance team, including a financial controller. At the end of every month, a reporting pack is prepared by the financial controller, including a copy of the management accounts, key completed reconciliations and detailed commentary on how the hotel has met the key performance indicators for that particular month. Each reporting pack is submitted to the head office, and the group financial controller reviews them and performs additional reconciliations. The group financial controller also prepares the year-end consolidated financial statements. Lisa Goh has, however, informed you that the group financial controller resigned in November 2019 because he could not cope with the pressure of the job. She has not been able to find a suitable replacement as to date. Lisa has asked if your firm would be able to help with the finalisation of the consolidated financial statements for the year ended 31 December 2019, as her team is currently struggling to find the time needed.
New acquisition
The hotel in Melbourne, Aston was acquired in September 2019 for RM 8,500,000, and will be included in the consolidated financial statements at 31 December 2019. The purchase of the hotel was financed by a bank loan. Datuk Paul Wong explained this was a significant investment for the Crown Group and that a further RM 2 million has since been spent on capital expenditure to ensure it meets the exceptionally high standards of the Group. Datuk Paul Wong has invited the entire audit team to travel to Melbourne for the opening of the hotel in June 2020 as his guests. He has also assured the team will be treated very well while there.
Valuation of the hotel properties
The group policy is to value Land and Buildings at fair value. The calculation of fair value and the allocation of fair value to Land and Buildings requires significant judgement. Datuk Paul Wong confirmed professional valuation experts were appointed to value Land and Buildings at 31 December 2019. Land and Buildings at that date were valued at RM 110 million, representing a revaluation increase of RM 12 million.
Loans and Borrowings
During the financial year to 31 December 2019, the Group borrowed
RM 10,500,000 in order to finance the purchase of the Aston, and to
complete the renovation work required. The loan is repayable over
10 years and the Group must adhere to strict loan covenants. The
bank requires the Group to provide management accounts on a
quarterly basis, if a loan covenant is breached, the loan may be
due for repayment immediately. Lisa Goh has informed you that the
group is also struggling to ensure management accounts for the
quarter ended 31 December 2019 will be submitted within the
allocated timeframe. The amount of interest paid was extremely
significant
Bonus
During the year, a new bonus scheme was introduced for both
managers and directors for all the hotel within the group in order
to increase revenue. The bonus is directly linked to revenue.
Advance payment
Advance deposits of 50% are collected for those booking for
conferences and wedding packages.
Hotel Belux
The hotel Belux is one of the biggest in the Group, and contributes
25% of total revenue is located in Singapore. Although revenue has
increased in 2019, profit has fallen significantly due to a number
of “special offers” in both accommodation rates and the restaurant.
Datuk Paul Wong believes the main causes for this fall are reduced
gross margins (due to the successful uptake of the various special
offer promotions during the year) and increasing costs (mainly
driven by payroll). The number of special offers were approved by
management in a bid to counter the tough economic environment
within which the hotel operates and thereby increase revenue.
Required:
(i) Identify and explain to the audit partner SEVEN (7) key audit
risks in respect of Crown Group.
(ii) Describe the matters Morline & Co should consider in the
context of ISA 620 in order to evaluate the adequacy of the
expert’s work in relation to engaging the services of a property
expert to value Land and Buildings.
(iii) Evaluate the ethical issues(s) if any in respect of the Crown
Group audit engagement and recommend appropriate safeguard(s).
In: Finance
Rebecca wishes to estimate the mean number of miles that her Nissan Versa can drive on a full tank of gas. She fills up her car with regular unleaded gasoline from the same station 9 times and records the number of miles that she drives until her low tank indicator light comes on. Construct a 96% confidence interval for the mean number of miles that she can drive on a full tank of gas until the low tank indicator light will turn on. Round to the nearest 0.1 miles
203 325 119 345 405 300 450 267 472
In: Statistics and Probability
In: Statistics and Probability
Developing an Equation from Average Costs The America Dog and Cat Hotel is a pet hotel located in Las Vegas. Assume that in March, when dog-days (occupancy) were at an annual low of 500, the average cost per dog-day was $14. In July, when dog-days were at a capacity level of 4,000, the average cost per dog-day was $7. (a) Develop an equation for monthly operating costs. (Let X = dog-days per month) Total cost = Answer + Answer * X (b) Determine the average cost per dog-day at an annual volume of 24,000 dog-days.
In: Accounting
In: Statistics and Probability
1. Use this data table for the bromination of acetone to answer the following questions;
|
Experiment |
[CH3COCH3] (M) |
[Br2] (M) |
[H+] (M) |
Rate (M s-1) |
|
1 |
0.3 |
0.05 |
0.05 |
0.000057 |
|
2 |
0.3 |
0.10 |
0.05 |
0.000057 |
|
3 |
0.3 |
0.05 |
0.10 |
0.000120 |
|
4 |
0.4 |
0.05 |
0.20 |
0.000310 |
|
5 |
0.4 |
0.05 |
0.05 |
0.000076 |
a) Determine the reaction order with respect to each of the three reactants and write the rate law.
b) What is the value of the rate constant including proper units?
In: Chemistry
A fire insurance company thought that the mean distance from a home to the nearest fire department in a suburb of Chicago was at least 5.9 miles. It set its fire insurance rates accordingly. Members of the community set out to show that the mean distance was less than 5.9 miles. This, they thought, would convince the insurance company to lower its rates. They randomly indentified 60 homes and measured the distance to the nearest fire department from each. The resulting sample mean was 5.3. If σ = 2.2 miles, does the sample show sufficient evidence to support the community's claim at the α = .05 level of significance?
(a) Find z. (Give your answer correct to two decimal places.)
(ii) Find the p-value. (Give your answer correct to four decimal places.)
(b) State the appropriate conclusion. Reject the null hypothesis, there is not significant evidence that the mean distance is less than 5.9 miles. Reject the null hypothesis, there is significant evidence that the mean distance is less than 5.9 miles. Fail to reject the null hypothesis, there is significant evidence that the mean distance is less than 5.9 miles. Fail to reject the null hypothesis, there is not significant evidence that the mean distance is less than 5.9 miles.
You may need to use the appropriate table in Appendix B to answer this question.
In: Statistics and Probability