Question

Requires Respondus LockDown Browser + Webcam Time Left:1:15:39 Rahima Daino: Attempt 1 00:00 Question 25 (1 point) At what quantity is selling either of the products equally profitable (point of indifference i.e. crossover point)? Price/Unit Variable Cost/unit Fixed Cost Product 1 Product 2 65 20 36,000 52 28 20,850 (Answer rounded to O decimal points, use standard rounding procedure) Your Answer: Answer Question 26 (1 point) What will be the MAPE (Mean Absolute Percent Error) of the table belc your answer to 2 decimal places, keep in decimal format)

Answer 1

Question 25

Let, for x units products will become equally profitable so,

65x-36000-20x = 52x-20850-28x

or, 45x-36000=24x-20850
or, 21x = 36000-20850 = 15150
or, x = 15150/21 = 721.4285714 = 721 units (Rounding) (Answer)

Question 26

D E F G А B с 1 three period moving average 2 Period Sales forecast 3 1 7 error Absolute error Squared error Abs percent error 4 N 5 5 3 9 6 4 11 7 4 4 36.36363636 16 28.8369 7 5 13.7 8.33 5.37 5.37 39.19708029 00 9 MAPE 37.78 10

MAPE = 37.78

Formula

B с D E F Sales forecast error Absolute error Squared error Abs percent error 7 1 three period moving average 2 Period 31 4 2 5 3 6 4 7 5 5 9 11 7 =E6^2 =B6-C6 =B7-C7 =ABS(D6) =ABS(D7) = (E6/B6) *100 = (E7/B7)*100 13.7 8.33 =E7^2 8 9 MAPE =ROUND(AVERAGE(G6:47),2) 10