In: Accounting
Konig Enterprises, Ltd., owns and operates three restaurants in Vancouver, B.C. The company allocates its fixed administrative expenses to the three restaurants on the basis of sales dollars. Last year the fixed administrative expenses totaled $970,000 and were allocated as follows:
Restaurants | |||||||||||||||
Rick’s Harborside |
Imperial Garden |
Ginger Wok |
Total | ||||||||||||
Total sales—Last Year | $ | 18,060,000 | $ | 13,440,000 | $ | 10,500,000 | $ | 42,000,000 | |||||||
Percentage of total sales | 43 | % | 32 | % | 25 | % | 100 | % | |||||||
Allocation (based on the above percentages) | $ | 417,100 | $ | 310,400 | $ | 242,500 | $ | 970,000 | |||||||
This year the Imperial Garden restaurant increased its sales by $1 million. The sales levels in the other two restaurants remained unchanged. The company’s sales data for this year were as follows:
Restaurants | |||||||||||||||
Rick’s Harborside |
Imperial Garden |
Ginger Wok |
Total | ||||||||||||
Total sales—This Year | $ | 18,060,000 | $ | 14,440,000 | $ | 10,500,000 | $ | 43,000,000 | |||||||
Percentage of total sales | 42 | % | 34 | % | 24 | % | 100 | % | |||||||
Fixed administrative expenses for this year remained unchanged at $970,000.
Required:
1. Using sales dollars as an allocation base, show the allocation of the fixed administrative expenses among the three restaurants for this year.
2. Calculate the change in each restaurant’s allocated cost from last year to this year.
3. Is sales dollars a good base for allocation of fixed costs?