Question

In: Accounting

Market Makers Inc. (MMI) provides a range of services to its retail clients—customer service for inquiries,...

Market Makers Inc. (MMI) provides a range of services to its retail clients—customer service for inquiries, order taking, credit checking for new customers, and a variety of related services. Auto Supermarket (AS) is a large auto dealer that provides financing for the autos and trucks that it sells. AS has approached MMI to manage the inquiries that come in regarding these loans. AS is not satisfied with the performance of the call center it currently uses for handling inquiries on these loans and is considering a change to MMI. MMI has been asked to estimate the cost of providing the service for the coming year.

There are two types of loans at AS, one for autos and SUVs and another for light trucks. The loans for auto and truck buyers typically have different types of customers and loan terms, so the nature and volume of the inquiries are expected to differ. MMI would use its own call center to handle the AS engagement. The MMI call center’s annual costs are as follows:

Call center costs
Salaries $ 4,233,555
Utilities 2,497,446
Leasing of facilities 1,995,513
Other expenses 820,036
$ 9,546,550

MMI’s call center is staffed 12 hours per day with 60 call staff always available. Each staff member has a paid 10-minute break for each hour worked, and an unpaid 1-hour break for a lunch/dinner during each 12-hour shift. Thus, the call center has 12,045,000 minutes (11 hr × 50 min × 60 staff × 365 days) available for calls during the year.

AS and MMI work together to estimate the number of calls and time required for each call, based on AS’s prior experience with its current call center.

Inquiries Total Calls
Answered
Average
Number of
Minutes/Call
Total Time
(minutes)
Inquire re: rates and terms
Autos 80,100 6 480,600
Trucks 32,100 7 224,700
Inquire re: loan application status
Autos 45,100 5 225,500
Trucks 6,760 11 74,360
Inquire re: payment status
Autos 39,100 3 117,300
Trucks 12,100 4 48,400
Inquire re: other matters
Autos 29,100 11 320,100
Trucks 8,510 15 127,650
1,618,610

Required:

1. Determine the amount that MMI should propose to charge AS for the coming year using TDABC, assuming MMI desires a profit of 30% of incurred cost.

2. Suppose that AS wants the proposal broken down by type of loan (auto, truck). What would the proposal look like now?

Solutions

Expert Solution

Amount in $
1 Determining total amount MMI should charge using Time Driven Activity based costing
Total cost incurred by MMI 9546550
Total Minutes available 12045000
Total Minutes allocated to AS 1618610
Cost per Minute 0.792574
Add :- 30% to cost per minute 0.237772
Revenue Per Minute 1.030346
TOTAL REVENUE TO BE BILLED BY MMI 1667728
2 where the proposal is broken down by type of loan (Auto, Truck) the loan would be based on minutes available and on time required for each activity.

Related Solutions

