Question: 1. Use Excel to do your work and provide a graph of the results as necessary. The Davis national drugstore chain prefers to operate one
1. Use Excel to do your work and provide a graph of the results as necessary. The Davis national drugstore chain prefers to operate one outlet in a town that has four major market segments. The number of potential customers in each segment and the location coordinates are shown below:
| Market Segment | Location Coordinates | Number of Customers | |
| x | y | ||
| 1 | 2 | 18 | 2000 |
| 2 | 15 | 17 | 600 |
| 3 | 2 | 2 | 1500 |
| 4 | 14 | 2 | 3400 |
Which would be the best location by the center-of-gravity method? Graph your location coordinates with the center of gravity.
Which would be the best location by the center-of-gravity method? Graph your location coordinates with the center of gravity.
2. A university currently has a recycling program for paper waste. The fixed cost of running this program is $15,000 per year. The variable cost for picking up and disposing of each ton of recyclable paper is $40. If the work is outsourced to a recycling company, the cost would be $65 per ton.
1. If the forecasted demand is 750 tons, what should the university do?
2. Find the break-even point by referring to equations in text.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
