Author: Strategy International

Strategic Finance & Accounts MIS

Developing Dynamic Financial & Accounting MIS Framework

Finance is core to any business organization. Its involvement starts with arrangement of Funds to start the business and continues till its closure. Any Financial MIS framework should originate from  Key Functions of Finance which are as follows :

Strategic Finance

  • Investment Evaluation – Utilization of Capital in right projects.
  • Finance Arrangement for Long Term Assets & Working Capital Finance.
  • Risk Management – Managing Risk in business and environment.
  • Stakeholder Communication – Shareholders, Bankers, Investors.
  • Financial Value Creation – Maximization of Business Valuation

Accounting & Statutory

  • Accounting of Transactions of business.
  • Statutory & Taxation compliances

Financial Efficiency

  • Profit Maximization from operations. – Revenue Maximization and Cost Minimization.
  • Financial Hygiene – Fraud & Mistakes Prevention.
  • Treasury Management

Keeping above functions in mind, following Financial MIS Reports can be generated :

Investment Efficiency MIS

Every business starts with introduction of financial capital. This capital could also have been invested in alternate investment opportunities. Apart from own Capital every business also arranges for loans from different sources. This Loan has to be repaid by promoters irrespective of profitability of business. Hence it is desirable that MIS should be generated to check returns and health of financial capital deployed in business. Following MIS may be generated to this effect.

  • Finance Macro Environment Report
  • Financial Value Creation Report
  • Investment Efficiency Report – Liabilities Based
  • Investment Efficiency Report – Assets Based
  • Investment Efficiency Report – Future Incomes
  • Investment Entry Report
  • Investment Exit Report
  • Credit Rating Report

Capital Expenditure MIS

Capital Expenditure Control is a vital element of Financial Management functions. Capital Expenditure generally involves large sum of expenditure. Further capital expenditure has a long term impact on profitability of company. Hence its finds an important place in Financial Management MIS. Some of key capital expenditure and assets related reports are as follows:

  • Capital Expenditure Analysis
  • Assets Disposed Off Report
  • List of Assets Not Authorized for Acquisition /Disposal
  • Fixed Assets Verification Analysis
  • List of Assets Pending Disposal
  • Reconciliation between Fixed Assets Register and Nominal Ledger

Project Progress MIS

Project MIS is a combination of Technical and Financial aspects of management. Every project has multiple components of cost and funding. It is essential that all these components progress as per schedule. This shall ensure that project is completed in time which in turn shall save Time & Cost Over runs. From Finance Angle two types of reports should be generated:

  • Project Progress Report: Expenditure Incurred
  • Project Progress Report: Means of Finance

Risk Management MIS

  • Risk Management MIS
  • Risk Coverage MIS
  • Insurance Adequacy Analysis: Market Value:
  • Premium Paid Analysis
  • Pending Claims Analysis
  • Exchange Fluctuation MIS

Regulatory MIS

Management of regulatory matters covered under different acts such as Income Tax, GST, Company Law, SEBI, RBI etc. are handled by Finance department in most organizations. A proper M.I.S shall help the Finance Manager to keep tab on all important aspects of this area of his responsibility. He should develop checks & systems to come to know about any deficiency in time and take necessary action. Broadly M.I.S for Taxation Compliances has to be patterned around following reports:

  • Statutory Laws Compliance Report
  • Statutory Laws Deficiency Report
  • Statutory Returns Compliance Report
  • Statutory Penalties Report
  • Forms Not Received

Financial Records MIS

  • Financial Records MIS
  • Accounts Master MIS
  • Reconciliation MIS
  • Debit Balance Confirmation MIS

Financial Analysis & Cost Management

  • Balance Sheet Analysis:
  • Profitability Analysis: Total Cost approach:
  • Profitability Analysis: Marginal Cost Approach:
  • Cash Flow Analysis:
  • Cost Minimization MIS:

Working Capital MIS

  • Working Capital Analysis
  • Debtors Analysis
  • Legal Debtors Analysis
  • Creditors Analysis
  • Vendor Advances MIS

Funds Management MIS

Deposit Float Report:

Payment Float Analysis

Bank Movement Plan:

Idle Funds Analysis:

Employee Accounts Analysis

————————————————————–

Please watch this space for regular articles on Strategy, MIS , Systems, Costing & Audit.

For Free Updates & Subscription to CSM Strategy & MIS Journal , Please send request for same in comments or Email given below.

