Transcribed Image Text
In: Accounting1.ABC Company started business on January 1, 20xx. The companyestimated that sales for the first...1.ABC Company started business on January 1, 20xx. The companyestimated that sales for the first six months would be asfollows:MonthUnitsDollarsJanuary10,000$ 50,000February8,00040,000March15,00075,000April17,00085,000May22,000110,000June30,000150,000The company sells all items on account and expects collectionsof accounts receivable to be as follows: 60% in the month of thesale, and the remaining 40% in the month after the sale.Required:Compute the expected cash collections during the months ofJanuary, February, March, April, May and June.The company has decided that finished goods inventory at theend of each month should ideally be equal to 40% of next month’ssales. What should budgeted production be for each of the firstfour months?It takes two pounds of raw material to make one unit offinished product. The company wants to keep an ending inventory ofraw material equal to 30% of next month’s production needs. Howmany pounds of raw material should be purchased in each of thefirst three months?The raw material costs $2 per pound. The company pays for 70%of its purchases during the month of purchase and the remainder inthe following month. How much cash will be disbursed during themonth of March for the purchase of raw material?The projected cash balance on March 1 is $13,500. What is theestimated cash balance at the end of the month? (Prepare a formalcash budget for the month of March.)