JP2006040002A - Sales management system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a sales management system automatically using information related to each delivery area designated on a display part of a personal computer as data on sales information for calculating a distribution charge. <P>SOLUTION: This sales management system is performed on the general personal computer (PC) having the display part, a central arithmetic processing part, a storage part, and an input part, and a program for executing the sales management system is installed on the PC. The sales system is used when a newspaper delivery station of each the area distributes inserts, for example, and the suitable program is constructed according to a demand of each the newspaper delivery station. Various kinds of information input when operating the sales management system are stored in the storage part, and various kinds of computing on the sales management system are performed by the central arithmetic processing part. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a sales management system for insert advertisements distributed along with newspapers, and more particularly to a sales management system that enables efficient work when distributing insert advertisements.

Folded advertisements that are attached to newspapers are distributed in detail according to the contents of the advertisement, the size of the advertiser, the time of advertisement, and the like.
Conventionally, when considering the distribution destination of insert advertisements, use the electronic map displayed on the computer screen for the number of advertisements created by the advertiser, for example by specifying the area divided into blocks Thus, after determining the distribution area and specifying the number of distributions, the distribution destination list is created by printing the information.
Based on the distribution destination list, the distribution fee is calculated by inputting each distribution area and the number of distributions on another computer.

  However, according to the above-described system, after the distribution destination is determined on one computer, it is necessary to input the distribution destination data to the other computer again as data for performing sales management such as calculation of distribution fees. There is a problem that it is troublesome and cumbersome.

  The present invention has been made in view of the above circumstances, and an object of the present invention is to provide a sales management system capable of improving the efficiency of the paperwork when distributing an insert advertisement.

To achieve the above object, the present invention (Claim 1) is a sales management system performed on a personal computer including a display unit, a central processing unit, and a storage unit, and includes the following configuration. .
An electronic map for dividing the map displayed on the display unit into blocks corresponding to each distribution area and designating each block by changing the display color of the block and determining the distribution area;
A distribution district table that is displayed on the display unit, displays a plurality of distribution addresses corresponding to each block, and changes the display color of the distribution address portion by specifying each distribution address to determine the distribution area. When,
Either of these can be selectively displayed.
By specifying the distribution area on the electronic map or the distribution area of the distribution district table, the other distribution designation is performed.
A distribution number corresponding to the distribution area is set in the storage unit in advance, and the central processing unit calculates a total distribution number by designating a plurality of distribution areas, and calculates a distribution fee.

  In the sales management system according to claim 1, in the distribution management system according to claim 1, when specifying the distribution area on the electronic map or in the distribution area table as the adjustment area not distributed to all contracted households, the distribution area is specified. The display color can be distinguished from the above.

  Claim 3 is the sales management system according to claim 1, wherein a correction coefficient is set for each distribution area on the electronic map or in the distribution area table, and the distribution fee is calculated in consideration of the correction coefficient. It is characterized by doing.

  According to the present invention, the information on each delivery area designated on the display unit of the personal computer is automatically used as sales information data for calculating the distribution fee. It is not necessary to input data again, and the efficiency of paperwork can be improved.

  The sales management system according to the present invention is performed on a general personal computer (PC) having a display unit, a central processing unit, a storage unit, and an input unit, and a program for executing the sales management system is provided. Installed on the PC. This sales system is used, for example, when a newspaper delivery office in each region distributes an insertion advertisement, and constructs a program suitable for the demand of each newspaper sales office. Various information input when operating the sales management system is stored in the storage unit, and various calculations on the sales management system are performed by the central processing unit.

This sales management system is configured to display an order screen 10, a region selection screen (electronic map 20, distribution region table 30), and a sales management screen 40 on the display unit.
As shown in FIG. 1, the order receiving screen 10 includes an advertisement number input window 12 for inputting the number of advertisements and an advertisement for inputting an expected date of advertisement in addition to the bibliographic item window 11 for inputting the name and name of the advertiser. A scheduled date window 13 is formed, and the input number and date are stored in the storage unit of the PC. A history window 14 for searching for past advertisement history is also formed. The contents of the advertisement history will be described later.

  The region selection screen has a function of displaying the electronic map 20 or the distribution district table 30 on the display unit. The electronic map 20 stores, for example, map data that a newspaper sales office designates as a distribution target area (territory). As shown in FIG. 2, the electronic map 20 includes cells 21 having an arbitrary shape (a shape partitioned by black lines) in block units obtained by subdividing the distribution target area in the display unit. Each cell 21 can be designated by clicking the cursor at. Each block (cell 21) is divided into units in which newspapers can be easily distributed, for example, an area along the road is grouped as one unit. Then, by designating each cell (each block) 21, the display color of the block changes on the display unit (for example, from white to red), so that it is possible to confirm that the distribution area has been determined. Yes. Each cell 21 is given a name as a distribution area name, and this name is displayed as a distribution area name 22 in each cell 21 on the map.

  Within each distribution area, the number of households (contracted households) that have signed a newspaper distribution contract with a newspaper sales office is entered in advance when the program is constructed, and stored in the storage unit corresponding to the distribution area. This number is displayed as the number of contracted households 23 in each cell 21 on the map. Further, since the number of contracted households 23 fluctuates due to the occurrence or cancellation of a new contract, it can be changed by re-input as necessary.

  An operation screen 24 is displayed on the right side of the electronic map 20. The operation screen 24 includes an enlargement button 25 for enlarging the map screen, a reduction button 26 for reducing, and a scroll button 27 composed of arrows for scrolling up, down, left and right.

  The distribution area table 30 displays data of a plurality of area names (distribution area names 22) in a range corresponding to the electronic map 20. That is, as shown in FIG. 3, for a regional cell 31 obtained by dividing a distribution target area of a newspaper sales office into a plurality (for example, east, west, north, and south), a distribution region name 22 corresponding to each block included in the regional cell 31 The number of contracted households 23 described above is displayed in the lower column of the area cell 31 and to the right of the distribution area name 22 in FIG. Then, the distribution area is designated by clicking the cursor at the position of the distribution area name 22 on the display unit, and the display area of the distribution area name 22 is changed to determine the distribution area.

  In this example, an area obtained by dividing a distribution target area into a plurality of areas (for example, east, west, south, and north) is used as the area cell 31. However, one newspaper sales office uses a plurality of types of newspapers (A newspaper, B newspaper, C sports newspaper, etc.). In the case of handling, a distribution area table 30 may be created in which the area cell 31 corresponds to the type of newspaper (in this case, the area cell 31 displays the type of newspaper).

On each screen of the electronic map 20 and the distribution area table 30, a "distribution area table" and a "map" switching window 28 are displayed, and the electronic map 20 or the distribution area table 30 can be selectively selected by clicking the switching window 28. Can be displayed.
Further, in each screen of the electronic map 20 and the distribution area table 30, an advertisement number display window 32 for displaying the number of advertisements input on the order receiving screen 10, and the total number of contracted households in each distribution area by specifying the distribution area are shown. A total distribution number display window 33 to be displayed and a remaining number display window 34 to display the remaining number obtained by subtracting the total distribution number from the advertisement number are respectively formed. When the total number of distributions is larger than the number of advertisements, the remaining number display window 34 is displayed as a minus (−) display.

  In addition, in the designation of the distribution area in the electronic map 20 or the distribution area table 30, for example, the distribution area can be selected as the adjustment area by performing an operation different from the normal designation method such as clicking while pressing the shift key. Yes, the cell 21 (FIG. 2) or the distribution area name (FIG. 3) corresponding to the adjustment area is set so that the display color of the distribution area in the electronic map 20 and the distribution area table 30 is different from the case of normal designation. . This is because the adjustment area of the number of advertisements can be grasped at a glance.

  In the area selection screen, when the distribution area (cell 21) on the electronic map 20 is specified, the distribution area (distribution area name 22) in the distribution area table 30 corresponding to this is automatically specified. If the distribution area (distribution area name 22) in the distribution area table 30 is specified, the distribution area (cell 21) on the electronic map 20 corresponding to this is automatically specified. It is linked so that the other distribution designation is performed.

  A pattern designation window 35 is provided at the top of the screen of the electronic map 20 or the distribution area table 30 that is the area selection screen. When this pattern designation window 35 is clicked, a selection window 350 on which several types of patterns in which a plurality of distribution areas are designated in advance is displayed. In each pattern, for example, a distribution area where there are many elderly residents, a distribution area where there are many single persons, a distribution area where there are many detached houses, etc. are selected and set in advance. By selecting one of the patterns, the distribution area table 30 (electronic map 20) in which the pattern has already been specified can be displayed. If the pattern designation window 35 is used, a plurality of distribution areas can be selected without individually selecting a distribution area (cell 21 or distribution area name 22).

  An end window 36 is provided in the electronic map 20 and the distribution area table 30 which are area selection screens. By clicking the end window 36 on the screen, the sales management screen of FIG. 4 is opened. On the sales management screen 40, various information (advertisement date 41, address and name 42, number of advertisements 43) input on the order screen 10 is displayed, and a distribution fee corresponding to the number of advertisements is displayed in the distribution fee window 44. Usually, the distribution fee is the value obtained by multiplying the number of advertisements by the unit price per piece. However, if there is a difference in work effort depending on the distribution area (for some reason, it is difficult to distribute), the distribution area It is also possible to store the correction coefficient in advance for each distribution area and display the entire distribution fee as a calculation result in consideration of the correction coefficient for each distribution area.

  Further, the “designation of distribution area” information performed on the area selection screen is accumulated as history data that can be searched by the scheduled date of advertisement for each client, and when the history window 140 on the order screen 10 described above is clicked, the history information window is displayed. 140 is opened, data is displayed for each scheduled advertisement date, and the same area selection screen (electronic map 20 and distribution area table 30) as specified in the past is displayed on the screen by clicking the scheduled advertisement date on the screen. Can do.

Next, how to use the above-described sales management system will be described.
This sales management system is used in a newspaper sales office that distributes newspapers or a folding center that manages the distribution of inserted advertisements. The sales system can be used at newspaper sales offices (local districts) or insert centers (local districts) depending on the regional scope of electronic map and district data registration. An example of use at a newspaper sales office will be described. When a client of an insertion advertisement wants to distribute 3000 copies of an insertion advertisement created by himself, first, the address and name of the client on the order receiving screen 10 displayed on the display. Enter the number of advertisements (in this case, 3000).

  Subsequently, the distribution area table 30 as an area selection screen is displayed on the display, and the distribution area name 22 is selected. Since the display color of the selected distribution area name 22 changes, the selected distribution area can be confirmed. At this time, in the upper part of the screen, the number of advertisements (advertisement number display window 32), the total number of distributions specified by the distribution area (total distribution number display window 33), and the remaining number obtained by subtracting the total number of distributions from the number of advertisements (remaining number display) Since each of the windows 34) is displayed, it is possible to grasp the designated situation of the distribution area with respect to the created number of advertisements. When selecting the distribution area, the number of advertisements is displayed to the right of the distribution area name 22 portion, and the number of contracted households 23 is displayed, so it is possible to consider which area should be distributed according to the remaining number.

  In the area selection screen, the designation of the distribution area in the distribution area table 30 and the designation of the distribution area on the electronic map 20 are linked to each other. The distribution area can be selected by switching to the electronic map 20 by clicking on the switching window 28.

If the pattern designation window 35 is clicked and pattern designation is selected, a pre-registered distribution area pattern can be immediately selected. When there is a gap between the number of advertisements and the total number of distributions, the distribution area may be designated or canceled on the electronic map 20 or the distribution area table 30 and then corrected.
Further, if history information is selected by clicking the history window 14 from the order receiving screen 10, a distribution area pattern performed in the past can be immediately called and selected.

  If the number of advertisements does not match the total number of distributions, or if there is a remaining number of sheets, it can be dealt with by selecting the distribution area as the adjustment area. In this case, since the display color of the distribution area (adjustment area) in the electronic map 20 and the distribution area table 30 is different from the normal designation, the adjustment area can be recognized at a glance.

  By clicking the end window 36 on the screen of the electronic map 20 or the distribution area table 30 that is the area selection screen, the screen is moved to the sales management screen 40 of FIG. In the sales management screen 40, the number of advertisements input on the order screen 10 is displayed, and a distribution fee corresponding to the number of advertisements is displayed in the distribution fee window 44, so that the requester can immediately confirm the estimate for the selected distribution area. .

It is explanatory drawing which shows the order receipt screen in the sales management system of this invention. It is explanatory drawing which shows the electronic map which is an area selection screen in the sales management system of this invention. (A) is explanatory drawing which shows the distribution area table | surface which is an area selection screen in the sales management system of this invention, (b) is explanatory drawing of a pattern designation | designated screen. It is explanatory drawing which shows the sales management screen in the sales management system of this invention. It is explanatory drawing of a log | history information screen.

Explanation of symbols

DESCRIPTION OF SYMBOLS 10 Order screen 12 Advertisement number input window 13 Advertisement scheduled date input window 14 History window 20 Electronic map 21 cell 22 Distribution area name 23 Number of contracted households 24 Operation screen 28 Switching window 30 Distribution area table 31 Area cell 32 Advertisement number display window 33 Total Distribution number display window 34 Remaining number display window 35 Pattern designation window 36 End window 40 Sales management screen 44 Distribution fee window

Claims (3)

A sales management system on a personal computer having a display unit, a central processing unit, and a storage unit,
An electronic map for dividing the map displayed on the display unit into blocks corresponding to each distribution area and designating each block by changing the display color of the block and determining the distribution area;
A distribution district table that is displayed on the display unit, displays a plurality of distribution addresses corresponding to each block, and changes the display color of the distribution address portion by specifying each distribution address to determine the distribution area. When,
Can be selectively displayed,
While specifying the distribution area on the electronic map or specifying the distribution area of the distribution district table, the other distribution specification is linked,
In the storage unit, preset the number of contracted households corresponding to the distribution area,
A sales management system, wherein the central processing unit calculates a total distribution number by designating a plurality of distribution areas and calculates a distribution fee. The sales according to claim 1, wherein when specifying the distribution area on the electronic map or in the distribution area table as an adjustment area not distributed to all contracted households, the display color is distinguishable from the distribution area specification. Management system. The sales management system according to claim 1, wherein a correction coefficient is set for each distribution area on the electronic map or in the distribution district table, and a distribution fee is calculated in consideration of the correction coefficient.

Images