Pages

Subscribe:

Ads 468x60px

Oracle ERP's tentative cost sheet format

In Oracle ERP Environment Calcium Tablet will show this cost sheet.



BioPharma LIMITED
 Product Name  :

CAC- 1000 TAB 10'S



     FORM   MS-1



 Product Code   :CAC-1000



Mfg. Code

      Effective Date



 Lot / Batch Size

Lot Input
Output
Pack Size
Yield %
      01/01/04


STD. PROD. COST CALCULATION
 and Quantity

1,000
990
1X10'S
99.0%






10000TAB
 Current Year Standard

   Last Year's Standard

GROWTH

 STANDARD MATERIAL COST Summary (Variable)



Total cost
Unit cost
Total cost
Unit cost
%

 ACTIVE MATERIAL COST









 RAW MATERIAL COST



18,774
18.9636




 PACKAGING MATERIAL COST



9,800
9.8990




 TOTAL  MATERIAL COST



28,574
28.8626













CODE
LABOUR, EQUIPMENT &
Distribution
     Assesment Rates

    Budgeted Mfg Overhead Cost


Mfg. cost
Last
No.
OVERHEAD COST CENTERS  :
Factors
Variable
Fixed
Variable
Fixed
Total
Per Unit
Year STD.

 PLANT LABOR &OVERHEAD
10000
0.086
0.154
860
1,540
2,400
2.4242


 TOTAL MFG. EXPENSES



860
1,540
2,400
2.4242


 MFG EXPENSES per unit



0.8687
1.5556
2.4242













STANDARD COST
           Total Batch Costing



Cost Per Unit

Last year
Growth

SUMMARY :
Variable
Fixed
Total
Variable
Fixed
Total
Total
%

 MATERIAL COST
28,574

28,574
28.8626

28.8626



 MFG. OVERHEAD COST
860
1,540
2,400
0.8687
1.5556
2.4243



 TOTAL STANDARD COST
29,434
1,540
30,974
29.7313
1.5556
31.2869












CODE
Description of Materials
  Label Weight Qty.

Unit
Std. Qty
Unit Cost
Total Cost
Last Yr
Growth %
No.
 ACTIVE MATERIAL COST  :









TOTAL









 RAW MATERIAL COST :









 Cal Lactate Gluconate


KG
10.000
206.100
2,061



 Cal Carbonate (DC Grade)


KG
3.270
289.720
947



 Ascorbic acid Uncoated


GM
5000
0.805
4,025



 Sodium Bicarbonate


KG
20.000
21.200
424



 Citric Acid Anhydrous


KG
15.800
93.000
1,469



 Sorbitol Powder


KG
5.500
150.000
825



 Aspartame


 GM
1880
1.789
3,363



 Sodium Saccharin


 GM
300
0.276
83



 Orange Flavor -Dry


 GM
3500
1.000
3,500



 Beta Carotine


 GM
100
11.926
1,193



 Sodium Chloride


KG
2.000
35.000
70



 Poly ethylene Glycol -6000


 GM
2000
0.407
814



TOTAL





18,774



 PACKAGING MATERIAL COST :









 Alu Container with Plastic Screw Caps


PC
1000
6.000
6,000



 Printed Al Foil


kg
5.000
500.000
2,500



 Desiccant Bags


PC
1000
0.300
300



 CARTON IFC


PC
1,000
1.000
1,000



TOTAL





9,800