Your company is selling a product, Product A$,$ at a price of $$300$ per unit. You purchase the product from a manufacturer with whom you have exclusive right to sell the products only thru your company. You pay $$180$ for each unit.

At present, your company is selling $15,000$ units of this products in a year.

The expenditures include the following:

$\backslash$table$[[$Marketing expense,$$,210,000],[$Salaries expense,$$,105,000],[$Rent expense,$$,140,000],[$Miscellanous expense,$$,40,000]]$

How to calculate income statement?

The target market for this product is middle aged woman.

You are a marketing manager of the company. Your team feels that if current marketing budget is increased by an addition: $20\%$ then it will generate an increase $,10\%,$ of unit sales.

Q$.$ How to calculate income statement current and projected $?$ Using excel sheet