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

A 24-tooth spur gear is to drive a 12-tooth spur gear. For both gears, the...

Mechanical Engineering
Q

subject human resources management What is the role of Immediate Supervisor during an appraisal interview? Explain with...

General Management
Q

moor 230 V e circuit shown in the figure alongside shows a series LCR circuit...

Physics
Q

Information of S/C 1.THE BUYER: TKAMLA CORP. 6-7, KAWARA MACH, TOKYO JAPAN 2.THE SELLER: SHANGHAI...

Accounting
Q

Use one example to explain what is moral hazard problem in finance industry. How should...

Accounting
Q

Required: For the month of February: 1. Prepare journal entries...

Accounting
Q

Parkins Company produces and sells a single product. The company's income statement for the most...

Accounting
Q

Redhawk, Inc., is a merchandiser that provided the following information: ...

Accounting
Q

Kaler Company has sales of $1,270,000, cost of goods sold of $750,000, other operating expenses...

Accounting
Q

***** If Sarah's wages decrease to $70,000, James's wages decrease to $45,000,...

Accounting
Q

Cullumber Sports Inc. manufactures basketballs for the Womens National Basketball Association (WNBA). For the first...

Accounting
Q

Calculate the Accounts payable turnover (APT). the Accounts receivable turnover (ART), and the inventory turnover...

Accounting