Purchase Solution

Spread Sheet Problem

Not what you're looking for?

Ask Custom Question

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?

Purchase this Solution

Solution Summary

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

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 ...

Purchase this Solution


Free BrainMass Quizzes
Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Introduction to Finance

This quiz test introductory finance topics.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.