Project – Phase 4.1
Complete the following Tasks:
Table 1.1: Information to Create Purchase Orders
| PO Number | PO Date | Vendor Name | Vendor Type | Credit Period | Item(s) Purchased | Expected Delivery (Days) |
| TV/PO/101 | 01-M1-YY | Metro Tech Components Pvt Ltd | Registered | 60 days | LED Panel (32”) – 20 pcs @ ₹5,800; Motherboard – 15 pcs @ ₹2,200 | 7 |
| TV/PO/102 | 02-M1-YY | Digital Circuits & Solutions | Registered | 45 days | Motherboard – 25 pcs @ ₹2,200 | 5 |
| TV/PO/103 | 05-M1-YY | Starline Electronics | Registered | 60 days | Remote
Control Unit – 50 pcs @ ₹120; Power Supply Unit – 20 pcs @ ₹350 |
10 |
| TV/PO/104 | 08-M1-YY | South Tech Packaging Solutions | Registered | 30 days | Recycled Packaging Material – 20 kg @ ₹30 | 8 |
| TV/PO/105 | 11-M1-YY | Shree Cable Traders | Unregistered | Immediate | Power Supply Unit – 30 pcs @ ₹350 | 3 |
| TV/PO/106 | 22-M1-YY | Shree Cable Traders | Unregistered | Immediate | TV Wall Mount Bracket (32–43 Inch) – 50 Pcs @ ₹650 | 6 |
| TV/PO/107 | 23-M1-YY | Unique Print Solutions | Composition Dealer | 30 days | User Manual (Printed Guide) – 50 pcs @ ₹7 | 4 |
| TV/PO/108 | 28-M1-YY | Crystal Technova Pvt Ltd | Registered | 60 days | LED
Panel (32”) – 10 pcs @ ₹5,600; Motherboard – 15 pcs @ ₹2,000; Power Supply Unit – 20 pcs @ ₹400; HDMI Cable – 1.5 Meter – 25 pcs @ ₹180 |
9 |
Table 1.2: New Vendor Details:
| Vendor Name | Contact Person | Mobile | Email ID | Address | GST Registration Type | GSTIN | State | Credit Period |
| Unique Print Solutions | Anil Gupta | 9876543210 | uniqueprint. 2solutions58 @gmail.com |
Shop No. 12, Ground Floor, Patparganj Industrial Area, Delhi – 110092 | Composition Dealer | 07AAEPU 4321C1Z2 |
Delhi | 30 days |
| Crystal Technova Pvt Ltd | Ramesh Patel | 9825098765 | 1crystaltechnova 36@gmail.com |
Plot No. 45, GIDC Industrial Estate, Vatva, Ahmedabad, Gujarat – 382445 | Registered (Regular) | 24AAFTC 7890D1Z5 |
Gujarat | 45 Days |
Table 1.3: New Item Details:
| Item Name | Type | Unit | HSN/SAC | Tax | Description | Cost Price (₹) | Selling Price (₹) |
| TV Wall Mount Bracket (32–43 Inch) | Goods | Pieces | 830250 | 18% | Steel wall mounting bracket suitable for LED TVs | 650 | 1,200 |
| HDMI Cable – 1.5 Meter | Goods | Pieces | 854442 | 18% | High-speed HDMI cable for audio & video transmission | 180 | 350 |
Table 2: Make changes to the POs based on the information given:
| PO Number | Bill Date | Vendor Name | Bill Number | Credit Period | Item(s) Purchased | Status |
| TV/PO/101 | 03-M1-YY | Metro Tech Components Pvt Ltd | MTC/236 | 60 days | LED Panel (32”) – 20 pcs @ ₹5,800; Motherboard – 15 pcs @ ₹2,200 | Convert to Bill |
| TV/PO/102 | NA | Digital Circuits & Solutions | NA | 45 days | Motherboard – 25 pcs @ ₹2,200 | Cancel the PO |
| TV/PO/103 | 11-M1-YY | Starline Electronics | INV-Star-2798 | 60 days | Remote
Control Unit – 40 pcs @ ₹120; Power Supply Unit – 20 pcs @ ₹375 |
Convert to Bill with Updated Item Quantity & Rate |
| TV/PO/104 | NA | South Tech Packaging Solutions | NA | 30 days | Recycled Packaging Material – 20 kg @ ₹30 | Change expected delivery date to 30 days from date of PO. |
| TV/PO/105 | 19-M1-YY | Shree Cable Traders | 10071 | Immediate | Power Supply Unit – 30 pcs @ ₹350 | Convert to Bill |
| TV/PO/106 | NA | Shree Cable Traders | NA | Immediate | TV Wall Mount Bracket (32–43 Inch) – 50 Pcs @ ₹650 | No changes to be made |
| TV/PO/107 | NA | Unique Print Solutions | NA | 30 days | User Manual (Printed Guide) – 50 pcs @ ₹7 | Cancel the PO |
| TV/PO/108 | 28-M1-YY | Crystal Technova Pvt Ltd | CTPT/INV/378 | 45 days | LED
Panel (32”) – 10 pcs @ ₹5,600; Motherboard – 15 pcs @ ₹2,000; Power Supply Unit – 20 pcs @ ₹375; HDMI Cable – 1.5 Meter – 25 pcs @ ₹180 |
Convert to Bill with Updated Rate |
Table 3.1: Create Bills based on the information given:
| Bill No | Bill Date | Vendor Name | Discount | Credit Period (Days) | Item(s) Purchased | GST Rate(s) |
| DC/121 | 12-M1-YY | Digital Circuits & Solutions | 10% | 45 days | Motherboard – 20 pcs @ ₹2,000 | 18% |
| NPS/BILL/1024 | 18-M1-YY | Shree Cable Traders | NA | Immediate | LED
TV Remote Cover (Silicone) – 50 pcs @ ₹45; Set Top Box Stand (Plastic) – 50 pcs @ ₹95 |
No GST, Unregistered vendor |
| AV/SL/303 | 21-M1-YY | AV Electronics Distributors | 50 each on Set Top Box Only | 45 days | Set
Top Box (HD) – 50 pcs @ ₹1,250; Sound Bar – 2.1 Channel – 50 pcs @ ₹3,800 |
18% (both items) |
Table 3.2: New Item details
| Item Name | Type | Unit | HSN/SAC | Tax | Description | Cost Price (₹) | Selling Price (₹) | Reorder Quantity |
| Set Top Box (HD) | Goods | Pieces | 852871 | 18% | HD digital set top box compatible with LED TVs | 1,250 | 2,100 | 25 |
| Sound Bar – 2.1 Channel | Goods | Pieces | 851822 | 18% | 2.1 channel sound bar for enhanced TV audio | 3,800 | 6,500 | 25 |
| LED TV Remote Cover (Silicone) | Goods | Pieces | 392690 | 5% | Protective silicone cover for LED TV remote | 45 | 90 | 25 |
| Set Top Box Stand (Plastic) | Goods | Pieces | 392690 | 5% | Plastic stand to place set top box near TV | 95 | 180 | 25 |
Table 3.3: New Vendor Details:
|
Field |
Details |
|
Vendor Name |
AV Electronics Distributors |
|
Legal Name |
AV Electronics Distributors Pvt Ltd |
|
GST Registration Type |
Registered (Regular) |
|
GSTIN |
29AAVCA6789F1Z4 |
|
State |
Karnataka |
|
State Code |
29 |
|
Address |
No. 45, 2nd Main Road, Peenya Industrial Area,
Bengaluru, Karnataka – 560058 |
|
Contact Person |
Suresh Kumar |
|
Mobile |
9845098765 |
|
Email ID |
|
|
Payment Terms |
45 Days Credit |
Table 4: Record expenses based on the information given in the table below;
| Date | Bill No. | Vendor | Amount | Expense Category | Expense Details | Payment Mode | Special Setting |
| 02-M1-YY | 265675 | Delhi Vidyut Board (DVB) | 6,500 | Electricity Expense | Office electricity bill paid | Trust Bank of India | Normal expense |
| 17-M1-YY | ACT/7671 | FAST Fibernet | 2000 + GST 18% | Internet & Communication | Monthly internet charges | Trust Bank of India | Convert to Recurring Expense (Monthly) |
| 22-M1-YY | BH-MM-76 | JM Consultants | 9000 + GST 18% | Professional Fees | Vendor inspection charges paid | Trust Bank of India | Normal expense |
| 25-M1-YY | 87 | NA | 860 | Staff Welfare Expenses | Snacks for Employees | Cash | Normal expense |
| 26-M1-YY | NA | NA | 13,600 | Transport Expenses | Expenses paid for goods transport | Trust Bank of India | Normal expense |
| 17-M2-YY | ACT/8621 | FAST Fibernet | 2000 + GST 18% | Internet & Communication | Monthly internet charges | Trust Bank of India | Convert to Recurring Expense (Monthly) |
New Vendor Details:
| Vendor Name | GSTIN |
| Delhi Vidyut Board (DVB) | NA |
| FAST Fibernet | 07HBTCF7856M6Z2 |
Table 5: Record Credit Note Received from Vendors
| Credit Note No | CN Date | Vendor Name | Item | Qty Returned | Taxable Value (₹) | GST Rate | GST Amount (₹) | Total Value (₹) |
| MT/CN-716 | 15-M1-YY | Metro Tech Components Pvt Ltd | LED Panel (32”) | 5 | 29,000 | 18% | 5,220 | 34,220 |
| AVE-C28 | 28-M1-YY | AV Electronics Distributors | Sound Bar – 2.1 Channel | 10 | 38,000 | 18% | 6,840 | 44,840 |
Table 6: Record all payments made against the Bills, Expenses & Vendor Advances
Note:
Payment Details:
| Date | Payment No. | Towards | Party | Amount | Payment Mode |
| 11-M1-YY | TV/PT/101 | Vendor Payment | Starline Electronics | 14,514 | Cash in Hand |
| 15-M1-YY | TV/PT/102 | Vendor Advance | South Tech Packaging Solutions | 20,000 | Trust Bank of India |
| 20-M1-YY | TV/PT/103 | Vendor Payment | Shree Cable Traders | 12,390 | Trust Bank of India |
| 20-M1-YY | TV/PT/104 | Vendor Payment | Shree Cable Traders | 7,350 | Cash in Hand |
| 25-M1-YY | TV/PT/105 | Vendor Advance | South Tech Packaging Solutions | 50,000 | Trust Bank of India |
| 28-M1-YY | TV/PT/106 | Vendor Payment | AV Electronics Distributors | 50,000 | Trust Bank of India |
| 18-M2-YY | TV/PT/107 | Vendor Payment | Metro Tech Components Pvt Ltd | 50,000 | Trust Bank of India |
| 21-M2-YY | TV/PT/108 | Vendor Payment | AV Electronics Distributors | 1,50,000 | Trust Bank of India |
| 21-M2-YY | TV/PT/109 | Vendor Payment | AV Electronics Distributors | 14,500 | Cash in Hand |
| 26-M2-YY | TV/PT/110 | Vendor Payment | Digital Circuits & Solutions | 42,480 | Trust Bank of India |