Based on the information below prepare a: (1) Sales Budget (2) Purchase Budget (3)S & A Budget (4) Cash Budget for Jan thru March (30 pts) Remember prepare thru Excel. Set up your template based o the information below and link as much information as possible. ABC Company Balance Sheet, December 31 inform Cash Accounts receivable Finished goods Land Plant and equipment Less: accumulated depreciation Total assets $41,700 192.000 55,000 100,000 $750,000 25,000 725,000 $1113,700 $55,000 Accounts payable to suppliers Common Stock Retained Earnings Total liabilities and equity $200,000 858,700 1,058,700 $1,113,700 Estimated sales of product z January February March April May Selling price Collections from customers Collected in month of sale Collected the following month Desired finished goods inventory (% of next month's unit sales) 10,000 10,700 11,200 11,000 10,500 $70 75% 25% 20% Beginning inventory units & cost Product z Cost 2,200 $25 Purchases Pald in the month of purchase Paid in the subsequent month 80N 20 Selling and administrative expenses indudes $25,000 depreciation) Variable Expense $175,000 $ 10 fixed per unit sold Based on the information below prepare a: (1) Sales Budget (2) Purchase Budget (3)S & A Budget (4) Cash Budget for Jan thru March (30 pts) Remember prepare thru Excel. Set up your template based o the information below and link as much information as possible. ABC Company Balance Sheet, December 31 inform Cash Accounts receivable Finished goods Land Plant and equipment Less: accumulated depreciation Total assets $41,700 192.000 55,000 100,000 $750,000 25,000 725,000 $1113,700 $55,000 Accounts payable to suppliers Common Stock Retained Earnings Total liabilities and equity $200,000 858,700 1,058,700 $1,113,700 Estimated sales of product z January February March April May Selling price Collections from customers Collected in month of sale Collected the following month Desired finished goods inventory (% of next month's unit sales) 10,000 10,700 11,200 11,000 10,500 $70 75% 25% 20% Beginning inventory units & cost Product z Cost 2,200 $25 Purchases Pald in the month of purchase Paid in the subsequent month 80N 20 Selling and administrative expenses indudes $25,000 depreciation) Variable Expense $175,000 $ 10 fixed per unit sold