Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Operation Management Expert

The Student Center is preparing a special breakfast to attract veterans to the university. The School's dieticians have decided to serve four items: eggs, toast, sausage, and orange juice (plus coffee). The dieticians have set the minimum vitamin and calorie requirements, and minimum servings sizes, for the breakfast as follows:

Vitamin content per unit (Per Gram):

Vitamin Eggs Toast Sausage Orange Juice Minimum Requirement

A 3 2 1 0 400 Grams

B 2 1 2 0 500 Grams

C 1 0 0 4.5 700 Grams

Total Calories 2 3 3.2 3.6 1000 Calories

Minimum serving Size (Grams)

Eggs Toast Sausage Orange Juice

125 100 70 125

If the unit costs are $0.005 per gram of eggs, $0.003 per gram of of toast, $0.015 per gram of sausage, and $0.01 per gram of orange juice, use excel/solver to find the least-cost (minimal) solution for a breakfst that meets all the requirement for vitamins, calories, and serving sizes. Create a formulation section, data table section, and model section for decision variables, objective function, and LHS and RHS columns of constraints. Find the optimal menu solution with Solver and write a statement about what the total cost, servings sizes, and calorie count will be.

Please inlcude Excel formulas

Operation Management, Management Studies

  • Category:- Operation Management
  • Reference No.:- M92501706

Have any Question?


Related Questions in Operation Management

An end itemrsquos demand forecasts for the next 10 weeks

An end item’s demand forecasts for the next 10 weeks are 30, 20, 35, 50, 25, 25, 0, 40, 0, and 50 units. The current on-hand inventory is 80 units. The order policy is to produce in lots of 100. The booked customer order ...

The use of pay differentials is common in both the private

The use of pay differentials is common in both the private and public sectors. Employers use this extra pay to recognize working on weekends, late at night, in locations with high costs of living, etc. One of the downsid ...

Marketing strategy and marketing plan in this section you

Marketing Strategy and Marketing Plan. In this section you will identify your marketing strategy. Tell how you are going to attract your customers, what marketing media will be used, Use example as social media vs. print ...

1 advertisers use the reach argument to say that on a per

1. Advertisers use the reach argument to say that on a per exposure basis, advertising is very very cost effective. Your professor is in strong disagreement with this statement. Can you tell me why advertising on an expo ...

What is the difference between direct and vicarious

What is the difference between direct and vicarious employer tort liability? What is meant by the “zone of risk” test? Under what circumstances will an employer be liable for intentional torts of the employee? When will ...

Training goal based on enterprise business strategy and

Training Goal: Based on Enterprise business strategy and goals develop several training goals based on your needs assessment and gap analysis. A training goal is a statement about what is to be learned. Think of it as a ...

1 innovative companies like intel nike coca-cola and many

1. Innovative companies like Intel, Nike, Coca-Cola and many more are embracing social media and using it to their advantage. Name some of the different ways social media can be used to enhance a traditional marketing co ...

Anne is employed by cory contracting company cory has a 13

Anne is employed by Cory Contracting Company. Cory has a $1.3 million contract to build a small group of outbuildings in a national park. Anne alleges that Cory Contracting has discriminated against her, in that she has ...

Recall that the security market line sml illustrates the

Recall that the security market line (SML) illustrates the relationship between systematic risk and expected returns. Perhaps the most famous and practical application of the SML is the capital asset pricing model (CAPM) ...

We learned about the leadership practice of encouraging the

We learned about the leadership practice of encouraging the heart. Do encouragement and recognition really matter? Psychodynamic theory proposes that leaders have to understand their own personality traits and those of t ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As