Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

As shown in the attachment I have part A done. Show full steps to complete the subsequent parts of this problem. Sunblessed Juice Company sells

As shown in the attachment I have part A done. Show full steps to complete the subsequent parts of this problem.

Sunblessed Juice Company sells bags of oranges and cartons of orange juice. Sunblessed grades oranges on a scale of 1 (poor) to 10 (excellent). At present, Sunblessed has 220,000 pounds of grade 6 oranges and 150,000 pounds of grade 9 oranges on hand. The aver- age quality of oranges sold in bags must be at least 7, and the average quality of the oranges used to produce orange juice must be at least 8. Each pound of oranges that is used for juice yields a revenue of $2.25 and in- curs a variable cost (consisting of labor costs, variable overhead costs, inventory costs, and so on) of $1.35. Each pound of oranges sold in bags yields a revenue of $2.00 and incurs a variable cost of $1.20.

a. Determine how Sunblessed can maximize its profit.

b. Use SolverTable to determine how a change in the cost per bag of oranges changes the optimal solution.

c. Use SolverTable to determine how a change in the amount of grade 6 oranges available affects the optimal solution.

d. Use SolverTable to determine how simultaneous changes in the required average quality required for juice and the average quality required for bags change the optimal solution.

image text in transcribed
Formulas Data Review Calibri 29 v 11 ' ' Paste B IU V V A Open recovered workbooks? Your recent changes were saved. Do you want to con H29 x vfx A B. C D E F 1 Selling oranges and orange juice Cartons of oranges Revenue $2.25 Variable cost $1.35 Grade of orange Grade Cartons/Juice Used 6 26666.66667 220000 o 53333.33333 150000 220000 150000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting What the Numbers Mean

Authors: David H. Marshall, Wayne W. McManus, Daniel F. Viele,

9th Edition

978-0-07-76261, 0-07-762611-7, 9780078025297, 978-0073527062

More Books

Students also viewed these Accounting questions

Question

Graph the function y = 2(3 x ) on semilog paper.

Answered: 1 week ago