JPH0223462A - sales forecast alarm system - Google Patents

Abstract

(57) [Summary] This bulletin contains application data before electronic filing, so abstract data is not recorded.

Description

DETAILED DESCRIPTION OF THE INVENTION [Industrial Field of Application] The present invention relates to a sales prediction alarm system that creates an alarm list of the actual sales numbers of measured products sold in packs by time zone for each day of the week.

[Prior Art] Conventionally, for example, in a POS system or the like, a system is known in which the sales of each product sold in a day are totaled by time zone and printed out.

[Problems to be Solved by the Invention] Among the products for sale, perishable products such as meat and fish that are sold by weight are often sold in bags in advance. To do this, it is necessary to know in advance the quantity according to sales and give processing instructions.

Also, freshness is important for perishable products, so if sales vary depending on the time of day, for example, it is necessary to arrange products on store shelves accordingly. If this is done incorrectly, problems may occur, such as overselling products during periods when sales are slow, resulting in a large number of products remaining until subsequent periods, resulting in loss of freshness.

However, since conventional POS systems simply aggregate sales by time of day, there is a problem in that accurate sales forecasts cannot be made for products whose sales by time of day change depending on the day of the week. Additionally, since the data was compiled for only one day, there was a problem with the lack of accuracy in data for measuring sales. For this reason, there was a problem in that accurate processing instructions could not be given according to sales by time zone.

Therefore, the present invention makes it possible to create an alarm list by accurately tallying the actual sales numbers of back-sold products by weight and time for each day of the week, thereby making it possible to give accurate processing instructions according to sales by time. The purpose of this project is to provide a sales forecast alarm system.

[Means for solving the problems] As shown in FIG. A time zone sales record memory b that stores the time zone sales results for each day of the week for weighed products, and a time zone memory a and time zone sales record memory b for the corresponding day of the week. a data updating means C which calculates a new actual sales number by time zone from the actual sales number by time zone, and updates the contents of the actual sales number data by time zone on the corresponding day of the week in the sales record memory b by time zone; A printer d is provided for printing out the contents stored in the band-specific sales performance memory b to create an alarm list.

[Function] In the present invention having such a configuration, the time zone memory a
1; Store the number of sales of each weighed product in one day by time zone. Then, the data updating means C stores the actual sales numbers by time slot on the corresponding day of the week in the time slot sales record memory b that stores the sales record numbers by time slot for each day of the week, and the sales numbers by time slot in the time slot memory a. A new number of sales results for each time period is determined from the data, and the contents of the sales result memory b for each time period are updated accordingly. For example, add the actual number of sales by time on the corresponding day of the week and the number of sales by time in time zone memory a for each time zone, and divide by 2 to calculate the new average number of sales by time. Band sales record memory b
Update the contents of.

Then, the printer d prints out the number of sales results by time zone for each day of the week stored in the sales record memory b by time zone to create an alarm list for processing instructions by time zone.

[Example code] Embodiments of the present invention will be described below with reference to the drawings.

Fig. 2 is a block diagram showing the configuration, where 11 is a microprocessor that constitutes the main body of the control unit, 12 is a perishable product mask in which the product name and code of perishable products as sold by weight are set, and 13 is an analysis period and data. 14 is a perishables management mask storing various data for managing weights to be applied to items, etc.; 14 is a perishables priority single item file in which memory for each time period and sales performance memory for each time period are provided for predetermined priority perishable products; 15; Reference numeral 16 indicates a daily perishable product record file that manages daily sales data of perishable products, 16 indicates a holiday record memory that stores sales data of perishable products on holidays, and 17 indicates a special sale record memory that stores sales data of perishable products on special sale days. ,1
8 is a special sale setting memory in which fresh products to be sold on sale and their period are set.

The microprocessor 11 and each master 12, 13, each file 14, 15 and each memory 1617, 18 are connected via a path line 19.

Further, 20 is a host interface connected to a host computer, 21 is a CRT controller that controls a CRT display 22, 23 is a printer controller that controls a printer 24, and 25 controls data transmission and reception with an externally connected weighing label issuing device 26. This is a transmitting/receiving controller.

The microprocessor 11, the interface 20, and each controller 21, 23, 25 are connected via a path line 27.

