Create a graph of your table results

Assignment Help Operation Management

Reference no: EM131921765

For both problems assume that quantity produced = quantity demanded = quantity sold

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.

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.

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

What is total revenue at the break-even point?

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

Create a graph of your table results.

Reference no: EM131921765

Questions Cloud

Climate of that region potentially by damaging : A way I feel like this is related to geography, is that prior to the war, the Vietnam region had more forests, and the land was untouched by civilization.

Find upper limit for option price to make bank profitable : Find the upper limit for the option price c to make the bank profitable.

Determine and define the variance and standard deviation : How confident are you of this estimate? Calculate a 99% confidence interval for weekly profits, assuming that sigma is unknown. What does this tell you about

To which situation does this fit and what should the rop be : Furnco builds and sells secretarial chairs. Every chair model requires exactly 8 specialty fasteners that they get from a supplier.

Create a graph of your table results : 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)

Which form or forms of conflict were displayed : Which of the causes listed in the book were at the root of the conflict? Which form or forms of conflict were displayed?

What is return on equity : Suppose a firm’s EBT is $3 million and its tax rate is 35%. If the current price of the firm’s shares is $25, what is the return on equity?

Define and explain the significance of entities : What are the problems of managing data resources in a traditional file environment and how are they solved by a database management system?

What is the expected exposure on the lost profits claim : what is the expected exposure on the lost profits claim? To formally test Mr. Cooper's claim, test to see if there was a significant difference in mean weekly

User Account

All Pages