Question: Based on Lab 2-4 Excel Sensitivity Analysis of Profitability under Changing Volume, Sales Price, and Fixed and Variable Cost Assumptions, using the Exhibit below, answer
Based on Lab 2-4 Excel Sensitivity Analysis of Profitability under Changing Volume, Sales Price, and Fixed and Variable Cost Assumptions, using the Exhibit below, answer the following question. A table for Sensitivity Analysis of Profitability under Changing Volume. The table has sales price ranging from $5 to $50 on the horizontal column headers and fixed costs ranging from 500 to 3000 on the vertical column headers. The table is color coded, it begins with a dark red color on the top left corner and turns to green towards the top right corner. The Exhibit above is an example of which analytics type? Multiple Choice Predictive Analytics Prescriptive Analytics Diagnostic Analytics Descriptive Analytics
Step by Step Solution
There are 3 Steps involved in it
Correct Answer Descriptive Analytics Explanation The Exhibit Sensitivity Analysis table prese... View full answer
Get step-by-step solutions from verified subject matter experts
