Warning: foreach() argument must be of type array|object, bool given in /var/www/html/web/app/themes/studypress-core-theme/template-parts/header/mobile-offcanvas.php on line 20

Question: Tent Pro produces two lines of tents sold to outdoor enthusiasts. The tents are cut to specifications in department A. In department B, the tents are sewn and folded. The activities, costs, and drivers associated with these two manufacturing processes and the company’s production support activities follow.

Process Activity Overhead Cost Driver Quantity

Department A Pattern alignment \( 64,400 Batches 560

Cutting 50,430 Machine hours 12,300

Moving product 100,800 Moves 2,400

\)215,630

Department B Sewing \(327,600 Direct labor hours 4,200

Inspecting 24,000 Inspections 600

Folding 47,880 Units 22,800

\)399,480

Support Design \(280,000 Modification orders 280

Providing space 51,600 Square feet 8,600

Materials handling 184,000 Square yards 920,000

\)515,600

Additional production information on the two lines of tents follows.

Pup Tent Pop-up Tent

Units produced……………. 15,200 units 7,600 units

Moves …………………….... 800 moves 1,600 moves

Batches ………………….... 140 batches 420 batches

Number of inspections .... 240 inspections 360 inspections

Machine hours …….......... 7,000 MH 5,300 MH

Direct labor hours ……… 2,600 DLH 1,600 DLH

Modification orders …… 70 modification orders 210 modification orders

Space occupied ……….. 4,300 square feet 4,300 square feet

Material required ……… 450,000 square yards 470,000 square yards

Required

1. Using a plantwide overhead rate based on direct labor hours, compute the overhead cost that is assigned to each pup tent and each pop-up tent.

2. Using the plantwide overhead rate, determine the total cost per unit for the two products if the direct materials and direct labor cost is \(25 per pup tent and \)32 per pop-up tent.

3. If the market price of the pup tent is \(65 and the market price of the pop-up tent is \)200, determine the gross profit per unit for each tent. What might management conclude about the pup tent?

4. Using ABC, compute the total cost per unit for each tent if the direct labor and direct materials cost is \(25 per pup tent and \)32 per pop-up tent.

5. If the market price is \(65 per pup tent and \)200 per pop-up tent, determine the gross profit per unit for each tent. Comment on the results.

6. Would your pricing analysis be improved if the company used, instead of ABC, departmental rates determined using machine hours in department A and direct labor hours in department B? Explain.

Short Answer

Expert verified

Using Plant-wide method

Cost per case (Pup tent):$71.05

Cost per case (Pop-up tent):$88.68

Using ABC method

Cost per case (Pup tent):$58.45

Cost per case (Pop-up tent): $113.86

Step by step solution

01

Calculation of overhead cost

TotalOverheadcost=Department1totaloverheadcost+Department2totalOverheadcost+Totalsupportoverheadcost=$215,630+$399,480+$515,600=$1,130,710

Plantwideoverheadallocationratebasedondirectlabor=TotaloverheadcostTotaldirectlaborhour=$1,130,7102,600+1,600=$1,130,7104,200=$269.217

TotaloverheadcostforPuptent=Plantwiderate×DirectlaborhourforPupTent=$269.00×1,600=$699,972

TotaloverheadcostforPopupTent=Plantwiderate×DirectLaborhourforpopupTent=$269.22×1,600=$430,752

02

Calculation of total cost per unit

TotalCostperunitforPupTent=DirectMaterialandDirectLaborcostperunit+PlantwideOverheadCostperunit=$25+$699,97215,200=$71.05


TotalCostperunitforPopupTent=DirectMaterialLaborcostperunit+PlantwideOverheadcostperunit=$32+$430,7507,600=$88.68


03

Calculation of gross profit per unit

GrosProfitperunitforPupTent=Marketpriceperunit-TotalCostperunit=$65-$71.05=$6.05

GrossProfitperunitforPop-upTent=Marketpriceperunit-TotalCostperunit=$200-$88.68=$11.32

By looking at the data it can be concluded that product line 1 is a not profitable product and product line 2 is a profitable product. Loss arising from product line 1 can be recovered from product line 2.

