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 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: Owners Marketing Design Engineering Department Department Admin Support Concrete Casting Department $15,500 $30,000 $186,000 $14,000 $50,000 $40,000 Budgeted Overhead Assigned Driver Number Number of Direct labor Number of Number projects hours frogs made of projects of Square feet of office space 4,500 projects 200 16,640 1,000 200 200 Budgeted Drivers 600 2,000 400 750 0 Office Space Used Number of 50 projects Frogs, Inc. Page 7 of 10 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. 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? 4.00 Total cost of Project:- Departmental wide Total Cost of Project Concrete Design deptt Engineering | Owner Casting Direct Material 62,000.00 10,000.00 900,000.00 1,000.00 Direct labour 208,000.00 436,800.00 447,200.00 187,200.00 Overhead Cost 23,000.00 40,000.00 200,000.00 21,000.00 (Using part 2 & 3) 293,000.00 486,800.00 1,547,200.00 209,200.00 2,536,200.00