1.ABC Company started business on January 1, 20xx. The companyestimated that sales for the...

70.2K

Verified Solution

Question

Accounting

1.ABC Company started business on January 1, 20xx. The companyestimated that sales for the first six months would be asfollows:

MonthUnitsDollars
January10,000$ 50,000
February8,00040,000
March15,00075,000
April17,00085,000
May22,000110,000
June30,000150,000

The 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:

  1. Compute the expected cash collections during the months ofJanuary, February, March, April, May and June.
  2. 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?
  3. 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?
  4. 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?
  5. 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.)

Answer & Explanation Solved by verified expert
4.5 Ratings (771 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

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.)

Other questions asked by students