JPS60198697A - Sale report generator - 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 The present invention relates to a packaging system for sales revo-1 which is used for selling products in supermarkets, department stores, etc.

For companies that handle products such as Super Marketera 1,
Knowing the sales status of products, such as sales figures, sales trends, and profits, is an essential condition for conducting sales management such as optimizing product assortments, special sales, analyzing the effects of selling price changes, and analyzing productivity.
Knowing the sales status; the format in which the resale report is compiled is important for improving management efficiency and determining the correct management policy.

In view of the circumstances of refusal, the present invention connects a label printer and an electronic register to a computer (central processing unit) to perform online processing, display product purchase amount and sales data together with forecast data and comparison data, and display the same. See “
The purpose is to provide reports that are easy to manage and easy to use by organizing them into display columns that are easy to analyze.

The device of the present invention has a human power section, a display section, and a central processing unit (
A main body with a CPU)! One or more label printers and electronic registers are connected to the unit, and the printers and registers transmit the required data to the central processing unit in a timely manner, and the central processing unit receives the required data and the input unit. The following display fields are processed based on the data: ■
Title side that displays the level of sales data, ■ Specification field that displays level name, day 4 = J, sales period, etc. ■ Displays the actual values of purchase n1 sales^ and gross profit in the sales period along with the predicted values For display and/or printing, including: ■ Weekly upper column that displays sales data for each day of the week, ■ Annual sales column that displays sales data in comparison with the previous year's sales for each required period It is characterized by having a 1” format.

To explain an embodiment of the present invention with reference to the drawings, FIG. 1 shows a system block diagram of the apparatus of the present invention, where (A> is a main unit, a computer (a) having a built-in central processing unit (CPU), an input It consists of a display section (b) and a printer (0), and the computer (a) has a memory disk (dl
) (d2), and its disk (d2) is for backup.

Main unit [(Δ) is line control equipment L! (LCU) to connect one or more weighing labelers (1), (2) barcode printers (3)... (32 units can be connected in the J3 example), and one or more electronic register(
ECR) (4)... (1 in the example)
(6 units can be connected).

In addition, a backup power supply (5) is connected to the main unit (A) and the line control unit (LCU).

This power supply (5) operates when the AC power goes down to protect the stored contents of the specified memory.
It is being charged by the C power source.

fit ffl labeler (1) (2) is used to price (label) purchased products, and for each priced product, it records the product name, code number, date, unit price, 100 million price,
Necessary data such as the number of pieces is stored in the line control unit (LCU).

The barcode printer (3) also issues and affixes labels on purchased products that display necessary data such as C1's product code and price in the form of a barcode. be remembered.

Therefore, "C, line control device ffi<LCLJ) d4.t,
aIW labeler (1) (2), barcode printer (3)
) is stored, and when there is an output command from the main unit bTi(A), the central processing unit f! The data is output to (CPU).

The electronic register (4) is installed at the sales floor counter, and reads or inputs necessary data such as the product name, code number, price, etc. for the products being sold. The collection data of the sales products handled at each register (4) is stored in the line control unit (LCU) for each required data, and the main unit 1
When there is an output command from ft(A), the central processing unit (
CPU).

Body packaging! The input display section (b) of (A) consists of an input section (bl) having a numeric keypad and function keys, and a display section (b2), and the input section (bl) can be used to input purchasing data other than the above purchasing data. Input the data, for example, the data of purchased products whose value has been reduced by 1 using a hand labeler,
Alternatively, it is also possible to input calculation data such as previous year's sales data or constants for estimating predicted values.

The central processing unit (CPU) is ■1 labeler (1) (2)
, purchase data input from the barcode printer (3), data input from the input section (bl), and register (
4) Perform processing to memorize and hold the sales data input from . . . and screen out each item of the display and print format (10) based on the data.

The above format (10) is the memory disk (dl).
) (d2), an example of which is shown in FIG. 2 and consists of display columns (11) to (16).

(11) is a title column that displays the level of sales data, and displays level distinctions such as total sales for the entire store, sales by department, sales by main group, and sales by group.

In (12), there is a designation column e, and the formal name of the level (for example, 1-store name for the total sales level, 1- for the departmental level)
"Food", "Confectionery" at the main group level, [Cho-lu-1 to-1, etc.] designation item (121) at the 4-knob group level, Japanese-Il designation 341 (122),
This is the sales period specification gj (123).

The above sales period is a 7J style in which the year is divided into 4 periods every 3 months from January to March, 4th, June, July to September, and 0 to December, and 1 year is 4 weeks. 131! There are 6 methods that divide the IJ into 12 periods, or 1 year divided into 12 periods every 1 month.

The above designation item (123) consists of a first term part indicating the divided period, a month part indicating the number of months, a week part indicating the number of times, and a part indicating the day of the week.

(13) is the sales amount display column, which includes a purchase amount item (131) that shows the purchase amount, 1 sales amount item (132) that shows the sales amount, a gross profit item (133) that shows the gross profit rate, and the number of customers. Item (134),
It consists of the customer unit price term (135), the number of sales term (136), the average unit price term (137), and the above term (131) (
132) and (133) each have a predicted value display section (131).
a> (132a) (133a> and actual km (+TJ
The display parts (131b), (132b), and (133b) are provided so as to be displayed in two upper and lower stages.

Now, if you plan to purchase N units of a certain product at unit price PI and sell it at selling price P2, the predicted purchase amount is P=P+
XN (yen) Forecast sales P' = P2XN (yen) Forecast pre-interest rate Q=
The fraud processing is performed as (P'-P)/P', (%).

In addition, the actual purchase n, P- is the above H1-m labeler (1) (
2) Performance processing (P+XN':
N' is the actual number of units sold), the actual sales amount, and P-'' is based on the sales data sent from the register (4)... 2' is the actual selling price, N is the actual number of units sold), the actual interest rate is Q
- is processed by (P'-1))/几'.

The top purchase amount, sales amount and rough interest rate are specified at the beginning of each period during the sales period and are displayed after processing the cumulative amount up to this day. Ru.

J3, The above predicted value indicates the case where the actually purchased product is sold at a fixed price, whereas the actual value indicates the case where the product is actually sold.
It shows the rental amount, sales A3, and gross profit margin.

However, the predicted value J3 and the actual I! Meaning 1) of I ship is arbitrary, and it is now J! based on past sales data as a predicted value. Of course, it is possible to predict the 13 purchasing fields, sales^, and gross profit margin, and display the corresponding actual values. In this case, those predicted values are determined by a predetermined prediction constant that refers to past sales data (for example, rather than simply dividing the monthly forecast into three equal parts, the 3l months are divided into 1:2:1). Or, for the monthly forecast value, select forecast 1 = 0.8:
It is also optional to calculate by multiplying the ratio of 0.8:2.

The number of customers term (134) displays the real number of customers entered in the register (4)..., and the customer unit price term (135) shows the operation (actual hole - L'B+)'/real number of customers). Displayed through pruning processing, the sales number field (136) displays the actual value of the sold products, and the average 11111i field (137) shows the actual sales HP'
/ number of sales).

(14) is the weekly light upper column, which displays the sales amount by day of the week in one week (Monday to Sunday) including the specified date of 111.

Weekly sales l1l (14) is divided into days of the week such as "Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday."

(15) is annual sales -, and this year's sales item (151)
and previous year sales section (152), and each sales section (151)
In (152), each month is divided so that the sales amount is displayed for each month from January to December.

(16) has other information columns, such as the total weekly sales (161) and the total inventory for 31i1 (1
62), the average term (1
63), the average term of the weekly inventory quantity in the specified period (164
), 1 inventory term (16!i) indicating the past weekly inventory count
It also includes out-of-stock items (16G) based on the number of out-of-stock items at FJ this month, this year, and the previous year. The above format (10) may be arbitrary, such as being indicated by the M1 character of a foreign country such as English, in addition to being indicated by the M1 character as in the embodiment.

111i main unit i/((△) displays display part (b2)
An example of REVO-1 (R) (image) created on the screen is shown in FIG.

Revo-1-(R) achieved total store sales of 31,122 in 1959.
1 (1 is the first period in which the year is divided into 4 periods of 3 months, and the 11th Thursday of the 13th week counting from January) The corresponding field is specified (
12) You can know more about weekly sales III (14)
If the sales amount for Wednesday is blank, it means that the corresponding day is a holiday.

In addition, if the title (11) is "total sales by department", [total sales by main group], or "total sales by subgroup", the title m (11) and designation II (12) are shown in Figure 4. 5
6, the department ``12'' in the figure represents the ``food department'', the main group ``345'' represents the ``confectionery'', and the Zabu group ``6789J'' represents the ``Duccolate''.

The report (R) created on the display section (112) can be issued by printing the same data on the printer (C) by operating the function: V- of the input section (bl).

In the above embodiment, the line control device (Lf) is connected to the label printer and the electronic register directly to the main unit.
(LCU). This allows the line control device to control the label printer and electronic register and store predetermined data, thereby reducing the burden on the main device and making effective use of its solid wood structure. This is because it was intended. However, the present invention is not limited to this, and for example, the central processing unit (CPU) of the main body device is equipped with a label printer J3.
It is also conceivable that electronic registers are directly connected and these are directly controlled by the central processing unit of the main unit.

Since the present invention is configured as described above, purchase and sales data is transmitted from the label printer and electronic register to the main unit, and sales management is carried out based on these data and the data sent to the human resources department. Management information is displayed on the predetermined A-Matsu 1-'c display section, and a revolution report is created.
During Rebo-1~, actual purchasing and sales data is displayed along with predicted values, sales n for each day of the week is displayed, and this year's sales are displayed together with the previous year's sales for each III hi. Ru.

(Revo-1 that can accurately grasp and analyze the sales situation)
・Providing an effective report creation device for sales management and business management, it is possible to achieve the intended purpose of 1!11.

[Brief explanation of drawings]

Figure 1 is a system block diagram of the device of the present invention, Figure 2 is a front view of the format, Figure 3 is a front view illustrating the created REVO-1, and Figures 4 to 6 are reports. FIG. 7 is a front view showing a modified example of the title style and designation field. In the figure, (A> is the main unit, (a) is the central processing unit (C
PU), (bl) is the input section, (b2
) is the display unit, (1) (2) is the total M labeler, (3) is the barcode printer, (4) is the electronic register, (Hl) is the format 1~, (11) is the title -, ( 12) is the designated field, (13) is the sales amount display field, (14) is the weekly sales field, (
15) is the annual sales column, and (R) is the report. Figure 1 Figure 4 Figure 5 Figure 6

Claims (1)

[Claims] One or more label printers and electronic registers are connected to an uninterrupted device that includes an input section, a display section, and a central processing unit (CPLI), and necessary data is transmitted from the printers and registers to a central processing unit. will be sent to the MR, and the next display field to be displayed will be based on the processing required data and the data entered in the human resources department.
Title column that displays the level of sales data, ■ Name of level, day (=l, specification for displaying sales period, etc. 11■, ■ Actual values of purchases, sales, and gross profit in the sales period are predicted values) A display that includes a sales display column that is displayed together with ■ a weekly sales column that displays sales data for each day of the week; and ■ an annual sales table that displays sales data in comparison with the previous year's sales for each predetermined period; and/or A sales report creation device characterized by being equipped with an A-mat for printing.