Hi This Question is for an accounting case that is about Dream Chocolate company. I chose a Job order cost method and would like help with the following questions below.

Part B: Calculate Product Costs B1: Compute New Standard Product Costs

a: D.C. does not currently track actual cost information, but Kay has estimated some additional production data provided in Table 5. Using the approach(es) you recommended in Part A and the estimated data provided in Tables 1-5 and the Case, use Excel to compute estimated total cost, profit margin, and margin percentage for each of the four jobs identified in Table 5, Panel A.

b: Compare your costs and profitability per bar to Kay's estimates in Table 4. What is the potential financial impact of using your method instead of Kay's?

B2: Special Order a: Starting with your standard bar costs from part B1, compute the estimated cost per bar for the new special order from the wellness products supplier for 200,000 1.25-oz. organic chocolate bars. The bars will have special stir-in ingredients that Kay estimates will cost about $10 per pound, and these ingredients will become about 7 percent of the finished weight of the bar. The additional labor required for stirring in these ingredients is estimated to be 10.5 hours at $12.50/hour for each batch of 10,000 bars.

b: Compare your estimated cost per bar for the special order with the price, which is at a 20 percent discount off the normal price for these types of bars of $1.75. Will Kay make a profit on this order?

TABLE 5 Additional Estimated Data for Part B

Panel A: Job-Specific Information

Job 1 1.25/Org. Job 2 1.25/Non-Org. Job 3 3.0/Non-Org. Job 4 3.25/Org. Other Jobs Total Month No. of Bars 10,000 5,000 200 300 10,500 26,000 Cost of Chocolate $3,135 $945 $84 $274 $3,162 $7,600 Cost of Foil 274 133 11 18 374 810 Cost of Label 347 163 16 21 283 830 $3,756 $1,241 $111 $313 $3,819 $9,240