LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
David Adamson
 
Posts: n/a
Default

Developing Binary Variables



I think I have this but I can 't get the Sumproduct to work



This gives me the correct answer if I have already determined Yield effects
of salt

Here Yield is a combination of production*Income already



Profit = Sumproduct (Area, Yield) - Sumproduct(Area,Costs)



Sumproduct(Area, Costs) = cost to produce

Sumproduct (Area, Yield) = return from production



What I need to do is alter the return from production to include the salt
impact within the function



Yield = Basic Yield - Threshold Impact * (Salt-Threshold)*Y



Where

Salt = level of salt in water

Threshold = salt level required to affect yield

Threshold Impact = impact of salt

Y = Dummy Binary Variable, which I then add as a constraint



But I have no idea how to put this into a Sumproduct formula to use in
Solver.



Sumproduct(Area, ?????)



Any suggestions would be greatly appreciated





 
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 solver with function with multiple outputs [email protected] Excel Worksheet Functions 5 July 29th 05 01:58 PM
More time questions and IF function problem baz Excel Worksheet Functions 6 June 17th 05 08:56 PM
Match Function Problem - Won't Find Certain Numbers PE Excel Discussion (Misc queries) 2 May 9th 05 03:53 PM
Protecting a sheet that includes a solver function 20002238Rijk Excel Worksheet Functions 3 December 9th 04 09:53 AM
Protecting a sheet that includes a solver function 20002238Rijk Excel Worksheet Functions 0 November 11th 04 01:44 PM


All times are GMT +1. The time now is 02:36 PM.

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

About Us

"It's about Microsoft Excel"