BI: Compute New Standard mt Costs a: [H1 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 15 and the Case, use Excel to compute estimated total cost, prot margin, and margin percentage for each of le four jobs identied in Table 5, Panel A. b: l[ZiompLare your costs and protability per bar to Kay's estimates in Table 4. What is the potential nancial impact of using your method instead of Kay's? 32: Special Order a: Starting wi'l your standard bar costs from part El, compute the estimated cost per bar for the new special order from the wellness products supplier for 'll'im LES-oz. organic chocolate bars. The bars will have special stirin ingredients that Kay estimates will cost about $0 per pound, and these ingredients will become about 7' percent of the nished weight of the bar. The additional labor required for stirring in these ingredients is estimated to be Ij hours at $l'Ejtour for each batch of l bars. h: lICIompare your estimated cost per bar for the special order with the price, which is at a 2!} percent discount o the normal price for these types of bars of $1515. Will Kay make a prot on this order