How many pounds of each ingredient should be purchased

Assignment Help Mathematics
Reference no: EM131159860

Question 1:

Snoo Coffee Company creates three blends of coffee: budget, classic, and premium. The coffee blends are composed of four ingredients: A, B, C, and D. The table below shows the percentage of each component that are in each blend and the cost per pound for that ingredient. The blends have a wholesale price of $2.50, $3.00, and $4.50 for budget, classic, and premium, respectively. A limited amount of each ingredient is available on a weekly basis.

Ingredient

Budget

Classic

Premium

Cost/lb.

Max Weekly Availability

A

25%

35%

0%

$0.60

40,000

B

55%

25%

0%

$0.80

20,000

C

5%

10%

50%

$0.95

35,000

D

15%

30%

50%

$0.70

45,000

Snoo can make 100,000 pounds of coffee per week, and it wants to make a minimum of 25,000 pounds of each blend.

1. In order to maximize weekly profits, how many pounds of each ingredient should be purchased?

2. What is the shadow price of ingredient C?

3. How much should Snoo be willing to pay for an additional pound of ingredient C to raise total profit?

Question2:

The AppleBerry Company makes a mix of three types of electronic devices: MP3 players, eReaders, and tablet computers. The company is trying to determine which products to make to optimize its profits. Each product requires a specific number of hours in fabrication, assembly, and machining. In addition, to save on expenses, all the devices have been engineered to use the same basic raw materials. The table below details the hours and costs involved, as well as the profit per device. AppleBerry has a total of 2000 hours of fabrication, 3200 hours of assembly, and 1600 hours of machining currently available per month. It also has budgeted to purchase $9200 of raw materials each month.

Device

Fabrication Hours Required

Assembly Hours Required

Machining Hours Required

$ of raw Materials Needed

Profit per Device

MP3 Player

6

6

9

$30

$16

eReader

6

8

6

$40

$20

Tablet

2

12

8

$25

$14

Answer the following questions:

1. Given the current situation, what product mix should AppleBerry use to maximize its monthly profits? What is the optimized monthly profit? Set this up as a spreadsheet using Solver.

2. If AppleBerry chooses to commit more resources to increase profits, should it purchase more fabrication time, assembly time, machining time, or raw materials?

Must use Excel Solver to generate report.

Verified Expert

The paper is about the details of Linear Programming. It talks about the method of calculation of optimal portfolio for both the questions and calculates the reduced cost. The paper has been prepared using Microsoft Excel.

Reference no: EM131159860

Questions Cloud

Actions by the federal reserve : The percentage of deposits which banks must keep in their vault to meet the withdrawal needs of depositors has increased. Which of the following actions by the Federal Reserve could have caused this change?
Write academic paper with headings : Write an academic paper, with headings, citation and correct grammar. - Either find a case or the legislative history to the Code Section and write about it.
Quantity of real gdp demanded : Discuss the difference between an increase in the aggregate demand curve and an increase in the quantity of real GDP demanded. Include discussion of how the price level relates to each event.
Calculate the national bank of the undemocratic republic : Banks can create money through lending from excess reserves. The National Bank of the Undemocratic Republic of Swagnervania receives $1.5 million. The Federal Reserve of the Undemocratic Republic of Swagnervania stipulates all commercial banks use a ..
How many pounds of each ingredient should be purchased : In order to maximize weekly profits, how many pounds of each ingredient should be purchased - What is the shadow price of ingredient C?
Find the p-value for the indicated hypothesis test : Find the P-value for the indicated hypothesis test. Find the number of successes x suggested by the given statement. Find the critical value or values of CritVALX2 based on the given information.
Supply and demand for productive good and services : Economic theory explains that markets generate wealth for individuals through the supply and demand for productive good/services. Does this help explain why you(studnet) are obtaining a college education?
Guaranteed fundamental rights : In the US, Americans are guaranteed fundamental rights to their freedom and privacy of information under which of the following?
Good deal for each type of consumer : i)  Show that this insurance is a good deal for each type of consumer ii)  Show that the insurance company makes money on average with each type of consumer.

Reviews

Write a Review

Mathematics Questions & Answers

  Find the dimensions of the can which minimize the amount

A soda can is to hold 12 fluid ounces. Suppose that the bottom and the top are twice as thick as the sides. Find the dimensions of the can which minimize the amount of material used.

  How many ounces of pure zinc must be alloyed

How many ounces of pure zinc must be alloyed with 25 ounces of brass that is 30% zinc and 70% copper to produce brass that is 55% zinc?

  How many balloons of each color did marty inflate

1147 total balloons. There were 255 more white balloons than red ones. There were 116 fewer blue balloons than white. How many balloons of each color did Marty inflate?

  Determine convergent or divergence

Determine convergent or divergence. SUM from n=0 to infinity for

  Find a polynomial whose roots are the squares of the roots

Consider the quadratic polynomial, Q(x) = x2 + ax + b. Find a polynomial whose roots are the squares of the roots of Q(x). Consider the cubic polynomial, C(x) = x3 + ax2 + bx + c. Find a polynomial whose roots are the cubes of the roots of C(x)

  What was the original price of the painting

libay sold a painting for php 3125 if she earned php 5000 profit,what was the original price of the painting ?

  Fundamental groups of moebius strip and cylinder

If G acts on X, pi1(X) = {e}, and for all x elements of X there exists Ux neighborhood of X such that Ux intersection g(Ux) = empty set for all g elements of G{e}, then pi1(XG) is homeomorphic to G.

  Using the telephone numbers listed in your local directory

using the telephone numbers listed in your local directory as your population randomly obtain 20 samples of size 3.

  The temperature 100 ft below sea level is 36°f.

The temperature 100 ft below sea level is 36°F. The temperature at sea level is 56°F.

  Banking circular motion with friction

On a level track the car can just go round a bend (radius=80m) at 20ms^-1. At what angle must the tracked be banked so a speed of 30ms^-1 is reached (coefficient of friction being the same)?

  Find the least squares approximation

Find the least squares approximation of e^x over the interval [0,1] by a polynomial of the form ao+a1x. Find the mean square error of the approximation.

  Calculate the area of idaho

Idaho is shaped like a triangle with a base of approximately 320 miles and a height of approximately 520 miles. Calculate the area of Idaho and write the answer in scientific notation.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd