In: Accounting
Midwest Entertainment has four operating divisions: Bus Charters, Lodging, Concerts, and Ticket Services. Each division is a separate segment for financial reporting purposes. Revenues and costs related to outside transactions were as follows for the past year (dollars in thousands):
Bus Charters | Lodging | Concerts | Ticket Services | |||||||||
Revenues | $ | 11,800 | $ | 5,250 | $ | 4,430 | $ | 1,750 | ||||
Costs | 7,850 | 3,520 | 3,320 | 1,650 | ||||||||
Bus Charters Division participates in a frequent guest program with Lodging Division. During the past year, Bus Charters reported that it traded lodging award coupons for travel that had a retail value of $1.3 million, assuming that the travel was redeemed at full fares. Concerts Division offered 20 percent discounts to Midwest’s bus passengers and lodging guests. These discounts to bus passengers were estimated to have a retail value of $350,000. Midwest's lodging guests redeemed $170,000 in concert discount coupons. Midwest’s hotels also provided rooms for Bus Charters’s employees (drivers and guides). The value of the rooms for the year was $660,000.
Ticket Services Division sold chartered tours for Bus Charters valued at $210,000 for the year. This service for intracompany lodging was valued at $110,000. It also sold concert tickets for Concerts; tickets for intracompany concert admission were valued at $55,000.
While preparing all of these data for financial statement presentation, Lodging Division’s controller stated that the value of the bus coupons should be based on their differential and opportunity costs, not on the full fare. This argument was supported because travel coupons are usually allocated to seats that would otherwise be empty or that are restricted similar to those on discount tickets. If the differential and opportunity costs were used for this transfer price, the value would be $250,000 instead of $1.3 million. Bus Charters’s controller made a similar argument concerning the concert discount coupons. If the differential cost basis were used for the concert coupons, the transfer price would be $55,000 instead of the $350,000.
Midwest reports assets in each division as follows (dollars in thousands):
Bus Charters | $ | 48,250 | |
Lodging | 18,900 | ||
Concerts | 15,300 | ||
Ticket Services | 3,250 | ||
Required:
a. Using the retail values for transfer pricing for segment reporting purposes, what are the operating profits for each Midwest division? (Enter your answers in thousands of dollars.)
|
b. What are the operating profits for each Midwest division using the differential cost basis for pricing transfers? (Enter your answers in thousands of dollars.)
|
c. Rank each division by ROI using the transfer pricing methods in requirements (a) and (b). (Round your answers to 2 decimal places.)
|
|
a) | (in thousand $) | |||
Bus charters | Lodging | Concerts | Ticket services | |
Revenues | ||||
External | $ 11,800 | $ 5,250 | $ 4,430 | $ 1,750 |
Internal | $ 1,300 | $ 660 | $ 520 | $ 375 |
Total revenues | $ 13,100 | $ 5,910 | $ 4,950 | $ 2,125 |
Costs | ||||
External | $ 7,850 | $ 3,520 | $ 3,320 | $ 1,650 |
Internal | $ 1,220 | $ 1,580 | $ 55 | $ - |
Total costs | $ 9,070 | $ 5,100 | $ 3,375 | $ 1,650 |
Operating profits | $ 4,030 | $ 810 | $ 1,575 | $ 475 |
b) | (in thousand $) | |||
Bus charters | Lodging | Concerts | Ticket services | |
Revenues | ||||
External | $ 11,800 | $ 5,250 | $ 4,430 | $ 1,750 |
Internal | $ 250 | $ 660 | $ 225 | $ 375 |
Total revenues | $ 12,050 | $ 5,910 | $ 4,655 | $ 2,125 |
Costs | ||||
External | $ 7,850 | $ 3,520 | $ 3,320 | $ 1,650 |
Internal | $ 925 | $ 530 | $ 55 | $ - |
Total costs | $ 8,775 | $ 4,050 | $ 3,375 | $ 1,650 |
Operating profits | $ 3,275 | $ 1,860 | $ 1,280 | $ 475 |
c) | ||||
Using retail values | ||||
Bus charters | Lodging | Concerts | Ticket services | |
Operating profits using retail values as per (a) | $ 4,030 | $ 810 | $ 1,575 | $ 475 |
Assets value | $ 48,250 | $ 18,900 | $ 15,300 | $ 3,250 |
ROI | 8.35% | 4.29% | 10.29% | 14.62% |
Using differential costs | ||||
Bus charters | Lodging | Concerts | Ticket services | |
Operating profits using differential costs as per (b) | $ 3,275 | $ 1,860 | $ 1,280 | $ 475 |
Assets value | $ 48,250 | $ 18,900 | $ 15,300 | $ 3,250 |
ROI | 6.79% | 9.84% | 8.37% | 14.62% |
Please Like the solution if satisfied with the answer and if any query please mention it in comments...thanks