Question

In: Accounting

World Gourmet Coffee Company (WGCC) is a distributor and processor of different blends of coffee. The...

World Gourmet Coffee Company (WGCC) is a distributor and processor of different blends of coffee. The company buys coffee beans from around the world and roasts, blends, and packages them for resale. WGCC currently has 15 different coffees that it offers to gourmet shops in one-pound bags. The major cost is raw materials; however, there is a substantial amount of manufacturing overhead in the predominantly automated roasting and packing process. The company uses relatively little direct labor.

Some of the coffees are very popular and sell in large volumes, while a few of the newer blends have very low volumes. WGCC prices its coffee at full product cost, including allocated overhead, plus a markup of 30 percent. If prices for certain coffees are significantly higher than market, adjustments are made. The company competes primarily on the quality of its products, but customers are price-conscious as well.

Data for the 20x1 budget include manufacturing overhead of $13,616,160, which has been allocated on the basis of each product’s direct-labor cost. The budgeted direct-labor cost for 20x1 totals $1,361,616. Based on the sales budget and raw-material budget, purchases and use of raw materials (mostly coffee beans) will total $6,100,000.

The expected prime costs for one-pound bags of two of the company’s products are as follows:

Kona Malaysian
Direct material $ 3.20 $ 4.20
Direct labor 0.70 0.70


WGCC’s controller believes the traditional product-costing system may be providing misleading cost information. She has developed an analysis of the 20x1 budgeted manufacturing-overhead costs shown in the following chart.

Activity Cost Driver Budgeted
Activity
Budgeted
Cost
Purchasing Purchase orders 2,391 $ 2,534,460
Material handling Setups 3,720 3,143,400
Quality control Batches 1,500 645,000
Roasting Roasting hours 195,200 4,489,600
Blending Blending hours 68,400 1,573,200
Packaging Packaging hours 53,500 1,230,500
Total manufacturing-overhead cost $ 13,616,160


Data regarding the 20x1 production of Kona and Malaysian 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.

Kona Malaysian
Budgeted sales 2,600 lb. 103,000 lb.
Batch size 650 lb. 20,600 lb.
Setups 3 per batch 3 per batch
Purchase order size 650 lb. 51,500 lb.
Roasting time 1 hr. per 100 lb. 1 hr. per 100 lb.
Blending time 0.5 hr. per 100 lb. 0.5 hr. per 100 lb.
Packaging time 0.1 hr. per 100 lb. 0.1 hr. per 100 lb.


Required:
1. Using WGCC’s current product-costing system:
a. Determine the company’s predetermined overhead rate using direct-labor cost as the single cost driver.
b. Determine the full product costs and selling prices of one pound of Kona coffee and one pound of Malaysian coffee.
2. Develop a new product cost, using an activity-based costing approach, for one pound of Kona coffee and one pound of Malaysian coffee.

Solutions

Expert Solution

Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks!
World Gourmet Coffee Company (WGCC)
Ans 1 a
Calculation of predetermined overhead rate Amount $ Note
Budgeted factory overhead 13,616,160.00 A
Budgeted direct labor cost     1,361,616.00 B
Predetermined overhead rate 1000% C=A/B
Ans 1 b- Workings Kona Malaysian Note
Direct labor cost                     0.70                      0.70 D
Predetermined overhead rate 1000% 1000% See C
Overhead allocated                     7.00                      7.00 E=C*D
Ans 1 b
Unit Product cost Kona Malaysian Note
Direct Materials                     3.20                      4.20
Direct Labor                     0.70                      0.70 See D
Overhead allocated                     7.00                      7.00 See E
Cost per 1 pound bag                  10.90                   11.90 F
Markup at 30%                     3.27                      3.57 G=F*30%
Sell price of 1 pound bag                  14.17                   15.47 H=F+G
Ans 2- Workings Kona Malaysian Note
Expected Sales             2,600.00         103,000.00 I
Batch Size                650.00            20,600.00 J
Number of Batches                     4.00                      5.00 K=I/J
Setups per Batch                     3.00                      3.00 L
Number of Setups                  12.00                   15.00 M=K*L
Purchase Orders Size                650.00            51,500.00 N
Purchase Orders                     4.00                      2.00 O=I/N
Roasting time per 100 pound                     1.00                      1.00 P
Roasting Hours                  26.00              1,030.00 Q=I/100*P
Blending time per 100 pound                     0.50                      0.50 R
Blending Hours                  13.00                 515.00 S=I/100*R
Packaging time per 100 pound                     0.10                      0.10 T
Packaging Hours                     2.60                 103.00 U=I/100*T
See workings above V W X=V/W Y Z=X*Y AA=Z/2600 AB AC=X*AB AD=AC/103000
Overhead allocation table Kona Malaysian
Activity Cost Driver Cost Pool Cost Driver Volume Cost per Cost Driver Cost Driver used Cost allocated Cost Per unit Cost Driver used Cost allocated Cost Per unit
Purchasing Purchase Orders      2,534,460.00       2,391.00 1,060.00                          4.00              4,240.00                      1.63                          2.00              2,120.00                      0.02
Material Handling Number of setups      3,143,400.00       3,720.00      845.00                        12.00            10,140.00                      3.90                        15.00            12,675.00                      0.12
Quality Control Number of batches         645,000.00       1,500.00      430.00                          4.00              1,720.00                      0.66                          5.00              2,150.00                      0.02
Roasting* Roasting Hours      4,489,600.00 195,200.00         23.00                        26.00                 598.00                      0.23                  1,030.00            23,690.00                      0.23
Blending Blending Hours      1,573,200.00     68,400.00         23.00                        13.00                 299.00                      0.12                     515.00            11,845.00                      0.12
Packaging Packaging Hours      1,230,500.00     53,500.00         23.00                          2.60              &nb

