Question

*** Please show excel formulas, thanks *** Babaloo leather company produces briefcases from leather, fabric, and...

*** Please show excel formulas, thanks ***

Babaloo leather company produces briefcases from leather, fabric, and synthetic materials in a single production department. The basic product is a standard briefcase made from leather and lined with fabric. Babaloo has a good reputation in the market because the standard briefcase is a high-quality item that has been produced for many years.

Last year, the company decided to expand its product line and produce specialty briefcases for special orders. These briefcases differ from the standard in that they vary in size, contain both leather and synthetic materials, and are imprinted with the buyer’s logo (the standard briefcase is simply imprinted with the Babaloo name in small letters). The decision to use some synthetic materials in the briefcase was made to hold down the materials cost. To reduce the labor costs per unit, most of the cutting and stitching on the specialty briefcases is done by automated machines, which are used to a much lesser degree in the production of the standard briefcases. Because of these changes in the design and production of the specialty briefcases, Babaloo management believed that they would cost less to produce than the standard briefcases. However, because they are specialty items, they were priced slightly higher; standards are priced at $30 and specialty briefcases at $32.

After reviewing last month’s results of operations, Babaloo’s president became concerned about the profitability of the two product lines because the standard briefcase showed a loss while the specialty briefcase showed a greater profit margin than expected. The president is wondering whether the company should drop the standard briefcase and focus entirely on specialty items. Units and cost data for last month’s operations as reported to the president are as follows:

Units produced

10,000.00

2,500.00

Direct materials

Leather (1 sq. yd. x $15.00; 112 sq. yd. x $15.00)

15.00

7.50

Fabric (1 sq. yd. x $5.00; 1 sq. yd. x $5.00)

5.00

5.00

Synthetic

5.00

Total materials

20.00

17.50

Direct labor (1/2 hr. x $12.00, 1/4 hr. x $12.00)

6.00

3.00

Manufacturing overhead (1/2 hr. x $8.98; 1/4 hr. x $8.98)

4.49

2.25

Cost per unit

30.49

22.75

Factory overhead is applied on the basis of direct labor hours. The rate of $8.98 per direct labor hour was calculated by dividing the total overhead ($50,500) by the direct labor hours (5,625). As shown in the table, the cost of a standard jacket is $0.49 higher than its $30 sales price; the specialty jacket has a cost of only $22.75, for a gross profit per unit of $9.25. The problem with these costs is that they do not accurately reflect the activities involved in manufacturing each product. Determining the costs using ABC should provide better product costing data to help gauge the actual profitability of each product line. The manufacturing overhead costs must be analyzed to determine the activities driving the costs. Assume that the following costs and cost drivers have been identified:

•             The Purchasing Department's cost is $6,000. The major activity driving these costs is the number of purchase orders processed. During the month, the Purchasing Department prepared the following number of purchase orders for the materials indicated:

Leather

20

Fabric

30

Synthetic Material

50

•             The cost of receiving and inspecting materials is $7,500. These costs are driven by the number of deliveries. During the month, the following number of deliveries were made:

Leather

30

Fabric

40

Synthetic Material

80

•             Production line setup cost is $10,000. Setup activities involve changing the machines to produce the different types of jackets. Each setup for production of the standard jackets requires one hour; each setup for specialty jackets requires two hours. Standard jackets are produced in batches of 200, and specialty jackets are produced in batches of 25. During the last month, there were 50 setups for the standard item and 100 setups for the specialty item.

•             The cost of inspecting finished goods is $8,000. All jackets are inspected to ensure that quality standards are met. However, the final inspection of standard jackets takes very little time because the employees identify and correct quality problems as they do the hand cutting and stitching. A survey of the personnel responsible for inspecting the final products showed that 150 hours were spent on standard jackets and 250 hours on specialty jackets during the month.

•             Equipment-related costs are $6,000. Equipment-related costs include repairs, depreciation, and utilities. Management has determined that a logical basis for assigning these costs to products is machine hours. A standard jacket requires 1/2 hour of machine time, and a specialty jacket requires two hours. Thus, during the last month, 5,000 hours of machine time relate to the standard line and 5,000 hours relate to the specialty line.

•             Plant-related costs are $13,000. These costs include property taxes, insurance, administration, and others. For the purpose of determining average unit costs, they are to be assigned to products using machine hours.

Required:

a.            Using activity-based costing concepts, what overhead costs should be assigned to the two products?

b.            What is the unit cost of each product using activity-based costing concepts?

c.             Reevaluate the president's concern about the profitability of the two product lines.

d.            Discuss the merits of activity-based management as it relates to Babaloo's ABC cost system. Please do not state the obvious. Use this example to identify the merits and compare it with the traditional system. How your decision would be affected in either case

