The table below shows a firm’s costs at different production levels.Complete the table output Unit Fixed cost Variable cost Total cost Average total cost Average fixed cost Average variable cost Marginal cost 0 200 1 40 2 68 3 88 4 104

Open your Quality Sweaters (break-even) workbook and set the BASE inputs: fixed cost of printing $20,000; variable cost of printing and mailing $0.25; number mailed 100,000; average order $40; variable cost per order $32.20; response rate 8%. (Check: profit shows $17,400.) Change ONLY this input: variable cost per order = $30.00. What response rate makes profit exactly $0? Enter a percent with two decimals and no % sign. Example: if Excel shows 5.77% or 0.0577, enter 5.77. If your cell shows a rounded value such as 6%, add decimals first (Home, Increase Decimal).

Open your Quality Sweaters (break-even) workbook and set the BASE inputs: fixed cost of printing $20,000; variable cost of printing and mailing $0.25; number mailed 100,000; average order $40; variable cost per order $32.20; response rate 8%. (Check: profit shows $17,400.) Change ONLY this input: fixed cost of printing = $25,000. How many catalogs must be mailed for profit to be exactly $0? Round to the nearest whole catalog and enter it with no comma (example: 53476).

In the RT-OC-QC prompt template, which part does this sentence belong to? “Do not invent any numbers, and show which cell each figure came from.”

Open your Woodworks (bookshelf) workbook and set the BASE inputs: 30 board-feet and 16 labor hours per bookshelf for both woods; cherry $5.50 per board-foot rising 2.4% a year; oak $4.30 per board-foot rising 1.7% a year; labor $18.50 per hour rising 1.5% a year. (Check: the year-6 cherry bookshelf shows $513.89.) Change ONLY this input: oak’s projected annual increase = 3.0%. What is the cost of one OAK bookshelf 6 years from now? Enter dollars and cents with no $ sign (example: 498.25).

Open your Quality Sweaters (break-even) workbook and set the BASE inputs: fixed cost of printing $20,000; variable cost of printing and mailing $0.25; number mailed 100,000; average order $40; variable cost per order $32.20; response rate 8%. (Check: profit shows $17,400.) Change ONLY this input: response rate = 10%. How many catalogs must be mailed for profit to be exactly $0? Round to the nearest whole catalog and enter it with no comma (example: 53476).

In the reference $A19, what stays fixed when the formula is copied to other cells?

Open your Woodworks (bookshelf) workbook and set the BASE inputs: 30 board-feet and 16 labor hours per bookshelf for both woods; cherry $5.50 per board-foot rising 2.4% a year; oak $4.30 per board-foot rising 1.7% a year; labor $18.50 per hour rising 1.5% a year. (Check: the year-6 cherry bookshelf shows $513.89.) Make NO changes to the base inputs. What is the FIRST year (0 to 6) in which one CHERRY bookshelf costs more than $480? Enter a whole number.

Open your Woodworks (bookshelf) workbook and set the BASE inputs: 30 board-feet and 16 labor hours per bookshelf for both woods; cherry $5.50 per board-foot rising 2.4% a year; oak $4.30 per board-foot rising 1.7% a year; labor $18.50 per hour rising 1.5% a year. (Check: the year-6 cherry bookshelf shows $513.89.) Make NO changes to the base inputs. What is the FIRST year (0 to 6) in which one OAK bookshelf costs more than $450? Enter a whole number.

Open your Quality Sweaters (break-even) workbook and set the BASE inputs: fixed cost of printing $20,000; variable cost of printing and mailing $0.25; number mailed 100,000; average order $40; variable cost per order $32.20; response rate 8%. (Check: profit shows $17,400.) Change ONLY these two inputs: number mailed = 80,000 and response rate = 9%. What is the profit? Enter whole dollars with no $ sign or comma (example: 12345). If it is a loss, enter a negative number.