Wedding Budget worksheet

1. Total budget per guest: $250.00

1. Divide the total budget by the number of guests to see what each guest's share costs

   $\frac{\mathrm{\$27,500.00}}{110}$$=\mathrm{\$250.00}$

2. Venue, food and drink gets 50% of the budget

   $\mathrm{\$27,500.00}\times \mathrm{50\%}$$=\mathrm{\$13,750.00}$

3. Photography and video gets 9% of the budget

   $\mathrm{\$27,500.00}\times \mathrm{9\%}$$=\mathrm{\$2,475.00}$

4. Attire, hair and makeup gets 7% of the budget

   $\mathrm{\$27,500.00}\times \mathrm{7\%}$$=\mathrm{\$1,925.00}$

5. Divide venue, food and drink by the guests, since it's usually the cost that grows with the guest list

   $\frac{\mathrm{\$13,750.00}}{110}$$=\mathrm{\$125.00}$

6. Check that the category amounts add back up to the total budget

   $\mathrm{\$13,750.00}+\mathrm{\$2,475.00}+\mathrm{\$1,925.00}+\mathrm{\$1,375.00}+\mathrm{\$2,475.00}+\mathrm{\$1,375.00}+\mathrm{\$1,650.00}+\mathrm{\$2,475.00}$$=\mathrm{\$27,500.00}$

2. Total budget per guest: $274.39

1. Divide the total budget by the number of guests to see what each guest's share costs

   $\frac{\mathrm{\$22,500.00}}{82}$$=\mathrm{\$274.39}$

2. The shares add up to 110%, not 100%. So each one is scaled by 100 ÷ 110 to use the whole budget. For the first category

   $\mathrm{50\%}\times \frac{100}{110}$$=\mathrm{45.4545\%}$

3. Venue, food and drink gets 45.4545% of the budget

   $\mathrm{\$22,500.00}\times \mathrm{45.4545\%}$$=\mathrm{\$10,227.27}$

4. Photography and video gets 10.9091% of the budget

   $\mathrm{\$22,500.00}\times \mathrm{10.9091\%}$$=\mathrm{\$2,454.55}$

5. Attire, hair and makeup gets 10% of the budget

   $\mathrm{\$22,500.00}\times \mathrm{10\%}$$=\mathrm{\$2,250.00}$

6. Divide venue, food and drink by the guests, since it's usually the cost that grows with the guest list

   $\frac{\mathrm{\$10,227.27}}{82}$$=\mathrm{\$124.72}$

7. Check that the category amounts add back up to the total budget

   $\mathrm{\$10,227.27}+\mathrm{\$2,454.55}+\mathrm{\$2,250.00}+\mathrm{\$1,840.91}+\mathrm{\$2,045.46}+\mathrm{\$818.18}+\mathrm{\$1,227.27}+\mathrm{\$1,636.36}$$=\mathrm{\$22,500.00}$

3. Total budget per guest: $278.26

1. Divide the total budget by the number of guests to see what each guest's share costs

   $\frac{\mathrm{\$32,000.00}}{115}$$=\mathrm{\$278.26}$

2. The shares add up to 94%, not 100%. So each one is scaled by 100 ÷ 94 to use the whole budget. For the first category

   $\mathrm{44\%}\times \frac{100}{94}$$=\mathrm{46.8085\%}$

3. Venue, food and drink gets 46.8085% of the budget

   $\mathrm{\$32,000.00}\times \mathrm{46.8085\%}$$=\mathrm{\$14,978.72}$

4. Photography and video gets 12.766% of the budget

   $\mathrm{\$32,000.00}\times \mathrm{12.766\%}$$=\mathrm{\$4,085.10}$

5. Attire, hair and makeup gets 5.3191% of the budget

   $\mathrm{\$32,000.00}\times \mathrm{5.3191\%}$$=\mathrm{\$1,702.13}$

6. Divide venue, food and drink by the guests, since it's usually the cost that grows with the guest list

   $\frac{\mathrm{\$14,978.72}}{115}$$=\mathrm{\$130.25}$

7. Check that the category amounts add back up to the total budget

   $\mathrm{\$14,978.72}+\mathrm{\$4,085.10}+\mathrm{\$1,702.13}+\mathrm{\$2,382.98}+\mathrm{\$2,382.98}+\mathrm{\$1,702.13}+\mathrm{\$1,702.13}+\mathrm{\$3,063.83}$$=\mathrm{\$32,000.00}$

4. Total budget per guest: $400.00

1. Divide the total budget by the number of guests to see what each guest's share costs

   $\frac{\mathrm{\$34,000.00}}{85}$$=\mathrm{\$400.00}$

2. The shares add up to 107%, not 100%. So each one is scaled by 100 ÷ 107 to use the whole budget. For the first category

   $\mathrm{55\%}\times \frac{100}{107}$$=\mathrm{51.4019\%}$

3. Venue, food and drink gets 51.4019% of the budget

   $\mathrm{\$34,000.00}\times \mathrm{51.4019\%}$$=\mathrm{\$17,476.64}$

