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. Paychecka Processed 1,029 993 Accounting Service Costa $ 63,800 68,900 64,000 61,300 61,600 50,800 51,020 54,300 50,500 64,800 58,000 57,500 62,200 54,900 71,530 64,800 $959,950 Special Analyses 2. 4 Customer Accounts 325 Month 1. 310 302 213 222 214 131 123 1,268 1,028 984 712 762 739 3. 4. 2 7. 115 708 10 296 213 222 217 132 1,232 978 929 1,059 942 1,299 1,283 15,945 11 12 13 14 2. 15 4 300 16 315 Totala 30 3,650 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 Total cost of maintaining customer accounts Total cost of performing special analyses Total fixed costs (total for 16 montha) Total costs $180,100 109,600 120,000 550,250 $959,950 Required: a-1. What is the cost per unit for paychecks processed? a-2. Whet is the cost per unt for customer accounts maintained? a-3. What is the cost per unit for special analyses performed? b. Assuming the following level of cost driver vonlumes

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. Paychecka Processed 1,029 993 Accounting Service Costa $ 63,800 68,900 64,000 61,300 61,600 50,800 51,020 54,300 50,500 64,800 58,000 57,500 62,200 54,900 71,530 64,800 $959,950 Special Analyses 2. 4 Customer Accounts 325 Month 1. 310 302 213 222 214 131 123 1,268 1,028 984 712 762 739 3. 4. 2 7. 115 708 10 296 213 222 217 132 1,232 978 929 1,059 942 1,299 1,283 15,945 11 12 13 14 2. 15 4 300 16 315 Totala 30 3,650 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 Total cost of maintaining customer accounts Total cost of performing special analyses Total fixed costs (total for 16 montha) Total costs $180,100 109,600 120,000 550,250 $959,950 Required: a-1. What is the cost per unit for paychecks processed? a-2. Whet is the cost per unt for customer accounts maintained? a-3. What is the cost per unit for special analyses performed? b. Assuming the following level of cost driver vonlumes

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter7: Allocating Costs Of Support Departments And Joint Products

Section: Chapter Questions

Problem 30E: A company uses charging rates to allocate service department costs to the using departments. The...

See similar textbooks

Similar questions

