A beverage cans manufacturer makes 3 types

ByPlatinum Essays

A beverage cans manufacturer makes 3 types of soft drink cans needed for the beverage producers to fill soft drinks of three different volumes. The maximum availability of the machines’ time allotted per day is 90 hours and the supply of metal is limited to 120 kg per day. The following table provides the details of the input needed to manufacture one batch of 100 cans.CansLargeMediumSmallMaximumMetal (kg)/batch965120Machines’ Time (hr)/batch4.44.2490Profit/batch$50$45$42Let L = number of Large cans produced M = number of Medium cans produced S = number of Small cans producedFormulate and solve for the recommended production quantities for all the three different types cans by maximizing the profit. Use Excel solver to find your answers. Report the optimal value of LBased on question 1, use Excel Solver to find the optimal solution and report the value of M.Based on question 1, use Excel Solver to find the optimal solution and report the value of SBased on question 1, use Excel Solver to find the optimal solution and report the optimal value of the objective function.Based on question 1, write down the objective fuction.

Order a similar assignment, and have writers from our team of experts write it for you, guaranteeing you an A

Order Solution Now

Similar Posts

After the Civil War and by the mid-20th century

ByPlatinum Essays

After the Civil War and by the mid-20th century, the United States had become the dominant force in international relations. Some have argued that the United States’ military functions as the world’s “police.” This assignment covers the manner in which this shift occurred and the consequences the United States faces as a result of its…

The Social Responsibility of Business

ByPlatinum Essays

In “The Social Responsibility of Business Is to Increase its Profits,” what economic idea is the author alluding to by stating that the social responsibility of business is to increase profits? Explain. What does Friedman mean when he equates social responsibility to “taxation without representation?” Friedman states that the principle underlying the market mechanism is…

Embry MBAA518 All Discussions Latest 2016 November

ByPlatinum Essays

Embry MBAA518 Module 1.7 Discussion Latest 2016 November1.7 – Discussion2121 unread replies.4141 replies.You have seen the word greed come up in the videos. You have seen Gordon Gekko explain the benefits of greed and Milton Friedman as well. Friedman makes you think about greed in ways you probably have not. Greed seems to come with…

The value of each Latin American currency relative

ByPlatinum Essays

The value of each Latin American currency relative to the dollar is dictated by supply and demand conditions between that currency and the dollar. The values of Latin American currencies have generally declined substantially against the dollar over time. Most of these countries have high inflation rates and high interest rates. The data on inflation…