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.
29 freelancers are bidding on average $157 for this job
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
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.
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.
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 [login to view URL] regards enrico