Category Current Input Values Lean Input Values Innovation Input Values

Sales $$16,750,000\mathrm{.}00$ $$16,750,000\mathrm{.}00$ $$21,440,000\mathrm{.}00$

Cost of Goods Sold $$14,237,500\mathrm{.}00$ $$12,244,250\mathrm{.}00$ $$16,080,000\mathrm{.}00$

Variable Expenses $$1,005,000\mathrm{.}00$ $$954,750\mathrm{.}00$ $$1,072,000\mathrm{.}00$

Fixed Expenses $$1,005,000\mathrm{.}00$ $$904,500\mathrm{.}00$ $$1,005,000\mathrm{.}00$

Inventory $$1,675,000\mathrm{.}00$ $$1,239,500\mathrm{.}00$ $$2,144,000\mathrm{.}00$

Accounts Receivable $$816,000\mathrm{.}00$ $$734,400\mathrm{.}00$ $$816,000\mathrm{.}00$

Other Current Assets $$663,000\mathrm{.}00$ $$663,000\mathrm{.}00$ $$795,600\mathrm{.}00$

Fixed Assets $$693,000\mathrm{.}00$ $$693,000\mathrm{.}00$ $$693,000\mathrm{.}00$

Required:

Note: Use cells A$2$ to D$10$ from the given information to complete this question.

Calculate the ROA for current values, lean values, and innovation values.

Note: Round your answers to $2$ decimal places.

SPM Outputs Current Input Values Lean Input Values Innovation Input Values

Gross Profit

Total Expenses

Net Profit

Net Profit Margin $0\mathrm{.}030\mathrm{.}150\mathrm{.}15$

Current Assets

Total Assets

Asset turnover

ROA $(\%)$