Break-even points

Needs assistance in completing spreadsheet for break-even points.

? Calculate the break-even points (at various price levels) and the operating leverage for the software and keyboard divisions. State and explain the assumptions you made when performing these calculations.
? Describe how the break-even quantities and operating leverages are affected by the relationships between fixed and variable costs.
We’ve reviewed the marketing report and are convinced that the company would be well served by expanding the Electric 88 keyboard division instead of the software division.
Using our current sales and cost data, and assuming that we keep our costs at their current levels, we have calculated the break-even quantities for our division using the marketing division’s list of possible prices.
Our current fixed costs are $470,000 per year. Our current variable costs are about $285 per keyboard?and I think we can hold that steady. So if, as the marketing department says is possible, keyboard prices fall to $290 each, then our variable margin will be $5 per keyboard, and we will need to sell 94,000 keyboards per year to break even. We’re not likely to be able to do that. But suppose keyboard prices remain at their current $305. Then our variable margin is $20, and we only need to sell 23,500 keyboards to break even?we’re doing better than that now. If prices rise, then our break-even quantities fall. I’ve prepared the following table, which reports our break-even quantities for various prices
Table. Break-Even Quantities
Keyboard Price Variable Margin Break-Even Quantity
$290 $5 94,000
$305 $20 23,500
$320 $35 13,429
$335 $50 9,400
$350 $65 7,231
Of course, if the price falls below our variable cost of $285 per keyboard, then we won’t break even?no matter how many keyboards we sell. But because our fixed costs are the lowest of any of our divisions, our break-even quantities are low for any reasonable prices.
Factoring in our fixed costs, our current average cost is about $295.44. That means that at our current prices, our degree of operating leverage is 2.09?this is the ratio of our contribution margin of $20 to our unit profit of about $9.56. So if our quantity sold increases by 5 percent, then our division’s profits increase by more than 10 percent. Our division is primed to expand.
We anticipate that the price of DigiMuse’s software might decline over the next two years. We think the likelihood of this is rather small, and if it occurs the decline will be minimal, to about $120 per unit. (There is a very small chance of a larger drop, to $114 or $108 per unit).
Of course, the price could increase by $6 or up to $132 per unit. We think a price increase is just as likely as a price decrease.
During the market life of the new sound card, the marketing department will incur additional expenses. We will need to hire three additional salespersons at salaries of $35,000/year each, plus a $1.50 commission per sound card with quantities in the thousands. Administrative, travel, and other expenses for the new salespersons will be $25,000/year each. Direct-marketing expenses will be $125,000/year.
We expect that the market price of the new sound card will be stable at $105. However, because of uncertainty over macroeconomic and market conditions, we have some concern about the quantity DigiMuse will be able to sell.
The best-case scenario involves very high demand for the new sound card. With the additional advertising and new salespeople, we expect to be able to sell about 250,000 of the new sound cards per year. There is about a 15 percent chance that demand will be lower, and we will sell around 120,000 sound cards per year, and there is an even slighter chance, around 5 percent, that demand will be very low, and sales will only be around 40,000 units per year.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with AssignmentHelpWeb
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Anthropology
Excellent services will definitely come back
Customer 452441, September 23rd, 2022
Anthropology
excellent loved the services
Customer 452443, September 23rd, 2022
English 101
Very good job. I actually got an A
Customer 452443, September 25th, 2022
Nursing
The paper was EXCELLENT. Thank you
Customer 452449, September 23rd, 2022
Architecture, Building and Planning
The assignment was well written and the paper was delivered on time. I really enjoyed your services.
Customer 452441, September 23rd, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat