Question
I need to do everything in excel, so please explain well the formulas. The following information pertains to Torasic Companys budgeted income statement for the
I need to do everything in excel, so please explain well the formulas.
The following information pertains to Torasic Companys budgeted income statement for the month of June:
Sales (1,200 units at $250) | $300,000 |
Variable cost | 150,000 |
Contribution margin | 150,000 |
Fixed cost | 200,000 |
Net loss | $(50,000) |
Required
a)Determine the companys breakeven point in both units and dollars.
b)The sales manager believes that a $22,500 increase in the monthly advertising expenses will result in a considerable increase in sales. How much of an increase in sales must result from increased advertising in order to break even on the additional monthly expenditure?
c)The sales manager believes that an advertising expenditure increase of $22,500 coupled with a 10% reduction in the selling price will double the sales quantity. Determine the net income (or loss) if the company adopts these proposed changes.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started