Qualitative Analysis Homework Derivatives
This is homework in Qualitative Analysis MBA Course regarding Derivatives.
This question was already posted before here.
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. My lecturer said it is not so long and difficult. Maximum 20 minutes (who knows) of work on it.
Willing to pay $10 for homework (all 6 questions). No bidding and shaking hands. Accepting serious offers only. Thank you.
Derivatives
Price |
Number of Items Sold |
4.25 |
714495 |
4.64 |
704405 |
4.74 |
738689 |
5.15 |
738423 |
5.84 |
700775 |
6.07 |
701370 |
6.16 |
705884 |
6.38 |
697011 |
6.57 |
686771 |
6.59 |
683839 |
6.78 |
665641 |
6.82 |
690920 |
6.86 |
670827 |
7.08 |
683833 |
7.11 |
666674 |
7.30 |
637978 |
7.35 |
631497 |
7.41 |
639231 |
7.42 |
631739 |
7.66 |
620396 |
7.78 |
612080 |
7.79 |
639209 |
7.79 |
591471 |
7.80 |
590248 |
7.92 |
615265 |
7.93 |
589644 |
7.99 |
598021 |
8.07 |
610704 |
8.07 |
595432 |
8.32 |
576894 |
8.40 |
575995 |
8.58 |
555844 |
8.67 |
559958 |
8.72 |
535670 |
8.74 |
540079 |
8.80 |
549971 |
8.87 |
541065 |
8.99 |
515531 |
9.14 |
522314 |
9.16 |
512325 |
9.21 |
492818 |
9.51 |
479736 |
9.59 |
480402 |
10.13 |
397314 |
10.59 |
362052 |
10.73 |
335221 |
10.92 |
310495 |
11.65 |
216427 |
12.81 |
13666 |
12.84 |
23702 |
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.