Question: Please include formulation, model spreadsheet and answer A pet hotel makes dog food by mixing three grain products to obtain a balanced diet. The data

Please include formulation, model spreadsheet and answer

Please include formulation, model spreadsheet and

A pet hotel makes dog food by mixing three grain products to obtain a balanced diet. The data for the three products are shown in the following table: GRAIN PRODUCT COST PER POUND ($) PROTEIN (%) CARBOHYDRATE (%) FAT (%) A B 0.45 0.38 0.27 62 55 36 5 10 20 3 2 1 The manager wants to make sure that each of the dogs consumes at least 8 ounces protein and 1 ounce of carbohydrate, and no more than 0.5 ounces of fat each day. Develop a linear optimization model to determine how much of each grain product should be used in the dog food in order to minimize the cost. Solve it by Excel's solver. (16 ounces = 1 pound)

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!

you will be given a Organization Profile in which you will then answer your questions according to the information in the Organization Profile. The questions should be formatted such that when I send...

Evaluation Only. Created with Aspose.Words. Copyright 2003-2018 Aspose Pty Ltd. 1. Surfing USA, an Internet service provider, is considering to offer a service in Laramie County, WY, that connects a...

Here is the new homework question. Please review the General Homework instructions due to the instructor being so strict. Were there any podcasts or Homework document notes that you needed me to...

Hello there, I am having a real hard time figuring out how to arrive at the gross plant & equipment amount for Exercise 4-9 part a Colgate's Average total life span of plant and equipment using their...

Case Breeder's Own Pet Foods, Inc. In January 2011, Breeder's Own Pet Foods, Inc. executives looked forward to their meeting with representatives of Marketing Momentum Unlimited, a market- ing and...

Nestle Global: looks for ways to boost stale growth as consumers snub unhealthy food Large food companies have long been among the world's most solid, with reassuringly consistent returns even in...

Case Breeder's Own Pet Foods, Inc. In January 2011, Breeder's Own Pet Foods, Inc. executives looked forward to their meeting with representatives of Marketing Momentum Unlimited, a market- ing and...

A strain of tuberculosis bacteria grows at a rate proportional to its size. A researcher has determined that every hour the culture is 1.5 times larger than the hour before and that initially 1here...

Calculate the rain attenuation which is exceeded for 0.001 percent of the time in any year, for a point rain rate of 10 mm/h. The frequency is 15 GHz and assume circular polarization. The earth...

Please explain how the current geopolitical contestations impact the decision on where to buy or manufacture its drones in South Africa.

What is an example of constructive feedback? provide reference