please help

Chocolate Bars, Inc. (CBI), manufactures creamy deluxe chocolate candy bars. The firm has developed three distinct products: Almond Dream, Krispy Krackle, and Creamy Crunch Celis 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 identity 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 of 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 Krackle Creamy Crunch 9. 1, eee $ 10.00 $ 54.00 9, cee $ $ 5.0 1, eee 4.00 30.00 5, see 1.0 1, eee $ 10.50 $ 6.ee 1,000 Product costs Labor-hours per caso Total cases produced Material cost per case Direct labor cost per case Labor-hours per product Total overhead $79,500 Total labor-hours = 15,eee Direct labor costs per hour $6.ee 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 $ $10.00 54.00 (6) 4.ee 3e.ee $10.50 6.ee d) ( f CBI recently adopted a general policy to discontinue all products whose gross profit margin percentages [(Gross margin-Seling 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 $105.00, $69.00, and $30.00 per case, respectively Overhead will remain $79,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 cel 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? Almond Dream Krispy Krackle Creamy Crunch 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 $ $ 9.00 1,000 10.00 54.00 9,000 5.00 1,000 $ 4.00 $ 30.00 5,000 $ $ 1.00 1,000 10.50 6.00 1,000 $ 79,500 15,000 $ 6.00 $ 10.00 S $ 10.50 Costs of products Material cost per case Direct labor cost per case Allocated overhead per case Product cost Selling price Gross profit margin percentage 4.00 30.00 54.00 6.00 % % % Complete this question by entering your answers in the tabs below. Req A1 Req AZ Reg C1 Reg C2 Reg D1 Reg D2 Determine which product(s), if any, should be dropped. Almond Dream Krispy Krackie Creamy Crunch Show le 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 Profit margin percentage % 96 Complete this question by entering your answers in the tabs below. Req AI Red A2 Reqci Reg C2 Reg D1 Reg D2 If CBI maintains its current rule about dropping products, which additional products, if any, should CBI drop under the existing cost system? Almond Dream Krispy Krackde Creamy Crunch 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 $ Profit margin percentage 0.00 0 % Complete this question by entering your answers in the tabs below. Reg A1 Reg A2 ReqC1 Req C2 Req D1 Reg D2 Which additional products, if any, should CBI drop under the existing cost system? Almond Dream Krispy Krackle Creamy Crunch