15. Final Project: FreshGo Maharashtra Monthly Report
15.1 Project Brief and Data
Brief. FreshGo and MarketRush (fictional data) want one monthly report for Ganeshotsav month, September 2026, covering the six cities. The report is for Ravindra Bagale (regional lead) and the six city managers. It must answer:
- What were Net Sales, Delivered Orders, AOV and Cancellation Rate for the month?
- Which city and which area contributed most? Which is below target?
- How did daily sales move during Ganeshotsav (festival spike expected from 14-09-2026, the start of the festival in this fictional data)?
- Which categories (Dairy, Fruits, Sweets, Pooja Items, Snacks…) sold most per city?
- Are deliveries within the 12-minute promise in every city?
Input files (you create them with fictional rows):
| File / sheet | Rows (suggested) | Columns |
|---|---|---|
Raw_Orders |
300–500 | Order ID, Order Date, City, Area, Store ID, Product, Qty, Amount, Delivery Mins, Status, Customer, Phone |
Stores |
12 (2 per city) | Store ID, Platform, City, Area, City Manager, Manager Email |
Products |
25 | Product, Category, Unit Price |
Targets |
6 | City, Monthly target |
About this data: Teaching sample for a fictional shop “NovaCraft Tools”. Figures and names (e.g. Sana Sheikh) are made up for this lesson on project brief and data.
Use only these people: Ravindra Bagale, Shraddha Bagale, Ruhi Bagale, Shahrukh, Amir, Salman, Zoya, Ravina, Raja, Rani, with @example.com e-mails. Areas: Pune (Kothrud, Hinjewadi, Baner, Hadapsar, Wakad), Nashik (College Road, Gangapur Road), Nagpur (Dharampeth, Sitabuldi), Kolhapur (Rajarampuri, Tarabai Park), Solapur (Hotgi Road, Murarji Peth), Sambhaji Nagar (CIDCO, Nirala Bazar).
Steps to prepare the raw data (deliberately messy)
- Type or generate the rows; then damage about 10% of them on purpose: extra spaces, "pune/PUNE", "Aurangabad" for Sambhaji Nagar, text amounts like "Rs. 450", US-style dates, 5–8 duplicate rows, a few blank Delivery Mins, phone numbers with +91 and spaces.
- Keep a copy of this untouched sheet as
Raw_Ordersand never edit it. - Write the five questions above on a
Notessheet with KPI definitions (Module 13.1).
Worked example – a few raw rows.
| Order ID | Order Date | City | Amount | Status |
|---|---|---|---|---|
| blk-9001 | 14-09-2026 | pune | Rs. 450 | delivered |
| BLK-9002 | 09/14/2026 | Aurangabad | 1,299 | Delivered |
| BLK-9001 | 14-09-2026 | pune | Rs. 450 | delivered |
About this data: Demo table only — not real customer or company data. Built to practise project brief and data.
Ravindra Bagale's Tip
Many students take already-clean data for their project – then in the interview they have no answer to "what challenges did you face?" Deliberately create messy data and write down every problem and its fix on a Notes sheet. That is the real "story" of your project.
Ravindra Bagale's Tip – मराठी
बरेच students project साठी आधीच clean data घेतात – मग interview मध्ये "what challenges did you face?" ला काहीच उत्तर नसतं. मुद्दाम messy data बनवा आणि प्रत्येक problem आणि त्याचा fix Notes sheet वर लिहून ठेवा. हीच तुमच्या project ची खरी "story" असते.
Ravindra Bagale's Tip – हिंदी
बहुत से students project के लिए पहले से clean data ले लेते हैं – फिर interview में "what challenges did you face?" का कोई जवाब नहीं होता. जानबूझकर messy data बनाओ और हर problem और उसका fix Notes sheet पर लिखकर रखो. यही तुम्हारे project की असली "story" होती है.
Worked example — project brief and data
Why
Rohan Patil in Pune and James O'Neill abroad both need a clear, repeatable way to use project brief and data on a Pearl Textiles sheet without breaking totals.
What
Project Brief And Data is the Excel idea this page teaches. We will walk one tiny example end to end.
How
- Open a blank sheet. In A1 type a short label for project brief and data.
- Enter a small made-up value for Rohan Patil using € where money appears.
- Add a second value for James O'Neill using £ so you see mixed currencies stay numeric.
- Apply the method from this lesson step by step (menu or formula as shown above).
- Check the result still works inside SUM or a simple check cell.
Formula / action
Follow the formula or ribbon steps shown in this lesson (keep values numeric).Meaning: Once project brief and data is correct on one row, copy the same pattern down the column.
Practice tasks (10+)
Try these on a blank sheet. Open a hint only if you are stuck. No quiz — just practice.
1. Rebuild the smallest example of project brief and data on a blank sheet for HomeNest Supplies.
Hint: Use only the steps on this page. Keep numbers numeric.
2. Change one input for Vikram Rao and confirm the result updates.
Hint: If the result is stuck, check absolute vs relative references.
3. Repeat the same steps with a £ or € value for Carlos Rivera.
Hint: Formatting must not break SUM.
4. Write the result meaning in one plain sentence next to the cell.
Hint: Imagine explaining it to a new joiners.
5. Add a second row and fill the method down.
Hint: Double-click the fill handle if the pattern is consistent.
6. Break the example on purpose, then fix it using this lesson.
Hint: Common break: text instead of a number.
7. Apply project brief and data to a 5-row made-up HomeNest Supplies table.
Hint: Keep column headers clear.
8. Check your answer with a simple total or COUNT.
Hint: A wrong total usually means a format or key mismatch.
9. Swap ₹ and $ on one column and re-check totals.
Hint: Stored values stay the same; only the display changes.
10. List two mistakes beginners make with project brief and data.
Hint: Look back at the tip box on this page.
11. Teach the steps out loud in under one minute.
Hint: Why → What → How.
12. Save the sheet as HomeNestSup_practice.xlsx.
Hint: Use a clear file name for class.
Quick revision cards
Three standalone cards. Each one explains the idea with its own example. Scan the QR to open this lesson.