4. Photography and video gets 11.215% of the budget

   $\mathrm{\$34,000.00}\times \mathrm{11.215\%}$$=\mathrm{\$3,813.08}$

5. Attire, hair and makeup gets 5.6075% of the budget

   $\mathrm{\$34,000.00}\times \mathrm{5.6075\%}$$=\mathrm{\$1,906.54}$

6. Divide venue, food and drink by the guests, since it's usually the cost that grows with the guest list

   $\frac{\mathrm{\$17,476.64}}{85}$$=\mathrm{\$205.61}$

7. Check that the category amounts add back up to the total budget

   $\mathrm{\$17,476.64}+\mathrm{\$3,813.08}+\mathrm{\$1,906.54}+\mathrm{\$2,542.06}+\mathrm{\$2,224.30}+\mathrm{\$1,271.03}+\mathrm{\$1,588.78}+\mathrm{\$3,177.57}$$=\mathrm{\$34,000.00}$

5. Total budget per guest: $333.33

1. Divide the total budget by the number of guests to see what each guest's share costs

   $\frac{\mathrm{\$25,000.00}}{75}$$=\mathrm{\$333.33}$

2. The shares add up to 99%, not 100%. So each one is scaled by 100 ÷ 99 to use the whole budget. For the first category

   $\mathrm{45\%}\times \frac{100}{99}$$=\mathrm{45.4545\%}$

3. Venue, food and drink gets 45.4545% of the budget

   $\mathrm{\$25,000.00}\times \mathrm{45.4545\%}$$=\mathrm{\$11,363.64}$

4. Photography and video gets 12.1212% of the budget

   $\mathrm{\$25,000.00}\times \mathrm{12.1212\%}$$=\mathrm{\$3,030.30}$

5. Attire, hair and makeup gets 6.0606% of the budget

   $\mathrm{\$25,000.00}\times \mathrm{6.0606\%}$$=\mathrm{\$1,515.15}$

6. Divide venue, food and drink by the guests, since it's usually the cost that grows with the guest list

   $\frac{\mathrm{\$11,363.64}}{75}$$=\mathrm{\$151.52}$

7. Check that the category amounts add back up to the total budget

   $\mathrm{\$11,363.64}+\mathrm{\$3,030.30}+\mathrm{\$1,515.15}+\mathrm{\$1,767.68}+\mathrm{\$2,272.73}+\mathrm{\$757.57}+\mathrm{\$1,262.63}+\mathrm{\$3,030.30}$$=\mathrm{\$25,000.00}$

6. Total budget per guest: $261.90

1. Divide the total budget by the number of guests to see what each guest's share costs

   $\frac{\mathrm{\$27,500.00}}{105}$$=\mathrm{\$261.90}$

2. The shares add up to 99%, not 100%. So each one is scaled by 100 ÷ 99 to use the whole budget. For the first category

   $\mathrm{50\%}\times \frac{100}{99}$$=\mathrm{50.5051\%}$

3. Venue, food and drink gets 50.5051% of the budget

   $\mathrm{\$27,500.00}\times \mathrm{50.5051\%}$$=\mathrm{\$13,888.89}$

4. Photography and video gets 9.0909% of the budget

   $\mathrm{\$27,500.00}\times \mathrm{9.0909\%}$$=\mathrm{\$2,500.00}$

5. Attire, hair and makeup gets 8.0808% of the budget

   $\mathrm{\$27,500.00}\times \mathrm{8.0808\%}$$=\mathrm{\$2,222.22}$

6. Divide venue, food and drink by the guests, since it's usually the cost that grows with the guest list

   $\frac{\mathrm{\$13,888.89}}{105}$$=\mathrm{\$132.28}$

7. Check that the category amounts add back up to the total budget

   $\mathrm{\$13,888.89}+\mathrm{\$2,500.00}+\mathrm{\$2,222.22}+\mathrm{\$1,388.89}+\mathrm{\$2,777.78}+\mathrm{\$1,388.89}+\mathrm{\$1,388.89}+\mathrm{\$1,944.44}$$=\mathrm{\$27,500.00}$

7. Total budget per guest: $200.00

1. Divide the total budget by the number of guests to see what each guest's share costs

   $\frac{\mathrm{\$24,000.00}}{120}$$=\mathrm{\$200.00}$

2. The shares add up to 97%, not 100%. So each one is scaled by 100 ÷ 97 to use the whole budget. For the first category

   $\mathrm{40\%}\times \frac{100}{97}$$=\mathrm{41.2371\%}$

3. Venue, food and drink gets 41.2371% of the budget

   $\mathrm{\$24,000.00}\times \mathrm{41.2371\%}$$=\mathrm{\$9,896.91}$

4. Photography and video gets 13.4021% of the budget

   $\mathrm{\$24,000.00}\times \mathrm{13.4021\%}$$=\mathrm{\$3,216.50}$

5. Attire, hair and makeup gets 8.2474% of the budget

   $\mathrm{\$24,000.00}\times \mathrm{8.2474\%}$$=\mathrm{\$1,979.38}$

6. Divide venue, food and drink by the guests, since it's usually the cost that grows with the guest list

   $\frac{\mathrm{\$9,896.91}}{120}$$=\mathrm{\$82.47}$

