I need help with this accounting problem

Chocolate Bars, Inc. (CBI), manufactures creamy deluxe chocolate candy bars. The firm has developed three distinct products: Almond Dream, Krispy Krackle, and Creamy Crunch. CBI is profitable, but management is quite concerned about the profitability of each product and the product costing methods currently employed. In particular, management questions whether the overhead allocation base of direct labor-hours accurately reflects the costs incurred during the production process of each product. In reviewing cost reports with the marketing manager, Steve Hoffman, who is the cost accountant, notices that Creamy Crunch appears exceptionally profitable and that Almond Dream appears to be produced at a loss. This surprises both him and the manager, and after much discussion, they are convinced that the cost accounting system is at fault and that Almond Dream is performing very well at the current market price Steve decides to hire Jean Sharpe, a management consultant, to study the firm's cost system over the next month and present her findings and recommendations to senior management. Her objective is to identify and demonstrate how the cost accounting system might be distorting the firm's product costs Jean begins her study by gathering information and documenting the existing cost accounting system. It is rather simplistic, using a single overhead allocation base-direct labor-hours-to calculate and apply overhead rates to all products. The rate is calculated by summing variable and fixed overhead costs and then dividing the result by the number of direct labor-hours. The product cost is determined by multiplying the number of direct labor-hours required to manufacture the product by the overhead rate and adding this amount to the direct labor and direct material costs. CBI engages in two distinct production processes for each product. Process 1 is labor intensive, using a high proportion direct materials and labor. Process 2 uses special packing equipment that wraps each individual candy bar and then packs it into a box of 24 bars. The boxes are then packaged into cases, each of which has six boxes. Special packing equipment is used on all three products and has a monthly capacity of 3,000 cases, each containing 144 candy bars (= 6 boxes 24 bars). To illustrate the source of the distortions to senior management, Jean collects the cost data for the three products, Almond Dream, Krispy Krackle, and Creamy Crunch. Almond Dream Krispy Xrackle Creamy Crunch 7.8 1,000 $ 8.80 $ 46.80 7,800 3.8 1,000 $ 2.80 $ 22.80 3,800 1.0 1,000 $ 9.30 $ 6.00 1,000 Product costs Labor-hours per case Total cases produced Material cost per case Direct labor cost per case Labor-hours per product Total overhead - $73,500 Total labor-hours = 12,600 Direct labor costs per hour - $6.00 Allocation rate per labor-hour - (a). Costs of products Material cost per case Direct labor cost per case Allocated overhead per case to be computed) Product cost $ 8.80 46.80 (b) $ 2.80 22.80 $ 9.30 $ 6.00 (d) (f) CBI recently adopted a general policy to discontinue all products whose gross profit margin percentages [(Gross margin = Selling price) * 100) were less than 10 percent By comparing the selling prices to the firm's costs and then calculating the gross margin percentages, Jean could determine which products, under the current cost system, should be dropped. The current selling prices of Almond Dream, Krispy Krackle, and Creamy Crunch are $93.00, $65.00, and $30.00 per case, respectively. Overhead will remain $73,500 per month under all alternatives. Required: a-1. Complete the table under the current cost system. a-2. Determine which product(s), if any, should be dropped. C-1. Assume that CBI drops the product(s) identified in requirement (a) above. Calculate the gross profit margin percentage for the remaining products. Assume that CBI can sell all products that it manufactures and that it will use the excess capacity from dropping a product to produce more of the most profitable product. c-2. If CBI maintains its current rule about dropping products, which additional products, if any, should CBI drop under the existing cost system? d-1. Assume that CBI drops the products identified in requirements (a) and (c) above. Recalculate the gross profit margin percentage for the remaining product(s) and ascertain whether any additional product(s) should be dropped. d-2. Which additional products, if any, should CBI drop under the existing cost system? Complete this question by entering your answers in the tabs below. Req Al Req AZ Reg CI Reg C2 Reg Di Req D2 Complete the table under the current cost system. (Round your intermediate calculations and final answers to 2 decimal places. Negative values should be indicated with a minus sign.) Almond Dream Krispy Krackle Creamy Crunch 7.80 1,000 8.80 1.00 1,000 9.30 $ 3.80 1,000 $ 2.80 $ 22.80 3,800 $ $ Product costs Labor-hours per case Total cases produced Material cost per case Direct labor cost per case Labor-hours per product Total overhead Total labor-hours Direct labor costs per hour Allocation rate per labor-hour $ 46.80 7,800 6.00 1.000 $ 73,500 12,600 6.00 $ $ $ 8.80 $ $ 9.30 2.80 22.80 46.80 6.00 Costs of products Material cost per case Direct labor cost per case Allocated overhead per case Product cost Selling price Gross profit margin percentage $ 55.60 $ 25.60 $ 15.30 % % % Reg A1 Req A2 > Required: a-1. Complete the table under the current cost system. a-2. Determine which product(s), if any, should be dropped. c-1. Assume that CBI drops the product(s) identified in requirement (a) above. Calculate the gross profit margin percentage for the remaining products. Assume that CBI can sell all products that it manufactures and that it will use the excess capacity from dropping a product to produce more of the most profitable product. c-2. If CBI maintains its current rule about dropping products, which additional products, if any, should CBI drop under the existing cost system? d-1. Assume that CBI drops the products identified in requirements (a) and (c) above. Recalculate the gross profit margin percentage for the remaining product(s) and ascertain whether any additional product(s) should be dropped. d-2. Which additional products, if any, should CBI drop under the existing cost system? Complete this question by entering your answers in the tabs below. Req Al Req AZ Req ci Reg C2 Req D1 Req DZ Determine which product(s), if any, should be dropped. Almond Dream Krispy Krackle Creamy Crunch Required: a-1. Complete the table under the current cost system. a-2. Determine which product(s), if any, should be dropped. c-1. Assume that CBI drops the product(s) identified in requirement (a) above. Calculate the gross profit margin percentage for the remaining products. Assume that CBI can sell all products that it manufactures and that it will use the excess capacity from dropping a product to produce more of the most profitable product. c-2. If CBI maintains its current rule about dropping products, which additional products, if any, should CBI drop under the existing cost system? d-1. Assume that CBI drops the products identified in requirements (a) and (c) above. Recalculate the gross profit margin percentage for the remaining product(s) and ascertain whether any additional product(s) should be dropped. d-2. Which additional products, if any, should CBI drop under the existing cost system? Complete this question by entering your answers in the tabs below. Req Al Reg AZ Reg CI Reg C2 Reg Di Req DZ Assume that CBI drops the product(s) identified in requirement (a) above. Calculate the gross profit margin percentage for the remaining products. Assume that CBI can sell all products that it manufactures and that it will use the excess capacity from dropping a product to produce more of the most profitable product. (Round your intermediate calculations and final answers to 2 decimal places.) Show less Direct labor cost per hour Direct labor-hours per case Total cases produced Labor-hours per product Allocation rate per labor-hour: Allocated production costs: Material cost per case Direct labor cost per case Allocated overhead per case Product cost Gross profit margins Selling price Product cost-direct labor allocation base $ 0.00 $ 0.00 $ 0.00 $ 0 % 0.00 0 % 0 % Profit margin percentage Required: a-1. Complete the table under the current cost system. a-2. Determine which products), if any, should be dropped. c-1. Assume that CBI drops the product(s) identified in requirement (a) above. Calculate the gross profit margin percentage for the remaining products. Assume that CBI can sell all products that it manufactures and that it will use the excess capacity from dropping a product to produce more of the most profitable product. c-2. If CBI maintains its current rule about dropping products, which additional products, if any, should CBI drop under the existing cost system? d-1. Assume that CBI drops the products identified in requirements (a) and (c) above. Recalculate the gross profit margin percentage for the remaining product(s) and ascertain whether any additional product(s) should be dropped. d-2. Which additional products, if any, should CBI drop under the existing cost system? Complete this question by entering your answers in the tabs below. Req Al Reg A2 Reqci Reg C2 Reg D1 Reg D2 Assume that CBI drops the products identified in requirements (a) and (c) above. Recalculate the gross profit margin percentage for the remaining product(s) and ascertain whether any additional product(s) should be dropped. (Round your intermediate calculations and final answers to 2 decimal places.) Direct labor cost per hour Direct labor hours per case Total cases produced Labor hours per product Allocation rate per labor-hour: Allocated Production Costs Material cost per case Direct labor cost per case Allocated overhead per case Product cost Gross profit margins: Selling price Product cost-direct labor allocation base $ 0.00 $ 0.00 Profit margin percentage 0 % 73,500 per month under all alternatives. Required: a-1. Complete the table under the current cost system. a-2. Determine which product(s), if any, should be dropped. C-1. Assume that CBI drops the product(s) identified in requirement (a) above. Calculate the gross profit margin percentage for the remaining products. Assume that CBI can sell all products that it manufactures and that it will use the excess capacity from dropping a product to produce more of the most profitable product. c-2. If CBI maintains its current rule about dropping products, which additional products, if any, should CBI drop under the existing cost system? d-1. Assume that CBI drops the products identified in requirements (a) and (c) above. Recalculate the gross profit margin percentage for the remaining product(s) and ascertain whether any additional product(s) should be dropped. d-2. Which additional products, if any, should CBI drop under the existing cost system? Complete this question by entering your answers in the tabs below. Req Al Reg AZ Reg CI Reg C2 Reg Di Reg D2 Which additional products, if any, should CBI drop under the existing cost system? Almond Dream Krispy Krackle Creamy Crunch