Related Solutions

World Gourmet Coffee Company (WGCC) is a distributor and processor of different blends of coffee. The...
World Gourmet Coffee Company (WGCC) is a distributor and processor of different blends of coffee. The company buys coffee beans from around the world and roasts, blends, and packages them for resale. WGCC currently has 15 different coffees that it offers to gourmet shops in one-pound bags. The major cost is raw materials; however, there is a substantial amount of manufacturing overhead in the predominantly automated roasting and packing process. The company uses relatively little direct labor. Some of the...
World Gourmet Coffee Company (WGCC) is a distributor and processor of different blends of coffee. The...
World Gourmet Coffee Company (WGCC) is a distributor and processor of different blends of coffee. The company buys coffee beans from around the world and roasts, blends, and packages them for resale. WGCC currently has 15 different coffees that it offers to gourmet shops in one-pound bags. The major cost is raw materials; however, there is a substantial amount of manufacturing overhead in the predomi-nantly automated roasting and packing process. The company uses relatively little direct labor. Some of the...
Falcon Specialty Coffee Company is a distributor and processor of different blends of coffee. The company...
Falcon Specialty Coffee Company is a distributor and processor of different blends of coffee. The company buys coffee beans from around the world and roasts, blends, and packages them for resale. Company currently has 12 different coffees that it offers to gourmet shops in one-pound bags. The major cost is raw materials; however, there is a substantial amount of manufacturing overhead in the predominantly automated roasting and packing process. The company uses relatively little direct labour. Some of the coffees...
Java Source, Inc. (JSI), is a processor and distributor of a variety of blends of coffee....
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...
DavidsTea is a distributor and processor of different tea blends. The company buys raw tea leaves...
DavidsTea is a distributor and processor of different tea blends. The company buys raw tea leaves from around the world and gently roasts, blends and packages them for resale. DavidsTea currently has over 30 different blends of gourmet teas that it sells to retail shops in one-kilogram bags. The major cost is raw materials; however, there is a substantial amount of manufacturing overhead in the predominantly automated roasting and packaging process. The company uses relatively little direct labour. Some of...
Swifty’s Nut House is a processor and distributor of a variety of different nuts. The company...
Swifty’s Nut House is a processor and distributor of a variety of different nuts. The company buys nuts from around the world and roasts, seasons, and packages them for resale. Swifty’s Nut House currently offers 15 different types of nuts in one-pound bags through catalogs and gourmet shops. The company’s major cost is that of the raw nuts; however, the predominantly automated roasting and packing processes consume a substantial amount of manufacturing overhead cost. The company uses relatively little direct...
A coffee manufacturer blends three component coffee beans into three final blends of coffee. The Table...
A coffee manufacturer blends three component coffee beans into three final blends of coffee. The Table below summarizes the very precise recipes for the final coffee blends, the cost and availability information for the three components, and the wholesale price per pound of the final blends. The percentages in the body of the table indicate the percentage of each component to be used in each blend. Table: Percentage of each component to be used in each blend _____________________________________________________________________________                                    Final Blend...
Coffee Blending Model: A coffee manufacturer blends three component coffee beans into three final blends of...
Coffee Blending Model: A coffee manufacturer blends three component coffee beans into three final blends of coffee. The Table below summarizes the very precise recipes for the final coffee blends, the cost and availability information for the three components, and the wholesale price per pound of the final blends. The percentages in the body of the table indicate the percentage of each component to be used in each blend. Table: Percentage of each component to be used in each blend...
Coffee Co. (the “Company”) is a global distributor of organic coffee beans and teas that is...
Coffee Co. (the “Company”) is a global distributor of organic coffee beans and teas that is registered with the SEC in the United States. The Company’s operations are primarily located in the United States, Canada, and South America. In March 20X8, Coffee Co., looking to refocus efforts to only produce coffee products, entered into an agreement (the “Agreement”) with Nature’s Beverage, a food distributor in the United States looking to expand its international footprint (the “Transaction”). Nature’s Beverage is registered...
Java Gourmet Coffee Java Gourmet Coffee reports the following data for April 2010 where 200,000 pounds...
Java Gourmet Coffee Java Gourmet Coffee reports the following data for April 2010 where 200,000 pounds of roasted gourmet coffee beans were actually produced (note: standard costs do not allow for any wastage), Actual: Direct Materials: Quantity of coffee beans: 210,000 pounds Cost per pound: $0.60 per pound Direct Labor: Direct labor rate: $19.00 per hour Labor hours used: 13,000 hours Variable Overhead: Actual costs: $21,600 Standard: Direct Materials: Quantity of coffee beans: 200,000 pounds Cost per pound: $0.50 per...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT