Skip to content

pratiksha-naikk/Solving-Business-Problems-with-Excel

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 

Repository files navigation

Solving Business Problems with Excel

The Golf Club Problem: Modeling Demand and Price

The 19th Hole sells golf clubs at its golf outlet stores throughout the US. The company knows that the demand for its club varies considerably with price. In the last year, the demand at each price level was recorded in the table below.

Month Price Demand
1 450 45
2 300 103
3 440 49
4 360 86
5 290 125
6 450 52
7 340 87
8 370 68
9 500 45
10 490 44
11 430 58
12 390 68

The company wants to estimate the relationship between demand and price and then use this estimated relationship to answer the following questions:

  1. Assuming the unit cost of producing a set of clubs is $250, and the price must be a multiple of $10, what price should the company charge to maximize its profit?
  2. How does the optimal price depend on the unit cost of producing a set of clubs?
  3. Is the model an accurate representation of reality?

About

Solving Business Problems with Excel

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published