Financial & Managerial Accounting
Financial & Managerial Accounting
17th Edition
ISBN: 9780078025778
Author: Jan Williams, Susan Haka, Mark S Bettner, Joseph V Carcello
Publisher: McGraw-Hill Education
Question
Book Icon
Chapter 19, Problem 2AP

a.

To determine

Calculate the target cost for Product K and Product Q.

a.

Expert Solution
Check Mark

Explanation of Solution

Target costing:

Target costing is a business procedure that targets at the earliest stages of new product and service development, before creating and designing of production techniques.

Calculate the target cost for Product K.

Targetcost=TargetpriceTargetprofit=$120$18(1)=$102

Working note:

Targetprofit=Percentageofreturnonsales×Targetprice=15%×$120=$18

(1)

Calculate the target cost of the product Q.

Targetcost=TargetpriceTargetprofit=$220$33(2)=$187

Working note:

Targetprofit=Percentageofreturnonsales×Targetprice=15%×$220=$33

(2)

Therefore, the target cost of product K is $102 and product Q is $187.

b.

To determine

Estimate the total manufacturing cost per unit of each product if fixed overhead costs are assigned to products on the basis of estimated production in units and state the product which is earning the desired income.

b.

Expert Solution
Check Mark

Explanation of Solution

Manufacturing overhead costs:

Manufacturing overhead costs are costs that are not directly related with the manufacturing of the products and it is also known as indirect costs. For example, indirect materials, indirect labour, indirect supplies.

Calculate the total manufacturing cost per unit:

ParticularsProduct KProduct Q
Direct materials cost per unit$30$45
Direct labor cost per unit$24$60
Variable overhead cost$6$15
Fixed overhead cost  (3)$50$50
Total manufacturing cost per unit$110$170

Table (1)

  • The cost per unit of Product K is above its target cost of $102, thus it is not earnings the desired 15% return.
  • The cost per unit of Product Q is below its target cost of $187, thus it is earnings a greater return than the desired rate.

Working note:

Calculate the fixed overhead cost per unit:

Allocationrateperunit=FixedoverheadTotalunitsofproduction=$2,000,00025,000(Productk)+15,000(ProductQ)=$50perunit

(3)

Conclusion
  • The manufacturing cost per unit of product K is $110 and for product Q is $170.
  • Product Q is earning the desired income from the above estimation.

c.

To determine

Recalculate the total manufacturing cost per unit if fixed overhead costs are assigned to products on the basis of direct labor hours and identify the product that is earning the desired income.

c.

Expert Solution
Check Mark

Explanation of Solution

Manufacturing overhead costs:

Manufacturing overhead costs are costs that are not directly related with the manufacturing of the products and it is also known as indirect costs. For example, indirect materials, indirect labour, indirect supplies.

Recalculate the total manufacturing cost per unit of the products:

ParticularsProduct KProduct Q
Direct materials cost per unit$30$45
Direct labor cost per unit$24$60
Variable overhead cost$6$15
Fixed overhead cost$32$80
Total manufacturing cost per unit$92$200

Table (2)

  • The cost per unit of Product K is below its target cost of $102 thus, it is earning a greater return than the desired rate.
  • The cost per unit of Product Q is above its target cost of $187 thus, it is not earnings the desired return.

Working notes:

Calculate the time taken to produce each unit of Product K:

TimetakentoproduceeachunitofproductK)=TotallaborcostperunitPerhourwagerate=$24$12=2hours

(4)

Calculate the time taken to produce each unit of Product Q:

TimetakentoproduceeachunitofproductQ)=TotallaborcostperunitPerhourwagerate=$60$12=5 hours

(5)

Calculate the total time taken to produce the estimated production of Product K:

Totaltimetaken=(Estimatedprodction×TimetakentoproduceeachunitofproductK)=25,000units×2(4)hoursperunit=50,000hours

(6)

Calculate the total time taken to produce the estimated production of Product Q:

Totaltimetaken=(Estimatedprodction×TimetakentoproduceeachunitofproductK)=15,000units×5(5)hoursperunit=75,000hours

