Tea Operational Procedure

Tea Operational Procedure

Marketing

Garden

Factory

Warehouse

BrokersBuyers

Auction

Blending

Tea Packaging

Tea Stock Transaction

Tea Blend Transaction

Tea Buying Transaction

Exit

Overview

View

View

View

Broker & Garden list: If you change or add broker or garden in source data or other sheet then you need to change and add broker and garden list after that you have to refresh on every report in these sheet.

Next

Source data: Here has opening stock and include the receivable product from the tea auction. And blend the different standard wise tea then it throw out the factory. Here is define the used and unused of raw tea after the blend.

Next

If you change anything from source data then you have to keep the mouse courser over the any data of this sheet. And then you will get a Pivot Table Tools menu then you click the option menu and get Refresh option. So always refresh your data after the entre any data. Stock details report shows the details of used and unused data.

Next

Stock Standard details report2: Here we create standard wise details. And it’s forecasting and estimating the stock what we measure the quality of product that we can be provide or not.

Next

Stock Standard summary report3: Here we can get standard wise summary and easily measure that how much we need products from the auction.

Back

Blend Details Report 1: We can find out which blend we used by standard wise.

Next

Blend-summary-report-001: Here we will get how much blend we used till now.

Next

Blend-summary-sub-report-002: Here we set up some standard and make the summary how much we blend by standard wise.

Back

Buy-broker-summary-rpt-01: we will give the payment to the brokers through the summary how much we bought raw items from the auction.

Next

Buy-standard-summary-rpt-02 : Here we can measure how much we bought the raw items by the standard wise.

Next

Buy-count-garden-rpt-03: Here we select some special garden where we find or look out the amount the of raw tea from these garden.

Next

Buy-broker-lot-detail-rpt-04: Here we show that the Lot number ,Garden, Chest/ Bag details by the broker wise.

N.B: if u can change by the different type of product which is your any requirement.

Back

Thank You