LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default period solver to schedule lifts

KISS : keep It Simple Sam. This is a revised request to help on a
period solver to schedule lifts

You have a tank that contains liquid. You make liquid each day at some
rate. The tank has to hold this daily make. Tank has a max and a min
volume of liquid to hold. You have to lift liquid out of tank so that
it stays within main & max. It costs $5 + $0.42/bbl to lift liquid out.
You know how much liquid you have in tank to start and how much liquid
make for the next 21 days. what is the optimal lift schedule. See the
solver & click show scenarios available here
http://availg.com/images/stories/tools/runout_1.xls

Problem: why is solver not finding the optimal schedule of lifts
regardless of initial guess?

For Example:
go to model tab:
click show scenarios
select base then close
go to Tools solver
click solve
solve does not find optimal schedule.

click show scenarios
select optimal then close
That is the optimal solution.

Your help is 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
Excel 2003 - Calculation production schedule using solver Blurz Excel Worksheet Functions 0 September 8th 07 01:00 PM
change the payment period of amortization schedule gcip Excel Worksheet Functions 2 March 14th 07 03:01 AM
HOW DO I CHANGE A SCHEDULE USING SOLVER WITHOUT CHANGING EACH DAY? TARA BROWN Excel Worksheet Functions 1 August 5th 06 01:14 AM
How to use solver to schedule part time and full time workforce? The Ooz Excel Discussion (Misc queries) 0 August 18th 05 06:53 AM
Need an excel amortization schedule formula with a grace period Grace period formula Excel Worksheet Functions 1 June 26th 05 06:32 PM


All times are GMT +1. The time now is 07:56 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"