Transcript PowerPoint Presentation - Projects Data Management System

RMAX
RMax – Report Maximizer
RMAX Features
Report Designer to design your own reports in Excel / HTML
Define user specific interfaces to extract data from your ERP
Define your own Information Pivot Views
Define your own Graphs using Pivot Charts
Email Scheduler for Reports as desired
Powerful Query Generator
Access Rights – Role-wise and Responsibility-wise
RMAX Architecture
ERP or
Internal
System
Database
Export of
Selected Data
Raw Data
RMax
Processor
RMax
Database
With
Multiple
Processes
RMax
Setup
(Designer)
RMax for
Users
RMAX Report Setup
Add Your Own MIS Reports
Output in Excel or HTML Pages
Apply Access Rights
RMAX Sample Reports – Expense Monitoring
Demo Co. Pvt. Ltd.
Vallabh Vidya Nagar
Gujarat
EXPENSE MONITORING as on Date [ 21-10-2008 ]
Amount
Group_Name
Employee Cost- Wages
Establishment Expenses
Financial Charges
Manufacturing Expenses
Personnel
Cost- Salary
Rates & Taxes
Repair &
Maintenance
Month_Year
Acnt_Name
Labour Contractor
Salary - Administrative Dept.
Salary - Alluminium Foundry
Salary - Prodn. Rubber
Salary - Steel Foundry
Salary Manufacturing - Bonus/Comm.
Salary Manufacturing - Leave Pay
Salary Manufacturing - LTA
Salary Manufacturing - Medical Exp
Advertisement / Sales Promotion
Agency charges for Export
Carriage Outward
Communication Expenses
Donations
Insurance Charges
Labour / Staff Welfare Expenses
Legal & Professional Charges
Lunch & Tiffine Expenses
Office expenses
Periodical / Subscribtion / Fees
Personnel Training/Seminar/Conferences.
Postage & Courier Expenses
Printing & Stationery
Profit/(Loss) on sale of Asset
Rent / Hire Charges
Rounding Off -Amount
Sales Meeting Expenses
Steel Foundary Project Expenses
Bank Charges/Commission
Bank Interest - CC/OD
Exchange Rate Fluctuation
Other Interest
Electricity
Excise Expenses
Factory Rent
Machining / Proccessing Charges
Octroi Charges
Power / Fuel
Testing & analysis chgs
Water
Comp.Contribution-PF & PF Admi.Chg.
Company Contri.- EDLI & EDLI Admini.Chg
Labour Welfare Fund Expenses
Maharashtra Security Guard Board Levy
Salary Establishment
Salary Establishment - Bonus/Comm.
Salary Establishment - LTA
Salary Establishment - Medical Reim/Exp
License Fees & Govt. Taxes
Profession Tax
Repair & Maintenence - Motor Car
Repairs & Maintenance - Other
Repairs & Maintenence - Building
2007-04
2007-05
2007-06
2007-07
2007-08
2007-09
2007-10
2007-11
634252
342104
132800
450768
5125749.76
803712
461116
282696
596136
4252764.32
771368
450140
248680
521812
5121438.56
761440
403156
248680
545212
5373151.2
761440
390511.6
248680
562528
5222903.8
703440
404028
238280
526556
5692400.2
703440
406528
244808
510364
196800
7499876.28
771588
398836
239880
533624
98000
12000
70000
60000
40000
24000
110268
48000
-3456000
56000
64336
72000
8000
204876
121504.52
8000
522684
144495.52
26000
472141.92
179364.72
64000
2203980
153549.32
247452
204073.88
30400
2757016.52
35608.92
16000
1322192
169812.96
11000
1148500
257652.6
72616
39880
627704
640
350202
108492
189074
149760
27932
82396
61800
397549
-86066.28
1820
515380
928688
282225
121401.84
12236
293208
1916856
93218
196400
32764
-14004
1384052
353912
1036400
78072
317152
51200
576280
30400
2796
294318.52
36458
29593.4
71116
18787.52
156600
6176
187000
2021996
109360.36
116000
8000
1172131.64
17422.12
535420
2490862.48
60020
4158840
3900
107060
255656
5892
402800
19508
68330
1396680
149480
220176.72
5400
189698
126000
11200
41713.68
124364
13520
29393.24
53200
48320.6
150708
51867.52
219236
195000
195000
195000
205800
197000
197000
2289572
35358.84
1887036
647765.52
16992.36
949848
21411.84
897424
409610.16
16557.6
1576824
40640.52
909472
343105.32
16121.84
1091208
51005.76
888416
518354.4
15685.08
421484
91929
797044
1643750.36
15247.32
1011508
234935.56
996468
-2633958.2
25580.56
93360
113187.8
897504
-38786.2
14356.76
535420
2727004.44
39672
3950640
400
535420
4203889.72
52396
5162400
535420
4625858.6
77788
3555480
26161.72
67560
252140
6404
535420
7680795.64
94692
1739000
65271.16
90300
253316
6284
535420
4873322.96
49604
5213720
13240
185080
211852
6128
535420
7482198.72
43992
3889520
45359.4
404004
247956
6168
8948
402800
8948
402800
402800
9596
402800
600
141978.4
-58332
5660
154098
41280
15036
182888
43680
8948
402800
402800
535420
5643922
74164
5202360
22000
208376
234976
21096
6048
17896
402800
74768
412843.4
127431.2
3540
39840
88380
10000
14708
19580
16360
252860
220200
5660
138080
258924
5992
-1512
4320
24644
66460
19856
28420
RMAX Sample Reports – Product Mix
Demo Co. Pvt. Ltd.
Vallabh Vidya Nagar
Gujarat
Product Mix
Year_Id
Company_Code
Item_Code
Item_Name
(All)
(All)
(All)
(All)
Quarter
Month_YearData
(20072008) Quarter 1
2007-05
2007-06
(20072008) Quarter 2
2007-07
Category_Name
Sales_Qty AmountCount of Invoice_No
Sales_Qty AmountCount of Invoice_No
Sales_Qty
Alluminium Inserts
Aluminium Casting
615.5
2349743
17
952
6679964
59
1181.6
Cutters
1
Dies and Moulds
1
Element
650
2514997
21
1097
7052074
65
5299
EZ Elements
Fastners
General Tools
Hub
Mixed Rubber Compound
Reinforcement Ring
15
SERVICE
Steel plates
Grand Total
1265.5
4864741
38
2049
13732038
124
6497.6
2007-08
Amount
Count of Invoice_No
Sales_Qty
4651454
2800
38400
4667766
49
1
1
61
56029.05
1
9416449
113
2007-09
Amount
Count of Invoice_No
Sales_Qty
Amount
1426.4
4752465
32
1000
1117
1207
6945304
67
929
4775595
4
18672
1
20
1656
4
3070
41218
10415887
2637.4
11716440
100
67896
5529521
RMAX Sample Reports – Stock Valuation
Demo Co. Pvt. Ltd.
Vallabh Vidya Nagar
Stock Valuation
Principal_Name
Month_Year
Category_Name
Item_Code
Item_Name
(All)
2008-07
(All)
(All)
(All)
Amount
Position
Category_Code
(A) Opening Stock
(B) Receipt
(C) Issue
(D) Closing Stock
(H) Overhead
110
872425.02
19128.4
19128.4
872425.02
872425.02
120
79151.16
17064.7
17064.7
79151.16
79151.16
130
268367.06
268367.06
268367.06
150
90213.6
210
291739.7
90213.6
90213.6
291739.7
291739.7
220
230
80000
80000
80000
0
0
15122.46
15122.46
310
43292
43292
43292
320
50066.6
50066.6
50066.6
330
4964
350
91751.94
7537.79
7537.79
4964
4964
91751.94
131734.04
360
7081.1
48652.5
48652.5
7081.1
7081.1
365
182288.98
27917.8
27917.8
182288.98
182288.98
410
89288.9
8662.21
8662.21
420
73598.74
89288.9
89288.9
73598.74
73598.74
430
0
0
440
152233.28
152233.28
162243.28
450
0
0
24500
460
0
0
465
113669
113669
113669
470
29026.4
29026.4
29026.4
480
160624.22
160624.22
160624.22
510
4800
4800
4800
530
257824.82
257824.82
257824.82
540
10800
10800
21650
550
28596.68
28596.68
28596.68
560
0
0
RMAX Sample Reports – Stock Trend
Product Group Description (All)
Product Group (All)
Sum of Amount
6000000
5000000
4000000
Position
(B) Receipt
3000000
(C) Issue
(D) Closing Stock
2000000
1000000
0
2007-04
2007-05
2007-06
Month - Year
2007-07
RMAX – Email Scheduler
Define the frequency in which you want to
View the report
Rmax will email the required Information
Output without any manual intervention
On the set frequency
You get information On-Time
Thus helps you in Timely Decisions
RMAX Report Designer
Pivot Chart Setup
RMAX Report Designer
Plain Report Designer
RMAX - Summary
You can use Rmax as a front-end Data-Warehousing Tool for
Practically any Requirement to generate Information Outputs
Rmax can be connected to your ERP, or your Software Solution
or to Multiple databases, either existing or you can create
New Data, if required
Rmax can help you to club data of various Financial years
in One Report to effectively monitor the Trend of Business
Rmax can be deployed on your Server and can be accessible to your
Organisation over Internet
Rmax is simple to deploy, easy to maintain,
yet can be scalable for any requirement
RMAX - Support from Werardt
Werardt has Domain Experts who can understand your
Requirement, and team up with your IT Team to give you the
Desired results
Werardt will Offer in-depth training to your IT Staff on designing
Database required by Rmax, or alternatively can take responsibility
Of designing and implementing the same
Contact Information
Werardt Systemss Pvt Ltd
Pune, India
Phone : 91-20-25285256, 25285257
Website : http://www.werardt.com
email: [email protected]