This article is part of publication Strategic MIS. To download SMIS brochure :  https://www.csmstrategy.com/pdf/SMIS_Brochure.pdf

To know more about our Media, Training and Consultancy Services please contact on details below. To download complete Catalog , click on link below: https://www.csmstrategy.com/pdf/Catalog.pdf

©All rights are reserved with author

#strategy #MIS #ERP #Systems #Cost #analytics #planning #Audit #HR #Finance #Accounts #Funds #Treasury #Marketing #operations #Reports #profit #risk #supplychain #operations#processimprovement #management #learning #knowledge #corporate #information

Strategic Sales & Marketing MIS

Developing dynamic Sales & Marketing MIS Framework
Developing Strategic Sales & Marketing MIS

Sales & Marketing is a critical function essential to achieve objectives of organization An effective Sales & Marketing function is vital to success of an organization.

MIS is system to ensure that goals to business are achieved in acceptable quality and cost norms. Strategic MIS ensures that activities of business are aligned to core Strategy of organization. SMIS helps in identifying the bottlenecks of business which prevent achievement of goals. It also helps to judge effectiveness of Strategy adopted and to make changes if required.

Developing a Strategic Information System involves following steps :

a)        Goal Setting : Goals Of Organization at Macro & Micro Level.

b)        Bottleneck Identification : Identifying bottlenecks which prevent achievement of goals.

c)         Identifying Information required to help achieve goals and solve bottlenecks.

d)        Identifying Inputs required to compile this information

e)        Designing Formats to collect these information

f)         Assigning responsibility to collect and compile this information

g)        Analyzing the information received and applying to decision making.

h)        Evaluation and Audit of Information System.

SMIS for Sales & Marketing Function :

Strategic MIS for Sales & Marketing function primarily measures synergy between Marketing and Core Strategic Objectives of organization. Marketing MIS starts from Demand Projection and extends to Marketing function performance from different parameters such as Sales Target Achievement, Sales Profitability, Sales Promotion Efficiency, Receivables Management etc.  Key Sales & Marketing MIS reports which should be generated in every organization are indicated below :

A. Strategic Marketing MIS

  1. Macro Environment Analysis – Marketing MIS
  2. Competition Intelligence MIS
  3. Market Needs Analysis
  4. Sales & Marketing Objectives MIS
  5. Product Life Cycle MIS
  6. Market Segmentation MIS
  7. Brand Management MIS
  8. Market Size Report

B. Customer Relationship MIS

  1. Customer Orientation MIS
  2. Customer Grievances MIS – Detailed
  3. Customer Grievances MIS – Summary
  4. Customer Grievance Frequency Report

C. Sales Price MIS

  1. Product Pricing Report
  2. Sales Price Revisions MIS
  3. Sales Price Verifications MIS
  4. Price Verification Frequency
  5. Price Composition Trend Analysis
  6. Price Discount Efficiency MIS
  7. Foreign Exchange Fluctuation Impact MIS

D. Market Communication MIS

  1. Call Centre Effectiveness MIS
  2. Public Relations Effectiveness MIS
  3. Advertising Marketing Efficiency MIS
  4. Mobile SMS Marketing Efficiency MIS
  5. Email Marketing Efficiency MIS

E. Sales Revenue MIS

  1. Revenue Maximization MIS
  2. Sales Analysis Report :
  3. New Market Sales MIS
  4. New Product Sales MIS
  5. Channel Sales / Performance Report
  6. Tender Sales MIS
  7. Sales Loss Analysis MIS
  8. Product Despatch Loss Analysis
  9. Pending Disputed Sales Report
  10. Sales Return Notes Not Prepared MIS

F. Sales Order MIS

  1. Sales Order Report
  2. Pending Sales Order MIS
  3. New Sales Order MIS
  4. Orders Cancelled MIS
  5. Customer Order Rejections MIS

G. Sales Expenses MIS

  1. Selling & Distribution Overheads MIS
  2. Sales Expenses Reduction MIS
  3. Freight Cost Analysis
  4. Demurrage Cost
  5. Brokerage / Discount Control MIS

