Q22

14: Electronics manufactures electronic home appliances. It follows weighted average Cost method for inventory valuation. Following are the data of component X: Date Particulars Units Rate per unit 15-12-19 30-12-19 01-01-20 05-01-20 10,000 10,000 3,500 10,000 500 9,930 9,780 9,810 05-01-20 9,750 06-01-20 07-01-20 10-01-20 12-01-20 Purchase Order-008 Purchase Order-009 Opening stock GRN*-008 (against the Purchase Order-008) MRN**-003 (against the Purchase Order-008) Material Requisition-011 Purchase Order-010 Material Requisition-012 GRN-009 (against the Purchase Order-009) MRN-004 (against the Purchase Order-009) Material Requisition-013 Material Requisition-014 GRN-010 (against the Purchase Order-010) Material Requisition-015 Material Requisition-016 3,000 10,000 4,500 10,000 400 13-01-20 15-01-20 24-01-20 25-01-20 2,200 1,500 10,000 4,000 3,200 28-01-20 31-01-20 *GRN- Goods Received Note; **MRN- Material Returned Note Based on the above data, you are required to CALCULATE: (i) Re-order level (ii) Maximum stock level (iii) Minimum stock level