Question: Help with number 4 please! Required information [The following information applies to the questions displayed below.] This exhibit provides an example of a sensitivity analysis

Help with number 4 please!

Help with number 4 please! Required information
Required information [The following information applies to the questions displayed below.] This exhibit provides an example of a sensitivity analysis that might be performed by management accountants, evaluating the changing profitability based on two important inputs, the level of total fixed costs, and the sales price. To perform sensitivity analysis, the analysis varies the sales price from $35 to $53 (as shown in the columns) and the fixed costs from $500 to $3,000 (as shown in the rows), The colored columns are the total profits based on the changing input parameters. When combined with conditional formatting, the estimated profitability can be evaluated. 'Sales Price $ 35.00 $ 37.00 $ 39.00 $ 41.00 $ 45.00 45.00 $ 47.00 $ 49.00 $ 51.00 $ 53.00 00 4600.00 5200.00 Se00.00 6400.00 i gS0 Fixed Costs i 6150.00 2 ) 5900.00 5650.00 5400.00 $150.00 4300.00 Answer the following questions based on the information provided. 1. As sales price increases, what happens to the estimated profitability? 2..As total fixed costs increase, what happens to the estimated profitability? 3. If the sales price is $53 and total fixed costs are $3,000, what is the estimated profitability? 4. If the sales price is $45 and total fixed costs are $500, what is the estimated profitability? pin amare impactful on profitability, a $2 increase in sales price per unit or a $250 decrease in A'S2 incresse in ales price per unit stimated profitability decreases $ 6,900

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!