Market Makers Inc. (MMI) provides a range of services to its retail clients—customer service for inquiries,...
Market Makers Inc. (MMI) provides a range of services to its retail clients—customer service for inquiries, order taking, credit checking for new customers, and a variety of related services. Auto Supermarket (AS) is a large auto dealer that provides financing for the autos and trucks that it sells. AS has approached MMI to manage the inquiries that come in regarding these loans. AS is not satisfied with the performance of the call center it currently uses for handling inquiries on...
Question 3 Ted’s Travel Agency provides travel services for walk-in retail clients and for corporate clients....
Question 3 Ted’s Travel Agency provides travel services for walk-in retail clients and for corporate clients. It is the largest privately owned travel agency in the greater Toronto area. Ted Thompson has been the owner since its first day of business. Many clients are walk-ins who live within a fivekilometre radius of the office, and others hear about the agency from friends and will drive from much farther away. The agency also has a large and growing component of business...
The Superior Gardening Service provides gardening services to its clients. The company uses an activity-based costing...
The Superior Gardening Service provides gardening services to its clients. The company uses an activity-based costing system for its overhead costs. The company has provided the following data from its activity-based costing system. Activity Cost Pool   Total Cost    Total Activity Gardening $125,425 17,300 hours Job support 28,134 1,775 jobs Client support 4,530 280 clients Other     150,000 Not applicable Total   $308,089 The "Other" activity cost pool consists of the costs of idle capacity and organization-sustaining costs. One particular client, the...
Alejandro Associates is an accounting firm that provides audit and tax services to its clients. Each...
Alejandro Associates is an accounting firm that provides audit and tax services to its clients. Each tax return is considered a "job" for the firm, just like a manufacturing company considers a customer order as a "job." Alejandro has direct costs related to Tax Return 8405 as follows: 8 hours of staff labor @ $123 per hour 6 hours of assembly labor @$168 per hour $62 of materials In addition, Alejandro Associates estimates its overhead related to the manufacture of...
Question 3: Sun Consultancy provides special consultancy services to its clients. It started its operation on...
Question 3: Sun Consultancy provides special consultancy services to its clients. It started its operation on January 1, 2018. An un-adjusted trial balance as on May 31, 2018 for this firm is given below. Sun Consultancy Trial Balance As on May 31, 2018 Serial # List of Accounts Debit (Rs) Credit (Rs) 1 Cash 97,300 2 Accounts receivable 10,400 3 Office supplies 15,000 4 Prepaid insurance 12,000 5 Furniture 40,000 6 Car 50,000 7 Accumulated depreciation-car 7,600 8 Unearned revenue...
Part 2 Communications Unlimited provides support services to its clients. This company expects to earn an...
Part 2 Communications Unlimited provides support services to its clients. This company expects to earn an annual return on the assets invested at a rate of: 20% The company has the following amount invested in the business: $8,000,000 The annual budgeted costs for next year are: Variable costs Fixed costs Support Services $600,000 1,900,000 The annual budgeted hours for next year are: Consulting services           60,000 hours Required: You must use cell references for all calculations. 5. Determine the markup...
3.      General Hospital provides a wide range of health services in its community. The board of directors...
3.      General Hospital provides a wide range of health services in its community. The board of directors has authorized the following capital expenditures:      Intra-aortic balloon pump                                          $1,400,000         Computed tomographic scanner                                   850,000         X-ray equipment                                                                550,000         Laboratory equipment                                                   1,200,000         Total                                                                                 $4,000,000 The expenditures are planned for October 1, 20X7, and the board wishes to know the amount of borrowing, if any, necessary on that date. Rebecca Singer, hospital controller,...
3.      General Hospital provides a wide range of health services in its community. The board of directors...
3.      General Hospital provides a wide range of health services in its community. The board of directors has authorized the following capital expenditures:      Intra-aortic balloon pump                                          $1,400,000         Computed tomographic scanner                                   850,000         X-ray equipment                                                                550,000         Laboratory equipment                                                   1,200,000         Total                                                                                 $4,000,000 The expenditures are planned for October 1, 20X7, and the board wishes to know the amount of borrowing, if any, necessary on that date. Rebecca Singer, hospital controller,...
3.      General Hospital provides a wide range of health services in its community. The board of directors...
3.      General Hospital provides a wide range of health services in its community. The board of directors has authorized the following capital expenditures:      Intra-aortic balloon pump                                          $1,400,000         Computed tomographic scanner                                   850,000         X-ray equipment                                                                550,000         Laboratory equipment                                                   1,200,000         Total                                                                                 $4,000,000 The expenditures are planned for October 1, 20X7, and the board wishes to know the amount of borrowing, if any, necessary on that date. Rebecca Singer, hospital controller,...
SAFE PLC is an unlisted company that provides a range of services to the medical and...
SAFE PLC is an unlisted company that provides a range of services to the medical and healthcare industry. Last year, it made a profit of £500,000 and had a dividend payout ratio of 80%. The average P/E ratio for this sector is 9. The company’s balance sheet shows Shareholder funds of £2.25m for 1m shares, but the buildings are worth £1m more than their balance sheet value and stocks would be worth £250,000 less in a break-up of the company....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT