Enter or review these records before relying on the summary.
Suggested for your taskFor makers producing repeatable batches
Batch Production & Materials
Close a batch with its actual materials and waste.
Connect a bill of materials to each batch, actual material issues, good output and scrap without double-counting inputs.
Excel 2021, Excel 2024 or Microsoft 365 with XMATCH; native compatibility not verified. Spreadsheet software is separate.
- Format
- Excel · .xlsx
- Inside
- 8 worksheets
- Included
- Clean file + example + guide
$9.90USD · one-time priceVAT included where applicable. Other applicable taxes are shown at checkout.Explore the sheets Follow the real example
Check the capacity and fitWho it is for, supplied record limits and software requirements
The everyday problem
Close a batch with its actual materials and waste.
Connect a bill of materials to each batch, actual material issues, good output and scrap without double-counting inputs.
Optional guideNeed help getting started?Choose where to begin. All listed files are included.
Add the complete product to your cart whenever you’re ready. Use this guide only if you’d like help choosing what to open first; your choices do not change the product or its price.
Guide step 1 of 4
What would you like to do?
Pick a useful task, or build your own selection.
Which sheets would you explore first?
Choose your starting points. The workbook keeps all its connected sheets and formulas; this does not remove or rebuild worksheets.
Nothing selected yet.
Enter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskEnter or review these records before relying on the summary.
Suggested for your taskWhich file would you open first?
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Your starting plan.
Your first file or method
Both XLSX files, all 8 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the complete setup guideThe complete product. Your starting choices do not change its contents or price.
Your choices help you understand the complete product. They do not alter its contents or price.
Both XLSX files, all 8 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the tasks, contents and file choices
Useful starting tasks
Define the product recipe. Use the included START_HERE.pdf guide to follow one complete task in a disposable example copy.
Choose my own starting points. Explore the contents and select only the parts you would use first.
Contents to explore
- Dashboard: Enter or review these records before relying on the summary.
- Start: Enter or review these records before relying on the summary.
- Settings: Enter or review these records before relying on the summary.
- Products: Enter or review these records before relying on the summary.
- Materials: Enter or review these records before relying on the summary.
- Bill of Materials: Enter or review these records before relying on the summary.
- Batches: Enter or review these records before relying on the summary.
- Material Issues: Enter or review these records before relying on the summary.
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Explore the worked example: Fictional records show how the sheets work together. Save a disposable copy before trying a change. batch-production-example.xlsx
Start my own working copy: Open the clean workbook after reading the guide. Keep the original and save a copy for your own records. batch-production-clean.xlsx
Follow the complete first taskUse the included guide and a disposable example copy.
Your first useful session / Start with the example
Define the product recipe
Follow this one complete task before entering your own records. Keep the blank original and save a working copy.
Name the products
Create stable product IDs and units for the goods you make before linking a recipe or batch.
Inspect ProductsName the materials
Create material IDs, units and planning rates; actual issue costs are entered separately later.
Inspect MaterialsDefine the product recipe
Link each material to the product once and enter its requirement per started unit in the Bill of Materials.
Inspect Bill of MaterialsClose the batch count
Record the production date and started, good and scrap units; good plus scrap must equal started.
Inspect BatchesPost actual material issues
Enter each material quantity and actual unit cost for the batch; review missing material warnings.
Inspect Material Issues
EVERY WORKSHEET / ACTUAL EXAMPLE FILE
See what you enter.
Understand what updates.
Inspect all 8 sheets. These are images of the delivered example, with fictional records. Open an image to read its full detail.
Actual example worksheet · Preview range A1:E29. Image only; entries are made in your downloaded workbook.
Dashboard
Dashboard: Labelled results and source warnings.
- You enter
- Review linked input records
- Calculated or supplied reference
- Labelled results and source warnings
Actual example worksheet · Preview range A1:D40. Image only; entries are made in your downloaded workbook.
Start
Start: The first task and route through the sheets.
- You enter
- Read the route through the file
- Calculated or supplied reference
- First useful task
Actual example worksheet · Preview range A1:D27. Image only; entries are made in your downloaded workbook.
Settings
Settings: Review date and chosen assumptions.
- You enter
- Review date and assumptions
- Calculated or supplied reference
- Chosen settings
Actual example worksheet · Preview range A1:E14. Image only; entries are made in your downloaded workbook.
Products
Products: 80 supplied input rows.
- You enter
- Record ID, Product, Unit, Reference / short note
- Calculated or supplied reference
- Input check
Actual example worksheet · Preview range A1:F14. Image only; entries are made in your downloaded workbook.
Materials
Materials: 120 supplied input rows.
- You enter
- Record ID, Material, Reference unit cost, Unit, Reference / short note
- Calculated or supplied reference
- Input check
Actual example worksheet · Preview range A1:G14. Image only; entries are made in your downloaded workbook.
Bill of Materials
Bill of Materials: 220 supplied input rows.
- You enter
- Record ID, Product ID, Material ID, Qty per start, Reference / short note
- Calculated or supplied reference
- Standard cost per start
Actual example worksheet · Preview range A1:L14. Image only; entries are made in your downloaded workbook.
Batches
Batches: 100 supplied input rows.
- You enter
- Record ID, Product ID, Produced on, Started units, Good units, Scrap units
- Calculated or supplied reference
- Standard material cost, Actual material cost, Missing material lines, Cost difference, Material cost per good
Actual example worksheet · Preview range A1:I14. Image only; entries are made in your downloaded workbook.
Material Issues
Material Issues: 300 supplied input rows.
- You enter
- Record ID, Batch ID, Material ID, Issued on, Issued qty, Actual unit cost, Reference / short note
- Calculated or supplied reference
- Issued cost
Follow the supplied fictional exampleRead the inputs and the result together
From the supplied fictional example
The supplied fictional example
One batch starts 20 gift box sets and closes 18 good plus 2 scrap. Two boxes at 1.50 and one label at 0.20 give 3.20 standard material per start and 64.00 for the batch. Actual issues of 40 boxes and 20 labels also cost 64.00.
- Batch started
- 20 gift box sets
- Boxes issued
- 40
- Labels issued
- 20
- Actual material
- 64.00
- Good units
- 18
FOLLOW THE ACTUAL EXAMPLE FILE
The supplied fictional example
Fictional records from the supplied example XLSX. Follow the same references through the sheets, then start your own clean copy.
The records behind the result
Batch started 20 gift box sets
Boxes issued 40
Labels issued 20
One batch starts 20 gift box sets and closes 18 good plus 2 scrap. Two boxes at 1.50 and one label at 0.20 give 3.20 standard material per start and 64.00 for the batch. Actual issues of 40 boxes and 20 labels also cost 64.00.
- Actual material
- 64.00
- Good units
- 18
This is an explanation of the downloadable workbook, not an online editor. Its complete clean and worked files are included. Save a working copy. Manual entry, with no automatic sync or external connections.
Inspect the actual worksheetsFrom setup to a regular review
How you use it.
Open the 3-step setup and review routineInputs, calculations and the decision each step supports
- 01
Define the product recipe
You enterName products and materials; put each material once in the Bill of Materials with the quantity for one started unit.
CalculatedThe bill of materials supplies the standard use per started unit.
Your next stepReview the labelled results and correct source warnings before acting.
- 02
Close the batch count
You enterRecord started, good and scrap units on the production date. Good plus scrap must equal started.
CalculatedStarted, good and scrapped units stay distinct for each batch.
Your next stepReview the labelled results and correct source warnings before acting.
- 03
Post material issues
You enterEnter each material quantity and its actual unit cost once for the batch. Review missing material lines and the cost difference.
CalculatedIssued material quantities and costs reconcile against the standard batch requirement.
Your next stepReview the labelled results and correct source warnings before acting.
8 sheets. Inspect each one.Inputs, outputs and when to use every worksheet
DashboardOpen sheet details
Editable inputs
- Review linked input records
Calculated or reference
- Labelled results and source warnings
Enter or review these records before relying on the summary.
Inspect the actual Dashboard sheetStartOpen sheet details
Editable inputs
- Read the route through the file
Calculated or reference
- First useful task
Enter or review these records before relying on the summary.
Inspect the actual Start sheetSettingsOpen sheet details
Editable inputs
- Review date and assumptions
Calculated or reference
- Chosen settings
Enter or review these records before relying on the summary.
Inspect the actual Settings sheetProductsOpen sheet details
Editable inputs
- Record ID, Product, Unit, Reference / short note
Calculated or reference
- Input check
Enter or review these records before relying on the summary.
Inspect the actual Products sheetMaterialsOpen sheet details
Editable inputs
- Record ID, Material, Reference unit cost, Unit, Reference / short note
Calculated or reference
- Input check
Enter or review these records before relying on the summary.
Inspect the actual Materials sheetBill of MaterialsOpen sheet details
Editable inputs
- Record ID, Product ID, Material ID, Qty per start, Reference / short note
Calculated or reference
- Standard cost per start
Enter or review these records before relying on the summary.
Inspect the actual Bill of Materials sheetBatchesOpen sheet details
Editable inputs
- Record ID, Product ID, Produced on, Started units, Good units, Scrap units
Calculated or reference
- Standard material cost, Actual material cost, Missing material lines, Cost difference, Material cost per good
Enter or review these records before relying on the summary.
Inspect the actual Batches sheetMaterial IssuesOpen sheet details
Editable inputs
- Record ID, Batch ID, Material ID, Issued on, Issued qty, Actual unit cost, Reference / short note
Calculated or reference
- Issued cost
Enter or review these records before relying on the summary.
Inspect the actual Material Issues sheetFiles, capacities and practical limitsRead these before choosing your working copy
The download
Files with a purpose.
START_HERE.pdf
One four-page guide: first session, file index, practical limits, recovery and license.
batch-production-clean.xlsx
Empty workbook. Save As a working copy before entering records.
batch-production-example.xlsx
The same workbook with fictional records and checked results.
English instructions, sheet names and field labels.
Before you choose
Fit and practical limits.
- For makers producing repeatable batches
Understand the boundaries.
- Save a working copy. Manual entry, with no automatic sync or external connections.
- Supplied tables have fixed capacities. Extend formulas, tables and validation together before using extra rows.
- Use one currency. Blank means unknown; enter 0 when the amount is known to be zero.
- Resolve the highlighted input rows before relying on the summary.
- Uses exact-mode XMATCH. Requires Excel 2021, Excel 2024 or Microsoft 365; older Excel editions are not supported. Native Excel, Google Sheets and Numbers have not been verified.
- One Bill of Materials row is one material per product. The per-unit standard is applied to every started unit, including scrap.
- Enter one Material Issues row per batch/material, including an explicit zero where none was issued. The cost is a dated price snapshot, not the current Materials reference price.
- Actual material cost divided by good output is a material-only rate. It excludes labour, overhead, tax, work in progress and selling price.
Excel 2021, Excel 2024 or Microsoft 365 with XMATCH; native compatibility not verified. Local digital-engine tests are separate from native application verification.
Batch Production & Materials / Version 1.0
Your own working copy.
Clean workbook, separate example and one START_HERE.pdf guide covering setup, practical limits and the internal-use license.
$9.90USD · One-time purchaseVAT included where applicable. Other applicable taxes are shown at checkout.
Desktop spreadsheet software required; it is not included. Native Excel compatibility is still awaiting verification.
Private preview. Purchases are unavailable while the files and delivery are verified.
Questions about this workbook
The details that affect your choice.
Must I connect an account?
No. The workbook uses manually entered records and has no external connection.
Can I add unlimited records?
No. Supplied capacities are listed. Extend formulas, tables and validation together before using additional rows.
Why does the result ask me to review inputs?
Correct the highlighted Input check at its source. Keep a backup before changing IDs, dates or assumptions; do not replace a formula with a typed result.