Search for question
Question

[10 marks] A company sells a commercial product with a fixed cost of $80,000 per month,and a variable cost of $90 per unit. The selling price is $200 – 0.02(D). Using the givenExcel template: a. [3 marks] Determine by a hand-written solution the optimal demand for this product. b. [3 marks] Determine by a hand-written solution the breakeven points. c. [3 marks] Plot using Excel the Cost, Revenue, and profit versus the demand. The range of the demand is 0 to 6000. d. [1 mark] Comment on the results obtained by hand-written calculations versus Excel.

Fig: 1

Fig: 2

Fig: 3

Fig: 4

Fig: 5