HW Question 4 (of 7) value: 10.00 points Executive officers of Weston Company ar
ID: 2585737 • Letter: H
Question
HW Question 4 (of 7) value: 10.00 points Executive officers of Weston 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 $378,000 529,000 Second Quarter $302,000 452,000 Third Quarter $281,000 406,000 Fourth Quarter $475,000 649,000 Weston's past experience indicates that cost of goods sold is about 65 percent of sales revenue. The company tries to maintain 10 percent of the next quarter's expected cost of goods sold as the current quarter's ending inventory. This year's ending inventory is $35,000. Next year's ending inventory is budgeted to be $36,000. Required a. Prepare an inventory purchases budget using the sales manager's estimate. (Round your answers to the nearest whole dollar amount.) First Quarter econd Quarter Third Quarter Fourth Quarter Sales Cost of goods sold Plus: Desired ending inventory Total inventory needed Less: Beginning inventory Required purchases 378,000 S 302,000 $ 281,000S 475,000 245,700 196,300 182,650 308,750 36,000 344,750 30,875 230,330 194,935 S 195,260 $ 313,875 263213.525 18,265 214,565 19,630 30,875 19,630 265,330 35,000 18,265Explanation / Answer
b.) Inventory purhcase budget using the marketing consultant's estimate
[293800 * 10%]
=
29380
[263900 * 10%]
=
26390
[421850 *10%]
=
42185
First quarter Second quarter Third quarter Fourth quarter Sales 529000 452000 406000 649000 Cost of goods sold [65% of sales ] 343850 293800 263900 421850 Plus: Desired ending inventory[293800 * 10%]
=
29380
[263900 * 10%]
=
26390
[421850 *10%]
=
42185
36000 Total inventory needed 373230 320190 306085 457850 less: Beginning inventory 35000 29380 26390 42185 Required Purchases 338230 290810 279695 415665Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.