This preview shows page 1. Sign up to view the full content.
Unformatted text preview: If the Unit Cost was changed from $2.75 to $2.50 the Total Profit would changed from $125,000 to $150,000 C) "Goal Seek" analysis tool to find Price (B3) which results in a Total Profit (B11) of $200,000 $6.14 price would result in a profit of $200,354 D) "Goal Seek" analysis tool to find Fixed Costs (B8) which results in a Total Profit (B11) of $150,000 $75,000 fixed costs will result in a total profit of $150,000 E) "Optimization" analysis (using solver tool) to find what Price (B3) maximizes Total Profit (B11) The price that mazimizes profit is $8.87 and the profit is maximizes is $275,156.25 A B C D E F G H 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26...
View
Full
Document
This note was uploaded on 04/23/2008 for the course GB 203 taught by Professor Montissino during the Spring '07 term at Bentley.
 Spring '07
 Montissino

Click to edit the document details