Determine the optimal product mix for a package

Assignment Help Computer Engineering

Reference no: EM132155923

USE EXCEL SOLVER

Doug Turner Food Processors wishes to introduce a new brand of dog biscuits composed of chicken and liver flavored biscuits that meet certain nutritional requirements.

The liver flavored biscuits contain 1 unit of nutrient A and 2 units of nutrient B; the chicken flavored biscuits contain 1 unit of nutrient

A and 4 units of nutrients B. According to federal requirements, there must be at least 40 units of nutrient

A and 60 units of nutrient B in a package of the new mix. In addition, the company has decided that there can be no more than 14 liver flavored biscuits in a package.

It costs $.01 to make 2 liver flavored biscuit and $.02 to make 1 chicken flavored. Doug wants to determine the optimal product mix for a package of the biscuits to minimize the firm's cost.

The aim of the objective function should be to [maximize/minimize?] the objective value.

The optimum solution is:

Number of liver flavored biscuits in a package = ?

Number of chicken flavored biscuits in a package = ?

Optimal solution value = ?

USE EXCEL SOLVER

Reference no: EM132155923

Questions Cloud

Could colonial adventure tours upgrade to the dbms : Use computer magazines and/or the internet to investigate one of these DBMSs: DB2, SQL Server, MySQL, Oracle, or Sybase.

Create a student class to hold student data : Create a Student class to hold student data. In previous exercises, we had a requirement that you name your class Main.

Repeated measures or matched pairs : State the degrees of freedom and the type of test (repeated measures or matched pairs) for the following examples of measures for a related samples t test:

Confidence interval for the population proportion : In a survey of 3135 adults, 1438 say they have started paying bills online in the last year.

Determine the optimal product mix for a package : The liver flavored biscuits contain 1 unit of nutrient A and 2 units of nutrient B; the chicken flavored biscuits contain 1 unit of nutrient

Mean residual life of a continuous survival time : Suppose that the mean residual life of a continuous survival time X is given by MRL(x) = x + 10.

Why do you think telnet is not installed by default : You can use either the ssh program or the telnet program to connect to other computers; however, telnet is not installed by default.

What is the mean of the sampling distribution : A population is normally distributed with a mean of -30 and a standard deviation of 5.

What will be toms expected profit from selling cookies : Suppose that Tom buys 220 cookies each morning. Use Analytic Solver Platform to perform 5,000 trials of a Monte Carlo simulation on a spreadsheet.

User Account

All Pages