(7)

Calculate the allocation rate per hour:

Allocationrateperunit=FixedOverheadTotaldirectlaborhours=$2,000,000125,000hours=$16perhour

Note:125,000hours=50,000hours+75,000hours

(8)

Calculate the fixed overhead cost of product K:

FixedoverheadcostofProductk=(Timetakentoproduceeachunitofproduct×Allocationrateperunit)=2hours(4)×$16/hours (8)=$32

(9)

Calculate the fixed overhead cost of product Q:

FixedoverheadcostofProductQ=(Timetakentoproduceeachunitofproduct×Allocationrateperunit)=5hours(5)×$16/hours(8)=$80

(10)

d.

To determine

Estimate the total manufacturing cost per unit of each product if activity-based costing is used for assigning fixed overhead costs and state the product that is earning the desired income under this method.

d.

Expert Solution
Check Mark

Explanation of Solution

Manufacturing overhead costs:

Manufacturing overhead costs are costs that are not directly related with the manufacturing of the products and it is also known as indirect costs. For example, indirect materials, indirect labour, indirect supplies.

Calculate the total manufacturing cost per unit of the products:

ParticularsProduct KProduct Q
Direct materials cost per unit$30$45
Direct labor cost per unit$24$60
Variable overhead cost$6$15
Fixed overhead cost (11)$36.40$72.67
Total manufacturing cost per unit$96.40$192.67

Table (3)

Therefore, the total manufacturing cost per unit of product K and Product Q is $96.40 and $192.67.

Working note:

Calculate the fixed overhead allocation per unit:

Particulars

Product K (In numbers)Product Q (In numbers)

Allocation rate per unit

Total fixed overhead cost
Activity cost pools(a)(b)(c) Product K (d) = (a) × (c)Product Q (d) = (b) × (c)
Setup costs100400$800$80,000$320,000
Purchase orders200100$2,000$400,000$200,000
Machining2,0006,000$63$125,000$375,000
Inspection5030$2,500$125,000$75,000
Shipping300200$600$180,000$120,000
Total fixed overhead allocated units produced$910,000$1,090,000
 ÷Units produced÷25000÷15000
Fixed overhead cost per unit$36.40$72.67

Table (4)

Note: For the calculation of allocation rate per unit refer Table (5)

(11)

Calculate the allocation rate of each overhead:

Financial & Managerial Accounting, Chapter 19, Problem 2AP

Overhead costs

(a)

Rate per set up ( Product k)

(b)

Rate per set up ( Product Q)

(c)

Total rate per set up

(d)=(b)+(c)

Allocation rate per unit activity

(e) = (a) ÷ (d)

Machine setups $400,000$100$400$500$800
Purchase orders $600,000$200$100$300$2,000
Machining rate $500,000$2,000$6,000$8,000$62.50 (or) $63
Inspection  $200,000$50$30$80$2,500
Shipping $300,000$300$200$500$600

 Table (5)

(12)

Conclusion
  • The cost per unit of Product K is below the target cost of $102, thus it is earning a return greater than the desired rate.
  • The cost per unit of Product Q is above the target cost of $187, thus it is not earnings the desired return.

e.

To determine

State the proportion of fixed overhead that is value added, and mention the activity which can be improved first.

e.

Expert Solution
Check Mark

Explanation of Solution

  • Machining and shipping are the two fixed overhead activities that are value added and the proportion of these costs to total fixed overhead is calculated below:

            Proportionofoverheadcoststototalfixedcosts)=Machining+ShippingTotalfixedcosts×100=$500,000+$300,000$2,000,000×100=40%

  • Therefore, the proportion of machining and shipping overheads to total fixed costs is 40%.
  • The number of steps taken to produce product Q can be reduced and this appears to be a logical activity.

f.

To determine

Ascertain the impact of the design changes on the manufacturing costs of both products and mention the products that will earn the desired return.

f.

Expert Solution
Check Mark

Explanation of Solution

Manufacturing overhead costs:

Manufacturing overhead costs are costs that are not directly related with the manufacturing of the products and it is also known as indirect costs. For example, indirect materials, indirect labour, indirect supplies.

Calculate the manufacturing costs of product K and Product Q:

ParticularsProduct KProduct Q
Direct materials cost per unit$30$45
Direct labor cost per unit$24$60
Variable overhead cost$6$15
Fixed overhead cost  (13)$46$57
Total manufacturing cost per unit$106$177

Table (6)

Working note:

Calculate the fixed overhead cost of product K and product Q:

Particulars

Product K (In numbers)Product Q (In numbers)

Allocation rate per unit

Total fixed overhead cost
Activity cost pools(a)(b)(c)Product K (d) = (a) × (c)Product Q (d) = (b) × (c)
Setup costs$100$25(14)$3,200$320,000$80,000
Purchase orders$200$100$2,000$400,000$200,000
Machining$2,000$6,00$62.50$125,000$375,000
Inspection$50$30$2,500$125,000$75,000
Shipping$300$200$600$180,000$120,000
Total fixed overhead allocated units produced$1,150,000$850,000
 ÷Units produced÷25,000÷15,000
Fixed overhead cost per unit$46$56.67

Table (7)

Note: For the calculation of allocation rate per unit except for setup costs refer Table (5)

(13)

Calculate the new allocation rate per machine setup:

Allocationrateperunit(machinesetup)=FixedoverheadTotalunitsofproduction=$400,000100(Productk)+25(ProductQ)=$3,200perunit

(14)

Note: Units of production for product Q is reduced to 25 units.

Conclusion
  • The cost per unit of Product K is above the target cost of $102 thus, it will not earn the desired 15% return.
  • The cost per unit of Product Q is below the target cost of $187 thus, it will earn a return greater than the desired rate.

g.

To determine

Calculate the manufacturing costs for each product if the machine is purchased and find out whether the Product Q should be redesigned or should the machine be purchased.

g.

Expert Solution
Check Mark

Explanation of Solution

Manufacturing overhead costs:

Manufacturing overhead costs are costs that are not directly related with the manufacturing of the products and it is also known as indirect costs. For example, indirect materials, indirect labour, indirect supplies.

Calculate the manufacturing costs for each product if a new machine is purchased:

ParticularsProduct KProduct Q
Direct materials cost per unit$30$45
Direct labor cost per unit$24$60
Variable overhead cost$6$15
Fixed overhead cost (15)$34.80$62
Total manufacturing cost per unit$94.80$182

Table (8)

Working note:

Calculate the total fixed overhead allocated per unit:

Particulars

Product KProduct Q

Allocation rate per unit

Total fixed overhead cost
Activity cost pools(a)(b)(c)Product K (d) = (a) × (c)Product Q (d) = (b) × (c)
Setup costs$20$80(16)$2,000$40,000$160,000
Purchase orders$200$100$2,000$400,000$200,000
Machining$2,000$6,00$62.50$125,000$375,000
Inspection$50$30$2,500$125,000$75,000
Shipping$300$200$600$180,000$120,000
Total fixed overhead allocated units produced$870,000$930,000
 ÷Units produced÷25,000÷15,000
Fixed overhead cost per unit$34.80$62

Table (9)

Note: For the calculation of allocation rate per unit except for setup costs refer Table (5)

(15)

Calculate the new allocation rate per machine setup:

Allocationrateperunit(machinesetup)=FixedoverheadTotalunitsofproduction=$200,00020(Productk)+80(ProductQ)=$2,000perunit

(16)

Note: Units of production for product K is reduced to 20 units and for product Q is 80 units.

Conclusion
  • The machine is purchased because the total manufacturing costs is reduced by $200,000 that will increase profits by $200,000.
  • If Product Q is redesigned, there is no increase in profits, just a reallocation of fixed costs between the two products occurs.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Chapter 19 Solutions

Financial & Managerial Accounting

Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
FINANCIAL ACCOUNTING
Accounting
ISBN:9781259964947
Author:Libby
Publisher:MCG
Text book image
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Text book image
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Text book image
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Text book image
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Text book image
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education