Appendices for GM 600 - Staffing Budget 2011 TOTA L 2012...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Staffing Budget 2011 2012 2013 TOTA L TOTAL Management # Employees Salary/Wages $14,0 00 $36,000 Benefits $7,92 0 $8,316 Payroll Taxes $2,10 0 $5,400 Total Costs $24,0 20 $49,716 Administrative/Support # Employees Salary/Wages $21,1 20 $21,859 Benefits $7,92 0 $8,316 Payroll Taxes $3,16 8 $3,279 Total Costs $32,2 08 $33,454 Sales/Marketing # Employees Salary/Wages $46,9 44 $72,881 Benefits $15,8 40 $24,948 Payroll Taxes $7,04 2 $10,932 Total Costs $69,8 26 $108,761 Operations/Production # Employees Salary/Wages $0 $0 Benefits $0 $0 Payroll Taxes $0 $0 Total Costs $0 $0 Other # Employees Salary/Wages $0 $0 Benefits $0 $0 Payroll Taxes $0 $0 Total Costs $0 $0 TOTAL # Employees Salary/Wages $82,0 64 $130,740
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Benefits $31,6 80 $41,580 Payroll Taxes $12,3 10 $19,611 GRAND TOTAL COSTS $126, 054 $191,931 Sales Projections 2011 2012 TOTA L TOTAL Homeowner's Insurance Unit Volume 460 668 Unit Price Gross Sales $598, 307 $867,817 (Commissions) $5,98 3 $8,678 (Returns and Allowances) $5,98 3 $8,678 Net Sales $586, 340 $850,461 (Cost of Goods Sold) $490, 611 $711,610 GROSS PROFIT $95,7 29 $138,851 Renter's Insurance Unit Volume 213 304 Unit Price Gross Sales $53,2 20 $75,879 (Commissions) $532 $759 (Returns and Allowances) $532 $759 Net Sales $52,1 56 $74,362 (Cost of Goods Sold) $43,6 40 $62,221 GROSS PROFIT $8,51 5 $12,141 Condominium Insurance Unit Volume 142 202 Unit Price Gross Sales $170, 304 $242,813 (Commissions) $1,70 3 $2,428 (Returns and Allowances) $1,70 3 $2,428 Net Sales $166, 898 $237,957 (Cost of Goods Sold) $139, 650 $199,107 GROSS PROFIT $27,2 49 $38,850
Background image of page 2
Pesonal Liability Umbrella Policy Unit Volume 57 81 Unit Price Gross Sales $17,0 30 $24,281 (Commissions) $170 $243 (Returns and Allowances) $170 $243 Net Sales $16,6 90 $23,796 (Cost of Goods Sold) $13,9 65 $19,911 GROSS PROFIT $2,72 5 $3,885 Personal Articles Policies Unit Volume 80 102 Unit Price Gross Sales $10,0 59 $12,757 (Commissions) $101 $128 (Returns and Allowances) $101 $128 Net Sales $9,85 8 $12,502 (Cost of Goods Sold) $8,24 8 $10,461 GROSS PROFIT $1,60 9 $2,041 Sales Projections 2011 2012 Sales Projections 2011 2012 TOTA L TOTAL Unit Volume 331 529 Unit Price Gross Sales $595, 022 $952,649 (Commissions) $5,95 0 $9,526 (Returns and Allowances) $5,95 0 $9,526 Net Sales $583, 121 $933,596 (Cost of Goods Sold)
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/26/2012 for the course GM600 GM600 taught by Professor Professor during the Summer '10 term at Keller Graduate School of Management.

Page1 / 11

Appendices for GM 600 - Staffing Budget 2011 TOTA L 2012...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online