Question
OfficeSupplies Ltd. uses a periodic inventory system. It entered into the following transactions for May: Date Description Units Acquired at Cost Units Sold at Retail
OfficeSupplies Ltd. uses a periodic inventory system. It entered into the following transactions for May:
Date | Description | Units Acquired at Cost | Units Sold at Retail |
May 1 | Beginning Inventory | 200 units @ $45 per unit | |
May 7 | Purchase | 500 units @ $48 per unit | |
May 14 | Sale | 450 units @ $75 per unit | |
May 21 | Purchase | 350 units @ $50 per unit | |
May 28 | Sale | 300 units @ $80 per unit |
For specific identification, the May 14 sale consisted of 100 units from beginning inventory and 350 units from the May 7 purchase. The May 28 sale consisted of 150 units from the May 21 purchase and 150 units from the May 7 purchase.
Required:
- Calculate the ending inventory and COGS using FIFO and LIFO methods.
- Determine the gross profit for May using the weighted average cost method.
- Assess the financial impact of each inventory costing method on OfficeSupplies Ltd.'s net income.
- Provide strategic recommendations for inventory management based on the financial analysis.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started