7. Check that the category amounts add back up to the total budget

   $\mathrm{\$9,896.91}+\mathrm{\$3,216.50}+\mathrm{\$1,979.38}+\mathrm{\$2,474.23}+\mathrm{\$1,979.38}+\mathrm{\$989.69}+\mathrm{\$1,237.11}+\mathrm{\$2,226.80}$$=\mathrm{\$24,000.00}$

8. Total budget per guest: $514.29

1. Divide the total budget by the number of guests to see what each guest's share costs

   $\frac{\mathrm{\$36,000.00}}{70}$$=\mathrm{\$514.29}$

2. The shares add up to 111%, not 100%. So each one is scaled by 100 ÷ 111 to use the whole budget. For the first category

   $\mathrm{50\%}\times \frac{100}{111}$$=\mathrm{45.045\%}$

3. Venue, food and drink gets 45.045% of the budget

   $\mathrm{\$36,000.00}\times \mathrm{45.045\%}$$=\mathrm{\$16,216.22}$

4. Photography and video gets 10.8108% of the budget

   $\mathrm{\$36,000.00}\times \mathrm{10.8108\%}$$=\mathrm{\$3,891.89}$

5. Attire, hair and makeup gets 9.009% of the budget

   $\mathrm{\$36,000.00}\times \mathrm{9.009\%}$$=\mathrm{\$3,243.24}$

6. Divide venue, food and drink by the guests, since it's usually the cost that grows with the guest list

   $\frac{\mathrm{\$16,216.22}}{70}$$=\mathrm{\$231.66}$

7. Check that the category amounts add back up to the total budget

   $\mathrm{\$16,216.22}+\mathrm{\$3,891.89}+\mathrm{\$3,243.24}+\mathrm{\$2,918.92}+\mathrm{\$3,243.24}+\mathrm{\$1,297.30}+\mathrm{\$1,621.62}+\mathrm{\$3,567.57}$$=\mathrm{\$36,000.00}$

9. Total budget per guest: $250.00

1. Divide the total budget by the number of guests to see what each guest's share costs

   $\frac{\mathrm{\$25,000.00}}{100}$$=\mathrm{\$250.00}$

2. The shares add up to 106%, not 100%. So each one is scaled by 100 ÷ 106 to use the whole budget. For the first category

   $\mathrm{45\%}\times \frac{100}{106}$$=\mathrm{42.4528\%}$

3. Venue, food and drink gets 42.4528% of the budget

   $\mathrm{\$25,000.00}\times \mathrm{42.4528\%}$$=\mathrm{\$10,613.21}$

4. Photography and video gets 10.3774% of the budget

   $\mathrm{\$25,000.00}\times \mathrm{10.3774\%}$$=\mathrm{\$2,594.34}$

5. Attire, hair and makeup gets 10.3774% of the budget

   $\mathrm{\$25,000.00}\times \mathrm{10.3774\%}$$=\mathrm{\$2,594.34}$

6. Divide venue, food and drink by the guests, since it's usually the cost that grows with the guest list

   $\frac{\mathrm{\$10,613.21}}{100}$$=\mathrm{\$106.13}$

7. Check that the category amounts add back up to the total budget

   $\mathrm{\$10,613.21}+\mathrm{\$2,594.34}+\mathrm{\$2,594.34}+\mathrm{\$1,886.79}+\mathrm{\$2,122.64}+\mathrm{\$707.55}+\mathrm{\$1,415.09}+\mathrm{\$3,066.04}$$=\mathrm{\$25,000.00}$

10. Total budget per guest: $283.02

1. Divide the total budget by the number of guests to see what each guest's share costs

   $\frac{\mathrm{\$30,000.00}}{106}$$=\mathrm{\$283.02}$

2. The shares add up to 91%, not 100%. So each one is scaled by 100 ÷ 91 to use the whole budget. For the first category

   $\mathrm{40\%}\times \frac{100}{91}$$=\mathrm{43.956\%}$

3. Venue, food and drink gets 43.956% of the budget

   $\mathrm{\$30,000.00}\times \mathrm{43.956\%}$$=\mathrm{\$13,186.82}$

4. Photography and video gets 13.1868% of the budget

   $\mathrm{\$30,000.00}\times \mathrm{13.1868\%}$$=\mathrm{\$3,956.05}$

5. Attire, hair and makeup gets 6.5934% of the budget

   $\mathrm{\$30,000.00}\times \mathrm{6.5934\%}$$=\mathrm{\$1,978.02}$

6. Divide venue, food and drink by the guests, since it's usually the cost that grows with the guest list

   $\frac{\mathrm{\$13,186.82}}{106}$$=\mathrm{\$124.40}$

7. Check that the category amounts add back up to the total budget

   $\mathrm{\$13,186.82}+\mathrm{\$3,956.05}+\mathrm{\$1,978.02}+\mathrm{\$2,307.69}+\mathrm{\$2,637.36}+\mathrm{\$989.01}+\mathrm{\$1,978.02}+\mathrm{\$2,967.03}$$=\mathrm{\$30,000.00}$