Preview

Est1 Task 4

Good Essays
Open Document
Open Document
1193 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Est1 Task 4
TASK 5

METHOD

Because of the delivery situation outlined in task 4, the manager of the store decided to look to other options to best use the supplies he has been sent. In this task calculations were performed to see which one type of nut mix was the most appropriate to make to use up as many of his nuts as possible.

From Task 4 we know that there are 1360kg of peanuts, 1260kg of cashews and 2000kg of macadamias.

CALCULATIONS

a) Making all Budget Mix

Case 1: We have 1360kg of peanuts, 1260kg of cashews and 2000kg of macadamias and endeavour to use up all 1360kg of peanuts in the order.

Peanuts (60%) Cashews (40%) Macadamias (0%)
If we use all 1360kg of peanuts If 1360kg is 60%, then 100% is 2266kg
2266 x 0.6
=1359kg (round down) 2266kg x 0.4
= 906.4
…show more content…
Peanuts (30%) Cashews (30%) Macadamias (40%)
If we use all 2000kg of macadamias 5000kg x 0.3
= 1500kg 5000kg x 0.3
= 1500kg If 2000kg is 40%, then 5000kg is 100%
5000 x 0.4
=2000kg

This situation cannot be used as there is less than 1500kg of both peanuts and cashews, so all macadamias cannot be used up.

i. If we only make Premium Mix from the nuts received in the order, we can make a maximum of 4200 1kg packets. ii. This situation would leave 100kg of peanuts and 320kg of macadamias left over from the order.

REASONABLENESS AND LIMITATIONS

Making the Premium Mix is the most reasonable thing to do because it involves the least wastage and uses up the least amount of storage space possible.

