Microsys Corp is located in Seattle, Washington. The company has developed the Websurfer, a low-cost high-speed...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Microsys Corp is located in Seattle, Washington. The company has developed the Websurfer, a low-cost high-speed wireless email and web-surfing appliance. This product is manufactured at two plants, located in Atlanta, and Seattle from parts sourced from domestic and international suppliers. After production, Websurfer are shipped to three of its regional distribution centers (RDC) located in San Jose and Houston to serve the USA market. Microsys sells the Websurfer mainly through retail channels. Its major customers selling the Websurfer are - GameStop, Best Buy and STEAM. According to contractual agreement, Microsys makes weekly shipments to the main warehouses (W) of these three retailers. The company uses its own fleet to supply the RDCs on a regular basis using TL shipping with an average cost per box with 10 units given in the table below: Plant Atlanta Seattle Shipping Cost ($/box) to RDC San Jose $3 $1.5 Houston $2.5 $3.5 RDC / Warehouse → San Bernardino San Jose Houston Customer demand (boxes of 10 units) Current distribution design calls for shipments from the RDCs to main warehouses specified by the customers. The customer is responsible for the pickup at the main warehouses and shipping to their retail stores. The company uses LTL shipments (via 3PL contractor) from RDC's to customers' warehouses. Shipping costs, and the weekly demand for boxes of 10 units are given in the table below: $8.5 $2.5 300 Memphis $4.5 $4 Capacity (units/week) 600 10500 8000 Chicago $6.5 $6.5 500 Orlando $7 $7.5 350 Assist Microsys with the design of this service network a. Draw a network diagram representation for this problem. b. Develop a production and distribution plan in Excel for Microsys Corp. that will minimize its service cost. c. Illustrate the final configuration of the service network d. Provide a transportation analytics report for this proposal. Break down distribution costs. e. f. If Memphis needs 100 more boxes, which RDC should supply? At what additional cost? Microsys is studying the possibility of supplying warehouses directly from plants using a dropship model. This initial negotiation with a carrier would allow a regular supply from Atlanta to Orlando for an estimated cost of $8.5 per box. What would change in the initial configuration? If the carrier increases cost by $1, would this option still make business sense? g. If the dropship model at $8.5 per box from Atlanta to Orlando is limited to no more than 150 boxes per week due to carrier capacity, how would that change the dropship model developed in f)? Microsys Corp is located in Seattle, Washington. The company has developed the Websurfer, a low-cost high-speed wireless email and web-surfing appliance. This product is manufactured at two plants, located in Atlanta, and Seattle from parts sourced from domestic and international suppliers. After production, Websurfer are shipped to three of its regional distribution centers (RDC) located in San Jose and Houston to serve the USA market. Microsys sells the Websurfer mainly through retail channels. Its major customers selling the Websurfer are - GameStop, Best Buy and STEAM. According to contractual agreement, Microsys makes weekly shipments to the main warehouses (W) of these three retailers. The company uses its own fleet to supply the RDCs on a regular basis using TL shipping with an average cost per box with 10 units given in the table below: Plant Atlanta Seattle Shipping Cost ($/box) to RDC San Jose $3 $1.5 Houston $2.5 $3.5 RDC / Warehouse → San Bernardino San Jose Houston Customer demand (boxes of 10 units) Current distribution design calls for shipments from the RDCs to main warehouses specified by the customers. The customer is responsible for the pickup at the main warehouses and shipping to their retail stores. The company uses LTL shipments (via 3PL contractor) from RDC's to customers' warehouses. Shipping costs, and the weekly demand for boxes of 10 units are given in the table below: $8.5 $2.5 300 Memphis $4.5 $4 Capacity (units/week) 600 10500 8000 Chicago $6.5 $6.5 500 Orlando $7 $7.5 350 Assist Microsys with the design of this service network a. Draw a network diagram representation for this problem. b. Develop a production and distribution plan in Excel for Microsys Corp. that will minimize its service cost. c. Illustrate the final configuration of the service network d. Provide a transportation analytics report for this proposal. Break down distribution costs. e. f. If Memphis needs 100 more boxes, which RDC should supply? At what additional cost? Microsys is studying the possibility of supplying warehouses directly from plants using a dropship model. This initial negotiation with a carrier would allow a regular supply from Atlanta to Orlando for an estimated cost of $8.5 per box. What would change in the initial configuration? If the carrier increases cost by $1, would this option still make business sense? g. If the dropship model at $8.5 per box from Atlanta to Orlando is limited to no more than 150 boxes per week due to carrier capacity, how would that change the dropship model developed in f)?
Expert Answer:
Answer rating: 100% (QA)
Lets break down this supply chain network design problem for Microsys Corp stepbystep a Network Diagram Representation A network diagram for this problem would include two plants San Jose and Atlanta ... View the full answer
Related Book For
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier
Posted Date:
Students also viewed these general management questions
-
Huiling owns a rental property on Main street, but she is considering selling the property to another real estate investor. In preparation for negotiating a price, Huiling wants to know the value of...
-
Aberdeen Computer Corp. (ACC) is located in Aberdeen, Washington. The company has developed the Web-Surfer, a low-cost e-mail and Web-surfing appliance. This product is manufactured at four plants,...
-
Norway has a long tradition of boatbuilding stretching back to before Viking times. This is due, no doubt, to Norways proximity to the sea, ample forests, and long coastline. Among luxury sailing...
-
The read-write head for a hand-held music player has a surface area of 0.04 mm. The head is held 0.04 m above the disk, which is rotating at a constant rate of 1800 rpm. Determine the torque T that...
-
Explain whether or not the volume of a metal specimen changes when the specimen is subjected to a state of (a) Uniaxial compressive stress and (b) Uniaxial tensile stress, all in the elastic range.
-
Distinguish between the verification model and the discovery model approaches to data mining.
-
Consider the following data: Required Use the above data to prepare the operating cash flow section of a consolidated statement of cash flows, using the indirect method. Consolidated net income.......
-
Stefani Company has gathered the following information about its product. Direct materials. Each unit of product contains 4.5 pounds of materials. The average waste and spoilage per unit produced...
-
. Exercise 11-9A (Static) Recording and reporting common and preferred stock transactions LO 11-4 Eastport Incorporated was organized on June 5, Year 1. It was authorized to issue 300,000 shares of...
-
Jessica is a sociologist who studies culture in the workplace at Company Y. She is designing a research study to get a better understanding of differences in productivity among mixed-gender teams and...
-
The Musicians' Guild has 949 members and three representatives. Calculate the Huntington-Hill number for the Musicians' Guild. What is the Huntington-Hill number for the Musicians' Guild? (Round to...
-
I am to set up a money market hedge for a small firm, for the interest rate, should I look for central bank interest rate, money market rate, or the bank lending/deposit rate?
-
A steam condenser employed in a power plant handles 35,000 kg of dry air per hour and saturated steam at 50 C. The cooling water enters the condenser at 15 C and leaves at 25 C. The tubes (made of...
-
Light of wavelength 295 nm is incident on a metallic surface of work function 1.73 eV. 1) What is the kinetic energy of the ejected electrons 2) What is the cutoff frequency of the metal 3) What is...
-
You are negotiating the rights to mine a gold field for the next 30 years. The initial investment, all the equipment and the operating license, would cost you a million dollars upfront. Then you...
-
K1 Describe the specific safety precautions to be taken whilst carrying out the assembly of trim components to the vehicle (including any specific legislation, regulations or codes of practice...
-
Write an essay describing the differing approaches of nursing leaders and managers to issues in practice. To complete this assignment, do the following: 1. Select an issue from the following list:...
-
Consider the Think-Big Development Co. problem presented in Section 3.2, including the spreadsheet in Figure 3.3 showing its formulation and optimal solution. In parts a-g, use the spreadsheet and...
-
Ralph Edmund loves steaks and potatoes. Therefore, he has decided to go on a steady diet of only these two foods (plus some liquids and vitamin supplements) for all his meals. Ralph realizes that...
-
a. Formulate and solve a linear programming model for this problem. b. What is your resulting recommendation to the school board? After seeing your recommendation, the school board expresses concern...
-
What are the two matching principles which characterise management accounting?
-
On the balance sheet equation show how the following transactions would be entered: (i) A purchase of fixed assets worth 500 000 from a supplier for payment in one month (show both the purchase...
-
Most large companies have a website that contains investor information such as the latest set of accounts and any other information relevant to shareholders. On the Internet locate the websites for...
Study smarter with the SolutionInn App