04

Calculation of total cost per unit under ABC

Computation of total cost per unit for Pup Tent

Patternalignmentcostperunit=TotalcostTotalBatchses×TotalbatchesbyPuptentTotalunitsproduced=$64,400560×14015,200=$1.89

Cuttingcostperunit=TotalcostTotalmachinehour×TotalmachinehourbyPuptentTotalunitsproduced=$50,43012,300×7,00015,200=$1.89

MovingProductcostperunit=TotalcostTotalno.ofmoves×Totalno.ofmovesbyPuptentTotalunitsproduced=$100,8002,400×80015,200=$2.21

Sewingcostperunit=TotalcostTotalDLhours×TotalDLhoursbyPuptentTotalunitsproduced=$327,6004,200×2,60015,200=$13.34

Inspectingcostperunit=TotalcostTotalno.ofinspections×No.ofInspectionsbyPuptentTotalunitsproduced=$24,000600×24015,200=$0.63

Fodingcostperunit=TotalcostTotalno.ofunits=$47,88022,800=$2.1

Designcostperunit=TotalcostTotalmodificationorder×No.ofmodificationorderbyPupTotalunitsproduced=$280,000280×7015,200=$4.61

Providingcostperunit=TotalcostTotalsquarefeet×No.ofsquareyardbyPuptentTotalunitsproduced=$184,000920,000×450,00015,200=$5.92

Materialhandlingcostperunit=TotalTotalsquareyard×No.ofsquareyardbyPuptentTotalunitsproduced=$184,000920,000×450,00015,200=$5.92

TotalcostperunitforPuptent=DirectMaterialandDirectLaborCost+TotalOverheadcostforpuptent=$125+($1.06+$1.89+$2.21+$13.34+$0.63+$2.1+$4.61+$1.69+$5.92)=$58.45

Computation of total cost per unit for Pop-up Tent

Patternalignmentcostperunit=TotalcostTotalBatches×TotalbatchesbyPop-uptentTotalunitsproduced=$64,400560×4207,600=$6.36

Cuttingcostperunit=TotalcostTotalmachinehour×TotalmachinehourbyPop-uptentTotalunitsproduced=$50,43012,300×5,3007,600=$2.86

role="math" localid="1654859103417" MovingProductcostperunit=TotalcostTotalno.ofmoves×TotalmachinehourbyPop-uptentToatlunitsproduced=$100,8002,400×1,6007,600=$8.84

Sewingcostperunit=TotalcostTotalDLhours×TotalDLhoursbyPop-uptentTotalunitsproduced=$327,6004,200×1,6007,600=$16.42

Inspectingcostperunit=TotalcostTotalno.ofinspections×No.ofinspectionbyPop-uptentTotalunitsproduced=$24,000600×3607,600=$1.89

Foldingcostperunit=TotalcostTotalno.ofunits=$47,88022,800=$2.1

Designcostperunit=TotalcostTotalmodificationorder×No.ofmodificationorderbyPop-uptentTotalunitsproduced=$280,000280×2107,600=$27.63

Providingcostperunit=TotalcostTotalsquarefeet×No.ofsquarefeetbyPop-uptentTotalunitsproduced=$51,6008,600×4,3007,600=$3.39

Materialhandlingcostperunit=TotalTotalsquareyard×No.ofsquareyardbyPop-uptentTotalunitsproduced=$184,000920,000×470,0007,600=$12.37

TotalCostperunitforPop-uptent=DirectmaterialsandDirectlaborcost+TotalOverheadCostforPop-uptent=$32+($6.36+$2.86+$8.84+$16.42+$1.89+$2.1+$27.63+$3.39+$12.37)=$113.86

05

Calculation of gross profit per unit under ABC

GrossProfitperunitforPuptent=Marketpriceperunit-Totalcostperunit=$65-$58.45=$6.55

GrossprofitperunitforPop-uptent=Marketpriceperunit-Totalcostperunit=$200-$113.86=$86.14

By looking at the data it can be concluded that both the product lines are profitable. Based on ABC method, the cost has been allocated accurately.

