Determine amount of green beans jane should purchase

Assignment Help Supply Chain Management
Reference no: EM131433992

Case study: Reducing cafe costs

A cafe at the university has one special dish it serves like clockwork every Monday at noon. This supposedly tasty dish is a casserole that contains sautéed onions, boiled sliced potatoes, green beans, and cream of mushroom soup. Unfortunately, students fail to see the special quality of this dish, and they loathingly refer to it as the Killer Casserole. The students reluctantly eat the casserole, however, because the cafe provides only a limited selection of dishes for Monday's lunch (namely, the casserole).

Jane Lim, the cafe manager, is looking to cut costs for the coming year, and she believes that one sure way to cut costs is to buy less expensive and perhaps lower quality ingredients. Because the casserole is a weekly staple of the cafe menu, she concludes that if she can cut costs on the ingredients purchased for the casserole, she can significantly reduce overall cafe operating costs. She therefore decides to invest time in determining how to minimise the costs of the casserole while maintaining nutritional and taste requirements.

Jane focuses on reducing the costs of the two main ingredients in the casserole, the potatoes and green beans. These two ingredients are responsible for the greatest costs, nutritional content, and taste of the dish.

Jane buys the potatoes and green beans from a wholesaler each week. Potatoes cost $0.30 per pound (lb), and green beans cost $0.95 per lb.

The university has established nutritional requirements that each main dish of the cafe must meet. Specifically, the dish must contain 160 grams (g) of protein, 65 milligrams (mg) of iron, and 1,000 mg of vitamin C. For simplicity when planning, Jane assumes that only the potatoes and green beans contribute to the nutritional content of the casserole.

Because Jane works at a cutting-edge technological university, she has been exposed to the numerous resources on the Internet. She decides to find the nutritional content of potatoes and green beans. Her research yields the following nutritional information about the two ingredients.

Nutrient

Potatoes

Green Beans

Protein

1.4 g / 100g

5.9 g / 10 oz

Iron

0.255 mg / 100 g

3.56 mg / 10 oz

Vitamin C

11 mg / 100 g

29.75 mg / 10 oz

(There are 28.35 g in one ounce, and 16 ounces in one pound)

Eddy Brooks, the cafe cook who is surprisingly concerned about taste, informs Jane that an edible casserole must contain at least a six-to-five ratio in the weight of potatoes to green beans.

Given the number of students who eat in the cafe, Jane knows that she must purchase enough potatoes and green beans to prepare a minimum of 12 kilograms (kg) of casserole each week. (There are 1,000 g in one kg.) Again, for simplicity in planning, she assumes that only the potatoes and green beans determine the amount of casserole that can be prepared. Jane does not establish an upper limit on the amount of casserole to prepare since she knows all leftovers can be served for many days thereafter or can be used creatively in preparing other dishes.

a. Determine the amount of potatoes and green beans Jane should purchase each week for the casserole to minimise the ingredient costs while meeting nutritional, taste, and demand requirements.

Before she makes her final decision, Jane plans to explore the following questions independently, except where otherwise indicated.

b. Student Union meets during Health Awareness Week and determines that The university's nutritional requirements for iron are too lax and that those for vitamin C are too stringent. The Union urges the university to adopt a policy that requires each serving of an entrée to contain at least 100 mg of iron and at least 500 mg of vitamin C. Using the new nutritional requirements, determine the amount of potatoes and green beans Jane should purchase each week.

c. Jane learns that the wholesaler has a shortage of green beans and is now selling the green beans for a higher price of $1.20 per lb. Using the new price of the green beans, determine the amount of potatoes and green beans Jane should purchase each week.

d. Using the new nutritional requirements in part b and the new price of green beans in part c, determine the amount of potatoes and green beans Jane should purchase each week.

e. Based on part d, which required nutrition would affect the cost if it were to be changed. Why?

Verified Expert

The given case is related to reducing the cafe cost by formulating a linear programming equation and using solver excel tool. The word file provides the facts and the end solution and the excel sheet contains calculations for each part. The quantity of potatoes and green beans (in pounds) have been determined in order to achieve minimum cost and for specifically provided nutritional requirement.

Reference no: EM131433992

Questions Cloud