H. Sales Process MIS

  1. Sales Order Issue Time MIS
  2. Sales Order to Despatch MIS
  3. Time Taken from Despatch to Payment Report
  4. Emergency Sales MIS
  5. Sales Authorization MIS
  6. Sales  Function Automation MIS
  7. Sales Records Management MIS
  8. Sales Process Time & Cost Standards MIS
  1. Debtors Management
  1. Customer Credit Worthiness MIS
  2. Receivable Analysis MIS
  3. Legal Debtors MIS
  4. Customer Advances Analysis MIS
  5. Customer Balance Confirmation MIS

J. Sales Team MIS

  1. Sales Team Productivity Report
  2. Sales Team Performance Report
  3. Sales Team Performance MIS – KRA Analysis
  4. Sales Team Performance MIS – Summary
  5. Sales Team Development Report
  6. Sales Team Deficiency Report

K. After Sales Service MIS

  1. After Sales Service Efficiency MIS
  2. After Sales Service Profitability MIS
  3. Warranty MIS – Replacements
  4. Warrant Management MIS – Product Wise
  5. Warranty Management MIS – Invoice Wise
  6. Service Material Return MIS

L. Miscellaneous S&M MIS

  1. Goods Lost MIS
  2. Stocks Not booked MIS
  3. Slow & Non Moving Stock Analysis
  4. Sales Employee Imperest MIS
  5. Earnest Money / Security Deposit Report
  6. Deposit Float Report
  7. Deposit Float Report – Region Wise
  8. Post Dated Cheque Register
  9. Deduction Made From Invoice by Customer MIS
  10. Debit / Credit Note Control MIS
  11. Balance Sheet Analysis for Sales & Marketing

————————————————————–

Please watch this space for regular articles on Strategy, MIS , Systems, Costing & Audit.

For Free Updates & Subscription to CSM Strategy & MIS Journal , Please send request for same in comments or Email given below.

This article is part of publication Strategic MIS. To download SMIS brochure :  https://www.csmstrategy.com/pdf/SMIS_Brochure.pdf

Download complete Product Catalog for Media, Training & Consultancy services  from : https://www.csmstrategy.com/pdf/Catalog.pdf

Call : 9818397806 / 9582497948 / 0120- 4230954.

Email : info@csmstrategy.com

Website : www.csmstrategy.com

Journal : journal.csmstrategy.com

#strategy #MIS #ERP #Systems #Costmanagement #analytics #planning #Audit #HR #Finance #Marketing #operations #Reports #profitmanagement #riskmanagement #supplychainmanagement #operationsmanagement #processimprovement #management #learning #knowledge #corporate #information

Strategic Material & Supply Chain MIS

Developing Strategic Material & Supply Chain MIS

Material is an important cost in any business organization. However, in Manufacturing organizations it is prime cost where it can go up to 90% of total cost. Material Control is important function for any MIS. It has primarily four objectives:

  • Improving Material Quality and Customer Satisfaction
  • Reducing Material Cost
  • Ease of Material Availability
  • Improving overall Material Management System

Keeping above objectives in mind following Class of  MIS Reports are generated for Material:

Material Cost Reports: Purpose of these reports is to Plan, Collect and analyze information on Material Cost factors.

Material Quality Reports: Purpose of these reports is to analyze impact of Material Quality on Final Product.

Material Availability Reports: These reports analyze parameters to ensure timely and adequate availability of material for production.

Material Storage Reports: These Reports analyze parameters to check smooth and efficient working of material stores & warehouse.

Procurement Process Efficiency Reports: These reports analyze efficiency of procurement process.

Based on above classifications, key Material MIS Reports which should be generated in any organization  are as below:

A. Strategic Material MIS

  1. Macro Analysis for Material Management
  2. Bottleneck Analysis for Materials
  3. Material Content Improvement MIS
  4. Material Cost Reduction MIS
  5. Material Planning Report

B. Material Quality MIS

  1. Material Quality Improvement Report
  2. Materials Quality Related Rejections Trend
  3. Customer Quality Grievances Report
  4. Production Rejections Analysis Report
  5. Vendor Rejections Analysis Report
  6. Vendors with high Rejections Report
  7. Rejections Cost Performance Report

C. Material Storage MIS

  1. Stock Verification Discrepancy Report
  2. Physical Verification Frequency Report
  3. Stores Physical Condition MIS
  4. SRNS NOT PREPARED
  5. SRN not Accounted For
  6. Material not Returned
  7. Returnable Gate Passes Report
  8. Ageing Analysis
  9. Slow Moving Items Report
  10. Stock Loss at Stores

