4. Box Quotation & Costing
Open this screen from an approved Box Enquiry. Enquiry details load automatically and most fields are read-only.
Screen sections
- Header — enquiry code, dates, customer, receipt terms
- Product details — copied from enquiry
- PP Paper Combination — paper layers with mill, rate, and cost
- Manufacturing Rate Chart — reference rates (admin-configured)
- Rate breakdown — paper, conversion, printing, etc.
- Box costing — margin, GST, final price
- Die cost details — optional one-time die charges
Step-by-step: generate a quotation
Step 1 — Review enquiry data
Confirm customer, dimensions, ply, flute, printing, and paper combination are correct. Fix on the enquiry screen if needed, then return here.
Step 2 — Set paper mill IDs
In the PP Paper Combination table, the Mill column is editable (click the cell):
- Default mill IDs are applied per layer (e.g. Top = 12, others = 11).
- Enter the correct mill / contact person ID for each paper layer.
- Mill ID links to the Paper Rate Chart (
paper_rate_chart).
Step 3 — Adjust flute constant (if needed)
Flute Constant dropdown: 1.5, 1.45, 1.4, 1.35, 1.3
Use the value matching your flute type and production practice.
Step 4 — Click Generate
The system:
- Calls the paper rate API for each visible paper row (
BF+Color+Mill ID). - Fills Rate and Cost of Paper per row.
- Sums Total Paper Rate (₹/BOX).
- Calculates conversion, printing, pin/glue, die cut, and reinforcement costs.
- Computes final box cost with interest, profit margin, and GST.
If a rate is missing, a warning appears: "No Rate For [layer]". Update the Paper Rate master or correct the mill ID, then click Generate again.
Step 5 — Select profit margin (PM No.)
| Code | Default % |
|---|---|
| A | 7% |
| B | 10% (default) |
| C | 15% |
| D | 20% |
| E | 30% |
| F | 50% |
| G | 75% |
| H | 100% |
| I | Custom (Admin only — enter % manually) |
Changing PM No. recalculates Base Cost of Box and Total Cost of Box.
Step 6 — Select HSN/SAC code
Choose the applicable HSN/SAC Code | GST %. GST is applied on the base cost after margin.
Step 7 — Enter die cost (optional)
| Field | Description |
|---|---|
| Die Cost | One-time die charge |
| Die Cost Details | Notes / breakdown |
Step 8 — Click Submit
Saves the quotation and opens Box Quotation View. The quotation appears in Quotation list.
Rate breakdown fields
All amounts are ₹ per box unless noted.
| Field | How it is calculated |
|---|---|
| Total Box Wt. | From enquiry (kg) |
| Total Paper Rate | Sum of (paper weight × rate) for each layer |
| Conversion Fixed Rate | Total box weight × Fixed rate (from Mfg Rate Chart) |
| Semi Fixed Rate | Total box weight × Semi Fixed rate |
| Variable Rate | Total box weight × Variable rate |
| Semi Variable Rate | Total box weight × Semi Variable rate |
| Printing Rate | Based on printing type (Single / Two / Three / Four Color) |
| Pin/Glue Cost | Based on join type (Pin, Glue, or both) |
| Die Cut Rate | Applied only if Die Cut Machine = Yes |
| Reinforcement Strip Rate | Based on Inside / Outside / Both Side |
Manufacturing Rate Chart items
Configured in box_mfg_rate_chart (admin). Typical items:
- Fixed, Semi Fixed, Variable, Semi Variable (per kg conversion)
- Single / Two / Three / Four Color printing
- Pining, Gluing, Die Cost
- Reinforcement Inside / Outside / Both Side
- Interest rate (annual % — used for payment-term interest)
Box costing formulas
Primary box rate
Primary Box Rate =
Total Paper Rate
+ Fixed Rate + Semi Fixed Rate + Variable Rate + Semi Variable Rate
+ Die Cut Rate + Printing Rate + Pin/Glue Cost + Reinforcement Strip Rate
Interest (based on receipt terms)
Daily Interest Rate = (Annual Interest % / 100) / 365
Interest Amount = Primary Box Rate × Receipt Days × Daily Interest Rate
Receipt Days is parsed from the Receipt Terms text (first number in the string).
Cost with margin
Total Cost With Interest = Primary Box Rate + Interest Amount
Base Cost of Box = Total Cost With Interest × (1 + Profit Margin % / 100)
Total Cost of Box (with GST) = Base Cost of Box × (1 + GST % / 100)
Updating paper rates from quotation screen
Click a Rate cell in the paper table to open the Paper Rate modal. You can add or update rates for the selected BF, colour, and mill without leaving the quotation.
Quotation list
Menu: Quotation
Filter by product type, enquiry status, quotation status, quotation type (Regular / Custom), and UID.
| Quotation status | Meaning |
|---|---|
| Created | New quotation saved |
| Approved | Approved for sales |
| New Created | Re-generated after enquiry update |
| Previously Approved | Earlier version was approved |
Permissions
- Quotation / Estimate — Add — generate and submit quotations
- Quotation / Estimate — View — view quotation list and details
Troubleshooting
| Problem | Solution |
|---|---|
| Generate does nothing | Ensure paper table has rows and mill IDs are set |
| Total Paper Rate = 0 | Check Paper Rate master for BF + Color + Mill |
| Interest seems wrong | Verify Receipt Terms contains payment days (e.g. "30 Days") |
| Submit button hidden | Click Generate first to run calculations |
| PM option I not showing custom % | Only Admin can use custom margin (code I) |