1.

Mr A, a shopkeeper had prepared the following trial balance from his ledger on 31st March, 2009:DEBIT:Purchases : 6,20,000Cash in hand: 4,200Cashi at Bank: 24,000Stock of goods on 1st April,2008: 1,00,000Drawings: 8,000Salaries:64,000Postage and telephone: 23,000Salesman commission: 70,000Insurance; 18,000Advertisementt: 34,000Furniture: 44,000Printing and Stationary:6,000Motor Car: 96,000Bad debts: 4,000Cash Discount: 8,000General Expenses : 60,000Carriage Inward: 20,000Carriage Outward : 44,000Wages: 40,000Debtors: 2,00,000Total: 14,87,200CREDITSales: 8,30,000Capital: 5,77,200Creditors: 80,000Total: 14,87,200You are requested to prepare a Tradin and Profit & Loss Account for the year ended on 31st March, 2009 and a Balance Sheet as on that date.You are also given the following informationCost of goods in stock as on 31st March,2009 Rs 1,45,000Mr A had withdrawn goods worth Rs 5,000 during the year.Purchases include purchase of furnituere worth Rs 10,000Debtors include rs 5,000 bad debtsCreditors include a balance of rs 4,000 to the credit of Mr Biman in respect of which it has been decided and settled with the party to pay only rs 1,000Sales include goods worth rs 15,000 sent to Kundu &Co. On approval and remaining unsold as on 31st March,2009 the cost of the goods was Rs 10,000Provision for bad debts is to be created at 5% on sundry debtorsDepreciate furniture by 15% and motor car by 20%The salesmen are entitled to a commission on 10% on total sales

Answer»

you are a sales manager of a company that deals in cosmetic- soaps, talcum POWDER, moisturizer , deodarant and face pack prepare a sales analysis in EXCEL worksheet and then BASED on the create a PRESENTATION highlighting the most profit able products of your company



Discussion

No Comment Found

Related InterviewSolutions