Heron, lnc Sales Budget For the 6 mos ending June '10 Budged unit sales Selling price per unit Total Sal es Cash Sales Credit Sales % Cash Sales Credit Sales Total sal rrent month AIRCollections 1 month prior AIR Collections 2 months prior AJR Collections Uncollectible Current month cash Sales Current month AJR Collections 1 month prior AJR Collections 2 months prior AJR Collections Total cash collections Bad Debt Exp Budged unit sales Add desired ending inventory Total needs Less Beginning Inventory Required Purchases Cost per unit Purchases s s s Nov '09 11 ,250 1000 112,500 33,750 78,750 112,500 Jan '10 30,000 21 ,ooo 40,600 12,600 104,200 3,150 Novog 11 ,250 4,640 15,ago s s s Dec og 11,600 1000 116,000 34,800 81 ,200 116,000 s s s Jan '10 10,000 1000 100,000 30,000 70,000 100,000 s s s Heron, Inc. Cash Collections For the 6 mos ending June '10 Feo '10 34,200 23,g40 35,000 12,gg2 106,132 3,248 Mar '10 36,000 25,200 3g,goo 11 ,200 112,300 2,800 s s s s Feo '10 11 1000 114,000 34,200 7g,800 114,000 Apr '10 46,800 32,760 42,000 12,768 134,328 3,1g2 Mar '10 12,000 1000 120,000 36,000 84,000 120,000 May '10 60,750 42,525 54,600 13,440 171,315 3,360 s s s s Apr '10 15,600 1000 156,000 46,800 log,200 156,000 June '10 74,250 51,g75 70,875 17,472 214,572 4,368 s s s s s s May '10 18,000 1125 202,500 60,750 141,750 202,500 6 mos total 282,000 lg7,400 47g,400 80,472 842,847 20,118 Purchase Budget For the 6 mos ending June '10 11,600 4,000 15,600 4,640 43,840 Jan '10 10,000 4,560 14,560 10560 s 42,240 Feo '10 11,400 4,800 16,200 4,560 11640 Mar '10 12,000 6,240 18,240 4,800 13440 56 , 448 Apr '10 15,600 7,200 22,800 6,240 16560 May '10 18,000 8,800 26,800 1 gaoo June '10 22,000 s 11 s 247,500 s 74,250 s 173,250 s 247,500 June '10 22,000 7,200 2g,200 8,800 20400 1 ogso s s 46,560 s ag,552 s 4.41 86,436 s s 4.41 eg,g64 6 mos total eg,ooo s g40,ooo s 282,000 658,000 s g40,ooo 6 mos total u, ooo 38,800 127,800 g2200 3g1 ,200