Inventory Management Study for a Local Retailer

Added Jul 2026 3 design docs

The neighbourhood grocery store is one of the most efficient businesses in India and one of the least measured. A shopkeeper carrying twelve hundred items knows in his head which brand of atta moves fastest, but not how much money is sleeping on the top shelf in packets nobody has bought since Diwali, and not how often a customer walks out because the one shampoo sachet she wanted was missing. Both losses are invisible, both are large, and both can be fixed with nothing more than a notebook, a few weeks of counting, and the arithmetic that big retail chains run every night.

The intern conducts a full inventory management study of a fictional 900 square foot self-service store called Sunrise Supermart. That means building an SKU master for sixty tracked items across four categories, keeping a twenty-one day movement log, auditing shelf gaps twice a day to measure stockouts, running a short exit survey of thirty shoppers in google-forms on what they could not find, classifying every tracked item by sales value and demand variability in excel, computing reorder points, safety stock, and economic order quantities from real supplier lead times, valuing the dead stock, and writing a one-page bilingual reorder policy card in google-docs that a shopkeeper could pin beside the till and use tomorrow.

The project builds exactly the analytical muscle retail, supply chain, and category management roles hire for: demand measurement, ABC and XYZ classification, safety stock logic, order quantity trade-offs, and the discipline of turning three weeks of counting into a policy someone will actually follow. A study that names the rupees tied up in dead stock and the sales lost to empty shelves is a portfolio piece that survives any interview question about whether you can work with real operating data.

Related projects

Cafe and Cloud Kitchen Operations Study

A neighbourhood café and a delivery-only cloud kitchen can sell the same sandwich at the same price and end the month with completely different bank balances. One pays rent for twenty-four seats and a barista who is idle from three to six in the afternoon; the other pays a commission on every order and lives or dies by how fast food leaves the counter after a rider arrives. Owners of both feel the pressure daily, yet almost none of them have ever timed an order, costed a recipe, or worked out which menu items quietly lose money on every sale. The intern runs a comparative operations study of two fictional small food businesses, a twenty-four seat café called Kettle and Crumb and a delivery-only kitchen called Tandoor Tales, using observation rather than opinion. That means six timed site visits with a stopwatch log of forty orders from placement to service, activity sampling of what staff actually do minute by minute, a five-day wastage tally, a hundred public delivery-app reviews coded into complaint categories, a menu engineering matrix in excel that sorts twelve items by popularity and contribution margin, a peak-hour capacity model that names the bottleneck station, three swimlane process maps drawn in canva, and a pack of standard operating procedures written in google-docs. The project teaches the core toolkit of operations management: process mapping, cycle-time analysis, bottleneck thinking, contribution margin, capacity planning, and turning messy observation into a costed recommendation an owner can act on this week. Operations, supply chain, retail, and quick-service roles all interview on exactly this ground, and a study that names a bottleneck and quantifies the fix reads far stronger than a summer spent shadowing a manager.

managementcanvaexcelgoogle-docs

PRD · HLD · LLD includedView

BusinessMedium

Franchise Expansion Feasibility Report

Every successful neighbourhood café, salon or tuition centre in India eventually hears the same suggestion: franchise it. The idea is seductive because someone else brings the capital, but the graveyard of Indian franchise brands is full of chains that expanded on enthusiasm and collapsed on arithmetic. A single outlet in the wrong locality, signed with a partner who cannot fund the first six months of losses, can burn more brand equity than five good outlets build. Deciding whether to franchise, where, with whom and on what terms is a feasibility question, and it is answered with a report, not a gut call. The intern produces that report for Chai Theory, a fictional Pune café chain with six company-owned outlets and ₹4.2 crore in annual revenue, which is evaluating franchise entry into three Tier-2 cities. The work includes a weighted city scoring model comparing Nashik, Nagpur and Indore across ten indicators drawn from census and public municipal data, a full unit economics model in excel covering both company-owned and franchise-owned formats with break-even month, payback period and return on investment, a two-way sensitivity table stress-testing footfall and rent, a 12-point site selection scorecard applied to three shortlisted high-streets from actual field visits, an ideal franchisee profile with a screening questionnaire built in google-forms, a royalty and fee structure benchmarked against at least six publicly advertised Indian franchise opportunities, and a risk register. The whole thing lands as an 18 to 24 page feasibility report with a phased go or no-go recommendation, plus a 12 to 14 slide board deck in powerpoint. This is the work that consulting analysts, business development associates and family-business successors do in their first year. The intern comes away able to build unit economics from scratch, defend a location choice with data, structure a partnership commercially, and write the one thing decision makers actually read: a recommendation that says yes, no or not yet, and shows exactly which number would change the answer.

managementexcelgoogle-formspowerpoint

PRD · HLD · LLD includedView

BusinessMedium

Pricing Strategy Analysis

Most small Indian service businesses set their price once, at launch, by copying the shop across the road, and then never revisit it. A self-study hall in Mukherjee Nagar charging one flat monthly rate is a clean example of the damage: the aspirant who arrives at six in the morning and leaves at eleven at night pays exactly what the student who drops in twice a week pays, and nobody can say whether the rate is too high, too low, or accidentally correct. Because a price change costs almost nothing to implement and flows straight to the bottom line, pricing is the highest-leverage decision such a business can reopen. The intern runs a full pricing analysis for Studyloft, a fictional 120-seat study hall near Mukherjee Nagar in Delhi that charges a flat ₹2,500 a month and barely clears its costs. They rebuild the cost structure and break-even occupancy in excel, benchmark 20 competing study halls on publicly listed rates and features, run a van Westendorp price sensitivity survey through google-forms with at least 80 exam aspirants, model a three-tier price architecture with contribution margins and a price-versus-occupancy sensitivity grid, and present the recommendation as a 16-to-20 page analysis in google-docs plus a 12-to-14 slide decision deck in powerpoint. The project builds cost accounting, willingness-to-pay research, price architecture design, sensitivity analysis, and the harder skill of naming a number and defending it under questioning. Pricing work is rare on a fresher's resume and immediately recognisable to interviewers in consulting, category management, and revenue roles, because it demands quantitative discipline and commercial judgement at the same time.

business-developmentexcelgoogle-docsgoogle-forms+1

PRD · HLD · LLD includedView