John is interested in finding a ute car. Below is the summary of his criteria and the choices that he has selected as potential cars that he may purchase. Conduct TOPSIS in an Excel spreadsheet to determine the best car that he should purchase. What do the results suggest? Note: Calculate the data given below in the same way as the rating scale. There is no need to convert the data into the rating scale before the calculation.
Q: XYZ and Co has provided the following data seeking your advice on optimum investment strategy: Net…
A:
Q: The Lake Sharkey BBQ Pit serves slow cooked beef brisket by the pound. Based on historical sales…
A: The profit from selling one unit = Selling price- Cost = 23-14=9 Loss from one unit = Cost- salvage…
Q: A national census bureau predicts that a certain population will increase from 34.1 million in 2000…
A: Population increase from 34.1 to 58.2 million Time duration (t) = 2070-2000 = 70
Q: began operations in 2015 and reported profits for the years 2015 through 2018. Due primarily to…
A: Ethics is all framing the behaviours in accordance with the moral principles and values. From an…
Q: Lou Silva has owned and operated The Wellness Store for fifteen years. The company's year-end is…
A: Recapture is distinguished when the measure of UCC balance is not exactly the proceed [from your…
Q: Train an ID3 decision tree for a dataset shown in the following table. The table contains 2…
A: The following is the python code for ID3 decision tree and predict values.
Q: Let Q be the number of pies they make and sell. The total cost, C(Q) in dollars, for making Q pies…
A: The question demands us to find the total cost which is incurred in making 20 pies Total cost =…
Q: Problem No. 1: The first week of chess club had 3 students. The second week had five students. The…
A: As per Bartleby guidelines, we can only solve one question at a time...Kindly upload the other…
Q: Using MAD as the criterion, which of the following models would you use for the given time series…
A: THE ANSWER IS AS BELOW:
Q: a) Determine the amount of potatoes and green beans Maria should purchase each week for the…
A: Note: first three subparts being done because of guidelines. Repost for other part answers. a)
Q: Force Field Analysis. Substantiate with relevant ideas and mention the positives and negatives of…
A: Total Quality Management (TQM) is a management concept based on the premise that an enterprise may…
Q: GENERATE THE DECISION VARIABLE SOLUTION AND GENERATE AN ANSWER REPORT 2. During the winter WeeMow…
A: Let, R = Number of residential jobs C = Number of commercial jobs Objective function: Maximize Z =…
Q: Your Lego furniture company makes Tables and Chairs. Below, you are given the starting inventory,…
A: Let us assume x1 is the no of tables to be madeand x2 as the number of chairs to be made Now,…
Q: Read the following case and answerthe questions given below:Students in Mrs. Rickshaw’s Student…
A: "Since you have asked multiple questions we will solve the first question for you. If you want any…
Q: The Gotham City News is moving to a paywall subscription service rather than a free news website…
A: Customer Lifetime Value refers to the total business value in terms of revenue can be generated from…
Q: In what ways does Ritz-Carlton utilize control to ensure high-quality service? How does the company…
A: Question: In what ways does Ritz-Carlton utilize control to ensure high-quality service? Answer: As…
Q: The plot of the time series is not necessary to decide about the best model to be used for…
A: Regardless of whether we wish to anticipate the pattern in monetary business sectors or power…
Q: A PRACTICAL GUIDE TO WRITING A FEASIBILITY STUDY NIMM PRINTERS Operational or Production Objectives…
A: Production is the systematic transformation of raw materials into final products as a result of…
Q: Quality Air Conditioning manufactures three home air conditioners: an economy model, a standard…
A: Objective Functions and Constraints: Based on the given details, we found the…
Q: An airline decided to offer direct service from City A to City B. Management must decide between a…
A: Thank you for posting the question,As per our guidelines we will be answering the first 3 sub parts…
Q: Please answer this using EXEL AND SOLVER ADD IN. Include and identify decision variables, objective,…
A: O = overtime , RE = regular employees, H = holding cost RP = Regular production, D = demand…
Q: Harrison Hotels is considering adding a spa to its currentfacility in order to improve the list of…
A: given, fixed cost = $ 25000 per year variable cost = $35 per customer break even = 12000 customers
Q: 4. If they exist, use the stepping stone algorithm and find the second optimal solution. Present…
A: Find the IBFS below: Shipped To Boston (d1) Dallas (d2) Los Angels (d3) St. Paul (d4) Dummy…
Q: Hayworth Corporation has Just segmented last year's income statement Into its ten product lines. The…
A: Introduction: Contribution margin: Formula: Contribution margin = Selling price per unit -…
Q: A zoo wishes to transport a family of four wolves overnight to a facility 200 km away. The journey…
A: As the journey will take 6hrs+45mins at each end for loading and unloading of animals. As the sedate…
Q: Round Tree Manor is a hotel that provides two types of rooms with three rental classes: Super Saver,…
A: Given data: Rental Class Room Super Saver Deluxe Business Availability Type I 30 35 -…
Q: The Pampered Pet Kennels Company provides room and board for dogs and cats. The manager must mix up…
A: LPP MEANING LPP stands for Linear Programming Procedure. In mathematics, a problem is a system for…
Q: 1. Sara is planning to start a new designer cloth shop. Her problem is to decide how large her shop…
A: The Laplace criterion: The Laplace criterion manages all the knowledge by assigning similar…
Q: Garfield Industries is expanding its operations throughout the Southeast United States. Garfield…
A: Calculation of increase or decrease in income: Incremental sales $1000000 Less: Increase in cost of…
Q: A survey was conducted to 12 first time voters on their preferred candidate. The results are: BBM,…
A: The First question is related to Plurality Method. As per this method only first choice votes are…
Q: Define below mentioned structure table in your words and explain importance of path coefficient, T…
A: IMPORTANCE OF PATH COEFFICIENT1- It tells us the true nature of the cause and effect relationship.2-…
Q: ABC company wants to open one, two, or three shops. The average Profit varies with the demand in…
A: Given Information:
Q: The Gotham City News is moving to a paywall subscription service rather than a free news website…
A: Monthly subscription fee = $21 Discount on the on-line subscription rate = 60% Monthly rate for the…
Q: Find the optimal solution and the maximum profit. In which plant there will be idle capacity and how…
A: Since you have submitted multiple questions, as per guidelines we have answered the first three…
Q: Bilbo Baggins wants to save money to meet three objectives. First, he would like to be able to…
A: The timeline is: The cash flows for this problem occur monthly, and the interest rate given is the…
Q: Even though independent gasoline stations have been having a difficult time, Susan Solomon has been…
A: “Hi, since there are multiple questions posted, we will answer the sub-parts from (a) to (d)…
Q: 1. Sara is planning to start a new designer cloth shop. Her problem is to decide how large her shop…
A: Answer: For this question, we can reach the solution with the help of decision making without…
Q: Lets say, each store is pursuing its own best interest. What will be a rational (or dominant)…
A: As per the Bartleby guidelines, only the first three parts have been answered.
Q: The function of management that compares planned results to actual results is known as: Select one:…
A: At the most fundamental level, the board is a discipline that consists of a bunch of five general…
Q: The operations manager for an auto supply company is evaluating the potential purchase of a new…
A: a) We prepare the excel sheet as shown below: We can enter any value in the Green box and get the…
Q: ABC company wants to open one, two, or three shops. The average Profit varies with the demand in…
A: Concepts used to solve the problem: MAXIMAX: Determine the best possible payoff, and choose the…
Q: The marketing team at P&G Company is developing an advertising campaign to promote their specialty…
A: Objective Function Z (max)=600,000x1 +200,000x2 Where x1 be the no. of TV ads x2 be the no. of SM…
Q: The following table represents sales data for milk (in hundred liters) sold by a grocery. Do the…
A: Note: - Since the exact question that has to be answered is not specified we will answer the…
Q: Golden Company is in the period of budgeting for 2022. The Sales manager forecasted the number of…
A: Given that: Forecast units to be sold = 30000 units Selling Price = 40 OMR Decrease in Selling Price…
Q: For the given information related to "inputs," the values for deviation and total are: The deviation…
A: This question is related to the topic of production management and this topic falls under the…
Q: The three divisions of Yummy Foods are Snack Goods, Cereal, and Frozen Foods. The divisions are…
A: a. Investment Turnover = Total InvestmentRevenue earned Particulars Snack Goods Cereals Frozen…
John is interested in finding a ute car. Below is the summary of his criteria and the choices that he has selected as potential cars that he may purchase. Conduct TOPSIS in an Excel spreadsheet to determine the best car that he should purchase. What do the results suggest?
Note: Calculate the data given below in the same way as the rating scale. There is no need to convert the data into the rating scale before the calculation.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
- Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?The following table represents sales data for milk (in hundred liters) sold by a grocery.Do the computations to fill out the table and answer the following questions:1. Using MAD as the criterion, which of the following models would you use for thegiven time series data? Why?A. Naïve approach;B. 5-month SMA model;C. WMA model with weights 0.1, 0.3, and 0.6; orD. ES model with α = 0.5 and a forecast of 3,500 liters in the first month.NOTE: In answering Item 1, mention the whole description of the model; i.e., not just“SMA model”, but “SMA model with n = ...”; not just “WMA model”, but “WMA modelwith weights ...”; not just “ES model”, but “ES model with α = ...”.2. Interpret the MAD of the most accurate among the forecasting models above.3. Based on your decision in Item 1, what should be the forecast for Month 11?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…
- You have an idea for a new web service that offers customized workouts for subscribers. Build a spreadsheet to calculate 1) the number of new customers each month and 2) the total customer base (cumulative number of customers signed up) each month. Mimic what we did in the class to project the subscription volumes for 60 months under the following sets of assumptions. a)Total market potential is 1,000,000 customers. Each month, you sign up 2% of customers in the market that have not yet signed up. b)Total market potential is initially 1,000,000 customers, but grows at 1% per month. Each month, you sign up 2% of customers in the market that have not yet signed up. Use the graph wizard to make a graph comparing total customer base under each of the two scenarios. Which type of graph is appropriate?Quality Air Conditioning manufactures three home air conditioners: an economy model, a standard model, and a deluxe model. The profits per unit are $63, $95, and $135, respectively.The production requirements per unit are as follows: (SEE ATTACHED) Answer the following questions (a-i) using the output below please be brief. If there are twopossible answers one will suffice. Where necessary a range analysis must be shown. a) What is the optimal solution and what is the value of the objective function. b) Which constraints are binding and which constraint show extra capacity? c) 100 hours of manufacturing time became available .Evaluate the effect? Explain.The following table represents sales data for milk (in hundred liters) sold by a grocery. Do the computations to fill out the table and answer the following questions: Using MAD as the criterion, which of the following models would you use for the given time series data? Why? Naïve approach; 5-month SMA model; WMA model with weights 0.1, 0.3, and 0.6; or ES model with α = 0.5 and a forecast of 3,500 liters in the first month. NOTE: In answering Item 1, mention the whole description of the model; i.e., not just “SMA model”, but “SMA model with n = …”; not just “WMA model”, but “WMA model with weights …”; not just “ES model”, but “ES model with α = …”. Interpret the MAD of the most accurate among the forecasting models above. 3. Based on your decision in Item 1, what should be the forecast for Month 11?
- XYZ Co. has provided the following data seeking your advice on the optimum investment strategy: Investment at the beginning of the year Net return data of selected investments Amount P Q R S available (£) 1 95 80 70 60 70 2 75 65 60 50 40 3 70 45 50 40 90 4 60 40 40 30 30 Maximum Investment (£) 40 50 60 60 The following additional information is also provided: o P, Q, R and S represent the selected investments o The company has decided to have four years investment plan o The policy of the company is that the amount invested in any year will remain so until the end of the fourth year o The values in the table represent net returns on investment of £1 till the end of the planning horizon Determine the optimal investment strategy. You may use the transportation techniqueTriple X Company manufactures and sells refrigerators. It makes some of the parts for the refrigerators and purchases others. The engineering department believes it might be possible to cut costs by manufacturing one of the parts currently being purchased for $8.25 each. The fi rm uses 100,000 of these parts each year. The accounting department compiles the following list of costs based on engineering estimates:Fixed costs will increase by $50,000. Labor costs will increase by $125,000.Factory overhead, currently running $500,000 per year, may be expected to increase 12 percent.Raw materials used to make the part will cost $600,000.Given the preceding estimates, should Triple X make the part or continue to buy it?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%
- A goldsmith makes two types of jewelry. A model A ring is made with 1 g of gold and 1.5 g of silver and sells for 25 UM.Another model B ring sells for 30 UM and is made of 1.5 g of gold and 1 g of silver. If you only have 750 gof each metal, how many rings should be made of each type to obtain maximum profit?Requested:- Make Initial Table of the problem.- Obtain the Case Variables- Obtain the Objective Function- Get Restrictions- Create the Simplex Table- Obtain the Optimal Solution and the Slack Variables.Solve this operational research exercise.Search for Patterns: Problem No. 1: The first week of chess club had 3 students. The second week had five students. The third week had eight students and the fourth had twelve. If this pattern continues, how many students will show up for the eight week? Problem No. 2: From the given table find the value of n if m = 50. M 1 2 3 4 5 50 N 1 3 5 7 Problem No. 3: What is the unit’s digit in the power of 7 with an exponent of 1999?Sapphire Farm is a business that trains and boards horses and educates young riders about horse care, nutrition, a product focusand riding. The farm provides both a learning and a fun environment for young equestrians and their families. It also hosts horse shows for beginning riders to help them build confidence in the show ring and to prepare them for local horse shows by running shows in accordance with the rules and regulations of the National Hunter Jumper Association. Feedback from the horseshow judges are provided to all riders so they can do better at their next meet. In addition, all warm-up and training areas are fenced and monitored by adults for the children's safety.According to the service-profit chain, the high-value service offered by Sapphire Farm LLC should lead to: A. congruent market response B. positive framing C. customer autonomy D. customer satisfaction E. a product focus