D. Material Lead Time MIS

  2. Indent & Purchase Order Gap Report
  3. Purchase Order to Supply Time Gap Report
  4. Time Gap for Inspection of Goods Report
  5. Time taken from gate to stores Report
  6. Time taken for issue of material Report
  7. Time taken for release of payment Report
  8. Vendor Wise Supply Delays Report
  9. Item Wise Delays Report

E. Material Price MIS

  1. Price Verification Analysis
  2. Price Composition Trend Report
  3. Foreign Exchange Fluctuation Impact MIS
  4. Price Discounts Efficiency MIS
  5. Price Reduction MIS
  6. Freight Cost Analysis MIS
  7. Demurrage Cost Analysis MIS
  8. Material Price Verification Frequency Report
  9. Adequacy of Quotations Report

F. Purchase MIS Reports

  1. Pending Purchase Orders MIS
  2. Purchase Orders Cancellation MIS
  3. Purchase Orders Revision MIS
  4. Purchase Authority Variation MIS
  5. Vendor Database MIS
  6. New Vendor Development
  7. Vendor Advances Blocked
  8. Material Vendors Ageing MIS
  9. Vendors Balance Confirmations MIS
  10. Legal Vendor Cases Status
  11. Purchase not with lowest bidder’s report
  12. Emergency Purchases MIS
  13. Pending Purchase Requisition MIS
  14. Purchase Order Variation MIS
  15. Pending Disputed Purchases
  16. Stock loss at Material Receipt
  17. Material Return MIS

G. Special Material MIS Reports

  1. Balance Sheet Analysis for Materials
  2. Material Reconciliation MIS
  3. Material Management Process Automation MIS
  4. Production Loss due to Material Availability
  5. Purchase Expenses Analysis
  6. Material Working Capital MIS
  7. Consumables & Packing Cost Analysis
  8. Goods Lost MIS
  9. Insurance Coverage of Stocks MIS
  10. Empty Containers / Bags MIS
  11.  Scrap Treatment MIS
  12. Material Shortage Analysis Report
  13. Material Standards & Ratios Analysis MIS

———————————————————–

Please watch this space for regular articles on Strategy, MIS , Systems, Costing & Audit. For Free Updates & Subscription to CSM Strategy & MIS Journal , Please send request for same in comments or Email given below.

This article is part of publication Strategic MIS. To download SMIS brochure :  https://www.csmstrategy.com/pdf/SMIS_Brochure.pdf

Download complete Product Catalog for Media, Training & Consultancy services  from : https://www.csmstrategy.com/pdf/Catalog.pdf

Call : 9818397806 / 9582497948 / 0120- 4230954.

Email : info@csmstrategy.com

Website : www.csmstrategy.com

Journal : journal.csmstrategy.com

#strategy #MIS #ERP #Systems #Costmanagement #analytics #planning #Audit #HR #Finance #Marketing #operations #Reports #profitmanagement #riskmanagement #supplychainmanagement #operationsmanagement #processimprovement #management #learning #knowledge #corporate #information

Violence Against Women – A Strategic Analysis

Journal.csmstrategy.com : Violence Against Women

There is a nationwide outrage on recent rape incidents from different states. There are numerous processions , TV discussions , parliament debates and call to hang the guilty. As a nation we are a reactive nation. We tend to emotionally react to situations and forget after few days. There were similar rages in past on rape cases , some of them got equal national prominence , but the problem remains where it was in past.

What we lack is a culture of Strategic Thinking , which requires deeper research into problems and building systems to solve it for ever. This is same with every problem we face whether crime against women or terrorism or problem of alcoholism and drug abuse. We don’t think deep enough. Our actions don’t come out of thoroughly researched plan of action. Rather we just react and act in casual manner. I am not claiming to have conducted deep research into this problem , but from CSM Strategy point of view my take on issue of crime against women is as below :

One of major reason of our youth indulging in these crime is lack of positive vision , hope and focus in major part of our population. Our youth does not have a positive focus in life. Most of these crimes are committed from people from lower strata of life. These people live a life which is without any hope and under abject poverty . Just visit any of poor colonies or Jhuggis in Delhi and see the condition in which the people live there.

It is very difficult to get a healthy mind set in those depressing conditions . There is no hope – no dream – no vision and no focus for these people to change their life. When a life is so deprived , one is easily swayed towards criminality.

