please help me calculate the budget balance sheet

Cost Basics Units Produced 659,329 Direct Material Cost Per Unit (5) Water $0.01 Clay Powder $1 .30 Quartz $0.15 Feldspar $0.09 Glaze $0.80 Paint $0.06 Total Material Cost Per Unit $2.41 Direct Labor Hours Per Unit Portion Cutters 0.003 Cup Molders 0.005 Handle Molders 0.009 Handle Attachers 0.006 Technician 0.004 Painters 0.015 Total Labor Cost 0.042 Fixed Assets Quantity Mixer 2 Molding Tubes 2 Molding Machines 5 Padding Machine 4 Drying Racks 500 Conveyor Ovens 1 Total Assets Wage Per Hour $14.00 $14.00 $15.00 $16.00 $20.00 $17.00 $96.00 Cost $8,000 $3,000 $4,000 $3,000 $10 $20,000 Cost Per Unit $0.04 $0.07 $0.14 $0.10 $0.08 $0.26 $0.68 Total Cost $1 6,000 $6,000 $20,000 $12,000 $5,000 $20,000 $79,000 Variable MOH Utilities Indirect Materials Maintenance Total Variable MOH Costs Fixed MOH Rent Insurance Depreciation Manager Salaries Proprty Taxes Total Fixed MOH Costs Variable Expenses Sales Commissions Shipping Costs Total Variable Expense Fixed Expenses Sales Salaries Ofce Salaries Advertising Expense Depreciation Utilities Total Fixed Expense 'otal Selling 8. Administrative Expense Variable Costs Direct Material Direct Labor Variable Manufacture Overhead Variable Selling and Administrative Total Variable Cost Per Year $10,000 $5,800 $9,500 $25,300 Per Year $34,000.00 $13,500.00 $5,600.00 $65,000.00 $25,000.00 $143,100.00 Per Unit $0.45 $4.00 $4.45 Per Unit $0.12 $0.25 $0.01 $0.03 $0.01 5 $0.43 $4.88 Per Unit $2.41 $068 $0.04 $445 $7.58 Per Unit $0.02 $001 $0.01 $004 Per Unit $0.05 $002 $0.01 $0.10 $0.04 $022 Per Month $24,724.84 $219,776.33 $244,501 .17 Per Month $1 ,740.00 $3,625.00 $725.00 $2,175.00 $1 ,087.50 $9,352.50 $253,853.67 Per Month $132,415.24 $37,252.09 $2,108.33 $244,501 .17 $416,276.83 Per Year Units to be Sold $296,698.05 $2,637,316.00 $2,934,014.05 Per Year $20,880.00 $43,500.00 $8,700.00 $26,100.00 $13,050.00 $1 12,230.00 $3,046,244.05 Per Year $1,588,982.89 $447,025.06 $25,300 $2,934,014.05 $4,995,322.00 659,329 659,329 Table 6: Fixed and Variable Costs Variable Costs Per Unit Per Month Per Year Direct Material $2.41 $132,415.24 $1,588,982.89 Direct Labor $0.68 $37,252.09 $447,025.06 Variable Manufacture Overhead $0.04 $2,108.33 $25,300 Variable Selling and Administrative $4.45 $244,501.17 $2,934,014.05 Total Variable Cost $7.58 $416,276.83 $4,995,322.00 Fixed Costs Per Unit Per Month Per Year Fixed Manufacture Overhead $0.22 $11,925.00 $143, 100.00 Fixed Selling and Aministrative $0.43 $9,352.50 $1 12,230.00 Total Fixed Cost $0.64 $21,277.50 $255,330.00 Total Fixed and Variable Cost $8.22 $437,554.33 $5,250,652.00Group 10 Manufacturing Budgeted Balance Sheet For the Year Endin 202x Current Assets Cash Accounts Receivable Raw Goods Inventory Finished Goods Inveentory Total Current Assets Property, Plant, and Equipment Buildings and Equipment Less: Accumulated Depreciation Total Property, Plant, and Equipment Total Assets Liabilities & Stockholders' Equity Liabilities Accounts Payable Income Tax Payable Total Current Liabilities Stockholders' Equity Common Stock Retained Earnings Total Stockholders' Equity Total Liability and Stockholders' Equity Selling Price Variable Costs Contribution Margin Fixed Costs Net Income Break-even Point Break-even Sales Variable Costs Contribution Margin Fixed Costs Net Income Units Required to Break-even Target Prot Target Sales Target Units Target Sales Variable Cost Contribution Margin Fixed Costs Target Net Income Margin of Safety Margin of Safety Ratio Cost Volume Profit Anal sis Per Unit $25.00 $7.58 $17.42 $0.64 $16.78 Annual $5,253,042 .82 $4,997,713.82 $255,330 $255,330 $0 210121 Annual $11,000,000.00 $16,483,225.00 $659,329.00 Annual $16,483,225.00 $4,995,322.00 $11 ,487,903.00 $255,330 11 ,232,573.00 Ratio 0.3 0.54 Group 10 Manufacturing Budgeted Income Statement For the Year Ending December 31, 202X Revenue Net Sales $16,153,560.50 100% Less: Cost of Good Sold -1662430.05 -500946.9 Gross Profit $13,990,183.55 Expenses Selling and Administrative Expenses Income From Operations Interest Expense Income Before income Taxes Income Tax Expense Net Income Group 10 Manufacturing Budgeted Balance Sheet For the Year Ending 202XGroup 10 Manufacturing Selling & Administrative Expense Budget For The Year Ending Ending December 31, 202X Quarters Year 2 3 4 G Budgeted Sales in Units 160.400 169,489 158,353 171,087 659,329 ariable Expenses Sales Commissions $72,180.00 $76,270.05 $71,258.85 $76,989.15 $296,698.05 Shipping Costs $641,600.00 $677,956.00 $633,412.00 $684 348.00 $2,637,316.00 Total Variable Expenses $713,780.00 $754,226.05 $704,670.85 $761,337.15 $2,934,014.05 Fixed Expenses Sales Salaries $5,220.00 $5,220.00 $5,220.00 $5,220.00 $20,880.00 Office Salaries $10,875.00 $10,875.00 $10,875.00 $10,875.00 $43,500.00 Advertising Expense $2,175.00 $2,175.00 $2,175. CX $2,175.00 $8,700.00 Depreciation $6,525.00 $6,525.00 $6.525. $6,525.00 $26, 100.00 Utilities $3,262.50 $3,262.50 $3,262.50 $3,262.50 $13,050.00 Total Fixed Expenses $28,057.50 $28,057.50 $28,057.50 $28,057.50 $1 12,230.00 Total Selling and Administrative Expenses $741,837.50 $782,283.55 $732,728.35 $789,394.65 $3,046,244.0 P Group 10 Manufacturing Cash Budget For The Year Ending Ending December 31, 202X Quarters Year 2 3 Beginning Cash Balance $2,220,741.00 Add: Cash Collections (Receipts) $3,929,800.00 $4,152,480.50 $3,879,648.50 $4 191,631.50 $16,153,560.50 Total Cash Available $6, 150,541.00 ess: Cash Disbursements Direct Material $464, 173.01 $403,369.32 $387,461.63 $407,426.09 $1,662,430.05 Direct Labor $711,653.87 $679,114.11 $643,356.93 $685,729.24 $2,719,854.14 Manufacturing Overhead $34,659.46 $34,646.45 $34,632.16 $34,649.09 $138,587.16 Selling and Administrative $741,837.50 $782,283.55 $732,728.35 $789,394.65 $3,046,244.05 Equipment Purchases $79,000.00 $0.00 $0.00 $0.00 $0.00 Dividends $0.00 $0.00 $0.00 $0.00 $0.00 Total Disbursements $2,031,323.84 $1,899,413.43 $1,798,179.07 $1,917,199.07 $7,567,115.40 Excess (Deficiency) $4, 119,217.16 ($1,899,413.43) ($1,798, 179.07) ($1,917, 199.07) ($7,567, 115.40) inancing: Borrowing $0.00 $0.00 $0.00 $0.00 $0.00 Repayments $0.00 $0.00 $0.00 $0.00 $0.00 Interest $0.00 $0.00 $0.00 $0.00 $0.00 Total Financing $0.00 $0.00 $0.00 $0.00 $0.00 Ending Cash BalanceGroup 10 Manufacturing Direct Materials Budget For The Year Ending Ending December 31, 202X Quarters Year 2 3 Units To Be Produced (from Production Budget) 176,501 168,431 159,563 170,072 674,567 Direct Materials Per Unit Total Direct Materials Needed for Production 176,501 168,431 159,563 170,072 674,567 Add: Desired Ending Direct Materials 16, 101 15,044 16,253 15,238 62,636 Less: Beginning Direct Materials 16,101 15,044 16,253 47,398 Direct Materials Purchased 192,603 167,373 160,772 169,056 689,805 Cost Per Pounod $2.41 $2.41 $2.41 $2.41 Total Cost of Direct Material Purchases $464,173.01 $403,369.32 $387,461.63 $407,426.09 $1,662,430.05 Group 10 Manufacturing Direct Labor Budget For The Year Ending Ending December 31, 202X Quarters Year 1 2 3 4 Units To Be Produced (from Production Budget) 176,501 168,431 159,563 170,072 674,567 Direct Labor Hours Per Unit 0.042 0.042 0.042 0.042 Total Direct Labor Hours Needed 7,413.06 7,074.11 6,701.63 7,143.01 28,331.81 Direct Labor Cost Per Hour $96.00 $96.00 $96.00 $96.00 Total Cost of Direct Labor $711,653.87 $679,114.11 $643,356.93 $685,729.24 $2,719,854.14 Group 10 Manufacturing Manufacturing Overhead Budget For The Year Ending Ending December 31, 202X Quarters Year 1 2 3 4 Budgeted Direct Labor Hours 7,413.06 7,074.11 6,701.63 7,143.01 28,331.81 Variable MOH Rate $0.04 $0.04 $0.04 $0.04 Variable MOH $284.46 $271.45 $257.16 $274.09 $1,087.16 Fixed MOH $35,775.00 $35,775.00 $35,775.00 $35,775.00 $143, 100.00 Total Manufacturing Overhead $36,059.46 $36,046.45 $36,032.16 $36,049.09 $144,187.16 Less: Depreciation $1,400.00 $1,400.00 $1,400.00 $1,400.00 $5,600.00 Cash Disbursement for MOH $34,659.46 $34,646.45 $34,632.16 $34,649.09 $138,587.16Group 10 Manufacturing Sales Budget For The Year Ending Ending December 31, 202X Quarters Year 2 3 4 Forecasted Unit Sales 160,400 169,489 158,353 171,087 659,329 Selling Price Per Unit $25 $25 $25 $25 Total Gross Sales $4,010,000.00 $4,237,225.00 $3,958,825 $4,277,175.00 $16,483,225.00 Sales Discounts & Allowances $80,200.00 $84,744.50 $79, 176.50 $85.543.50 $329,664.50 Total Net Sales $3,929,800.00 $4, 152,480.50 $3,879,648.50 $4, 191,631.50 $16,153,560.50 Group 10 Manufacturing Production Budget For The Year Ending Ending December 31, 202X Quarters Year 1 2 3 4 Sales Units 160,400 169,489 158,353 171,087 659,329 Add: Desired Ending Inventory 16, 101 15.044 16,253 15,238 62,636 Total Units Needed 176,501 184,533 174,606 186,325 721,965 Less: Beginning Inventory 16,101 15,044 16,253 47,398 Units to Produce 176,501 168,431 159,563 170,072 674,567 Group 10 Manufacturing Ending Inventory Budget For The Year Ending Ending December 31, 202X Quantity Cost Total Direct Material $2.41 $2.41 - - Direct Labor $0.68 $0.68 Manufacturing Overhead $0.26 $0.26 Total Unit Product Cost $3.34 Ending Finished Good Inv (Units) 15,238 Unit Product Cost $3.34 Total Ending Finished Goods Inv. $50,946.90