Question

In: Accounting

Franklin Fireplace Inserts manufactures two premium models of fireplace inserts that provide more BTUs of heat...

Franklin Fireplace Inserts manufactures two premium models of fireplace inserts that provide more BTUs of heat per cord of wood than any other wood burning fireplace insert or stove. One model, the Heatilator, sells for $1,800, and the Heat Queen, a new model that sells for $1,200. Franklin’s marketing department suggested that the company should concentrate on the new Heat Queen model and begin to phase out the Heatilator model.

            Franklin currently uses a traditional costing system. The following cost information has been used as a basis for pricing decisions over the past year.

Per-Unit Data                          Heatilator          Heat Queen

Direct materials                           $200                 $280

Direct labor hours                           1.5                    1.5

Machine hours                                5.0                    4.0

Units produced                         11,000                4,000

            Direct labor cost is $20 per hour, and the machine usage cost is $18 per hour. Manufacturing overhead costs were estimated at $4,800,000 and were allocated on the basis of machine hours.

            Gwen Freely, the new company controller, suggested that an activity-based costing analysis first be performed to obtain a better picture of the true manufacturing cost. The following data were collected:

Activity Center            Cost Driver                              Traceable Costs

Soldering                     Number of solder joints                 $   942,000

Shipments                    Number of shipments                         860,000

Quality control             Number of inspections                     1,240,000

Purchase orders           Number of orders                               950,400

Machining                    Machine hours                                      57,600

Machine setups            Number of setups                               750,000

Total traceable costs                                                           $4,800,000

            Number of Events during the year:

Activity                                Heatilator        Heat Queen           Total

Soldering                               296,250              96,250           392,500

Shipments                                  4,050                   950               5,000

Quality control                        14,050                5,325             19,375

Purchase orders                       20,025              27,495             47,520

Machining                               44,000                4,000             48,000

Machine setups                          4,000                3,500               7,500

            Selling, general, and administrative costs per unit sold are $175.00 for Heatilator and $125 for Heat Queen.

a.   Calculate the manufacturing cost per unit for Heatilator and Heat Queen under:

1.   A traditional costing system

2.   The ABC system

b.   Explain the differences in manufacturing cost per unit calculated in part (A).

c.   Which system would most likely do a better job of measuring costs for this product emphasis/keep or drop decision? Explain.

d.   Franklin’s controller points out that the ABC information could also be used to identify and eliminate non-value added activities. Explain how ABC and ABM can be used for this purpose.

Solutions

Expert Solution

Answer a)
1
Cost Type Heatilator Heat Queen
Direct materials               200.00                 280.00
Direct labors                 30.00                   30.00
Machine usage cost               90.00                   72.00
Manufacturing overhead cost             338.03                 270.42
Total manufacturing cost             658.03                 652.42
Working
Total manufacturing overhead cost 4,800,000.00
Total machine hours        71,000.00 (11000x5 + 4000x4)
Overhead allocation rate per machine hour               67.61
Answer a)
2
Cost Type Heatilator Heat Queen
Direct materials               200.00                 280.00
Direct labors                 30.00                   30.00
Machine usage cost               90.00                   72.00
Manufacturing overhead cost             287.28                 409.98
Total manufacturing cost             607.28                 791.98
Working
Number of Activity Cost Allocation based on Cost Per Activity
Activity Center Traceable Costs Activity Total Cost per Activity Heatilator Heat Queen   Heatilator Heat Queen  
Soldering      942,000.00          392,500.00                     2.40           296,250.00           96,250.00                 711,000.00                    231,000.00
Shipments        860,000.00              5,000.00                 172.00               4,050.00                950.00                 696,600.00                    163,400.00
Quality control   1,240,000.00            19,375.00                   64.00             14,050.00             5,325.00                 899,200.00                    340,800.00
Purchase orders      950,400.00            47,520.00                   20.00             20,025.00           27,495.00                 400,500.00                    549,900.00
Machining            57,600.00            48,000.00                     1.20             44,000.00             4,000.00                   52,800.00                        4,800.00
Machine setups      750,000.00              7,500.00                 100.00               4,000.00             3,500.00                 400,000.00                    350,000.00
4,800,000.00              3,160,100.00                 1,639,900.00
Total Number Units Produced                   11,000.00                        4,000.00
Manufacturing Overhead cost per unit                        287.28                           409.98
Answer b)
As per both Traditional & Activity based costing system, there will be no difference in the direct cost such as direct material, direct labor cost because these cost are directly identifiable & attributable to each unit
Under traditional cost, the manufacturing overhead cost is allocated based on machine hours, whereby Module-Heatiltor bears the cost of 658 as compared to Heat Queen of 652. However ABC method of costing accurately captures the costing, which reveals that Module-Heatilator consumes only 287 as compared to Heat Queen of 410
Answer c)
Activity-based costing is a way to apportion costs based on the amount of resources a product or service consumes.
The use of ABC is particularly necessary to businesses that provide tailored products or services.
A tailored production atmosphere requires ABC’s allocation of actual indirect costs to a product to categorize its true cost.
Therefore in this setup, The usage of ABC method benefit the organization better pricing, cost controlling and etc.
Answer d)
Activity-based management (ABM) can be defined as the entire set of activities that can be taken on a better informed basis using ABC information. The purpose is to attain the same level of output with lower costs.
Stages in ABC & ABM
1.      Identify the activities that the organization performs
2.      Calculate the cost of each activity
3.      Identify the activity cost driver for each activity.
The purpose and stages of ABC & ABM focuses on identifying and eliminating the activities that don’t add value. Also under this system each cost and its relationship to main cost and activity driver is better analyzed, therefore any wastage or improvement can be quickly identified.

