Irvine Publications established the following standard price and costs for a hardcover picture book that the company produces. Standard price and variable costs Sales price $ 48.00 Materials cost $ 12.00 Labor cost $ 6.00 Overhead cost $ 8.40 Selling, general, and administrative costs $ 9.60 Expected fixed costs Manufacturing overhead Selling, general, and administrative $ 180,000 $ 72,000 Irvine planned to make and sell 30,000 copies of the book. Required 30,000 Complete the spreadsheet below to illustrate a static budget and a flexible budget for production volumes of 28,000, 29,000, 30,000, 31,000, and 32,000. 28,000 29,000 30,000 31,000 32,000 Number of Units Sales Revenue Variable Manufacturing Costs Materials Labor Overhead Variable Selling, general, and administrative Contribution Margin Fixed Costs Manufacturing Overhead Selling, general, and administrative Net Income Per Unit Standards Static Budget Flexible Budgets