48 17548 1139 1707 2470 1006 921 1233 1087 1360

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $0 $0 $0 $0 $0 $2,500 $2,500 $2,500 Secretarial $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,750 $1,750 $1,750 Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $17,000 $27,250 3 3 3 3 3 3 3 3 4 7 Total Payroll Total Headcount Payroll Burden Total Payroll Expenditures $1,680 $1,680 $1,680 $1,680 $1,680 $1,680 $1,680 $1,680 $2,380 $3,815 $13,680 $13,680 $13,680 $13,680 $13,680 $13,680 $13,680 $13,680 $19,380 $31,065 Aug Sep Oct SAMPLE PLAN: ACME CONSULTING Personnel Plan $27,250 $27,250 7 7 $3,815 $3,815 $31,065 $31,065 General Assumptions Jan Feb Mar Apr May Jun Jul Short-term Interest Rate % 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% 8.00% Long-term Interest Rate % 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% Nov Dec Payment Days Estimator 35 35 35 35 35 35 35 35 35 35 35 35 Collection Days Estimator 45 45 45 45 45 45 45 45 45 45 45 45 Tax Rate % 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% Expenses in Cash % 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% Sales on Credit % Personnel Burden % 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% 14.00% SP1.21 Jan Sales Direct Cost of Sales Other Feb Mar Apr May Jun Jul Aug Sep Oct $10,000 $10,000 $20,000 $34,000 $58,000 $75,000 $50,000 $35,000 $70,000 $85,000 $90,000 $55,000 $2,500 $2,500 $4,000 $8,000 $13,500 $19,000 $12,000 $8,000 $21,500 $24,000 $25,000 $19,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 SP1.22 Profit and Loss (Income Statement) Nov $0 Dec $0 ——————————————————————————————————————————————————————————————————————— Total Cost of Sales $2,500 $2,500 $4,000 $8,000 $13,500 $19,000 $12,000 $8,000 $21,500 $24,000 $25,000 $19,000 Gross Margin $7,500 $7,500 $16,000 $26,000 $44,500 $56,000 $38,000 $27,000 $48,500 $61,000 $65,000 $36,000 75.00% 75.00% 80.00% 76.47% 76.72% 74.67% 76.00% 77.14% 69.29% 71.76% 72.22% Gross Margin % 65.45% Operating expenses: Advertising/Promotion $3,000 $3,000 $3,000 $3,...
View Full Document

This note was uploaded on 01/26/2014 for the course BUINESS 102 taught by Professor Unknown during the Winter '09 term at University of Phoenix.

Ask a homework question - tutors are online