PHP algorithm to calculate profitability

  • Status: Closed
  • Prize: $80
  • Entries Received: 6
  • Winner: idiez

Contest Brief

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.

Recommended Skills

Top entries from this contest

View More Entries

Public Clarification Board

  • sambestsolutions
    sambestsolutions
    • 4 years ago

    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

    • 4 years ago
  • sambestsolutions
    sambestsolutions
    • 4 years ago

    is this still open?

    • 4 years ago
    1. amlodkowski
      Contest Holder
      • 4 years ago

      it's still open

      • 4 years ago
  • rajaaziz
    rajaaziz
    • 4 years ago

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

    • 4 years ago
    1. amlodkowski
      Contest Holder
      • 4 years ago

      it's still open

      • 4 years ago
  • tarik128
    tarik128
    • 4 years ago

    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?

    • 4 years ago
    1. amlodkowski
      Contest Holder
      • 4 years ago

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

      • 4 years ago
    2. tarik128
      tarik128
      • 4 years ago

      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?

      • 4 years ago
  • koleszarcsaba
    koleszarcsaba
    • 4 years ago

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

    • 4 years ago
    1. amlodkowski
      Contest Holder
      • 4 years ago

      hey

      • 4 years ago
    2. amlodkowski
      Contest Holder
      • 4 years ago

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

      • 4 years ago
  • tarik128
    tarik128
    • 4 years ago

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

    • 4 years ago
    1. amlodkowski
      Contest Holder
      • 4 years ago

      professional

      • 4 years ago
  • hiten247
    hiten247
    • 4 years ago

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

    • 4 years ago
    1. amlodkowski
      Contest Holder
      • 4 years ago

      I did not see anything on skype

      • 4 years ago
    2. amlodkowski
      Contest Holder
      • 4 years ago

      can you send on email ?

      • 4 years ago
  • amlodkowski
    Contest Holder
    • 4 years ago

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

    • 4 years ago
  • amlodkowski
    Contest Holder
    • 4 years ago

    hey

    • 4 years ago
  • koleszarcsaba
    koleszarcsaba
    • 4 years ago

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

    • 4 years ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!