User Account

All Pages

What is the optimal product composition

Assignment Help Business Management
Reference no: EM132965621

Please use Excel Solver and show clear step up of the problem step by step.

Patterson Nut Company wishes to introduce packaged trail mix as a new product. The five ingredients for the trail mix are: seeds, raisins, granola, pecans and walnuts. Each ingredient contains a certain amount of vitamins, minerals, protein and calories. The marketing department has specified the product to be designed so that a certain minimum nutritional profile is met. The data is shown below summarize the parameters of the problem.

Units per Pound Nutritional Requirement

Seeds Raisins Granola Pecans Walnuts

vitamins 10 20 10 30 20 16

Minerals 5 7 4 9 2 10

Protein 1 4 10 2 1 15

Calories 500 450 160 300 500 600

Cost/pound $4 $5 $3 $7 $6

This data can be interpreted as follows. The trail mix should have at least 16 units of vitamins at least 10 units of minerals, at least 15 units of protein, and at least 600 calories. The columns associated with each ingredient provide us their nutritional composition and cost. For example, a pound of seeds provides 10 units of vitamins, 5 units of minerals, 1 unit of protein, 500 calories and costs $4.

Patterson would like to determine the product composition of a trail mix that meets the nutritional requirements at a minimum cost.

a) Write a mathematical linear program for the above optimization problem, including clearly defined decision variables, objective function and constraints.

b) Solve the linear programming model in Excel Solver. Please take screen shots and show step by step process.

c) What is the optimal product composition? That is, how much of each of the five ingredients should be in the trail mix? State this in words.

d) What is the cost of this optimal product composition. State this in words.

e) Patterson's owner insists that each of the trial mix ingredients makes up at least 15% of the overall trail mix. i) Show mathematically how to modify your model to incorporate this requirement and ii) Implement modification in Solver Model in a separate sheet to determine the new optimal product composition and cost. State the new optimal product composition and its cost. The model should be linear.

Reference no: EM132965621

Questions Cloud

Findings on singapore airline sustainability : Post a summary of your findings on Singapore Airline's sustainability. Make sure that you include your references and they are written in APA format.
How does coaching differ from other service professions : How does coaching differ from other service professions (namely consulting, training, and psychology)?
Explain how MMPL will recognise the revenue : Explain how MMPL will recognise the revenue arising from Annie's purchase of this promotion package using the five-step model from FRS 115 Revenue
Explain a feasible purchase combination : Cully Furniture buys two products for resale: big shelves (B)and medium shelves (M). Each big shelf costs $500 and requires 100 cubic feet of storage space, and
What is the optimal product composition : This data can be interpreted as follows. The trail mix should have at least 16 units of vitamins at least 10 units of minerals, at least 15 units of protein, an
Maximising resources to achieve business success : Maximising Resources to Achieve Business Success - Level 3 Diploma in Business and Management
What is the book value of the old equipment : Hercules Exercise Equipment Co. purchased a computerized measuring device two years ago for $76,000. What is the book value of the old equipment
Examine the problems faced in goal settings : The process of influencing individual goals and ensuring that they are congruent with those of the organisation is a complex one and it is not entirely clear th
Why does the hierarchy of values have conformation : Present a hierarchical list of values, starting with those that human societies in general treat as most important and ending with the least important.

Reviews

Write a Review

Business Management Questions & Answers

  Problem regarding the market-basket analysis

Suppose you work at Costco or another major, national big-box store; you do a market-basket analysis and identify the 25 pairs of items in the store that have the highest lift and the 25 pairs that have the lowest lift.

  What type of pattern exists in the data

Consider the following time series: a. construct a time series plot. what type of pattern exists in the data? b. Use Excel Solver or LINGO to find the parameters for the line that minimizes MSE this time series. C.What is the forecast for t=8

  Examples where intellectual property is threatened

The creators of intellectual property have some protection. Explain what you view as threats to intellectual property in today's world economy. What are some examples where intellectual property is threatened? What are some protections in place to..

  How and in what ways do cultures communicate

How and in what ways do cultures communicate differently and does it make a difference in the workplace

  Qualitative and quantitative forecasting method

Determine a qualitative and quantitative forecasting method for your operation. Next, create a table in which you identify the characteristics of the operation that relate to each method.

  How derived demand affect the manufacturing of an automobile

How might derived demand affect the manufacturing of an automobile? - How will your buying process for the company differ from your recent purchase for yourself?

  Discuss the levels of organizational culture

Discuss the levels of organizational culture. Summarize the actions and behaviors a health leader would perform to proactively and positively

  Efforts important in business environments

Are diversity and inclusion efforts important in business environments?

  What is performance appraisal

Can you clearly explain what is Performance Appraisal and also give some of its examples?

  Which of the following is not true in relation classes

1. Which of the following is not true in relation classes and objects? a. Two object instances from the same class share the same properties

  Explain the importance of team effectiveness

Explain the importance of Team Effectiveness and how it contributes to consumer satisfaction. What are the characteristics of teams, specifically in a healthcar

  Increases total variable costs rise proportionately

The marginal cost of an item is its variable cost. What is the formula for calculating the marginal cost?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd