Solution-Negotiate with suppliers to bring his variable

Negotiate with suppliers to bring his variable costs down

Assignment Help Mathematics

Reference no: EM131103126

Start with a blank Excel worksheet.

Mountain Cycle makes custom mountain bikes. PJ, the owner of Mountain Cycle would like to know what he must do in the next year to break even.

The owner has estimated the following:

His annual fixed costs (rent, utilities, etc) are $65000

His variable cost per bike (raw materials, shipping, etc) is $1575

Question 1: If he sets the price of the mountain bike at $2500, how many bikes must he sell to break even? (rounded to the nearest integer number)

Question 2: If he estimates demand for next year to be 120 bikes, what price should he set per bike to break even?

Question 3: PJ thinks he can sell 130 bikes next year if he lowers the price of each bike to $2000. His fixed costs cannot be brought down, but he thinks he can negotiate with suppliers to bring his variable costs down. In order to break even, what does his new variable cost per bike have to be?

Use the Goal Seek function of Excel to arrive at your answers.

Reference no: EM131103126

Questions Cloud

Why the circuit is said to provide compressive characterstic : explain why the circuit is said to provide a "compressive" characteristic.

Demonstrated the four functions of management : Using the film, identify 1 or 2 situations/individuals (positive or negative) that demonstrated the four functions of management (planning, organizing, leading, and controlling).

Do corporations often sell convertibles on a rights basis : Why do corporations often sell convertibles on a rights basis?

Explain what the following code does : Explain what the following code does?

Negotiate with suppliers to bring his variable costs down : PJ thinks he can sell 130 bikes next year if he lowers the price of each bike to $2000. His fixed costs cannot be brought down, but he thinks he can negotiate with suppliers to bring his variable costs down. In order to break even, what does his n..

Analyze the contents of online shopping carts : One way the author of this textbook recommends to effectively manage credibility concerns with online information is to. Analyzing the contents of online "shopping carts" is an example of which class of Internet-based data sources?

Compute the character with maximum number of connections : Compute the character with maximum number of connections print out the result - Network theory has a host of applications. One fun application is to find the central character in a novel.

Evaluate the statement : Evaluate the following statement: "Issuing convertible securities represents a means by which a firm can sell common stock at a price above the existing market."

Sketch a picture of a residual plot : Sketch a picture of a residual plot that shows non-constant variance and linearity. Sketch a picture of a residual plot that shows constant variance and nonlinearity. Sketch a picture of a residual plot that shows non-constant variance and nonlineari..

User Account

All Pages

Negotiate with suppliers to bring his variable costs down

Reference no: EM131103126

Reference no: EM131103126

Questions Cloud

Reviews

Write a Review

Mathematics Questions & Answers

Questions on ferris wheel

Logistic map

Finding the probability of cards

Systems of ode

Derive the boolean expression

System of equations

Linear programming problem

Find the natural domain

Introduction to numerical methods

Chart of the topological manifold

Mathematics in computing

Complex problems

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT