- This topic has 0 replies, 1 voice, and was last updated 19 years ago by
.
-
Posts
-
Theoretical Sales Plugin
ThSales 6.01Last edited: December 15, 2003 08:18 AM
The Theoretical Sales plugin is a custom plugin written explicitly for Lucky 7, but is available for download to dealers who would like to use it as is. It calculates theoretical cost/sales by by any one preselected price level, and compares it with actual sales, calculating the percentage between the two and reporting it by group. This can allow a user to see what sales would be if all items had been sold at this price level. By keying the cost of each item into an unused price level, it provides a simple way to get theoretical food cost also.
Place the following files in the Plugins directory:
* ThSales.EXE – the program executable
* ThSales.PID – the program definition file
* ThSales.RES – the program resource fileSample
*** Theoretical Sales Report ***
Report Printed on: Thu, Sep 21, 2000 5:30pm
Report For: Fri, Jun 02, 2000
> Fri, Jun 02, 2000Using Price Level 0
** Group 0 **
PLU DESCRIPTION QTY COST THEO ACTUAL %
311 bleu cheese 1 0.00 0.00 0.00 0.0
TOTALS: 1 0.00 0.00 0.0** Liquor **
PLU DESCRIPTION QTY COST THEO ACTUAL %
2 NY Steak 3 9.10 27.30 33.30 82.0
TOTALS: 3 27.30 33.30 82.0** 2Sides **
PLU DESCRIPTION QTY COST THEO ACTUAL %
1 Sirloin Steak 1 8.00 8.00 12.00 66.7
3 T-Bone Steak 2 11.35 22.70 22.70 100.0
TOTALS: 3 30.70 34.70 88.5** 2Sundry **
PLU DESCRIPTION QTY COST THEO ACTUAL %
227 Salad 1 2.00 2.00 0.00 0.0
TOTALS: 1 2.00 0.00 0.0** Descriptor 13 **
PLU DESCRIPTION QTY COST THEO ACTUAL %
228 Well Done 4 2.00 8.00 0.00 0.0
TOTALS: 4 8.00 0.00 0.0===================================================================
GRAND TOTALS: 12 68.00 68.00 100.0
Note: Sales totals are based on prices
as of when the report was run, not
when the items were sold.
(Version 6.01)
Configuration
ThSales.jpg (11516 bytes)The plugin can be configured from the Configure Extra Reports section of the File pulldown menu. The only option is to select which price level to use when generating the report.
Technical
Theoretical Sales loads Registry.Dat for the configuration option, Product.Dat for the names and prices, and Groups.Dat for the group names. It then reads the journal files as necessary.
Theoretical sales amounts are generated by multiplying the current price in the selected price level with the number of items rung up. The items are then posted under the group as currently set for that PLU in the product database.
Actual sales amounts are generated by adding up them up in the journal. However, the item will report under the group it is currently assigned to in the product database. This means that if the item was actually sold under another group, this report may not balance with other group reports.
The percentage is simply the theoretical sales divided by the actual sales.
Theoretical Sales holds the currently selected price level on line 40 of Registry.Dat as a single digit holding a value of 0 to 3. 0 is the default when the plugin is first installed.
Revisions6/22/00 Version 6.00 rw
1. Initial Release
9/21/00 Version 6.01 rw
1. Added Actual Sales and Percentage calculation to report.
2. Changed SALES to THEO in header.
3. Changed report to show sales under the group as currently set in the product database. Previously, it showed sales for the group the PLU was assigned to when the last item was rung up. Although theoretically more likely to match other group reports, the old method created the possibility that group totals and calculations may not match the sum of the items in that group.
- You must be logged in to reply to this topic.