As shown in FIG. 3, the perishable product master 12 contains the product code, product name for PO8 (for receipts), and product name for data station (CR
It is also used for the T display and the weighing label issuing device 26. ),
Processing code that distinguishes processing light, average unit price of 1 pack, 1
A product setting memory 28 is provided in which the average weight of the bag, single item code, group code, event flag set when an event such as a special sale is held, unit price per unit weight, tare weight/quantity, valid days, processing date, etc. There is. Further, a predicted sales memory 29 for this week, a predicted sales memory 30 for next week, and a basic memory 31 are provided for each fresh product. Each memory 29, 30, and 31 has areas (1) to (7) for storing the maintenance flag, number of units sold, average weight per bag, and average unit price per bag for exactly one week. There is.

That is, the perishable product master 12 includes a product setting memory 28, this week's expected sales memory 29, next week's expected sales memory 30, and a basic memory 3 for each perishable product to be backsold.
1 is provided as a set.

As shown in FIG. 4, the perishable date record file 15 includes, for each perishable product, the product code, date (year, month, day), single item code, event flag, planned processing back count, and planned sales back. Quantity and average unit price, number of back pieces, total amount, and total weight for actual processing, number of back pieces, total amount, and total weight for actual sales, number of back pieces, total amount, and total weight for actual luminosity, number of back pieces, total amount, and total amount for actual disposal. A memory 32 for storing total weight and days of the week is provided, for example, for five weeks (35 days).

As shown in FIG. 5, the fresh priority single item file 14 is set with product codes, single item codes, event flags, days of the week, etc., and the day is divided into time periods (1) to (12), for example, and each time period is set. Update flags, number of processes, number of sales,
Time zone memory 33 with an area for storing sales amount
, (1) to (12) for each day of the week from Monday to Sunday
A time zone sales record memory 34 that stores the number of sales results for each time zone until A sales record memory 35 for each event time zone is provided corresponding to a predetermined priority product, which stores the number of sales records.

The microprocessor updates the perishable date record file 15 every time it receives daily sales data for each perishable product from the host computer via the interface 20. This update clears the oldest data from 36 days ago and stores the received data as the newest data. Note that the host computer is configured to aggregate sales data from a plurality of PO8 terminals.

In addition, the microprocessor receives data from the host computer via the interface 20, such as the number of processed items, the number of sales (number of items sold), and the sales amount of each priority fresh product for each time period of the day, for example, for each time period. Upon reception, the time zone area of the time zone memory 33 is updated.

(1) to (12) for the time zone memory 33
) is completed, the number of sales results for each time period of the corresponding day of the week is read out from the time period sales performance memory 34 according to the day of the week of that day, and the number of sales results for each time period of the time period memory 33 is read out. Add the sales numbers in each area for each time zone, divide it by 2 to find a new average, and use it as the new time zone sales record number on the corresponding day of the week in the time zone sales record memory 34. The information is stored in separate areas for each time period.

Further, when there is an event such as a special sale, when the time zone areas (1) to (12) in the time zone memory 33 are updated, the corresponding event time zone sales record memory 35 is updated according to the day of the week. Read the actual number of sold items for each time zone on the day of the week, add the number of sold items for each time zone area of the time zone memory 33 for each time zone, and divide it by 2 to find a new average, This is stored as a new number of sales results for each time period in the time period area of the time period sales result memory 35 for the corresponding day of the week.

For example, if one week is defined as Monday to Sunday,
At the set time on Sunday night at the end of the week, the microprocessor 11 automatically creates a sales plan. This is done by first reading out the past five weeks' worth of data for each day of the week from the perishable day performance file 15 for each perishable product, and calculating the average sales quantity, average weight per pack, and average unit price per bag for each day of the week. The contents of the basic memory 31 are rewritten based on the contents. At this time, if it is set to apply weight to the data in the perishable date record file 15, the calculation will be based on the weighted data.

Then, the contents of next week's expected sales memory 30 are transferred to this week's expected sales memory 29, and the contents of next week's expected sales memory 30 are rewritten based on the contents of the basic memory 31.

Next, the microprocessor 11 checks whether a special sale for the perishable product is set in the special sale setting memory 18 from this week to next week.

If a sale is set, the data for the corresponding day of the week in this week's and next week's expected sales memory 29.30 is rewritten based on the past sale record data for the perishable product stored in the sale record memory 17. .

In this way, when a special sale is held on a certain perishable product, the expected number of items to be sold is calculated based on past sale results rather than data on past days of the week.

The microprocessor 11 also checks whether there is a holiday next week. If there is a holiday, the data on the day of the week corresponding to the holiday in the next week's expected sales memory 30 is rewritten based on the sales performance data for the relevant perishable product on past holidays stored in the holiday performance memory 16.

In this way, when there is a holiday, the expected number of sales is calculated based on the sales performance of the past holiday rather than data on the past day of the week.

Furthermore, the microprocessor 11 controls the printer controller 23 for each day of the week stored in the time zone sales record memory 34 and the event time zone sales record memory 35 for each priority fresh product in the fresh priority single item file 14. The actual number of sales by time zone is printed out using the printer 24 to issue an alarm list.

In this embodiment having such a configuration, the time zone memory 33 stores the number of processed items, the number of sold items, and the sales amount for each time zone of the day. When the number of processed items, the number of sold items, and the sales amount for each time period of the day have been updated in the time period memory 33, the sales results for each time period on the day of the week corresponding to the day of the week are stored in the time period sales performance memory 34. Read out the number of items, and record the actual sales number for each time period and memory 33 for each time period.
The number of sold items for each time period is added for each time period, and the result is divided by 2 to obtain a new averaged number of sold items for each time period. Then, the time slot area of the corresponding day of the week in the time slot sales performance memory 34 is updated with the obtained number of sales results for each time slot.

In this way, the past averaged sales results for each day of the week and each time period are stored in the time period sales performance memory 34.

Therefore, by printing out the contents stored in the time zone sales performance memory 34 using the printer 24 and creating an alarm list, it is possible to accurately know the number of time zone sales results for each priority perishable product on each day of the week.

Therefore, by making a sales forecast for each time of the day based on this alarm list and instructing the processing of perishable products accordingly, it becomes possible to instruct the processing of quantities according to the sales for each time of the day. Moreover, since this alarm list shows the number of actual sales by time zone for each day of the week, processing instructions can be given according to the sales for each day of the week, making it possible to give more accurate processing instructions. In other words, if a certain perishable product sells well during a certain time on a certain day of the week, processing instructions can be given accordingly, and there is no risk of running out or having too much of the product.

In addition, by printing out the contents stored in the event time zone sales performance memory 35 using the printer 24 and creating an alarm list, it is possible to grasp the sales of a certain perishable product by time zone on a day when a special sale is held. Accurate machining instructions can be given even in cases where

[Effects of the Invention] As described in detail above, according to the present invention, an alarm list can be created by accurately tallying the actual sales numbers of back-sold products by weight for each day of the week and time period. It is possible to provide a sales prediction alarm system that enables accurate processing instructions according to the separately sold items.

[Brief explanation of the drawing]

Fig. 1 is a functional block diagram showing the configuration of the present invention, Figs. 2 to 5 show implementation sequences of the present invention, Fig. 2 is a block diagram, and Fig. 3 is a main memory of the perishable product mask. FIG. 4 is a diagram showing the configuration of daily performance data of the perishable daily performance file, and FIG. 5 is a diagram showing the main memory configuration of the perishable priority single item file. DESCRIPTION OF SYMBOLS 11... Microprocessor, 14... Fresh food priority single item file, 24... Printer, 33... Memory by time zone, 34... Sales record memory by time zone. Applicant's agent Patent attorney Takehiko Suzue

Claims (1)

[Claims] A time zone memory that stores the number of units sold by time zone for at least one day of a plurality of measured products sold in packs, and a time zone sales memory that stores the actual sales number of each metered product sold by time zone on each day of the week. A new actual sales number for each time period is calculated from the actual sales results memory, the sales number for each time period in the time period memory, and the sales result number for each time period on the corresponding day of the week in the time period sales result memory, and a data updating means for updating the contents of the sales record number data by time zone on the corresponding day of the week in a separate sales record memory; and a printer for creating an alarm list by printing out the contents stored in the sales record memory by time zone. A sales forecast alarm system characterized by providing.