ManagementAdvancedEngineeringManufacturing
Quoting, Cost & Project Margin Analysis Prompt
Helps build a quote cost structure, margin simulation, and sensitivity analysis.
Audience: Sales, finance, project teams · Last updated 2026-07-17
Contents
Scenario
Helps build a quote cost structure, margin simulation, and sensitivity analysis.
Applicable Industry or Company Size
- Engineering
- Manufacturing
Preparation Before Use
- Historical quotes and actual cost data.
- Main cost category breakdown.
Variable Reference
| Variable | Description |
|---|---|
| [Company Name] | Your company's official name |
| [Quote Type] | e.g., engineering integration, system implementation, consumables |
| [Main Cost Items] | e.g., labor, materials, subcontracting, travel |
Full Prompt
Prompt
You are a finance and project cost consultant. Help build a quote cost model. [Background] - Company: [Company Name] - Quote Type: [Quote Type] - Main Cost Items: [Main Cost Items] [Output] 1. A cost-structure tree (Levels 1–3). 2. A formula and data source for each cost item. 3. A split between direct and indirect costs. 4. Margin-calculation method and a recommended target margin range. 5. Sensitivity analysis: margin impact of ±10% on the 3 key variables. 6. A list of commonly underestimated cost items. 7. Quote-review checkpoints. [Judgment Criteria] Do not assume specific numbers; provide formulas and a spreadsheet structure, with numbers to be filled in by the company. [Handling uncertain information] If any of the variables below have not been filled in or the information is insufficient, list the missing fields directly and ask the user — do not assume or fabricate data. [Prohibited] - Do not fabricate statistics, regulation numbers, certification names, or client case studies. - When professional judgment is insufficient, explicitly mark "requires human confirmation" rather than inferring on your own. [Final self-check] After producing the output, list a self-check at the end covering: (1) whether any fabricated numbers, regulations, standards, or client names were used; (2) whether any unfilled but important variable was ignored; (3) whether assumptions are clearly labeled.
Usage Steps
- Fill in the variables.
- Review the formulas with finance.
- Build an Excel / BI spreadsheet.
Example
Engineering integration commonly underestimates: overtime pay, material waste, change-management costs.
Common Mistakes
- Reverse-engineering price from margin target while ignoring competitive conditions.
Cautions
- Margin strategy must be evaluated alongside long-term customer relationships.
Last updated 2026-07-17
Need further customization to fit your company's process and industry?
AEGIS POWER INTEGRATIONS offers AI adoption, process assessment, and systems integration consulting to help you turn prompts into a stable, working internal process.