Related Solutions

Franklin Manufacturing manufactures two models of windows, bay windows and casement windows. Franklin uses an activity...
Franklin Manufacturing manufactures two models of windows, bay windows and casement windows. Franklin uses an activity based costing system. The following information about the activities used to produce the company's products has been provided. Estimated Cost                      Cost Driver           Bay Windows      Casement Unit-level            $   125,000          Labor hours           750                       500 Batch-level          $     75,000          Inspections            30                         20 Product-level       $     35,000          Storage Space       3,500 sq feet        2,100 sq feet Facility-level       $   165,000          Machine hours      9,000                    6,000 If bay windows and casement windows require the same amount of direct labor, using labor hours as the allocation base for facility-level costs would: A. undercost the casement windows. B. overcost...
Katy Company manufactures three product models, Standard, Premium, and Deluxe. The following is the data for...
Katy Company manufactures three product models, Standard, Premium, and Deluxe. The following is the data for each product per week. Standard Premium Deluxe Total Maximum weekly demand (in units) 300 250 200 750 units Current weekly production (in units) 200 200 200 600 units Contribution margin per unit $40 $45 $60 Number of machine hours required 2 3 5 Maximum Machine hours per week 2,000 hours Required) a) What is the contribution margin per machine hour for each model? (10...
What is the relationship between transportation models and more general logistics models? Explain how these two...
What is the relationship between transportation models and more general logistics models? Explain how these two types of linear optimization models are similar and how they are different.
What is the main difference between Deterministic Models and Stochastic Models? Provide two examples for each...
What is the main difference between Deterministic Models and Stochastic Models? Provide two examples for each type of models.
Howrley-David, Inc., manufactures two models of motorcycles: the Fatboy and the Screamer. Both models are assembled...
Howrley-David, Inc., manufactures two models of motorcycles: the Fatboy and the Screamer. Both models are assembled in the same plant and require the same assembling operations. The difference between the models is the cost of materials. The following data are available for August: Fatboy Screamer Total Number of units assembled 810 1,620 2,430 Materials cost per unit $ 2,200 $ 3,200 Other costs: Direct labor $ 2,332,800 Indirect materials 388,800 Other overhead 1,166,400 Required: Howrley-David uses operations costing and assigns...
Shoe Shock Innovations manufactures athletic shoe inserts that cushion the foot and reduce the impact of...
Shoe Shock Innovations manufactures athletic shoe inserts that cushion the foot and reduce the impact of exercise on the joints. The company has two divisions, Sole Inserts and Heel Inserts. A segmented income statement from last month follows. Sole Inserts Division Heel Inserts Division Total Shoe Shock Sales revenue $497,000 $2,544,000 $3,041,000 Less variable expenses 300,000 2,036,000 2,336,000 Contribution margin 197,000 508,000 705,000 Less traceable fixed expenses 120,400 349,200 469,600 Segment margin $76,600 $158,800 235,400 Common fixed costs 172,900 Net...
Franklin Industries produces two electronic decoders, P and Q. Decoder P is more sophisticated and requires...
Franklin Industries produces two electronic decoders, P and Q. Decoder P is more sophisticated and requires more programming and testing than does Decoder Q. Because of these product differences, the company wants to use activity-based costing to allocate overhead costs. It has identified four activity pools. Relevant information follows: Activity Pools Cost Pool Total Cost Driver Repair and maintenance on assembly machine $ 69,600 Number of units produced Programming cost 100,860 Number of programming hours Software inspections 5,000 Number of...
Go Camera manufactures and sells two types of cameras for cars and drones. These two models...
Go Camera manufactures and sells two types of cameras for cars and drones. These two models are manufactured in separate facilities and each facility is treated as profit center. Go Camera serves as a supplier to car manufacturers as well as drone manufacturers. The following table provides cost and price information for each model: Car Camera Drone Camera Selling Price $70 $100 Variable Cost $30 $35 Fixed Cost $300,000 $ 600,000 Go Camera has a marketing department with cost $400,000...
(a) Wilder Company manufactures two models of its banjo, the Basic and the Luxury. The Basic...
(a) Wilder Company manufactures two models of its banjo, the Basic and the Luxury. The Basic model requires 10,000 direct labor hours and the Luxury requires 30,000 direct labor hours. The company produces 3,400 units of the Basic model and 600 units of the Luxury model each year. The company inspects one Basic for every 100 produced, and inspects one Luxury for every 10 produced. The company expects to incur $84,600 of total inspecting costs this year. How much of...
Kima Company manufactures and sells two models of a home appliance. The Standard model is a...
Kima Company manufactures and sells two models of a home appliance. The Standard model is a basic appliance with mostly manual features, while the Galaxy model is highly automated. The appliances are produced to order, and there are no inventories at the end of the year. The cost accounting system at Kima allocates overhead to products based on direct labor cost. Overhead in year 1, which just ended, was $3,342,250. Other data for year 1 for the two products follow:...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT