Prepare a sales, production, direct materials, direct labor, overhead, and selling & administrative expense budget by quarter for the year 2020 for the Budgets R Us Co. using the following assumptions:

1. Sales quantity by quarter: 10,000, 11,000, 12,000, 13,000, 14,000, 15,000.
2. Selling price per unit = $20.
3. Ending FG inventory = 10%.
4. RM pounds per unit = 4.
5. Ending RM inventory = 20%.
6. RM price per pound = $2
7. Direct labor hours per unit = 2
8. Direct labor hourly rate = $20.
9. Variable overhead costs per direct labor hour: Indirect labor = $1.60, Indirect material = $.40, Maintenance = $.70, Repairs = $.30.
10. Fixed overhead costs per quarter: Depreciation = $20,000, Supervisors salary = $10,000, Rent = $5,000.
11. Variable selling & administrative costs: Sales commission = 5% of sales dollars, Packaging & shipping = $2 per unit sold.
12. Fixed selling & administrative costs per quarter: Sales salaries = $30,000, Insurance = $5,000, Advertising = $15,000.