Please show excel formulas to solve this. Thanks You have four plants that must service customers in five major cities. Thecustomer demand, plant capacity, and shipping costs per item are in the Excel file.Setup a linear programming model in Excel to determine the minimum cost. UseSolver to solve.APlantsIndianapolisGrand RapidsLincolnKansas CityBDCustomersChicago Boston Denver Nashville New York$18$12$15$16$5$3$10$13$15$6$12$29E$26$36$25$15$7$8$24$12FGHPlantsIndianapolisGrand RapidsLincolnKansas CityCapacity2000015000700010000PLEASE ANSWER WITH EXCEL EQUATIONS AND STEPS!!!KCustomers DemandChicagoBostonDenverNashvilleNew York6000700010000120009000

You have four plants that must service customers in five major cities. The customer demand, plant capacity, and shipping costs per item are in the Excel file. Setup a linear programming model in Excel to determine the minimum cost. Use Solver to solve. A B Plants Indianapolis Grand Rapids 5 Lincoln 5 Kansas City D Customers Chicago Boston Denver Nashville New York $18 $12 $15 $16 B $5 $3 $10 $13 C $15 $6 $12 $29 $26 $36 $25 $15 E $7 $8 $24 $12 G H Plants Indianapolis Grand Rapids Lincoln Kansas City Capacity 20000 15000 7000 10000 PLEASE ANSWER WITH EXCEL EQUATIONS AND STEPS!!! Customers Demand Chicago Boston Denver Nashville New York 6000 7000 10000 12000 9000

You have four plants that must service customers in five major cities. The customer demand, plant capacity, and shipping costs per item are in the Excel file. Setup a linear programming model in Excel to determine the minimum cost. Use Solver to solve. A B Plants Indianapolis Grand Rapids 5 Lincoln 5 Kansas City D Customers Chicago Boston Denver Nashville New York $18 $12 $15 $16 B $5 $3 $10 $13 C $15 $6 $12 $29 $26 $36 $25 $15 E $7 $8 $24 $12 G H Plants Indianapolis Grand Rapids Lincoln Kansas City Capacity 20000 15000 7000 10000 PLEASE ANSWER WITH EXCEL EQUATIONS AND STEPS!!! Customers Demand Chicago Boston Denver Nashville New York 6000 7000 10000 12000 9000

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

