Create the solver model for problem

Assignment Help Operation Management

Reference no: EM131272105

Windy City Cheese Company produces two cheese spreads by blending Mild Cheddar Cheese and Spicy Cheddar Cheese. The cheese spreads are packaged in 9-ounce containers and sold to distributors throughout the Midwest. The Regular blend contains 80% Mild and 20% Spicy. The Smoking Hot blend contains 20% Mild and 80% Spicy. A dairy cooperative across the border in Wisconsin can provide up to 5000 pounds of Mild Cheddar Cheese for $1.20 per pound and up to 4000 pounds of Spicy Cheddar Cheese for $1.75 per pound. The cost to blend and package the cheese spreads (excluding the cost of the cheese) is $0.25 per container. Each Regular container is sold for $3.75. Each Smoking Hot container is sold for $4.25 per container.

Formulate the linear programming model within your Word Report: Define the decision variables, the objective function, and the constraints. You should show any extra work required for constraints and the net profit per unit for each blend in your Excel spreadsheet.

Create the Solver model for this problem. Run the model. Select the Sensitivity Report also. Submit the Excel spreadsheet with your Solver model and Sensitivity Report to the dropbox. How many of each blend should Windy City Cheese produce next period? What is the estimated profit for next period? Show your answers in your Word document.

Copy the Sensitivity Report into your Word document. Analyze the change below by referring back to your original model.

Using the Sensitivity Report only, what happens to Net Profit if the dairy cooperative can provide a maximum of 2,950 pounds of Spicy Cheddar Cheese next period? Show your calculations in both the Word document and the Excel file.

Reference no: EM131272105

Questions Cloud

Stakeholder when conducting the value chain analysis : Who is the important stakeholder when conducting the value chain analysis? What are the importance of sustainability for corporation? How much does the forecasting process at Deckers correspond with the typical forecasting process described at the en..

Use of electronic information systems : You are the director of health information services for a community mental health center that is planning to expand its use of electronic information systems. You have been asked to serve on the steering committee that will be guiding this initiative..

Prepare the property-plant and equipment section : Moen owns two tracts of land. The first, which cost $18,000, is being held as a future building site. It has a current market value of $20,000. The second, which cost $19,000, was purchased 10 years ago. The current office and factory buildings are o..

Communication plan should also contain elements : Sarah has been with GHG Corporation for about a mo... Sarah has been with GHG Corporation for about a month. As part of her initial month with the firm, she has witnesses some bad practices within the projects that are currently underway. The communi..

Create the solver model for problem : Windy City Cheese Company produces two cheese spreads by blending Mild Cheddar Cheese and Spicy Cheddar Cheese. The cheese spreads are packaged in 9-ounce containers and sold to distributors throughout the Midwest. The Regular blend contains 80% Mild..

Does the writing satisfy the ucc statute of frauds : Sam entered into a contract with Ben for the sale of cotton. A writing was made sufficient to indicate a contract for sale; it specified the quantity as “all the cotton to be produced on my 825 acres.” That contract was signed by Sam. Does the writin..

After exhaustive attempts to fix the smelly water problem : Julie Murdock was interested in buying a house offered by Greg and Beth Puckett. During a tour of the house, Julie noticed an apparatus labeled “water conditioner” in the basement and asked, “What kind of water do you have here?” After exhaustive att..

Use of empathic listening could lead to third alternative : Develop a case study that describes a scenario that would benefit from the habits (knowledge, skills, approach) presented in Part 3. This can be based on a real-life situation with which you are familiar or it can be totally fictional. Either way, yo..

User Account

All Pages