60.1K

Verified Solution

Link Copied!

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 on the information below and link as much information as possible. ABC Company Balance Sheet, December 31 Inform I 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 $1,113,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 2 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 7596 25% 20% Beginning Inventory units & cost Product 2 Cost 2,200 $25 Purchases Paid in the month of purchase Paid in the subsequent month 80% 20% Selling and administrative expenses includes $25,000 depreciation) Variable Expense $175,000 $19 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 on the information below and link as much information as possible. ABC Company Balance Sheet, December 31 Inform I 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 $1,113,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 2 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 7596 25% 20% Beginning Inventory units & cost Product 2 Cost 2,200 $25 Purchases Paid in the month of purchase Paid in the subsequent month 80% 20% Selling and administrative expenses includes $25,000 depreciation) Variable Expense $175,000 $19 Fixed per unit sold

Answer & Explanation Solved by verified expert

See Answer