| The inventory purchases budget using the sales manager's estimate is shown below | |||||||
| First quarter | Second quarter | Third quarter | Fourth quarter | ||||
| Sales | $378,000 | $319,000 | $277,000 | $484,000 | |||
| Cost of goods sold | $245,700 | $207,350 | $180,050 | $314,600 | |||
| Add: Desired ending inventory | $31,103 | $27,008 | $47,190 | $34,000 | |||
| Total inventory needed | $276,803 | $234,358 | $227,240 | $348,600 | |||
| Less: Beginning inventory | $33,000 | $31,103 | $27,008 | $47,190 | |||
| Required purchases | $243,803 | $203,255 | $200,233 | $301,410 | |||
| Cost of goods sold | |||||||
| 1st quarter | 378000*65% | ||||||
| 2nd quarter | 319000*65% | ||||||
| 3rd quarter | 277000*65% | ||||||
| 4th quarter | 484000*65% | ||||||
| Desired ending inventory | |||||||
| 1st quarter | 207350*15% | ||||||
| 2nd quarter | 180050*15% | ||||||
| 3rd quarter | 314600*15% | ||||||
| 4th Quarter | Given | ||||||
| Beginning inventory for current quarter is ending inventory for previous quarter | |||||||
| The inventory purchases budget using the marketing consultant's estimate is shown below | |||||||
| First quarter | Second quarter | Third quarter | Fourth quarter | ||||
| Sales | $515,000 | $459,000 | $416,000 | $644,000 | |||
| Cost of goods sold | $334,750 | $298,350 | $270,400 | $418,600 | |||
| Add: Desired ending inventory | $44,753 | $40,560 | $62,790 | $34,000 | |||
| Total inventory needed | $379,503 | $338,910 | $333,190 | $452,600 | |||
| Less: Beginning inventory | $33,000 | $44,753 | $40,560 | $62,790 | |||
| Required purchases | $346,503 | $294,158 | $292,630 | $389,810 | |||
| Cost of goods sold | |||||||
| 1st quarter | 515000*65% | ||||||
| 2nd quarter | 459000*65% | ||||||
| 3rd quarter | 416000*65% | ||||||
| 4th quarter | 644000*65% | ||||||
| Desired ending inventory | |||||||
| 1st quarter | 298350*15% | ||||||
| 2nd quarter | 270400*15% | ||||||
| 3rd quarter | 418600*15% | ||||||
| 4th Quarter | Given | ||||||
| Beginning inventory for current quarter is ending inventory for previous quarter | |||||||
Executive officers of Thornton Company are wrestling with their budget for the next year. The following...
Executive officers of Zachary Company are wrestling with their budget for the next year. The following are two different sales estimates provided by two difference sources. Source of Estimate Sales manager Marketing consultant First Quarter $377,000 522,000 Second Quarter $303,000 462,000 Third Quarter $272,000 415,000 Fourth Quarter $485,000 650,000 Zachary's past experience indicates that cost of goods sold is about 60 percent of sales revenue. The company tries to maintain 15 percent of the next quarter's expected cost of goods...
Finch's past experience indicates that cost of goods sold is about 60 percent of sales revenue. The company tries to maintain 15 percent of the next quarter's expected cost of goods sold as the current quarter's ending inventory. This year's ending inventory is $39,000. Next year's ending inventory is budgeted to be $40,000. Required a. Prepare an inventory purchases budget using the sales manager's estimate. b. Prepare an inventory purchases budget using the marketing consultant's estimate. Complete this question by...
On January 1, 2020, the Johnson Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Sales Units: First quarter 5,600; second quarter 6,400; third quarter 7,000 Ending raw materials inventory: 40% of the next quarter's production requirements. Ending finished goods inventory: 25% of the next quarter's expected sales units. Third-quarter production: 7,440 Units The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to...
White Corporation's budget calls for the following sales for next year: Quarter i Quarter 2 108,500 units 90,000 units Quarter 3 Quarter 4 73,300 units 105,200 units Each unit of the product requires 3 pounds of direct materials. The company's policy is to begin each quarter with an inventory of product equal to 5% of that quarter's estimated sales requirements and an inventory of direct materials equal to 20% of that quarter's estimated direct materials requirements for production. Required: 1....
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Sales units: First quarter 5,600; second quarter 6,300; third quarter 7,000. Ending raw materials inventory: Ending finished goods inventory: 40% of the next quarter's production requirements. 25% of the next quarter's expected sales units. Third-quarter production: 7,820 units. The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to...
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Sales units: First quarter 5,200; second quarter 6,700;third quarter 7,000. Ending raw materials inventory: 40% of the next quarter's production requirements. Ending finished goods inventory: 25% of the next quarter's expected sales units. Third-quarter production: 7,380 units. The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to production...
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Sales units: First quarter 6,000; second quarter 6,900; third quarter 7,400. 40% of the next quarter's production requirements Ending raw materials inventory: Ending finished goods inventory: 25% of the next quarter's expected sales units. 7,840 units. Third-quarter production: The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to...
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data for the months ending June 30, 2020. Sales units: First quarter 6,000 second quarter 6.900: third quarter 7400 Ending raw materials inventory: 40% of the next quarter's production requirements Ending finished goods inventary: 25% of the next quarter's expected sales units. Third-quarter production: 7.840 units. The ending raw materials and finished goods Inventaries at December 31, 2019 follow the same percentage relationships to production...
port On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Sales units: First quarter 5,600, second quarter 6,300: third quarter 7.000. Ending raw materials inventory: 40% of the next quarter's production requirements. Endinghnished goods inventory: 25% of the next quarter's expected sales units. Third quarter production: 7.820 units. The ending raw materials and finished goods inventories at December 31, 2019 follow the same percentage relationships...
Show Attempt History Current Attempt in Progress On January 1, 2017, the Blue Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2017. Sales units: First quarter 5,700; second quarter 6,200; third quarter 7,200 Ending raw materials inventory: 40% of the next quarter's production requirements Ending finished goods inventory: 25% of the next quarter's expected sales units Third-quarter production: 7,670 units. The ending raw materials and finished goods inventories at December 31,...