JP3045654U - Comprehensive product evaluation analysis table by computer - Google Patents
Comprehensive product evaluation analysis table by computerInfo
- Publication number
- JP3045654U JP3045654U JP1997004307U JP430797U JP3045654U JP 3045654 U JP3045654 U JP 3045654U JP 1997004307 U JP1997004307 U JP 1997004307U JP 430797 U JP430797 U JP 430797U JP 3045654 U JP3045654 U JP 3045654U
- Authority
- JP
- Japan
- Prior art keywords
- sales
- product
- products
- gross profit
- rank
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Expired - Lifetime
Links
Abstract
(57)【要約】
【目的】 随時必要な時、商品対策を行う為に必要な情
報を提供する。
【構成】 商品の売上情報、粗利益情報と総合評価ラン
クを含んだ分析表。
(57) [Summary] [Purpose] When necessary, provide the necessary information to take product countermeasures. [Structure] An analysis table that includes product sales information, gross profit information, and overall evaluation rank.
Description
【０００１】[0001]
商品の製造、販売を行う部門の商品対策資料。 Product countermeasure materials for the department that manufactures and sells products.
【０００２】[0002]
従来の売上高ＡＢＣ分析表は売上高の順位と割合に依りＡ，Ｂ、Ｃの３ランク に区分した表である。又粗利益ＡＢＣ分析表は粗利益の順位と割合に依りＡ，Ｂ 、Ｃの３ランクに区分した表であり売上高と粗利益の関連がわからない為本当に 対策が必要な特定商品とその対策方法が一覧で判別出来ない。 The conventional sales ABC analysis table is a table divided into three ranks of A, B, and C according to the rank and ratio of sales. The gross profit ABC analysis table is a table divided into three ranks of A, B, and C according to the rank and ratio of gross profit, and it is not possible to know the relationship between sales and gross profit. Cannot be identified in the list.
【０００３】[0003]
コンピュータに依り商品売上高順位表と商品祖利益高順位表の両表マトリック スから特定範囲を抽出し、本当に対策が必要な売上高も利益も大きい商品と、売 上高は大きいが利益が小さい商品と、売上高は小さいが利益が大きい商品と、売 上高も利益も小さい商品の４グループとその他一般的な商品の１グループに分類 し商品対策が必要な４グループに対してＡ、Ｂ、Ｃ、Ｄのランク付けを行う。 これにより、各ランクの商品に対して適確な対策が行える。 A computer is used to extract a specific range from the matrix of both the product sales ranking table and the product profit ranking table, and those products that really need measures and have high sales and high profits, and those with high sales but low profits Products are classified into four groups: products with low sales but high profit, products with low sales and low profit, and one group of other general products. , C and D are ranked. As a result, appropriate measures can be taken for products of each rank.
【０００４】[0004]
（イ）コンピュータで商品別売上高を集計後、売上高の大きい順に上位グループ をＡランク、中位グループをＢランク、下位グループをＣランクとする。 （ロ）コンピュータで商品別粗利益を集計後、粗利益の大きい順に上位グループ をＡランク、中位グループをＢランク、下位グループをＣランクとする。 （ハ）売上高がＡランクでかつ粗利益がＡランクの商品は総合評価を“Ａ”とす る。 （ニ）売上高がＣランクでかつ粗利益がＡランクの商品は総合評価を“Ｂ”とす る。 （ホ）売上高がＡランクでかつ粗利益がＣランクの商品は総合評価を“Ｃ”とす る。 （ヘ）売上高がＣランクでかつ粗利益がＣランクの商品は総合評価を“Ｄ”とす る。 これにより、商品の総合評価がランク付けされる。 (A) After summing up the sales by product using a computer, the upper group is ranked A, the middle group is ranked B, and the lower group is ranked C in descending order of sales. (B) After gross profit by product is tabulated by computer, the upper group is ranked A, the middle group is ranked B, and the lower group is ranked C in descending order of gross profit. (C) A product whose sales are rank A and whose gross profit is rank A is given an overall rating of "A". (D) For products with sales rank C and gross profit A rank, the overall evaluation is "B". (E) A product whose rank is A and whose gross profit is C is given a comprehensive rating of "C". (F) Products with sales rank C and gross profit rank C are given a comprehensive rating of "D". Thereby, the comprehensive evaluation of the products is ranked.
【０００５】[0005]
（イ）一定期間の売上明細より商品別に売上高を集計し商品別売上高ファイを作 成する。 （ロ）商品別売上高ファイルを売上高の大きい順に並びかえる。 （ハ）商品別売上高ファイルの上位グループをＡ、中位グループをＢ、下位グル ープをＣにランク付けした売上高ＡＢＣ分析ファイルを作成。 （ニ）一定期間の売上明細より商品別に粗利益を集計し商品別粗利益ファイルを 作成する。 （ホ）商品別粗利益ファイルを粗利益の大きい順に並びかえる。 （ヘ）商品別粗利益ファイルの上位グループをＡ、中位グループをＢ、下位グル ープをＣランク付けしたた粗利益ＡＢＣ分析ファイルを作成。 （ト）売上高ＡＢＣ分析ファイルと粗利益ＡＢＣ分析ファイルを入力し、各ファ イルのランクから、図２の商品の総合評価を求めるマトリツクス表に従い総合評 価のランク付けを行つた総合評価分析ファイルを作成する。 （チ）総合評価分析ファイルを総合評価のランク順に並びかえる。 （リ）総合評価分析ファイルの内容によつて、図１の商品総合評価分析表を印字 、又は表示する。 (B) Summarize the sales for each product from the sales details for a certain period to create a sales phi for each product. (B) Sort the sales files by product in descending order of sales. (C) Create a sales ABC analysis file that ranks the top group A, middle group B, and bottom group C of product-specific sales files. (D) Aggregate gross profit for each product from sales details for a certain period and create a gross profit file for each product. (E) Sort the gross profit files by product in descending order of gross profit. (F) Create a gross profit ABC analysis file that ranks the top group A, middle group B, and bottom group C in the gross profit file by product. (G) Input a sales ABC analysis file and a gross profit ABC analysis file, and rank the overall evaluation according to the matrix of the overall evaluation of the product shown in Fig. 2 based on the rank of each file. Create (H) Rearrange the comprehensive evaluation analysis files in the order of the overall evaluation rank. (I) The product comprehensive evaluation analysis table shown in Fig. 1 is printed or displayed according to the contents of the comprehensive evaluation analysis file.
【０００６】[0006]
何万点もある商品の中から対策を立てる必要がある特定商品がランク付けされ て表示されるので、誰でも随時早急に商品対策が立てられる。 Ａランクの商品は売上高も粗利益も大きい為、商品構成の中心に位置付けると ともにイメージアップ商品として育てる。 Ｂランクの商品は売上高は小さいが粗利益が大きい為、売筋商品とセット販売す るか広告宣伝の中心とする。 Ｃランクの商品は売上高は大きいが粗利益が小さい為、販売価格を上げるか原 価をさげる。 Ｄランクの商品は売上高も粗利益も小さい為、販売廃止商品として検討する。 以上の様に、従来のＡＢＣ分析表では出来なかつた具体的な商品対策が行える 。 Specific products for which measures need to be taken out of tens of thousands of items are ranked and displayed, so anyone can take action as soon as possible. A-ranked products have large sales and gross profits, so they will be positioned at the center of the product mix and nurtured as image enhancement products. Products of rank B have small sales but large gross profits, so they will be sold together with popular products or will be the center of advertising. C-ranked products have high sales but low gross profit, so raise sales prices or lower prices. D rank products are considered as discontinued products because their sales and gross profit are small. As described above, it is possible to take specific product measures that cannot be performed with the conventional ABC analysis table.
【図１】商品総合評価分析表[Fig. 1] Product comprehensive evaluation analysis table
【図２】商品の総合評価を求めるマトリツクス表[Figure 2] Matrix table for obtaining comprehensive evaluation of products
１ 総合評価のランク 1 Overall evaluation rank
Claims (1)
品粗利益高順位表の両表マトリックスから特定範囲を抽
出しＡ、Ｂ、Ｃ、Ｄのランク付けを行った商品総合評価
分析表。1. A comprehensive product evaluation analysis table in which a computer extracts a specific range from a matrix of both a product sales ranking table and a product gross profit high ranking table and ranks A, B, C, and D by a computer.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| JP1997004307U JP3045654U (en) | 1997-04-18 | 1997-04-18 | Comprehensive product evaluation analysis table by computer |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| JP1997004307U JP3045654U (en) | 1997-04-18 | 1997-04-18 | Comprehensive product evaluation analysis table by computer |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| JP3045654U true JP3045654U (en) | 1998-02-13 |
Family
ID=43180030
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| JP1997004307U Expired - Lifetime JP3045654U (en) | 1997-04-18 | 1997-04-18 | Comprehensive product evaluation analysis table by computer |
Country Status (1)
| Country | Link |
|---|---|
| JP (1) | JP3045654U (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2011238092A (en) * | 2010-05-12 | 2011-11-24 | Mitsubishi Electric Corp | Product price determination support device, product price determination support method and product price determination support program |
| JP2012120721A (en) * | 2010-12-09 | 2012-06-28 | Sun Corp | Prize management device |
| JP2016045693A (en) * | 2014-08-22 | 2016-04-04 | カシオ計算機株式会社 | Information processing device, menu determination method, and program |
-
1997
- 1997-04-18 JP JP1997004307U patent/JP3045654U/en not_active Expired - Lifetime
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2011238092A (en) * | 2010-05-12 | 2011-11-24 | Mitsubishi Electric Corp | Product price determination support device, product price determination support method and product price determination support program |
| JP2012120721A (en) * | 2010-12-09 | 2012-06-28 | Sun Corp | Prize management device |
| JP2016045693A (en) * | 2014-08-22 | 2016-04-04 | カシオ計算機株式会社 | Information processing device, menu determination method, and program |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Wind | A new procedure for concept evaluation | |
| Breen et al. | Class analysis and class theory | |
| Ramakrishnan | The competitive response of small, independent retailers to organized retail: Study in an emerging economy | |
| Tejada et al. | Applicability of global value chains analysis to tourism: issues of governance and upgrading | |
| Fearon | Historical evolution of the purchasing function | |
| Svensson | Efficient consumer response–its origin and evolution in the history of marketing | |
| Bean et al. | Marriage and family therapy research with ethnic minorities: Current status | |
| JP3045654U (en) | Comprehensive product evaluation analysis table by computer | |
| Morris et al. | The organization of the future: Unity of marketing and strategy | |
| Cox et al. | Productivity in the retail sector: Challenges and opportunities | |
| Lu et al. | Clustering e-commerce search engines based on their search interface pages using WISE-Cluster | |
| Rosenbaum et al. | A Framework for web-based e-commerce customer relationship management | |
| Ryynänen et al. | Low involvement, low price and low quality image renegotiated–a case study of staple food package design | |
| Hall | Information strategy and manufacturing industry—Case studies in the Scottish textile industry | |
| Lee et al. | Apparel, textiles, and merchandising scholarship practices from 2000 to 2019: Analysis of FCSRJ and CTRJ | |
| Ford et al. | Cognitive moral development and Japanese procurement executives: Implications for industrial marketers | |
| Wills et al. | Marketing in socialist societies | |
| Mishra et al. | Marketing Schools of Thought and Their Present Day Relevance | |
| Wong | The Role of Immigrant Entrepreneurs in Urban Economic Development | |
| Köse | Flooding the Ottoman market: Marketing history related topics | |
| Brown | Cincinnatti's reinvention: after a period of racial unrest, Ohio's third-largest city is accelerating the development of minority businesses and African American commercial investors | |
| Soeiro | Transforming the lives of Portuguese people by changing their eating habits: a new grab-and-go system of vacuum-packed healthy and highly nutritious food to preserve all nutrients and flavours | |
| Ghose et al. | Selecting appropriate support for marketing decisions | |
| Müller | Kinship, godparenthood and urban estates in the Bolivian Andes: The cultural production of business families | |
| IMAHASHI et al. | Brand management of small and medium-sized enterprises in Japan |