Gross Profit and Closing Stock calculation problem
Mathew_Hill
Registered Posts: 23 New contributor 🐸
Hi everyone
Just doing a practice exam paper and am having problems calculating the Gross Profit and Closing Stock figures.
The information given is :
From using the above information can someone explain how they would go about calculating the gross profit and closing stock?
Thanks in advance
Matt
Just doing a practice exam paper and am having problems calculating the Gross Profit and Closing Stock figures.
The information given is :
- This is the companys first year of trading (therefore no opening stock)
- Sales 89750
- Payments to trade creditors 59400
- Wages 8105
- General Expenses 7550
- Drawings 11000
- Fixtures 5000
- Value of stock at ened of year is unknown but the profit margin achieved on sales is a third
From using the above information can someone explain how they would go about calculating the gross profit and closing stock?
Thanks in advance
Matt
0
Comments
-
this is incomplete records isnt it...argggh i hate doing this.. id like to know how this would be worked out aswell please0
-
In the example gross profit is third of Sales.
Cost of Sale 2/3
Gross Profit 1/3
Sales 3/3
is Sales= 87750 Gross profit= 87750 x 1/3= 29250
and cost of sales= 87750 x 2/3= 58500
Cost of sales is mad up of:
Opening stock Nil
Purchases 59400
Less closing stock (x)
0+59400- x= 58500
x= 59400-58500
x= 900
closing stock = 900
:confused1: you think its right?0 -
Thanks Agatha
The sales figure is 89,700 as opposed to the 87,700 figure you used.
Did you do anything to the 89,700 figure or was this just a typing error?
I worked through the Closing stock the same as you did but using the 89,700 figure and got a closing stock of -433!
Matt0 -
Hi Matt,
Are you doing the David Nix/ABC Traders exam in the Osborne book?
I've had a quick look at it and calculate the GP to be 31,300 and closing stock is 6,120.
I've calculated as follows:
Cash Account
Cash banked = 89,750
Gen Expenses = 2,150
Wages = 1,900
Closing balance = 100 (this is your cash float)
therefore, sales income must be 89,750 + 2,150 + 1,900 + 100 = 93,900
Gross profit is 1/3 of 93,900 = 31,300, so cost of sales will be 62,600.
Purchases will be 59,400 paid to creditors plus 9,320 creditors outstanding = 68,720
Sales = 93,900
Opening stock 0 + purchases 68720 less cost of sales 62,600 = 6,120 closing stock figure.
I hope this makes it clearer for you.0 -
Hi Matt,
I make it £400 as the closing stock figure based on a figure of £89700 for sales:
you say a profit margin of 1/3 is acheived on sales, therefore -
89700 x 1/3 = a gross profit of £29900
if 1/3 is profit, then the remaining 2/3's must be cost of sales.
from the trading account on the profit and loss account we know:
Sales less Cost of Sales = Gross profit
As a note - Cost of sales is calculated as Opening Stock plus Purhases, Less Closing stock.
so, we have £89700 - 59800 (which is 2/3 x Sales, Cost of Sales ) = £29900 (1/3 x Sales, Gross profit)
So my reasoning as £400 for the closing stock is if total cost of sales is 59800 upon drawing up a total creditors account and using 59400 as the cash to suppliers figure my balancing figure is 59800 - 59400 = 400... which is basically the same as Agatha has done but with the £89700 sales figure......
That's my shot at it, anyone else?
Matt0 -
Ah just looked at Richard's reply, that would make a lot more sense if it's "cash banked" at £89700 rather than actual sales at 89700.... I did wonder why info of expenses paid out was given!0
-
Thanks Richard/Matt
I am indeed doing the David Nix exam!
Could you please explain why general expenses, wages and the cash float were added to the cashed banked figure?
Are general expenses and wages not money going out rather than in?
Cheers,
Matt0 -
The cash account is similar to the bank account in that any payments made are on the credit side, if you think about the double entry the gen expenses and wages accounts will already have been debited. The question states that £100 float is kept in the till, which we will use as our balancing figure. These payments have been taken out of the cash received from sales so need to be added back on to the banked figure (only the cash that remained after expenses was banked).
It may help if you draw up a T account for the cash book - money received on the dr side, payments, bankings and balancing figure on the cr side.0 -
Task 1.6
I'm not sure how to calculate the updated Gross Profit figure, do i include the stolen stock or just the figure given £3650.000 -
I would use the figure given.0
-
Thank you for your help.
:001_smile:0 -
In the example gross profit is third of Sales.
Cost of Sale 2/3
Gross Profit 1/3
Sales 3/3
is Sales= 87750 Gross profit= 87750 x 1/3= 29250
and cost of sales= 87750 x 2/3= 58500
Cost of sales is mad up of:
Opening stock Nil
Purchases 59400
Less closing stock (x)
0+59400- x= 58500
x= 59400-58500
x= 900
closing stock = 900
:confused1: you think its right?
If the figure shown was Purchases from the nominal it would not have VAT in figure but if the figure is taken from the cashbook or Purchase Ledger it will have VAT included.0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 318 NEW! Qualifications 2022
- 161 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 87 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership