Answer to Question #112100 in Excel for Abdulrahman

Question

You went to the fresh produce market with a crate that that can handle a weight of
3 kg and you can choose to fill with any of the following products listed in table 1.
Which products will you take to maximize the value of your prize?
# Item Price ($) Weight (Kg)
1 Watermelon 15 0.85
2 Mango 20 0.30
3 Banana 10 0.1
4 Carrot 1 0.05
5 Peach 5 0.08

Answer 1

30 Bananas. Total weight = 3 kgs.

Maximum price = $300.