*** Please show excel formulas, thanks ***

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Babaloo leather company produces briefcases from leather, fabric, and synthetic materials in a single production department....
Babaloo leather company produces briefcases from leather, fabric, and synthetic materials in a single production department. The basic product is a standard briefcase made from leather and lined with fabric. Babaloo has a good reputation in the market because the standard briefcase is a high-quality item that has been produced for many years. Last year, the company decided to expand its product line and produce specialty briefcases for special orders. These briefcases differ from the standard in that they vary...
Fine Clothing Company produces Jackets from leather, fabric, and synthetic materials in a single production department....
Fine Clothing Company produces Jackets from leather, fabric, and synthetic materials in a single production department. The basic product is a standard jacket made from leather and lined with fabric. Fine Clothing has a good reputation in the market because the standard jacket is a high-quality item that has been produced for many years. Last year, the company decided to expand its product line and produce specialty jackets for special orders. These jackets differ from the standard in that they...
Fine Clothing Company produces Jackets from leather, fabric, and synthetic materials in a single production department....
Fine Clothing Company produces Jackets from leather, fabric, and synthetic materials in a single production department. The basic product is a standard jacket made from leather and lined with fabric. Fine Clothing has a good reputation in the market because the standard jacket is a high-quality item that has been produced for many years. Last year, the company decided to expand its product line and produce specialty jackets for special orders. These jackets differ from the standard in that they...
Bunker makes two types of briefcase, fabric and leather. The company is currently using a traditional...
Bunker makes two types of briefcase, fabric and leather. The company is currently using a traditional costing system with labor hours as the cost driver but is considering switching to an activity-based costing system. In preparation for the possible switch, Bunker has identified two activity cost pools: materials handling and setup. Pertinent data follow:      Fabric Case Leather Case Number of labor hours 24,000 9,000 Number of material moves 798 1,102 Number of setups 42 188 Total estimated overhead costs are...
Bunker makes two types of briefcase, fabric and leather. The company is currently using a traditional...
Bunker makes two types of briefcase, fabric and leather. The company is currently using a traditional costing system with labor hours as the cost driver but is considering switching to an activity-based costing system. In preparation for the possible switch, Bunker has identified two activity cost pools: materials handling and setup. Pertinent data follow:        Fabric Case   Leather Case Number of labor hours   14,000      16,000      Number of material moves   765      935      Number of setups   45  ...
Lloyd and Harry, Inc. is a manufacturer of briefcases. The company produces and sells two products:...
Lloyd and Harry, Inc. is a manufacturer of briefcases. The company produces and sells two products: Leather and Vinyl. Currently, the company uses a traditional costing system to allocate manufacturing overhead to production based on a predetermined manufacturing overhead rate of $100 per machine hour. Management is considering switching to activity based costing to improve costing accuracy. In their analysis of manufacturing overhead, management has identified two activities and cost pools: Product Inspection and Machining. 80% of the total budgeted...
Pato Company produces leather sandals. The company employs a standard costing system and has the following...
Pato Company produces leather sandals. The company employs a standard costing system and has the following standards in order to produce one pair of sandals: standard quantity standard price direct materials 2 leather strips ?? per strip direct labor 2.5 hours $12 per hour variable overhead 2.5 hours ?? per hour During May, Pato purchased leather strips at a total cost of $124,250 and had direct labor totaling $171,100. During May, Pato used 13,600 leather strips in the production of...
Pato Company produces leather sandals. The company employs a standard costing system and has the following...
Pato Company produces leather sandals. The company employs a standard costing system and has the following standards in order to produce one pair of sandals: standard quantity standard price direct materials 2 leather strips ?? per strip direct labor 2.5 hours $10 per hour variable overhead 2.5 hours ?? per hour During May, Pato purchased leather strips at a total cost of $124,520 and had direct labor totaling $117,100. During May, Pato used 18,790 leather strips in the production of...
Budget Variances, Materials and Labor Cinturon Corporation produces high-quality leather belts. The company's plant in Boise...
Budget Variances, Materials and Labor Cinturon Corporation produces high-quality leather belts. The company's plant in Boise uses a standard costing system and has set the following standards for materials and labor: Leather (2 strips @ $6.00) $12.00 Direct labor (0.25 hr. @ $11.00) 2.75 Total prime cost $14.75 During the first month of the year, the Boise plant produced 31,000 belts. Actual leather purchased was 100,000 strips at $3.30 per strip. There were no beginning or ending inventories of leather....
McKnight Recliners manufactures leather recliners and uses flexible budgeting and a standard cost system. McKnight allocates...
McKnight Recliners manufactures leather recliners and uses flexible budgeting and a standard cost system. McKnight allocates overhead based on yards of direct materials. The? company's performance report includes the following selected? data: Static Budget Actual Results (1,000 recliners) (980 recliners) Sales (1,000 recliners x $500 each) $500,000 (980 recliners x $475 each) $465,500 Variable Manufacturing Costs: Direct Materials (6,000 yds. @ $8.50 / yd.) 51,000 (6,143 yds. @ $8.30 / yd.) 50,987 Direct Labor (10,000 DLHr @ $9.30 / DLHr)...