Document 1Extract
Stock card at 1 January 20X1
Stock card at 1 January 20X1, L40 lamps: 2,000 units at a unit cost of 12, i.e. 24,000.
Cases
Practical case
Lumivia Distribution SAS (a fictitious entity) buys and resells L40 model LED lamps, all of the same nature and use. It imports its lamps from a foreign manufacturer and stores them in its Lyon warehouse before delivering them to DIY stores. You are preparing the financial statements for the year ended 31 December 20X1.
Your assignment
Calculate the cost of purchase of the lot received on 15 March 20X1 and record the entry for its receipt into inventories. Then calculate the cost of sales and closing inventories using first-in, first-out (FIFO) and using the weighted average cost, select the formula required by the entity's accounting policy, reconcile the cost of sales, record the corresponding entry and measure the impact on the financial statements.
Work on this file as you would in practice: read the situation, open the documents, sort the useful information, then carry out the work requested. The solution is revealed once you submit.
Fundamental level: the method, help and references are shown.
Method
File checklist
5 documents: open each one to read it.
Document 1Extract
Stock card at 1 January 20X1, L40 lamps: 2,000 units at a unit cost of 12, i.e. 24,000.
The figures of the documents, gathered for your work.
| Item | Value | Found in |
|---|---|---|
| Opening quantity in stock | 2,000 units | |
| Unit cost of opening inventories | €12.00 | |
| Opening inventories | €24,000.00 | |
| Quantity received on 15 March 20X1 | 8,000 units | |
| Gross purchase price | €115,000.00 | |
| Trade discount | €5,750.00 | |
| Import duties | €4,600.00 | |
| Recoverable VAT paid on import | €23,200.00 | |
| Transport and handling to the warehouse | €2,150.00 | |
| Quantity sold in 20X1 | 7,000 units | |
| Delivery costs to customers | €1,800.00 |
Not every document matters: identify those that affect the accounting treatment.
Part 1 · Classification · Analysis
Sort each document: does it affect the accounting treatment?
Drag each item into its category, or tap the category under the item.
Stock card at 1 January 20X1
Supplier's invoice
Customs declaration and forwarding agent's invoice
Sales register 20X1
Accounting policy memo
8 tasks in the order of the file. Calculations, entries and effects on the financial statements are marked; written answers are self-assessed against the solution.
Task 1Calculation
Calculate the cost of purchase of the lot received on 15 March 20X1.
Start from the data in the pieces, set the formula, check the unit and the order of magnitude.
Part 1 · Calculation
Calculate the cost of purchase of the lot received on 15 March 20X1.
Task 2Journal entries
Record the entry for the receipt of the lot into inventories.
Identify the accounts affected and the direction of each movement; check the balance.
Part 1 · Journal entry · Journal entries
Entry 1 of 1
One line = one account and one side. Add a line if the entry needs more; the balance check updates live.
Line 1
Line 2
Line 3
Line 4
Task 3Calculation
Calculate the cost of sales and closing inventories using FIFO and using the weighted average cost.
Start from the data in the pieces, set the formula, check the unit and the order of magnitude.
Part 1 · Calculation
Calculate the cost of sales and closing inventories using FIFO and using the weighted average cost.
Result: Closing inventories under the weighted average cost
Task 4Analysis
Which cost formula do you apply and what do you answer the sales director?
Set out the facts, the question raised, then your analysis.
This answer is not marked automatically: after submitting, you will compare it with the solution.
Task 5Calculation
Reconcile the cost of sales from opening inventories, purchases and closing inventories.
Start from the data in the pieces, set the formula, check the unit and the order of magnitude.
Part 1 · Calculation
Reconcile the cost of sales from opening inventories, purchases and closing inventories.
Task 6Journal entries
Record the cost of sales entry for 20X1.
Identify the accounts affected and the direction of each movement; check the balance.
Part 1 · Journal entry · Journal entries
Entry 1 of 1
One line = one account and one side. Add a line if the entry needs more; the balance check updates live.
Line 1
Line 2
Task 7Effects on the financial statements
What is the impact of these entries on the financial statements?
For each financial statement, state the line affected, the direction and the amount.
Part 1 · Classification · Analysis
State the direction of the effect on each financial statement aggregate.
Financial position (balance sheet)
Profit or loss
Other comprehensive income
Equity
Part 2 · Calculation · Analysis
Quantify the effect on the aggregates concerned.
Result: Amount of the effect — Equity
Task 8Conclusion
Write the conclusion.
Write a conclusion that cites the facts and the treatment chosen.
This answer is not marked automatically: after submitting, you will compare it with the solution.
Your working draft for this file: points noted, leads, intermediate calculations.
Saved on this device only; never graded.
Complete every item of the file to submit it (0 / 10).
Document this file
These working papers use the data and results of this case.
Normative references