Purchase Solution

5-39 Account Analysis: Large limousine company cost per unit

Not what you're looking for?

Ask Custom Question

5-39 Account Analysis

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 2 325 1029 $63,800.00
2 4 310 993 68,900.00
3 2 302 1268 64,000.00
4 1 213 1028 61,300.00
5 2 222 984 61,600.00
6 0 214 712 50,800.00
7 1 131 762 51,020.00
8 1 123 739 54,300.00
9 0 115 708 50,500.00
10 2 296 1232 64,800.00
11 2 213 978 58,000.00
12 1 222 929 57,500.00
13 2 217 1059 62,200.00
14 2 132 942 54,900.00
15 4 300 1299 71,530.00
16 4 315 1283 64,800.00
Totals 30 3650 15945 $959,950.00

In addition to that 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 $180,100.00
Total cost of maintaining customer accounts 109,600.00
Total cost of performing special analyses 120,000.00
Total fixed cost (total for 16 months) 550,250.00
Total cost $959,950.00

Required:

A. What is the cost per unit for (1) paychecks processed, (2) customer accounts maintained, and (3) 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. 1,000 paychecks processed
2. 200 customer accounts maintained
3. 3 special analyses

Purchase this Solution

Solution Summary

Your solution is highlighted in yellow on the attached excel spreadsheet. Click on the cells to see the computations. I have calculated a rate for each of the three activities using the 16 month history. I did not round the rate (you can if you wish to re-compute for submitting for credit). I then computed a month's cost by multiplying the activity for the month times the rates and adding in expected fixed cost (1/16 times the amount given).

Solution Preview

See attached file.

Your solution is highlighted in yellow on the attached excel spreadsheet. Click on the cells ...

Solution provided by:
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution


Free BrainMass Quizzes
Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce