Management Information Report
Note: This section has been modified. It continues to undergo review for further improvements. The present modifications are correct, but the content is still being enhanced.
This report (PAR029) provides an analysis for the parts departments performance for the current month and is generated at month's end. Vendor G/L and other miscellaneous vendors are NOT excluded in any way. There are NO exclusions based on customer settings (type, misc, etc) and all customers are taken into account.
See Performing a Parts Month End and PAR029 Parts Management Report Q and A.
Formulas for Percent of Fill
Counter Sales Stocked Items
percentage of counter sales of stocked items = paid counter sales ÷ stocked counter sales
| Equation | Description | |||
|---|---|---|---|---|
| paid counter sales | = | |||
| counter charge sales | All items sold to accounts receivable internal. | |||
| + | counter cash sales | All items paid at the counter with cash. | ||
| + | counter warranty | All warranties sold at the counter. Generally applies to equipment and parts. | ||
| ÷ | ||||
| stocked counter sales | = | |||
| counter charge sales | All items sold to accounts receivable internal. | |||
| + | counter cash sales | All items paid at the counter with cash. | ||
| + | counter warranty | All warranties sold at the counter. Generally applies to equipment and parts. | ||
| + | counter lost sales stocked | All special orders recorded as a lost sale. | ||
| + | stocked counter special orders |
All special orders, including those sold to accounts receivable internal, or paid at the counter with cash, or for warranties sold at the counter. |
||
Counter Sales All Items
percentage of all sales that were counter sales = paid counter sales ÷ all counter sales
| Equation | Description | ||
|---|---|---|---|
| paid counter sales | = | ||
| counter charge sales | All items sold to accounts receivable internal. | ||
| + | counter cash sales | All items paid at the counter with cash. | |
| + | counter warranty sales | All warranties sold at the counter. Generally applies to equipment and parts. | |
| ÷ | |||
| all counter sales | = | ||
| counter charge sales | All items sold to accounts receivable internal. | ||
| + | counter cash sales | All items paid at the counter with cash. | |
| + | counter warranty sales | All warranties sold at the counter. Generally applies to equipment and parts. | |
| + | all counter lost sales |
All special orders recorded as a lost sale and counter lost sales of a non-stocked item. |
|
| + | all counter special orders |
All special orders and non-stock sales sold to accounts receivable internal, counter cash sale, or counter warranty. |
|
Shop Sales Stocked Items
percentage of all sales that were shop sales of stocked items = paid shop sale ÷ all shop sales of stocked items
| Equation | Description | ||
|---|---|---|---|
| paid shop sales | = | ||
| shop customer sales | All customer shop sales. | ||
| + | shop warranty sales | All warranty shop sales. | |
| ÷ | |||
| all shop sales | = | ||
| shop customer sales | All customer shop sales. | ||
| + | shop warranty sales | All warranty shop sales. | |
| + | stocked lost sales |
All shop sales of stocked items recorded as a lost sale. |
|
| + | stocked shop special orders |
All shop sales of stocked items that were out of stock and had to be special ordered. |
|
Shop Sales All Items
percentage of all sales that were shop sales = paid shop sale ÷ all shop sales
| Equation | Description | ||
|---|---|---|---|
| paid shop sales | = | ||
| shop customer sales | All customer shop sales. | ||
| + | shop warranty sales | All warranty shop sales. | |
| ÷ | |||
| all shop sales | = | ||
| shop customer sales | All customer shop sales. | ||
| + | shop warranty sales | All warranty shop sales. | |
| + | all shop lost sales | All shop sales of stocked and non-stocked items recorded as a lost sale. | |
| + | all shop special orders | All shop sales of stocked and non-stocked special orders. | |
Reconditioning Sales Stocked Items
Reconditioned from a IntelliDealer system perspective means that the dealership is paying for the part.
percentage of sales that were sales of stocked recondition items = reconditioning sales ÷ stocked reconditioning sales
| Equation | Description | ||
|---|---|---|---|
| reconditioning sales | All internal shop sales. | ||
| ÷ | |||
| all reconditioning sales | = | ||
| reconditioning sales | All internal shop sales. | ||
| + | stocked reconditioning lost sales | All sales of internal shop parts, stocked sale or special order, recorded as a lost sale. | |
| + | stocked reconditioning special orders |
All sales of internal shop parts, stocked parts and special order parts. |
|
Reconditioning Sales All Items
percentage of sales that were sales of all recondition items = reconditioning sales ÷ all reconditioning sales
| Equation | Description | ||
|---|---|---|---|
| reconditioning sales | All internal shop sales. | ||
| ÷ | |||
| all reconditioning sales | = | ||
| reconditioning sales | All internal shop sales. | ||
| + | all reconditioning lost sales | All sales of internal shop parts, stocked, non-stocked, or special order, recorded as a lost sale, which means that the part had to be acquired outside of the dealership. | |
| + | all reconditioning special orders | All sales of internal shop parts, stocked parts and special order parts. | |
Total Sales All Items
total percentage of all sales = paid sales ÷ all sales
| Equation | Description | ||
|---|---|---|---|
| paid sales | = | ||
| counter charge sales | All items sold to accounts receivable internal. | ||
| + | counter cash sales | All items paid at the counter with cash. | |
| + | counter warranty sales | All warranties sold at the counter. Generally applies to equipment and parts. | |
| + | shop customer sales | All customer shop sales. | |
| + | shop warranty sales | All warranty shop sales. | |
| + | reconditioning sales | All internal shop sales. | |
| ÷ | |||
| all sales | = | ||
| counter charge sales | All items sold to accounts receivable internal. | ||
| + | counter cash sales | All items paid at the counter with cash. | |
| + | counter warranty sales | All warranties sold at the counter. Generally applies to equipment and parts. | |
| + | all counter lost sales | All special orders recorded as a lost sale and counter lost sales of a non-stocked item. | |
| + | all counter special orders | All special orders and non-stock sales sold to accounts receivable internal, counter cash sale, or counter warranty | |
| + | shop customer sales | All customer shop sales. | |
| + | shop warranty sales | All warranty shop sales. | |
| + | all shop lost sales | All shop sales of stocked and non-stocked items recorded as a lost sale | |
| + | all shop special orders | All shop sales of stocked and non-stocked special orders. | |
| + | all reconditioning lost sales | All sales of internal shop parts, stocked, non-stocked, or special order, recorded as a lost sale | |
| + | all reconditioning special orders | All sales of internal shop parts, stocked parts and special order parts. | |
Activity Information
For all Activity Information statistics, these areas are shown:
-
CUR DOL—Current Cost used. Calculated as either:
-
Original cost + any additions (freight, pre-delivery, repairs, etc.) - any removals or rental costing.
-
Original cost + all capitalized entries (work orders that hit the inventory account)
-
-
AVG DOL—Average Cost used. The average cost is automatically updated whenever parts are receipted in the system (either through inventory adjustments or parts orders). Calculated as:
-
(Old Avg Cost x Old on Hand) + (New Cost x Number of Parts Receipted at New Cost) / Old on Hand + Number of Parts Receipted
For example, assume a part is added to the system with a cost of $10.00 and 2 parts are receipted. The average cost is $10.00 each for these 2 parts. Now assume the cost increases to $12.00 later in the year and 1 additional part is receipted after that cost has increased.
The now average cost is calculated as: (10.00 x 2) + (12.00 x 1) / (2 + 1) = $10.66
-
Note:
Negative on-hands are not included.
Retail Sales Last 12 Months
retail sales for the last 12 months
Retail Sales Current Month
retail sales for the current month
Cost of Sales Last 12 Months
cost of sales for the last 12 months
Cost of Sales Current Month
cost of sales for the current month
Avg Inventory Last 12 Months
Last 12 months inventory at cost ÷ 12
Inventory Dollars Current Month
current month's inventory value
Inventory At Cost, Zero Sales, L12
inventory value of all items which have had no sales for the last 12 months
Inventory At Cost, Zero Sales & Receipts, L12
inventory value of all items which have had no sales or receipts for the last 12 months and the parts have been in the system for more than 12 months
Cost of Sales % (Cost / Retail)
cost of sales last 12 months ÷ retail sales last 12 months
Markup Percent
(retail sales last 12 months - cost of sales last 12 months) ÷ cost of sales last 12 months
Turnover Last 12 Months (all items)
cost of sales last 12 months ÷ average inventory last 12 months
Turnover Last 12 Months (items sold)
cost of sales last 12 months ÷ (average inventory last 12 months - inventory value of parts with no sales the last 12 months)