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..

Reviews

Write a Review

Operation Management Questions & Answers

  How is the data collected and analyzed

Does your company collect any quality-related data? How is the data collected and analyzed? If no quality data is being collected, can you make a recommendation on what type of data is important to collect and how it may help your organization in ..

  Why is staff scheduling in a service environment

Why is staff scheduling in a service environment a difficult task? What can managers do to ensure that staff schedules are effective and efficient?

  Descriptive statistic and other using inferential method

Find two articles in which one in which the business problems are researched using a descriptive statistic and the other using an inferential method.

  Natural pipelines represent an important national asset

Although most people do not think about it, our networks of oil and natural pipelines represent an important national asset. As such, they are also vulnerable to threats from natural and man-made causes. Based on what you are able to find from reliab..

  What is the efficiency rating of the current operation

What is the efficiency rating of the current operation? If the company decides to use only one container, how many parts must it hold?

  Little sense of urgency about using up so many peoples time

My overall project leader, my boss, is a blowhard. In our team meeting, he wastes all kinds of time talking about things no one cares about (war stories, pet peeves, bad jokes, etc.). He seems to believe that has entertaining, but few others share th..

  Great uncertainty or little precedent for a decision

The use of _____ is important when there is great uncertainty or little precedent for a decision

  Graph the three total cost lines on the same chart

1) Graph the three total cost lines on the same chart. 2)Which alternative should Ski Boards, Inc., choos if it thinks it can sell more than 3000 boards 3) which alternative should the firm use if it thinks the market for boards will be between 10..

  From the e-activity-microsystem-mesosystem-exosystem

From the e-Activity, describe one (1) situation in your life from the past several years that required adjustment according to the Ecological theory. Discuss one to two (1-2) examples from your situation that apply to each of Bronfenbrenner’s five (5..

  An analyst is assessing two time-series forecasting methods

an analyst is evaluating two time-series forecasting techniques. using data from the past she notes that technique b

  My poem analysis needs edited to sound better

My poem analysis needs edited to sound better: The paradoxes in the poem’s first sestet reveal the difficulty of concealing her feelings to appear strong. Elizabeth emphasized this obstacle using contradictory statements: “I love, and yet am forced t..

  Opened checking account

Susan Williams opened a checking account at the First National Bank. She made an initial deposit of $1,800, signed a signature card that indicated to the bank that she was the authorized signator on the account, and was given a supply of blank checks..

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