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

  Epending on type of it investment under consideration

Do you agree with the notion that IT investments can be treated in the same manner as financialinvestments, and similarly quantified by putting a dollar value to them? Why or why not? Would youranswer change depending on the type of IT investment und..

  What are solution or way for economy to get out of recession

What are some solutions or ways for an economy to get out of a Recession or slow things down if we're growing to fast? Give some examples of items that you normally purchase and have noticed a definite increase or decrease in its price.

  What analysis should the manufacturer decide

A more reliable trucking firm promises delivery exactly in six days, but for a 5 % higher cost. What analysis should the manufacturer decide whether or not to switch?

  How information technology in the supply network

Critically evaluate point and provide various examples from the academic literature to underpin your arguments - case study for a critical review of how information technology in the Supply Network can help the Logistics and Operations Manager achi..

  Describe the parts of the dell supply chain

Describe the parts of the Dell supply chain, if any, that are push and pull.  If both exist, what would be characteristics in the real process that would let you identify the boundary between the two?

  What could be gained by stapling yourself to an order

How has transportation cost as a percentage of total logistics cost tracked since 1980, when transportation was deregulated? How do you explain this trend?

  Supply chain analysis for your proposed new division

Create a SWOTT table  - Your environmental analysis should consider, at a minimum, the following factors. For each factor, identify the one primary strength, weakness, opportunity, threat, and trend

  Conduct the simulation analysis

BST333 Logistics Modelling - Conduct the simulation analysis again based on the extended model and Does the removal of assumptions change and design the method of analysis and presentation of results. Again, numerical results and graphics (if desig..

  What is the current annual supply chain cost

What is the current annual supply chain cost? Do you recommend adding any plant(s)? If so, where should the new plan(s) be built?

  Critical reflection on your experience

What major learning on managing the value chain can apply in practice as a manager in your organisation - view of managing the value chain before entering this subject and how this has, or hasn't changed.

  Describe implications of poor forecasting on supply chain

Briefly describe the implications of poor forecasting on a supply chain. In other words, what are some of the bad things that can happen as a result of inaccurate demand forecasts?

  Research paper on supply chain design

Detailed Question: 15 page research paper on "Supply Chain Design" please inckude methodologies, analysis, and citations in MLA formate

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