1. Rouse & Sons | 2011 Volume | At 2011Selling Prices | Expected 2012Change in Volume | Expected 2012 Volume | Radon Tests | 12,200 | $290 | +6% | 12,932 | Lead Tests | 16,400 | $240 | -10% | 14,760 |
Rouse & Sons Sales Budget | For the Year Ended December 31, 2012 | | | | | | Selling Price | Units Sold | Total Revenues | Radon Tests | $290 | 12,932 | $3,750,280 | Lead Tests | $240 | 14,760 | 3,542,400 | | | | $7,292,680 |
2. Rouse & Sons | 2011 Volume | Planned 2012 Selling Prices | Expected 2012 Change in Volume | Expected 2012 Volume | Radon Tests | 12,200 | $290 | +6% | 12,932 | Lead Tests | 16,400 | $230 | -7% | 15,252 |
Rouse & Sons Sales Budget | For the Year Ended December 31, 2012 | | | | | | Selling Price | Units Sold | Total Revenues | Radon Tests | $290 | 12,932 | $3,750,280 | Lead Tests | $230 | 15,252 | 3,507,960 | | | | $7,258,240 |
Expected revenues at the new 2012 prices are $7,258,240, which is lower than the expected 2012 revenues of $7,292,680 if the prices are unchanged. So, if the goal is to maximize sales revenue and if Jim Rouse’s forecasts are reliable, the company should not lower its price for a lead test in 2012.
6-17 Sales and production budget. Budgeted sales in units 200,000 Add target ending finished goods inventory 25,000 Total requirements 225,000 Deduct beginning finished goods inventory 15,000 Units to be produced 210,000 6-18 Direct materials purchases budget. Direct materials to be used in production (bottles) 2,500,000 Add target ending direct materials inventory (bottles) 80,000 Total requirements (bottles) 2,580,000 Deduct beginning direct materials inventory (bottles) 50,000 Direct materials to be purchased (bottles) 2,530,000 6-19