Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default solver fourmela in excel

Your Aunty Safa is the Manager of several Radio stations here in Abu Dhabi.
She is interested in finding out how to get across to the most amount of
listeners ( Gross Impressions ) while still remaining under her 200,000 AED
Total Cost limit. She has asked you to help her come up with a potential
solution to find the correct mix of Number of Ads.
Her Number of Ads for Radio Network 1 must be greater than or equal to 50.
Her Number of Ads for Radio Network 2 and 3 must be and less than or equal to
40. The Number of Ads has to be a whole number. The Percentage ( of Ads )
must be less than or equal to 60%. Gross Impressions must be greater than or
equal to 15,000,000. Total Cost must be less than or equal to 200,000.
Use Solver to find the Maximum Gross Impressions given the constraints.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default solver fourmela in excel

Do your own homework.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"taaaaMy" wrote in message
...
Your Aunty Safa is the Manager of several Radio stations here in Abu
Dhabi.
She is interested in finding out how to get across to the most amount of
listeners ( Gross Impressions ) while still remaining under her 200,000
AED
Total Cost limit. She has asked you to help her come up with a potential
solution to find the correct mix of Number of Ads.
Her Number of Ads for Radio Network 1 must be greater than or equal to 50.
Her Number of Ads for Radio Network 2 and 3 must be and less than or equal
to
40. The Number of Ads has to be a whole number. The Percentage ( of
Ads )
must be less than or equal to 60%. Gross Impressions must be greater than
or
equal to 15,000,000. Total Cost must be less than or equal to 200,000.
Use Solver to find the Maximum Gross Impressions given the constraints.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default solver fourmela in excel

I don't have an Aunty Safa. Please re-read the assignment BEFORE
attempting the exercise or test.

taaaaMy wrote:

Your Aunty Safa is the Manager of several Radio stations here in Abu Dhabi.
She is interested in finding out how to get across to the most amount of
listeners ( Gross Impressions ) while still remaining under her 200,000 AED
Total Cost limit. She has asked you to help her come up with a potential
solution to find the correct mix of Number of Ads.
Her Number of Ads for Radio Network 1 must be greater than or equal to 50.
Her Number of Ads for Radio Network 2 and 3 must be and less than or equal to
40. The Number of Ads has to be a whole number. The Percentage ( of Ads )
must be less than or equal to 60%. Gross Impressions must be greater than or
equal to 15,000,000. Total Cost must be less than or equal to 200,000.
Use Solver to find the Maximum Gross Impressions given the constraints.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
using Excel Solver Kenneth Excel Discussion (Misc queries) 4 March 25th 08 01:02 AM
Interesting Solver problem (Solver encounters an error) MrShorty Excel Discussion (Misc queries) 3 December 22nd 05 10:52 PM
Excel Solver Zeelotes Excel Worksheet Functions 1 October 18th 05 12:03 PM
how to use solver in excel vadivukarasi raju New Users to Excel 1 March 22nd 05 02:04 PM
How can I get the Solver Add-in in Excel 97? Mindy Excel Discussion (Misc queries) 1 February 3rd 05 02:35 PM


All times are GMT +1. The time now is 12:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"