General Appliance Corporation (GAC) produces refrigerators at two plants: Marietta, Georgia and Minneapolis Minnesota. These plants...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
General Appliance Corporation (GAC) produces refrigerators at two plants: Marietta, Georgia and Minneapolis Minnesota. These plants have corresponding capacities of 1200 and 800 refrigerators respectively. The plants ship the refrigerators to major distribution centers in Cleveland, Baltimore, Chicago and Phoenix. These centers have demand requirements of 150, 350, 500 and 1000 respectively. The variable costs to ship from each plant to each center are given below. Cost per To: Marietta Minneapolis Refrigerator From: Cleveland Baltimore Chicago Phoenix $12.60 $14.35 $11.52 $17.58 $9.75 $16.26 $8.11 $17.92 (a) What type of problem is this? As a result, what can we say about the optimal values of the variables being integers? (0 points) (b) State the decisions to be made, the objective and the constraints in words using <=, >= or = in the constraints. (Handwrite answer, 5 points) (c) Define your decisions in part (a) algebraically as decision variables. Then, using your objective and constraints in part (b), formulate the problem as an algebraic linear optimization model. (Handwrite answer, 5 points) (d) Construct an EXCEL model for this problem and use Solver to determine an optimal solution. (Submit answer via Blackboard, 5 points) (e) The company is considering the possibility of expanding the capacity of its plant in Marietta. Assuming that the same variable costs will apply, give a graph that depicts how GAC's optimal cost changes in terms of the capacity of Marietta between 1200 and 2000. (Handwrite answer, 5 points) General Appliance Corporation (GAC) produces refrigerators at two plants: Marietta, Georgia and Minneapolis Minnesota. These plants have corresponding capacities of 1200 and 800 refrigerators respectively. The plants ship the refrigerators to major distribution centers in Cleveland, Baltimore, Chicago and Phoenix. These centers have demand requirements of 150, 350, 500 and 1000 respectively. The variable costs to ship from each plant to each center are given below. Cost per To: Marietta Minneapolis Refrigerator From: Cleveland Baltimore Chicago Phoenix $12.60 $14.35 $11.52 $17.58 $9.75 $16.26 $8.11 $17.92 (a) What type of problem is this? As a result, what can we say about the optimal values of the variables being integers? (0 points) (b) State the decisions to be made, the objective and the constraints in words using <=, >= or = in the constraints. (Handwrite answer, 5 points) (c) Define your decisions in part (a) algebraically as decision variables. Then, using your objective and constraints in part (b), formulate the problem as an algebraic linear optimization model. (Handwrite answer, 5 points) (d) Construct an EXCEL model for this problem and use Solver to determine an optimal solution. (Submit answer via Blackboard, 5 points) (e) The company is considering the possibility of expanding the capacity of its plant in Marietta. Assuming that the same variable costs will apply, give a graph that depicts how GAC's optimal cost changes in terms of the capacity of Marietta between 1200 and 2000. (Handwrite answer, 5 points)
Expert Answer:
Related Book For
Managerial Decision Modeling With Spreadsheets
ISBN: 9780136115830
3rd Edition
Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair
Posted Date:
Students also viewed these mathematics questions
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
(a) What is the mean value of spin 2 in the above example? Why is its mean value not zero? (b) What is the probability p that a given spin points up? (c) What is the probability that if spin 1 is up,...
-
A table of properties for methyl chloride lists the saturation pressure as 116.7 psia at 100oF. At 100oF, this table also lists hfg = 154.85 Btu/lbm, and vfg = 0.86332 ft3/lbm. Estimate the...
-
How much must you deposit at the end of each year in an account that pays a nominal annual rate of 20 percent, if at the end of five years you want $10,000 in the account?
-
In Exercises use the Ratio Test to determine the convergence or divergence of the series. OC n=0 (-1)n 24n (2n + 1)!
-
A neurosurgery resident wants to double her money in the time it takes her to complete a residency program (7 years) so she can buy a new car with cash upon graduation. What interest rate is needed...
-
Use the Internet to locate www.cia.gov and www.Amazon.com. Find the privacy and security policies for each. Compare and contrast the use of privacy statements, encryption, SSL, and cookie policies.
-
Income Statement Instructions Labels and Amount Descriptions Income Statement Instructions Jasper Company provided the following information for last year Costs Sales in units Selling price Amount...
-
In the figure for Problem 13-35, pinion 2 is to be a right-hand helical gear having a helix angle of 30, a normal pressure angle of 20, 16 teeth, and a normal diametral pitch of 6 teeth/in. A motor...
-
2. Hotwil Sdn. Bhd. facing a shortage of RM400,000 and the accountant has suggested obtaining funds for a period of 6 months to improve the situation. The following short-term sources of financing...
-
ASSA ABLOY's debt situation was good. Their debt decreased from 2018 to 2020 but increased significantly in the years following. According to Buffett, ASSA ABLOY is not a durable, competitive company...
-
Pharmacy Consulting is a privately held regional provider based in Ohio, with revenues of $25 million annually, and whose services include pharmacy, nursing and dietary nutrition care. Key client...
-
Allegion shows strengths in terms of ROA, ROE, and historical positive trends in cash, receivables, and property, plant & equipment. However, there are concerns about the substantial increases in...
-
Billy Bob Corp has a profit margin (income to sales) of 3.7%. Sales-to-assets measures a ratio of 6.6x. The capital structure of BBC is 40% debt & 60% equity. What is BBC's return on equity? (Answer...
-
A company intends to borrow RTGS$150 000 to finance the purchase of new machinery. The Finance manager is considering taking a 12% loan from First Capital Bank that will be amortized over the next 8...
-
Suppose you are going to receive a 10-year annuity with annual payments of $1,000. The first payment will be received at the end of Year 1 and the last payment will be received at the end of Year 10....
-
What is the difference between adsorption and absorption?
-
Suppose Good-to-Go (Problem 4-22) is considering the possible introduction of two new products to its line of suitcases: the Compact model (for teenagers) and the Kiddo model (for children). Market...
-
The Classic Furniture Company is trying to determine the optimal quantities to make of six possible products: tables and chairs made of oak, cherry, and pine. The products are to be made using the...
-
A series of activities must be completed in a coordinated fashion to complete a landscaping overhaul. The following table shows the activities; their optimistic, most likely, and pessimistic...
-
Renkas Heaters selected data for October 2017 are presented here (in millions): Calculate the following costs: 1. Direct materials inventory 10/31/2017 2. Fixed manufacturing overhead costs for...
-
The following data are for Huang Wong Ping Retail Outlet Stores. The account balances (in thousands) are for 2017. 1. Compute (a) the cost of goods purchased and (b) the cost of goods sold. 2....
-
The Howell Corporation has the following account balances (in millions): Prepare an income statement and a supporting schedule of cost of goods manufactured for the year ended December 31, 2017. (For...
Study smarter with the SolutionInn App