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 function of flight of his ball draw a graph of

mike was playing golf at hartford golf club. he hit the shot from the 4th tee which was 7 yards above the ground

  How many minutes will it take them to correct 150 quizzes

Working together, how many minutes will it take them to correct 150 quizzes?

  Change in price when the quantity supplied is increased

Use differentials to approximate the change in price when the quantity supplied is increased from 10000 units to 10500.

  How would you find the normal approximation to the binomial

1. if the random variable z is the standard normal score and pz lt a gt 0.5 then a gt 0.nbsp why or why not?2. given a

  Fundamental result of the calculus of variations

Write down the equation of motion for the point particle of mass m moving in the Kepler potential U (x) = -A /x + B /x2 and find extrema of the potential function and their position on the exis ξ. In which cases are the extrema stable and unstable?

  Write a correct statement using two of the numbers

write a correct statement using two of the numbers 0, 0.26, and 4/15 and one of the symbols , or =.

  Hat is seen in the stem and leaf plot for the money variable

Compare the mean for the heights of males and the mean for the heights of females in these data. Compare the values and explain what can be concluded based on the numbers.

  Perform some preliminary calculations

perform some preliminary calculations.

  Major challenges and problems

What major challenges and problems do you face in your company as an operation manager? How do you handle them?

  Find dimensions of enclosure that will minimize total cost

The fourth side will be built of cement blocks, at a cost of 30$ per running foot. Find dimensions of the enclosure that will minimize the total cost of the building material.

  Find the equation for the cubic function

Find the equation for the cubic function, f(x), with roots at 5, 4 and -4, and has a y-intercept at (0,3)

  Deterine wheter outcomes are likely to occur by chance.

Deterine wheter outcomes are likely to occur by chance.

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