Custom Applications Developed b Low Code Platform at AmpleLogic

1
Excel Spreadsheets Solutions
2
About Us
3
Excel Automations across different verticals
Budgeting and expenses
Sales Targeting
SCM (Back Order Management)
Sales Budget MIS
Opex Module

• Increased Budget Accuracy Visibility
• Increased Buy Ins with efficient dashboard view
• Work Online/Offline
• Integrated Active Directory
• Consolidated Output screen.
• Access rights checks and balances
• Auto Log registration in database for all changes

• Product wise, Quantity wise and Quality wise easy
  adjustments
• Customizable month or yearly submissions
• Consolidation of all the segregated data
• Full power to the user with proper checks and
  balances
• Customizable filters across verticals
• Auto Variance in Commit Vs Supply and demand Vs
  Commit

• Auto generated Targets
• Automated Dynamic Workflow
• Automated Reports
• Yearly quarterly and monthly breakup
• Auto Calculated Rows
• Automatic Email Triggers
• Centralised Database
• Inbuilt Dashboard

• Cost Centre Wise Data collection. Links with sub
  sheets like power, fuel and travel.
• BOM data management.
• Query Engine for custom reports.
• Role Based access.
• Cost Allocation based on 6 primary keys.

• Budget Forecasting
• PL estimation and comparison
• Product Wise Budget estimation
• Top 10 molecules reports budgets v/s actuals
• Link Workforce and Capex plans into overall
  financial budget.
• Sales Projections
• Working Capital estimations

4
Excel AutomationOur Solution Success Factor
5
Sales TARGETING MIS

• 100 reduction in Errors
• Efficiency Improved by 90
• ROI in One cycle
• Moved to 2 cycles instead of 1 cycle
• Planning to move quarterly cycles

• Auto Targeting based on
• Head Quarters(3500)
• Stockiest(5000)
• HQ Stockist Mapping(1,07,000)

• 8,00,000 Records in total
• In HQ v/s Stockeist v/s SKU combination
• 500 Floating Excel sheets. 500 previous Excel
  Sheets

• Division Heads (21)
• Sales Managers(105)
• Regional Sales Managers(164)

6
Application View of Management Information Flow
with various financial Process
7
Graphical Representation Charts / Reports
8
Summary or Consolidation Report
9
Finance and Budgeting
10
Details of Budgeted, Actuals, Variance , YTD
11
Summary Bulk Approvals
12
Current Status
Status displays where the Excel is lying
Pending
Completed
13
(No Transcript)
14
(No Transcript)
15
Excel Automation Our Solution Success Factor
Powered by extensive RD our AmpleLogic Platform
solution are both web Based and cloud-based that
delivers incredibly intuitive Solution for Sales
, Finance , Budgeting , Planning, Forecasting
with active Reporting and Visual Dashboards.
Designed for business users and accessible from
anywhere, our Platform made software solution
helps to visualize performance, plan effectively,
and monitor results.
Inbuilt Workflow
Centralized Access
Excel Interface
Inbuilt Workflow with automated email
triggers. Trace the excel with the workflow
status report
Secure Data Access with Active Directory
People start using our tools in just 2 hrs of
deployment.
Audit Ready
Status Quo of Excel
Role Based Access
Audit trails on data changes and no additional
software required.
Role Based access Definitions to rows, columns
and cells
Continue to use all the excel features like
Sorting Search etc.
16
Unique Features of Finance and Budgeting
Unique Features Value they bring in
Consolidation Bringing all business users on a single platform
Time stamps Status and time stamps to understand different users pending statuses and submissions
Structured workflow Single workflow across all departments
Change tracking The data is consistent across hierarchy unlike before where a small change might be un detected until the final budgeting
Budgets v/s actuals Comparison reports and charts
Democratization of data The data is available across hierarchy to see and plan, but not edit or manipulate it.
17
AmpleLogic Platform Technology Stack
18

• Our Capabilities

19
Pharma Automations
20
(No Transcript)
21
Keep in touch with us
Contact us for other Demos or a pilot
AmpleLogic
http//www.amplelogic.com/
Contact Info
Email info_at_amplelogic.com
Telephone
Board Line 91 40 42489921Pharma Solutions
91 40 42489927