Special type of soda consists of regular and diet soda

Assignment Help Financial Management

Reference no: EM131985323

The Bubbly Soda (BS) Company produces popular sodas. A special type of soda consists of regular and diet soda. The company has received an order for a minimum of 400.00 litres of the special type. The customer specified that the order must contain at least 40% of regular soda and not more than 250,000 litres of diet soda. The customer also specified that the blend should be mixed in the ratio of 2 parts regular to 1 part diet. The BS Company can produce 500,000 litres per week, regardless of the blend. The production manager wants to complete the order in 1 week. The blend is sold for $12 per litre. The BS company's cost per litre is $4 and $2 for diet. The company wants to determine the blend mix that will meet customer requirements and maximize profits.

a) Formulate algebraically a linear programming model for this problem.

b) Solve this problem using excel (please post a screenshot when using solver)

Reference no: EM131985323

Questions Cloud

What is the maximum price per share that an investor : What is the maximum price per share that an investor who requires a return of 15?% should pay for Home Place Hotels common? stock?

What is the npv of the next five years of cash flows i : What is the NPV of the next five years of cash flows if Darren had four new pumps installed?

What principal is owed immediately the sixth payment : How much principal is in the 6th payment? What principal is owed immediately following the 6th payment?

How much of the second payment goes to pay principal : How much are the annual payments? How much of the second payment goes to pay principal?

Special type of soda consists of regular and diet soda : The Bubbly Soda (BS) Company produces popular sodas. A special type of soda consists of regular and diet soda.

Deciding on refinancing changing interest rates : Deciding on Refinancing Changing interest rates create opportunities for home owners to gain advantage by refinancing their homes.

What coupon rate should the company set on its new bonds : What coupon rate should the company set on its new bonds if it wants them to sell at par?

What is the current yield on bonds : One More Time Software has 6.6 percent coupon bonds on the market with 20 years to maturity. What is the current yield on the bonds?

Distinguish among the three levels of market efficiency : Explain the Efficient Markets Hypothesis (EMH). Distinguish among the three levels of market efficiency.

User Account

All Pages