Ellerson Company provided the following information for the last calendar year: During the year, direct materials purchases amounted to 278,000, direct labor cost was 189,000, and overhead cost was 523,000. During the year, 100,000 units were completed. Refer to Exercise 2.21. Last calendar year, Ellerson recognized revenue of 1,312,000 and had selling and administrative expenses of 204,600. Required: 1. What is the cost of goods sold for last year? 2. Prepare an income statement for Ellerson for last year.
Thayne Company has 30 clerks that work in its Accounts Payable Department. A study revealed the following activities and the relative time demanded by each activity: Required: Classify the four activities as value-added or non-value-added, and calculate the clerical cost of each activity. For non-value-added activities, indicate why they are non-value-added.
Big Mikes, a large hardware store, has gathered data on its overhead activities and associated costs for the past 10 months. Nizam Sanjay, a member of the controllers department, believes that overhead activities and costs should be classified into groups that have the same driver. He has decided that unloading incoming goods, counting goods, and inspecting goods can be grouped together as a more general receiving activity, since these three activities are all driven by the number of receiving orders. The 10 months of data shown below have been gathered for the receiving activity. Required: 1. Prepare a scattergraph, plotting the receiving costs against the number of purchase orders. Use the vertical axis for costs and the horizontal axis for orders. 2. Select two points that make the best fit, and compute a cost formula for receiving costs. 3. Using the high-low method, prepare a cost formula for the receiving activity. 4. Using the method of least squares, prepare a cost formula for the receiving activity. What is the coefficient of determination?
Corazon Manufacturing Company has a purchasing department staffed by five purchasing agents. Each agent is paid 28,000 per year and is able to process 4,000 purchase orders. Last year, 17,800 purchase orders were processed by the five agents. Required: 1. Calculate the activity rate per purchase order. 2. Calculate, in terms of purchase orders, the: a. total activity availability b. unused capacity 3. Calculate the dollar cost of: a. total activity availability b. unused capacity 4. Express total activity availability in terms of activity capacity used and unused capacity. 5. What if one of the purchasing agents agreed to work half time for 14,000? How many purchase orders could be processed by four and a half purchasing agents? What would unused capacity be in purchase orders?
Nabors Company had actual quality costs for the year ended June 30, 20x5, as given below. At the zero-defect state, Nabors expects to spend 375,000 on quality engineering, 75,000 on vendor certification, and 50,000 on packaging inspection. Assume sales to be 25,000,000. Required: 1. Prepare a long-range performance report for 20x5. What does this report tell the management of Nabors? 2. Explain why quality costs still are present for the zero-defect state. 3. What if Nabors achieves the zero-defect state reflected in the report? What are some of the implications of this achievement?
SmokeCity, Inc., manufactures barbeque smokers. Based on past experience, SmokeCity has found that its total annual overhead costs can be represented by the following formula: Overhead cost = 543,000 + 1.34X, where X equals number of smokers. Last year, SmokeCity produced 20,000 smokers. Actual overhead costs for the year were as expected. Required: 1. What is the driver for the overhead activity? 2. What is the total overhead cost incurred by SmokeCity last year? 3. What is the total fixed overhead cost incurred by SmokeCity last year? 4. What is the total variable overhead cost incurred by SmokeCity last year? 5. What is the overhead cost per unit produced? 6. What is the fixed overhead cost per unit? 7. What is the variable overhead cost per unit? 8. Recalculate Requirements 5, 6, and 7 for the following levels of production: (a) 19,500 units and (b) 21,600 units. (Round your answers to the nearest cent.) Explain this outcome.
Ellerson Company provided the following information for the last calendar year: During the year, direct materials purchases amounted to 278,000, direct labor cost was 189,000, and overhead cost was 523,000. During the year, 100,000 units were completed. Required: 1. Calculate the total cost of direct materials used in production. 2. Calculate the cost of goods manufactured. Calculate the unit manufacturing cost. 3. Of the unit manufacturing cost calculated in Requirement 2, 2.70 is direct materials and 5.30 is overhead. What is the prime cost per unit? Conversion cost per unit?
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 CustomerAccounts PaychecksProcessed AccountingService Costs 1 2 325 1,029 $ 63,800 2 4 310 993 68,900 3 2 302 1,268 64,000 4 1 213 1,028 61,300 5 2 222 984 61,600 6 0 214 712 50,800 7 1 131 762 51,020 8 1 123 739 54,300 9 0 115 708 50,500 10 2 296 1,232 64,800 11 2 213 978 58,000 12 1 222 929 57,500 13 2 217 1,059 62,200 14 2 132 942 54,900 15 4 300 1,299 71,530 16 4 315 1,283 64,800 Totals 30 3,650 15,945 $ 959,950 In…
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 CustomerAccounts PaychecksProcessed AccountingService Costs 1 1 190 1,100 $ 58,800 2 1 260 1,010 61,600 3 2 270 1,170 59,200 4 2 250 920 59,100 5 3 160 1,280 60,600 6 2 170 1,180 61,900 7 1 340 830 59,000 8 4 220 1,220 61,400 9 3 150 1,210 61,300 10 1 230 1,270 60,100 11 2 220 1,130 60,200 12 2 300 930 61,200 13 3 190 1,010 59,700 14 3 290 1,120 60,700 15 4 300 910 60,500 16 2 180 980 60,200 Totals 36 3,720 17,270 $ 965,500 In addition to the above information, you learn that the accounting department had the following total…
The management of Casablanca Manufacturing Corporation believes that machine- hours is an appropriate measure of activity for overhead cost Shown below are machine hours and total overhead cost for the past six months: Machine- hours Overhead Cost Jan 150,000 P339,000 Feb 140,000 P328,000 Mar 160,000 P350,000 Apr 130,000 P319,500 May 170,000 P362,500 Jun 200,000 P400,000 Assume that the relevant range included all of the activity levels mentioned in this problem. If Casablanca expects to incur 185,000 machine hours next month, what will the estimated total overhead cost be using the high-low method?
Audio Zone Co. needs to prepare pro forma financial statements for the next fiscal year. To do so, the company must forecast its total overhead cost. The actual machine hours and total overhead cost are presented below for the past six months. Month Total Overhead Machine Hours Jan. $ 6,288 1,980 Feb. 6,460 2,090 Mar. 5,987 1,745 Apr. 5,559 1,560 May 6,032 1,865 June 6,341 2,012 Using the high-low method, total monthly fixed overhead cost is calculated to be:
The following report was prepared for evaluating the performance of the plant manager of Marching Ants Inc. Evaluate and correct this report. Marching Ants Inc.Manufacturing CostsFor the Quarter Ended June 30 Materials used in production (including $56,200 of indirect materials) $607,500 Direct labor (including $84,400 maintenance salaries) 562,500 Factory overhead: Supervisor salaries 517,500 Heat, light, and power 140,650 Sales salaries 348,750 Promotional expenses 315,000 Insurance and property taxes—plant 151,900 Insurance and property taxes—corporate offices 219,400 Depreciation—plant and equipment 123,750 Depreciation—corporate offices 90,000 Total $3,076,950 Marching Ants Inc.Manufacturing CostsFor the Quarter Ended June 30 $- Select - - Select - Factory overhead: $- Select - - Select - - Select - - Select - - Select - - Select - - Select - Total…