# Spread Sheet Problem

Spread sheet problem.

The following are the expected revenue and costs from developing two different computer products over a five year period. At the end of five years, each system will have to be replaced. The salvage value for each is the same at $50,000. The fixed costs over the five year period for system 1 is $1,000,000 per year, and for system 2, it's $1,500,000 per year. The variable costs per unit for system 1 is $350 per unit, and for system 2, it's $150 per unit. The selling price for each unit of production is $500. What are the Break even points for both selling price for each unit of production is $500. What are the break even points for both systems? How many units would each have to produce and sell in a year to make a profit for each year of $500,000? Which system would you choose and why after you completed your analysis, the sales manager added one more bit of information. She indicated that it is easy to make a profit that average $500,00 using either system. However, she felt there might be an opportunity to sell an additional 1000 units in either system. How does this change your analysis?

© BrainMass Inc. brainmass.com April 3, 2020, 7:06 pm ad1c9bdddfhttps://brainmass.com/business/financial-ratios/spread-sheet-problem-245376

#### Solution Preview

Please see the attached file.

The following are the expected revenue and costs from developing two different computer products over a five year period.

At the end of five years, each system will have to be replaced. The salvage value for each is the same at $50,000.

The fixed ...

#### Solution Summary

This solution is comprised of a detailed explanation to answer how does this change your analysis.