Write effectively on a topic in medical ethics : Begin by informing yourself about some of the current topics in bioethics and the resources that are available for researching topics in bioethics. There are many resources that explore these issues from the disciplines of medicine, nursing, law, ..
Provide obvious starting point in screens upper left corner : Provide an obvious starting point in the screen's upper left corner. Divide information into units that are logical, meaningful, and sensible.
Credible research is important part : Based on your experiences to finish the question Credible research is an important part of writing academic papers. Reflect on the research that you've done for classes up to this point. For your main post, share your experiences with doing academic ..
Derive the consumer inter-temporal budget constraint : a. Derive the consumer's inter-temporal budget constraint. b. Derive the government's inter-temporal budget constraint.
Determine amount of green beans jane should purchase : Determine the amount of potatoes and green beans Jane should purchase each week for the casserole to minimise the ingredient costs while meeting nutritional, taste, and demand requirements.
Explain the importance of who sent the memo to whom : Nina owns a used car lot. She signs and sends a fax to Seth, a used car wholesaler who has a huge lot of cars in the same city. The fax says, “Confirming our agrmt—I pick any 15 cars fr yr lot—30% below blue book.” Seth reads the fax, laughs, and thr..
Interview a person about a task he performs on his job : Based on the information you learned in Steps 1 and 2 of The Essential Guide to User Interface Design, interview a person about a task he/she performs on his/her job.
Parent refuse to consent to lifesaving procedure : When can a parent refuse to consent to a lifesaving procedure for his or her child? What are the ethical implications? What are the legal implications (when is it reportable)? Do your findings change if it is a senior being cared for by an adult chil..
Contents of the article to concepts : You are to select a recent (three months of age or less) news article and write a post that relates the contents of the article to concepts from Chapter 4 and analyzes the article using an economic perspective

Reviews

inf1433992

3/27/2017 4:35:50 AM

Expertsmind, I simply needed to tell you that I got the paper and think it is exceptionally well done. I truly value your polished skills and ability and, when requesting the rest of the 2/3rds of the paper. Will put down your name on the request since you are as of now very much arranged to compose it. At the end of the day, my much obliged.

len1433992

3/20/2017 6:33:20 AM

I need a Word file to show complete solutions and explain mathematical models and An Excel file to demonstrate how you use Solver to identify the solutions. Before she makes her final decision, Jane plans to explore the following questions independently, except where otherwise indicated.

Write a Review

Supply Chain Management Questions & Answers

  Tremendous market success and redefined their industries

The following products have had tremendous market success and redefined their industries: Tekna's high-tech flashlights, Ingresoll-Rand's ergonomic power tools, Ciba Corning's diagnostic equipment, Oxo's kitchen tolls, Gillete's Sensor razor, and Boe..

  How does ims help coordinate between supply chain partners

Describeinformation management system. How does the IMS help coordinate between supply chain partners?

  How do you effectively conduct strategic sourcing

How do you effectively conduct strategic sourcing? How do you effectively conduct strategic cost management and supply chain analysis?

  About the model formulation

Case Description Gillian’s Restaurant has an ice-cream counter where it sells two main products, ice cream and frozen yogurt, each in a variety of flavors.  Please show your work for “Model Formulation”.  What is the optimal amount, in terms of gallo..

  What challenges is karen likely to encounter

What recommendations do you have with respect to sourcing temporary personnel? Why? What challenges is Karen likely to encounter?

  What are the benefits to each of the players in relationship

Supply base rationalism seeks to reduce the suppliers in which an organization deals directly to a smaller number of strategic suppliers. How does this process work? What are the benefits to each of the players in this relationship?

  Explain the impact those marketing recommendations

The first of the “365” stores is set to open in 2016 in the Silver Lake neighborhood of Los Angeles, named America’s No. 1 hippest hipster neighborhood by Forbes. The area is known for its large arts community, having risen to fame as the location of..

  Draw a map of the supply chain for leapfrog

Draw a map of the supply chain for LeapFrog, including the retailers, Capable Toys, and suppliers of key materials (i.e., Tyvek). Which supply chain partners are upstream of LeapFrog? Which are downstream? Which partners are first-tier suppliers? ..

  Identify logistics management strategies of zara

Identify logistics management strategies that enable Zara to become so successful - How can Zara maintain its competitive advantage, here the concept of sustainability may be introduced?

  Analyze the overall goal of a supply chain

Describe the overall goal of a supply chain. Describe the difference between a supply that is responsive (service) and a supply chain that is efficient. Can a supply chain be both?

  How can technology improve management of global logistics

How can technology improve the management of global logistics? Be specific with examples - How important is intermodal transportation with respect to global logistics?

  West gorham high school is to be located at the population

1.West Gorham High School is to be located at the population center of gravity of three communities:

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