Problem 1: Using the following factor ratings, determine which location alternative should be chosen on the basis of maximum composite score, A, B, or C. Factor (100 points each) Convenient Parking facilities Display area Shopper traffic Operating costs Neighborhood Location A B Weight C D E 0.15 80 0.20 72 0.18 88 0.27 94 0.10 98 0.10 96 1.00 X 3 8 4 ++ ASSIGNMENT Problem 2: A toy manufacturer produces toys in five locations throughout the century. Raw materials (primarily barrels of powdered plastics) will be shipped from a new, centralized warehouse whose location is to be determined. The monthly quantities to be shipped to each location are the same. A coordinate system has been established, and coordinates of each location have been determined as shown. Determined the coordinates of the centralized warehouse. +6 A 4 K 7 26 LOCATION B 6 1 4 70 76 90 86 90 85 60 92 90 80 82 75 C

Problem 1: Using the following factor ratings, determine which location alternative should be chosen on the basis of maximum composite score, A, B, or C. Factor (100 points each) Convenient Parking facilities Display area Shopper traffic Operating costs Neighborhood Location A B Weight C D E 0.15 80 0.20 72 0.18 88 0.27 94 0.10 98 0.10 96 1.00 X 3 8 4 ++ ASSIGNMENT Problem 2: A toy manufacturer produces toys in five locations throughout the century. Raw materials (primarily barrels of powdered plastics) will be shipped from a new, centralized warehouse whose location is to be determined. The monthly quantities to be shipped to each location are the same. A coordinate system has been established, and coordinates of each location have been determined as shown. Determined the coordinates of the centralized warehouse. +6 A 4 K 7 26 LOCATION B 6 1 4 70 76 90 86 90 85 60 92 90 80 82 75 C

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

Related questions

Q: Question 3. Change your spreadsheet to 'show formulas' - type "show formulas" and Enter key as shown…

A: A linear objective function can be optimized using the linear programming (LP), also known as linear…

Q: QUESTION ONE The diagram below shows demand and supply curves for good K; where Do and So are the…

A: From the Supply demand curve: Initially, the equilibrium happens when the Price = 2 and the demand…

Q: Penny Farthing Penny Farthing, a leading manufacture of full metal and coil wire zippers, has been…

Q: Three suppliers A, B and C, each produce road grit which has to be delivered to council depots W, X,…

A: Find the Given details below: Given details: Depot W Depot X Depot Y Depot Z Stock…

Q: Question 1 You first conduct analysis for ordering product 101 and shipping by truckload…

A: Given Information:Demand for product 101: 200 units per weekPurchase cost (p): $500 per…

Q: QUESTION 4 Medex is a new medical supply company that only services the top 3 metro areas in the US…

A: Given, (x1,y1) = (40,74), w1 = 21 customers (x2,y2) = (34,118), w2 = 16 customers (x3,y3) = (42,…

Q: Problem 1 The following information applies to the City View Restaurant. May 1 Food inventory value:…

A: Inventory control is also described as the control of stock and is a means of managing of inventory…

Q: 6. The University cafeteria is offering meal plans for their students on a tight budget. They can…

A: Find the given details below: Given details: Plan Monthly cost Extra cost Gold $…

Q: Heman Company has three production plants in P1, P2, and P3 and two warehouses W1 and W2. The…

Q: Searching for ways to cut costs and increase profit, one of the industrial engineers at Home Comfort…

A: To determine: The most cost-effective option, we need to calculate the equivalent annual worth (EAW)…

Q: Question 2 Alpha Electronics (AE) is a large manufacturer of electronics products. The company sells…

A: (a)

Q: Question 1 (a) Beijing Daxing International Airport (PKX), China’s new USD11 billion mega airport…

A: Beijing Daxing International Airport (PKX) is a state-of-the-art airport located in Daxing District,…

Q: Question 1 (20 points) The annual production capacities of the concrete pipe factories of the…

A: Step 1: Step 2: Step 3:Creating a mathematical model for the transportation problem involves several…

Q: A vendor for the local ballpark food stand is questioning whether to stock his concession with a…

A: Find the Given details below: Given details: Profit Alternative Large Crowd Average Crowd…

Q: Question 1 William and Oliver have been working together as managers at British Imperial Textile…

A: Law plays an integral role in making the judgements related to complex situations. It helps in…

Q: Question 5: A Mechanical Design Company produces an innovative design of Batttery used for electric…

A: Variance is a comparison between actual and standard usage or price of the material in production…

Q: Question 2: From studying the local real estate market in the past few years, you observe that on…

A: The local real estate market is a key indicator of economic activity in a particular area, and…

Q: Question 2. Take a screenshot (snip tool) of you excel spreadsheet and save it. Click on the image…

A: A linear objective function can be optimized using the linear programming (LP), also known as linear…

Q: What is long range plan?

A: The set of the goal majorly outlines the five or more than five goals defining the path of the…

Q: Question 4. • Formulate this problem as a LP in which the objective is to minimize the total cost? •…

A: Find the given details below:

Question

Problem 2

Problem 1:
Using the following factor ratings, determine which location
alternative should be chosen on the basis of maximum
composite score, A, B, or C.
Factor
(100 points each)
Convenient
Parking facilities.
Display area
Shopper traffic
Operating costs
Neighborhood
ASSIGNMENT
Location
A
B
с
D
E
Weight
0.15 80
0.20
72
0.18 88
0.27 94
0.10
98
96
0.10
1.00
X
3
8
4
m
A
4
6
ASSIGNMENT
Problem 2:
A toy manufacturer produces toys in five locations throughout the
century. Raw materials (primarily barrels of powdered plastics) will
be shipped from a new, centralized warehouse whose location is
to be determined. The monthly quantities to be shipped to each
location are the same. A coordinate system has been established,
and coordinates of each location have been determined as
shown. Determined the coordinates of the centralized warehouse.
LOCATION
B
y
7
2
6
1
4
70
76
90
86
90
85
60
92
90
80
82
75
C

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1 Given the following information in the question:

VIEW

Step 2 Solve for problem 1 as follows:

VIEW

Step 3 Solve for problem 2 as follows:

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Question: Retail Channel: David can run the business fully online then he does not need to rent the facility. Alternatively, he can run the business in hybrid model (online as well as through traditional brick-and-motor channel). What will be the possible benefits and challenges for Food-Town to take the options (fully online or hybrid)? Can you solve this question for me which is linked with case study? This subject is about RETAIL AND SERVICE LOGISTICS. Please make sure to read the case study. I also provided the case study in image. Please just write in 150 words.
QUESTION 2 CLO 4: Explain the role of risk management in portfolio management Evaluate risk measurement techniques (20 marks) a) with The average returns, standard deviations and betas for three funds are given below along data for the S&P 500 index. The risk free return during the sample period is 6%. The average returns, standard deviations and betas for three funds are given below along with data for the S&P 500 index. The risk free return during the sample period is 6%. a) The average returns, standard deviations and betas for three funds are given below along with data for the S&P 500 index. The risk free return during the sample period is 6%. Fund Avg Return St Dev Beta A 13.6% 40% 11 B 13.1% 25% 10 12.4% 30% 13 S&P 500 120% 15% 10 i) ii) You wish to evaluate the three mutual funds using the Sharpe measure for performance evaluation. The fund with the highest Sharpe measure of performance is (Show your workings) Calculate and rank the funds using Jensen's alpha, Treynor measure,…
Qn.1 What are the specific academic and professional qualities you possess that could help you excel in Master's in Supply Chain Management program? 2. What goals do you hope to achieve if you are accepted into Master's in Supply Chain Management program?
QUESTION 12 A vendor for the local ballpark food stand is questioning whether to stock his concession with a large or small inventory. He believes that it will depend upon the size of the crowd. He has developed a payoff matrix for the various alternatives (stocking decision) and states of nature (size of crowd). What is the answer using the criterion of maximin? Alternatives Large Inventory Small Inventory Probability OA) -$2,000 O B) $0 OC) $51,667 OD) $220,000 O E) -$5,000 Large Crowd $220,000 $90,000 .20 PROFIT (S) Average Crowd $50,000 $70,000 1.50 Small Crowd -$2,000 -$5,000 30
Module 5 Question 8 Mayborn Enterprises, LLC runs a number of sporting goods businesses and is currently analyzing a new T-shirt printing business. Specifically, the company is evaluating the feasibility of this business based on its estimates of the unit sales, price per unit, variable cost per unit, and fixed costs. The company's initial estimates of annual sales and other critical variables are shown here: Base CaseUnit sales 7,500Price per unit $16.00Variable cost per unit $10.00Fixed cash expense per year $10,000Depreciation expense $4,000 a. Calculate the accounting and cash break-even annual sales volume in units. b. Bill Mayborn is the grandson of the founder of the company and is currently enrolled in his junior year at the local state university. After reviewing the accounting break-even calculation done in part a, Bill wondered if the depreciation expense should be included in the calculation. Bill had just completed his first finance class…
Problem 4. TT Racing and Performance Motor Corporation wishes to evaluate two alternative CNC machines for NHRA engine building. Use the AW method at 10% per year to select the better alternative. In-house Contract -250,000 -370,500 First cost, S Annual operating cost, $ per year Salvage value, $ Life, years -40,000 20,000 3 -50,000 30,000 5
Question 1 the concrete pipe factories of the DSI(State Hydraulic Works) in Eskişehir, Bursa and Konya and the 2019 needs for these pipes are given below. The annual production capacities of Annual Production (Pieces) Requirement (Pieces) Factory Capacity Eskişehir 8000 Bursa 7000 Konya 9000 City Demand İstanbul 7500 Ankara 6000 Trabzon 5000 Gaziantep 5500 Estimated intercity transportation prices : Transportation Prices (Pipe / TL) İstanbul Ankara Trabzon Gaziantep|| Eskişehir 44 40 46 50 Bursa 30 40 30 60 Konya 45 30 42 45 Create a mathematical model that will provide the most economical transportation of pipes produced in different factories to the points of need.