GRAPH PROBLEM                                                      
 
     A COMPANY IN A PURELY COMPETITIVE INDUSTRY HAS A TOTAL COST        
FUNCTION FOR ITS PRODUCT THAT CAN BE APPROXIMATED BY THE                
FOLLOWING EQUATION: 
                                          2                             
            TC = $6800 + $2.40 Q  + $.06 Q                              
                                                                        
IN WHICH Q IS THE ANNUAL OUTPUT RATE IN UNITS.                          
     THE MARKET PRICE IS $50 PER UNIT.                                  
                                                                        
DEVELOP A PROGRAM THAT WILL GIVE THE QUANTITY AT WHICH THE FIRM         
SHOULD PRODUCE TO MAXIMIZE PROFIT,  AND THE BREAKEVEN QUANTITY          
(THERE WILL BE 2 BEQ'S IN THIS PROBLEM).  AND HAVE THE PROGRAM         
GRAPH OF WHAT YOU HAVE JUST DONE, SIMILAR TO THE ILLUSTRATION.          
AND LABEL THE AXIS.                                                     
                                                                        
    $    ^                                                              
         !                       MAXIMUM PROFIT                         
         !.............................X                                
 PROFIT  !                          *  .  *                             
         !                       *     .    *                           
         !                     *       .      *                         
         !                   *         .        *                       
         !                 *           .          *    Q OUTPUT         
       0 !---------------X-------------.------------X----------->       
         !             * BEQ 1         Q        BEQ 2 *   SALES         
         !            *                                *                
         !          *                                    *              
 LOSS    !       *                                         *            
         !    *                                               *         
         !  *                                                   *       
         V*                                                       *     

       NET PROFIT IS GIVEN BY:  NP =  $50 Q  -  TC.                     

HINTS: ASSUME YOUR Y-AXIS HAS 101 POINTS, 50 IN THE NEGATIVE            
       AND FIFTY IN THE POSITIVE.  DIVIDE YOUR NET PROFIT BY 100        
       AND ADD +51 TO THE NUMBER AND PLOT THAT NUMBER.                  
       ANY NUMBER THAT DOES NOT FIT THE GRAPH                           
       SIMPLY SET TO THE MAXIMUM OR MINIMUM GRAPH POSITION.
             
In EXCEL calculate the net profit from 100 to 800 by 10.
Graph the net profit column.
Use the Quadratic formula below to compute 2 break-even points.
Use the Max Profit Quantity to show the best production rate.
Lastly, write a one page (short) report on your findings and include the BEQ and MPQ formulas using the MS Equation editor. 

A=-.06  B=47.6   C=-6800   (BEQs=187,606 - MPQ=397)                                                                  
 
  Break Even Quantities BEQ(2)                                                                    
        Maximum Profit Quantity  MPQ