Meridian-Studio-Fee-and-Margin-Model.xlsx

	B	C
1
2	Fee & Margin Model
3	Meridian Studio Architects · how we price work, and whether the price held
4
5	Representative model built by Go Pivot Edge. The structure, formulas and logic are exactly as delivered; the firm, projects and figures are illustrative so the model can be shared openly.
6
7
8	What this is	A pricing model for a project based business. It answers two questions. What should we charge for this job, and did the last one actually make money.
9
10	The idea in one line	A fee is a guess about hours, made months before anyone finds out the truth. This model makes the guess carefully, then checks it against what really happened.
11
12	How to drive it	Everything is steered from the Control Panel. Change a shaded box there and every sheet updates. Nothing else needs editing. If a number looks wrong, it is coming from the Control Panel, not from a hard coded cell.
13
14	THE SHEETS
15	Control Panel	The whole model in one screen. Toggles on the left, headline results on the right. Start here.
16	Rate Card	What each person costs us per hour, and what we bill them at. Everything else prices off this.
17	Fee Builder	Build a fee for a new job. Type in hours by role and phase, and it returns the fee three different ways so you can compare.
18	Projects	Every job in the portfolio. What we charged, what it cost, what was left.
19	Phase Detail	The same jobs broken into the five phases, estimated hours against actual. This is where the money is won and lost.
20	Variance	The answer sheet. Which phases overrun, which fee types hold up, and what it costs a year.
21	Practice KPIs	How busy people are, how much of that time we actually bill, and the multiplier we really achieve.
22	Scenarios	The same portfolio under three sets of assumptions, side by side.
23	Contract Terms	Clauses that quietly move margin, and what each one is worth.
24	Glossary	Every term in this workbook, in plain words. No jargon left unexplained.
25
26	COLOUR CODE
27	Shaded boxes	These are yours to change. They are the only cells anyone should type into.
28	Everything else	Calculated. If you type over a formula the model stops telling the truth, so it is best left alone.
29	Green / amber / red	Green is at or better than target. Amber is drifting. Red needs a conversation this week.
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100