Coffee Bean, Inc. (CBI), is a processor and distributor of a variety of blends of coffee....

Transcribed Image Text:

Coffee Bean, Inc. (CBI), 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. CBI 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 CBI's coffees are very popular and sell In large volumes, while a few of the newer blends sell In very low volumes. For the coming year, CBI's budget Includes estimated manufacturing overhead cost of $3,240,000. CBI assigns manufacturing overhead to products on the basis of direct labor-hours. The expected direct labor cost totals $540,000, which represents 54,000 hours of direct labor time. The expected costs for direct materials and direct labor for one-pound bags of two of the company's coffee products appear below. Mona Loa Direct materials $ 4.60 Malaysian $ 3.60 Direct labor (0.025 hours per bag) $ 0.25 $ 0.25 CBI'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 Purchasing Activity Measure Purchase orders Number of setups Number of batches Roasting hours Blending hours Packaging hours Material handling Quality control Roasting Blending Packaging Total manufacturing overhead cost Expected Activity for the Year 1,750 orders 1,840 setups Expected Cost for the Year $ 595,000 809,600 640 batches 96,500 roasting hours 33,900 blending hours 22,180 packaging hours 179,200 1,061,500 372,900 221,800 $3,240,000 Data regarding the expected production of Mona Loa and Malaysian coffee are presented below. There will be no raw materials Inventory for either of these coffees at the beginning of the year. Expected sales Batch size Setups Purchase order size Roasting time per 100 pounds Blending time per 100 pounds Packaging time per 100 pounds Mona Loa 144,000 pounds 12,000 pounds 4 per batch 24,000 pounds 1 roasting hours 0.5 blending hours 0.1 packaging hours Malaysian 3,000 pounds 500 pounds 4 per batch 600 pounds 1 roasting hours 0.5 blending hours 0.1 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 Mona Loa coffee and one pound of the Malaysian 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 Mona Loa coffee and to the Malaysian coffee for the year. b. Using the data developed in part (2a) above, compute the amount of manufacturing overhead cost per pound of the Mona Loa coffee and the Malaysian coffee. c. Determine the unit product cost of one pound of the Mona Loa coffee and one pound of the Malaysian coffee. Complete this question by entering your answers in the tabs below. Req 1A Req 1B Req 2A Req 2B Req 2C Using activity-based costing as the basis for assigning manufacturing overhead cost to products, determine the total amount of manufacturing overhead cost assigned to the Mona Loa coffee and to the Malaysian coffee for the year. (Do not round intermediate calculations. Round your answers to the nearest dollar amount.) Mona Loa Malaysian Total manufacturing overhead cost < Req 1B Req 2B > Coffee Bean, Inc. (CBI), 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. CBI 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 CBI's coffees are very popular and sell In large volumes, while a few of the newer blends sell In very low volumes. For the coming year, CBI's budget Includes estimated manufacturing overhead cost of $3,240,000. CBI assigns manufacturing overhead to products on the basis of direct labor-hours. The expected direct labor cost totals $540,000, which represents 54,000 hours of direct labor time. The expected costs for direct materials and direct labor for one-pound bags of two of the company's coffee products appear below. Mona Loa Direct materials $ 4.60 Malaysian $ 3.60 Direct labor (0.025 hours per bag) $ 0.25 $ 0.25 CBI'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 Purchasing Activity Measure Purchase orders Number of setups Number of batches Roasting hours Blending hours Packaging hours Material handling Quality control Roasting Blending Packaging Total manufacturing overhead cost Expected Activity for the Year 1,750 orders 1,840 setups Expected Cost for the Year $ 595,000 809,600 640 batches 96,500 roasting hours 33,900 blending hours 22,180 packaging hours 179,200 1,061,500 372,900 221,800 $3,240,000 Data regarding the expected production of Mona Loa and Malaysian coffee are presented below. There will be no raw materials Inventory for either of these coffees at the beginning of the year. Expected sales Batch size Setups Purchase order size Roasting time per 100 pounds Blending time per 100 pounds Packaging time per 100 pounds Mona Loa 144,000 pounds 12,000 pounds 4 per batch 24,000 pounds 1 roasting hours 0.5 blending hours 0.1 packaging hours Malaysian 3,000 pounds 500 pounds 4 per batch 600 pounds 1 roasting hours 0.5 blending hours 0.1 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 Mona Loa coffee and one pound of the Malaysian 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 Mona Loa coffee and to the Malaysian coffee for the year. b. Using the data developed in part (2a) above, compute the amount of manufacturing overhead cost per pound of the Mona Loa coffee and the Malaysian coffee. c. Determine the unit product cost of one pound of the Mona Loa coffee and one pound of the Malaysian coffee. Complete this question by entering your answers in the tabs below. Req 1A Req 1B Req 2A Req 2B Req 2C Using activity-based costing as the basis for assigning manufacturing overhead cost to products, determine the total amount of manufacturing overhead cost assigned to the Mona Loa coffee and to the Malaysian coffee for the year. (Do not round intermediate calculations. Round your answers to the nearest dollar amount.) Mona Loa Malaysian Total manufacturing overhead cost < Req 1B Req 2B >