Fresh production planner

Patent metadata

Field	Value
Publication number	US-2018158009-A1
Application number	US-201715831520-A
Country	US
Kind code	A1
Filing date	Dec 5, 2017
Priority date	Dec 5, 2016
Publication date	Jun 7, 2018
Grant date	—

Abstract

A system is described for maximizing sales of perishable items while minimizing the waste produced. The system employs a number of stores each having at least one production department, such as a bakery or deli department, etc. The stores are linked to a corporate computing entity having a central CPU and corporate database. Each of the stores keeps a history of items made and sold for many time periods. The items sold for past equivalent time periods is used as an estimate of the number items to make. The corporate computing entity can determine a model store which has the best performance. The production plan for the model store is normalized and used to adjust the production plan. These numbers are calculated and rolled out just before they are needed from the east coast time zone through the farthest west time zone.

First claim

What is claimed is:

1 . A system for producing, presenting and selling an optimum number of perishable items in a predetermined time period, comprising:
a plurality of stores for making, presenting, selling, and discarding a plurality of perishable items; a corporate database adapted to store information provided to it; a central CPU coupled to the plurality of the stores and the corporate database, and is adapted to:
receive information indicating the net sales of each of a plurality of items from each of the stores for a predetermined time period,
store the received information in the corporate database;
normalize the received information for a difference in overall sales of the stores;
identify the production facilities having net sales of the item for the current time period above a predetermined amount as model production facilities,
acquire a production plan of a model store wherein the production plan indicates a number of items to produce for a plurality of time periods;
identify the acquired production plan as the model production plan numbers;
normalize the model production plan numbers for each store;
calculate the production plan numbers for each store based upon the normalized production plan numbers, resulting in an optimum number of items to produce in the predetermined time period.

2 . The system of claim 1 , wherein net sales are defined as sales of an item in a time period offset by a number of items made and not sold for the same time period.

3 . The system of claim 1 , wherein each store comprises:
a POS device adapted to acquire information on the items sold; a local database adapted to store information provided to it; at least one production department adapted to make the items, the production department having a display area adapted to display a limited number of items; a local CPU coupled to the POS and the local database adapted to:
receive information on sales of items and the time of sales from the POS,
store the sales information in the local database,
store markdown and waste information in the local database, and
store product shelf life information.

4 . The system of claim 3 wherein the production department may include at least one of a bakery, and a deli.

5 . The system of claim 3 , wherein central CPU is further adapted to:
acquire a production plan from the production plan storage for at least one previous time period; acquire information from the local database of actual items sold for the same time periods and determine a deviation from the pre-stored production plan; store the deviation in a deviation storage; display an indication of the magnitude of the deviation on an employee display for a plurality of time periods.

6 . The system of claim 3 further comprising:
an input device coupled to the local CPU allowing a count of items not sold to be input to the system.

7 . A method of increasing sales and decreasing waste of at least one perishable item made and sold in a plurality of stores, comprising the steps of:
identifying in a selected store a modular display size available for the items; identifying inventory of the selected store available to make the perishable items; determining the maximum number of items that can be made and displayed in the selected store; defining a time period to estimate a number of items to make; estimating net sales of the selected item for this store for the current time period; repeating the prior step for a plurality of time periods, items and stores; calculating a set of corporate adjustments to the estimated net sales; adjusting each estimated net sales by the corporate adjustments to result in the adjusted production numbers for each item for each store; making and displaying at the store, the adjusted production number of items needed to maximize sales and minimize waste.

8 . The method of claim 7 wherein the set of corporate adjustments is calculated by:
acquiring estimated numbers of items to make and present for the current store;
acquiring net sales of this item from net sales of a plurality of other production facilities for the defined time period;
normalizing the net sales to adjust for store size;
identifying the store that has the highest normalized net sales for this item in this time period as a model store;
acquiring the production planner numbers for this model store for the selected time period;
normalizing these production planning numbers; and
using the normalized production planner numbers as the corporate adjustments.

9 . The method of claim 7 wherein corporate adjustments are calculated by:
acquiring estimated numbers of items to make and present for the current store;
acquiring net sales trends of this item from net sales of a plurality of other production facilities for the defined time period;
normalizing the net sales trends to adjust for store size;
identifying the store that has the highest normalized net sales trends for this item in this time period as a model store;
acquiring the production planner numbers for this model store for the selected time period;
normalizing these production planning numbers; and
using the normalized production planner numbers as the corporate adjustments.

10 . The method of claim 7 , wherein the step of estimating net sales comprises:
averaging the net sales of the same item from the same store over a plurality of equivalent other past time periods.

11 . The method of claim 7 , further comprising the steps of:
acquiring actual net sales for each item for at least one past time period of the store; comparing the actual net sales to the production planner numbers for the at least one previous time period to determine performance; activating at least one performance display indicating performance for at least one past time period.

12 . The method of claim 11 , wherein the at least one performance display is color coded as to performance.

13 . The method of claim 11 wherein the past time periods include at least one of:
a previous week, a previous four weeks, a previous eight weeks, and a previous twelve weeks.

14 . The method of claim 7 , wherein the adjusted production numbers are capped to be no more than the maximum number of items that can be made and displayed in the selected store.

15 . The method of claim 9 , wherein the net sales are the sales of the item adjusted for items not sold.

16 . A fresh production planner system which determines an optimum number of perishable items to make that maximizes sales and minimizes waste, having a plurality of stores, each comprising:
a production department for making perishable items having at least one modular display area; a point of sale (POS) device adapted to acquire sales information relating to the items sold; a local database having pre-stored information on:
the size of the modular display area in a current store available to present items, a current amount of inventory for making each item, and
previous sales information of the item; a local CPU coupled to the local database, the local CPU adapted to:
acquire sales, waste, and other information for a plurality of items for a plurality of time periods, and
store the acquired information in a local database,
a corporate computing entity adapted to:
calculate net sales for a current time period by analyzing a plurality of equivalent previous time periods,
identify maximum number of items that can be made based upon modular display size and inventory available at each store for each item,
cap the net sales by the maximum n

Assignees

• Wal Mart Stores Inc

Inventors

• Moon Latisha
• Dixon Gregory D
• Billings Lacrecia Lynn
• Cheek James

Classifications

• G06Q10/06315 Primary

  Needs-based resource requirements planning or analysis · CPC title

• G06Q10/087

  Inventory or stock management, e.g. order filling, procurement or balancing against orders · CPC title

• G06Q30/0202

  Market predictions or forecasting for commercial activities · CPC title

• G06Q30/06

  Buying, selling or leasing transactions · CPC title