Department Manager Report

Awarded Posted Oct 14, 2015 Paid on delivery
Awarded Paid on delivery

To develop a report based on a group of products that are grouped by their location.

A monthly sales report (which can be specified) for that group of products and a YTD report. It would also indicate stock on hand figures as well.

For example in our Mitre 10 store we have hundreds of bays. These are call Bin Locations or Bins for short.

They have all been named Bin Number: 024A, 024B, 024C etc..

They each store stock i.e one bay has screws in Bin number 004A.

Another Bin is 005J which is Hooks.

Each department manager looks after a specified number of bays.

The report could be customised for each department manager so that it can be saved and re-run each month.

For example: each month a report would run and give me the sales information on Bin number: 024A, 026H, 004G.

It would display sales, gross profit etc.. And compare to last month /year

The goal is to measure the profitability of each bay over time and determine where the weak areas of the store are.

The report will show Sales, Gross Profit and stock turns.

Comparisons can be made to the same month last year, and the same year last year.

There is an excel document attached to show a sample of the report.

The software we use is called Sympac. It runs a Pervasive database Version 11.

To achieve the results above three tables are used that I know and the the required fields are also known.

Database Programming

Project ID: #8638001

About the project

8 proposals Remote project Active Oct 8, 2015

8 freelancers are bidding on average $299 for this job

fabest

Dear, we are Team of French + US. 11 years experience on Access/Excel/VBA automations. I don't see your xls file, could you send me ? I will focus on user friendly interface. As you can see I have very good rate, y More

$294 AUD in 3 days
(1 Review)
3.9
jayamsoft

Hi, We are experienced programmer with more than 4 years of development experience here. We have handled production applications with various technologies like .NET, PHP (Codeigniter / Wordpress / Core Php), Classic More

$294 AUD in 5 days
(1 Review)
3.5
nikmah344

Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am having 6+ years of experience in Web Development. I have worked on below technologie More

$258 AUD in 3 days
(3 Reviews)
3.0
sheak

Hello! I am extremely interested in this project and would love to work on this project, please reply back to discuss further. Looking forward to hear from you soon. Thanks!

$270 AUD in 7 days
(1 Review)
2.7
bkabubi

I am a proficient writer with 24 hours customer support and willing to work within your budget. I hold a Masters in Business administration (finance & economics), Bachelor in Business Information Technology, CFA & ACC More

$300 AUD in 3 days
(0 Reviews)
0.0
coolwriter30

A proposal has not yet been provided

$285 AUD in 3 days
(0 Reviews)
0.0
JonnaNueros121

Hi, I'm experienced in Financial Analysis, Accounting and Economics, Project Management and Academic writing. Ready to complete your projects: 1) Writing Business Reports - Business Plan, Investment Memorandum, Financi More

$294 AUD in 6 days
(0 Reviews)
0.0
zhkhan89

Greetings from Italy, Our great performance has earned us Elite level ‘Preferred freelancer badge’. By hiring us, your work is done professionally, on demand and upto your satisfaction prior to your deadline. We c More

$400 AUD in 7 days
(0 Reviews)
0.0