A value stream has three activities and two products. The units produced and shipped per week are 50 of the deluxe model (Model A) and 250 of the basic model (Model B). The cycle time for Model A is four hours and that of Model B is three hours. The resource consumption patterns are shown as follows: Costs of Value- Model A Model B Stream Activities Cell manufacturing 2,600 min. 7,600 min. $306,000 Engineering 55 hrs. 255 hrs. 43,400 Testing 90 hrs. 190 hrs. 25,760 Total $ 375,160 Required: 1. Calculate the ABC product cost for Models A and B. If required, round your answers to the nearest cent. Product Cost Per Unit Model A $ Model B $ per unit per unit 2a. Calculate the value-stream average product cost. If required, round your answer to the nearest cent. $ per unit 2b. Assuming reasonable stability in the consumption patterns of the products and product mix, assess how well the products are grouped based on similarity. 3. Calculate the unit cost of each product using DBC. Round intermediate calculations and your answers to the nearest cent if rounding is required. Product Cost Per Unit Model A $ per unit Model B $ per unit How does this compare with the ABC unit costs? Which of the three costing methods would you recommend, and why? The DBC unit costs are both better than to the ABC unit costs. This suggests that, in the presence of heterogeneity, using DBC for costing is costing. 4. Identify the data analytic types (descriptive, diagnostic, predictive, and prescriptive) that apply for each of the following: Note: See Exhibits 2.5 and 2.6, for a review of data analytic types. a. The calculation of the unit costs by each of the three analytic costing methods. b. Assessing how well the products are grouped based on similarity. c. Comparison of DBC unit costs with ABC unit costs. d. Recommending and explaining which costing method should be used.