1. Companies A, B, and C supply components to three plants (F, G, and H) via two crossdockingfacilities (D and E). It costs $4 to ship from D regardless of final destination and $3 to ship to Eregardless of supplier. Shipping to D from A, B, and C costs $3, $4, and S5, respectively, andshipping from E to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide400, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 unitsrespectively. Crossdock facilities D and E can handle 800 and 700 units, respectively. LogisticsManager, Aretha Franklin, had previously used "Chain of Fools" as her supply chain consultingcompany, but now turns to you for some solid advice.What are total costs?

Cross-docking is the practice of dumping products from a producer or mode of transportation directly…

Answered: Companies A, B, and C supply components…

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

Q1. As a result of Covid 19, your management has decided that some key yield management analytics be manipulated in order to ensure cashflow for the hotel to survival the turbulence. As a result, you have been asked by management to look into how you can manage at least 50% occupancy for the first quarter, then an increment of 20% on the second quarter, 30% and 40% on the third and fourth quarters respectively. The total rooms available in your hotel is 920, and management expect a base revenue of GHS85,000.00. The base revenue of GHS85,000.00 is expected to increase by 20% on the second quarter, 30% and 40% on the third and fourth quarters respectively. 1. Identify the two most important yield management analytics (measures) that must be considered, offering explanations to what they are in hotel management. 2. Apply the formulas of these two measures to provide the actual figures that you expect to operate with, indicating the step-by-step stages of your calculations for clarity to…
Q1. Hotel manager Mr. Smith and his resourceful assistant, John, run a 26-room hotel in a little town. A combination of Mr. Smith's friendly attitude and the absence of a respectable hotel in the nearby vicinity imply that Mr. Smith enjoys sufficient demand at his low fare of $159 per night. John notes that some customers will walk into the hotel requesting a room for that evening and they are willing to pay a high fare of $325 per night. John knows this demand is variable. (In reality, this demand is U(4,9)) He suggests some rooms should be kept unsold to the low-fare customers so that they can serve the high-fare customers. a) To maximize profits with John's plan, what is the booking limit that should be set for low fare customers? b) Mr Smith does not like the idea of John and says “we will sell to everyone who reserves in advance and ignore the walk-in demand." If Mr Smith has his way, what will be the hotel's expected revenue? C) John replies, "If you are going to forgo the…
Q1. An LMN sugar mill company, department stores wish to purchase 10,000 handbags of which 2,000 are of style A, 2,000 are of style B, 3,000 of style C and 3,000 are of style D. Four manufacturers P, Q, R and S bid to supply not more than the following quantities, all styles combined. P= 1,500, Q = 2,600, R = 3,500 and S = 3,000. The following table gives the cost per handbag of each style of the bidders in RO. per handbag: Style Manufacturers P Q R S A 9 12 10 8 B 10 11 9 7 C 8 10 7 10 D 10 9 9 8 Use the transportation model to determine how should orders to be placed by the department store to minimize the total cost? Compare transportation cost by both models(NWCR and LCM)
Question 10.6 Storage Limited operates a 50-week working year. It produces a product called "GENERAL' for which demand any week in the year is described by the probability distribution below: Demand 2 3 4. 7 8. 9 Probability 0.07 0.10 0.11 0.13 0.15 0.17 0.13 0.08 0.04 0.02 Demand can only be satisfied (if at all) from stocks. The stockholding costs are N4 per item per year. Fixed costs per re-order are N16 and the variable, re-order costs are N30 per unit Lead time is one week. The costs of being out of stock are N12 per unit short. You are required to calculate: (i) The average weekly demand; [i] The Economic Order Quantity; [iv] The number of ordering cycles in the year; and [v] State briefly the main reason for holding inventory, and explain why good inventory management is a very important aspect of overall company management. [ii The average annual demand;
Q.No.2: Determine the type of scale (Nominal, Ordinal, Interval or Ratio) for the following examples. Age: _______________ Qualification: Intermediate Bachelor Master Phil. & Above Total work Experience in years: 1-5 6-10 11-15 16 & above Type of Organization ORIC R&D Firm Think tank Salary More than 15000 More than 25000 More than 45000 More than 95000 I love gardening. 1)Strongly Agree 2) Neutral 3)Disagree
A.3 Yellowburn University, a not-for-profit higher education organization, has the following mission statement: ‘We aim to deliver excellent tuition in state-of-the-art facilities to help develop socially responsible students and to contribute to global academic research.’ Which TWO of the following would be appropriate objectives to fit in with this mission? To deliver the best possible lessons. Each member of staff is to write two research papers for publication over the next two years. To increase car parking space at the university by 10% in the next 12 months to improve access. To get 15% of all students to receive first class honors degrees each year. To ensure 100% attendance from all students for every lecture.
Subject Name: Simulation & Modelling Q. Describe the following : • Simulation of a Multi-server queueing system • Simulation of an inventory system
Q1. General Appliance Corp. produces refrigerators at three plants: Marietta, Minneapolis and Phoenix. They ship them to major retail outlets in Chicago, Los Angeles and New York City. The accounting, production and marketing departments have provided the following information in the given tables; Plant capacities over the next planning period, retail outlet demand and unit cost of shipping between any plant and retail outlet. The company would like to minimize the cost of their transportation network by identifying how many units to ship between each plant and retail outlet. 1. Formulate this linear optimization problem by clearly listing the decision variables, objective function and constraints. 2. Create a spreadsheet model for this problem and solve it using Solver. What is the minimum cost? Plant Supply Marietta 1200 Minneapolis 800 Phoenix 1600 Retail Outlet Demand Chicago 650 Los Angeles 1450 New York City 1500…
#1 handwritten
M:26)
Q: Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 consider Cake (C) 0 -0.5 4.5 0.5 1E+30 $C$5 consider Dozen Cookies (D) 10 0 10 1E+30 1 what does the value minus .5 for the reduced cost of C mean (other than it is the change in thevalue of the coefficient in the objective function so that the solution includes a positive amountof C)?

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