Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. need to build an excel optimization model to find

Need to build an Excel optimization model to find the mixture with lowest total cost!...

60.1K

Verified Solution

Question

Accounting

Need to build an Excel optimization model to find the mixture with lowest total cost!

The Blanton Seed Company specializes in food products for birds and other household pets. In developing a new cockatiel mix, company nutritionists have specified that the mixture must contain at least 13 percent protein and 15 percent fat, and no more than 15 percent fiber. Given in the table below are the percentages of each of these nutrients and the wholesale cost per pound. image

Fiber Cost/lb Ingredient Sunflower White millet Protein Fat 26 4.1 0.22 0.19 16.9 29 8.3 12 Kibble corn 8.5 3.8 2.7 0.10 15.4 0.40 Oats 6.3 2.4 Cracked corn 3.8 8.5 2.7 0.07 Wheat 12 0.05 1.7 2.3 Safflower 18 17.9 28.8 0.26 Canary grass seed 0.11 11.9 4 10.9

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

How could we get the chemical element iron (Fe) that is required to make steel? In...

Mechanical Engineering
Q

Explain how nationalism, alliances, advances in weaponry, and unmet nationalist expectations were causes of World War...

Psychology
Q

What microbes have coupled transcription and translation?O a. Prokaryotes O b. All microbes Oc. Eukaryotes...

Biology
Q

Comparison of your contig DNA sequence to the Wt sequence of the T7 RNA polymerase...

Biology
Q

We have two concentric conducting sphere S of radius Rand S of radius 2R and...

Physics
Q

Expand the binomial by using Pascal s Triangle to determine the coefficients 6v 3z 4

Geometry
Q

14 If the base of a triangle is 6a 2 and its height is 13a...

Algebra
Q

A client owns an apartment building with a fair market value of $250,000, an adjusted...

Accounting
Q

The excess of investment over book value in a Parent-Subsidiary is assigned to goodwill assuming...

Accounting
Q

Question 5 (6 marks) On 1" January 2013, Green Ltd., a company that prepares financial...

Accounting
Q

31. Year 2. for Goldfish Company showed the follow Statement of Earnings Sales revenue Cost...

Accounting
Q

Financial data for Joel de Paris, Inc., for last year follow: ...

Accounting