Skip to content

Executive leadership: the MIS against plan, and margin by buyer and unit

Ask how the MIS moved against plan, which buyers carry the margin, or what a capex memo commits to. The agent answers from the reports, registers and memos you upload, names the file behind each figure, and sends or adds nothing unless an admin approves.

Works from: MIS and MBR pack, Board pack, Board minutes and action log, Annual plan and budget

Four gaps between the mill’s records and the board

The numbers exist: in the ERP, in each function’s Excel, in the costing sheets and in last quarter’s minutes. The board still waits for someone to collect them, and nobody can ask a report a question and see the source beside the answer.

  • The MIS is retyped from every function’s sheet, and arrives late

    Production, merchandising, stores and finance each keep their numbers in their own sheets or systems. At month end someone collects and retypes them into the MIS, so the owner reads last month’s figures well into this one. Two versions of one number reach the monthly business review (MBR), and the meeting argues over whose figure is right. The records are kept; they are not reviewed in time for the decision.

    Only 29%

    Share of treated plants in a 17-firm Indian cotton-weaving trial that, before it began, reviewed quality-defect records daily or by defect type, though 93% kept them, often on paper. None had a standard analysis or action plan. 2008–2010.

    Source: National Bureau of Economic Research (NBER), Does Management Matter? Evidence from India (opens in a new tab), 2011.

  • Too much of the year rides on one or two buyers

    When one buyer takes a large share of the lines, a cut in volume, a late payment or a cancelled order hits revenue, receivables and capacity at once. Leadership needs that exposure by buyer, month and unit, and it is spread across the sales register and the order book. The playbook treats a single account above 30% as a slow risk and sets the top-10 buyer share below 70%.

    Around 75%

    Share of garment-sector suppliers at high dependency risk in an ILO global survey, meaning their main buyer takes at least 35% of production. Across all sectors the share was 54%. 2016 survey.

    Source: International Labour Organization (ILO), INWORK Issue Brief No.10: Purchasing practices and working conditions in global supply chains: Global Survey results (opens in a new tab), 2017.

  • Every decision waits for the owner, and the reasons leave with managers

    In many family-run mills the owner signs off small purchases and hires, and is the only one who holds the whole picture. Managers wait for a signature on decisions they could take themselves. When one of them leaves, the reasons leave too: why a buyer was dropped, what a capex memo promised, which MBR action was never closed. The next decision starts again from memory.

    68 hours a week

    Average working week of the owners in a 17-firm study of Indian cotton-weaving firms, 2008–2010. The authors call them severely time constrained and give it as a major reason new practices were slow to take hold.

    Source: National Bureau of Economic Research (NBER), Does Management Matter? Evidence from India (opens in a new tab), 2011.

  • No P&L by style, buyer or unit, so loss-making orders hide in the total

    The company P&L comes in late, and even then nobody can say which buyers carry the margin and which orders lose money. Pre-costing sits with costing, consumption and rework with production, invoices with finance. So an order priced below cost is repeated next season on the same terms, and the lines stay full of work that does not pay. The owner sees it only in the year’s result.

MIS, margin by buyer and board actions, each with its file

It answers from the reports, registers, exports and memos uploaded to Executive Leadership, and the Google Sheets you connect. Each figure has its file, rows or cells. Every email, message or row it drafts waits for an admin, who approves or declines it.

  • The MIS and board pack, quoted with the file and its date

    Reads your documents

    Upload each month’s MIS, the budget, the board packs and the function heads’ month-end sheets to the Executive Leadership department. Ask how a line moved against plan and the agent quotes the figure as the report states it, with the file and date. Where two reports give different figures for the same line, it shows both, each with its file. If a line is not in the files, it says so.

    Ask“What did the October MIS report for gross margin, power cost and on-time shipment against plan? Name the file and its date.”

  • Margin and buyer share, totalled from your own rows

    Answers with sources

    Upload the P&L by buyer or the sales register as an Excel or CSV file. Name a buyer, unit, style or month, or up to three that must all hold, such as one buyer in Unit 2. The agent gives one total of revenue or contribution from the matching rows and lists them for the CFO to check. Ask buyer by buyer and it sets the totals side by side. If no sheet splits the P&L by style, it says so instead of estimating one.

    Ask“From the Q3 P&L by buyer, what was this buyer’s total contribution in Unit 2? List the rows you used.”

  • The order book, totalled from your monthly export

    Answers with sources

    Upload each month’s open-order export from your ERP as an Excel or CSV file. The agent totals open quantity or value for the buyer, unit or ship month you name and lists the rows it used. The figures stand as of the export’s date, and it gives that date. For capacity it quotes the unit plan you uploaded beside it, as written. It does not judge which orders the lines can take.

    Ask“From the November order-book export, what is this buyer’s total open quantity with a January ship month?”

  • The MBR variance note and board pack index, as real documents

    Creates files

    Ask for the month’s variance note and the agent builds it from the function reports uploaded to Executive Leadership: each cost head off budget, the figure as reported, and the reason each report gives. A line with no reason is marked open, not explained for you. Ask for one section changed and it edits that part only. Every revision is kept and attributed.

    Ask“Make the MBR variance note from this month’s function reports. Mark any cost head over budget where no reason is given.”

  • Board actions into the tracker, and the pre-read date to directors

    Acts in your tools

    From the typed minutes, the agent lists each action with its owner and due date as minuted. It drafts one row per action for your tracker in Google Sheets and a Slack or WhatsApp Business message to each owner. It can also prepare the email telling directors the pre-read is ready, and an Outlook calendar event for the board. An admin approves or declines each one. Nothing runs unless approved.

    Ask“Add the actions from Tuesday’s board minutes to the tracker with owner and due date, and draft a note to each owner.”

