• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

With what combination of No. of Units, will you be able to generate maximum profit?

iansari504

New Member
Cost PriceSelling PriceProfit/UnitNo. of Units SoldTotal Profit
Product A
100​
120​
20​
1599.999979​
32000​
Product B
800​
880​
80​
1200​
96000​
Product C
400​
440​
40​
2000​
80000​
Total
4799.999979​
208000​
 
Here are the attached sheet and need the solution for these 2 question using what if analysis
 

Attachments

  • What if Analysis.xlsx
    9.8 KB · Views: 1
Back
Top