one page budget worksheet

8/12/2019 One Page Budget Worksheet

1/9


2/9

Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 MonthRevenues 3,500 4,000 4,500 5,000 5,500 6,000 6,500 7,000 7,500 8,000 8,500 9,00

- Discounts - ReturnsNet Sales 3,500 4,000 4,500 5,000 5,500 6,000 6,500 7,000 7,500 8,000 8,500 9,000

Overhead Expenses - Salaries & Wages 1,800 1,800 1,800 2,500 2,750 2,750 3,000 3,500 3,500 4,500 4,500 4,500 - Overtime - Employer Taxes 180 180 180 250 275 275 300 350 350 450 450 45 - Employee Benefits 350 350 350 350 350 350 350 350 350 350 350 35

Staff Expenses 2,330 2,330 2,330 3,100 3,375 3,375 3,650 4,200 4,200 5,300 5,300 5,300Staffing Percent 66.6% 58.3% 51.8% 62.0% 61.4% 56.3% 56.2% 60.0% 56.0% 66.3% 62.4% 58.9%

Accounting Fees 100 100 100 100 100 100 100 100 100 100 100 10 Advertising Auto Expenses 50 50 50 50 50 50 50 50 50 50 50Bank Fees 25 25 25 25 25 25 25 25 25 25 25Computer Expenses 100 100 100 100 100 100 100 100 100 100 100 10Equipment Insurance

Internet Services 150 150 150 150 150 150 150 150 1,500 150 150 15Legal FeesMarketing Expenses 100 250 500 500 500 1,000 1,000 500 750 500 500 50Meals & Entertainment 75 75 75 75 75 75 75 75 75 75 75Office SuppliesPhone 100 100 100 100 100 100 100 100 100 100 100 1FreightRent 400 400 400 400 400 400 400 400 400 400 400 4Sales CommissionsSales Expenses

Travel 750 1,500Utilities 50 50 50 50 50 50 50 50 50 50 50

Non-Staff Expenses 1,150 1,300 1,550 1,550 1,550 2,050 2,800 1,550 3,150 1,550 3,050 1,550Non-Staff Percent 32.9% 32.5% 34.4% 31.0% 28.2% 34.2% 43.1% 22.1% 42.0% 19.4% 35.9% 17.2%

Total Overhead 3,480 3,630 3,880 4,650 4,925 5,425 6,450 5,750 7,350 6,850 8,350 6,850

Total Overhead Percent 99.4% 90.8% 86.2% 93.0% 89.5% 90.4% 99.2% 82.1% 98.0% 85.6% 98.2% 76.1%

Profit before Tax 20 370 620 350 575 575 50 1,250 150 1,150 150 2,1

Budget for 2007Prepared by: Christina Mora Date: November 1, 2006

Career Transitions Coaching Services


3/9

Career Transitions Coaching Services Budget for 2007

Prepared by: Christina Mora Date: November 1, 2006

$0$1,000$2,000$3,000

$4,000$5,000$6,000$7,000$8,000$9,000

$10,000

Sales, Overhead & Profit before Tax

Revenues Total Overhead Profit before Tax

Profit

Sales

Overhead Expenses

0.0%

20.0%

40.0%

60.0%

80.0%

100.0%

120.0%

1 2 3 4 5 6 7 8 9 10 11 12

Key Financial Percentages

Total Overhead Profit Before Tax

Staff Expenses Non-Staff Expenses

Staffing,$44,790 , 66%

Non-Staff,$22,800 , 34%

Overhead Expenses by Category

Staff ing Non-Staff

$0$5,000

$10,000

$15,000

$20,000

$25,000

$30,000

Q1 Q2 Q3 Q4

Sales & Profit by Quarter

Sales Profit

2003 The One Page Business Plan Company. All Rights Reserved. For additional information on other products or services visit www.onepagebusinessplan.com


4/9

Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 MonthGross Sales 27,500 30,000 32,500 35,000 37,500 40,000 42,500 45,000 47,500 55,000 57,500 60,000

