Formulate a linear mathematical programming model

Assignment Help Management Theories

Reference no: EM131859933

Question: A couple sent their three children to sell 90 cookies for a charity program The first carries 50 cookies, the middle one carries 30, and the youngest, carries only 10. The parents have stipulated five rules: (a) The selling price is either $1 for 7 cookies or $3 for one cookie, or a combination of the two prices (b) Each child may exercise one or both options of the selling price. (c) Each of the three children must return with exactly the same amount of money. (d) Each child's income must be in whole dollars (no cents allowed). (e) The amount received by each child must be the largest possible. Under these stipulated conditions and given that the three kids are able to sell all they have:

a. Formulate a linear mathematical programming model for the problem to satisfy the parents conditions (clearly define your decision variables, objective and constraints).

b. Use Excel and Solver to implement and solve the model you formulated in part (a) to find the optimal solution Report your results in the report by including a snapshot of your spreadsheet solution.

Reference no: EM131859933

Questions Cloud

Perform a data audit : Perform a data audit: Using IBM SPSS Modeler, perform a data audit on the dataset using the Data Audit Node. Perform a correlation analysis

Describe the concepts of product item and product line : The Crayola brand is currently placed on a wide variety of products, including crayons (standard and fluorescent colors packaged in a wide variety of box sizes)

What aspects of nursing make turnover for nurses : Turnover is high at almost every facility where nurses are employed. What aspects of nursing make turnover for nurses higher than for many other jobs?

What is the required rate of return on stock with beta : What is the required rate of return on a stock with a beta of 1.1?

Formulate a linear mathematical programming model : Formulate a linear mathematical programming model for the problem to satisfy the parents conditions.

Case is based on canadian tax law : Automotive Company is considering investing in a new low-cost hybrid cross-over vehicle.

Discuss functional area of planning based on the assessment : Defend two or three recommendations for improving the manager's performance in the functional area of planning based on the assessment of both strengths.

Analyze the hughes acquisition by first computing betas : Analyze the Hughes acquisition (which never took place) by first computing the betas of the comparison firms, Lockheed and Northrop,

Average beta of the new stocks added to the portfolio : What should be the average beta of the new stocks added to the portfolio?

User Account

All Pages