What are the constrains for each section? Morning Delight produceds 3 granola bars: Chocolate-Chip Bars, Chewy-Raisin Bars,
Fantastic news! We've Found the answer you've been seeking!
Question:
What are the constrains for each section?
Transcribed Image Text:
Morning Delight produceds 3 granola bars: Chocolate-Chip Bars, Chewy-Raisin Bars, and Nut-Butter Bars. Each Chocolate-Chip bar contains 1 oz granola and 0.5 oz chocolate chips. Each Chewy-Raisin bar contains 1 oz granola and 0.5 oz raisins. Each Nut-Butter bar contains 1 oz granola and 0.5 oz nut butter. Inventories available per month are as follows: chocolate chips 200 oz, raisins 300 oz, nut-butter 150 oz. A monthly contract with supplier of at least 1000 oz of granula must be satisfied. Production should not exceed the following projected monthly demand: 500 Chocolate-Chip Bars, 750 Chewy-Raisin Bars, and 400 Nut-Butter Bars. Profit contributions per bar: Chocolate-Chip Bar $0.30/bar, Chewy-Raisin Bar $0.50/bar, and Nut-Butter Bar $0.75/bar. How many granola bars of each type should be produced per month to maximize total profit? Numbers of Granola bars must be whole numbers. <---- Formulate Objective Function 0.5 points 0.5 points 0.5 points 0.5 points 0.5 points 0.5 points 0.5 points 0.5 points 0.0 points 1 point 1 point 1 point max z = 0.32 x1 +0.05 x1 +0.75 x1 Subject To: Set up the problem on a different sheet Solve the problem using SOLVER, making sure to generate the ANSWER Report How much is the total profit? <---Constraint Chocolate Chips Avail <---Constraint Raisins Avail <---Constraint Nut Butter Avail <---Constraint Granola Contract <---Constraint Demand Chocolate-Chip Bars <---Constraint Demand Chewy-Raisin Bars <---Constraint Demand Nut-Butter Bars <---Non-negativity, Integer Constraint(s) Morning Delight produceds 3 granola bars: Chocolate-Chip Bars, Chewy-Raisin Bars, and Nut-Butter Bars. Each Chocolate-Chip bar contains 1 oz granola and 0.5 oz chocolate chips. Each Chewy-Raisin bar contains 1 oz granola and 0.5 oz raisins. Each Nut-Butter bar contains 1 oz granola and 0.5 oz nut butter. Inventories available per month are as follows: chocolate chips 200 oz, raisins 300 oz, nut-butter 150 oz. A monthly contract with supplier of at least 1000 oz of granula must be satisfied. Production should not exceed the following projected monthly demand: 500 Chocolate-Chip Bars, 750 Chewy-Raisin Bars, and 400 Nut-Butter Bars. Profit contributions per bar: Chocolate-Chip Bar $0.30/bar, Chewy-Raisin Bar $0.50/bar, and Nut-Butter Bar $0.75/bar. How many granola bars of each type should be produced per month to maximize total profit? Numbers of Granola bars must be whole numbers. <---- Formulate Objective Function 0.5 points 0.5 points 0.5 points 0.5 points 0.5 points 0.5 points 0.5 points 0.5 points 0.0 points 1 point 1 point 1 point max z = 0.32 x1 +0.05 x1 +0.75 x1 Subject To: Set up the problem on a different sheet Solve the problem using SOLVER, making sure to generate the ANSWER Report How much is the total profit? <---Constraint Chocolate Chips Avail <---Constraint Raisins Avail <---Constraint Nut Butter Avail <---Constraint Granola Contract <---Constraint Demand Chocolate-Chip Bars <---Constraint Demand Chewy-Raisin Bars <---Constraint Demand Nut-Butter Bars <---Non-negativity, Integer Constraint(s)
Expert Answer:
Related Book For
Microeconomics Principles, Problems and Policies
ISBN: 978-1259450242
20th edition
Authors: Campbell R. McConnell, Stanley L. Brue, Sean Masaki Flynn
Posted Date:
Students also viewed these accounting questions
-
What fact ultimately constrains consumption of any item said to be available in "unlimited" amounts at a fixed price?
-
What type of assets are Section 1231 assets? What type of assets are capital assets? What type of assets are ordinary income assets? Give several examples of each type of asset.
-
Each hour, a 10 m 2 section of fabric is inspected for flaws. The numbers of flaws observed for the last 20 hours are as follows: a. Compute the upper and lower 3 limits for a c chart. b. Is the...
-
Design an application that declares two CheckingAccount objects and sets and displays their values. Write the pseudocode that defines the class from the class diagram & previous information...
-
True or False: 1. Human welfare is greatly influenced by long-term changes in a nations capacity to produce goods and services. 2. Emphasis on the short run of the business cycle can ignore the...
-
Deduce the structure of a compound with molecular formula C 6 H 14 O 2 that exhibits the following IR, 1 H NMR, and 13 C NMR spectra. 100 80 60 40 20 3000 2500 Wavenumber (cm-1) 4000 3500 2000 1500...
-
How you may use computers for litigation support?
-
A firm pays a $1.50 dividend at the end of year one (D1), has a stock price of $155 (P0), and a constant growth rate (g) of 10 percent. a. Compute the required rate of return (Ke). Indicate whether...
-
Exercise 14-1 (Algo) Common-Size Income Statement [LO14-1] A comparative income statement is given below for McKenzie Sales, Limited, of Toronto: McKenzie Sales, Limited Comparative Income Statement...
-
Show that the probability that the period of f(x)=a x mod M is odd is at most 1/2.
-
How to write a proposal on classism for picking majors of study?
-
What is a descent group? What forms do descent groups take? What are some of their functions?
-
Why do feminist economists question the effectiveness of neo-classical approaches to economics in providing answers to questions which affect women?
-
Imagine an economy in which all wages are set in three-year contracts. In this world, the central bank announces a disinflationary change in monetary policy to begin immediately. Everyone in the...
-
Discuss the concept of property ownership in tribal societies. How does it differ from what generally occurs in band societies?
-
Assume the interest rate is 6 per cent. In each of the following three cases, state which you would rather receive and briefly explain why: a. 200 today or 480 in two years? b. 205 today or 240 in...
-
Calculate the standard enthalpy for the given reaction. CaCOg CaO + CO, AHfCaCO3 = 1206.9 AHfCaO -635.1 kJmol = AHfCO-393-5
-
In Exercises 1-2, rewrite each verbal statement as an equation. Then decide whether the statement is true or false. Justify your answer. 1. The logarithm of the difference of two numbers is equal to...
-
A mathematically fair bet is one in which the amount won will on average equal the amount bet, for example when a gambler bets, say, $100 for a 10 percent chance to win $1,000 ($100 = .10 x $1,000)....
-
All MegaCorp employees who stay on the job for more than three years are rewarded with a 10 percent pay increase and coverage under a private health insurance plan that MegaCorp pays for. Tina just...
-
In Country A, the production of 1 bicycle requires using resources that could otherwise be used to produce 11 lamps. In Country B, the production of 1 bicycle requires using resources that could...
-
True or false? Explain: modularity reduces complexity because A. It reduces the effect of incommensurate scaling. B. It helps control propagation of effects.
-
True or false? Explain: hierarchy reduces complexity because A. It reduces the size of individual modules. B. It cuts down on the number of interconnections between elements. C. It assembles a number...
-
If one created a graph of personal friendships, one would have a hierarchy. True or false?
Study smarter with the SolutionInn App