06

Pricing analysis

Computation of total cost per unit for Pup tent

Department1costpercase=TotalcostTotalmachinehour×TotalMachinehourbyPuptentTotalunitsproduced=$215,63012,300×7,00015,200=$8.07

Department2costpercase=TotalcostTotalDLhours×DLhourbyPoptentTotalunitsproduced=$399,4804,200×2,60015,200=$16.27

Designcostperunit=TotalcostTotalmodificationorder×No.ofmodificationorderbyPop-uptentTotalunitsproduced=$280,000280×21015,200=$4.61

ProvidingCostperunit=TotalcostTotalsquarefeet×No.ofsquarefeetbyPuptentTotalunitsproduced=$51,6008,600×4,30015,200=$1.69

Materialhandlingcostperunit=TotalTotalsquareyard×No.ofsquareyardbyPop-uptentTotalunitsproduced=$184,000920,000×450,00015,200=$5.92

Totalcostperunit=DirectmaterialandDirectlaborcost+TotalOverheadCostforPuptent=$25+($8.07+$16.27+$4.61+$1.69+$5.92)=$61.56

Computation of total cost per unit for Pop-up tent

Department1costpercase=TotalcostTotalmachinehour×TotalMachinehourbyPuptentTotalunitsproduced=$215,63012,300×5,3007,600=$12.23

Department2costpercase=TotalcostTotalDLhours×DLhourbyPoptentTotalunitsproduced=$399,4804,200×1,6007,600=$20.02

Designcostperunit=TotalcostTotalmodificationorder×No.ofmodificationorderbyPop-uptentTotalunitsproduced=$280,000280×2107,600=$27.63

ProvidingCostperunit=TotalcostTotalsquarefeet×No.ofsquarefeetbyPuptentTotalunitsproduced=$51,6008,600×4,3007,600=$12.37

Materialhandlingcostperunit=TotalTotalsquareyard×No.ofsquareyardbyPop-uptentTotalunitsproduced=$184,000920,000×470,0007,600=$12.37

Totalcostperunit=DirectmaterialandDirectlaborcost+TotalOverheadCostforPuptent=$32+($12.23+$20.02+$27.63+$3.39+$12.37)=$107.64

No, the pricing analysis would not improve if the company uses departmental rate as the cost per unit would increase in both the case.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

The chief executive officer (CEO) of your company recently returned from a luncheon meeting

where activity-based costing was presented and discussed. Though her background is not in accounting, she has worked for the company for 15 years and is thoroughly familiar with its operations. Her impression of the presentation about ABC was that it was just another way of dividing up total overhead cost and that the total would still be the same “no matter how you sliced it.”

Required

Write a memorandum to the CEO, no more than one page, explaining how ABC is different from traditional volume-based costing methods. Also, identify its advantages and disadvantages vis-à-vis traditional methods. Be sure it is written to be understandable to someone who is not an accountant.

Bright Day Company produces two beverages, Hi-Voltage and EasySlim. Data about these products follow.

Hi-Voltage EasySlim

Production volume ………………… 12,500 bottles 180,000 bottles

Liquid materials ……………………. 1,400 gallons 37,000 gallons

Dry materials ……………………….. 620 pounds 12,000 pounds

Bottles ………………………………. 12,500 bottles 180,000 bottles

Labels ……………………………….. 3 labels per bottle 1 label per bottle

Machine setups ……………………. 500 setups 300 setups

Machine hours ……………………... 200 MH 3,750 MH

Additional data from its two production departments follow.

Department Driver Cost

Mixing department

Liquid materials ……………………. Gallons \( 2,304

Dry materials ……………………….. Pounds 6,941

Utilities ……………………………… Machine hours 1,422

Bottling department

Bottles ………………………………. Units \)77,000

Labeling …………………………….. Labels per bottle 6,525

Machine setup …………………….. Setups 20,000

Required

1. Determine the cost of each product line using ABC.

2. What is the cost per bottle of Hi-Voltage? What is the cost per bottle of EasySlim? (Hint:Your answer should draw on the total cost for each product line computed in requirement 1.)

