• View how much your company is spending, based on the invoice amount, for each commodity and supplier. • View a commodity’s purchase order savings across all items and suppliers in an operating unit, in the selected period. These are savings that result from better purchase order prices, compared to the average price paid in [...]
Read about the Type – 1 approach Type – 2 approach Type – 3 approach Type 4: This type defines the method of creating dashboard using Excel. The data and presentation is all part of the Excel file. This is the most popular approach as it is very easy and affordable to create dashboards. It [...]
By DZ Editor
Also posted in Dashboard, Hospital, IT, Product Life Cycle, Project Management, Quoting, Trader, Transport, Widget, desktop, sales, service
Read about the Type 2 Approach Type 3: This category involves the use of some big vendor BI tool. These BI tools are quite comprehensive and come with tons of options to choose from. They provide ad-hoc reporting and easy dashboard creation options. Once installed and configured, there is often a need to define data [...]
By DZ Editor
Also posted in Dashboard, Hospital, IT, Product Life Cycle, Project Management, Quoting, Trader, Transport, Widget, desktop, sales, service
This is a continuation of the Dashboard Creation Methods Type 2: This category involves the use of some Dashboard designing tool. You need to download and install the third party software and learn their basic steps in designing the dashboards. Most often the designing tools offer variety of connection methods to the various databases and [...]
By DZ Editor
Also posted in Dashboard, Hospital, IT, Product Life Cycle, Project Management, Quoting, Trader, Transport, Widget, desktop, sales, service
Are you trying to build a Dashboard or a new Application? Three are three types of Dashboard Solutions Type 1: This category defines those tutorials where you built everything from scratch. You write your own SQL queries, database connection methods and create data files. Then you construct your own presentation layer by defining the html, [...]
By DZ Editor
Also posted in Dashboard, Hospital, IT, Product Life Cycle, Project Management, Quoting, Trader, Transport, Widget, desktop, sales, service
Here is the list of KPIs/metrics on the dashboard Inventory Value Gross Adjustment rate Accuracy Rate Category Classification (funnel view) Quantity by Inventory Cateogyr Tags: dashboards, inventory dashboard, inventory kpis, funnel charts dashboard, funnel chartquickbooks,peachtree,sugarcrm,small business
Supply Chain KPI ListingProduct Revenue Product sales revenue (not including service) recognized in selected period (based on AR invoice lines)Product Revenue Backlog Value of booked order lines less returns plus deferred revenue backlog (invoiced but not recognized)Production Value Value of WIP Completions into InventoryProduction to Plan Rate Production Standard Value / Planned Standard ValueReceipt to [...]
Supply Chain KPI ListingPick Exceptions Rate Percent of Picks with ExceptionsPick Release to Ship Time elapsed from Pick Release to Ship ConfirmPlanned Inventory Turns Planned Cost of Goods Sold / Planned Inventory ValuePlanned Margin Planned Revenue – Planned CostsPlanned Margin Percent Planned Margin / Planned RevenuePlanned On-Time Shipment Planned service level (percent of shipments shipped [...]
Supply Chain KPI ListingAnnualized Inventory Turns Annualized COGS / Average Daily Inventory ValueBacklog Value Value of open, not yet fulfilled, booked order linesBook To Fulfill Ratio Booked Order Value / Fulfilled ValueBook to Ship Days Average of shipped date – firmed date (booked date used if no firmed date)Booked Order Value Booked order line value [...]
