Please use the spread sheet for A$.$C$.$M$.$E$.$ Pharmacies. This company has three years of sales and profits. Given what is gone on with the pandemic several companies have struggled as a result.

$1.$ RX sales drop $15\%$

$2.$ Cost of goods sold increase by $6\mathrm{.}2\%$

$3.$ Salaries are increased by $2\%$

$4.$ GM drop by $3\mathrm{.}2\%$

$5.$ Cast a year $4$ with a $10\%$ decrease in all categories from year $3.$

$6.$ Interest is now $$21000$ a year

$7.$ Provision for bad debts increases by $4\mathrm{.}5\%$

$8.$ Net Income drops by $5\%$ for each year

$9.$ Number of prescriptions per day increases by $2\%$

$10.$ Bad Debt Percentage rises to $4\%$

$11.$ Inflation Rates rises by $10\%$

$12.$ Unexpected costs not currently accounted for each year $$35,435$

Recast the statement given the criteria listed above and answer the following questions.

$1.$ Is the company still economically viable why or why not?

$2.$ Is there any information that you think is missing? What do you think you need? Why?

$3.$ Is there any conflicting data? What is it$?$

$4.$ What happens when companies$$ profitability changes because of outside factors?

$5.$ What corrective action would you take? Why?

$6.$ What are the risks, assumptions, and unanswered questions?