Holiday Fruit Company buys oranges and processes

Question # 00441281 Posted By: rey_writer Updated on: 12/11/2016 11:41 PM Due on: 12/12/2016
Subject Statistics Topic General Statistics Tutorials:
Question
Dot Image
Holiday Fruit Company buys oranges and processes them into gift fruit baskets and fresh juice. The company grades the fruit it buys on a scale from 1 (lowest quality) to 5 (highest quality). The following summarizes Holiday's current inventory of fruit:

Grade12345
Supply (1000s of lbs)9022530010075

Each pound of oranges devoted to fruit baskets results in a marginal profit of $2.50, whereas each pound of devoted to fresh juice results in marginal profit of $1.75. Holiday wants the fruit in its baskets to have an average quality grade of at least 3.75 and its fresh juice to have an average quality grade of at least 2.50.

a) Formulate an optimization model for this problem.

b) Implement your model in a spreadsheet and solve it.

c) What is the optimal solution?

Dot Image
Tutorials for this Question
  1. Tutorial # 00436998 Posted By: rey_writer Posted on: 12/11/2016 11:42 PM
    Puchased By: 2
    Tutorial Preview
    The solution of Holiday Fruit Company buys oranges and processes...
    Attachments
    Holiday_Fruit_Company_buys_oranges_and_processes.ZIP (18.96 KB)

Great! We have found the solution of this question!

Whatsapp Lisa