Please do fast ASAP fast Firm XYZ makes custom outfits in three tailoring shops in Albany, Boston, and Hartford. These outfitsare further shipped to the finishing facilities in Charlotte and Richmond. In the end, the final productswill be shipped to the clients based in Dallas, Louisville, Memphis, and Nashville.The company had the following orders: 450 from Dallas, 300 from Louisville, 275 fromMemphis, and 400 from Nashville. The shop in Albany can make up to 450 outfits, the Boston shopdoes up to 500 outfits, and the Hartford shop does up to 580 outfits. The unit shipping cost is $40from Albany to Charlotte, $55 from Albany to Richmond, $43 from Boston to Charlotte, $50 fromHartford to Charlotte, $46 from Boston to Richmond, and' $50 from Hartford to Richmond. Similarly,Nashville. The unit shipping cost is $30 from Richmond to Dallas, $47 to Louisville, $41 to Memphis,and $45 to Nashville. Assume all other information is the same, what is the minimized cost to satisfyall orders the company has? (Please provide your answer without any symbols and comma, such as11999)

Answered: Firm XYZ makes custom outfits in three…

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

Amy Zeng, owner ofZeng's Restaurant Distributions,supplies nonperishable goods to restaurants around the metroarea. She stores all the goods in a storage area with a single dockand one aisle. The goods are divided into five categories accordingto the following table. The table indicates the number of tripsper month to store or retrieve items in each category, as well asthe number of storage blocks taken up by each. The following picture of the storage area provides an identificationnumber for each of the 16 storage blocks. For each item category,indicate into which blocks it should be stored.
Accompany makes two products (1&2) each product requires time on two machines (A&B). specification for each product is as follows. Product1 product2 Processing time on Machine A (hrs/unit) 2 2 Processing time on Machine B (hrs/unit) 1 2 Material and labour cost ( ksh/unit) 14 15 Selling price (ksh/unit) 16 18 Maximum possible sale (units) 130 150 The amount of time available on machine A is 360 hours and on machine B is 260 hours. Formulate the linear programme which, when…
Radiant wants to hire planes to transport three types of goods- A, B, and C. They contacted VIP Transportation Company to hire Cargo planes. VIP informed that they can provide two types of Cargo Planes, and they have only 80 of each type of plane. In addition they provided the following Weight related information about the two types Cargo planes- WT88 and BH54: Goods A Goods B Goods C WT88 Can carry 20 tons 10 tons 20 tons BH54can carry 25 tons 20 tons 15 tons Radiant has to transport 500 tons of Goods A, 500 tons of Goods B, and 500 tons of Goods C. VIP charges $2800 for each WT88 and $1200 for BH54. Under the above circumstances, find out the following using Linear Programming: What will be the minimum cost to transfer the required goods? How many of WT88 and BH54 Radiant should hire? Can you check my answer is correct? Data Goods A Goods B Goods C VIP Charge WT88 can carry 20 10 20 $…
Radiant wants to hire planes to transport three types of goods- A, B, and C. They contacted VIP Transportation Company to hire Cargo planes. VIP informed that they can provide two types of Cargo Planes, and they have only 80 of each type of plane. In addition they provided the following Weight related information about the two types Cargo planes- WT88 and BH54: Goods A Goods B Goods C WT88 Can carry 20 tons 10 tons 20 tons BH54can carry 25 tons 20 tons 15 tons Radiant has to transport 500 tons of Goods A, 500 tons of Goods B, and 500 tons of Goods C. VIP charges $2800 for each WT88 and $1200 for BH54. Under the above circumstances, find out the following using Linear Programming: What will be the minimum cost to transfer the required goods? How many of WT88 and BH54 Radiant should hire? Can you use MS Excel solver to do this?
A chocolate maker has contracted to operate a small candy counter in a fashionable store. To startwith, the selection of offerings will be intentionally limited. The counter will offer a regular mixof candy made up of equal parts of cashews, raisins, caramels, and chocolates, and a deluxe mixthat is one-half cashews and one-half chocolates, which will be sold in one-pound boxes. In addition, the candy counter will offer individual one-pound boxes of cashews, raisins, caramels, andchocolates.A major attraction of the candy counter is that all candies are made fresh at the counter. However, storage space for supplies and ingredients is limited. Bins are available that can hold theamounts shown in the table.IngredientCapacity(pounds per day)Cashews 120Raisins 200Caramels 100Chocolates 160In order to present a good image and to encourage purchases, the counter will make at least 20boxes of each type of product each day. Any leftover boxes at the end of the day will be removedand given to a…
You own wheat warehouse with capacity of 20,000 bushels. At the beginning of month 1, you have 6,000 bushels of wheat. Each month, wheat can be bought and sold at the price per 1000 bushels given in the table Month Selling price ($) Purchase prie ($) 1 3 8 2 6 8 3 7 2 4 1 3 5 4 4 6 5 3 7 5 3 8 1 2 9 3 5 10 2 5 The sequence of events during each month is as follows: a. You observe your initial stock of wheat. b. You can sell any amount of wheat up to your initial stock at the current month's selling price. c. You can buy(at the current month's buying price) as much wheat as you want, subject to the warehouse size imitation. Your goal is to formulate an LP that can be used to determine how to maximise the profit earned over the next 10 months and solve using Excel solver or AMPL
Maxwell Manufacturing makes two models of felt tip marking pens. Requirements for each lot of pen...Maxwell Manufacturing makes two models of felt tip marking pens. Requirements for each lot of pens are given below.Fliptop Model Tiptop Model AvailablePlastic 3 4 36Ink Assembly 5 4 40Molding Time 5 2 30The profit for either model is $1000 per lot.What is the linear programming model for this problem?What are the boundary points of the feasible region?What is the profitability at each boundary point of the feasible region?Find the optimal solution.
A consulting firm has four projects to consider. Each project will require time (in days) in the next three months according to the table below. Project Time in first month Time in second month Time in third month Revenue A 6 8 6 22000 B 5 6 8 18000 C 8 7 6 16000 D 5 5 4 15000 Revenue from each project is also shown. There is 20 days’ time available in the first month, 22 days’ time available in the second month, and 22 days’ time available in the third month to do these projects. The management wants to select at most 3 projects. If project B is selected, then project C must also be selected. The objective of the firm is to maximize the total revenue. Formulate an integer optimization model for this problem by defining the decision variables, the objective function and all the constraints.…
Hawkins Manufacturing Company produces connecting rods for 4- and 6-cylinder automobile engines using the same production line. The cost required to set up the production line to produce the 4-cylinder connecting rod is $2,000, and the cost required to set up the production for the 6-cylinder connecting rod is $3,500. Manufacturing costs are $15 for each 4-cylinder connecting rod and $18 for each 6-cylinder connecting rod. Hawkins makes a decision at the end of each week as to which product will be manufactured the following week. If a production changeover is necessary from one week to the next, the weekend is used to reconfigure the production line.Once the line has been set up, the weekly production capacities are 6,000 6-cylinder connecting rods and 8,000 4-cylinder connecting rods. Letx4 = the number of 4-cylinder connecting rods produced next week,x6 = the number of 6-cylinder connecting rods produced next week,s4 = 1 if the production line is set up to produce the 4-cylinder…
TJ, Inc., makes three nut mixes for sale to grocery chains located in the Southeast. The three mixes, referred to as the Regular Mix, the Deluxe Mix, and the Holiday Mix, are made by mixing different percentages of five types of nuts. In preparation for the fall season, TJ, Inc., purchased the following shipments of nuts: Type of Nut Shipment Amount (pounds) Almond 6000 Brazil 7500 Filbert 7500 Pecan 6000 Walnut 7500 The Regular Mix consists of 15% almonds, 25% Brazil nuts, 25%filberts, 10% pecans, and 25% walnuts. The Deluxe Mix consists of 20% of each type of nut, and Holiday Mix consists of 25% almonds, 15% Brazil nuts, 15% filberts, 25% pecans, and 20% walnuts. An accountant at TJ, Inc., analyzed the cost of packaging materials, sales price per pound, and so forth, and determined that the profit contribution per pound is $1.85 for the Regular Mix, $2.10 for the Deluxe Mix, and $2.15 for the Holiday Mix. These figures do not include the cost…
Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database information, he has determined the daily requirements for part-time loading dock personnel. The distribution center operates 7 days a week, and the daily part-time staffing requirements are Day M T W Th F S Su Requirements 7 3 5 5 6 2 2 Find the minimum number of workers Glynn must hire. Prepare a workforce schedule for these individuals so that each will have 2 consecutive days off per week and all staffing requirements will be satisfied. Give preference to the S-Su pair in case of a tie. (Note: If there is a tie that cannot be broken by following the preference to the S-Su pair, choose the pair closest to the beginning of the considered week.) Part 2 The minimum number of workers is _________workers. (Enter your response as a…
Gerald Glynn manages the Michaels Distribution Center. After careful examination of his database information, he has determined the daily requirements for part-time loading dock personnel. The distribution center operates 7 days a week, and the daily part-time staffing requirements are Day M T W Th F S Su Requirements 7 3 4 4 5 4 5 Find the minimum number of workers Glynn must hire. Prepare a workforce schedule for these individuals so that each will have 2 consecutive days off per week and all staffing requirements will be satisfied. Give preference to the S-Su pair in case of a tie. (Note: If there is a tie that cannot be broken by following the preference to the S-Su pair, choose the pair closest to the beginning of the considered week.) The minimum number of workers is 7 workers. (Enter your response as a whole number.) Specify the workforce schedule for each employee by indicating the day offs (other days are considered to be…

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