Cary Company manufactures two models of industrial components$-$a Standard

model and an Advanced Model. It has provided the following information with

respect to these two products:

The company considers all of its manufacturing overhead costs $($$$1,346,250)$ to be

fixed and it uses plantwide manufacturing overhead cost allocation based on direct

labor$-$hours.

Click here for a brief tutorial on using Charts in Excel.

Use the Excel workbook titled

"ExcelAnalytics$\_$ComparingTraditionalandActivityBasedProductCosting$\_$Template" to complete

requirements $4$ a $.$ through $4$ c $.$

$4$a$.$ Navigate to the "Activity$-$Based Cost Analysis" tab of the Excel workbook. In cells B$2$ through C$5,$

create formulas that compute the percent of each activity's total cost that is allocated to each product.

$($Hint: If you complete this step correctly, the percentages shown in column D will total $100\%.)$

$4$b$.$ What percent of each of the four activities is allocated to the Standard model? The Advanced

model?

$4$c$.$ Within the "Activity$-$Based Cost Analysis" tab of the Excel workbook, use Charts to create a $100\%$

stacked bar chart that shows the percent of each activity's total cost allocated to each product. $($Hint:

This chart should refer to the percentages that you computed in cells B$2$ through C$5.)$