Reference no: EM131801966
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 Tablefunction 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.
|
Threat level of rivalry
: Overall, the average level of performance in an industry is likely to be highest when the threat level of rivalry, and substitutes is low
|
|
Deciding on the marketing of the new product
: What, in your opinion, should the company management consider before deciding on the marketing of the new product?
|
|
Provide an example of each category of strategy formulation
: The Discussion Board (DB) is part of the core of online learning. Classroom discussion in an online environment requires the active participation.
|
|
Does zappos sound like a place you would want to work
: Hollie Delaney is a senior HR manager at Zappos.com, an intense, high energy, unique company. She is responsible for staff members in six HR functions.
|
|
One-way table to show the sensitivity of profit
: Create a one-way table to show the sensitivity of profit to the variable cost per unit. (You must use Excel Data Tablefunction for this)
|
|
Examine the critical role of commercial insurance companies
: Review the video titled Long-Term Care Insurance 101. Examine the critical role of commercial insurance companies in the financing of long-term services.
|
|
Calculate the segment return on assets for Segment A
: Segment B average assets of $151,200 and segment operating income of $16,190. Calculate the segment return on assets for Segment A
|
|
What is the expected value for the rezoned shopping center
: What is the expected value for the rezoned shopping center, if the rezoning cost is included? (Do not round your intermediate calculations.
|
|
Goal surrounding the problem-opportunity
: Identify the business problem or opportunity - pinpoint the goal surrounding the problem/opportunity (what do you want improve?).
|