2.
The accounting department of a large limousine company is analyzing the costs of its services. The cost data and level of activity for the past 16 months follow.
| Month | Special Analyses | Customer Accounts |
Paychecks Processed |
Accounting Service Costs |
|||||||
| 1 | 4 | 190 | 1,150 | $ | 58,000 | ||||||
| 2 | 1 | 300 | 1,290 | 60,800 | |||||||
| 3 | 4 | 240 | 1,170 | 58,300 | |||||||
| 4 | 4 | 330 | 1,150 | 59,400 | |||||||
| 5 | 1 | 340 | 970 | 60,600 | |||||||
| 6 | 2 | 220 | 1,140 | 60,500 | |||||||
| 7 | 4 | 200 | 1,300 | 59,200 | |||||||
| 8 | 3 | 220 | 1,020 | 61,900 | |||||||
| 9 | 1 | 240 | 900 | 61,800 | |||||||
| 10 | 1 | 220 | 1,060 | 60,300 | |||||||
| 11 | 2 | 270 | 980 | 60,700 | |||||||
| 12 | 1 | 210 | 1,000 | 59,500 | |||||||
| 13 | 2 | 200 | 800 | 60,800 | |||||||
| 14 | 3 | 170 | 1,260 | 59,800 | |||||||
| 15 | 3 | 200 | 850 | 60,800 | |||||||
| 16 | 3 | 200 | 1,200 | 61,900 | |||||||
| Totals | 39 | 3,750 | 17,240 | $ | 964,300 | ||||||
In addition to the above information, you learn that the accounting department had the following total costs for the past 16 months for each of the following.
| Total cost of paychecks processed | $ | 205,156 | |
| Total cost of maintaining customer accounts | 113,625 | ||
| Total cost of performing special analyses | 154,050 | ||
| Total fixed costs (total for 16 months) | 491,469 | ||
| Total costs | $ | 964,300 | |
Required:
a-1. What is the cost per unit for paychecks processed?
a-2. What is the cost per unit for customer accounts maintained?
a-3. What is the cost per unit for special analyses performed?
b. Assuming the following level of cost-driver volumes for a month, what are the accounting department's estimated costs of doing business using the account analysis approach?
• 1,000 paychecks processed.
• 170 customer accounts maintained.
• 3 special analyses.
A) calculation of per unit costs
1. Paychecks = $205156 / 17240 = $11.9
2. Customer account = $113625/3750 = $30.3
3. Special analysis = $154050/39 = $3950
B) fixed cost per month = $491469/16 = $30716.8
Estimated costs
= $30716.8 + (1000*$11.9) + (170*$30.3) + (3*$3950)
= $59617.8
2. The accounting department of a large limousine company is analyzing the costs of its services....
The accounting department of a large limousine company is analyzing the costs of its services. The cost data and level of activity for the past 16 months follow: Month Special Analyses Customer Accounts Paychecks Processed Accounting Service Costs 1 0 150 1,270 $ 60,600 2 4 150 1,020 61,000 3 4 260 1,290 59,700 4 3 320 1,200 59,200 5 3 180 910 60,300 6 3 210 970 60,600 7 3 310 1,210 61,200 8 4 220 1,000 61,900 9...
The accounting department of a large limousine company is analyzing the costs of its services. The cost data and level of activity for the past 16 months follow: Month Special Analyses Customer Accounts 350 240 190 Paychecks Processed 1.150 1,220 1,280 1.000 1.110 980 830 340 260 310 250 290 840 Accounting Service Costs S 58.300 61,000 61,000 61,000 60,600 59,700 53,100 58,200 58,900 59,400 59,100 58,100 60,700 61,100 60,100 59,200 S 954,500 320 180 200 320 210 180 200...
The accounting department of a large limousine company is analyzing the costs of its services. The cost data and level of activity for the past 16 months follow. Month Special Analyses Customer Accounts Paychecks Processed Accounting Service Costs 1 3 300 1,240 $ 61,000 2 2 260 1,120 58,300 3 4 270 1,280 61,500 4 3 290 1,230 60,000 5 3 240 890 58,000 6 3 320 930 61,500 7 4 260 1,140 59,700 8 3 280 820 59,700 9...
Problem 3535 Ayu) Alluun The accounting department of a large limousine company is analyzing the costs of its services. The cost data and level of activity for the past 16 months follow. Special Customer Analyses Accounts Month 150 3:40 250 28 190 Paychecks Processed 940 850 1,090 1.300 1.020 1,300 1.07e 1,280 1.680 1.179 1.250 1,010 1,160 1,290 820 350 Accounting Service Costs 58.200 60.200 58.500 58,300 61,000 59,700 61,700 60,909 58,200 58,900 58,300 58.200 60,400 59,400 60,100 61.cee 5953.600...
Problem 5-49 Account Analysis (LO 5-3) The accounting department of a large limousine company is analyzing the costs of its services. The cost data and level of activity for the past 16 months follow Month Special Analyses Customer Paychecks Accounts Processed 1,040 910 900 1,130 1.020 290 200 260 250 800 290 1.150 ато 270 270 Accounting Service Casts S 60.000 58.500 58,000 61.900 59,600 61.100 61.500 58.400 61,400 60.400 58.000 61,600 59.320 61.700 58,800 60.300 S960.500 240 330 190...
Weisgarber Corporation is conducting a time-driven
activity-based costing study in its Customer Service Department.
The company has provided the following data to aid in that
study:
Weisgarber Corporation
Customer Service Department
Data Inputs
Resource Data:
Number of employees
24
Average salary per employee
$
37,710
Weeks of employment per year
50
Minutes available per week (40 hours × 60 minutes)
2,400
Practical capacity percentage
90
%
Activity Data:
Processing Orders
Resolving Queries
Processing Credit Reviews
Minutes per unit of the...
Last year, X Company sold 61,900 units of its only product for $19.00 each. Total costs were as follows: Cost of goods sold Variable $393,684 Fixed 118,848 Selling and administrative Variable$64,376 Fixed 82,946 At the end of the year, a company offered to buy 4,400 units of the product but only for $11.00 each. X Company had the capacity to produce the additional units, and even though there would have been no additional selling and administrative costs, it rejected the offer. 1. If X...
provides housecleaning services to its verhead costs. The company has provided services to its Chients. The company uses has provided the following data The Coletti Cleaning Brigade Company provides housecleani an activity-based costing system for its overhead cos from its activity-based costing system. Total Cost Total Activity Activity Cost Pool $302,993 $43,100 hours Cleaning 79,100 Job Support 5,000 jobs 180 clients 3,348 Client Support 150,000 Other $535,441 Total The "Other activity cost pool consists of the costs of idle capacity...
Bidder Distribution Hub 1 2 3 4 A 190 175 125 230 B 150 235 155 220 C 210 225 135 260 D 170 185 190 280 E 220 190 140 240 F 270 200 130 260 a. Develop the network of the problem. (1 Marks) b. Formulate the problem as a linear programming problem. (2 Marks) c. Solve assignment that minimizes total cost. (2 Marks)
The Purchasing Department of an international airways company is responsible for companywide purchasing. Its total costs are assigned to each division (one division in every country the company is operating in) based on the number of purchase orders the Purchasing Department processes for each division. The Purchasing Department's fixed costs are € 425,000 per year and the department is expected to process 17,000 purchase orders at a variable cost of € 65 per purchase order. Purchasing costs do not include...