Q.No : 2 Beta Plc is a manufacturing company which purchases raw material locally and also from Germany, processes them and sells in Domestic Tariff Area. Following costs have been given by the company: (a) Material (purchased locally) Rs. 4,50,500 (b) Material (imported from Germany) Rs. 2,12,250 (c) Carriage inward Rs. 4,500 (d) Carriage outward Rs. 5,200 (e) Octroi Rs. 3,700 (1) Freight Rs. 2,150 (g) Goods & Service Tax (local purchase) 18% on Material cost and Import duty is 1.5% of Material cost. (h) Wages Rs. 39,500 and Manager's salary Rs. 41,250 (i) Rent Rs. 131,000 (j) Factory Tools Rs. 1,62,000 (k) Computers Rs. 2,13,000 (1) Warehouse building Rs. 2,12,500 (m) Office expenses Rs. 10,570 (n) Repair of machine Rs. 2,470 (0) Sundry Expenses Rs. 3,220 (p) Fue Hel for machine Rs. 4,120 (q) Income tax Rs. 2,150 (r) Interest on loan Rs. 5,350 (s) Advertisement Rs. 5,210 (t) Distribution Manager salary Rs. 4,670 (u) Dividend Rs. 7,150 (v) Audit fees Rs. 6,130 (w)Insurance Rs. 21,400 Additional information: (i) Depreciation is 7% on tools, 12% on computers & 10% on buildings (ii) Opening stock of Raw Material is Rs. 13,759 WIP is Rs. 29,150 and Finished Goods is Rs. 32,350 (iii) All closing stocks are valued at 83% of the opening stock (iv) Insurance is allocated as per value of assets in factory, office & warehouse. (v) Profit margin is 20% on total cost (vi) 1/3 of Wages are productive wages (vii) Manager spends 45% time in office & 55% time in factory (viii) Office area is 1350 sq. ft, warehouse area is 700 sq. ft and Factory Area is 2100 sq. feet Required: Prepare a Cost Sheet from the given data.