Solving a problem in excel

J

Jamie

Do you know how to solve in excel?

I have 12 users;
the (cell phone) plans are as follows;

Minutes/Monthly Recurring Charge ("mrc"): 300/$50; 500/
$60; 800/$75; 1100/$95; 2000/$115; 2500/$130; 3500/$150;
4500/$175


I want the best mix of (12) plans to yield the maximum
minutes and minimum mrc; the users share the minutes

Sincerely,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mathematic problem solving using Excel 2
Lookup Table 1
HOW TO CALCULATE 1
Easy question for you, but hard for me. 3
ganaral stors 0
If time Go to Function 1
Public Folder Items 7
Public Folder Apointment 6

Top