Please show the formulas you use in Excel so I know how to work them. Also answer all of the questions listed underneath the chart. Thanks.

Edwards & Shaw is a merchandising company that is the sole distributor of a product that is increasing in popularity. The companys income statement for the three most recent months is listed below.

Edwards and Shaw

Income Statement

For the Three Months Ending September

	July	August	September
Sales in Units	4,500	5,000	6,000
Sales Revenue	$675,000	$750,000	$900,000
Cost of Goods Sold	275,000	300,000	350,000
Gross Margin	400,000	450,000	550,000
Operating Expenses:
Advertising Expense	11,000	11,000	11,000
Shipping Expense	27,000	30,000	36,000
Salaries and Commissions	127,500	135,000	150,000
Legal Expense	7,000	7,000	7,000
Depreciation Expense	10,000	10,000	10,000
Total Operating Expenses	182,500	193,000	214,000
Operating Income	$217,500	$257,000	$336,000

Identify each of the companys individual expenses as either a variable, fixed or mixed cost.

Using the high-low method, separate each of the individual mixed cost into the variable and fixed elements. State the cost equation for each individual mixed costs.

Edwards and Shaw expect to sell 6,500 units in October. Prepare an absorption income statement for October.

Prepare a Contribution Margin Income Statement based on October sales of 6,500 units. Do not combine expenses but show each expense separately in the appropriate category.

Calculate the contribution margin per unit and the variable cost ratio.

How many units would need to be sold to generate $350,000 in target income? (Round your answer to the nearest unit using the Excel Round Up function.)

Give one example of how Edwards and Shaw could increase projected operating income without increasing total sales revenue.

Edwards and Shaw are considering a multimedia advertising campaign that should increase sales by $50,000 per month. The ad campaign will cost an additional $1,500 per month and will be considered a fixed cost. How will the ad campaign affect product cost? How will the increase in fixed costs affect the break-even point? Explain.