- Discounts (825) (900) (975) (1,050) (1,125) (1,200) (1,275) (1,350) (1,425) (1,650) (1,725) (1,8 - ReturnsNet Sales 26,675 29,100 31,525 33,950 36,375 38,800 41,225 43,650 46,075 53,350 55,775 58,200

Cost of Sales- Subcontractor fees 9,075 9,900 10,725 11,550 12,375 13,200 14,025 14,850 15,675 18,150 18,975 19,800

- Materials 4,400 4,800 5,200 5,600 6,000 6,400 6,800 7,200 7,600 8,800 9,200 9,60- Overhead 2,500 2,500 2,500 2,500 2,500 4,000 4,000 4,000 4,000 5,000 5,000 5,000

Total Cost of Goods Sold 15,975 17,200 18,425 19,650 20,875 23,600 24,825 26,050 27,275 31,950 33,175 34,400

Gross Profit 10,700 11,900 13,100 14,300 15,500 15,200 16,400 17,600 18,800 21,400 22,600 23,800Gross Profit Percent 40.1% 40.9% 41.6% 42.1% 42.6% 39.2% 39.8% 40.3% 40.8% 40.1% 40.5% 4

Overhead Expenses - Salaries & Wages 8,000 8,000 8,000 8,000 8,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 - Overtime 500 500 500 500 1,500 1,500 1,500 1,500 1,500 500 500 5 - Employer Taxes 800 800 800 800 800 1,000 1,000 1,000 1,000 1,000 1,000 1,00 - Employee Benefits 1,000 1,000 1,000 1,000 1,000 1,250 1,250 1,250 1,250 1,250 1,250 1,250

Total Staffing Expenses 10,300 10,300 10,300 10,300 11,300 13,750 13,750 13,750 13,750 12,750 12,750 12,750

Accounting Fees 200 200 200 200 750 200 200 200 200 200 200 2 Advertising 500 500 500 500 500 500 500 500 500 500 500 Auto Expenses 500 500 500 500 500 500 500 500 500 500 500 5Bank Fees 75 75 75 75 75 75 75 75 75 75 75Computer Expenses 200 200 200 200 200 200 200 200 200 200 200 2Equipment 80 80 80 80 80 80 80 80 80 80 80Insurance 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500Internet Services 100 100 100 100 100 100 100 100 100 100 100 1Legal Fees 250 250 250 250 250 250 250 250 250 250 250Marketing Expenses 500 500 500 500 500 500 500 500 500 500 500 5

Meals & Entertainment 200 200 200 200 200 200 200 200 200 200 200 2Office Supplies 200 200 200 200 200 200 200 200 200 200 200Phone 200 200 200 200 200 200 200 200 200 200 200FreightRent 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,500 1,50Sales CommissionsSales Expenses 300 300 300 300 300 300 300 300 300 300 300 3Travel 1,500 500Utilities 150 150 150 150 150 150 150 150 150 150 150

Consolidated Budget for 2007Prepared by: Bill Jones Date: November 15, 2006

The New Sales Manager Training Company ( a young, growing company)


5/9

The New Sales Manager Training Company ( a young, growing company)Consolidated Budget for 2007

Prepared by: Bill Jones Date: November 15, 2006

($10,000)

$0

$10,000

$20,000

$30,000

$40,000

$50,000

$60,000

$70,000


Gross Sales Total Overhead Expenses Profit before Tax

Profit

Sales

Overhead Expenses

-30.0%

-20.0%

-10.0%

0.0%

10.0%

20.0%

30.0%

40.0%

50.0%

60.0%

70.0%

1 2 3 4 5 6 7 8 9 10 11 12


Cost of Goods Sold Gross Profit

Overhead Expenses Profit Before Tax

Labor,$168,300 , 57%

Materials,$81,600 , 28%

Overhead,$43,500 , 15%

Cost of Goods Sold

Labor Materials Overhead

Profit$0

$50,000

$100,000

$150,000

$200,000

Q1 Q2 Q3 Q4Q1 Q2 Q3 Q4

Profit (14,565) (11,765) (8,315) 10,185Sales 90,000 112,500 135,000 172,500


Profit Sales



6/9

Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 1Gross Sales

- Discounts - ReturnsNet Sales 0 0 0 0 0 0 0 0 0 0 0

Cost of Goods Sold- Labor

- Materials - Overhead

Total Cost of Goods Sold 0 0 0 0 0 0 0 0 0 0 0

Gross Profit 0 0 0 0 0 0 0 0 0 0 0Gross Profit Percent

Overhead Expenses - Salaries & Wages - Overtime - Employer Taxes - Employee Benefits

Total Staffing Expenses 0 0 0 0 0 0 0 0 0 0 0

Accounting Fees Advertising Auto ExpensesBank FeesComputer ExpensesEquipment Insurance Internet ServicesLegal FeesMarketing ExpensesMeals & EntertainmentOffice SuppliesPhone FreightRent Sales CommissionsSales Expenses Travel Utilities

Consolidated Budget for 2004Prepared by: Date:

Your Company Name


7/9

Your Company NameConsolidated Budget for 2004

Prepared by: Date:

$0$0$0

$0$0$1$1$1$1$1$1


Gross Sales Total Overhead Expenses Profit before Tax

Profit

Sales

Overhead Expenses

0.0%

10.0%20.0%

30.0%

40.0%

50.0%

60.0%

70.0%

80.0%

90.0%100.0%

1 2 3 4 5 6 7 8 9 10 11 12


Cost of Goods Sold Gross Profit

Overhead Expenses Profit Before Tax

Labor, $- ,0%

Materials, $- ,0%

Overhead, $-, 0%

Cost of Goods Sold

Labor Materials Overhead

$0$0$0$0$0$1$1$1$1$1$1

Q1 Q2 Q3 Q4


Sales Profit



8/9

Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12Revenues

- Discounts

Net Sales 0 0 0 0 0 0 0 0 0 0 0

Overhead Expenses - Salaries & Wages - Overtime - Employer Taxes - Employee Benefits

Staff Expenses 0 0 0 0 0 0 0 0 0 0 0Staffing Percent

Accounting Fees Advertising Auto ExpensesBank FeesComputer ExpensesEquipment Insurance Internet ServicesLegal FeesMarketing ExpensesMeals & EntertainmentOffice SuppliesPhone FreightRent Sales CommissionsSales ExpensesTravel Utilities

Non-Staff Expenses 0 0 0 0 0 0 0 0 0 0 0Non-Staff Percent

Total Overhead 0 0 0 0 0 0 0 0 0 0 0

Total Overhead Percent

Profit before Tax 0 0 0 0 0 0 0 0 0 0 0

Profit before Tax Percent

Consolidated Budget for 2004Prepared by: Date:

Your Company Name


9/9

Your Company NameConsolidated Budget for 2004

Prepared by: Date:

$0$0$0$0$0$1$1$1$1$1$1


Revenues Total Overhead Profit before Tax

Profit

Sales

Overhead Expenses

0.0%

10.0%

20.0%30.0%

40.0%

50.0%

60.0%

70.0%

80.0%

90.0%

100.0%

1 2 3 4 5 6 7 8 9 10 11 12


Total Overhead Profit Before Tax

Staff Expenses Non-Staff Expenses

Staffing, $- ,0%

Non-Staff, $- ,0%

Overhead Expenses by Category

Staffing Non-Staff

$0$0$0$0$0$1$1$1$1$1$1

Q1 Q2 Q3 Q4


Sales Profit


one page budget worksheet

Documents