The challenge is to build a spreadsheet that will calculate the lowest cost combination of medicine vials, based on what a patient needs. The bigger sizes come at a discount price to the smaller ones. In this scenario, medicine is sold in 3 different size vials: 50mg, 150mg, and 450mg. Let’s walk through an introduction to Solver and work through an example… The Problem Fortunately, Excel has an official Plug-in called Solver that can do amazing things to solve optimization problems like this. This is a problem that would be very challenging to solve with basic IF statements and arithmetic formulas. Buy too much, it will be wasted, and that won’t save you money at all. Bigger sizes come at a discount, which can save you money. ![]() Imagine you’re faced with a purchasing problem… You need to buy some inventory that comes in multiple sizes. ![]() ![]() ![]() 6To Download the Sample Worksheet, Click Here.5Running Solver and Checking the Output.
0 Comments
Leave a Reply. |