How do you use “BILL OF MATERIALS” in Tally Prime?

ASSIGNMENT

  1. Company has decided to produce a BODY LOTION. To produce that new product required raw materials are as follows
    • Finished Goods : Body Lotion (U.O.M – ML)
    • Raw Materials: (U.O.M – ML) For 1000ML of Body Lotion
      • Aqua — 80 ML
      • Glycerin – 33 ML
      • Caprylic / Capric Triglyceride – 30 ML
      • Isopropyl Myristate – 100ML
      • Cetryl Palmitate – 40ML
      • Ceterarly Stearate SE – 30ML
      • Fragrance – 45ML
      • Dimethicone – 90ML
      • Phenoxyethanol – 15ML
      • Methylparaben – 26ML
      • Acrylates / C10 – 30 ML
      • Acrylate Crosspolymer – 75 ML
      • Propylparaben – 65ML
      • Tocopheryl Acetate – 10ML
      • Sodium Hydroxide – 65ML
      • Disodium EDRA – 41ML
      • Vitis Vinifera Seed Oil – 78ML
      • Prunus Amygdalus Dulcis Oil – 65ML
      • Juglans Regia Seed Oil – 60ML
  2. Purchase the following items with ref no: TSS/1789 from TSS Industries and stored at Rajam godown (Date : 01-05-2021)
S.NONAME OF THE ITEMQUANTITYRATE
PER ML
1Aqua600 ML1.00
2Glycerin400 ML2.00
3Caprylic / Capric Triglyceride400 ML1.25
4Isopropyl Myristate1000 ML2.75
5Cetyl Palmitate520 ML1.00
6Cetearyl Alcohol400 ML1.50
7Glyceryl Stearate SE300 ML1.15
8Fragrance450 ML1.65
9Dimethicone900 ML1.60
10Phenoxyethanol150 ML1.45
11Methylparaben260 ML1.15
12Acrylates/C10-30750 ML1.60
13Propylparaben650 ML3.39
14Tocopheryl Acetate100 ML4.15
15Sodium Hydroxide650 ML1.15
16Disodium EDTA410 ML4.50
17Vitis Vinifera Seed Oil780 ML1.40
18Prunus Amygdalus Duilcis Oil650 ML1.00
19Juglans Regia Seed Oil600 ML1.10
  1. Pass a Manufacturing Journal under Stock Journal to produce 2000ML of Body Lotion
    Expenses Incurred
    • Labor Charges – 1%
    • Electricity – 2%
    • Packaging – ₹ 30

SOLUTION

SETTING- UP FEATURES

  • Press F11 for Company Features
  • Maintain Inventory : Yes
  • Press CTRL + A to accept the total screen

CREATING GODOWN

  • Gateway of Tally
    • Masters
      • Create
        • Inventory Masters
          • Godown
            • Click on New
              • Name : Rajam
  • Press CTRL + A to accept

CREATING RAW MATERIALS

  • Gateway of Tally
    • Create
      • Inventory Masters
        • Stock Item
          • Name : Aqua
          • Under : Primary
          • Unit : ML
          • Press Enter
          • Accept _ Yes
  • Create the remaining items (raw materials) same as above

CREATING BILL OF MATERIALS (PRODUCTION FORMULA)

  • Press F12 for Configuration at stock item creation screen and activate the below option
    • Set Components List (Bill of Materials) in Stock items : Yes
    • Press CTRL + A to accept all
    • Now create the finished goods with component list details and production formula
  • Name : BODY LOTION
  • Under : Primary
  • Units : ML
  • Additional Details :
    Set Components (BOM) : Yes
  • Name of BOM:
    Making of Body Lotion
    Press enter
  • Unit of Manufacturer :1000 ML <Press Enter>
  • Now select the item from the list <press Enter>
  • Then, select the Godown “Rajam” at godown field, <press enter>
  • Now enter the quantity as given in assignment
    • (Specify the all raw materials as given in assignment)
  • Press CTRL + A to accept the entire screen

CREATING PURCHASE VOUCHER

  • Gateway of Tally
    • Vouchers
      • Press F9 for purchase voucher
  • Press CTRL + H to change the voucher mode and select “Item Invoice” in it, Press enter
  • Press F2 to change date : and enter 01-05-2021
  • Supplier Invoice Number: TSS/1789
  • Party’s A/c Name : select “Create” option
    • Name : TSS Industries
    • Under : Sundry Creditors
    • Maintain Balances Bill – By Bill : Yes
    • Press Ener
    • Accept _ Yes
  • Purchase Ledger : Select “Create” option, Press enter
    • Name : Purcahse A/c
    • Under : Purchase Accounts
    • Inventory Values are Affected : Yes
    • Press enter
    • Accept_ Yes
      (note: If purchase ledger is not displays, press F12 for configuration then activate the option “Use Common Ledger A/c for Item Allocation : Yes)
  • Name of Item: <Select the item from the list>, Press enter (Ex : Aqua)
  • Godown : <Select “Rajam”godown from the list>, Press enter
  • Now Enter the Quantity and Rate
  • Enter the all raw materials as said above
  • Press Ctrl + A to accept all

CREATING MANUFACTURING JOURNAL

  • Press ALT + F7 for stock journal
  • Press Ctrl + H to change mode and Select “Use as a Manufacturing Journal” in it, press enter
  • Name of Product :
    BODY LOTION, Press Enter
  • Godown :
    Rajam, Press Enter
  • Qty: 2000ML
    Press enter
  • Now automatically fills the raw materials and required quantity
    Press enter
  • Type of Additional Cost:
  • Create the ledgers, Labour charge, Electricity and Packaging (Under : Indirect Expenses)
  • And enter the percentage as given in assignment
  • Now “Effective Cost and Effective Rate per ML ” displays automatically
  • Press Enter, Accept _ Yes
BILL OF MATERIALS IN TALLY PRIME

SEE MORE