4a. Navigate to the "Activity-Based Cost Analysis" tab of the Excel workbook. In cells B2 through C5, 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\%) 4b. What percent of each of the four activities is allocated to the Standard model? The Advanced model? 4c. 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 B2 through C5.) Which of the following statements is true with respect to the chart? Save your work in Excel then enter your answers for questions 4a. through 4c. in the tabs below. What percent of each of the four activities is allocated to the Standard model? The Advanced model? 4a. Navigate to the "Activity-Based Cost Analysis" tab of the Excel workbook. In cells B2 through C5, 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\%) 4b. What percent of each of the four activities is allocated to the Standard model? The Advanced model? 4c. 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 B2 through C5.) Which of the following statements is true with respect to the chart? Save your work in Excel then enter your answers for questions 4a. through 4c. in the tabs below. What percent of each of the four activities is allocated to the Standard model? The Advanced model