Excel Job Pricing Calculator

I need an easy-to-maintain Excel workbook that lets me quote new contracts for my labor-based service company. We operate in two distinct lines—Janitorial and Security—and I want each of them costed and reported separately.

Here’s the core logic I must be able to reproduce:

• I enter the direct monthly payroll required for the new customer (e.g., $10 k).
• I enter—or reference—our current fixed overhead and variable expenses (for example, $10 k each right now), plus total monthly sales.
• The sheet calculates the overhead and variable-expense percentages and applies them to the new job so the quoted price automatically covers its share of those costs.
• It then adds my target profit margin so I see both a recommended invoice amount and the margin in dollars and percent.

For Janitorial quotes the model must let me indicate the kind of facility—Office buildings, Schools, Other commercial spaces, Nursing Homes, Shelters, or Government buildings—because rates sometimes differ; I plan to adjust a single cell or pick from a drop-down to trigger any preset factors. Security quotes don’t need that breakdown but do need their own expense and margin logic, fully separated from Janitorial.
we have some jobs being billed per sq feet, all this calculations needs to be added into price per sq ft

Key expectations
• Clear input section for editable figures (payroll, overhead, variables, target profit).
• Locked formulas that roll those figures into a final monthly price for each service.
• A summary page comparing the two service lines side by side.
• Clean labeling and simple color coding so my managers can’t break it.

Please build it solely in Excel—no macros are required, but structured references or named ranges that keep the file flexible are welcome. When you deliver, include a brief note explaining where to change assumptions should our expenses or sales volumes shift.