Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. requesting help with understanding how to input th

Requesting help with understanding how to input the given data in the attached screenshot into...

70.2K

Verified Solution

Question

Accounting

Requesting help with understanding how to input the given data in the attached screenshot into a solver parameter.

imageimage
Planters Nut Company is planning to launch a new 32-ounce can of mixed nuts. The product will be a mix of Cashews, Almonds, Walnuts, Pecans, Brazil Nuts, Macadamia Nuts, Peanuts and Pistachios. The specific mix of these varieties will depend on several factors: The amount of fat per serving should not exceed 33.50 grams - each serving size is 2 ounces. There must be at least 2 ounces and no more than 7 ounces of each nut in the mix. Given the following cost and fat per ounce for each variety, how many ounces of each nut should be used in the new 32-ounce can to minimize the total cost of each can? Nut Type Cost Per oz. ($) | Fat Per oz. (g) Cashews $0.45 13 Almonds $0.30 15 Walnuts $0.35 18 Pecans $0.15 20 Brazil Nuts $0.30 19 Macademia Nuts $0.55 22 Peanut $0.15 14 Pistachios $0.60 13Nut Type Cost Per oz. ($) Fat Per oz. (9) Cashews $0.45 13 Almonds $0.30 15 Walnuts $0.35 18 Pecans $0.15 20 Brazil Nuts $0.30 19 Macademia Nuts $0.55 22 Peanut $0.15 14 Pistachios $0.60 13

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