The night before the MBR, a dedicated line and the board’s actions

  • The evening before the monthly business review

    Managing director

    The MBR is tomorrow morning, and the MIS pack arrived this afternoon.

    1. Asks

      “Which cost heads moved most against plan this month, and what do the function reports say caused each one?”

    2. The agent

      Reads the MIS workbook and the function reports uploaded to Executive Leadership. Lists the largest variances against budget as the MIS states them, quotes the reason each function’s report gives, and names the file and date for every line. Where a report gives no reason, it says so instead of offering one. Reported confidence sits beside the answer.

    3. Result

      The MD walks into the review with the largest movements, each with its source, and knows which function still owes an explanation.

  • A strategic buyer asks for a dedicated line

    CEO

    A large buyer offers a three-year programme if the mill adds a sewing line just for them.

    1. Asks

      “What share of our revenue is this buyer’s this year, what open orders do they have, and what payback does the capex memo for the new line state?”

    2. The agent

      Totals the buyer’s revenue and the year’s total from the uploaded sales register and gives the share, with the rows used. Lists the buyer’s open orders from the uploaded order-book export, with its date. Quotes the memo’s payback and NPV as written. Lists the playbook’s four checks and marks a check open where no record answers it, such as a written volume commitment. It builds all of this as a one-page note.

    3. Result

      The CEO takes the buyer’s share, the memo’s payback and each playbook check, marked answered or open, to the board. The decision stays with the board.

  • The day after the quarterly board

    Company secretary

    The board met yesterday, and the typed minutes are uploaded to Executive Leadership.

    1. Asks

      “Take the actions from yesterday’s board minutes, add them to the tracker with owner and due date, and send each owner a note on Slack.”

    2. The agent

      Reads the minutes and lists every action with its owner and due date as minuted, and marks any action recorded without an owner or a date. Prepares one new row per action for the board action tracker in Google Sheets, and a Slack message to each owner quoting their action and its due date.

    3. Approval

      The rows and messages wait as actions. The managing director, as department admin, approves or declines each one. It runs only if approved, and the audit trail keeps who decided.

    4. Result

      Only the rows and messages the MD approves run, each carrying the owner and date the minutes record; a declined one does nothing. Actions minuted without an owner stay with the secretary to settle.

What hidden margin, buyer exposure and lost routines cost

