Thread: Lowest Cost for Multiple Pricing Plans, Quantity, and Total Minutes

Ok, I'm embarrased that I even have to ask this question, but here it goes.

I would like to calculate the lowest overall price for Cellular minute pricing plans.

Plan A: 400 Minutes @ $49.99
Plan B: 1000 Minutes @ $74.99
Plan C: 2000 Minutes @ $99.99

I want a formula that will solve the below problem, and numerous others with the same format:

I want the best combination of plans to get the lowest cost per minute for a given number of phone lines and minutes.

EX: If I need 52 (X) lines of service and need a total pool of 31200 (y) minutes, what formula will give me the lowest average price per minute, or the lowest overall cost using the best combination of the three available pricing plans?


Thanks!

The number of minutes in the pool is a minimum, can go over slightly if needed to make the right combination of plans.

Originally Posted by djroy

The number of minutes in the pool is a minimum, can go over slightly if needed to make the right combination of plans.

32000 (16 @99.99) is the obvious answer with the given info.
52 lines will average 600 each : so what?