Question

Executive officers of Thornton Company are wrestling with their budget for the next year. The following are two different sal
Required A Required B Prepare an inventory purchases budget using the marketing consultants estimate. (Round your final answ
0 0
Add a comment Improve this question Transcribed image text
Answer #1
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
Add a comment
Know the answer?
Add Answer to:
Executive officers of Thornton Company are wrestling with their budget for the next year. The following...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Executive officers of Zachary 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....

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

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

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

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

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

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

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

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

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

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT