Closed

Analyze some Data

I have been trying to figure out a way to create a work sheet to input daily sales report for 80 sales rep working in 4 regions. Each region has 20 reps and one supervisor. Each supervisor has to monitor the sales of their agents. The records they have to input are quantity of SIM cards each agent collected, quantity of recharge vouchers each agent collected, quantity of sim cards and recharge vouchers sold and quantity of each products left. These records needs to be updated daily. The unit cost of each product is NGN100. Supervisor should be able to see a total amount of sales made each day, weekly and monthly for each product and grand total for both products, he should also see quantity sold and quantity remaining for each product, he should be able to filter by date, or agents name. Now since there are four regions, there is also an overall manager that needs to see what's happening in the four regions. He should be able to filter by region, date range, down to individual sales rep if necessary. I need someone to develop this in either excel or Microsoft Access putting into consideration ease of 20 agents for each region inputting the data daily which each of the region's the Supervisor has to view and the overall Manager being able to view for all regions.

Skills: Data Entry, Data Processing, Microsoft Access

See more: sales agents for products, product sales reps, data entry supervisor, data analyze administrator, historical sales data analyze, data entry work monthly, inputting survey data excel, stock data analyze, transmission per unit cost data, account manager handle day day accounting activities, inputting multiple data vba macro, clementine data analyze

About the Employer:
( 9 reviews ) lagos, Nigeria

Project ID: #7785094

29 freelancers are bidding on average $157 for this job

shikhamehta

Hey, There are multiple ways to go about it and if you could provide more information about the setup you have, I would be able to suggest some options. Do the sales reps and the managers have a common directory tha More

$333 USD in 15 days
(115 Reviews)
6.0
dpune

Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 235 projects. Please look at the feedback left by my employers to know more about my work. Wai More

$150 USD in 10 days
(100 Reviews)
5.9
zExcel

A proposal has not yet been provided

$200 USD in 2 days
(70 Reviews)
6.1
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft More

$140 USD in 8 days
(40 Reviews)
5.3
dipakmoliya

Hi! there, My name is Dipak Moliya. I’ve read your project description and can see that you’d like to build a Multi-user Microsoft Access Database With different rights for different users. There will be usertyp More

$155 USD in 7 days
(36 Reviews)
5.0
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards

$194 USD in 3 days
(28 Reviews)
4.9
DanielVizcaya91

Hello there, I will like to help you out with this project. I have plenty of experience developing this kind of tools on Excel. Also, I will include a really nice user interface. If you want, we could make a test run s More

$147 USD in 3 days
(18 Reviews)
5.0
aarifakhtar

Hi: Please note that I have 100% completion rate and 5-star feedback on all projects (>50 total completed projects). More than 90% of my completed projects are related to Excel and VBA Script. Please check my profile t More

$188 USD in 5 days
(30 Reviews)
5.1
srinichal

I am willing to discuss further about the project details and deliver the same to your specifications

$189 USD in 3 days
(13 Reviews)
4.5
farr4u

HI, Access and Excel VBA expert here, I offer you access application with very user friendly forms having functionalities like auto filling easy data selection through dropdowns, these forms will be for performing data More

$69 USD in 5 days
(29 Reviews)
4.6
ahujasahil1987

Hi I read that you're looking for some kind of custom made template in Excel or Access which can help you manage all your 4 regions and 20 reps each with a supervisor on top. This is doable and I can achieve it i More

$97 USD in 5 days
(15 Reviews)
4.0
rajafaizan

Hello sir... I provide very fast work & guarantee you 100% satisfaction and my expertise lies in quality service and delivery on Time kindly if you wants high quality work then as soon as possible discuss me. Please gi More

$83 USD in 1 day
(16 Reviews)
4.0
AlexandrK1

Предложение еще не подано

$250 USD in 15 days
(5 Reviews)
3.9
infoshree80

Dear Buyer, I am Access/VBA expert since 12 years. I checked your project description, and I can help you to develop your Access DB. Recently I have done little bit similar project about assigning sim commission More

$100 USD in 8 days
(16 Reviews)
4.7
vnb400sl

Respected Sir i can develop an application in .net framework (c# or vb.net) for you and another for your sales persons to input data and upload it to your server and generate reports and use queries at your end. More

$250 USD in 10 days
(25 Reviews)
4.2
Ayan

Hello, I can make an application in MS Access to resolve your problem. It can be done in a day. Please let me know when you want to discuss more about this. Thank you.

$45 USD in 1 day
(24 Reviews)
3.7
fastterp

please check my previous work on projects using Access. I will address data collection & ease of use for you approval prior to dealing with the multi-level reporting.

$250 USD in 30 days
(4 Reviews)
3.6
tomislav1975

Hi, I can do this very nice in Excel. I have very simple and efficient idea, ideal for such task. Contact me to discuss details. Thanks

$120 USD in 5 days
(6 Reviews)
3.1
ENRICOJ

hi.i would like to assist you. ms access is perhaps a better option as your task involve both data management and analysis. please do not hesitate to contact me for further [url removed, login to view] regards enrico

$50 USD in 3 days
(3 Reviews)
3.2
rashmisingh2990

I am database expert having experience of 2 years.I will definitely complete your work and deliver it on time.

$111 USD in 3 days
(4 Reviews)
2.7