Frogs, Inc. Part #3
Goal:
To allocate service department costs in a service company and use them to calculate full cost per unit.
Information: Frogs, Inc.’s owners were impressed by your analysis and has decided that a more detailed cost allocation system would indeed be better for the company. As part of your managerial duties, they have asked you to improve their cost accounting system.
In the past, the owners have used only DM, DL, and Manufacturing OH to calculate the cost of their jobs. However, you know that there are other costs in the company that contribute to the jobs. You tell the owners that you will present a cost analysis that includes all of these costs. The owners plan to meet with you on Friday to evaluate your proposal. After talking with the service department managers and asking them for the figures you need, they present you with the following chart of information:
Design Dept. | Engineer Dept | Concrete Casting Dept. | Owners | Admin Support |
Marketing |
|
Budgeted Overhead |
$30,000 | $186,000 | $15,500 | $14,000 | $50,000 | $40,000 |
Assigned Driver | Number of Projects | Direct Labor HRS | Number of Frogs Made | Number of Projects | SQ FT of Office Space | Number Of Projects |
Budgeted Drivers | 200 | 16,640 | 1,000 | 200 | 4,500 | 200 |
Office Space Used | 600 | 2,000 | 400 | 750 | 0 | 750 |
Number Of Projects | 50 | 50 | 50 | 50 | 0 | 0 |
Required:
1. Identify and summarize the problem or issue: What is the fundamental or underlying issue or issues in this problem? Explain.
2. Calculate the average cost to be assigned to each project (assume the projects are all the same for simplicity) using only DM, DL, and the MOH in Part 2 question 4 to compare the average cost of Frogs, Inc.’s projects to the cost of the proposed parking lot job. included below.
Concrete Casting | Design department | Engineering | Owner | ||
Direct Material | 71,000.00 | 10,000.00 | 900,000.00 | 1,000.00 | 982,000.00 |
Direct labour | 208,000.00 | 499,200.00 | 447,200.00 | 208,000.00 | 1,362,400.00 |
Inspection Cost | 1,000.00 | 500.00 | 5,000.00 | 2,000.00 | 8,500.00 |
Overhead Cost | 15,500.00 | 30,000.00 | 200,000.00 | 14,000.00 | 259,500.00 |
Direct Labor Hours | 10400.00 | 12480.00 | 16640.00 | 4160.00 | 43680.00 |
Totals for year | 280,000.00 | 509,700.00 | 1,382,200.00 | 211,000.00 | 2,382,900.00 |
Overhead Rate (POHR) | 5.62 | ||||
Design Dept | Engineering Dept | Concrete Cast | Owners | Totals | |
Overhead Costs | |||||
Setup Cost | 10000.00 | 50000.00 | 5000.00 | 1000.00 | 66000.00 |
Utilities | 10000.00 | 15000.00 | 5000.00 | 1000.00 | 31000.00 |
Equipment Fees | 0.00 | 100000.00 | 5000.00 | 5000.00 | 110000.00 |
Permits | 5000.00 | 1000.00 | 0.00 | 2000.00 | 8000.00 |
Travel to jobsite | 5000.00 | 20000.00 | 500.00 | 5000.00 | 30500.00 |
Total | 30000.00 | 186000.00 | 15500.00 | 14000.00 | 245500.00 |
3. Now, calculate the cost of the proposed job using your answers from Part 2, question 4 to include the Service Department costs. The company has decided to use the sequential method for allocating service overhead and apply Admin Support cost to marketing as well as the production departments.
4. Which result will the customer prefer? Explain.
5. Based on your answers to the previous questions, should Frogs, Inc. accept the parking lot job?
Ans 1. Frogs Inc. is not including the Administrative Overheads and Selling and Distribution Overheads to its costs to be assigned to each job. In other words, the Service Department's Costs were not being included in Total Costs to be assigned to a Job. So,
Thus, it is advisable to use the new system than a single volume measure system as was used in Traditional Costing Systems.
Frogs, Inc. Part #3 Goal: To allocate service department costs in a service company and use...
Bottom image is the information needed from part 2 question 4 Goal: To allocate service department costs in a service company and use them to calculate full cost per unit. Information: Frogs, Inc.'s owners were impressed by your analysis and has decided that a more detailed cost allocation system would indeed be better for the company. As part of your managerial duties, they have asked you to improve their cost accounting system. In the past, the owners have used only...
Frogs, inc. part #1 A commercial company has approached you to design and build the landscape for a new upscale restaurant on the lake. While Frogs Inc. has done some business projects, they have not completed one this elaborate. To keep with the tradition of the natural landscape, the project will not entail paving. Instead, the restaurant wants a clean, natural landscape with lights, plants, and frogs with a gravel parking lot. The owners know that if they can do...
Devon allocates support department costs using the direct method and estimated costs. The support department costs are budgeted at $88,000 for Department A, $63,000 for Department B, and $40,000 for Department C. These costs are allocated using the proportion of total cost the firm would pay to an outside service provider: Support Departments Operating Departments Dept. A Dept. B Dept. C Casting Machine Direct costs $88,000 $63,000 $40,000 - - Labour hours 6,000 4,000 Machine hours 2,000 10,000 Costs if...
Hotchkiss Company has two support departments, Maintenance Department (MD) and Personnel Department (PD), and two producing departments, P1 and P2. The Maintenance Department costs of $90,000 are allocated on the basis of standard service hours used. The Personnel Department costs of $9,000 are allocated on the basis of number of employees. The direct costs of Departments P1 and P2 are $36,000 and $60,000, respectively. Data on standard service hours and number of employees are as follows: Maint. Dept. Person. Dept....
Dunnes Stores has two service department, Advertising and Administration, and two operating departments, Hardware and Automotive. Sales, COGS, and direct expenses are given below. Complete the following table, including allocation of $220,000 of indirect costs. Indirect costs are allocated on the basis of square footage:... Advertising Department:750 square feet, Administration Department:1,500 square feet, Hardware Department: 3,000 square feet, Automotive Department: 9,750 square feet Dunnes Stores Revenues and Expenses Y/E December 31, 2018 Service Departments Operating Departments Totals Advertising Admin Hardware...
Question 3 Blue Ltd a manufacturing business with three production departments and one service department and has budgeted costs by department as follows: Dept Dept2 Depr3 Stores 320 480 200 Direct labour (£000) 240 280 240 Indirect labour (£000) 320 Production Requisition notes (000's) 120 160 40 Indirect materials (£000) 30,000 30,000 20,000 10,000 Area occupied (sqm) 20 70 10 Use of external maintenance (%) 40 The following additional information is available: • Total external maintenance costs will be £25,000...
Joe's Tire Company has two support departments, Personnel and Maintenance. The Maintenance Department costs of $80,000 are allocated on the basis of standard service hours used. The Personnel Department costs of $20,000 are allocated based on the number of employees. Costs of Departments A and B are $40,000 and $60,000, respectively. Data on standard service hours and number of employees are as follows: Maintenance Dept. Personnel Dept. Production Dept. A Production Dept. B Standard service hours used 200 200 240...
Allie, Inc. has two service departments and two operating departments. Allie allocates service department costs using the step-down method, with the service department with the highest cost allocated first. Initial cost for service department 1 was $140,000, and for service department 2, $100,000. Service department 1 is allocated on the basis of department employees, while service department 2 is allocated on the basis of square feet. Cost driver usage is as follows: Service 1 Service 2 Operating 1 Operating...
Use the direct method to allocate the following service costs to the operating departments. Source: Garrison 7e, Appendix A, McGraw Hill 2006 Kovac Printing Company has three service departments and two operating departments. Selected data for the five departments relating to the most recent period follow: Service Department Training Janitorial Maintenance $ 360,000 $ 210,000 $ 96,000 120 280 1.000 2,000 4000 Overhead costs Number of employees Square metres of space occupied Press time hours Operating Department Offset Printing Lithography...
Calculate and Use Overhead Rate Selected data for the consulting department of Austin Consulting, Inc., follow: Estimated consulting overhead cost for the year $810,000 Estimated direct labor cost for the year (@ $9/hr.) 450,000 Actual manufacturing overhead cost for January 48,000 Actual direct labor cost for January (1,200 hours) 33,000 Assuming that direct labor cost is the basis for applying consulting overhead, a. Calculate the predetermined overhead rate. _________% b. Prepare a journal entry that applies consulting overhead for January....