The following trial balance of The Shire Golf Club was extracted from the books as on 31 December 2023:\begin{tabular}{|c|c|c|}\hline 2023: & Dr & Cr \\\hline & E & £ \\\hline Clubhouse & 142,000 & \\\hline Equipment & 18,600 & \\\hline Profits from raffles & & 6,508 \\\hline Subscriptions received & & \\\hline Wages of bar staff & 29,200 & \\\hline Bar stocks 1 January 2023 & 2,400 & \\\hline Bar purchases and sales & 41,300 & 84,600 \\\hline Greenkeepers' wages & 21,500 & \\\hline Golf professional's salary & 37,000 & \\\hline✓ General expenses & 910 & \\\hline Cash at bank & 3,924 & \\\hline Accumulated fund at 1 January 2023 & & 303,83429,326 \\\hline\end{tabular}ADDITIONAL NOTESi. Bar purchases and sales were on a cash basis. Bar stocks at 31 December 2023 were valued at i. £6,410.ii. Subscriptions paid in advance by members at 31 December 2023 amounted to £1,870.iii. Provide for depreciation of equipment £2,400.You are required to:(a) Draw up the bar trading account for the year ended 31 December 2023.(b) Draw up the income and expenditure account for the year ended 31 December 2023, and a balance sheet as at 31 December 2023.
Q. The following trial balance of The Shire Golf Club was extracted from the books as on 31 December 2023:\begin{tabular}{|c|c|c|}\hline 2023: & Dr & Cr \\\hline & E & £ \\\hline Clubhouse & 142,000 & \\\hline Equipment & 18,600 & \\\hline Profits from raffles & & 6,508 \\\hline Subscriptions received & & \\\hline Wages of bar staff & 29,200 & \\\hline Bar stocks 1 January 2023 & 2,400 & \\\hline Bar purchases and sales & 41,300 & 84,600 \\\hline Greenkeepers' wages & 21,500 & \\\hline Golf professional's salary & 37,000 & \\\hline✓ General expenses & 910 & \\\hline Cash at bank & 3,924 & \\\hline Accumulated fund at 1 January 2023 & & 303,83429,326 \\\hline\end{tabular}ADDITIONAL NOTESi. Bar purchases and sales were on a cash basis. Bar stocks at 31 December 2023 were valued at i. £6,410.ii. Subscriptions paid in advance by members at 31 December 2023 amounted to £1,870.iii. Provide for depreciation of equipment £2,400.You are required to:(a) Draw up the bar trading account for the year ended 31 December 2023.(b) Draw up the income and expenditure account for the year ended 31 December 2023, and a balance sheet as at 31 December 2023.
Calculate Opening Stock: Calculate the opening stock for the bar trading account using the given value.Opening Stock = £2,400
Calculate Total Goods Available: Add bar purchases to the opening stock to find the total goods available for sale.Total Goods Available for Sale = Opening Stock + Bar PurchasesTotal Goods Available for Sale = £2,400 + £41,300Total Goods Available for Sale = £43,700
Calculate Closing Stock: Calculate the closing stock for the bar trading account using the given value.Closing Stock = £6,410
Determine Cost of Goods Sold: Determine the cost of goods sold (COGS) for the bar. COGS=Total Goods Available for Sale−Closing StockCOGS=£43,700−£6,410COGS=£37,290
Calculate Gross Profit: Calculate the gross profit for the bar by subtracting COGS from bar sales. Gross Profit = Bar Sales - COGSGross Profit = £84,600 - £37,290Gross Profit = £47,310
Calculate Net Profit: Calculate the net profit for the bar by subtracting expenses from the gross profit.Net Profit = Gross Profit - Wages of Bar StaffNet Profit = £47,310 - £29,200Net Profit = £18,110
Calculate Total Income: Calculate the total income for the income and expenditure account.Total Income = Profits from Raffles + Net Profit from Bar + Subscriptions ReceivedTotal Income = £6,508 + £18,110 + (Subscriptions Received)
More problems from Solve two-step equations: word problems