Mangerial Accounting the questions is posted in the pictures questions below need help getting the answers for the cells highlighted in Blue. Tried to solve some of it but don't think it's correct.

cricket $ 6:04 PM 1 22% X Screen Shot 2019-12-15 at... 125% View Zoom Insert Table Chart Text Shape Media Collaborate Format Organize Instructions Data ENTERANSWERS (O 34 35 SUMPRODUCT 36 Excel Solver 37 38 40 9 Excel Hints 41 SUMPRODUCT allows you set up a simplified equation to add up (SUM) the results of cells multiplied by each other (PRODUCT). Examine the following: 42 43 44 2 Product #1 Product #2 Product #3 Total Total using SUMPRODUCT 45 3 Quantity 10 15 46 4 Sales Price LOO 200 300 47 6 Total Sales 7,000 7,000 49 7 Formulas =(83*84)+(C3*C4)+(D3*D4) =SUMPRODUCT(83:D3,84:D4) 50 51 Total sales is equal to the quantity of Product #1 times sales price for Product #1, plus the quantity of Product #2 times sales price for Product #2, plus the quantity of Product #3 52 times sales price for Product #3. The traditional formula is displayed in cell E7. The SUMPRODUCT formula is displayed in cell F7, which is the range of items to be multiplied, comma, the range of items to be multiplied by. You can highlight with the cursor the range of items in either array. 53 54 The Solver is an Excel add-in. To load Solver onto the Data ribbon in the Analyze area: 55 a. Click File > Options > Add-ins 56 b. In the Manage box, select Excel Add-ins and click GO. 57 58 59 60 62 63 64 66 68 Text Magnolia Company produces leather shoes in three models: Medina, Ballard, and Fremont. Currently, Magnolia is manufacturing 4,000 pairs of Medina, 6,000 pairs of Ballard, and 1,500 pairs of Fremont during the year, for a Total cont - 0 SG$26:SG$28 = 0 105 SGS26:SG$28