To insure business value and effectively manage the portfolio, the "right" projects must be selected. One tool for doing this is the Weighed Scoring Model. Below is aproblem to solve.Use a weighted score model to choose between three locations (A,B,C) for setting up a factory. The relative weights for each criterion are shown in the following table. Ascore of 1 represents unfavorable, 2 satisfactory, and 3 favorable.CategoryLabor costsLabor productivityLabor supplyUnion relationsMaterial supplyTransport costsWEIGHTED SCORING MODELInfrastructureWeight2020101010255A1223212LocationB2313122с3132132

To determine the weighted scores- by multiplying the weight for all given criterion through its…

Answered: To insure business value and…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

the gulf coast foundry is developing a long range strategic plan for buying scarp metal for its foundry oprations the foundry can buy scrap metal in unlimited quantities from two sources, Atlanta(A) and Birmingham (B), and it receives the scrap daily in railroad cars. the scrap is melted down, and lead lead and copper are extracted for use in the foundry processes each railroad car of scrap from source A yields 1 ton of copper and 1 ton of lead and cost $10,000. each railroad car of scrap from source B yields 1 ton of copper and 2 tons of lead and costs $15,000, if the foundry needs at least 2 and a half tons of copper and at least 4 tons of lead per day for the foreseeable future, how many railroad cars of scrap should be ( purchased per day from source A and source B to minimize the long range scrap metal cost?
Type the linear program, optimal solution, and objective function value in a word document. Submit your excel file. An investor wishes to invest some or all of his $12.5 million in a diversified portfolio through a commercial lender. The types of investments, the expected interest per year, and the maximum allowed percentage investment he will consider are shown on the following table. He wants at least 35% of his investments to be in nonmortgage instruments and no more than 60% to be in high-yield (and high-risk) instruments (i.e., expected interest > 8%). How should his investment be diversified to make the most interest income? Investment Expected Return Maximum Allowed Low-income mortgage loans 6.50% 20% Conventional mortgage loans 6.00% 30% Government sponsored mortgage loans 8.25% 25% Bond investments 5.75% 15% Stock investments 8.75% 18% Futures trading 9.25% 10%
The following table presents cost, capacity, and demand data for a transportation problem in Stephanie Robbin’s furniture company. Set up the appropriate transportation table and find the optimal solution using Excel's solver. From/To 1 2 3 Supply A 30 10 5 20 B 10 10 10 30 C 20 10 25 75 Demand 40 60 55 a. Is the problem balanced? [ Select ] ["Yes", "it is balanced", "No", "cannot determine"] , If not, where? [ Select ] ["Neither", "Supply", "Demand"] , and by how much? [ Select ] ["0", "40", "30", "25"] b. What is the optimal cost? $ [ Select ] ["2,500", "1,100", "1,275", "1,300"] c. Were you able to meet all demand requirement? [ Select ] ["no", "cannot determine based on the information given", "yes"] If not, which destination (s) was/were not met? [ Select ] ["none, all destinations were met based on supply and demand being equal", "destination 3 by 30 units", "destination 2 by 30 units", "destination 1 by 25 units…
Dumaguete City Oil Mills, Inc must choose among a series of new investment alternatives. The potential investment alternatives, the NPV of future cash flows, the capital requirements, and the available funds over the next three years are as follows: NPV (in million pesos) Capital Requirements Alternative Year 1 Year 2 Year 3 Limited warehouse expansion 4.0 3.0 1.0 4.0 Extensive warehouse expansion 6.0 2.5 3.5…
Consider the info provided below as well as the financial statements and answer the questions that follow.Pearson & Litt is a manufacturing company in the Eastern Cape. Their factory manufactures glass wine bottles for the Blue Valley Beer Co. For 2019 and 2020 respectively :Sales price per unit R15 and R19Variable cost per unit R6 and R7Fixed cost (FC) per annum R650 000 and R 855 500Fixed cost per unit R3 and R4Current assets R450 600 and R560 700Current liabilities R510 000 and R780 000Retained profit R21 809 and R17 600Net Sales R2 900 320 and R 3 100 100Cost of sales R390 000 and R475 000 Q.1 Calculate the break‐even point for Pearson & Litt for 2019 and 2020. Q.2 Compare the results of the 2019 and 2020 break‐even point and explain why there might be a difference.
Please answer this using EXEL AND SOLVER ADD IN. Include and identify decision variables, objective, and constraints. Please also upload what the info in solver you added was!!!! It is summertime and your winter coat factory is trying to decide its production schedule and staffing level for the next season. You are forecasting demand of 5000 coats in October, 8000 coats in November, 8000 coats in December, 12000 coats in January, 12000 coats in February and 9000 coats in March. You want to manufacture these coats at the lowest cost possible during your production window (October-March). The first decision you need to make is how many people to hire. Each employee will cost $2500 a month. You don’t want to hire or fire any employees mid-season in order to minimize disruptions in your factory floor. You can have employees idle if there isn’t sufficient work for them to do. Employees still need to be paid even if they are idle. An employee works 20 business days a month and takes half a…
As purchasing agent for Eynan Enterprises in Richmond, Virginia, you ask your buyer to provide you with a ranking of "excellent" (worth 4 points), "good" (3 points), "fair" (2 points), or "poor" (1 point) for a variety of characteristics for two potential vendors, Donna Inc. (D) and Kay Corp. (K). You suggest that "Products" total be weighted 0.4, the "Company" total be weighted 0.2, and the "Service" and "Sales" totals each be weighted 0.2. The buyer has returned the following ranking. Which of the two vendors would you select? Click the icon to view the rankings. Part 2 You should choose vendor ▼ Donna Inc. Either Kay Corp. or Donna Inc. Kay Corp. , with a weighted score of ________. (Enter your response rounded to one decimal place.)
Dennison Manufacturing makes large helical springs used in aircraft landing gear. The company has narrowed its potential choices for its new manufacturing facility to four cities. The following information is known about the manufacturing and shipping costs of locating in each of these four cities: Fixed Costsper Year Variable ManufacturingCosts per Unit Variable ShippingCosts per Unit Phoenix Buffalo Seattle Atlanta $300,000 $600,000 $1,500,000 $1,750,000 $70.00 $56.00 $36.00 $42.00 $5.00 $4.00 $2.00 $5.00 a. Use break-even point analysis to determine where Dennison should locate.b. Based solely on break-even quantity, if Dennison’s manufacturing forecast for the foreseeable future is 40,000 units annually, where should he locate?
Mr. Smith is a rentier, he lives on renting apartments. However, these days he has to sell one of his apartments to get a big money. He hesitates which of three apartments of his to sell. Help Mr. Smith to make the right decision if you know the following: The present prices per m2 in the three locations equal: A) 4000, B) 5000, C) 6000 goldies, respectively. However, the long-run prices of those real estates are: A) 5000, B) 6000, and C) 7000 goldies, whereas the respective standard deviations are A) 400, B) 500, and C) 250 goldies.
How did you find the solutions in the table for the range of optimality for the profit coefficient?
For a table manufacturing company, selling price for a table is $183.00 per Unit, Variable cost is $25.00 per Unit, rent is $3,380.00 per month and insurance is $296.00 per month. Company wants to expand its business and improve the table quality, it wants to increase the selling price for a table to $254.00 per Unit, Variable cost to $43.00 per Unit, bigger area will have rent $5,235.00 per month and insurance is $362.00 per month At what point will the company be indifferent between the current mode of operation and the new option?
Formulate the LP model for each of the problem identified below. Clearly define the decision variables and the objective function The Burroughs Garment Company manufactures men’s shirts and women’s blouses for Walmark Discount Stores. Walmark will accept all the products supplied by Burroughs. The production process includes cutting, sewing, and packaging. Burroughs employs 25 workers in the cutting department, 35 in the sewing department, and 5 in the packaging department. The factory works one 8-hr shift, 5 days a week. Determine the optimal weekly production schedule for Burroughs. The following table gives the time requirements and profits per unit for the two garments.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS