![]() ![]() This results in a profit of $16.22 without C. I've added a requirement that units sold be whole integers and instead solved for the smallest non-negative profit to achieve this, which is 760, or 646 units of A and 114 units of B. ![]() The second image is what I have expanded your solution to as it is probably more useful. This is the solution for break even without sales of C that you correctly solved to be ~756 units, but more specifically 642.49 units of A and 113.38 units of B. The first image is what I understand you've already accomplished but are having difficulty moving past. Orange Cells are constraint requirements to satisfy the conditions you've set. This is only the volume of each products A and B. Yellow Cells are variables required to solve for break even. Required units of A/B to satisfy sales split estimates Green cells are calculated values required for the solution. Proportion of A/B Customers also Purchasing C Blue cells are fixed by the user and you can modify/update as needed without affecting the solver. This model will work in all versions as it is linear and has minimal variables and constraints. You need to have the Solver Add-In installed, which should be in your Excel options menu by default. ![]() I can send you the book if you want, just PM me your email address, but you should be able to recreate pretty easily from this post. So I created two different sheets for this. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |