Question

In: Accounting

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

1.ABC Company started business on January 1, 20xx. The company estimated that sales for the first six months would be as follows:

Month Units Dollars
January 10,000 $ 50,000
February 8,000 40,000
March 15,000 75,000
April 17,000 85,000
May 22,000 110,000
June 30,000 150,000

The company sells all items on account and expects collections of accounts receivable to be as follows: 60% in the month of the sale, and the remaining 40% in the month after the sale.

Required:

  1. Compute the expected cash collections during the months of January, February, March, April, May and June.
  2. The company has decided that finished goods inventory at the end of each month should ideally be equal to 40% of next month’s sales. What should budgeted production be for each of the first four months?
  3. It takes two pounds of raw material to make one unit of finished product. The company wants to keep an ending inventory of raw material equal to 30% of next month’s production needs. How many pounds of raw material should be purchased in each of the first 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 in the following month. How much cash will be disbursed during the month of March for the purchase of raw material?
  5. The projected cash balance on March 1 is $13,500. What is the estimated cash balance at the end of the month? (Prepare a formal cash budget for the month of March.)

Solutions

Expert Solution


Related Solutions

ABC Company started business on January 1, 20xx. The company estimated that sales for the first...
ABC Company started business on January 1, 20xx. The company estimated that sales for the first six months would be as follows: Month Units Dollars January 10,000 $ 50,000 February 8,000 40,000 March 15,000 75,000 April 17,000 85,000 May 22,000 110,000 June 30,000 150,000 The company sells all items on account and expects collections of accounts receivable to be as follows: 60% in the month of the sale, and the remaining 40% in the month after the sale. Required: (a)Compute...
Colosimo Company started business on January 1, 2021. The company estimated that sales for the first...
Colosimo Company started business on January 1, 2021. The company estimated that sales for the first six months would be as follows: Month Units Dollars January 12,000 $ 72,000 February 9,500 57,000 March 14,000 84,000 April 21,700 130,200 May 20,000 120,000 June 32,100 192,600 The company sells all items on account and expects collections of accounts receivable to be as follows: 80% in the month of the sale, and the remaining 20% in the month after the sale. Required: Compute...
Colosimo Company started business on January 1, 2017. The company estimated that sales for the first...
Colosimo Company started business on January 1, 2017. The company estimated that sales for the first six months would be as follows: January - 10,000 units, $60,000 February - 8,000 units, $48,000 March - 15,000 units, $90,000 April - 17,000 units, $102,000 May - 22,000 units, $132,000 June - 30,000 units, $180,000 The company sells all items on account and expects collections of accounts receivable to be as follows: 65% in the month of the sale, and the remaining 35%...
Part 1 On January 1, 2021, ABC Inc. started business with inventory on hand of $34,000....
Part 1 On January 1, 2021, ABC Inc. started business with inventory on hand of $34,000. The company reported purchases for the year of $136,000 and sales of $306,000. The value of inventory on hand on December 31, 2021 was $45,000 at end of year prices. The price index for 2020 was 106. What should abc Inc. report as COGS for 2021 if they use Dollar Value LIFO as their inventory method? Part 2 ABC Co. uses the conventional approach...
Charles Diggs began his new business, called Diggs Systems Company, on January 1. 20xx. The company...
Charles Diggs began his new business, called Diggs Systems Company, on January 1. 20xx. The company writes computer programs with special applications for businesses that own small computers. During the first six months of operation, the business was so successful that Diggs had to hire new employees on several occasions. Yet, he continually had to put off creditors because he lacked the funds to pay them. He wants to apply for a bank loan, but after preparing a statement showing...
Charles Diggs began his new business, called Diggs Systems Company, on January 1. 20xx. The company...
Charles Diggs began his new business, called Diggs Systems Company, on January 1. 20xx. The company writes computer programs with special applications for businesses that own small computers. During the first six months of operation, the business was so successful that Diggs had to hire new employees on several occasions. Yet, he continually had to put off creditors because he lacked the funds to pay them. He wants to apply for a bank loan, but after preparing a statement showing...
Charles Diggs began his new business, called Diggs Systems Company, on January 1. 20xx. The company...
Charles Diggs began his new business, called Diggs Systems Company, on January 1. 20xx. The company writes computer programs with special applications for businesses that own small computers. During the first six months of operation, the business was so successful that Diggs had to hire new employees on several occasions. Yet, he continually had to put off creditors because he lacked the funds to pay them. He wants to apply for a bank loan, but after preparing a statement showing...
ABC company purchased equipment on January 1, 2015, for $50,000, with an estimated useful life of...
ABC company purchased equipment on January 1, 2015, for $50,000, with an estimated useful life of 5 years and an estimated residual value of $5,000. Assume the equipment was sold on April 30th 2017 for $25,000 Prepare journal entries for the following: A) Calculate depreciation expense for 2015 and 2016 using straight line method of depreciation. Prepare the journal entry to record depreciation B) Calculate depreciation for 2017 and record the journal entry C) Prepare the journal entry for the...
ABC Furniture Company started construction of a office building for it’s own use at an estimated...
ABC Furniture Company started construction of a office building for it’s own use at an estimated cost of $5,000,000 on January 1, 2016. ABC expected to complete the building by December 31, 2016. ABC has the following debt obligations outstanding during the construction period. Construction Loan­ 12% interest, payable semiannually, issued December 31, 2015 $2,000,000 Short Term Loan ­ 10% interest, payable monthly, and principal payable at maturity on May 30, 2017 $1,400,000 Long­term loan – 11% interest, payable on...
Company A started business on January 1, 20X1, and bought the following piece of equipment. Cost...
Company A started business on January 1, 20X1, and bought the following piece of equipment. Cost of asset $150,000 Useful life 3 Tax rate 21% 20X1 estimated tax payment 1,800 Depreciation for book and tax purposes is as follows: Book Tax 20X1 40,000 100,000 20X2 40,000 20,000 20X3 40,000 0 20X1 income statement information: Sales 638,000 Expenses (does not include depreciation expense and tax expense) 510,000 What is ending taxes payable on the December 31, 20X1 balance sheet?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT