Formulate a linear programming model to maximize profit

Assignment Help Operation Management

Reference no: EM13994078

A small candy shop is preparing for the holiday season. The owner must decide how many bags of deluxe and how many bags of standard mix of Peanut/Raisin Delight to put up. The deluxe mix has 2/3 pound raisins and 1/3 pound peanuts, and the standard mix has 1/2 pound raisin and 1/2 pound peanuts per bag. The shop has 90 pounds of raisin and 60 pounds of peanuts to work with. Peanuts cost $0.60 per pound and raisins cost $1.5 per pound. The deluxe mix will sell for $2.90 per pound and the standard will sell for $2.25 per pound. The owner estimates that no more than 110 bags of one type can be sold.

a. Formulate a linear programming model to maximize profit.

b. Solve the model using Excel Solver.

Reference no: EM13994078

Questions Cloud

Race differences in police searches : Read and review the posted article and analysis the article. Article: Rosenfeld, Richard et. al. (2012). Age Matters: Race Differences in Police Searches of Young and Older Male Drivers. Journal of Research in Crime and Delinquency 49(1) pgs 31-55

Discuss effect on state regulations if federal government : Environmental law is both federal and state-controlled. Discuss the effect on state regulations if the federal government, through the Environmental Protection Agency, changes the standards for air pollution and carbon dioxide emissions. Analyze and ..

Connections between business-law-politics and ethics : Should we have an international code of ethics? Explain why or why not. Analyze and evaluate the various issues presented while arguing and debating the connections between business, law, politics, and ethics.

Deck and accidentally knocked over a pot of flowers : You were power-washing your deck and accidentally knocked over a pot of flowers. The flowerpot is cubic in shape, each side 30 cm in length. The outlet of the power-washer is 20 mm in diameter, and according the manual, the water exits at a velocit..

Formulate a linear programming model to maximize profit : A small candy shop is preparing for the holiday season. The owner must decide how many bags of deluxe and how many bags of standard mix of Peanut/Raisin Delight to put up. The deluxe mix has 2/3 pound raisins and 1/3 pound peanuts, and the standard m..

The owners of a house on a private lake : The owners of a house on a private lake are thinking of using "pumped storage" as a means of reducing their electricity bills. They will pump water from the lake up to a large reservoir overnight, and then during times of peak power prices, release t..

Creating a job description and for efficiency-safety : What one or two job analysis approaches would you recommend on the basis of relevance or providing the best quality information for creating a job description? For efficiency/safety? For training? Why do you think your chosen approaches are best?

Manufacturing shop is designed to operate most efficiently : A manufacturing shop is designed to operate most efficiently at an output of 1,130 units per day. In the past month the plant produced 940 units. What was their capacity utilization rate last month?

What is the potential difference of battery : Three capacitors are shown in the figure. C1=8μF, C2=4μF, C3=2μF. The capacitor network is connected to an applied potential difference V. After the charges on the capacitors have reached their final values, the charge on capacity C2 is 480μF. Wha..

User Account

All Pages