Colosimo Company started business on January 1, 2017. Thecompany estimated that sales for the first six months would be asfollows:
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 collectionsof accounts receivable to be as follows: 65% in the month of thesale, and the remaining 35% in the month after the sale.
Required:
(a) Compute the expected cash collections during the months ofJanuary, February, March, April, May and June.
(b) The company has decided that finished goods inventory at theend of each month should ideally be equal to 45% of next monthâssales. What should budgeted production be for each month?
(c) It takes three pounds of raw material to make one unit offinished product. The company wants to keep an ending inventory ofraw material equal to 40% of next monthâs production needs. Howmany pounds of raw material should be purchased in each month?
(d) The raw material costs $2.75 per pound. The company pays for75% of its purchases during the month of purchase and the remainderin the following month. How much cash will be disbursed during eachmonth for the purchase of raw material?
(e) The projected cash balance on March 1 is $19,500. What isthe estimated cash balance at the end of the month? (Prepare aformal cash budget for the month of March.)
Colosimo Company started business on January 1, 2017. Thecompany estimated that sales for the first six months would be asfollows:
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 collectionsof accounts receivable to be as follows: 65% in the month of thesale, and the remaining 35% in the month after the sale.
Required:
(a) Compute the expected cash collections during the months ofJanuary, February, March, April, May and June.
(b) The company has decided that finished goods inventory at theend of each month should ideally be equal to 45% of next monthâssales. What should budgeted production be for each month?
(c) It takes three pounds of raw material to make one unit offinished product. The company wants to keep an ending inventory ofraw material equal to 40% of next monthâs production needs. Howmany pounds of raw material should be purchased in each month?
(d) The raw material costs $2.75 per pound. The company pays for75% of its purchases during the month of purchase and the remainderin the following month. How much cash will be disbursed during eachmonth for the purchase of raw material?
(e) The projected cash balance on March 1 is $19,500. What isthe estimated cash balance at the end of the month? (Prepare aformal cash budget for the month of March.)
Related questions
CASE 1 MASTER BUDGET
Colosimo Company started business on January 1, 2016.The company estimated that sales for the first six months would beas 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 expectscollections of accounts receivable to be as follows: 60% in themonth of the sale, and the remaining 40% in the month after thesale.
Required:
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 paysfor 70% of its purchases during the month of purchase and theremainder in the following month. How much cash will be disbursedduring the month of March for the purchase of rawmaterial?
The projected cash balance on March 1 is $13,500. Whatis the estimated cash balance at the end of the month? (Prepare aformal cash budget for the month of March.)
DeWitt Industries has adopted the following production budgetfor the first 4 months of 2017.
Month | Units | Month | Units | |||
| January | 10,240 | March | 5,150 | |||
| February | 8,340 | April | 4,130 |
Each unit requires 3 pounds of raw materials costing $2 per pound.On December 31, 2016, the ending raw materials inventory was 6,144pounds. Management wants to have a raw materials inventory at theend of the month equal to 20% of next monthâs productionrequirements.
Prepare a direct materials purchases budget by month for the firstquarter.
