Scenario Things have been going well with your job at Northwind Traders. You received another message, containing a file, from your manager today on Slack: Thank you for the last memo and reports, they were incredibly helpful. I was curious about our top customer in Germany, and I had Chad to put together some data on them. He didn't have a chance to finish things though, and he didn't link the data, but he did put together a table with: their five highest selling products this past year (units sold) their current price per unit the units sold in the last year their total revenue I need you to finish this up. Can you look over the data and give me some updates? 1. If we suggested they update the price of only one product, how much would they need to charge to reach total revenue of $35k? Give me an estimate for changing each product 2. Conversely, if we suggested they redouble their efforts to sell more of only one of these products, how many more would they need to sell to reach total revenue of $35k? Again, estimate for each product 3. Put together a quick scenario summary to show the most profitable scenario among the following: increasing the price of Product A by $12 increasing the price of Product B by $7.20 increasing the price of Product C by $13.60 increasing the price of Product D by $2.40 increasing the price of Product E by $11.67 If I've missed anything here that you can think of, give me your insights. Just make sure to provide the data so I can have it ready if I meet with them. x Raw_Data_German AutoSave 0 CH RawData Germany QUICK-Stop 1 (1) - Excel -1 Search (Alti Mang lag 45 dc T AM File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Calibri - A A 11 AutoSum - 29 Wrap Text LEX FO) FOG General 2 e N ca Paste a. A v BIU A Merge Center Tasks Insert Delete Format DM Conditional Format as Cell Fomatting Table Styles Styles Sensitivity $ % to Clear Sort & Find & Filter Select Editing Analyze Data Clipboard Font Alignment Number Cels Analysis Sensity MyEducator G28 A B C D F G H K 1 1 Germany 2 QUICK-Stop Top Five Products 3 Product A - Uncle Bob's Organic Dried Pears 3 4 Product B Lakkalikri 5 Product C- Camembert Pierrot 6 Product D - Kunbu 7 Product - Gula Malacca 8 9 Current Price Per Unit $60.00 $36.00 $68.00 $12.00 $58.35 Units Sold Revenue 135 $8,100.00 134 $4,824.00 104 $7,072.00 97 $1,164.00 90 $5,251.50 Increase Quantity Target (Product A) Target (Product B) Target (Product C) Target (Product D) Target (Product E) Increase Price Target (Product A) Target (Product B) Target (Product C) Target (Product D) Target (Product E) Total Revenue - Top 5 $26,411.50 Total Units Sold - Tap 560 Most Profitable Scenario Additional Notes 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 79 QUIK-Stop Report Data Ready 1004 Scenario Things have been going well with your job at Northwind Traders. You received another message, containing a file, from your manager today on Slack: Thank you for the last memo and reports, they were incredibly helpful. I was curious about our top customer in Germany, and I had Chad to put together some data on them. He didn't have a chance to finish things though, and he didn't link the data, but he did put together a table with: their five highest selling products this past year (units sold) their current price per unit the units sold in the last year their total revenue I need you to finish this up. Can you look over the data and give me some updates? 1. If we suggested they update the price of only one product, how much would they need to charge to reach total revenue of $35k? Give me an estimate for changing each product 2. Conversely, if we suggested they redouble their efforts to sell more of only one of these products, how many more would they need to sell to reach total revenue of $35k? Again, estimate for each product 3. Put together a quick scenario summary to show the most profitable scenario among the following: increasing the price of Product A by $12 increasing the price of Product B by $7.20 increasing the price of Product C by $13.60 increasing the price of Product D by $2.40 increasing the price of Product E by $11.67 If I've missed anything here that you can think of, give me your insights. Just make sure to provide the data so I can have it ready if I meet with them. x Raw_Data_German AutoSave 0 CH RawData Germany QUICK-Stop 1 (1) - Excel -1 Search (Alti Mang lag 45 dc T AM File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Calibri - A A 11 AutoSum - 29 Wrap Text LEX FO) FOG General 2 e N ca Paste a. A v BIU A Merge Center Tasks Insert Delete Format DM Conditional Format as Cell Fomatting Table Styles Styles Sensitivity $ % to Clear Sort & Find & Filter Select Editing Analyze Data Clipboard Font Alignment Number Cels Analysis Sensity MyEducator G28 A B C D F G H K 1 1 Germany 2 QUICK-Stop Top Five Products 3 Product A - Uncle Bob's Organic Dried Pears 3 4 Product B Lakkalikri 5 Product C- Camembert Pierrot 6 Product D - Kunbu 7 Product - Gula Malacca 8 9 Current Price Per Unit $60.00 $36.00 $68.00 $12.00 $58.35 Units Sold Revenue 135 $8,100.00 134 $4,824.00 104 $7,072.00 97 $1,164.00 90 $5,251.50 Increase Quantity Target (Product A) Target (Product B) Target (Product C) Target (Product D) Target (Product E) Increase Price Target (Product A) Target (Product B) Target (Product C) Target (Product D) Target (Product E) Total Revenue - Top 5 $26,411.50 Total Units Sold - Tap 560 Most Profitable Scenario Additional Notes 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 79 QUIK-Stop Report Data Ready 1004