Heyberger Excel Budget

TECHNOLOGY ASSO Budget Estimates Hey *using estimates and actual from december to plan January budget INCOME ESTIMATED ACTUAL DIFFERENCE EVALUATE ESTIAMTES Net sales 65,000 53,000 (12,000) EVALUATE Interest income 2,300 2,300 0 EVALUATE Asset sales (gain/loss) 300 450 150 Total Income 67,600 55,750 (11,850) PERSONNEL ESTIMATED ACTUAL DIFFERENCE EVALUATE ESTIMATES Wages 10,000 9,801 (199) EVALUATE Employee benefits 4,000 4,200 200 Commision 5,000 4,500 (500) EVALUATE Subcontractors 2,500 3,800 1,300 Total Personnel Expenses 21,500 22,301 801 OPERATING EXPENSES ESTIMATED ACTUAL DIFFERENCE EVALUATE ESTIMATES Advertisitng 3,000 3,401 401 Bad debts 2,000 2,000 0 EVALUATE Cash Discounts 1,500 2,175 675 Comp Equipment 7,000 7,101 101 Delivery costs 2,000 1,500 (500) EVALUATE Deprecitation 1,200 1,200 0 EVALUATE Dues and Subscriptions 450 450 0 EVALUATE Insurance 1,300 1,275 (25) EVALUATE Interest 2,000 2,200 200 Legal and auditing 1,000 800 (200) EVALUATE Maintenance and repairs 4,500 4,600 100 Office supplies 800 751 (49) EVALUATE Postage 400 350 (50) EVALUATE Rent or mortgage 4,300 430 (3,870) EVALUATE Sales expenses 350 400 50 Shipping and storage 900 840 (60) EVALUATE Supplies 5,000 4,500 (500) EVALUATE Taxes 3,000 3,200 200 Telephone 250 280 30 Technology exp 2,000 2,500 500 Utilites 1,400 1,475 75 Total Operating expenses 44,350 41,427 (2,923)

OCIATES yberger Min, Max, and Average Operating Expenses Min Max Average 280 7,101 1,973 % OF INCOME vs EXPENSES %of income spent Personnel % of Income spent Operating Exp Profit / Loss 40% 74% -14% Benefits calculations $50,400

50.00% 41.24% 8.76% Income Differences ESTIMATED ACTUAL DIFFERENCE