ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   solver fourmela in excel (https://www.excelbanter.com/excel-discussion-misc-queries/189570-solver-fourmela-excel.html)

taaaaMy

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.


Bob Phillips

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.




Bob I

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.




All times are GMT +1. The time now is 09:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com