The figures below are published figures from surveys and studies of suppliers and mills, each cited at the source. None of them is a Mavick result. A pilot baselines your own numbers on the scorecard and reads them again at the end.

  • Margin read by buyer and order, not only in the total

    0 of 20 plants

    Treated and control plants in a 17-firm Indian cotton-weaving trial that, before it began, analysed past efficiency by design so prices could rest on each design’s own cost rather than the average. 2008–2010.

    How the agent helps

    Upload last season’s P&L by buyer as one Excel or CSV table, then ask for a buyer’s, unit’s or style’s contribution. The agent totals it from that table’s rows and shows them. Post-costing sheets kept one per order are answered one file at a time. You see whether a buyer ran below cost before the next price is agreed. It never estimates a margin the records do not hold.

    Track: Gross margin % by buyer and unit, against plan

    Source: National Bureau of Economic Research (NBER), Does Management Matter? Evidence from India (opens in a new tab), 2011.

  • Buyer exposure counted before you take more volume

    72.1%

    Share of buyers who, cancelling orders as Covid-19 hit, refused to pay for raw materials the supplier had bought. 316 Bangladeshi suppliers, March 2020; 58% of factories surveyed shut most or all operations. A shock, not a normal year.

    How the agent helps

    Before you accept more volume from one buyer, ask for its share. The agent totals that buyer’s revenue for the year, and for each unit you name, from the uploaded sales register, and lists its open orders from the uploaded order-book export. It quotes the playbook’s 30% line for one account. It does not predict which buyer will cut volume.

    Track: Largest single buyer’s share and top-10 buyer share

    Source: Penn State Center for Global Workers’ Rights, with the Worker Rights Consortium, Abandoned? The Impact of Covid-19 on Workers and Businesses at the Bottom of Global Garment Supply Chains (opens in a new tab), 2020.

  • Review routines that outlast a manager’s exit

    About half in 9 years

    Share of the management practices that Indian weaving plants had dropped nine years after a 17-firm trial brought them in. Managerial turnover and lack of director time were two of the most cited reasons.

    How the agent helps

    Upload MBR packs, board minutes and capex memos to Executive Leadership as they are made. The agent answers what was decided, in which minute, and which actions are open with their owners and dates, so the record stays answerable after a manager leaves. Tracker rows it prepares are added only if an admin approves.

    Track: MBR and board actions closed by their due date

    Source: American Economic Association (American Economic Journal: Applied Economics), Do Management Interventions Last? Evidence from India (opens in a new tab), 2020.

What to baseline before a pilot

Measure each one before the pilot starts, then again at its end.

Executive Leadership: the KPIs to baseline before a pilot, and why each matters
KPI to baselineWhy it matters
Gross margin % against plan, by buyer and unitThe playbook reads gross margin against plan and over time. Split by buyer and unit, it shows which accounts carry the mill and which are kept at a loss.
EBITDA % against planThe playbook reads it against plan. Track it each month beside gross margin, so a fall can be traced to the orders themselves or to overheads.
Top-10 buyer shareTotal each leading buyer’s revenue for the year from the uploaded sales register, one buyer at a time, and read the share against the playbook’s target of under 70%.
On-time shipment %The playbook calls it the operational North Star. Problems in planning, production and shipping all end up in this one number.
Working capital daysDays of cash held in yarn, fabric and garment stock and in buyer receivables. The playbook lists it to track. For an exporter it moves with buyer payment terms and with stock built ahead of shipment.
Revenue growth % against planThe playbook reads revenue growth against the annual plan. Totalled buyer by buyer from the sales register, it shows whether the growth comes from one account.

What the agent works from

Records it reads

  • MIS and MBR pack
  • Board pack
  • Board minutes and action log
  • Annual plan and budget
  • Capex memo
  • Capex register
  • P&L by style, buyer and unit
  • Sales register

In your ERP

The factory’s ERP connection gives the executive agent no records, and the agent writes nothing to it. The order book, P&L by buyer, budget and capex register come from the Excel or CSV files you upload and the Google Sheets you connect. Export the open orders from your ERP each month and upload the file; its figures stand as of that date.

One ERP connection serves the whole factory: SAP Business One, SAP S/4HANA, Odoo, Oracle NetSuite, Microsoft Dynamics 365, WFX Cloud ERP or Datatex NOW. This agent reads only the records named above; we check yours on the call.

In your tools

Reads the action tracker in Google Sheets and the leadership mailbox in Gmail or Outlook when asked. Prepares tracker rows, Slack or WhatsApp Business messages asking function heads for their MBR numbers, emails to directors and an Outlook calendar event for the board. An admin approves or declines each one. It runs only if approved.

Tools named today: Gmail, Outlook, Google Sheets, Slack and WhatsApp Business.

Never made up

  • Financial results, forecasts or projections
  • Capex commitments, approvals or returns
  • Strategic decisions, M&A positions or valuations
  • Commitments made in a buyer relationship

If it is not in your connected data, the agent says so.

Belongs to another department

What the Executive Leadership playbook covers

  • SOP: the board pre-read, five working days out

    The pre-read goes to directors five working days before the board, in standard sections: financials, operations, commercial, people, risk and strategy. Before it goes, every function head agrees the numbers, the variance notes are checked and each request to the board is written clearly. Minutes and action items are tracked.

  • Decision rule: a strategic buyer asks for a dedicated line

    Check four things: a multi-year volume commitment, a margin commitment, payback on the capex, and the opportunity cost of the other buyers you would turn away. If any of the first three fails, decline. Go ahead only with the multi-year commitment in writing.

  • KPI: buyer concentration

    The playbook sets the top-10 buyer share below 70% and calls one account above 30% a slow risk: keep finding new buyers even when nothing hurts. If a large customer starts to pull its business, the CEO and the board hear of it at once.

  • Heuristic: how long a capex project may take to pay back

    Energy and automation retrofits should pay back in under 24 months. For major machinery such as looms, stenters and spinning frames, 3–4 years is normal, 4–5 years needs a strategic case, and more than 5 is an aspiration unless a buyer commitment underwrites it.

