I need to finish these budget master budget

Cash Budget (10 pts.) Budgeted Balance Sheet (10 pts.

**** PLEASE INCLUDE ALL THE CALCULATIONS OF THE PROBLEMS***** THANK J

Year 2006 Remarks Quarter1 Quarter 2 Quarter 3 Quarter 4 Total 50300 Sales units (2005) Selling price Sales revenue 35000 37500 42200 165000 $22.00 $22.00$22.00 $ 22.00 $ 7,70,000$ 8,25,000 $ 9,28,400 $ 11,06,600 36,30,000 Sales units (2006) Selling price Sales Budget- Sales down by 10% 31500 33750 37980 45270 148500 $22.00 $22.00$22.00 $ 22.00 $6,93,000 $ 7,42,500$ 8,35,560$ 9,95,940 $ 32,67,000 Sales down by 10% Sales charge $ 4,15,800 $ 4,45,500 $ 5,01,336 $ 5,97,564 $ 19,60,200 60% in the same quarter 40% in the next quarter Sales of year 2005 40% in Q1 Opening cash $ 2,77,200 $ 2,97,000 3,34,224 $ 9,08,424 $ 3,60,000 $ 75,000 $ 3,60,000 $ 75,000 $ 8,50,800$ 7,22,700 $ 7,98,336 $ 9,31,788 33,03,624 Cash receipt budget - 5,697 37,980 6,791 39,074 6,791 45,270 6,791 45,271 20,550 1,48,500 24,341 1,52,291 (closing inventory of previous) Opening inventory Units required to be sold in the quarter Closing inventory (desired) Production budget Closing inventory+ sales - Op inventory 3,000 31,500 5,063 33,563 5,063 33,750 5,697 34,385 15% of sales in next quarter Production budget Closing inventory +Sales quantity opening inventory