Project Setup
Core project identity, currency and the projection horizon.
**Display Figures In** sets one unit for every scaled money figure across the whole report — Revenue, Staff Cost, Non-Staff Cost, Total Wage Bill and Total Manpower Cost (Monthly Production & Revenue and Manpower Summary tables, plus the KPI strip) — so you only pick it once here rather than per table. Food Cost is the one exception and always shows in plain currency, since it's usually too small a number for Lacs/Million/Crores to show without rounding to zero.
Product Assumptions
What you make and what it costs to make it.
Product & Direct Cost
One row per product. Add as many materials as the product needs.
Gross Margin (corrected 2026-09-24) discounts FOB for the channel's own Rejection % above (the same field that drives saleable Output/Revenue in Business Reports → Production & Revenue): Discounted FOB = FOB × (1 − Rejection %); Gross Margin = Discounted FOB − Total Direct Cost; Gross Margin % = Gross Margin ÷ FOB (the full, undiscounted FOB in the denominator). Material Cost, Trims, Common Charges and Total Direct Cost above are all unaffected — it only affects the Gross Margin / Gross Margin % figures shown here, so nothing in Business Reports (which read Total Direct Cost, not Gross Margin, from this section) is affected.
FOB Price Appreciation (Y-o-Y)
One schedule, common to every product — not set per product. Setting a year carries that % forward into every later year until you set a later one — e.g. set Year 3 to 5% and Years 4–5 fill in at 5% too; then set Year 4 to 10% and Years 4–5 become 10% while Year 3 stays at 5%. Held flat from Year 6 onward.
Applied to every product's FOB / Selling Price in the Monthly Production & Revenue calculation: each year's price is the base FOB grown by that year's own %, applied directly — Year 5's price is base × (1 + Year 5's %), not Year 1's escalated price compounded forward through Years 2–5 (corrected 2026-09-24, per direct instruction — appreciation is on the base year, not compounding). Typing into a year automatically fills every later year with the same % (until a later year is itself edited), so you only need to touch the year where the rate actually changes. Year 6 onward reuses Year 5's %, flat.
Production Assumptions
How the factory runs — shift structure, the efficiency ramp, and the line-by-line rollout plan.
Work Parameters
Shift structure and working calendar.
Efficiency Ramp-up
Starts low, climbs by a fixed monthly jump, hard-capped at peak — never crosses it, by decision.
The resulting ramp-up is shown as a report — see Business Reports → Production & Revenue in the right-hand sidebar, not here.
Ladder Plan
Set Number of Lines and Frequency and the matrix builds itself — Line 1 starts on the project start date, each next line follows by the frequency. With 2+ shifts, every shift on a line gets its own row and its own independent ramp. Shift Start Pattern controls when a line's later shifts come online: Parallel (default) starts them the same day as Shift 1 on that line; Sequential gives every line+shift its own place in one continuous start sequence, as if Shift 2 were another set of lines following on from Shift 1.
Product is editable per row. Tailors stays live-synced to Machines / Line (Work Parameters, Section 03, corrected 2026-09-24) — every row tracks that one shared figure automatically, so changing Machines/Line updates every line's Tailors at once; edit a row's own Tailors directly and that row detaches from Machines/Line from then on, staying at whatever you set it to ("later user can edit if required") until you delete and re-add the row. A second shift on the same line inherits the first shift's own Tailors value and sync state. Line Start Date is calculated, not entered — with Shift Start Pattern set to Parallel it follows Project Start Date + (Line − 1) × Frequency (Shift Number plays no part); set to Sequential, it follows Project Start Date + (that row's position in the continuous Line-then-Shift sequence) × Frequency. Efficiency starts at Start Efficiency the month a row comes online, climbs by Jump/Month, capped at Peak Efficiency — same frozen ramp rule as Section 04.
Manpower Assumptions
Operators (Tailors) ramp with the Ladder Plan above. Every other role scales with the number of active lines each month, at the Ratio Per Line it's set to.
Manpower Assumptions
Departments, designations, roles and monthly manpower cost.
| Department | Designation | Type | Level | Standard Salary / Month |
|---|
| Category | Designation | Type | Avg Salary / Month | Ratio / Line | Headcount @ Full Install |
|---|
Absenteeism % (moved here from Production Assumptions, 2026-09-23) currently drives one figure — Business Reports → Production & Revenue's "Total Recruit incl Absenteeism (Operator)" row, = round(Operators ÷ (1 − Absenteeism%)), how many Operators actually need to be on the rolls so the Ladder Plan's own Operators figure still holds after absentees. It does not (yet) change Manpower Monthly Cost, which still costs the raw Operators headcount — flagged in Next Blocks if that should change too. Non-Staff cost (including Operators/Tailors) carries the statutory benefits load; Staff cost does not — matching the master Excel's own formulas. Ratio Per Line is picked from a dropdown as a plain fraction ("1 per Line", "1 per 6 Lines", …) or typed directly as a "# per N Line(s)" split; Headcount @ Full Install is calculated from it as Ratio × Total Installed Lines × Number of Shifts (corrected 2026-09-29 — see below). The role table's Designation dropdown only shows designations under the row's own Department; picking one pulls in its Type and Standard Salary as a starting default, still editable per row. Level uses a generic manufacturing grade scale (Operator through Leadership) — mark anything that doesn't fit as NA. Department Master entries can be renamed in place (✎) — the rename cascades to every linked Designation and Role automatically. Shift multiplier (corrected 2026-09-29, per direct instruction — "when the number of shifts are 2 that the total Non Operators ratio is to be multiplied by 2... it is like 2 independent lines"): every role EXCEPT Operators/Tailors now ramps with active Line-Shifts, not active Lines — with 11 Lines × 2 Shifts both fully running, that's 22, not 11 (shown as its own "Line-Shifts" row in Business Reports → Manpower Summary, right under Active Lines). Operators/Tailors need no such change — each shift already has its own Ladder Plan row and its own Tailors count, so a second shift already added its own headcount correctly before this change. This is naturally time- and Shift-Start-Pattern-aware: under Sequential, a role's headcount only reflects Shift 2's lines once Shift 2 itself has actually started, exactly like Shift 1. Scoped to Manpower only — Rent, Machines Capacity and Fixed Overheads are unaffected by Number of Shifts (a separate, not-yet-scoped request). Excel download/upload uses CSV, which opens directly in Excel — this page can't load an external library to write a native .xlsx file. Manpower Overhead Appreciation (Y-o-Y) — the Year 1..Year 5 box above — escalates every role's Standard Salary and the Tailor/Operator Wage together, one shared schedule for all of them; each year's own % applies directly to the base value (corrected 2026-09-28, was previously compounded year-over-year — see below), and Year 6 onward holds at Year 5's value. Typing into a year fills every later year with the same % until a later year is itself edited (set Year 3 to 5% and Years 4–5 follow at 5%; then set Year 4 to 10% and Years 4–5 become 10% while Year 3 stays at 5%) — same mechanic, and now the exact same non-compounding formula, as the Product Assumptions' FOB Price Appreciation box. Fixed Overheads don't have this yet since that module isn't built (see Next Blocks). Manpower Summary moved to Business Reports (2026-09-24) — the month-wise headcount/cost breakdown and the Headcount Ramp-up chart that used to sit below this table now live in their own report block, Business Reports → Manpower Summary, alongside the other read-only reports (P&L, Cash Flow, Working Capital, etc.), with the same Monthly/Quarterly/Yearly toggle and PDF export those reports offer.
Manpower Subsidy
A flat monthly Revenue subsidy per Non-Staff designation — kept separate from Manpower Assumptions since it flows into Revenue, not Manpower Cost.
Manpower Subsidy
Flat monthly Revenue per Non-Staff designation, for its first N months after that designation is first recruited.
| Category | Designation | # of Associates | Subsidy Rate / Associate / Month |
|---|
Moved out of Manpower Assumptions into its own tab (2026-09-24) so it doesn't mix with manpower cost — this is Revenue, not a Manpower Cost offset: it flows directly into the same top-line Revenue figure used everywhere downstream (P&L, Cash Flow, Working Capital, EBITDA, Investment Appraisal). "Subsidy Applicable Months" is one shared figure applied to every Non-Staff designation listed here, counted from that designation's own first month of active headcount (its recruitment) — not from Project Start Date, and not a single calendar window shared identically across roles' start times. Subsidy Rate / Associate / Month (corrected 2026-09-24) is a per-person rate — the monthly subsidy amount is this rate × that designation's own headcount, pulled automatically each month from the live headcount Manpower Assumptions already computes (not a separate manually-entered associate count). The "Subsidy Rate / Associate / Month (all designations)" field above the table (added 2026-09-24) is a bulk-fill: typing a value there immediately sets every Non-Staff designation's row below to that same rate, as a fast default when all designations should start out equal; each row stays independently editable afterward, so any single designation can still be given a different rate without affecting the others, and the consolidated field itself doesn't keep re-applying — it only fires the moment it's changed. "# of Associates" here shows that designation's headcount at Full Install, for reference — during ramp-up the actual month's own (lower) headcount is what the calculation uses, so the realized monthly subsidy can be less than Rate × this reference figure until the plan is fully ramped. Only Non-Staff designations are listed (Staff roles aren't eligible) — the designation list itself is managed in Manpower Assumptions (Section 07); a role added/removed or switched between Staff/Non-Staff there is reflected here automatically. For transparency, the resulting monthly figure also shows as a "Subsidy Revenue" row in Manpower Assumptions → Manpower Summary, and as "Manpower Subsidy Revenue" under Sales in Business Reports → Profit & Loss Statement's Quarterly/Yearly view.
Financial Assumptions
Working capital cycle, and the cost/financial charge rates applied on top of the core numbers above.
Working Capital Norms
Set each component's cycle in days — drives the working capital calculation once that module is built (see Next Blocks).
| Particulars | Days | UOM |
|---|
Each row is a working-capital component held for the stated number of days — e.g. Fabric (Raw Material) held 35 days, Debtors collected in 45 days, Creditors paid immediately at 0 days. Only the Days column is edited here; Particulars and UOM are fixed. These norms drive the monthly working-capital calculation, which lives in Business Reports → Working Capital.
Cost & Financial Charges (%)
Rates applied on top of FOB / Selling Price and, for Interest, on working capital financing.
Logistics, Bank Charges and Marketing Costs feed straight into every product's Common Charges (Product Assumptions → Product & Direct Cost strip) as a % of that product's own FOB / Selling Price — the same three rates were already used in that calculation, just not editable from anywhere on the page until now; changing them here updates every product's Common Charges and Gross Margin immediately. Interest % feeds the monthly Working Capital calculation below (Section 09) — Interest = Working Capital Requirement × this rate ÷ 12 — which in turn drives the Interest row in the Monthly P&L and Synopsis reports. The earlier flat monthly Subsidy placeholder that used to live here (added 2026-09-23) was removed 2026-09-24 and replaced by the per-designation Manpower Subsidy block, now its own separate "Manpower Subsidy" tab (moved out of Manpower Assumptions the same day), which flows into Revenue everywhere (P&L, Cash Flow, Synopsis) rather than only offsetting Total Manpower Cost in Synopsis.
Fixed Overheads
Recurring factory-level costs, independent of production volume — Rent, Power, DG and Water each get their own section; everything else lives in the generic Other Overheads table.
Rent
Total Built-up Area × Cost per Sq Ft. Sq Ft / Machine is derived for reference.
Total Machines Installed is picked up live from Machines / Line × Number of Lines, both set in Production Assumptions → Work Parameters (Section 03) — this section no longer has its own Machines/Line field, so the machine count stays a single shared figure instead of being entered twice. Sq Ft / Machine and Total Rent Cost / Month update live as Total Area, Cost / Sq Ft, or that shared machine count change. Rent Cost / Machine / Day divides the monthly rent evenly across every installed machine and a 30-day month — the same per-machine/day framing used across every Fixed Overheads category, so they can be compared or summed on a like-for-like basis. Rent is the first Fixed Overheads category — Utilities, Insurance, Depreciation and others can be added the same way once their calculation basis is decided.
Power — Load Calculation
Connected load per piece of equipment, its own diversity factor, and the resulting kW / kVA demand.
| SL | Description | Qty | Rated (W) | Total Load (W) | Total Load (kW) | Diversity % | Load w/ Diversity (kW) | Phase |
|---|
| Fixture | Qty | Watt / Fixture | Total (W) |
|---|
Diversity Factor % is set per row, not one flat rate for every item — reverse-engineering the source load list showed production machines (Sewing, Band Knife, Straight Knife, Fusing) running at 35% diversity, while continuous/utility loads (Iron Tables, Embroidery, Compressors, HVLS Fans, Lighting, Mancooler, RO Plant, Boiler, IT/System) run far higher, 70–90% — a single "@ 35%" applied to everything would undercount the diversified load by nearly half. The LIGHTING row's Total Load (W) is not typed in directly — it's the live sum of the Lighting Breakdown table below, so the two can never drift apart; add or edit fixture rows there and the LIGHTING row updates on its own. Total Demand (kVA) uses the Power Factor above (kW ÷ PF) — for sizing a transformer or DG set, kVA is the number that matters, not kW.
Grid Power Cost — added 2026-09-23, per the instruction to include Power in Manufacturing Overhead: Operating Hours / Day × Total Diversified Load (above) × Cost / Unit (₹/kWh) = Power Cost / Day; × Working Days/Month (Work Parameters → project.days; corrected 2026-09-28 from a hardcoded 30 calendar days, per direct instruction — "it should be multiplied by 25 - working days but not 30") = Power Cost / Month. Operating Hours/Day now auto-follows Shifts (corrected 2026-09-29, per direct instruction — "if it is 1 shift it is 8 hr and 2 shift it is 16 hr - is it being calculated the same way" → "yes pl"): = Number of Shifts (Ladder Plan) × Working Hours/Shift (Work Parameters) — 1 Shift × 8 Hours = 8, 2 Shifts × 8 Hours = 16 — recalculating live whenever either changes, the same "auto until hand-edited" pattern Tailors already uses against Machines/Line; editing Operating Hours/Day directly detaches it from this formula from then on. Cost/Unit remains a placeholder pending your real tariff figure — update once known. This is grid/mains power cost specifically; DG (Section 13) remains the separate diesel-standby cost for when the grid is down.
DG — Standby Power Cost
Diesel burned to cover grid downtime, costed out to a monthly DG power cost.
DG (diesel generator) cost is driven by how much of each day is spent running on diesel rather than grid power. Avg Down Time / Day / Shift (Hours) (relabeled 2026-09-29, per direct instruction — "it is Average down time / Shift - so if two shift multiply by Number of shifts") is now a PER-SHIFT figure — how long the grid is out on a typical day, per shift — × Number of Shifts (Ladder Plan) gives the Down Time / Day (Total) readout above; × Diesel Consumption / Hour (Litres) — the DG's own burn rate — gives Diesel Consumed / Day, and × Diesel Price / Litre gives Diesel Cost / Day. DG Power Cost / Month extends that day rate across Working Days/Month (Work Parameters → project.days; corrected 2026-09-28 from a hardcoded 30 calendar days). DG Cost / Machine / Shift / Day (renamed 2026-09-29, same instruction) divides the daily diesel cost across Total Machines × Number of Shifts, not Total Machines alone — since the daily diesel cost already carries both shifts' downtime, dividing by machine-shifts (not just machines) gives a stable per-machine-per-shift rate that holds regardless of how many shifts run, the same "per Line-Shift" normalization Manpower already uses. All three DG inputs are placeholders pending your real site figures — update once known.
Water Overheads
Drinking/utility water for every associate on site, costed out to a monthly water cost.
Total Associates is picked up live from the Manpower module's own Final Month Headcount (Manpower Summary, Section 07) — the same fully-ramped headcount figure shown on that tab's KPI strip — rather than being entered again here, so Water Overheads always tracks the manpower plan without drifting out of sync (and, since that headcount is itself Shift-aware from Version 106 onward, Water Cost / Day already reflects Number of Shifts before this section does anything further). Litres / Person / Day and Cost / Litre are the two editable inputs: Total Litres / Day = Total Associates × Litres/Person, Water Cost / Day = that × Cost/Litre, Water Cost / Month extends the daily rate across Working Days/Month (Work Parameters → project.days; corrected 2026-09-28 from a hardcoded 30 calendar days). Water Cost / Machine / Shift / Day (renamed 2026-09-29, per direct instruction — "in water it is per mc /day/shift") divides the daily cost across Total Machines × Number of Shifts, not Total Machines alone — the same per-machine-per-shift normalization DG's own Cost/Machine/Shift/Day uses (Version 109), so the two stay directly comparable. Both inputs are placeholders pending your real site figures — update once known.
Other Overheads
A generic table for every remaining Fixed Overhead line item — each row picks its own basis.
| Particulars | Type | Rate | Category | Monthly Cost |
|---|
Every row here picks its own Type, and Rate means something different depending on which: Per Machine / Day / Shift (relabeled 2026-09-29, per direct instruction — "in the other overheads - Rate change from per mc / day / shift") — Rate (₹) × Total Machines × Number of Shifts × Working Days/Month (the "Working Days / Month" field on the Setup tab, `project.days`, seeded at 25 — corrected 2026-09-24 from an earlier hardcoded ×30, and now applied to every Per Machine/Day/Shift row, both Manufacturing and Factory categories alike; NOTE this is a deliberate departure from Rent's own per-machine/day mechanic elsewhere on this tab, which still uses a fixed 30-day month and no Shift multiplier); % of Revenue — Rate (%) × Final Month Revenue (the same peak-month figure shown on the Monthly Production & Revenue tab's KPI strip); Fixed (₹/Month) — Rate itself is the monthly cost, no multiplier, for a line item that's just a flat number every month (the same idea as Rent's own Total Rent Cost/Month, just without a separate Area × Rate breakdown here). % of Revenue and Fixed rows are unaffected by Number of Shifts — only Per Machine/Day/Shift rows scale with it, the same per-machine-per-shift normalization DG and Water use (Version 109). Seeded from your own pasted figures: R&M, Stores & Spares, IT Expenses, Audit Fees/Professional Fees, Printing & Stationery, and Staff Welfare/Admin/Medical Charges as Per Machine/Day/Shift (originally verified against your worked totals at 45 machines on a 30-day, 1-shift basis — e.g. 3 × 45 × 30 = 4,050 — now recomputed on a Working Days/Month basis, and scaling with Number of Shifts, instead); Insurance, Sampling Cost and Marketing Overhead Cost as % of Revenue (verified against your worked totals at a ₹531,900 revenue base — e.g. 1% × 531,900 = 5,319). R&M was moved here from its own dedicated section (previously Section 15 on its own) now that this generic table exists — one mechanism instead of a new bespoke section per item. Not yet included: Land Lease/Rent (1115 → 289,900 doesn't reconcile as Per Machine/Day/Shift at 45 machines, % of Revenue at this base, or a plain Fixed monthly figure — flagged, needs the actual formula), Manufacturing Overhead and Common (look like group-subtotal headers in your paste, not their own line items), and O&M Charges (no value was given). Rows can be added or removed freely.
Capex Assumptions
Itemized machinery & equipment schedule, multi-currency pricing, and straight-line Depreciation — feeds the Business Reports → Monthly P&L's Depreciation row and Investment Appraisal's Total Investment.
Currency Conversion Rates
₹ per unit of foreign currency — edit these and every item priced in that currency reprices live.
Only used by items in the table below whose Currency isn't INR. Defaults are the rates implied by your own original quotation (e.g. the Martin fusing machine's €25,300 vs. its own ₹21,50,500 ⇒ ₹85/€), so nothing changes until you edit a rate here.
Capex & Depreciation
Straight-line, per category — each category has its own Asset Class & Useful Life.
| S.No. | Machine Type | Model / Reference | Qty | Currency | Rate (per unit) | Tax % | Amount (₹) |
|---|
Capex by Asset Class (₹ in Cr.)
Seeded from your own pasted machinery/equipment quotation (all five Sewing sub-groups — Single Needle Lock Stitch, Overlock, Flat Lock, Bottom Hem, Other Machines — clubbed into one "Sewing Machines" category, no sub-headers; Cutting Section stays its own separate category, per your instruction), with Machine Type and Model/Reference as separate columns. Every field is editable and you can add or remove items and whole categories with the buttons below each group. Amount = Qty × Rate × FX Rate × (1 + Tax % ÷ 100) — always a formula, never a typed-in total; for the Sewing Machinery and Martin/Barudan rows, Rate is the ORIGINAL foreign-currency unit price from your paste (USD/EUR/JPY), converted live via the Currency Conversion Rates above, rather than a fixed pre-converted ₹ figure. Tax % defaults to 0 (a placeholder, same convention as every other not-yet-quantified input here) and, per your instruction, is included in the Amount that's capitalized — it flows into Total Capex, Monthly Depreciation and Investment Appraisal's Total Investment. Two corrections from your paste, per your own answers: Lab Equipments uses the sum of its own line items (₹18.22 lakh) rather than the Summary section's ₹3.45 lakh, which didn't match its own rows; and the Summary's separate "Furniture" line (₹65.67 lakh) is treated as already included in "Accessories & Furnitures" above it, not added again, even though the two figures don't exactly match — flagged in the decision log. Depreciation (added 2026-09-24): each category above carries its own Asset Class and Depreciation (Years) in its header row — Plant & Machinery defaults to 20 years, Vehicle/Furniture & Fixture/Office Equipment/IT Assets to 10, Approvals/Wages to 1, per your own schedule; changing the Asset Class re-seeds the default years for that category, and the years figure itself stays independently editable. Each category's Monthly Depreciation = its own Amount ÷ its own Years ÷ 12 (straight-line), summed into the Total Monthly Depreciation below — replacing the earlier single blanket Useful Life applied to all of Capex. Existing categories were mapped onto asset classes by best fit (e.g. Sewing Machines/Cutting Section/Lab Equipments/Utilities/Embroidery → Plant & Machinery, Accessories & Furnitures → Furniture & Fixture, Miscellaneous → Office Equipment) — reassign any category's class if a better fit applies. A fuller Capex schedule (phased additions over time, WDV as an alternative to straight-line) remains a Next Block.
Bulk Upload
Download the current table as a CSV, edit it in Excel, and upload it back — or paste rows to add many items at once.
One item per line, fields separated by Tab (pasted straight from Excel) or comma (CSV), in this order: Category, Machine Type, Model/Reference, Qty, Currency, Rate, Tax %, Item ID (Item ID is optional and only present in a downloaded file). Currency must be one of INR/USD/EUR/JPY (defaults to INR if left blank or unrecognized); Tax % defaults to 0 if left blank. Download CSV exports every item currently in the table above (with its own Item ID) — doubles as a template (correct headers) and as a working copy already filled with today's data. Uploading that file back updates each row that carries a recognized Item ID in place (including moving it to a different category, if you changed that column) rather than adding a duplicate; a row with a blank/unrecognized Item ID, or a name-only paste with no Item ID column at all, is simply added as a new item — matched to an existing category by name (case-insensitive) or creating a new one. The first line is skipped automatically if it looks like a header (starts with "Category").
Next Blocks — Waiting on Your Decisions
Nothing below is guessed at. Each one needs a call from you before it gets built.
- Absenteeism impact on cost — now used for the Total Recruit incl Absenteeism (Operator) figure in Business Reports → Production & Revenue, matching the Excel's own "inflates recruit headcount" role — but Manpower Monthly Cost still costs the raw Operators headcount, not the absenteeism-adjusted recruit number. Flag if the wage bill should switch to the recruit figure instead.
- Fixed Overheads — remaining categories — Rent is now captured under Fixed Overheads (Module 5); Utilities, Insurance, Depreciation and other indirect-cost categories aren't built yet. The module as a whole will also want an Appreciation % (Y-o-Y, capped Yr 5), same mechanic as Product FOB and Manpower Overhead escalation above, plus a rolled-up Total Fixed Overheads/Month once more than one category exists.
- Working Capital — funding split — the monthly working-capital calculation (investment tied up per component, Net Working Capital, Interest) is now built under Financial Assumptions, Section 09, and feeds Interest in the Monthly P&L/Synopsis reports. Not yet modeled: the funding split (bank borrowing vs. own margin money) and the cash conversion cycle as its own metric.
- P&L, Cash Flow, Investment Appraisal, Synopsis — the executive outputs, once the above are frozen.
Production & Revenue
Lines/Shifts/Operators ramp-up, output, mins utilization and revenue by sales channel and product — driven entirely by the assumptions on the left. Nothing here is editable.
Ladder Plan — Efficiency by Line
Consolidated Efficiency — Average of Active Lines
Average efficiency across only the lines already active (started) that month — a line not yet on the Ladder Plan is excluded from the average, not counted as 0%. Dips each time a fresh line joins at Start Efficiency, then climbs back as it ramps.
Active Lines per Month
Output & Revenue Trend
Export vs Domestic Output Split
Number of Lines / Operators break down by Shift only when Number of Shifts > 1 (Ladder Plan); with 1 shift the Shift 1 row simply repeats its parent. Total Recruit incl Absenteeism (Operator) = round(Operators ÷ (1 − Absenteeism%)) — Absenteeism% lives in Manpower Assumptions. Pieces Per Machine = Output/Day ÷ Total Recruit (labeled "per Machine" to match the source sheet — it's really per recruited Operator, one operator per machine). Export/Domestic rows are output pieces (pre-rejection), split by which channel each Ladder Plan line was on that month (Work Parameters → # Months on Domestic); Revenue rows are the same split, at each channel's own escalated FOB. Revenue here is shown in plain base-currency figures (not the Display Unit scaling used in the KPI strip), since this is a detailed monthly breakdown.
Profit & Loss Statement
Contribution statement down to EBITDA and PBT, plus per-piece and per-machine-shift cost metrics — driven entirely by the assumptions on the left. Nothing here is editable.
Margin Trend
Cost Structure (% of Revenue)
Direct Cost = Fabric + Trims & Accessories + Marketing + Logistics (Export) + Bank Charges, all from Product Assumptions' per-piece Common Charges. Fabric and Trims (corrected 2026-09-24, per direct instruction — "since this is a rejection - we should not discount here") are summed across every piece PRODUCED that month (gross Output, before Rejection %), since fabric is cut and trims are consumed for every piece made, rejected or not. Marketing, Logistics and Bank Charges (corrected 2026-09-24, then explicitly reversed the same day — "Logistics is Simply revenue * Logistics % - same way Bank charges is Revenue * Bank charges %") are each that month's own Revenue (saleable pieces × the FOB-Appreciation-escalated price — the same figure the Revenue row itself shows) × their own %, i.e. they DO scale down with Rejection %, unlike Fabric/Trims. Total Contribution = Revenue − Direct Cost. Manufacturing Overhead = DG + Water + Grid Power (Fixed Overheads, Module 5) + whichever Other Overheads rows are tagged "Manufacturing" (R&M, Stores & Spares, Manufacturing Overhead by default). Factory Overhead = Rent + whichever Other Overheads rows are tagged "Factory" (everything else) — both tags are set per row in the Other Overheads table (Section 15). Total Overhead = Total Manpower Cost + Manufacturing Overhead + Factory Overhead. Cost per Machine Shift figures divide by (Active Machines × Working Days/Month) — Active Machines = Active Lines × Machines/Line for that month, Working Days/Month from Work Parameters. Depreciation is straight-line from the Capex & Depreciation block (Capex Assumptions) — 0 until a Total Capex figure is entered. Interest is pulled from the monthly Working Capital calculation (Financial Assumptions, Section 09) — Working Capital Requirement × Interest % ÷ 12. COGS/pc = (Manpower + Manufacturing OH + Factory OH + Depreciation + Fabric + Trims) ÷ Output — Logistics/Bank/Marketing are treated as period/selling costs, not product cost, so they're excluded here; Conversion Cost/pc = COGS/pc − Fabric & Trims Cost/pc. Monthly/Quarterly/Yearly view (added 2026-09-24): Monthly is this same table exactly as always; Quarterly and Yearly roll up to one column per quarter/year (absolute figures summed, ratios recomputed from the summed totals, Lines/Machines/Efficiency simple-averaged) and add the productivity rows the former standalone "Synopsis" report used to show (Staff/Non-Staff cost split, per-minute and per-machine-shift figures) — Synopsis itself is retired as a separate report, folded into this one.
Working Capital
Working-capital investment by component, Net Working Capital, and the Interest it drives in the P&L report — driven entirely by the norms in Financial Assumptions. Nothing here is editable.
Working Capital Requirement & Interest
Net Current Assets Components
Built from your own pasted reference. Each inventory-type row = (that row's own monthly cost base ÷ 30, average calendar days in a month) × its own Days norm (Financial Assumptions → Working Capital Norms, Section 09) — e.g. Fabric (Raw Material) = Fabric Cost that month ÷ 30 × 35. Note (2026-09-28, per direct instruction): Working Capital uses a fixed 30-day calendar-month basis, not Working Days/Month — unlike Fixed Overheads (DG/Grid Power/Water), which use Working Days/Month since those costs only accrue on days the factory runs, WC norms track real calendar time inventory/debtors/creditors are held/outstanding. Cost bases, per your own instructions: Fabric → that month's Total Fabric Cost; Trims & Accessories → Total Trims Cost; Work In Process → Fabric + Trims Cost; Finished Goods (at Variable) and Finished Goods In Transit + Buyers Credit (at Cost of Prod) → both use full COGS (P&L's COGS/pc × Output); Spare Parts → R&M + Stores & Spares (Other Overheads, Section 15); Debtors → that month's Sales/Revenue; OH → Total Overhead; Cash in Hand / Bank — Contingency → Total Direct Cost + Total Overhead (changed 2026-09-28, per direct instruction — was Total Overhead alone); Creditors → Total Direct Cost (moot at its 0-day norm). Net Current Assets = Total Inventory + Debtors + OH + Cash Contingency. Net Working Capital (Operational) = Net Current Assets − Creditors − that month's own EBITDA (reverse-engineered from your reference and confirmed to reconcile exactly) — Working Capital Requirement repeats the same figure. Change in WC = this month's NWC − last month's (first month = the full NWC, no prior baseline). Interest = Working Capital Requirement × Interest % (Cost & Financial Charges) ÷ 12 — reverse-engineered from your reference and confirmed exact; this feeds Interest in the P&L report too. Change in Cash Balance (Cash Profit) and Total Production are pulled from the P&L's own Cash Profit and Production & Revenue's own Output, rather than the placeholder figures in your paste, which didn't reconcile to either concept at the right scale. Monthly/Quarterly/Yearly view (added 2026-09-24): balance-type rows (Total Inventory, Debtors, Net Current Assets, Net Working Capital, Working Capital Requirement, Cumulative Cash Balance) show the closing, end-of-period figure for Quarterly/Yearly (not a sum — a balance isn't additive); flow-type rows (Change in WC, Interest, Total Production, Change in Cash Balance) are summed across the period, same convention as every other summed row on this page.
Cash Flow Statement
Cash in/out and the running cash balance — driven entirely by the P&L and Working Capital reports above. Nothing here is editable.
Closing Balance Trend
The running cash balance across the whole plan horizon — where it dips below zero shows when the business needs outside funding to cover its own ramp-up, and where it crosses back above zero is the point the plan becomes self-funding.
Built from your own pasted reference. Total Cash Inflow = Revenue + Stock Sales (Stock Sales is a placeholder row, 0 until there's a real figure or calculation for it). Direct Cost = Fabric + Trims & Accessories + Marketing + Logistic + Bank Charges + Others (Others is likewise a 0 placeholder) — same figure as the P&L's own Total Direct Cost. Indirect Cost = Total Manpower Cost + Manufacturing Overhead + Other Overhead — the same three figures as the P&L's Total Overhead, just under this report's own row names ("Other Overhead" here = "Factory Overhead" there). Interest / Finance Cost is pulled straight from Business Reports → Working Capital's own Interest row. Capex Expenses is not included — the tool currently has only one lump Total Capex figure (Capex Assumptions → Capex & Depreciation) with no spending schedule, and using it here would need an assumption about timing that hasn't been made; flagged as a Next Block once a real phased Capex schedule exists. Cash and Cash Equivalents at Beginning of Period = the previous month's Closing Balance (0 for Month 1). Working Capital Financing is a 0 placeholder, pending the bank-vs-margin funding split (Next Blocks). Total Cash Outflow Budgeted = Direct Cost + Indirect Cost + Interest/Finance Cost. Closing Balance = Opening Balance + Total Cash Inflow − Total Cash Outflow + Working Capital Financing — reverse-engineered from your reference and confirmed to reconcile exactly, month over month. Monthly/Quarterly/Yearly view (added 2026-09-24): every flow row (Revenue through Total Cash Outflow Budgeted) is summed across the period; Opening Balance shows the period's first month's own Opening Balance and Closing Balance shows the period's last month's own Closing Balance (both are point-in-time balances, not sums).
Investment Appraisal
Capacity & financing summary, yearly Free Cashflow / NPV, IRR and Payback — built entirely from Total Capex, the P&L report and Working Capital. Nothing here is editable.
PNL Chart with Cash Flow Summary (₹ in Cr.)
Break Even Analysis (₹ in Cr.)
Factory Overhead Summary
Month-wise line-item breakup of Manufacturing Overhead and Factory Overhead, shown in the same two sections used everywhere else in this model, each with its own subtotal, plus a Grand Total. Nothing here is editable.
Added 2026-09-24, per direct request for a month-wise Factory Overhead summary as its own report block; Power, Water and DG added right after Rent later the same day. Bifurcated into two labeled sections on 2026-09-24, per direct request ("give the same bifurcation in the Factory Overhead Summary as well") after a question about whether Manufacturing Overhead and Factory Overhead had any duplication: Manufacturing Overhead (DG, Water, Power, plus every Other Overheads row currently tagged Category "Manufacturing") and Factory Overhead (Rent, plus every Other Overheads row currently tagged Category "Factory") — the exact same split the P&L, Cash Flow and Working Capital reports already use for their own "Manufacturing Overhead"/"Factory Overhead" lines, just shown line by line here instead of as one figure each. Each section's own subtotal (Total Manufacturing Overhead / Total Factory Overhead) ties exactly to those reports' figures, and the Grand Total below is their sum — so, unlike the single-section version of this report published earlier the same day, this Grand Total DOES reconcile with the P&L's Manufacturing Overhead + Factory Overhead added together. Every row appears in exactly one section, once — there is no double-counting. Rows shown mirror the Other Overheads table exactly: add, remove or re-tag a row there and it appears, disappears or moves between sections here automatically. Every row here is currently a flat monthly figure (Rent, Power, Water, DG and each Other Overheads row are fixed amounts or a %/machine-day/Working-Days-per-Month rate off Peak Revenue/Total Machines, not something that varies month to month within the plan), so each month's column repeats the same value — this report exists to show the composition, not a month-to-month trend. Monthly/Quarterly/Yearly view: Monthly shows one column per month; Quarterly/Yearly sum each row across the period, same convention as the Cash Flow report.
Manpower Summary
Month-wise headcount and manpower cost breakdown, and the Headcount Ramp-up chart — moved here from Manpower Assumptions so it sits alongside the other read-only Business Reports. Nothing here is editable.
Headcount Ramp-up
Moved out of Manpower Assumptions into its own Business Reports block on 2026-09-24, per direct request ("move the manpower summary to a separate block under business reports") — same relocation pattern already used for Manpower Subsidy. No calculation changed: rows mirror the master Excel's Manpower 1 summary rows (109–119) exactly as before. Non-Operators = non-staff support headcount (excludes Operators and Staff); Ratio – Overall = Total Headcount ÷ Operators, matching the Excel's own formula (`TOTAL/OPERATORS`) exactly. Line-Shifts row (added 2026-09-29) = Active Lines × active Shifts that month/period, e.g. 11 × 2 = 22 once both shifts are fully running — this, not Active Lines, is what Non-Operators and Staff below actually ramp against (Operators are unaffected, since each shift already has its own Ladder Plan row); see Manpower Assumptions' own footnote for the full explanation of why. Total Wage Bill (Unloaded) = Staff Cost + Non-Staff Cost before benefits loading or food — this reproduces what the Excel's row labeled "GRAND TOTAL OF NON-STAFF" actually calculates (its formula sums every department's full cost, staff and non-staff together, unloaded); despite that row's name in the source file, its own numbers only reconcile as a combined staff+non-staff total, so it's labeled here for what it computes rather than repeating what looks like a mislabel in the original sheet — flagged in the decision log in case that Excel row was intended to mean something narrower. Food expense is a flat per-head amount, added unloaded — shown in plain currency rather than the Display Unit, since at a few thousand to a few lakh rupees a month it would round to "0.00" in Crores or Million. Staff Cost, Non-Staff Cost, Total Wage Bill and Total Manpower Cost follow the Display Figures In setting in Project Setup (Thousands / Lacs / Million / Crores). Monthly/Quarterly/Yearly view (added 2026-09-24, new with this move): Monthly is this exact table as before; Quarterly/Yearly average the headcount/ratio rows (Active Lines, Operators, Non-Operators, Staff, Total Headcount, Ratio – Overall — stock figures, not something that sums meaningfully) and sum the cost/flow rows (Staff Cost, Non-Staff Cost, Food, Total Wage Bill, Total Manpower Cost, Subsidy Revenue), the same convention already used for Production & Revenue's own headcount vs. flow rows. The Headcount Ramp-up chart always shows monthly detail regardless of this toggle, matching the Ladder Plan/Production & Revenue charts' own convention.
Department-wise Summary
Added 2026-09-28, per direct request ("Can i get a department wise summary in the Manpower Summary as an additional table"). Buckets every role's live monthly headcount and cost by its own Department (the same Department Master used in Manpower Assumptions), plus a separate Operators (Tailors) row for the Ladder Plan's own per-line Operators — they aren't one of the `manpowerRoles` and so don't carry a Department of their own. Shares the Monthly/Quarterly/Yearly toggle above (no separate toggle): headcount rows are averaged across a period, cost rows are summed — the same convention as the table above. Manpower Cost by Department is shown loaded — each department's Staff Cost (unloaded) + Non-Staff Cost × (1 + Total Statutory Load %) — the same loading the table above applies to its own Non-Staff Cost row, so a department's own Staff+Non-Staff split matches how it's actually costed. Food is not allocated to any department — it's a flat per-head amount with no department of its own — so the Grand Total row here reconciles to the table above's Total Manpower Cost minus Food, not the full figure.