Use excel to make the calculations (show formulas used in excel) and be sure to identify your answer, including units. FloorsRUs is considering new locations for its manufacturing plants. Costs for constructing a new facility in Huntsville are $1,100,000 and the company estimates that for every product from its new line, there would be an additional cost of $3. If the company were to locate in Hays, the new facility would cost $1,800,000 and each product would incur a $2 incremental cost. The company plans to sell the products to retailers for $7. What is the break-even point for each location? At what volume is the point of indifference? At what forecasted volumes should FloorsRUs select Huntsville as their new manufacturing location and what volumes should the company select Hays and why?
Please answer all parts A Rhino cement company owns two production plants. Plant 1 costs 20977 per day to operate, and it can produce 330 bags of high-grade cement, 475 bags of medium-grade cement , and 508 bags of low-grade cement each day. Plant 2 is newer and more modern. It costs 22570 per day to operate, and it can produce 435 bags of high-grade cement,271 bags of medium-grade cement, and 274 bags of low-grade cement each day. The company has orders totaling 24539 bags of high-grade cement, 25248 bags of medium-grade cement, and 33749 bags of low-grade cement. How many days should it run each plant to minimize its costs and still produce enough cement to meet its orders? What is the value of the first dual variable? What is the value of the second dual variable? What is the value of the third dual variable? What is the value of dual optimal solution z?
Give an example of Integer Linear Programming that is connected to business environment. provide a problem, soution, answer and conclusion
Edwards Machine Tools needs to purchase a new machine. The basic model is slower but costs less, whereas the advanced model is faster but costs more. Profitability will depend on future demand. The following table presents an estimate of profits over the next three years. Decision Basic model Advanced model Fill in the table below for maximum and minimum profit payoffs under each model. Round your answers to the nearest dollar. Decision alternative Basic model Advanced model $ Opportunity Loss Matrix Decision alternative Basic model Advanced model Maximum $ $ Low Minimum Calculate the amounts foregone by not adopting the optimal course of action for each possible demand level. Determine the maximum opportunity cost for each model. Fill in the table below. If your answer is zero, enter "0". Round your answers to the nearest dollar. Future events Medium $ $ High Low $70,000 $30,000 Demand Volume Maximum # Medium $120,000 $140,000 Given the uncertainty associated with the demand volume,…
DONT SOLVE WRONG... SOLVE IF YOU ARE 5000% SURE Jaclyn is considering opening a location on campus to sell bubble tea. Her rent would be $500/month and she expects to sell each drink for $5. Variable costs are $0.85 and labor is $1.77. She also has the option to share space with a friend, which would cost her only $300/month in rent. Her friend wants $0.03 per bubble tea revenue sharing. What is Jaclyn’s new break-even point? If she sells 264 bubble teas, which option does she prefer? a. She prefers sharing space with her friend at Q=264. b. She is indifferent between the two choices at Q=264. c. She prefers working by herself at Q=264.
You are planning a vacation to Patagonia. You have a choice of 4 hotels at which to stay, and a choice of 3 different car rental companies to use. Patagonia offers 5 different day trips you can take. A vacation to Patagonia consists in selecting one hotel, one car rental company and 2 different day trips (the order doesn't matter). How many ways are there to plan your vacation? (A) 24 (B) 60 (С) 40 (D) 4 (E) 240 (F) 30 (G) 495 (Н) 120 OA OB В OD F OG OH
with the information given draw a graph, On the x-axis, you would have the number of units sold (from 0 to 800,000 in increments of 100, 000) and on the y-axis, you would have the dollar amount (from 0 to $3,200,000 in increments of $ 400,000). Draw a line from the origin with a slope equal to the variable cost per unit ($2.5) to represent total variable costs. Draw a horizontal line at $600,000 to represent total fixed costs. The sum of these two lines gives the total cost line. Draw another line from the origin with a slope equal to the selling price per unit ($4) to represent total sales. The point where the total sales line intersects the total cost line
solve asap with explanation and get multiple upvotes
You own a combination architectural/engineering company. I long-ter m client just asked your firm to design a boat dock that can accommodate 20 boats. Please list 12 questions that you would need to ask the client in order to properly design the boat dock to be economical, safe, and long-lasting. Please also explain the purpose of asking each question.
Linear programming has no real-life applications. Do you agree with this statement? Discuss
Create spreadsheets and use Solver to determine the correct volumes to be produced to minimize cost for the following problem. Your company has two trucks that it wishes to use on a specific contract. One is a new truck the company is making payments on, and one is an old truck that is fully paid for. The new truck’s costs per mile are as follows: 54₵ (fuel/additives), 24₵ (truck payments), 36₵ (driver), 12₵ (repairs), and 1₵ (misc.). The old truck’s costs are 60₵ (fuel/additives), 0₵ (truck payments), 32₵ (rookie driver), 24₵ (repairs), and 1₵ (misc.). The company knows that truck breakdowns lose customers, so it has capped estimated repair costs at $14,000. The total distance involved is 90,000 miles (to be divided between the two trucks).
American Red Cross wants to determine the least expensive way to transport available blood donations from Pittsburgh and Staunton to hospitals in Charleston, Roanoke, Richmond, Norfolk, and Suffolk. The supply and demand for donated blood is shown the following figure along with the unit cost of shipping along each possible arc: -1,300 Pittsburgh Staunton -1,200 2 Charleston 3 Roanoke 300 200 8 Richmond 9 6 4 Norfolk 800 700 Suffolk 7 400