One of first thing for Long Term Solution to this problem is to give a vision to youth of this country. For this we need a vision for India . Unfortunately there are few leaders who are credible enough to give this vision to youth of India.

Taking a step further , we need to learn the art of sowing seeds to future in minds of our children and our youth. We need to channelize their energies to a positive goal . Our parents and teachers need to be trained in this. Changing the focus of our youth and population at large is most important strategic step towards problem of crime against women. A mind which is focused on building a future for itself and for the country is likely to availd in such sort of behaviour.

2.  At a Strategic Level , we also need to revisit the type of inputs we give to our children and youth from our movies , magazines , TV and online media. Most of stuff rolled out from media shows women as an object to fulfil physical desires. We do not see health portrayal of women as a normal human being. It is stupid to expect that our children and youth to remain unaffected with this visual onslaught which ignites their passions. The craziest part is that our liberal media is first to shout when you talk of any level of regulation towards this.

Human minds are not machines but products of emotions. Our children and youth should get messages from media which promote values of discipline , respect , hard work and compassion. We all know the principle of GIGO ( Garbage in – Garbage Out ). If we want a society built upon these values we need to ensure that social messages we get from media are altered.

3. The legal solution which comes out of fear of law is also an effective deterrent but not an ideal solution. You can’t solve a problem of mindset with fear. Nevertheless the legal solution is required to keep an order of semblance in society. However to do this it is required that the solution is swift and with enough safeguards to prevent misuse. This is a tall order keeping in view the present legal system which is imported from west and is not just suited for a country like India.

In nut shell , we should stop being reactive and look for real solutions to our problems.

———————————————————–

For Free Subscription of CSM Strategy & MIS Journal in Inbox please send your Email details. To know more about our Media, Training and Consultancy Services for Individuals & Organizations , please visit our website : www.csmstrategy.com or contact on numbers given below. To download complete Catalog , click on link https://www.csmstrategy.com/pdf/Catalog.pdf

Call: 9818397806 / 9582497948/ 0120-4130954 Mail: info@csmstrategy.com Website : www.csmstrategy.com

©All rights are reserved with author

 

CSM : The Natural Law Strategy for Success

CSM i.e. Core Strategy Manifestation is a program developed by Strategy International, to develop right strategies for individuals as well as organizations to unleash a spiral of growth and peak success in harmony with society and environment. CSM is based on some very simple but highly effective natural laws. Almost all of successful people, companies and nations have acted and behaved in a common pattern. CSM attempts to articulate it simply for every Individual or Organization.

CSM is result of numerous readings, ideas & decades of experiences which has come out of laboratory of life. Deep gratitude is expressed towards all the thinkers and achievers of past and present whose ideas have provided the basic raw material for this program.

Every Individual , Organization and Nation makes effort to grow & evolve – from darkness to light, from failure to success , from inefficiency to peak efficiency. Every living entity undertakes this journey of evolution and growth. Actual success from these efforts depends on multiple factors which combine in different ways during this journey. CSM is a modest attempt to give an insight towards this journey to success.

CSM is not claimed to be an absolute theory. It is based on natural principal that no knowledge is constant and perfect. However the basic laws of nature remain constant – only applications may differ. Hence one should evaluate knowledge with an open mind and any disagreement be taken as a tool for further development.

Three Segments : CSM program has been developed for three specific segments : Individuals, Organizations and Nation. The universal application of CSM principals is due to its adherence to basic laws of nature which are simple and can be applied to any situation and issues from business and governance.

One major problem with many management theories is lack of integration between individuals, companies and nation. The organizations are also divided in water tight departments, each with its own boundaries.This is against laws of nature. Nature is designed in a way that all systems are integrated in a harmonious way while leading to one destination. In terms of Spirituality, it is said that purpose of all living beings is achievement of spiritual integration. Same applies for organizations and nations. All Individuals and organizations should work in a way towards goal of maximum social value and harmonious integration. CSM articulates this intense integration at every level while still retaining own specific identity.

———————————————————–

Please watch this space for regular articles and updates.To know more on CSM please visit www.csmstrategy.com . To know about all Publications, Training & Consultancy services , kindly click at following link https://www.csmstrategy.com/pdf/Catalog.pdf.

Contact Details : +91 9818397806 / 9582497948 / 0120-4130953. Mail : info@csmstrategy.com. www.csmstrategy.com

#strategy #naturallaw #success #careermanagement #money #health #energy #organization #nation #governance #politics #hrReport