Written as general textile practice and reviewed by four independent AI models. Not yet signed off by a human subject-matter expert. Upload your own SOPs and standards, and every answer shows which source it used.

Ten questions it ships with

The template’s starter questions. Your team can edit them, or ask in its own words.

  • Latest MIS against plan

    What does the latest MIS report, and how did each key line move against plan? Cite the report and its date.

  • P&L by buyer and unit

    Show the P&L split by buyer and by unit for this period, and tell me which are carrying the margin.

  • Capex committed against plan

    What capex has been committed against the annual plan, what is spent, and what remains uncommitted?

  • Risks escalated to leadership

    Which risks and exceptions have the assurance functions escalated this period, and what is the status of each?

  • Order book and capacity picture

    Show the current order book against factory capacity for the coming quarter, and where the pressure points are.

  • Leadership summary from the reports

    Prepare a leadership summary from the reports already on record: performance, risks, and the decisions that need making.

  • Cost heads moving most

    Which cost heads have moved most against plan this period, and what do the records attribute the movement to?

  • Buyer concentration

    What share of revenue do our top buyers account for this year, and how has that concentration changed?

  • Capacity utilisation by unit

    Show capacity utilisation by unit for this period, and where we are leaving capacity unused.

  • What the board pack contains

    What does the latest board pack cover, and which items were flagged for follow-up?

Executive Leadership: questions before a demo

Each function sends its MIS in a different Excel layout. Can the agent still total it?

Yes, once the figures sit in a table. In each Excel file the first sheet becomes the table the agent counts and totals from, up to 5,000 rows; the other sheets are searched and quoted as text, not totalled. So ask each function head to put the month’s figures on the first sheet, one row per line, with columns such as unit, cost head, plan and actual. The agent then totals for the unit or cost head you name and shows the rows used. It answers from one file at a time and sets the answers side by side; it does not merge two layouts into one table.

Will the executive agent see Finance’s ledgers or Internal Audit’s working papers?

No. The executive agent sees what is connected to the Executive Leadership department, plus files someone has shared across the factory. Finance, Treasury and Internal Audit keep their own workspaces, and that boundary is built into how Mavick stores and retrieves everything. To make an audit escalation report or the AR ageing answerable here, upload the final version to Executive Leadership. Asked for ledger entries or control testing, the agent says Finance & Accounts or Internal Audit & Risk owns them.

Can it work out the NPV, IRR or payback of a capex request?

No. It quotes the payback, NPV, IRR and sensitivity the capex memo states, names the memo, and sets the payback beside the playbook’s bands for that kind of project. From an uploaded capex register it totals the committed, spent or remaining column for the project or status you name, as the register records them, with the rows shown. It does not compute returns, run scenarios or forecast demand. If a memo gives no payback, it says so.

Can it compare this quarter’s board actions with last quarter’s?

Yes, from the tracker rows. In the board action tracker in Google Sheets it reads each meeting’s actions and sets them side by side with owner, due date and status, citing the cells. To count them, upload the tracker as an Excel or CSV file with a status and a quarter column, and it counts the rows that match, such as status Closed in Q3. It reports the status the tracker records; it does not judge whether the work was done. Minutes must be typed: a scanned page has no text to read.

Can it send us a P&L flash every Monday morning?

No. The agent answers when someone asks. It does not run on a schedule or watch the numbers between questions. Ask on Monday and it builds the flash as a real document from the latest files on record, and names any figure it could not find. If the flash should go to directors, it prepares the email. An admin approves or declines that email. It goes out only if approved.

Can our function heads see the board pack or the margins through Mavick?

No. Only the people invited to Executive Leadership work in its workspace. A production manager or merchandiser lands in their own department and sees nothing else, and their agent cannot read files uploaded to Executive Leadership. A file reaches other departments only if someone shares it across the factory, so keep the board pack, P&L by buyer and capex memos here. Removing access takes effect at once.

Bring Executive Leadership. We’ll build it on the call.

Book a 30-minute demo (opens in a new tab)
Email
support@mavick.si