; juice
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

juice

VIEWS: 4 PAGES: 9

  • pg 1
									              21d8cd8b-f9aa-4eef-a0c6-bd18329b975b.xls




              A                       B                  C   D
1    Groovy Juice Mixers, Inc.
2
3        Minimum %                     Grape Guava Papaya
4        Tropical Breeze                 0%   20%    20%
5            Guava Jive                  0%   40%     0%
6
7        Maximum %                     Grape Guava Papaya
8        Tropical Breeze               100%   25%    25%
9            Guava Jive                100%   50%     5%
10
11                                     Grape Guava Papaya
12     Available Gallons                1000   400    300




                               DATA
21d8cd8b-f9aa-4eef-a0c6-bd18329b975b.xls




            E             F
     1
     2             Revenue
     3            per Gallon
     4            $    1.30
     5            $    1.50
     6
     7
     8
     9
     10
     11
     12




                 DATA
              21d8cd8b-f9aa-4eef-a0c6-bd18329b975b.xls




              A                       B                  C   D
1    Groovy Juice Mixers, Inc.
2
3        Minimum %                     Grape Guava Papaya
4        Tropical Breeze                 0%   20%    20%
5            Guava Jive                  0%   40%     0%
6
7        Maximum %                     Grape Guava Papaya
8        Tropical Breeze               100%   25%    25%
9            Guava Jive                100%   50%     5%
10
11                                     Grape Guava Papaya
12     Available Gallons                1000   400    300
13
14          Mix                        Grape Guava Papaya
15       Tropical Breeze                 820   280    300
16           Guava Jive                  180   120 9E-12




                            VARIABLES
21d8cd8b-f9aa-4eef-a0c6-bd18329b975b.xls




            E               F
     1
     2              Revenue
     3             per Gallon
     4             $    1.30
     5             $    1.50
     6
     7
     8
     9
     10
     11
     12
     13
     14
     15
     16




                VARIABLES
              21d8cd8b-f9aa-4eef-a0c6-bd18329b975b.xls



              A                       B                  C   D
1    Groovy Juice Mixers, Inc.
2
3        Minimum %                     Grape Guava Papaya
4        Tropical Breeze                 0%   20%    20%
5            Guava Jive                  0%   40%     0%
6
7        Maximum %                     Grape Guava Papaya
8        Tropical Breeze               100%   25%    25%
9            Guava Jive                100%   50%     5%
10
11                                     Grape Guava Papaya
12     Available Gallons                1000   400    300
13
14          Mix                        Grape Guava Papaya
15       Tropical Breeze                 820   280    300
16           Guava Jive                  180   120 9E-12
17                 Total                1000   400    300
18
19   Minimum Amounts                   Grape Guava Papaya
20      Tropical Breeze                    0   280    280
21          Guava Jive                     0   120      0
22
23   Maximum Amounts                   Grape Guava Papaya
24      Tropical Breeze                 1400   350    350
25          Guava Jive                   300   150     15
26
27                Revenue $ 2,270.00

                          CALCULATIONS
21d8cd8b-f9aa-4eef-a0c6-bd18329b975b.xls



            E             F
     1
     2             Revenue
     3            per Gallon
     4            $    1.30
     5            $    1.50
     6
     7
     8
     9
     10
     11
     12
     13
     14   Total
     15   1400
     16    300
     17
     18
     19
     20
     21
     22
     23
     24
     25
     26
     27



            CALCULATIONS
              21d8cd8b-f9aa-4eef-a0c6-bd18329b975b.xls



              A                       B                  C   D
1    Groovy Juice Mixers, Inc.
2
3        Minimum %                     Grape Guava Papaya
4        Tropical Breeze                 0%   20%    20%
5            Guava Jive                  0%   40%     0%
6
7        Maximum %                     Grape Guava Papaya
8        Tropical Breeze               100%   25%    25%
9            Guava Jive                100%   50%     5%
10
11                                     Grape Guava Papaya
12     Available Gallons                1000   400    300
13
14          Mix                        Grape Guava Papaya
15       Tropical Breeze                 820   280    300
16           Guava Jive                  180   120 9E-12
17                 Total                1000   400    300
18
19   Minimum Amounts                   Grape Guava Papaya
20      Tropical Breeze                    0   280    280
21          Guava Jive                     0   120      0
22
23   Maximum Amounts                   Grape Guava Papaya
24      Tropical Breeze                 1400   350    350
25          Guava Jive                   300   150     15
26
27                Revenue $ 2,270.00

                            SOLUTION
21d8cd8b-f9aa-4eef-a0c6-bd18329b975b.xls



            E              F
     1
     2              Revenue
     3             per Gallon
     4             $    1.30
     5             $    1.50
     6
     7
     8
     9
     10
     11
     12
     13
     14   Total
     15   1400
     16    300
     17
     18
     19
     20
     21
     22
     23
     24
     25
     26
     27



                SOLUTION
                                                21d8cd8b-f9aa-4eef-a0c6-bd18329b975b.xls



               A                            B                             C                  D               E                 F
1    Groovy Juice Mixers, Inc.
2                                                                                                                           Revenue
3         Minimum %                                     Grape                 Guava          Papaya                        per Gallon
4          Tropical Breeze 0                                     0.2                  0.2                                  1.3
5              Guava Jive 0                                      0.4                  0                                    1.5
6
7         Maximum %                                     Grape                 Guava          Papaya
8          Tropical Breeze 1                                     0.25                 0.25            Decision Variables
9              Guava Jive 1                                      0.5                  0.05                          >= 0
10                                                                                                          >= B20:D21
11                                                      Grape                 Guava          Papaya         <= B24:D25
12        Available Gallons 1000                                 400                  300
13
14            Mix                                       Grape        Guava        Papaya             Total
15          Tropical Breeze 834.999999962727                               285.00000003731
                                                              280.000000000026           =SUM(B15:D15)
16              Guava Jive 165.000000037267                                15.0000000005646
                                                              119.999999999974           =SUM(B16:D16)
17                    Total =SUM(B15:B16)                     =SUM(C15:C16)=SUM(D15:D16)
18                                                                                             Constrained
19     Minimum Amounts                                  Grape        Guava        Papaya       <= B12:D12
20          Tropical Breeze =B4*$E15                          =C4*$E15     =D4*$E15
21              Guava Jive =B5*$E16                           =C5*$E16     =D5*$E16
22
23    Maximum Amounts                                   Grape           Guava       Papaya
24        Tropical Breeze =B8*$E15                               =C8*$E15     =D8*$E15
25            Guava Jive =B9*$E16                                =C9*$E16     =D9*$E16
26
27                 Revenue =SUMPRODUCT(E15:E16,F4:F5)
28
29
30                                 Objective, Maximize


                                                              FORMULAS

								
To top