PHP algorithm to calculate profitability

  • Durum: Closed
  • Ödül: $80
  • Alınan Girdiler: 6
  • Kazanan: idiez

Yarışma Özeti

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.

Tavsiye Edilen Beceriler

Bu yarışmadan başlıca girdiler

Daha Fazla Katılım Görüntüle

Genel Açıklama Panosu

  • sambestsolutions
    sambestsolutions
    • 2 yıl önce

    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

    • 2 yıl önce
  • sambestsolutions
    sambestsolutions
    • 2 yıl önce

    is this still open?

    • 2 yıl önce
    1. amlodkowski
      Yarışma Sahibi
      • 2 yıl önce

      it's still open

      • 2 yıl önce
  • rajaaziz
    rajaaziz
    • 2 yıl önce

    working don't close early wait for entry.i hope u like my work.Thank you

    • 2 yıl önce
    1. amlodkowski
      Yarışma Sahibi
      • 2 yıl önce

      it's still open

      • 2 yıl önce
  • tarik128
    tarik128
    • 2 yıl önce

    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?

    • 2 yıl önce
    1. amlodkowski
      Yarışma Sahibi
      • 2 yıl önce

      it's cost of the inventory FIFO- basically you sell the oldest inventory. each item acquired to the inventory has cost

      • 2 yıl önce
    2. tarik128
      tarik128
      • 2 yıl önce

      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?

      • 2 yıl önce
  • koleszarcsaba
    koleszarcsaba
    • 2 yıl önce

    I would some questions according to the exercise, please contact me!

    • 2 yıl önce
    1. amlodkowski
      Yarışma Sahibi
      • 2 yıl önce

      hey

      • 2 yıl önce
    2. amlodkowski
      Yarışma Sahibi
      • 2 yıl önce

      you can call me on skype or email me at adrian@infosystrade.com

      • 2 yıl önce
  • tarik128
    tarik128
    • 2 yıl önce

    Hi, just wondering about the nature of the project please, is it for academic or professional purpose?

    • 2 yıl önce
    1. amlodkowski
      Yarışma Sahibi
      • 2 yıl önce

      professional

      • 2 yıl önce
  • hiten247
    hiten247
    • 2 yıl önce

    Have sent spreadsheet with daily computation in skype..let me know if thats correct, will convert into php algorithm accordingly...

    • 2 yıl önce
    1. amlodkowski
      Yarışma Sahibi
      • 2 yıl önce

      I did not see anything on skype

      • 2 yıl önce
    2. amlodkowski
      Yarışma Sahibi
      • 2 yıl önce

      can you send on email ?

      • 2 yıl önce
  • amlodkowski
    Yarışma Sahibi
    • 2 yıl önce

    call me on skype or email me at adrian@infosystrade.com

    • 2 yıl önce
  • amlodkowski
    Yarışma Sahibi
    • 2 yıl önce

    hey

    • 2 yıl önce
  • koleszarcsaba
    koleszarcsaba
    • 2 yıl önce

    I have it almost completed, I just need a quick clarification.

    • 2 yıl önce

Daha fazla yorum göster

Yarışmalara nasıl başlanır

  • Projenizi ilan edin

    Yarışmanızı İlan Edin Hızlı ve kolay

  • Tonlarca girdi alın

    Tonlarca Girdi Alın Bütün dünyadan

  • En iyi girdiyi seçin

    En iyi girdiyi seçin Dosyaları indirin - Kolay!

Şimdi bir Yarışma İlan Et ya da Bugün Bize Katılın!