Would you like to identify bottlenecks, analyse job margins, evaluate whether to outsource a process, optimise machine selection for specific jobs, or determine the most suitable materials for your operations?
Packway collects data from the various cost centres and builds analytical and statistical reports for each individual job, client, cost centre and period. Managers can thus customise the dashboard to display the data they’re most interest in, and constantly analyse and view updates of the current situation in real-time.
Packway includes a Business Intelligence module that lets you monitor any decision and any area of interest. It delivers swift, smooth production management and never overlooks any data because it’s seamlessly integrated with your entire management system, including accounts.
Management analysis is based on OLAP cube architecture and provides the flexibility to filter and manipulate data much like you would in an Excel spreadsheet, ensuring comprehensive and effective management. The structure allows you to collate all data supplied by Packway into queryable containers which can be viewed through any compatible software: two of the most common are Excel and Microsoft Power BI .
MANAGEMENT ANALYSIS USAGE METHODOLOGY
There are many different types of Cube:
– For production ,such as estimates and jobs or shipped goods.
– For purchasing,such as goods purchased and received.
You can also view production summaries showing job profitability and machine performance: waste per machine, machine performance when producing a particular type of product etc.
The data collection process is automatic and covers all data entered. Packway organises and freezes them in this parallel structure. While it’s extrapolating data for analysis, ordinary work continues uninterrupted and all data is kept safe and unmodified.
What are the advantages? Each area can analyse and process statistics by selecting the data they’re interested in without the need to print out paper copies. All users can access and extract data, share it and view it in real time – all from one common location.
Management analysis involves multiple dimensions: the production manager, the purchasing department and comparison of estimates with final costings. It’s called Management analysis because its value lies in its ability to provide managers with data to help them make decisions.
Data flow in Packway
The data comes from the entire production chain: estimate, order confirmation, analysis of the order and its related requirements, purchases and materials received, production, conclusion of production with final costings, and shipment to the client, at which point the final profit and economic analysis of the job can be viewed.
COSTS ANALYSED AND COMPARED
Theoretical estimated costs
Theoretical production costs
Actual final costs
Statistics and Analysis of Job Costs
SUMMARY KPIs, BAR CHARTS, PIVOT TABLES OR FILTERS
COSTS: estimated cost, theoretical costs and real cost. Deviation between theoretical and real costs or between estimated and real costs.
EFFECTS: % of turnover costs (total production cost, raw materials cost)
MARGINALITY: the margin of the net production cost compared to the net raw material cost
PROFIT AND LOSS: compared to gross turnover of a real and expected order with commissions, net revenue broken down so as to arrive at the final operating margin, etc.
EXAMPLE OF ANALYSIS: gross turnover by province, net operating margin by product type (e.g. exhibitor products: top and bottom ten), clients by gross turnover, analysis of agents, profit and loss displayed by families of articles, with the ability to enter details of the product family and view a breakdown of data by order.
SALES ANALYSIS (sales order by product family or item or time period: how the various periods selected contribute to the total)
ANALYSIS OF SHIPPED GOODS: the moment when the goods leave the warehouse and when the sale is actually complete
