Determine total amount of manufacturing overhead cost


Response to the following problem:

Java Source, Inc. (JSI), is a processor and distributor of a variety of blends of coffee. The company buys coffee beans from around the world and roasts, blends, and packages them for resale. JSI offers a large variety of different coffees that it sells to gourmet shops in one-pound bags. The major cost of the coffee is raw materials. However, the company's predominantly automated roasting, blending, and packing processes require a substantial amount of manufacturing overhead. The company uses relatively little direct labor.

Some of JSI's coffees are very popular and sell in large volumes, while a few of the newer blends sell in very low volumes. JSI prices its coffees at manufacturing cost plus a markup of 25%, with some adjustments made to keep the company's prices competitive.

For the coming year, JSI's budget includes estimated manufacturing overhead cost of $2,200,000. JSI assigns manufacturing overhead to products on the basis of direct labor-hours. The expected direct labor cost totals $600,000, which represents 50,000 hours of direct labor time. Based on the sales budget and expected raw materials costs, the company will purchase and use $5,000,000 of raw materials (mostly coffee beans) during the year.

The expected costs for direct materials and direct labor for one-pound bags of two of the company's coffee products appear below.

 

Kenya Dark

Viet Select

Direct materials

$4.50

$2.90

Direct labor (0.02 hours per bag)

$0.24

$0.24

JSI's controller believes that the company's traditional costing system may be providing misleading cost information. To determine whether or not this is correct, the controller has prepared an analysis of the year's expected manufacturing overhead costs, as shown in the following table:

Activity Cost Pool

Activity Measure

Expected Activity for the Year

Expected Cost for the Year

Purchasing

Purchase orders

2000 orders

$560,000

Material handling

Number of setups

1,000 setups

$193,000

Quality control

Number of batches

500 batches

$90,000

Roasting

Roasting hours

95,000 roasting hours

$1,045,000

Blending

Blending hours

32,000 blending hours

$192,000

Packaging

Packaging hours

24,000 packaging hours

$120,000

Total manufacturing overhead cost

 

 

$2,200,000

Data regarding the expected production of Kenya Dark and Viet Select coffee are presented below.

 

Kenya Dark

Viet Select

Expected sales

80,000 pounds

4,000 pounds

Batch size

5,000 pounds

500 pounds

Setups

2 per batch

2 per batch

Purchase order size

20,000 pounds

500 pounds

Roasting time per 100 pounds

1.5 roasting hours

1.5 roasting hours

Blending time per 100 pounds

0.5 blending hours

0.5 blending hours

Packaging time per 100 pounds

0.3 packaging hours

0.3 packaging hours

Required:

1.    Using direct labor-hours as the base for assigning manufacturing overhead cost to products, do the following:

a.     Determine the predetermined overhead rate that will be used during the year. 

b.     Determine the unit product cost of one pound of the Kenya Dark coffee and one pound of the Viet Select coffee. 

2.     Using activity-based costing as the basis for assigning manufacturing overhead cost to products, do the following:

a.    Determine the total amount of manufacturing overhead cost assigned to the Kenya Dark coffee and to the Viet Select coffee for the year. 

b.    Using the data developed in (2a) above, compute the amount of manufacturing overhead cost per pound of the Kenya Dark coffee and the Viet Select coffee. Round all computations to the nearest whole cent. 

c.     Determine the unit product cost of one pound of the Kenya Dark coffee and one pound of the Viet Select coffee. 

3.     Answer the following for Viet and Kenya coffee. Using ABC, what was the implication on the current pricing.  

a.      Is Viet priced to achieve a profit?

b.    Reflect on the Harvard business case to determine if the current situation for Viet and Kenya, does one of the product lines subsidize the other?

c.     Does Java Source need to consider any pricing changes? 

Solution Preview :

Prepared by a verified Expert
Cost Accounting: Determine total amount of manufacturing overhead cost
Reference No:- TGS02125744

Now Priced at $25 (50% Discount)

Recommended (92%)

Rated (4.4/5)