This is homework in Qualitative Analysis MBA Course regarding Derivatives.

From a table above the quadratic equation should be found in Excel and used as a base for derivative. The rest of calculations should is related to this first part.

Derivatives

Question 1: In the table above we have "Price vs. Number of Items Sold".  The first column is the price charged for a point of purchase dog toy in several different markets, while the second column is the number items sold of that item.  Plot the data with items sold as the y-variable and determine the quadratic fit to the data.  Insert the plot below and write out the quadratic equation allowing you to predict sales as a function of the price charged.

Question 2: What price would you charge to maximize items sold? (Use the quadratic fit you determined above.)

Question 3: Write out a quadratic equation which predicts revenue given the price charged.  (Use the same procedure as in Question 1.)

Question 4: What price would you charge to maximize revenue? (Use the quadratic equation from Question 3.)

Question 5: The cost of manufacturing one of the toys is given by the following equation:

Cost= 800/√Number of items made

Use this function to determine the cost of making the toys in each market for which you have data.  Use this cost data to determine the profit you make for each market. Finally, use the profit data to determine what price you should set to maximize profit. (Use the same procedure as in Question 1 and Question 2).

Question 6: Point out one area where the set up of this homework is unrealistic.