1. Sales are expected to be $80,000 in January, $100,000 in February, and $105,000 in March. 2. All sales are on credit and it collects 20% of all sales in the month of the sale, the remaining 80% in the month after the sale. 3. The cost of goods sold is equal to 40% of sales. 4. The company likes to keep an ending inventory on hand equal to 15% of next month's cost of goods sold. 5. All purchases of inventory are on account, and the company pays for 60% of all purchases in the month of the purchase, 40% in the month after the purchase. 6. The company pays its sales force a commission equal to 3% of sales. 7. The company also believes that its miscellaneous expense is equal to $500 plus 2% of sales. 8. Rent is $2,000 per month, Supplies are $600 per month, and Depreciation is $1,800 per month. 9. On October 1 of last year, the company purchased an insurance policy covering 12 months for $14,400. 10. All selling and administrative expenses are paid in the month they are incurred except for commissions that are paid in the month after they are eamed and the insurance which is paid as stated in #9. 11. The company purchased $40,000 of Land on January 18th. They paid cash for the land. 12. Interest on long-term debt is equal to 1% of the beginning balance and is paid each month. The company must maintain a minimum balance in cash of $15,000 and will use any cash surplus to pay down long-term debt. The company borrows cash in $1,000 increments. 13. The company's Board of Directors declared a cash dividend of $400 on January 4th. The dividend will be paid on February 104. 14. The company had a beginning balance sheet (as of January 1) as follows: Prepare the following budgets for January: 1. Sales budget 2. Purchsses budget 3. Selling \& Admin Expense budget 4. Cash Budget 5. Budget Proforma Income Statement 6. Budget Proforma Balance Sheet Once you have completed the budget, determine the following balances. 1. Total Cash Receipts for Jamuary. 2. Total Imventory Purchases for January. 3. Total Cash Payments for Inventory Purchases for January. 4. Total Variable Selling \& Administrative Expenses for Jamuary. 5. Total Fixed Selling \& Administrative Expenses for Jamuary. 6. Total Cash Payments for Selling \& Administrative Expenses for January. 7. Total Cash Surplus (Deficit) for January. 8. Total New Borrowing (Repayments) for Jamuary. 9. The Contribution Margin for January. 10. Total Interest Expense for January. 11. Pre-tax Income for January. 12. Ending Balance of Cash on January 31st. 13. Ending Balance of Accounts Receivable on January 31 st. 14. Ending Balance of Inventory on Jamuary 31 st. 15. Ending Balance of Prepaid Insurance on January 31 st. 16. Ending Balance of Land on Jamuary 31 st. 17. Ending Balance of Accumulated Depreciation on January 31 st. 18. Ending Balance of Accounts Payable on January 31 st. 19. Ending Balance of Commissions Payable on January 31 st. 20. Ending Balance of Dividends Payable on January 31 st. 21. Ending Balance of Long-Term Debt on January 31 st. 22. Ending Balance of Retained Eamings on January 31 st