Back To Table of Contents

Download This Workbook

BUSINESS BUDGET

           
   
SUMMARY

ACTUAL

BUDGETED

OVER BUDGET

UNDER BUDGET

 
Total income

1,432,500.00

1,318,080.00

114,420.00

   
Total expenses

350,760.00

314,910.00

35,850.00

   
Income less expenses:

1,081,740.00

1,003,170.00

78,570.00

   
 
INCOME DETAILS

ACTUAL

BUDGETED

OVER BUDGET

UNDER BUDGET

NOTES

Sales

1,400,000.00

1,200,000.00

200,000.00

  Increase advertising next year.
Interest earned

5,000.00

4,500.00

500.00

   
Fees

1,000.00

980.00

20.00

   
Commissions

10,000.00

98,000.00

 

-88,000.00

 
Rent

9,000.00

8,000.00

1,000.00

   
Royalties

2,500.00

2,600.00

 

-100.00

 
Other

5,000.00

4,000.00

1,000.00

   
Total income:

1,432,500.00

1,318,080.00

114,420.00

   
 
EXPENSE DETAILS

ACTUAL

BUDGETED

OVER BUDGET

UNDER BUDGET

NOTES

SELLING          
Salaries and wages

257,000.00

248,000.00

9,000.00

   
Commissions

10,000.00

12,000.00

 

-2,000.00

 
Advertising

6,000.00

8,000.00

 

-2,000.00

Increase Here 3%.
Delivery

0.00

0.00

     
Shipping

0.00

0.00

     
Travel

4,600.00

5,600.00

 

-1,000.00

 
Other

1,000.00

1,200.00

 

-200.00

 
Total sales expenses:

278,600.00

274,800.00

3,800.00

   
Percent of total:

79.43%

87.26%

     
ADMINISTRATIVE          
Salaries and wages

12,000.00

10,000.00

2,000.00

   
Employee benefits

5,000.00

6,000.00

 

-1,000.00

 
Payroll taxes

500.00

500.00

     
Insurance

14,000.00

14,000.00

     
Loans

6,000.00

5,000.00

1,000.00

   
Office supplies

4,000.00

4,100.00

 

-100.00

 
Travel & entertainment

200.00

190.00

10.00

   
Postage

300.00

320.00

 

-20.00

 
Furnishings

0.00

0.00

     
Contributions

0.00

0.00

     
Dues

0.00

0.00

     
Other

0.00

0.00

     
Total admin. expenses:

42,000.00

40,110.00

1,890.00

   
Percent of total:

11.97%

12.74%

     
SERVICE & EQUIPMENT        
Accounting

1,200.00

1,500.00

 

-300.00

 
Legal

5,000.00

6,000.00

 

-1,000.00

 
Utilities

15,000.00

15,789.00

 

-789.00

Too high.
Telephone

5,000.00

4,800.00

200.00

   
Equipment purchases

3,400.00

3,000.00

400.00

   
Rent & maintenance

560.00

600.00

 

-40.00

 
Other

0.00

0.00

     
Total S&E expenses:

30,160.00

31,689.00

 

-1,529.00

 
Percent of total:

0.09

0.10

     

Back To Table of Contents

  Copyright, 2014, JaxWorks, All Rights Reserved.