ASSIGNMENT
- 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
- Purchase the following items with ref no: TSS/1789 from TSS Industries and stored at Rajam godown (Date : 01-05-2021)
S.NO | NAME OF THE ITEM | QUANTITY | RATE PER ML |
---|---|---|---|
1 | Aqua | 600 ML | 1.00 |
2 | Glycerin | 400 ML | 2.00 |
3 | Caprylic / Capric Triglyceride | 400 ML | 1.25 |
4 | Isopropyl Myristate | 1000 ML | 2.75 |
5 | Cetyl Palmitate | 520 ML | 1.00 |
6 | Cetearyl Alcohol | 400 ML | 1.50 |
7 | Glyceryl Stearate SE | 300 ML | 1.15 |
8 | Fragrance | 450 ML | 1.65 |
9 | Dimethicone | 900 ML | 1.60 |
10 | Phenoxyethanol | 150 ML | 1.45 |
11 | Methylparaben | 260 ML | 1.15 |
12 | Acrylates/C10-30 | 750 ML | 1.60 |
13 | Propylparaben | 650 ML | 3.39 |
14 | Tocopheryl Acetate | 100 ML | 4.15 |
15 | Sodium Hydroxide | 650 ML | 1.15 |
16 | Disodium EDTA | 410 ML | 4.50 |
17 | Vitis Vinifera Seed Oil | 780 ML | 1.40 |
18 | Prunus Amygdalus Duilcis Oil | 650 ML | 1.00 |
19 | Juglans Regia Seed Oil | 600 ML | 1.10 |
- 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
- Click on New
- Godown
- Inventory Masters
- Create
- Masters
- 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
- Stock Item
- Inventory Masters
- Create
- 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
- Vouchers
- 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
