Question

In: Computer Science

The owner of Pitt Fitness is considering whether to consolidate his clubs and offer classes in

The owner of Pitt Fitness is considering whether to consolidate his clubs and offer classes in only one location to ensure profitability. To explore his question, what query or queries would you create to answer this business strategy question? 

Solutions

Expert Solution

First, create a query that counts the number of classes offered at each location. Next, create a query that counts the number of reservations at each location. Finally, to refine the answer, you could create a query that counts the number of reservations for each specific class at the low-enrollment location and compare that to the other locations.


1. Count classes by location.

2. Count reservations by location.

3. Compare class reservations at low-enrollment location to others for refinement.

Related Solutions

Brad Pitt, owner of a small car repair and engine service business, operates his business as...
Brad Pitt, owner of a small car repair and engine service business, operates his business as a C corporation with a December 31 year-end. He has three employees, including himself. The following expenses, along with $565,000 of gross income, are reported in the corporation’s financial statements. Employee 1 salary                                                                  $ 28,000 Employee 2 salary                                                                     28,000 Brad Pitt’s salary                                                                       45,000 Building rent                                                                              24,000 New Machinery purchased for the year                                 100,000 Depreciation of machinery for the year                                 10,000 Insurance...
The owner of a development site is considering an offer from a parking lot operator to...
The owner of a development site is considering an offer from a parking lot operator to rent the parcel for the next five years, while the development is being planned and approved. The operator has offered to pay $65,000 today or an annuity of $20,000 at the end of each of the next 5 years. Which payment method should the site owner accept if her required rate of return is 15 percent?
Geoff is the proud owner of a restaurant. He is interested in determining whether his Wagyu...
Geoff is the proud owner of a restaurant. He is interested in determining whether his Wagyu beef or Hiramasa kingfish sashimi should be marketed as the Geoff Special. Geoff has selected a random sample of 20 people to taste his Wagyu beef and give it a score out of 100. He also selected a different random sample of 20 people to taste his Hiramasa kingfish sashimi and give it a score out of 100. The sample mean score given to...
A plant owner is considering replacing each of the metal halide lamps in his facility with...
A plant owner is considering replacing each of the metal halide lamps in his facility with a 6-lamp T8 fixture. The plant has a total of 31 fixtures. Determine the annual energy savings for the proposed lighting upgrade (in kWh). Information about each light type is given below: Metal Halides Each lamp is rated at 400 W with a ballast factor of 1.17. Lamp intensity is 22,000 lumens. Lamp lifetime is 20,000 hours. The cost of a replacement lamp is...
Externality: A restaurant owner is considering a ban on smoking in his restaurant. The table below...
Externality: A restaurant owner is considering a ban on smoking in his restaurant. The table below lists the daily-expected benefits received by the owner from smokers and non-smokers. There are three choices, ban, allow or set up a separate smoking area. Assume all parties can negotiate at zero cost. Ban Smoking $200 (smokers) $220 (non-smokers) Allow Smoking $280 (smokers) $150 (non-smokers) Separate Smoking Rooms $210 (smokers) $200 (non-smokers) Suppose the restaurant owner has the property rights to allow, ban or...
The owner of a number of gas stations is considering installing coffee machines in his gas...
The owner of a number of gas stations is considering installing coffee machines in his gas stations. It will cost $250,000 to install the coffee​ machines, and they are expected to boost cash flows by $116,071 per year for their​ five-year working life. What must the cost of capital be if this investment has a profitability index of​ 1?
The owner of a number of gas stations is considering installing coffee machines in his gas...
The owner of a number of gas stations is considering installing coffee machines in his gas stations. It will cost $290,000 to install the coffee machines, and they are expected to boost cash flows by $134,643 per year for their five-year working life. What must the cost of capital be if this investment has a profitability index of 1 1. 10.37% 2. 12.96% 3. 2.59% 4. 5.81%
The owner of Fairfax Inn, Will Loy, is considering franchising a national brand to increase his...
The owner of Fairfax Inn, Will Loy, is considering franchising a national brand to increase his property’s visibility to a broader market of travelers. After visiting the Franchise Office of the brand company, Mr. Loy learned that, to join franchise, he needs to pay the following fee: One time initial fee at the signing of the franchise agreement: $150 per room ($12,500 Minimum) Annual royalty fee: 3% of gross sales Annual Advertising fee: 2.8% of gross sales Reservation fee: $2...
Your company is considering whether it should tender for two contracts (MS1 and MS2) on offer...
Your company is considering whether it should tender for two contracts (MS1 and MS2) on offer from a government department for the supply of certain components. The company has three options: • Tender for MS1 only; or • Tender for MS2 only; or • Tender for both MS1 and MS2. If tenders are to be submitted the company will incur additional costs. These costs will have to be entirely recouped from the contract price. The risk, of course, is that...
A farm owner is considering replacing his obsolete tractor with one of two new state-of-the-tractors. This...
A farm owner is considering replacing his obsolete tractor with one of two new state-of-the-tractors. This new machine would cost $125,000 and would have a ten-year useful life. Unfortunately, the new machine would have no salvage value but would result in annual cost savings of $23,000 per year. The current old tractor can be sold now for $10,000. The farm owner’s Cost of Capital is 10%. The farm owner uses the straight line method of depreciation (this depreciation information is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT