Re: converting 41 program to Palm OS Message #9 Posted by Jim on 8 Dec 2003, 11:36 a.m., in response to message #8 by Jonathan Purvis (New Zealand)
This program goes one step beyond EOQ. Let's say you've established your order quantity at a given price, but then your vendor or a competitive vendor approaches you with a deal of a lower price but you have to order in larger quantities. It then becomes a decision, depending on the parameters, do you want to invest in more inventory in order to enjoy the lower price. This decision process primarily involves items THAT WILL DEFINITELY be used, not items like clothes that may have to be discounted. Usually the decision boils down to: Does the return produced by the lower price justify the INCEMENTAL investment. There are nine variables to the problem, with six given variables and three to solve for, depending on how you, the purchasing agent, wishes to approach it. I.e., do you want to solve for new price, P2, new quantity, Q2, or return on incremental investment, ROII?
This program has been done in Lotus and Quattro Pro macros, DOS, and both the 41 and 19BII. But DOS is now kaput and the other two modes are too limited for general use. I want a purchasing agent AND the salesman to have this program available as a handy PDA application. However, I am not a programmer. I did fine with the 41, and some programs were fairly complicated, and Lotus macros presented no problem but I flamed out with Virtual Basic, which it's my understanding, is used for Excel macros. But if you're using Excel, you don't even need a macro but it would be convenient. So, now C looks to be the best approach but I cannot invest the time to become proficient in C for a limited amount of production. I will farm it out at a local college. I have a couple other decision-making programs that need to be programmed as well. I appreciate your help.
|