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

VariableDescription
[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

  1. Fill in the variables.
  2. Review the formulas with finance.
  3. 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.