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 10 Expected fixed costs 11 Manufacturing overhead 180,000 12 Selling, general, and administrative 72,000 13 14 Irvine planned to make and sell 30,000 copies of the book, 30,000 15 16 Required Complete the spreadsheet below to illustrate a static budget and a flexible budget for production 17 volumes of 28,000, 29,000, 30,000, 31,000, and 32,000. 28,000 29,000 30,000 31,000 32,000 18 Per Unit 19 Standards Static Budget Flexible Budgets 20 Number of Units 21 Sales Revenue 22 Variable Manufacturing Costs 23 Materials 24 Labor 25 Overhead 26 Variable Selling, general, and administrative 27 Contribution Margin 28 Fixed Costs 29 Manufacturing Overhead 30 Selling, general, and administrative 31 Net Income