Performance Indicators
jessbill3
Registered Posts: 17
Scenario 1;
Sales Volume (units) 120,000
Revenue £1,680,000
Gross Profit £600,000
Profit from operations £275,000
Net Assets £2,298,400
Inventory £147,950
Scenario 2;
Sales Volume (units) 150,000
Revenue £1,800,000
Gross Profit £450,000
Profit from operations £200,000
Net Assets £2,100,340
Inventory £167,500
Please can somebody provide the formula and calculation to the following for each scenario;
Inventory holding period in days?
Full Production cost per unit?
Sales Volume (units) 120,000
Revenue £1,680,000
Gross Profit £600,000
Profit from operations £275,000
Net Assets £2,298,400
Inventory £147,950
Scenario 2;
Sales Volume (units) 150,000
Revenue £1,800,000
Gross Profit £450,000
Profit from operations £200,000
Net Assets £2,100,340
Inventory £167,500
Please can somebody provide the formula and calculation to the following for each scenario;
Inventory holding period in days?
Full Production cost per unit?
0
Comments

Inventory Holding Period
Formula
Closing Inventory Value x 365
Cost of Sales Value
Scenario 1£147,950 x 365
(£1,680,000  £600,000)
Scenario 2£167,500 x 365
(£1,800,000  £450,000)0 
Full Production Cost per unit
FormulaRevenue  Profit from Operations
Sales Volume
Scenario 1£1,680,000  £275,000
120,000 units
Scenario 2£1,800,000  £200,000
150,000 units0 
I hope the above helps:
We like to know what the inventory is worth in terms of the cost of sales. In scenario 1 we have £147,950 of inventory (this would be finished goods)
As the total cost of the inventory sold (cost of sales) was £1,080,00 over a year this means our inventory is equivalent to 13.7% of the cost of sales. By multiplying this by 365 (days in a year) we can see that are holding inventory worth as much as 50 days sales.
We know that profit from operations is the value left after all the operating costs have been deducted from the revenue. So we can reverse the calculation and find operating costs by deducting the profit from operations from the revenue.
The cost per unit is total operating costs divided by the number of units produced.
In the case of Scenario 1 £1,405,000/120,000 units = £11.71 to the nearest whole pence
I hope this has been useful
If you would like to show your appreciation in the form of a donation to charity, please consider this donation page on the Cancer Research UK website. The money raised so far is being used to try to find cures for cancer. Whenever I see researchers from the specialist research unit in Southampton they tell me of new treatments and other breakthroughs they have achieved. The donations really help.
http://relay.cancerresearchuk.org/site/TR/RelayForLife/General?team_id=6827&pg=team&fr_id=1481
[email protected]
www.sandyhood.com0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 18.9K For AAT students
 248 NEW! Qualifications 2022
 138 General Qualifications 2022 discussion
 8 AAT Level 2 Certificate in Accounting
 33 AAT Level 3 Diploma in Accounting
 59 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 274 VAT
 92 Software
 274 Tax
 136 Bookkeeping
 7.3K General accounting discussion
 193 AAT member discussion (AATQB, MAAT, FMAAT and AAT Licensed Accountants and Bookkeepers)
 3.8K For everyone
 39 AAT news and announcements
 352 Feedback for AAT
 2.8K Chat and offtopic discussion
 589 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