Capstone · Week 8
Inventory Planning
Implement FIFO and LIFO logic for at least three purchase and sales lots. Show turnover and days on hand.
Use the capstone Rubrics to guide quality.
What to include
Logic and KPIs
- FIFO/LIFO process with clear steps.
- COGS and ending inventory calculation.
- KPIs: inventory turnover and days on hand.
- Short note: risk of stockouts or excess stock.
Excel Requirements
Track lots; compute COGS and ending stock
- Inventory log: date, action (purchase/sale), qty, unit cost (for purchases), and notes.
- Create a lot tracker: for FIFO, consume oldest lots first; for LIFO, newest first.
- Compute COGS and ending inventory value for each method.
- KPIs: turnover = COGS ÷ average inventory; days on hand = 365 ÷ turnover.
Quality Checks
Transparent, step‑by‑step logic
- COGS and ending inventory match the lot movements.
- Method toggle (FIFO/LIFO) updates all dependent totals.
- KPIs use correct period and units; labels are clear.
Submission
What to turn in
- Excel file with log, lot tracker, COGS/ending inventory, and KPIs.
- Short note (3–5 sentences) on inventory risks and mitigation ideas.