Math Problem Statement

​, Inc. uses​ activity-based costing to account for its chrome bumper manufacturing process. Company managers have identified four manufacturing activities that are responsible for most of the manufacturing overhead costs​ incurred: materials​ handling, machine​ setup, insertion of​ parts, and finishing. The budgeted activity costs for the year and their allocation bases are as​ follows: View the budgeted costs and activity bases.LOADING... Read the requirements.LOADING... Cost Pool Total Budgeted Cost Allocation Base Materials handling $18,000 Number of parts Machine setup 4,800 Number of setups Insertion of parts 40,000 Number of parts Finishing 84,000 Finishing direct labor hours Total $146,800

Felcher​, Inc. expects to produce 500 chrome bumpers during the year. The bumpers are expected to use 2 comma 500 ​parts, require 10 ​setups, and consume 2 comma 000 hours of finishing time.1. Compute the predetermined overhead allocation rate for each activity. 2. Job 86 required the production of 120 bumpers and required one setup. Compute the manufacturing overhead cost allocated to Job 86.Question content area bottom Part 1 Requirement 1. Compute the predetermined overhead allocation rate for each activity. Begin by selecting the formula to calculate the predetermined overhead​ (OH) allocation rate. Then enter the amounts to compute the allocation rate for each activity. ​(Abbreviation used; qty​ = quantity. Round your answers to the nearest​ cent.) Part 2Part 3Part 4Part 5

Predetermined OH

Estimated overhead costs ÷ Estimated qty of the allocation base

allocation rate Materials handling $18,000 ÷ 2,500

$7.20 Machine setup $4,800 ÷ 10

$480.00 Insertion of parts $40,000 ÷ 2,500

$16.00 Finishing $84,000 ÷ 2,000

$42.00

Part 6 Requirement 2. Job 86 required the production of 120 bumpers and required one setup. Compute the manufacturing overhead cost allocated to Job 86. Begin by selecting the formula to allocate overhead​ (OH) costs. ​(Abbreviation used; qty​ = quantity.) Expected qty of the allocation base used × Predetermined OH allocation rate

Allocated mfg. overhead costs

Part 7 Job 86 required the production of 120 bumpers and required one setup. Compute the indirect manufacturing cost allocated to Job 86. ​(Abbreviations used; Mfg.​ = manufacturing, OH​ = overhead. Round all amounts to the nearest​ cent.) Job 86: Allocated Mfg. OH Cost Materials handling

Machine setup

Insertion of parts

Finishing

Total mfg. OH costs

Solution

Part 1: Predetermined Overhead Allocation Rate for Each Activity

The formula to calculate the predetermined overhead allocation rate is:

Predetermined OH Rate=Estimated Overhead CostsEstimated Quantity of the Allocation Base\text{Predetermined OH Rate} = \frac{\text{Estimated Overhead Costs}}{\text{Estimated Quantity of the Allocation Base}}

Now, applying the data provided:

  1. Materials Handling: 18,0002,500=7.20 per part\frac{18,000}{2,500} = 7.20 \text{ per part}

  2. Machine Setup: 4,80010=480.00 per setup\frac{4,800}{10} = 480.00 \text{ per setup}

  3. Insertion of Parts: 40,0002,500=16.00 per part\frac{40,000}{2,500} = 16.00 \text{ per part}

  4. Finishing: 84,0002,000=42.00 per finishing hour\frac{84,000}{2,000} = 42.00 \text{ per finishing hour}

Part 2: Manufacturing Overhead Cost Allocated to Job 86

Now, let's calculate the manufacturing overhead allocated to Job 86:

  • Expected quantity for Job 86:
    • 120 bumpers
    • 1 setup
    • Finishing time (since we don't have this for Job 86, let's assume it follows the same pattern for the time required to finish each bumper. We can use the estimated hours per bumper from the total 2,000 hours for 500 bumpers, which gives 4 finishing hours per bumper).

Let's break down the allocation:

  1. Materials Handling (per part): Parts used for Job 86=120 bumpers×2,500 parts500 bumpers=600 parts\text{Parts used for Job 86} = 120 \text{ bumpers} \times \frac{2,500 \text{ parts}}{500 \text{ bumpers}} = 600 \text{ parts} 600 parts×7.20=4,320 allocated to materials handling600 \text{ parts} \times 7.20 = 4,320 \text{ allocated to materials handling}

  2. Machine Setup (per setup): Setup used for Job 86=1 setup\text{Setup used for Job 86} = 1 \text{ setup} 1 setup×480.00=480.00 allocated to machine setup1 \text{ setup} \times 480.00 = 480.00 \text{ allocated to machine setup}

  3. Insertion of Parts (per part): Parts used for Job 86=600 parts\text{Parts used for Job 86} = 600 \text{ parts} 600 parts×16.00=9,600 allocated to insertion of parts600 \text{ parts} \times 16.00 = 9,600 \text{ allocated to insertion of parts}

  4. Finishing (per finishing hour): Finishing time for Job 86=120 bumpers×4 hours per bumper=480 hours\text{Finishing time for Job 86} = 120 \text{ bumpers} \times 4 \text{ hours per bumper} = 480 \text{ hours} 480 hours×42.00=20,160 allocated to finishing480 \text{ hours} \times 42.00 = 20,160 \text{ allocated to finishing}

Total Manufacturing Overhead for Job 86:

Total Manufacturing OH Cost=4,320+480+9,600+20,160=34,560\text{Total Manufacturing OH Cost} = 4,320 + 480 + 9,600 + 20,160 = 34,560

Summary for Job 86:

  • Materials Handling: $4,320.00
  • Machine Setup: $480.00
  • Insertion of Parts: $9,600.00
  • Finishing: $20,160.00
  • Total Manufacturing OH Cost: $34,560.00

Would you like further details on the process or additional questions related to this scenario?

Here are some additional questions for you:

  1. How does activity-based costing improve cost accuracy compared to traditional costing methods?
  2. Why is it important to allocate overhead costs to individual jobs?
  3. What happens to the allocation rate if production increases or decreases?
  4. How would you calculate the total cost of Job 86 if there were additional direct costs involved?
  5. How can you optimize activity-based costing for future budget estimates?

Tip: When calculating overhead costs, it's crucial to regularly review and update the allocation bases to reflect any changes in production activities or cost drivers.

Ask a new question for Free

By Image

Drop file here or Click Here to upload

Math Problem Analysis

Mathematical Concepts

Activity-Based Costing
Overhead Allocation
Basic Arithmetic Operations

Formulas

Predetermined OH Rate = Estimated Overhead Costs ÷ Estimated Quantity of the Allocation Base
Allocated OH = Expected Quantity of the Allocation Base Used × Predetermined OH Rate

Theorems

-

Suitable Grade Level

Grades 11-12