Linear programming problem using Excel Solver
Not what you're looking for?
The Kalo Fertilizer Company produces two brands of lawn fertilizer Super Two and Green Grow - at plants in Fresno, California, and Dearborn, Michigan. The plant at Fresno has resources available to produce 5000 pounds of fertilizer daily; the plant in Dearborn has enough resources to produce 6000 pounds daily. The costs - not the profit -per pound of producing each brand is as follows:
Plant
Product Fresno Dearborn
Super Two $2 $4
Green Grow $2 $3
The selling is 9 $/lb for Super Two and 7 $/lb for Green Grow. The company has a daily budget of $45000 for both plants. Based on past sales, the company knows the maximum demand (converted to a daily basis) is 6000 pounds for Super Two and 7000 pounds for Green Grow.. The company wants to know the number of pounds of each brand of fertilizer to produce at each plant in order to maximize profits.
Justify your answers to questions b & c using Sensitivity Analysis
a. Formulate the Linear Programming model for this problem.
b. Management is considering increasing the Fresno production capability by 500 pounds. How would this affect Kalo's profit? Why?
c. Management must reduce its daily budget to $40'000.How will this change affect its profits Why?
Purchase this Solution
Solution Summary
Uses excel solver to solve a linear programming problem.
Purchase this Solution
Free BrainMass Quizzes
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
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.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.