Shan Foods Private Limited Report Presentation PDF
Shan Foods Private Limited Report Presentation PDF
Shan Foods Private Limited Report Presentation PDF
Siddiqui
Product Costing – Recipe Spice
2012
Shan Foods
Private Limited
Korangi Industrial Area,
Karachi, Pakistan
+ 92 – 21 – 3505 3196
+ 92 – 21 – 3505 3080
Letter of Acknowledgement
This Letter is to acknowledge the efforts and sincerity, offered by the course
instructor Mr. Muhammad Rizwan Siddiqui, to teach the subject and guide.
The accomplishment of this report is a result of a combine effort made by the
reported and the reporting individuals, during the term spring 2012. The
objective to write this report is to learn the method of product costing used
by an FMCG producer, in this case Shan Foods Private Limited. I hereby
acknowledge that I may not be able to understand and write the content of
this report without sincere guidance from Mr. Abdul Gaffar (CFO, Shan Foods
Private Limited) and his associates, as well.
Gracias,
Adeel A. Siddiqui
2010 – 1 – 27 – 11262
Letter of Transmittal
To,
Muhammad Rizwan Siddiqui,
Institute of Business Management,
Dear Sir,
Gracias,
Adeel A. Siddiqui
2010 – 1 – 27 – 11262
List of Figures
List of Tables
Table of Contents
Introduction ....................................................................................................................... 2
Product Range ................................................................................................................. 2
Organization Management .......................................................................................... 3
Planning and Reporting.................................................................................................. 3
Selected Product ............................................................................................................. 4
Manufacturing Process ................................................................................................... 4
Manufacturing Process (Flowchart)............................................................................. 6
Costing Method ............................................................................................................... 7
Costing ............................................................................................................................... 9
Product Costing – Recipe Spice – Introduction
Introduction
Shan Foods (Private) Limited is a Food products Manufacturing and
Marketing Organization. It was founded in 1981 in a single room as Shan
Masala. Later, due to its popularity, the company was named Shan Foods. It
has presence in more than 50 countries today and deals in several broad
categories of offerings. Shan Foods has capitalized on the changing market
trends and consumer tastes and through product trials, it has made sure to
churn out offerings that are best in line with consumer tastes.
A huge part of their sales consist of Recipe Mix Category. Recipe Mix
Category consists of 64 variants, classified into 9 ranges. The share of products
from Biryani Range in the Recipe Mix Category Sales is significantly larger than
any other range, and it is due to the popularity of Shan Bombay Biryani
Masala.
This report is to understand the costing methods Shan Foods has adopted, for
the regular SKU (60 gm Pack), of Bombay Biryani Masala.
Product Range
Shan Foods have a brand portfolio of two brand names, Shan and Delve,
which are further sub divided into several categories and ranges of different
variants of products. Primarily, it is important to understand the broad
categories of offerings by Shan Foods. Following is a summarized list.
• Shan Variants
– Recipe Mix 64
– Plain Spices 16
– Oriental Recipe 10
– Arabic Recipe 7
– Salt 2
– Pickle 7
– Paste 3
– Sauces 5
– Rice 5
– Vermicelli 1
• Delve Deserts
– Jelly Crystals 4
– Custard Powders 3
– Pudding Mix 3
Page | 2
Product Costing – Recipe Spice – Organization Management
Organization Management
Shan Foods strongly practice Kaizen approach for continuous improvement
and was able to reduce labor dependency by implementing technological
advancements, process automation, process re-engineering and strong BPR
Strategies. These activities have not resulted in any significant reduction in
their labor cost, as the sophistication of the process require skilled and
expensive labor, irrespective of the fact that the count of labor is reduced
remarkably, while it is benefiting them by controlling wastages and quality
standards. For few production processes they are able to achieve Six Sigma.
The Production Facilities are less labor intensive, while they are striving to
automate their warehousing as well. Shan Foods adheres to the Lean
Manufacturing philosophy, and still striving to completely implement JIT in the
production and delivery process. They are focused to find ways to limit the
warehousing costs, but due to several External factors, they have to keep
material and finish goods inventory. They have projected 20% reduction in
production cost, if JIT is completely implemented.
Page | 3
Product Costing – Recipe Spice – Selected Product
Selected Product
To understand the costing method, adopted by Shan Foods Private limited, I
selected a Regular SKU (60 gm Pack) of Bombay Biryani, from Recipe Mix
Range. Recipe Mix Range consists of 64 different variant with 4 to 8 different
SKU’s for each. All these products and SKU’s have different cost associations,
while the costing methods are the same, in this specific category. The Selling
Price of this Product is PKR 35, at a Net Income level of 35~40%.
Manufacturing Process
Significantly, Shan Foods operates a highly machinery intensive and
automatic processing facility. They claim that they have eliminated direct
human hand interfaces with the product, after sterilization process. The
Manufacturing process of the selected product is divided into twelve sub
processes, which are performed in four departments, listed as follows. The
following list also contains the percentage of COGM these departments
incur, for this particular product, if we don’t accumulate the cost.
• RM Warehouse 52
– Quality Classification 10.4
– Sterilization 31.2
– Cold Storage and Warehousing 10.4
• Grinding Facility 21.75
– Chopping 1.81
– Cryogenic Grinding 9.06
– Sifting Classification 1.81
– Temp Regulated SILO Storage 3.63
– Recipe Batching 1.81
– Blending 3.363
• Packaging Facility 21.5
– Polly Filling 5.02
– Packaging & Cartooning 16.48
• Dispatch Terminal 4.75
– Finish Good Warehousing 4.75
Page | 4
Product Costing – Recipe Spice – Manufacturing Process
capacity is 250,000 units a day (8 continuous working hrs); weak links have
been strengthened by continuous Capacity Enhancement Programs and
OEE. On the basis of above evaluations, we can assume that the average
production period for a batch of 250,000 units is 4 working days, which is 32
working hrs, and 7,812.5 units are produced every hour. All Transportation of
goods is conducted during the night shift. All inventories are operated on
FIFO. They can’t practice JIT, due to the uncertain availability of Raw
Material, circumstantial uncertainty, economic, social and political
conditions.
There are five quality checks in the process. These checks are integrated
either in line or by automate sample delivery system (To QC and R&D), to
assess following standards.
These standards are immediately checked after the setting process. If the
production doesn’t meet the required standards, there is a procedure for any
set of results, which is executed accordingly. Few may result in reprocessing,
other may in spoilage. The wastage of RM is negligible, while spoilage
comprises of packaging material, significantly, whereas, the reprocessing
costs are negligible and wastage costs are adjusted in the departmental
costs.
Page | 5
Product Costing – Recipe Spice – Manufacturing Process (Flowchart)
Procurement of RM
Dispatching Terminal
Page | 6
Product Costing – Recipe Spice – Costing Method
Costing Method
For Bombay Biryani Masala, Shan Foods uses Process costing accumulation
by department, with absorbing Fixed Overheads. The percentage distribution
of Various Costs with respect to COGM is as follows.
These are rough percentages, as told by Abdul Gaffar, (CFO at Shan Foods).
The Product Flow through various processes and departments, materials
Page | 7
Product Costing – Recipe Spice – Costing Method
RM X RM Y PR HP & Cartoon
DM 0% 68% 74% 79%
Processes
QC 1 QC 2 QC 3 QC 4 QC 5
Qaul. Check 52% 65% 74% 79% 95%
Departmental
Page | 8
Product Costing – Recipe Spice – Costing
Costing
We are assuming the following to make a Cost of Production reports by
departments and a consolidated Cost of Goods Manufactured Statement,
separately.
Page | 9
Product Costing – Recipe Spice – Costing
Cost Charged
Cost Units Rate
DM 1 38,403,750 6,000,000 6.40
CC 21,656,250 6,000,000 3.61
60,060,000 10.01
Page | 10
Product Costing – Recipe Spice – Costing
Cost Charged
Cost Units Rate
CFPD 60,060,000 5,970,000 10.06
CC 24,995,644 5,970,000 4.19
85,055,644 14.25
Page | 11
Product Costing – Recipe Spice – Costing
Cost Charged
Cost Units Rate
CFPD 85,055,644 5,964,030 14.26
DM 2 2,029,224 6,023,670 0.34
CC 22,901,242 6,023,670 3.80
109,986,109 18.40
Page | 12
Product Costing – Recipe Spice – Costing
Cost Charged
Cost Units Rate
CFPD 109,986,109 5,964,030 18.44
CC 5,453,360 5,964,030 0.91
115,439,469 19.36
Page | 13
Product Costing – Recipe Spice – Costing
Page | 14
10/4/2012
• Shan Foods (Private) Limited is a Food products Manufacturing and
Marketing Organization.
• It has presence in more than 50 countries today and deals in several
broad categories of offerings.
• A huge part of their sales consist of Recipe Mix Category. Recipe
Mix Category consists of 64 variants, classified into 9 ranges.
• The share of products from Biryani Range in the Recipe Mix
Category Sales is significantly larger than any other range, and it is
due to the popularity of Shan Bombay Biryani Masala.
• This report is to understand the costing methods Shan Foods has
adopted, for the regular SKU (60 gm Pack), of Bombay Biryani
Masala.
1
10/4/2012
5% 10%
22%
16%
33%
5%
32%
3% 8%
2%
4%
9% 10%
2% 10% 2%
12%
2% 5%
4% 4%
Quality Classification Sterilization Cold Storage and Warehousing
Chopping Cryogenic Grinding Sifting Classification
0%
0%
Temp Regulated SILO Storage Recipe Batching Blending DM 1 DM 2 DL RM WH DL Grinding DL Packaging V. IDM V. IDL V. Others F. IDM F. IDL F. Others
Polly Filling Packaging & Cartooning Finish Good Warehousing
Procurement of RM
Quality Classification and Sterilizing Process
Cold Storage and Warehousing
Primary Quality Check (QC 1) Fails
Mehrunisa Warehouse
Transportation to Grinding Facility
Mid Quality Check each Ingredient (QC 2) Fails
Temperature Regulated SILO Storage
RM (S) Compound Y Recipe Batching and Blending Process
Main Quality Check (QC 3) Fails
Grinding Facility
IBC Storage
Packaging Rolls Poly Filling Process
Pressure Testing (V lock method; QC 4) Fails
Hard Packets and Cartoons Packaging and Cartooning Process
Packaging Quality Check (QC 5) Fails
Packaging Facility
Finish Good Warehousing
Dispatching Terminal
Processes
Departmental
2
10/4/2012
Equivalent Production Units
DM 1 CC
Units Introduced 6,000,000 6,000,000
Unit Manufacturing Cost DM DL VFOH FFOH CC Total Units Transferred 5,970,000 5,970,000
Normal Spoilage 30,000 30,000
6,000,000 6,000,000
RMWH 6.40 2.31 0.14 1.16 3.61 10.01
Grinding Facility
Grinding Facility 0 00
0.00 0 77
0.77 0 34
0.34 3 08
3.08 4 19
4.19 4 19
4.19 Cost Charged
Cost Charged
Packaging Facility 0.34 0.77 0.34 2.70 3.80 4.14 Cost Units Rate
Dispatch Terminal 0.00 0.00 0.14 0.77 0.91 0.91 DM 1 38,403,750 6,000,000 6.40
CC 21,656,250 6,000,000 3.61
60,060,000 10.01
6.74 3.85 0.96 7.70 ‐ 19.25
Cost Accounting for
Units Rate Total
Transferred Out 5,970,000 10.01 59,759,700
Losses
DM 1 30,000 6.40 192,019
CC 30,000 3.61 108,281
60,060,000
Equivalent Production Units Equivalent Production Units
CFPD DM 2 CC
CFPD CC
Units Introduced 5,964,030 6,023,670 6,023,670
Units Introduced 5,970,000 5,970,000
Units Transferred 5,964,030 5,964,030 Units Transferred 5,964,030 5,964,030 5,964,030
Normal Spoilage 0 59,640 59,640
Normal Spoilage 5,970 5,970
5,970,000 5,970,000 5,964,030 6,023,670 6,023,670
Cost Charged
Cost Charged
Cost Charged Cost Units
i Rate
Cost Units Rate
CFPD 85,055,644 5,964,030 14.26
CFPD 60,060,000 5,970,000 10.06
DM 2 2,029,224 6,023,670 0.34
CC 24,995,644 5,970,000 4.19
CC 22,901,242 6,023,670 3.80
85,055,644 14.25
109,986,109 18.40
Cost Accounting for Cost Accounting for
Units Rate Total Units Rate Total
Transferred Out 5,964,030 14.25 84,970,588 Transferred Out 5,964,030 18.40 109,739,273
Losses Losses
CFPD 0 14.26 0
CFPD 5,970 10.06 60,060 DM 2 59,640 0.34 20,091
CC 5,970 4.19 24,996 CC 59,640 3.80 226,745
85,055,644 109,986,109
3
10/4/2012