Chapter 7 Cost Homework (1) - Protected View - Excel Russom, Saron (srussom @student.cccs.edu) RS X File Home Insert Draw Page Layout Formulas Data Review View Help QuickBooks Search Share Comments O i PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X i X O UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. Update now M8 :X V fx A B D E H K M N O P Fixed Cost CACULATE THE FOLLOWING: (1) Total Revenue, (2) Total Variable Cost, (3) Profit before Fixed Costs, (4) Average Price, (5) Marginal Revenue, (6) Marginal Cost, (7) Maximum Profit, (8) The Price that delivers Maximum Profit, and (9) The Value O $100 of MR + MC when they are equal Total Change in Variable Tota Total Profit B/4 Average Quantity Variable MR MC Quantity Fixed Costs Price Sold Revenue Cost per Price per Cost "Current Unit Number of P B5+A6 B5*C5 Units" B5*E5 D5-F5 D5/B5 (D6-D5)/A6 (F6-F5)/A6 O 100 100 25 $15.00 15 115 24 $14.45 15 130 23 $13.90 qb 15 145 22 $13.35 15 160 21 $12.80 W 10 15 175 20 $12.25 11 15 190 19 $11.70 12 15 205 18 $11.15 X 13 15 220 17 $10.60 14 15 235 16 $10.05 15 15 250 15 $9.50 16 15 265 14 $8.95 17 15 280 13 $8.40 EN 18 Maximum Profit = The Price for Maximum What is the Value Where MC = MR? 19 Profit = 20 21 22 23 24 ENG 25 26 12:23 AM 27 Friday 28 3/12/2021 an Variable - all Units Variable - per Unit Added Sheet2 Sheet3 + 1 100%Chapter 7 Cost Homework (1) - Protected View - Excel Russom, Saron (srussom @student.cccs.edu) RS X File Home Insert Draw Page Layout Formulas Data Review View Help QuickBooks Search Share Comments O i PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X i UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. Update now X O F19 X V fx m A Ividigital neverlue , (U / Marginal Cust , (7/ IViaAnnum Profit , to , The Price tat denvers IViaximum Front , and to , me value K L M N O P $100 of MR + MC when they are equal 2 O Total Total Total Variable Profit B/4 Average Quantity Variable MR MC Revenue Price Sold Price per Cost per Cost Fixed Costs Change in 3 Quantity Unit Units "Added" B5+A6 B5*C5 B5*E5 D5-F5 D5/B5 (D6-D5)/A6 (F6-F5)/A6 P 100 100 $25 $15.00 15 115 $24 $14.45 15 130 $23 $13.90 15 145 $22 $13.35 qb 15 160 $21 $12.80 10 15 175 $20 $12.25 W 11 15 190 $19 $11.70 12 15 205 $18 $11.15 13 15 220 $17 $10.60 X 14 15 235 $16 $10.05 15 15 250 $15 $9.50 16 15 265 $14 $8.95 17 15 280 $13 $8.40 18 EN Maximum Profit = The Price for Maximum What is the Value Where MC = MR? 19 Profit = 20 21 22 23 24 25 ENG 26 12:23 AM Friday 29 3/12/2021 in Variable - all Units Variable - per Unit Added Sheet2 Sheet3 + 1 100%