AutoSave File Home Insert Draw Ch07WillenHW- Page Layout Formulas Data Review View Help Paste Arial B I U Undo Clipboard y Font A2Z X fx A 10 AA = A B 9. C CV Search (Alt+Q) Wrap Text General Merge & Center $% B Alignment F Number D Conditions Format as Cell Formatting Table Styles Insert De ata Format Styles Cells Kross Joseph K Comments Share Sot & Find & Filter Select Analyza Sensitivity Data Editing Analys Sensitivity E F G H J K L M N P Q Pace Electronics currently produces the shipping containers it uses to deliver the electronics products it sells the monthly cost of producing 9,000 containers is as follows. 1 2 3 4 DM DL 5 Variable OH 6 Fixed OH 7 8 $6,000 6,600 4,200 37,200 $54,000 Ace Container Co. has offered to sell comparable containers to Pace for $2.70 each. If Pace buys the containers is 9 will avoid $3,600 in fixed costs. 10 Required 11 12 13 11 15 16 17 18 19 20 21 22 23 24 P1 P2 P3 P4 P5 Ready 1 (10 points) Use incremental analysis to decide whether Pace should continue to make the containers. 2 (5 points) Pace has an offer to lease the space it currently uses to make the containers for $10,000 per month. Use incremental analysis to decide if your answer to part 1 would change. IT 100%