Some limitations to this scenario include:
- This model assumes all nuts can only be used in these particular mixes and cannot be sold individually or as part of any other nut mixes
- The model assumes all of the nut mix made will in fact be sold; there is a possibility that no one actually buys the Premium Mix and therefore it may be worth making other mixes as they may sell

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Tjs Product Mix

    • 260 Words
    • 2 Pages

    This problem was solved using Excel Solver LP Programming. The decision variables are pounds of each type of Mix. The objective function was a formula of profit contribution for each Mix. The constraints are the nuts purchased the following shipment and the orders that need to be satisfied.…

    • 260 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Mid Term Exams

    • 1230 Words
    • 5 Pages

    | The owner of Chips etc. produces 2 kinds of chips: Lime (L) and Vinegar (V). He has a limited amount of the 3 ingredients used to produce these chips available for his next production run: 4800 ounces of salt, 9600 ounces of flour, and 2000 ounces of herbs. A bag of Lime chips requires 2 ounces of salt, 6 ounces of flour, and 1 ounce of herbs to produce; while a bag of Vinegar chips requires 3 ounces of salt, 8 ounces of flour, and 2 ounces of herbs. Profits for a bag of Lime chips are $0.40, and for a bag of Vinegar chips $0.50. Which of the following is not a feasible production combination?Answer…

    • 1230 Words
    • 5 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Red Canners

    • 550 Words
    • 3 Pages

    Firstly, we will calculate the product mix used to make different type of products in the existing scenario to maximize profit.…

    • 550 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Corey Camel Pow # 12

    • 544 Words
    • 3 Pages

    Process Doing the mini POW helped a lot with this one. Because knowing that Corey Camel can drop bananas on the way to the market is an important part, because of he couldn’t the answer would be an obvious zero. Since you can drop them I decided to drop 800 bananas at the 100 mile point. That way she can eat her 100 bananas that she needs to on her way there and still have another 100 to get back to her banana grove. When she gets there she’ll have 900 new bananas. The only problem is that she can only carry 1,000 bananas at a time. So she takes 1,000 bananas the rest of the way. This would leave her with 100 bananas. Then I realized that wasn’t the largest amount that she could sell. So I started to work backwards from 500 miles. I did this because 500 is half of 1,000. The only problem with 500 is that she would use 500 bananas to get there and wouldn’t be able to drop any bananas because she would have to use the last 500 bananas to get back. So I started to work with 400 miles. When she gets there she has 600 bananas to drop. But she needs 400 of those to go back. So she drops 200 bananas. When she comes back she has an additional 500 bananas. When she picks up the other 200 bananas she has 700 bananas. When she gets to the market she has 300 bananas because she had to eat 400 bananas on the way. I wasn’t sure if that was the largest amount of bananas so I tried the 300 mile point. So she would drop 400 bananas and go back she would come back and get to market with 300 bananas. Then I tried the 200 mile point. She would drop 700 bananas come back and get to market…

    • 544 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    - 250kg of beans  185kg of nibs; This relation can be seen in the…

    • 3275 Words
    • 14 Pages
    Powerful Essays
  • Satisfactory Essays

    Corey s Camels POW

    • 291 Words
    • 2 Pages

    The problem basically is about a camel named Corey that has to carry 3000 bananas to a place 1000 miles away. But, Corey can only carry 1000 bananas and Corey has to eat one banana for every mile she walks/runs/skips/hops, etc. In addition to that, there is a refrigerator at every mile. So the question being asked is how many bananas can Corey get to the market with all these requirements?…

    • 291 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Optimization and Brand

    • 846 Words
    • 4 Pages

    72 units of flavor additive are available so the mathematical equation of constraint 2 is…

    • 846 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    If a all customers order 3 dozen (the maximum the bowl can handle) and they are all the same cookie, such as a sugar cookie,…

    • 967 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    available are at most 3,300, while raw material availability does not exceed 4000. Formulate an LP using…

    • 884 Words
    • 4 Pages
    Powerful Essays
  • Good Essays

    Kristen's Cookie Company

    • 897 Words
    • 4 Pages

    Q4. Discounts can be given to people who order two dozen or more cookies. This is because, Activity 1 (wash bowl, add and mix ingredients) that is performed by Kristen will take only 6 minutes per order for a maximum order size of 3 dozen cookies. So Kristen will spend the same 6 minutes for activity 1 regardless of whether the order quantity is 1,2, or 3 dozens. Similarly, Activity 7 performed by Kristen's roommate will take 1 minute per order regardless of the order size.…

    • 897 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    To enable an explanation of the use of marketing mixes for two segments in the consumer market, it is intended to use a food product which is entering a competitive UK market. In this case, it is intended to concentrate on two diverse products:…

    • 2022 Words
    • 9 Pages
    Powerful Essays
  • Satisfactory Essays

    Linear Programming

    • 663 Words
    • 3 Pages

    TJ's has just purchased the following shipments of nuts at the prices shown: Type of Nut Shipment Cost per Shipments($) Amount(Pounds) Almond 6000 7500 I I Brazil 7500 7125 Filbert 6750 7500 Pecan 6000 7200 7875 Walnut 7500…

    • 663 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Parts Per Million

    • 565 Words
    • 3 Pages

    To scale 100 chocolate bars up to 1 000 000, I'd need to multiply by 10 000. So 3.5 x 10 000 would give 35 000 white chocolate bars out of a million. So 35 000 parts per million.…

    • 565 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Task 4 a) The additional cost for high and medium risk scenarios for Mint Cake project, considering the new scenario in which all the raw materials need are available (i.e. risks R2 and R4 are dismissed) are displayed below (Table 4a, bold blue text). Table 4a – Additional cost in pounds (raw materials available)…

    • 958 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    quant assignment

    • 1146 Words
    • 5 Pages

    Q 1) Determine the amount of potatoes and green beans Maria should purchase each week for the casserole to minimize the ingredient costs while meeting nutritional, taste, and demand requirements. Before she makes her final decision, Maria plans to explore the following questions independently…

    • 1146 Words
    • 5 Pages
    Satisfactory Essays