Tulip MMC produces doors in different regions and has 5 shops across the country.Given the different shipping costs which warehouse should serve which customer in order to minimize costs?Put your total shipping costs in the green cellNo negative numbers. Do not exceed capacity. Meet the demandwarehouseLocationBaku (Ci)GanjaLankaranQabalaUcarTotalTotalMonthyCapacityBakuGanjaLankaranQabalaUcarTotal cost = ?6105109103606103000Shop 1Shop 2Shop 3MonthyDemand(Di)540440500520600Shop 4Shop 5Total 2600Cost to ship one door from Warehouse I to Customer j (Tij)Shop 1 Shop 2 Shop 3 Shop 4 Shop 54.53.53.28.56.547.52.53.751010.568.56.86.55.77.52.89.57.27.46.32.27.110.5

Find the Given details below: Given details: Warehouse Location Customer Shop 1 Shop 2 Shop…

Answered: Tulip MMC produces doors in different…

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

ProHaul specializes in trans-American shipments for businesses through the delivery of containers. For every container the company loads on its trucks, ProHaul estimates the haul costs $1,000. In addition, containers are weighed and for each pound, there are hauling fees of $0.15. ProHaul plans to charge $0.49 per pound to his customers.Break even=2,941.17647 unitsWhat would the total revenue be for this?
A retail has 8 stores supplied from 4 suppliers, where each supplier supplies different goods. Delivery from the Supplier is in trucks with a capacity of 40,000 units at a cost of $1100 per load plus $100 per delivery to the store. Inventory costs are $0.2 per unit per year. The Supply Chain Manager is considering whether to use direct shipping or Milk Run delivery for 4 stores for each truck in one shipment a) if annual sales in each store are 1000,000 units, which shipping method provides the lower cost b) if the annual sales in each store are 200,000 units, which shipping method provides the lower cost
Please answer the following in an organized way and showing steps. Maxwell Manufacturing makes two models of felt tip marking pens. Requirements and available resources for each lot of pens are given in the following table: Fliptop Model Tiptop Model Available Plastic 3 4 36 Ink Assembly 5 4 40 Molding Time 5 2 30 The profit for either model is $1,000 per lot. a. What is the linear programming model for this problem? b. Using Microsoft Excel's Solver, find the optimal solution. How many Fliptop models and how many Tiptop models should be produced? What is the maximum profit? c. Will there be excess capacity in any resource? Use Excel's Solver and run a sensitivity report to answer the following questions: d. Over which range can the objective function coefficient for Fliptop Models change without affecting the original optimal solution? What is this range called? e. What is the shadow price (dual price) for the plastic constraint and how…
Ching-Chang Kuo is considering opening a new foundryin Denton, Texas; Edwardsville, Illinois; or Fayetteville, Arkansas, to produce high-quality rifle sights. He has assem-bled the following fixed-cost and variable-cost data: PER-UNIT COSTS LOCATION FIXED COSTPER YEAR MATERIALVARIABLELABOR OVERHEADDenton $200,000 $ .20 $ .40 $ .40Edwardsville $180,000 $ .25 $ .75 $ .75Fayetteville $170,000 $1.00 $1.00 $1.00a) Graph the total cost lines.b) Over what range of annual volume is each facility goingto have a competitive advantage?c) What is the volume at the intersection of the Edwardsvilleand Fayetteville cost lines?
A manufacturing firm has four plants and wants to find the most efficient means of meeting the requirements of its four customers. The relevant information for the plants and customers, along with shipping costs in dollars per unit, are shown in the table below: Customer (requirement) Factory (capacity) Customer 1 (125) Customer 2 (150) Customer 3 (175) Customer 4 (75) A (100) $ 15 $ 10 $ 20 $ 17 B (75) $ 20 $ 12 $ 19 $ 20 C (100) $ 22 $ 20 $ 25 $ 14 D (250) $ 21 $ 15 $ 28 $ 12 How many supply nodes are present in this problem? Multiple Choice: 4 3 1 8 16
. Botany weaving was established in 1934 in Dublin Ireland and it is now an approvedsupplier of fabrics for both Boeing and Airbus. They operate 3 plants in Europe to supplytheir 2 major airline customers and these plants are located in Ireland, UK and Italy. Theyhave to decide where to manufacture the two newest high-tech fabrics: Nano Seat Fabricsand Ultra Curtains. Each plant has a different variable cost structure and capacity formanufacturing the different products. Also, each product has an expected demand. CostPlan Plant Capacity Nano Seat Fabrics Ultra curtains Ireland 6000 31€ 28.5€UK 5300 32.5€ 30.5€Italy 5000 35€ 29.5€Demand…
Mary is a sales person for Challenge Furniture. She receives an incremental commission based on the table below. If she sells $26,000 and has already received a draw of $766.15, how much commission is still owed to Mary? level 1 1-11,700 3.7% sales volume 2 11,701-21,200 4.3% commission rate 3 over 21,200 4.7%
Problem Solving. Solve the following problems completely. 3. An item which can be sold for P63.00 per unit wholesale is being produced with the followingcost data; labor cost, P11 per unit; material cost, P15.00 per unit; fixed charges, P10,000;variable cost, P8.00 per unit. What is the break-even point sales volume?
Valencia Products makes automobile radar detectors and assembles two models: LaserStop and SpeedBuster. The firm can sell all it produces. Both models use the same electronic components. Two of these can be obtained only from a single supplier. For the next month, the supply of these is limited to 4,000 of component A and 3,500 of component B. The number of each component required for each product and the profit per unit are in the table below. This question is interested in maximizing the profit). a) Identify the decision variables, objective function, and constraints in simple verbal statements. b) Mathematically formulate a linear optimization model. Components Required/Unit A B Profit/Unit LaserStop 18 6 $124 SpeedBuster 12 8 $136 Solve this question in Excel by using SOLVER. Please clearly explain what is the optimal solution? What is the resulting output of the objective function at the optimal solution? P.S. please solve in Excel.
Lenka's Fresh Snacks (LFS), the producer of the Lenka Bar, is a granola bar manufacturer based in Yoe, Pennsylvania. LFS produces a number of granola bars for its 450 retail partners across the eastern seaboard, manufacturing them in its 4,000-square-foot facility. According to Steve Rasovsky, CEO, the best-selling flavors for Lenka Bar are peanut butter, and nuts and berries. 8 As LFS continues to expand, it has decided to add a new flavor to its product line: chia seeds and almonds. These ingredients have different order quantities and storage requirements than other ingredients already used in manufacturing. As it considers how to move forward, LFS must consider a number of issues regardingwarehousing and storage. What are some of the key priorities that it must consider?
Williams Inc. produces fluorescent lightbulbs for commercial use. The accounting manager isattempting to estimate the total cost for the next quarter using the high-low method. He has compileddata and found the high and low costs are $10,000 and $6,000, respectively, and the associated costdrivers are 7,000 and 3,000 packs, respectively. What is the value for b (the variable cost per unit)?What is the value for a (the fixed quantity)?
Two items are omitted from each of the following three lists of cost of goods sold data from a manufacturing company income statement. Determine the amounts of the missing items, identifying them by letter. Finished goods Inventory,June1 $61,600 $46,200 (e) Cost of goods manufactured 329,000 (c ) 484,800 Cost of finished goods available for sales (a) $260,400 $540,000 Finished goods Inventory ,June30 72,800 61,600 (f) Cost of goods sold (b) (d) $513,600

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