In: Accounting
The following information is available about Ancora Co. (Ancora): 1. Ancora's cash balance on December 31, 2019, was $70,000. 2. Actual sales for November and December 2019, and expected sales for January and February 2020, are as follows: November 2019 December 2019 January 2020 February 2020 (actual) (actual) (estimate) (estimate) Cash sales $ 75,000 $ 90,000 $ 60,000 $ 50,000 Credit sales 560.000 650,000 480,000 430,000 Sales on account are collected over a three-month period at the following rate: 30% collected in the month of sale, 50% collected in the month following sale and 17% collected in the second month following sale. The remaining 3% is uncollectable and is written off 3. Ancora's gross profit on sales is 35%. 4. Ancora's policy is to hold inventory at the end of the month equal to 40% of next month's budgeted sales. Inventory purchases in a given month are paid for as follows: 30% are paid in the month of purchase and 70% in the month following 5. Selling and administrative expenses are budgeted at $400,000 for January 2020. This amount includes $120,000 for depreciation 6 Equipment costing $150 000 was expected to be purchased for cash during January 2020 7 On December 15, 2019. Ancora declared a $100.000 dividend to be paid on January 15, 2020 8 Ancora must maintain a minimum cash balance of $50.000 An open line of credit is available from Ancora's bank. REQUIRED: Prepare Ancora's cash budget for the month of Jan 2020 and calculate Ancora's budgeted account receivable and accts payable closing balance at Jan 31, 20.
PLEASE PROVIDE TYPE WRITTEN ANSWER AND NOT HAND-WRITTEN SINCE IT'S HARD TO UNDERSTAND HAND WRITING.