Question: please use ILP through excel solver and show work with formulas The three children of a farm couple are sent to the market to sell

please use ILP through excel solver and show work with formulas

The three children of a farm couple are sent to the market to sell 90 apples. Karen, the oldest, carries 50 apples; Bill, the middle one, carries 30; and John, the youngest carries only 10. The parents have stipulated 5 rules: (1) The selling price is either $1 for 3 apples or $2 for 1 apple. (2) Each child may exercise one or both options of the selling price. (3) Each of the three children must return with exactly the same amount of money. (4) Each child's income must be in whole dollars (no cents allowed). (5) The amount received by each child must be the largest possible under the stipulated conditions. Assume that the kids are able to sell all they have. Please Use ILP to show how the children can satisfy the parents' condition

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Use ILP The three children of a farm couple are sent to the market to sell 90 apples. Karen, the oldest, carries 50 apples; Bill, the middle one, carries 30; and John, the youngest carries only 10....

The three children of a farm couple are sent to the market to sell 90 apples. Karen, the oldest, carries 50 apples; Bill, the middle one, carries 30; and John, the youngest carries only 10. The...

The three children of a farm couple are sent to the market to sell 90 apples. Karen, the oldest, carries 50 apples; Bill, the middle one, carries 30; and John, the youngest, carries only 10. The...

Need mathematical modeling of below problem using linear programming 1. The three children of a farm couple are sent to the market to sell 90 apples. Karen, the oldest, carries 50 apples; Bill, the...

The three children of a farm couple are sent to the market to sell 90 apples. Karen, the oldest, carries 50 apples; Bill, the middle one, carries 30; and John, the youngest, car- ries only 10. The...

A farm couple are sending their three children to the market to sell 90 apples with the objective of educating them about money and numbers. Karen, the oldest, carries 50 apples; Bill, the middle...

1. In 2013, several data server companies took a dramatic decision to begin using energy surcharges to recapture rising energy costs. However, customers are critical of how the energy surcharges are...

I am so lost with all of this and the worst part it is due in an hour and a half. I don't know what to do please help. In this course you will have the opportunity to apply the concepts learned to a...

Question: Define the problem in the case and Recommend a solution to solve the problem. use quantitative and qualitative analysis to support the recommendation and layout the Implementation Plan for...

Consider the single-input, single-output system is described by x(t) = Ax(t) + Bu(t) y(t) = Cx(t) where Compute the characteristic polynomial and plot the root locus as 0 ¤ K 1 -8.c-u C = [1...

1: what is the relationship between management communication style and employee job satisfaction? Independent: management communication style/ dependent: satisfaction Q2: what is the relationship...

7. In the figure, the angle of elevation of the top of a wrtical tower PQ from a point A is 30. The foot of the tower Q, is on the same horizontal plane a as A and B. Given that AB=60 m, LRAQ-45 and...

According to recent census figures, the proportion of adults (persons over 18 years of age) in the United States associated with five age categories are as given in the following table: Age...