Extracted text: ATC 8-6 Spreadsheet Assignment Using Excel 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 $180,000 Selling, general, and administrative 72,000 Irvine planned to make and sell 30,000 copies of the book. Page 3 Required Construct a spreadsheet like the one shown in Exhibit 8.1 to illustrate a static budget and a flexible budget for production volumes of 28,000, 29,000, 30,000, 31,000, and 32,000.
Extracted text: 1. Tab 1: Excel Sheet of Cell Formulas for the static budget at 30,000 units and flexible budgets at 28,000, 29,000, 30,000, 31,000, and 32,000 units) 2. Tab 2: Excel Sheet of Cell Values for the static budget at 30,000 units and flexible budgets at 28,000, 29,000, 30,000, 31,000, and 32,000 units)