What is total revenue at the break-even point

Assignment Help Operation Management

Reference no: EM131423128

The owner/manager of Randy Nets, a small sporting goods store, is considering a plan to offer a service to string tennis rackets.

Martina Shoz, the weekend manager has analyzed the costs and estimated materials and labor cost for each racket would be $19.00 and fixed cost that must be covered will be $2000.

Martina suggests that they charge $37.50 per racket for the service.

a. Set up the profit model and use it to answer the following questions. Note: only one model needs to be created and used for all of the questions below.

b. How many tennis racket stringing jobs would the store need to break even? (use Excel Goal-Seek function)

c. What is total revenue at the break-even point?

d. Create a one-way table to show the sensitivity of profit to the variable cost per unit. (You must use Excel Data Table function for this)

Use variable cost values of $14.00, $16.00, $18.00 and $20.00. Set Quantity to 150

e. Create a graph of your table results.

Reference no: EM131423128

Questions Cloud

Explain categories of computer crimes : Explain the four (4) major categories of computer crimes, and provide at least one (1) example for each. Explain the most common forms of digital crime

Find the mean and the standard deviation : Find the mean and the standard deviation. If we toss a fair coin 100 times, the number of heads is a random variable that is binomial.

Explain thoroughly-segmentation-targeting and positioning : Explain thoroughly each of the following: Segmentation, Targeting, and Positioning. How do you combine segmentation, targeting and positioning to come up with a full marketing strategy? Give an example.

Give the probability model for the 14 possible outcomes : Each of the triangles is also equally likely, but the triangle probability differs from the square probability. The probability of getting a square is 0.72. Give the probability model for the 14 possible outcomes.

What is total revenue at the break-even point : The owner/manager of Randy Nets, a small sporting goods store, is considering a plan to offer a service to string tennis rackets. Martina Shoz, the weekend manager has analyzed the costs and estimated materials and labor cost for each racket would be..

Type influence job performance : How might your personality type influence your job performance? Please explain in detail the different types of personalities and how they might influence job performance.

What is probability that taster 2 rates wine higher than 3 : What is the probability that Taster 1 rates a wine higher than 3? What is the probability that Taster 2 rates a wine higher than 3?

Layers of diversity help organizations : How does awareness about the layers of diversity help organizations effectively manage diversity?

Analyze the political and social effects of racial profiling : Analyze the political and social effects of racial profiling within law enforcement. Conduct research and find at least two scholarly resources on this topic

User Account

All Pages