Practice exam 1 - Question 7 d) calculating Inventory Holding Period
philreddy1985
Registered Posts: 23
I am wondering if someone could give me some help with a question from the MDCL practice exam 1 please.
The formula I am given in my textbook for calculating Inventory Days is:-
Inventories/Cost Of sales x 365
I can understand this ratio when using the simple example provided in my textbook (all figures are already provided) but when I am trying to apply this ratio to the exam question I am becoming lost.
What is meant by 'Inventories'? Does this mean Opening + Purchases - Closing Inv?
How am I calculating cost of sales? Is it Revenue - Purchases or Payables?
The question is as follows:-
Revenue - 1,350,400
Opening Inv -122,658
Purchases - 849,200
Closing Inv - 110,000
Receivables - 369, 973
Payables - 118, 063
Calculate the Inventory Holding Period in days.
The formula I am given in my textbook for calculating Inventory Days is:-
Inventories/Cost Of sales x 365
I can understand this ratio when using the simple example provided in my textbook (all figures are already provided) but when I am trying to apply this ratio to the exam question I am becoming lost.
What is meant by 'Inventories'? Does this mean Opening + Purchases - Closing Inv?
How am I calculating cost of sales? Is it Revenue - Purchases or Payables?
The question is as follows:-
Revenue - 1,350,400
Opening Inv -122,658
Purchases - 849,200
Closing Inv - 110,000
Receivables - 369, 973
Payables - 118, 063
Calculate the Inventory Holding Period in days.
0
Comments
-
Opening inventory + Purchases - Closing inventory is COST OF SALES, not Inventories. I expect you knew that.
One question remains, for "Inventories". Should you use the average (of opening and closing) or the closing inventory? Average is theoretically better but see if your textbook suggests which to use.0 -
Hello Peter,
Thank you for your response, the textbook I am using just states Inventories / COS x 365
It does not say whether this is Opening/Closing or the average.
I am suitably confused as this equation is only afforded half a page in my textbook with no further explanation given.
0 -
Having looked in the Kaplan AAT textbook, I see that they recommend using the average if possible, but they point out that you are sometimes only given one value for inventory (which makes it easier).0
-
I have managed to reach the correct answer by using the average inventory value and dividing this by the COS x 365.
116329 / (COS) 861858 x 365 = 49
Thank you for your help.0 -
You're welcome0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 18.9K For AAT students
- 259 NEW! Qualifications 2022
- 146 General Qualifications 2022 discussion
- 9 AAT Level 2 Certificate in Accounting
- 37 AAT Level 3 Diploma in Accounting
- 64 AAT Level 4 Diploma in Professional Accounting
- 8.9K For accounting professionals
- 23 coronavirus (Covid-19)
- 274 VAT
- 92 Software
- 274 Tax
- 137 Bookkeeping
- 7.3K General accounting discussion
- 193 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 352 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 590 Job postings
- 17 Who can benefit from AAT?
- 36 Where can AAT take me?
- 44 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 65 AAT membership