PHP algorithm to calculate profitability
- Estado: Closed
- Premio: $80
- Propuestas recibidas: 6
- Ganador: idiez
Resumen del concurso
Create a simple algorithm in PHP to calculate profitability. details in the attachment. This project is a test project as I need few programmers to work on financial reporting very similar to this task.
Habilidades recomendadas
Comentarios del empleador
“the guy is good, but totally unreachable, it took like a week to talk briefly and then he did not have time anymore. do not hire if you don't want to have delays”
amlodkowski, United States.
Tablero de aclaración pública
-
sambestsolutions
- 7 años atrás
please check my entry with the image of the part of the code and the result ... Can calculate profit for any given range for any number of entries... Please check and message
- 7 años atrás
-
sambestsolutions
- 7 años atrás
is this still open?
- 7 años atrás
-
Organizador del concurso - 7 años atrás
it's still open
- 7 años atrás
-
rajaaziz
- 7 años atrás
working don't close early wait for entry.i hope u like my work.Thank you
- 7 años atrás
-
Organizador del concurso - 7 años atrás
it's still open
- 7 años atrás
-
tarik128
- 7 años atrás
I found it hard, and some questions came when tried to solve it, can you tell:
- What is the formula to calculate the weighted average of previous costs for a date?
- When we have more than a Bye for one date (eg 06-20-15) what is the formula to calculate the cost for this only date?
- And same if you have more than a Sell for one date, what is the formula to calculate the profit for this only date?- 7 años atrás
-
Organizador del concurso - 7 años atrás
it's cost of the inventory FIFO- basically you sell the oldest inventory. each item acquired to the inventory has cost
- 7 años atrás
-
tarik128
- 7 años atrás
I don't understand, but i will try answer my own questions and tell me if it's correct, i will take date examples from the Excel file.
For first question, if we want to calculate the weighted average of costs previous to 06-19-15, is it:
((1480-14,5*100)*10 + (1565-15,4*100)*8)/2
Or: sum((price-spot*weight)*qty)/n where n is number of previous buys?
For second question, if we want to calculate the cost for a date where we did more than a buy, in 06-20-15 we did 2 buys, i suppose the cost for this date is calculated by using the same formula as above, so we calculate the weighted average of the 2 costs for this only date to get the cost for that date?
For third question, if we want to calculate the profit for a date where we did more than a sale, in the Excel file there is always 1 Sale per date, but if we had a situation like so should we use a weighted average again to calculate the profit for a date with more than a sale?- 7 años atrás
-
koleszarcsaba
- 7 años atrás
I would some questions according to the exercise, please contact me!
- 7 años atrás
-
Organizador del concurso - 7 años atrás
hey
- 7 años atrás
-
Organizador del concurso - 7 años atrás
you can call me on skype or email me at adrian@infosystrade.com
- 7 años atrás
-
tarik128
- 7 años atrás
Hi, just wondering about the nature of the project please, is it for academic or professional purpose?
- 7 años atrás
-
Organizador del concurso - 7 años atrás
professional
- 7 años atrás
-
hiten247
- 7 años atrás
Have sent spreadsheet with daily computation in skype..let me know if thats correct, will convert into php algorithm accordingly...
- 7 años atrás
-
Organizador del concurso - 7 años atrás
I did not see anything on skype
- 7 años atrás
-
Organizador del concurso - 7 años atrás
can you send on email ?
- 7 años atrás
-
Organizador del concurso - 7 años atrás
call me on skype or email me at adrian@infosystrade.com
- 7 años atrás
-
Organizador del concurso - 7 años atrás
hey
- 7 años atrás
-
koleszarcsaba
- 7 años atrás
I have it almost completed, I just need a quick clarification.
- 7 años atrás
Cómo comenzar con los concursos
-
Publica tu concurso Fácil y rápido
-
Consigue toneladas de propuestas De todo el mundo
-
Elige la mejor propuesta ¡Descarga fácilmente los archivos!