Applylng Excel $-$ Goal Seek and PMT: Exerclse $($Part $2$ of $2)$

Keeping all other data the same as in the original example, change the targeted operating income goal for the quarter, units sold for

January and February, and price per unit and variable expense per unit for all three months to match the information below:

Targeted operating income for the quarter $=$$$10\mathrm{.}800$

Required:

$2$a$.$ Using Goal Seek in Excel, determine the total number of units Jim needs to sell in March in order to meet his targeted operating

income for the quarter. $($Round your answer up to the nearest unit.$)$

$2$b$.$ If the company increases the price per unit by $$200$ for March only. what is the minimum number of units that Jim needs to sell in

order to meet his t$$rgeted operating income for the quarter? $($Round your onswer up to the nearest unit.$)$

Total number of units to sell in March after price increase

$2$c$.$ Assume that Jim met his target net operating income of $$10,800$ and will now receive a $$1,080$ bonus. Jim plans to use his bonus

as a down payment on a car that costs $$23,400.$ Using the PMT function. determine the monthly payment for his new car loan. $($Round

your answer to $2$ decimal ploces.$)$