Question

Verizon LIE 17:26 The best way to understand the interrelationship between 2 uncertain numbers: O combine spinners o correlation coefficient O observe a scatter plot covariance Verizon LTE 17:24 0 The following spreadsheet illustrates a newsvendor model. Use the spreadsheet to answer the question(s) below ewsvendor Model Data elling price 20 iscount price Model emand urchase Q uantity antity Sold rofit What is the total profit generated? $488 $91 $117 $183 ch 0 The following spreadsheet illustrates a newsvendor model. Use the spreadsheet to answer the question(s) below Newsvendor Model ata elling price iscount price Model emand antity How will the formula to calculate A17 be represented in B172 How will the formula to calculate A17 be represented in B17? B12 B6 + B15 B7-B14 B5 O B15 87 B12 BS B14 B6 O B14 B5+ 815 B7-B12 B6

Answer 1

Answer to spreadsheet:

Quantity sold = quantity demanded = 22

surplus quantity = quantity purchased - quantity sold = 25 - 22 = 3

Total profit generated = [quantity sold *selling price] + [surplus quantity * discounted price] - [purchase quantity *cost price]

Total profit generated = [22 * 20] + [ 3* 9] - [ 25 * 14] =440+27 - 350 = $117

Correct option is option no 3

Formula to calculate A17 be presented in B17:

Total profit generated = [quantity sold *selling price] + [surplus quantity * discounted price] - [purchase quantity *cost price]

= B14* B5 + B15 * B7 - B12 * B6

Correct option is option no 4

***only one question has to be solved in case of unrelated multi questions