Question: please do explain step to step how to do the calculations so i can learn from them. thank you Edwards and Shaw Income Statement For

 please do explain step to step how to do the calculations
so i can learn from them. thank you Edwards and Shaw Income
Statement For the Three Months Ending September July August September 4.500 5.000
6,000 Sales in Units Sales Revenue 5675,000 $750,000 $900,000 Cost of Goods
please do explain step to step how to do the calculations so i can learn from them. thank you

Edwards and Shaw Income Statement For the Three Months Ending September July August September 4.500 5.000 6,000 Sales in Units Sales Revenue 5675,000 $750,000 $900,000 Cost of Goods Sold 275,000 300,000 350,000 Gross Margin 400,000 450,000 $30,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 5217.500 $257,000 $336,000 1. Identify each of the company's individual expenses as either a variable, fixed or mixed cost. 2. 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. 3. Edwards and Shaw expect to sell 6,500 units in October. Prepare an absorption income statement for October. 4. 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. 5. Calculate the contribution margin per unit and the variable cost ratio. 6. 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.) 7. Give one example of how Edwards and Shaw could increase projected operating income without increasing total sales revenue. 8. 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. Income Statement Template Sheet3 Edwards & Shaw Income Statement or the Three Months Ending September 30th July August September Sales in Units 4,500 5,000 6,000 675,000 275,000 400,000 750,000 300,000 450,000 900,000 350,000 550,000 Sales Revenue Cost of Goods Sold Gross Margin Operating Expenses: Advertising expense Shipping expense Salaries and commissions Legal expense Depreciation expense Total Operating Expense Operating Income 11,000 27,000 127,500 7,000 10,000 182,5001 217,500 11,000 30,000 135,000 7,000 10,000 193,000 257,000 11,000 36,000 150,000 7,000 10,000 214,000 336,000 1) Identify each of the company's expenses as either variable, fixed, or mixed. For the FC list the total fixed costs per month for each month. For VC list the variable cost per unit for each month. For MC list the total average cost per unit for each mixed cost per month. July August September Fixed Costs Variable Costs Mixed Costs 2) Using the high-low method, separate each of the mixed expenses into variable and fixed elements. State the cost equation for each mixed cost. You may have more than one mixed cost. Variable Rate Fixed Cost Cost Formula 3. Edwards and Shaw expect to sell 6,500 units in October. Prepare an absorption income statement for October (assume we produce and sell the same number of units). Sales in Units | 6,500 Sales Revenue Operating Income 4) Prepare a Contribution Margin Income Statement based on the October sales of 6,500 units (assume we produce and sell the same number of units.) Do not combine expenses but show each expense separately in the appropriate category. Sales in Units 6,500 Sales Revenue Operating Income 5) Calculate the contribution margin per unit. Calculate the variable cost ratio. 6) Calculate how many units would need to be sold to generate $350,000 in target income. Round up to the nearest unit using the Excel Round Up function. Target Incom 350,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!