Allocation Rates College Paper Lab | collegepaperslab.com

Business Finance

Allocation Rates College Paper Lab | collegepaperslab.com

HOMEWORK PROBLEM 6-1

ABC Costing

High Mountain Coffee Co. is a processor and distributor of different blends of quality coffee. The company buys beans from around the world and roasts, blends and packages them for resale. There are presently 15 different flavors which are sold to gourmet shops in one pound bags. The major cost is raw materials; however, there is substantial amount of manufacturing overhead in the product. This relates to the high level of automation in the roasting and packing. The company uses very little direct labor.

Some of the flavors are very popular and sell in large volumes while a few newer blends have very low volumes. High Mountain prices its coffee at full product cost including allocated overhead plus a markup of 30%. High Mountain competes with comparable qualities but customers are cost conscience.

Data for the 2011 budget includes manufacturing overhead of $3,000,000; direct labor of $600,000, and raw materials of $6,000,000. Total plant production is estimated to be 3,000,000 pounds of coffee.

The expected prime costs for one pound bags of the two following products are as follows:

KAYAKER’S DELIGHT

BRUNDAGE BLENDED

DIRECT MATERIAL

$3.20

$4.20

DIRECT LABOR

$.30

$.30

High Mountain has also developed the following budgeted manufacturing overhead information for 2011.

ACTIVITY

COST DRIVER

BUDGETED ACTIVITY

BUDGETED

COST

PURCHASING

PURCHASE ORDERS

1,158

$579,000

MATERIAL HANDLING

SETUPS

1,800

$720,000

QUALITY CONTROL

BATCHES

720

$144,000

ROASTING

ROASTING HOURS

96,100

$961,000

BLENDING

BLENDING HOURS

33,600

$336,000

PACKAGING

PACKAGES

260,000

$260,000

TOTAL MFG OVERHEAD

$3,000,000

Data regarding the 2011 production of Kayaker’s and Brundage coffee are shown in the following table. There will be no raw material inventory for either of these coffees at the beginning of the year.

KAYAKER’S

BRUNDAGE

BUDGETED SALES

2,000 LBS

100,000 LBS

BATCH SIZE

500 LBS

10,000 LBS

SETUPS

3

5

PURCHASE ORDER SIZE

500 LBS

25,000 LBS

ROASTING TIME

1 HR/100 LBS

1 HR/100 LBS

BLENDING TIME

.5 HR/100 LBS

.5 HR/100 LBS

PACKAGING

1 LB PER PACKAGE

1 LB PER PACKAGE

Required:

1. Calculate the overhead allocation rate for each blend using direct labor dollars as the driver.

2. Calculate the overhead allocation rate for each blend assuming number of pounds is the driver.

3. Calculate the overhead allocation

College Paper Lab

Place your Order Today

- collegepaperslab.com