S CALCULATOR PRINTER VERSION BACK NEXT c ulumber Company expects to have a cash balance of $136.500 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows: Collections from customers: January $247.900, February 1425,000 Payments for direct materials: January $153.100, February $232,000 Direct labor: January 591,200. February 5134.700. W e are in the month they are incurred. Mandacturing overhead: January $53,300. February $75,400. These costs include depreciation of $5,000 per month. All other overhead costs are paid as incurred. Selling and administrative expenses: January $44,700, February 58,900. These costs are exclusive of depreciation. They are pad as incurred. Sales of marketable securities in January are expected to realize $35,700 in cash. Clumber Company has ine of credit at the local bank that enabled to borrow up to $79,700. The cor Wants toma m m oth Canh balance of $60.600 Prepare a cash budget for January and February Cubber Company For the Months Ending February 2010 Beginning Cahatance Colections from customers of Sec CALCULATOR Total Available Cash PRINTER VERSION BACK NEXT Direct Materials Direct Labor Manufacturing Overhead Selling and Administrative Expenses Total Disbursements Excess (Deficiency) of Available Cash over Cash Distraments Financing Add Borrowing Reparments including interest Ending Cas Balance Clumber Company's financial officer feels that it is important to have data for the entire quarter especially since therandal Grecasts indicate some discuit economic periods in the coming year, March formaton has been budoted as folows: Collections from customers: $81.200 Payments for direct materials: 3210,800 CALCULATOR PRINTER VERSION BACK NEXT Payments for direct materials: $210,800 Direct labor: Wages paid in March $117.900 Manufacturing overhead: $63,700. This includes the monthly depreciation of $5,000. Selling and administrative expenses: $52,100. This cost is exdusive of depreciation Marketable securities of $51,800 can be sold if needed for additional cash. Prepare a cash budget for March assuming that the company does not sel the marketable securities. Cullumber Company Cash Budget For the Month Ending March 2020 NEXT What is the maximum amount the company can borrow during March Maximum amount the company can borrow $ Does this provide the company with an adequate ending cash balance? Borrowing this amount Cullumber Company with the minimum ending cash balance How much does the company need to borrow if the marketable securities are sold CALCULATOR PRINTER VERSION BACK What is the maximum amount the company can borrow during March? Maximum amount the company can borrow Does this provide the company with an adequate ending cash balance? Borrowing this amount Cullumber Company with their minimum ending cash balance How much does the company need to borrow if the marketable secunties are sold? Company needs to borrow Click if you would like to Show Work for this question: Don Show Work By accessing this Question Assistance, you will learn while you earn points based on the point potential policy set by your instructor