You are marketing manager for a product line selling medical equipment to hospitals. You are struggling to generate the profit dollars that your division is expecting from your product line. Your sales team believe that if you allowed them to lower prices by $10\%$ they would be able to sell more and by selling more, grow profits. Your current annual revenue is $$1,000,000$ and annual gross profit is $$300,000.$ You decide that you need to do some analysis prior to having a discussion with sales to first understand how much growth would be required to even produce the same gross profit with lower prices.

a$.$ Fill in all of the gray highlighted boxes below:

$\backslash$table$[[,\backslash$table$[[$P&L prior to price$],[$decrease$]],\backslash$table$[[$P&L if price reduction with$],[$no volume growth$]],\backslash$table$[[$P&L after price$],[$reduction if growth$],[$occurs to maintain$],[$original gross profit $$]],\backslash$table$[[$Volume$],[$Growth$],[$required to$],[$maintain$],[$Gross Profit $$]]],[$Revenue$],[$COGS$],[$Gross Margin $\%],[$Gross Profit $