We are doing a master budget project for class however after much work and effort we cant seem to get our numbers to balance in the balance sheet and trial balance. Also, for the first year were supposed to lose precisely $100,000 but that is not coming out right either. I feel like its a minor mistake Im overlooking. Please help.

Assumptions 9664 15411 72882 32.00 to lose 100k to break ever to make 1 mil 3 Raw Materials 4 Direct Labor 5 Bad Debt Exp 6 Selling Exp. 7 total variable exp 8 Unit Con Mgn 9 MOH 10 Admin 11 interest expense 12 Fixed Expenses 13 14 15 Quarter 16 units sold 17 selling price 18 total sales 19 bad debts 20 collections Q of sale 21 collections Q after sale 22 total collections 23 cash 24 25 Accounts Receivable 26 27 bad debts exp 28 29 cash 30 31 5.20 3.00 3.20 3.20 14.60 17.40 107,350.00 136,550.00 20% 10% 10% 60% Q1 02 03 04 24.250.00 268,150.00 sales budget 4 totals 798 966 1933 966 32.00 9663 32.00 3 S 32.00 32.00 61,856.0030,912.00 30,912.00 185,536.00 309,216.00 18,553.6030,921.60 92,768.00154,608.00 $ 24,742.40 12,364.80 12,364.8049,472.00 27,820.80105,132.80204,080.00 6,185.60$ 3,091.20 0,928.00 15,456.00 S 3,091.20S 15,456.00 $ 30,928.0040,198.40 S $100,000.00 $100,000.00 S 309,216.00 $30,921.60 S204,080.00 common stock sales $30,921.60 Bad Debt Alw $204,080.00 Acct Rec 4 next year Q1 1933 193 2126 5798 616 6414 1160 S254 sales desired endin total needed less beg inv units to be 3082 193 1159 193 1160 2126 193 1933 2126 10279 raw material 4 totals units to be produced rement S254 unit r raw materials to be unit cost total cost 2126 1933 $254 5.2 27,320.80 21,856.64 2,010.32 10279 $5.2 $5,023.20 ,018.56 11,055.20 $8,844.16 53,450.80 $42,760.64 5.226.00 47,986.64 0,051.60 8,041.28 ,004.64 in month of purchase t in month followin 2,211.04 $6,229.60 53,450.80 chase total 8,844.16 finished 53,450.80 acct acct. payable 47,986.64 cash $47,986.64 direct labor 4 totals 5254 0.3 1576 9.00 4,185.80 2126 units 10279 unit r 290 9.00 2,608.20 27,753.30 total labor hours labor rate total direct labor finished goods 638 9.00 5,740.20 580 9.00 5,219.10 3084 27,753.30 27,753.30 direct labor budget 4totals quarter 2126 0.3 638 966 0.3 290 9.00 $ 1933 5254 0.3 1576 9.00 10279 per unit req total labor hours 0.3 580 9.00 S 3084 5,740.20 2,608.20 $ 5,219.10S14,185.80$27,753.30 $27,753.30 total direct labor $27,753.30 cash Manufacturing Overhead 4 total quarter 07,350.00107,350.00 107,350.00 107,350.00 429,400.00 107,350.00107,350.00$107,350.00107,350.00 429,400.00 total overhead total payment administrative expenses 4 total 1 136,550.00 136,550.00S 546,200.00 27450.00 5 715000 745000 5 7150 5 108 60.00 136,550.00$ 136,550.00 $ total expense less depreciation 109,400.00109,400.00$109,400.00 109,400.00 437,600.00 ent selling expenses 4 total 18,553.60 $ 30,921.60 quarter 6,185.60 3,091.20 S ,091.20 S less depreciation total payment 6,185.60$ 3,091.20S 3,091.20 18,553.6030,921.60 10% Capital expenditure budget 4 total 242,500.00 $ 970,000.00 quarter total expenditure 242,500.00 $ 242,500.00 S242,500.00S 24,250.0024,250.0024,250.0024,250.0097,000.00 Cash Budget 4 total receipts: beginning cash balance collections 200,000.00200,000.00200,000.00200,000.00 200,000.00 30,928.0040,198.40 7,0.80 $ 105,132.80 204,080.00 230,928.00 240,198.40227,820.80 $ 305,132.80 disbursements: Raw materials 8,844.16$ 6,229.60S9,045.9223,866.96$ 47,986.64 14,185.80 27,753.30 5,740.202,608.20 S ,219.10 S manufacturing overhead selling exp administrative expenses interest expense TOTAL PAYMENT excess cash 6,185.60 3,091.20 3,091.20 18,553.60$ 30,921.60 109,400.00109,400.00109,400.00 109,400.00 437,600.00 24,250.00$ 97,000.00 261,769.96252,929.00 258,356.22297,606.36 1,070,661.54 24,250.0024,250.00 S 24,250.00 S 7,526.44 230,841.96 212,730.60 230,535.42S 192,473.56 866,581.54 200,000.00 200,000.00 200,000.00200,000.00 ending cash bal Contribution margin Income Statement quantity unit price total 32.00309,248.00 sales variable costs: direct material direct labor selling expense bad debt total variable costs 9664 $ 9664 $ 9664 $ 9664 $ 9664 $ 9664$ 5.20 $ 3.00 $ 3.20 $ 3.20 $ 50,252.80 28,992.00 30,924.80 30,924.80 14.60 S 141,094.40 17.40 $168,153.60 9664 S contribution margin fixed expenses: Manufacturing overhead Administrative expenses interest expense total fixed expense S107.350.00 $136,550.00 24,250.00 $268,150.00 net loss (99,996.40) urnal entries 200,000.00 1 cash common stock 200,000.00 309,216.00 30,921.60 $309,216.00 2 Accounts Receivable sales bad debts exp 30,921.60 Bad Debt Allowance 204,080.00 cash Acct Rec 204,080.00 3 raw materials 53,450.80 accts payable 53,450.80 47,986.64 27,753.30 accts payable 47,986.64 27,753.30 429,400.00 0,921.60 $546,200.00 cash 4 direct labor cash 5 MOH cash 29,400.00 6 selling expenses cash 30,921.60 7 admin expenses accum depr cash 108,600.00 437,600.00 8 finished goods 84,287.80 raw materials direct labor 53,450.80 30,837.00 9 COGS 79,244.80 finished goods 79,244.80 10 Cash $866,581.54 Loan Payable 866,581.54 24,250.00 7,700.00 11interest expense 24,250.00 cash 12 equipment 7,700.00 note payable Trial balance cash accts. Receivable equipment allowance for bad debts finished accumulated depreciation accounts payable loan payable notes payable common stock sales cost of goods sold bad debt expense selling expense nterest expense manufacturing expense administrative expense total debits credits 272,750.00 105,136.00 7,700.00 $30,921.60 s inventor 5,043.00 $108,600.00 $5,464.16 $866,581.54 $7,700.00 $200,000.00 $309,216.00 79,244.80 30,921.60 30,921.60 24,250.00 29,400.00 546,200.00 1,531,567.001,528,483.30 balance sheet cash 272,750.00 105,136.00 7,700.00 5,043.00 (108,600.00) 30,921.60 accounts payable loans payable notes payable 5,464.16 866,581.54 7,700.00 accounts payable uipment finished goods ess depreciation less bad debt common stock 200,000.00 831,722.00) revenue 251,107.40 total 248,023.70 total