Purchase Solution

Hot Dog Mix Planning - Linear Programming

Not what you're looking for?

Ask Custom Question

A meatpacking house is creating a new variety of hot dog for the low-calorie, low-fat, low-cholesterol market. This new hot dog will be made of beef and pork, plus either chicken, turkey, or both. It will be marketed as a 2-ounce all-meat hot dog, with no fillers. Also, it will have no more than 6 grams of fat, no more than 27 grams of cholesterol, and no more than 100 calories. The cost per pound for beef, pork, chicken, and turkey, plus their calorie, fat, and cholesterol counts, are shown in the following table.

Cost/Pound Calories/Pound Fat (G/lb) Cholesterol (G/lb)
Beef $ 0.76 640 32.5 210
Pork $ 0.82 1055 54 205
Chicken $ 0.64 780 25.6 220
Turkey $ 0.58 528 6.4 172

The packer would like each 2-ounce hot dog to be at least 25% beef and at least 25% pork.
Solve the given problem scenario for the meatpacking house by recommending the most economical combination of four meats to make this hot dog. Formulate and set up the problem using the most appropriate technique in Excel Solver.

Attachments
Purchase this Solution
Solution Summary

A meat packing company is introducing an all meat hot dog. It wants to decide mix of the hot dog basis cost, calories, cholesterol, fat etc. The problem has been addressed using linear programming technique and solved using Excel Solver.

Solution Preview

Hello,

I am attaching my response to this posting. I have provided all the required ...

Purchase this Solution
Free BrainMass Quizzes
Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Basics of corporate finance

These questions will test you on your knowledge of finance.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

View More Free Quizzes
Related BrainMass Solutions

  • Using Corner Point Method

    (d) What is the total cost of a package of dog biscuits using the optimal mix? 3. Consider the following linear programming problem: Maximize : 10X + 30Y Subject to : X + 2Y ? 80 8X + 16Y ? 640 4X + 2Y ?

  • Linear Programming Case Study : Julia's Food Booth(V2)

    She measured a hot dog and found it takes up about 16 in2 of space, whereas a barbecue sandwich takes up about 25 in2. She plans to sell a piece of pizza for $1.50 and a hot dog for $1.60 each and a barbecue sandwich for $2.25.

  • linear programming model

    Formulate and solve a linear programming model for this case.

  • Formulate a linear programming model for Julia

    Solve the linear programming model using a computer for Julia that will help you advise her if she should lease the booth. In this solution, determine the number of pizza slices, hot dogs and barbecue sandwiches she should sell at each game.

  • Linear programming problems with sensitivity analysis

    She estimates it will cost her $0.45 for each hot dog and $0.90 for each BBQ sandwich if she makes the BBQ herself the night before. She measured a hot dog and found it took up 16 inches (squared).

  • Linear programming

    Relevance of linear programming to the decision makers who are primarily concerned with marketing or finance or production : Product mix and Production planning: Finding the minimum cost production schedule.

  • Linear programming models

    Relevance of linear programming to the decision makers who are primarily concerned with marketing or finance or production : Product mix and Production planning: Finding the minimum cost production schedule.

  • Linear Prodcution Possibilities Frontier

    Improved technology brings about an increase in productivity; one worker to produce a hot dog in one day, rather than two. Consumption also increases to 40m hot dogs and buns each day.

  • Linear Programming : Objective Function and Optimal Solution

    a) Formulate a linear programming solution to be used to determine what the composition of the dog food should be to meet the various requirements at the minimum cost.

View More Related Solutions