Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with parts 3 and 4. See attachments below for template. Sunblessed Juice Company sells bags of oranges and cartons of orange juice.

I need help with parts 3 and 4. See attachments below for template.

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 100,000 pounds of grade 9 oranges and 120,000 pounds of grade 6 oranges on hand. The average 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 $1.50 and incurs a variable cost (consisting of labor costs, variable overhead costs, inventory costs, and so on) of $1.05. Each pound of oranges sold in bags yields a revenue of $1.50 and incurs a variable cost of $0.70.

  1. Determine how Sunblessed can maximize its profit.
  2. Use SolverTable to determine how a change in the cost per bag of oranges changes the optimal solution.
  3. Use SolverTable to determine how a change in the amount of grade 9 oranges available affects the optimal solution.
  4. Use SolverTable to determine how a change in the required average quality required for juice changes the optimal solution.

image text in transcribed
image text in transcribed
3 B 1 Selling oranges and orange juice Part 1 Bags 4 Revenue S Variable cost 6 7 Grade Bags 6193333.333 9 966666667 290000 Tags 8 9 10 11 sold 12 13 14 ST. 16 17 18 19 Actual 20 21 required 22 21 24 cost, revenus, profe 26 Variable cost 37 Revenue 28 * 29 Profa 39 Total profe 33 32 17 33 34 35 36 37 38 39 IN 41 43 43 1 1.01 4.4 1.15 12 3.25 18 NET 14 1.48 2010000 2010000 Bags WAT Jx Profit C Cartons 348000 180000 312000 304000 290000 2.25 1.35 Cartons 2666666667 5333333333 Used 220000 150000 80000 Cartons 7 a Canon 640000 640000 100000 180000 72000 Cartons 0 00 Pra F Specify the flowing information about the input to be varied and the outputs to be captured Input cell: SMS (Optional) Descriptive me for input Bast Values of put E for table Oats on flowin Hann var 1.5 Maximum value benet cas Use the was the following True value range Use the valum belo (pe with light val antro G M K Parameters for oneway table OK Cance Note about specifying t od cels a anges as many of 1: wwww. 300 and the L M O D it n ing vent ad c ilds a cost p Run SolverTable About SolverTable Unload SolverTable for Mac for Mac for Mac 033 x fx A B C D E 1 Oneway analysis for Solver model in P4-50 worksheet 2 Part 2 3 Bag Cost (cell $855) values along side, output cells) along top 4 1 370000 370000 d 370000 351500 333000 80000 290000 BOOOD 290000 80000 290000 318500 304000 80000 290000 289500 80000 290000 275000 80000 290000 260500 B0000 290000 246000 B0000 290000 231500 BODOD 290000 217000 SUTE 8 9 10 11 12 13 14 15 16 17. 18 19 20 23 22 23 24 25 26 21 28 29 10 31 12 3 34 32 1.05 11 1.15 12 1.25 1.3 1.35 14 1.45 $C$11 0 EESOS DESOS F G H 90000 80000 20000 60000 50000 40000 10000 20000 10000 B I La Data for chart 1155 0 0 80000 80000 80000 80000 80000 80000 80000 80000 80000 Sensitivity of $C$11 to Bag Cost 13 LIS 12 125 12 LB ( Share M N When you select an output from the dropdown list in cell the cha will adapt to that output 14 141 L.B Commer A for tem cartons c (exceller id 120,000 n bags mus nge juice m venue of $1. ad costs, in ilds a revenue it. cost per bag c

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_2

Step: 3

blur-text-image_3

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

Financial Accounting Information For Decisions

Authors: Robert w Ingram, Thomas L Albright

6th Edition

9780324313413, 324672705, 324313411, 978-0324672701

More Books

Students also viewed these Accounting questions