This program enables you to determine the profitability of menus. For example, this enables a profit figure to be calculated for the action of fitting a standard alarm unit. The initial display is a summary of all menus but this can be altered by specifying a franchise for labour and/or a range of menus. You have the option to print a summary of menu profitability or a detailed report. It is also possible to view a breakdown of parts and labour for each menu item. Only RTS codes with a default allowed time and an hourly cost and labour rate are displayed sensibly in these reports because these values are used to calculate profitability of labour items in a menu.
Note: This report can be extremely useful in identifying areas of business with little or no profit margin.
The Summary Menu Profitability report summarises the following details:
The Detailed Menu Profitability report summarises the following details:
To produce a summary/detailed menu profitablity report:
The POINT OF SALE menu is displayed.
Select the Reports & enquiries option.
The SO REPORTS AND ENQUIRIES menu is displayed.
Select the Menu profitability option.
The Detailed Menu Breakdown form is displayed.
Tip: Double-click a menu item to view a breakdown of parts and labour.
Do one of the following:
To produce a summary of menu profitability, leave the Detailed check box unticked and click the Print button.
To produce a detailed menu profitability report, tick the Detailed check box and click the Print button.
The report is printed to the currently selected printer, and a dialog box is displayed with the following message:
Printed OK
The Detailed Menu Breakdown report form is displayed when you select the Menu profitability option from the SO REPORTS AND ENQUIRIES menu. From this form you can determine the profitability of menus, and print a summary of menu profitability or a detailed report.
Franchise for labour:
The system defaults into this field the first labour rate in the labour rates table. Enter the labour franchise that you want to employ on the report. This will have a significant impact on the profit and GP% because of the variable cost of labour associated with each franchise.
Tip: Click the
button to display a list of valid options.
Start menu:
The system defaults into this field the first menu in the Manufacturer Systems Menu pricing file. Enter the first menu code in the range that you want to employ on the report.
Finish menu:
The system defaults into this field the last menu in the Manufacturer Systems Menu pricing file. Enter the last menu code in the range that you want to employ on the report.
Detailed: By default, this box is unticked to produce a summary of menu profitability. Tick this check box to produce a detailed menu profitability report.
PUSH BUTTONS:
Print: Prints the report to the currently selected printer.
Exit: Returns you to the SO REPORTS AND ENQUIRIES menu.
Help: Displays help on the current application using the default browser.
For each menu item, the following details are summarised:
Tip: Double-click a menu item to view a breakdown of labour and parts.
Menu code: The menu code in the Manufacturer Systems Menu pricing file.
Description: A description of the menu.
Fixed price: The retail price of the menu.
Labour retail: The retail price of labour.
Parts retail: The retail price of parts.
Difference: This is the difference between the fixed price and the combined retail price of labour and parts. The calculation for this figure is:
Fixed price - (Labour retail +Parts retail)
Labour cost: The cost price of labour.
Parts cost: The cost price of parts.
Profit: This is the amount of profit. The calculation for this figure is:
Fixed price - (Labour cost + Parts cost)
GP%: The gross profit percentage of selling the part. The calculation for this figure is:
(Profit/Fixed price) * 100
The Breakdown For Menu form is displayed when you double-click a menu item on the Detailed Menu Breakdown form. From this form you can view a breakdown of labour and parts for the menu item.
The first table displays a breakdown of labour. For each labour item, the following details are summarised:
RTS description: The Repair Time Schedule (RTS) code.
Allowed: The time allowed to complete the operation.
Rate: The labour rate.
Cost/hour: The hourly cost price of labour.
Retail: The total retail price of labour. The calculation for this figure is:
(Allowed*Rate)
Cost: The total cost price of labour. The calculation for this figure is:
(Allowed*Cost/hour)
The second table displays a breakdown of parts. For each part, the following details are summarised:
Part number: The packed part number.
Description: A description of the part.
Quantity: The number of parts required to complete the operation.
Retail: The retail price of the part.
Cost: The cost price of the part.
