Question: i need formulation for this question and the way to solve it in excel . note ( the solution that you have guys not clear,

i need formulation for this question and the way to solve it in excel . note ( the solution that you have guys not clear, cus. in sum m3:m6 not shwon ).

2. The Good-Nut Company sells dry-roasted nut mixes. The table below gives the price per bag and the ingredients in a 210g bag of its four best-selling nut mixes, along with current prices of a kilo of each nut type Peanuts Brazils Walnuts Almonds Mixes Cocktail Special Cashews 60 Price ($) 60 30 30 30 2.20 Deluxe Mix 90 60 60 2.50 Good-Nut Mix 90 60 60 2.20 Party Special 120 90 2.50 7.20 3.75 6.00 8.25 9.50 Price per kilo (S) The Good-Nut Company has the following stocks of bulk nuts (in kilos): 200 (cashews), 100 (brazils). 50 (walnuts), 150 (almonds) and an unlimited supply of peanuts. The Company cannot sell more than 800 bags of Cocktail Special in the current period. Recommend the best product mix to maximize profits. Solve this linear programming problem using Excel's Solver

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!

Henry Wells, William Fargo, and their partners decided the two business services most needed by San Franciscans were transportation and banking. After acquiring a building near the intersection of...

MATHEMATICS FOR MACHINE LEARNING Marc Peter Deisenroth A. Aldo Faisal Cheng Soon Ong Contents Foreword 1 Part I Mathematical Foundations 9 1 Introduction and Motivation 11 1.1 Finding Words for...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

I am looking for the solution or guidance with the following case study. The case study has been asked about by other students but I cannot find the solution. can you direct me to it or provide some...

Please read the question Question: On pages 5 and 6 the authors write, "Narrative provides not only meaning but also a mental framework for imbuing future experiences and information with meaning, in...

1 2.3 Definition of a Discrete Probability Function Definition: Let S be a discrete sample space from some experiment. A function P, defined on all events in S, is said to be a probability function...

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

U.S. Army Cost Benefit Analysis Guide 12 JANUARY 2010 Prepared by Office of the Deputy Assistant Secretary of the Army (Cost and Economics) Version 1.0 U.S. Army Cost Benefit Analysis Guide - V 1.0 2...

See Attached You know that the fish requires at least 100 grams of food. At the same time, fish is a strange animal in the sense that if you feed it more food than it needs, then it will eat the...

Could you please solve this using excel and show a step by step way to plug it in . Really struglling with this question Q 1 ( 2 0 pts ) . One of the many linear programming applications is in doing...

Task 1. Recently you received a complaint from Peter, a gym member, by email. Peter said he is not happy working out at the gym because people stay too long at the equipment during peak hours, and he...

In a construction project, the field moist unit weight was 18.08 kN/m3 at a moisture content of 8%. If maximum and minimum dry unit weight determined in the laboratory were 16.93 kN/m3 and 14.46...

Which type of charitable remainder trust permits additional contributions to the trust after its inception? Group of answer choices CRATs. CRUTs. Both CRATs and CRUTs. Neither CRATs nor CRUTs.

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...