Subjects accounting

Sales Production Budget C0C4Ee

Step-by-step solutions with LaTeX - clean, fast, and student-friendly.

Search Solutions

Sales Production Budget C0C4Ee


1. **Problem Statement:** Prepare the sales budget and production budget for Senator Company for September, October, and November. 2. **Given Data:** - Budgeted sales units: September = 10,000, October = 30,000, November = 40,000, December = 50,000 - Selling price per unit = 0.5 - Ending inventory must be 20% of next month's sales units - Beginning inventory on August 31 = 4,000 units 3. **Sales Budget Formula:** Sales Revenue = Budgeted Sales Units \times Selling Price 4. **Production Budget Formula:** Required Production = Budgeted Sales + Desired Ending Inventory - Beginning Inventory 5. **Calculate Sales Budget:** - September Sales = $10,000 \times 0.5 = 5,000$ - October Sales = $30,000 \times 0.5 = 15,000$ - November Sales = $40,000 \times 0.5 = 20,000$ 6. **Calculate Ending Inventory (units):** - September Ending Inventory = 20\% \times October Sales Units = $0.2 \times 30,000 = 6,000$ - October Ending Inventory = 20\% \times November Sales Units = $0.2 \times 40,000 = 8,000$ - November Ending Inventory = 20\% \times December Sales Units = $0.2 \times 50,000 = 10,000$ 7. **Calculate Production Budget:** - September Production = $10,000 + 6,000 - 4,000 = 12,000$ - October Production = $30,000 + 8,000 - 6,000 = 32,000$ - November Production = $40,000 + 10,000 - 8,000 = 42,000$ **Final Answers:** - Sales Budget (units and revenue): - September: 10,000 units, 5,000 revenue - October: 30,000 units, 15,000 revenue - November: 40,000 units, 20,000 revenue - Production Budget (units): - September: 12,000 - October: 32,000 - November: 42,000