Question: Hello, i don't know how to do these questions, so can you cpmpute these question in detailed steps ? Thank you for your help! -9.
Hello, i don't know how to do these questions, so can you cpmpute these question in detailed steps ? Thank you for your help!

-9. Referring to question 8, (a) what formula goes in cells F10, E3, E4, E5, and B6 of the following Excel spreadsheet? Ee Fe Costs $140.00 by Rail Totals 120 60 Be $200.00 by Truck 45 50 132 108 43.2% 108 Required 120 200- 250 Week 12 Week 2 Week 32 Shipped bye Percentage Total Limit De $500.00 by Aire 152 0 02 15 15% 37.52 225 250- 55 12- 127 40% 100 Total Cost $46,880.00 Trucke 452 Air 13 | 14- Week 12 Week 2 Week 32 Weekly Limits Raile 604 552 45 L 50 15 10 5e 15.1 55 b. What cell references would you enter in Solver for the cells in this Excel spreadsheet implementation of this problem? -9. Referring to question 8, (a) what formula goes in cells F10, E3, E4, E5, and B6 of the following Excel spreadsheet? Ee Fe Costs $140.00 by Rail Totals 120 60 Be $200.00 by Truck 45 50 132 108 43.2% 108 Required 120 200- 250 Week 12 Week 2 Week 32 Shipped bye Percentage Total Limit De $500.00 by Aire 152 0 02 15 15% 37.52 225 250- 55 12- 127 40% 100 Total Cost $46,880.00 Trucke 452 Air 13 | 14- Week 12 Week 2 Week 32 Weekly Limits Raile 604 552 45 L 50 15 10 5e 15.1 55 b. What cell references would you enter in Solver for the cells in this Excel spreadsheet implementation of this
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