3. If Hi-Voltage sells for $3.75 per bottle, how much profit does the company earn per bottle of Hi- Voltage that it sells?

4. What is the minimum price that the company should set per bottle of EasySlim? Explain.

Glassworks Inc. produces two types of glass shelving, rounded edge and squared edge, on the same production line. For the current period, the company reports the following data.

Rounded Edge Squared Edge Total

Direct materials …………… \(19,000 \) 43,200 \( 62,200

Direct labor ………………… 12,200 23,800 36,000

Overhead 36,600 71,400 108,000

(300% of direct labor cost)

Total cost ………………….. \) 67,800 \( 138,400 \) 206,200

Quantity produced ……….. 10,500 ft. 14,100 ft.

Average cost per ft. (rounded) \( 6.46 \) 9.82

Glassworks'controller wishes to apply activity-based costing (ABC) to allocate the \(108,000 of overhead costs incurred by the two product lines to see whether cost per foot would change markedly from that reported above. She has collected the following information.

Overhead Cost Category (Activity Cost Pool) Cost

Supervision ……………………………………………………………….. \) 5,400

Depreciation of machinery ……………………………………………… 56,600

Assembly line preparation ……………………………………………… 46,000

Total overhead ……………………………………………………………. \(108,000

She has also collected the following information about the cost drivers for each category (cost pool) and the amount of each driver used by the two product lines.

Overhead Cost Category Usage

(Activity Cost Pool) Driver Rounded Edge Squared Edge Total

Supervision …………. Direct labor \)12,200 \(23,800 \)36,000

cost ($)

Depreciation Machine hours 500 hours 1,500 hours 2,000 hours

of machinery

Assembly Setups (number) 40 times 210 times 250 times

line preparation

Required

1. Assign these three overhead cost pools to each of the two products using ABC.

2. Determine average cost per foot for each of the two products using ABC.

3. Compare the average cost per foot under ABC with the average cost per foot under the current method for each product. Explain why a difference between the two cost allocation methods exists.

Textra Plastics produces parts for a variety of small machine manufacturers. Most products go through two operations, molding and trimming, before they are ready for packaging. Expected costs and activities for the molding department and for the trimming department for 2017 follow.

Molding

Trimming

Direct labor hours

52,000 DLH

48,000 DLH

Machine hours

30,500 MH

3,600 MH

Overhead costs

\(730,000

\)590,000

Data for two special order parts to be manufactured by the company in 2017 follow.

Part A27C

Part X82B

Number of units

9,800 units

54,500 units

Machine hours

Molding

5,100 MH

1,020 MH

Trimming

2,600 MH

650 MH

Direct labor hours

Molding

5,500 DLH

2,150 DLH

Trimming

700 DLH

3,500 DLH

Required

  1. Compute the plantwide overhead rate using direct labor hours as the base.
  2. Determine the overhead cost assigned to each product line using the plantwide rate computed inrequirement 1.

Question: Midwest Paper produces cardboard boxes. The boxes require designing, cutting, and printing. (The boxes are shipped flat, and customers fold them as necessary.) Midwest has a reputation for providing high quality products and excellent service to customers, who are major U.S. manufacturers. Costs are assigned to products based on the number of machine hours required to produce them. Three years ago, a new marketing executive was hired. She suggested the company offer custom design and manufacturing services to small specialty manufacturers. These customers required boxes for their products and were eager to have Midwest as a supplier. Within one year, Midwest found that it was so busy with orders from small customers, it had trouble supplying boxes to all its customers on a timely basis. Large, long-time customers began to complain about slow service, and several took their business elsewhere. Within another 18 months, Midwest was in financial distress with a backlog of orders to be filled.

Required

1. What do you believe are the major costs of making boxes? How are those costs related to the volume of boxes produced?

2. How did Midwest’s new customers differ from its previous customers?

3. Would the unit cost to produce a box for new customers be different from the unit cost to produce a box for its previous customers? Explain.

4. Could Midwest’s fate have been different if it had used ABC for determining the cost of its boxes?

5. What information would have been available with ABC that might have been overlooked using a traditional volume-based costing method?

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free