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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!