Calculations:

All the calculation are based on the $2019$ forecast target of units to be sold for Product A$,$ B$,$ and C$.$

$1)$ Calculate Projected Units to be Sold for each Product F$9$:F$11$ using the assumption inputted in cell D$35$ as $10\%$ increase over Actual Units Sold in $2018$

$2)$ Calculate the revenues and costs of goods sold $($COGS$)$ for each products based on Projected Units to be Sold and each product Unit Price and Unit Cost $.$

$3)$ TotalRevenue is the sum of the projected revenues for all three products for $2019.$

$4)$ TotalCOGS is the sum of the COGS for all three products for $2019.$

$5)$ GrossProfit $=$ TotalRevenue $$ TotalCOGS

$6)$ Calculate Salary using assumption inputted in cell D$36$ as $15\%$ of TotalRevenue

$7)$ Calculate Advertising using assumption inputted in cell D$37$ as $4\%$ of TotalRevenue

$8)$ Calculate Miscellaneous expenses using assumption inputted in cell D$38$ as $1\%$ of TotalRevenue

$9)$ OperatingExpense $=$ Salary $+$ Advertising $+$ Miscellaneous expenses

$10)$ EarningBeforeTax $=$ GrossProfit $-$ OperatingExpense

$11)$ Calculate the Taxes using assumption inputted in cell D$39$ as $30\%$ of the EarningBeforeTax.

$12)$ Net Profit $=$ EarningBeforeTax$-$ Taxes