QSR Cost of Sales & Gross Profit Plugin
a custom Manager plugin for Express Concepts

Last edited: December 15, 2003 08:20 AM

This program is an extra report that can be launched from Manager.  It is a custom report for Express Concepts and will not be applicable to any other customers.  The reason is, that it employs non standard methods to generate a cost of sales and gross profit by Profit Center.  Profit Center(s) in Express Concepts are represented by Sales Groups (as defined in Manager) and also by Cost Groups (as defined in Basic Inventory).  The report uses the Cost Groups and Sales Groups to calculate % of Sales and profitablity.  There is no real correlation between the two different types of groups, therefore the customer is responsible for keeping PLUs and Inventory Items in their proper Sales/Cost groups.

It functions similarly to other plugins, however you do not have to select a range of dates to run it.  Instead, when you choose this report, you will be presented with it’s own select-a-date screen populated with inventory count dates.

Here’s what the report looks like:

                                           

                                            ** QSR Cost of Sales & Gross Profit Report **

                                            Report Printed on: Fri, Jun 05, 1998  11:58am

                                        Report For: Sun, Feb 08, 1998

---

> Sun, Mar 08, 1998

                                    Sales dates included: Mon, Feb 08, 1998

---

> Sun, Mar 08, 1998

                                            Starting Counts gathered from: Mon, Feb 09, 1998

                                            Ending Counts gathered from: Sun, Mar 08, 1998

                  Group                    Usage    Net Sales        Disc  Gross Sales  % of Sales  Gross Profit

               

---

                    1 Meat & Cheese        2072.43      4187.23        0.00      4187.23    49.5    2114.80

               

---

                                          2072.43      4187.23        0.00      4187.23    49.5    2114.80

(Program: XprsPlg1  Version: 6.00)

Installation

Create a directory called Plugins on the same drive as Manager was found. If Manager was found on C: then the directory should be created on the C: drive.

Place the program files in this directory. The necessary files are:

    * XprsPlg1.EXE – the program executable
    * XprsPlg1.RES – the resource file
    * XprsPlg1.PID – the program definition file

You can download XprsPlg1 from our version 6.xx download section.

Below is an excerpt from Plugins.DOC describing the program definition file. For more detailed information about the workings of a plugin, please refer to the Plugins.DOC.
.PID File Format

The .PID file is a text file that may be created with DOS Edit or any other text editor. It contains settings that Manager will use. Below are a list of possible settings and their meanings.

The file may also contain remarks. A REM indicates that the line is a remark, and will be ignored. Blank lines will also be ignored. A remark may be placed after a setting, on the same line if it is preceeded by a ; symbol.

The following are sample settings, with remarks about each:

Version=6 ;This required line informs manager what version of TouchNet/TouchPRO the report is compatable with.

Name=A Plugin Report ;This is the name that the user will see

Wide=136 ;This is the report width (80 and 136 are common)

UseJournal=yes ;This report will not be launched without the user selecting dates first. Without this line, the /Date=YYMMDD-YYMMDD command line will not be passed.
Revisions

06/05/98 Version 6.00

  1. Initial Release

07/09/98 Version 6.01

  1. At customer’s request, the report now combines the totals for the following groups:
        1. 1 and 2
        2. 10 and 11
        3. 18 and 19
        4. 27 and 28
        5. 34 and 35
        6. 43 and 44

      The totals will be combined into the first group in each combination.
      (Group 1 will represent the totals for Groups 1 and 2)
  2. The report now uses the Sales Group names instead of the Cost Group names.

07/14/98 Version 6.02

  1. Changed Discount sales to report as a positive number instead of a negative.  Was causing the Gross Sales (net + disc) to calculate incorrectly.

09/30/98 Version 6.03

  1. Refixed bug found in 6.02

12/09/98 Version 6.05

  1. Y2K compliant.