Machine Profitability Report (F-032)

Owned by Peter Drill
Last updated: Aug 09, 2019 by Diane Partridge

Overview

This report runs against sale shipment lines that have been linked to a machine, either due to service calls or meter charging, and allows you to determine the profitability of a machine or a group of machines over a set period of time.
The product that stands for the machine needs to be set up correctly. That is you need the manufacturer on the Product.
In order to get an accurate machine profitability report, you need to set up the Costs on your labour products. Getting starting with machine profitability (labour costing)

Data Type

Sale Shipment Line

Criteria

  • Start and End Date Range
  • Manufacturer
  • Machine Product
  • Customer
  • Machine
  • Status
  • Only GP%
  • Exclude Labour Costs Check Box
  • Show Details Check Box

Grouping

  • Manufacturer
  • Model
  • Machine ID
  • Product Sold

Sorting

  • Machine ID

Columns

NameNotes
Last Service DateDate of the most recent service order for the machine
Quantity
  • For meter count products, the sum of the quantity counted for the meters
  • For anything else, the sum of the quantity shipped eg toner products
Actual LabourSum of the "actual" quantity on associated service order lines for any labour time products.
Each Cost
  • For stocked products, the average of the actual cost of the product
  • For non-stock products, the average of calculated notional costs based on the category settings (usually set to cost price 1 of the primary product supplier)
  • Copycost itself has no cost. The cost is all in the labour. The cost of copycost product to stay nil and the cost of the labour to report.
Each Sell ExThe average selling price of the product
Total Cost
  • For stocked products, the sum of the actual cost of the product
  • For non-stock products, the sum of calculated notional costs based on the category settings (usually set to cost price 1 of the primary product supplier)
Total Sell ExThe sum of the "value ex tax shipped" of the product
MarginThe sum of the margin values of the product

GP %

The calculated gross profit percent based on the sum of the "value ex tax shipped" and margin of the product


Machine Profitability Report

  1. Log onto Readysell>Form Reports>Machine Profitability F-032
  2. HIghlight the Parameter and select on 'Show report using parameters'

  3. Enter your parameters and click on OK

     Show Me

  4. Report will appear to screen. Review