Closed

Market share input form

This project received 10 bids from talented freelancers with an average bid price of $151 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
10
Project Description

Hi

My business partners sell notebooks, tablets and phones. I want to have a clear overview of what they are selling - what brands, what market shares, what average prices. I need this info each at the beggining of each month for one month and the partners are prepared to provide this data.

I need a database with few tables:

PARTNER table with following data:

- Country

- Account type (distributor, retail, etail...)

- Company name

- Contact person

- Contact phone

- Contact email

- Username and login password

INHOUSE SHARES table with:

- Year

- Month

- Product group (Notebook, Tablet, Phone...) // when filling in data the user can only pick a group previously defined by Admin

- Brand (HP, IBM, Samsung, Lenovo...) // when filling in data the user can only pick a brand previously defined by Admin

- QTY // meaning the total QTY sold in the listed month

- Revenue // total value of above QTY

- ASP // Average selling price calculated from above two data

I need each partner to be able to loggin and fill the data for their company, but cannot have access to the data from other companies.

I as the admin need to be able to view and export all data (for all companies together) into excel table.

Only admin can alter data in the PARTNER table

If possible the app should be php/mysql based and easy to transfer to my hosting server.

Skills Required

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online