## [answered] Model A B C Excel Challenge.xlsx 2 CGS 2100 Sovler Exercise

In this Exercise you will determine the number of cartons of oranges and strawberries that should be loaded on three trucks to earn maximum revenue. ?Use the following files.

Model A B C Excel Challenge.xlsx

2 CGS 2100 Sovler Exercise D E F G Tampa Produce Logistics Problem 1

3

4

5 Selling Price (\$/carton) Oranges

20 Strawberries

32 Oranges

5

4

3 Strawberries

10

12

11 6 Spoilage %

Truck 1

9 Truck 2

10 Truck 3

7

8 11 Spoilage-Adjustment Price (\$/carton) Oranges

Truck 1

14 Truck 2

15 Truck 3 Strawberries 12

13 ?

?

? ?

?

? Total Revenue

Use SumProduct Function 16 Carton Assignments

Truck 1

19 Truck 2

20 Truck 3

21 Total

17 Oranges = 22

23 Available Strawberries

1200

1200

1200

Sum

=

3900

3600

1300

1300

1300

Sum 18 Page 1 Total

&lt;==SUM

&lt;==SUM

&lt;==SUM &lt;=

&lt;=

&lt;= Capacity

Capacity Tons X 100

Capacity Tons X 100

Capacity Tons X 100

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Sep 18, 2020

Solution~0001013951.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Sep 18, 2020

EXPERT

Tutor