Bytelearn - cat image with glassesAI tutor

Welcome to Bytelearn!

Let’s check out your problem:

The following trial balance of The Shire Golf Club was extracted from the books as on 31 December 2023:




2023:
Dr

Cr



E

£


Clubhouse
142,000



Equipment
18,600



Profits from raffles

6,508


Subscriptions received




Wages of bar staff
29,200



Bar stocks 1 January 2023
2,400



Bar purchases and sales
41,300
84,600


Greenkeepers' wages
21,500



Golf professional's salary
37,000




✓ General expenses
910



Cash at bank
3,924



Accumulated fund at 1 January 2023


(29,326)/(303,834)




ADDITIONAL NOTES
i. 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.

The following trial balance of The Shire Golf Club was extracted from the books as on 3131 December 20232023:\newline\begin{tabular}{|c|c|c|}\newline\hline 20232023: & Dr & Cr \mathrm{Cr} \\\newline\hline & E & £ £ \\\newline\hline Clubhouse & 142142,000000 & \\\newline\hline Equipment & 1818,600600 & \\\newline\hline Profits from raffles & & 66,508508 \\\newline\hline Subscriptions received & & \\\newline\hline Wages of bar staff & 2929,200200 & \\\newline\hline Bar stocks 11 January 20232023 & 22,400400 & \\\newline\hline Bar purchases and sales & 4141,300300 & 8484,600600 \\\newline\hline Greenkeepers' wages & 2121,500500 & \\\newline\hline Golf professional's salary & 3737,000000 & \\\newline\hline \checkmark General expenses & 910910 & \\\newline\hline Cash at bank & 33,924924 & \\\newline\hline Accumulated fund at 11 January 20232023 & & 29,326303,834 \frac{29,326}{303,834} \\\newline\hline\newline\end{tabular}\newlineADDITIONAL NOTES\newlinei. Bar purchases and sales were on a cash basis. Bar stocks at 3131 December 20232023 were valued at i. £6,410 £ 6,410 .\newlineii. Subscriptions paid in advance by members at 3131 December 20232023 amounted to £1,870 £ 1,870 .\newlineiii. Provide for depreciation of equipment £2,400 £ 2,400 .\newlineYou are required to:\newline(a) Draw up the bar trading account for the year ended 3131 December 20232023.\newline(b) Draw up the income and expenditure account for the year ended 3131 December 20232023, and a balance sheet as at 3131 December 20232023.

Full solution

Q. The following trial balance of The Shire Golf Club was extracted from the books as on 3131 December 20232023:\newline\begin{tabular}{|c|c|c|}\newline\hline 20232023: & Dr & Cr \mathrm{Cr} \\\newline\hline & E & £ £ \\\newline\hline Clubhouse & 142142,000000 & \\\newline\hline Equipment & 1818,600600 & \\\newline\hline Profits from raffles & & 66,508508 \\\newline\hline Subscriptions received & & \\\newline\hline Wages of bar staff & 2929,200200 & \\\newline\hline Bar stocks 11 January 20232023 & 22,400400 & \\\newline\hline Bar purchases and sales & 4141,300300 & 8484,600600 \\\newline\hline Greenkeepers' wages & 2121,500500 & \\\newline\hline Golf professional's salary & 3737,000000 & \\\newline\hline \checkmark General expenses & 910910 & \\\newline\hline Cash at bank & 33,924924 & \\\newline\hline Accumulated fund at 11 January 20232023 & & 29,326303,834 \frac{29,326}{303,834} \\\newline\hline\newline\end{tabular}\newlineADDITIONAL NOTES\newlinei. Bar purchases and sales were on a cash basis. Bar stocks at 3131 December 20232023 were valued at i. £6,410 £ 6,410 .\newlineii. Subscriptions paid in advance by members at 3131 December 20232023 amounted to £1,870 £ 1,870 .\newlineiii. Provide for depreciation of equipment £2,400 £ 2,400 .\newlineYou are required to:\newline(a) Draw up the bar trading account for the year ended 3131 December 20232023.\newline(b) Draw up the income and expenditure account for the year ended 3131 December 20232023, and a balance sheet as at 3131 December 20232023.
  1. Calculate Opening Stock: Calculate the opening stock for the bar trading account using the given value.\newlineOpening Stock = £2,4002,400
  2. Calculate Total Goods Available: Add bar purchases to the opening stock to find the total goods available for sale.\newlineTotal Goods Available for Sale = Opening Stock + Bar Purchases\newlineTotal Goods Available for Sale = £2,400£2,400 + £41,300£41,300\newlineTotal Goods Available for Sale = £43,700£43,700
  3. Calculate Closing Stock: Calculate the closing stock for the bar trading account using the given value.\newlineClosing Stock = £6,4106,410
  4. Determine Cost of Goods Sold: Determine the cost of goods sold (COGS) for the bar. \newlineCOGS=Total Goods Available for SaleClosing Stock\text{COGS} = \text{Total Goods Available for Sale} - \text{Closing Stock}\newlineCOGS=£43,700£6,410\text{COGS} = £43,700 - £6,410\newlineCOGS=£37,290\text{COGS} = £37,290
  5. Calculate Gross Profit: Calculate the gross profit for the bar by subtracting COGS from bar sales. \newlineGross Profit = Bar Sales - COGS\newlineGross Profit = £84,60084,600 - £37,29037,290\newlineGross Profit = £47,31047,310
  6. Calculate Net Profit: Calculate the net profit for the bar by subtracting expenses from the gross profit.\newlineNet Profit = Gross Profit - Wages of Bar Staff\newlineNet Profit = £47,310£47,310 - £29,200£29,200\newlineNet Profit = £18,110£18,110
  7. Calculate Total Income: Calculate the total income for the income and expenditure account.\newlineTotal Income = Profits from Raffles + Net Profit from Bar + Subscriptions Received\newlineTotal Income = £6,5086,508 + £18,11018,110 + (Subscriptions Received)