3.4-9. Web Mercantile sells many household products through anon-line catalog. The company needs substantial warehouse spacefor storing its goods. Plans now are being made for leasing ware-house storage space over the next 5 months. Just how much spacewill be required in each of these months is known. However, sincethese space requirements are quite different, it may be most eco-nomical to lease only the amount needed each month on a month-by-month basis. On the other hand, the additional cost for leasingspace for additional months is much less than for the first month,so it may be less expensive to lease the maximum amount neededfor the entire 5 months. Another option is the intermediate approachof changing the total amount of space leased (by adding a new leaseand/or having an old lease expire) at least once but not every month.The space requirement and the leasing costs for the variousleasing periods are as follows:RequiredMonth Space (Sq. Ft.)Leasing Period Cost per Sq. Ft.(Months)Leased1$ 6530,00020,00040,00010,00050,000122$1003$135$16045$190The objective is to minimize the total leasing cost for meeting thespace requirements.(a) Formulate a linear programming model for this problem.c (b) Solve this model by the simplex method.

Answered: Required Month Space (Sq. Ft.) Leasing…

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

pls answer ASAP
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…
5. Myco is considering the introduction of three new products. For each product, thelabor and raw material requirements per unit produced are shown in the followingtable.Labor Raw Materials ProfitProduct (hours/unit) (pounds/unit) ($/unit)1 3 4 252 4 3 303 5 6 22Myco must pick one of its two plants to produce these three new products. If Mycouses the East Plant, there will be 100 labor hours and 100 pounds of raw materialsavailable each day. If Myco uses the West Plant, there will be 90 labor hours and 120pounds of raw materials available each day.Formulate an integer program to help Myco determine which plant to use and howmuch of each product to produce at the selected plant. (Only whole units can beproduced.) The objective is to maximize profit. Make sure to define your variablesand provide a brief yet descriptive label for your constraints
The Ace Manufacturing Company has orders for three similar products. Product Min A s.t. B C 1 2 Machine 3 Three machines are available for the manufacturing operations. All three machines can produce all the products at the same production rate. However, due to varying defect percentages of each product on each machine, the unit costs of the products vary depending on the machine used. Machine capacities for the next week and the unit costs are shown below. A A LB B Ic C Product 4 2 3 Orders (units) Machine 1 Capacity Product A Orders Machine 2 Capacity Product B Orders Machine 3 Capacity Product C Orders 1,800 X20 for all i, j. 700 1,100 Capacity (units) 1,400 (a) Develop the linear programming formulation of this problem. (Let x₁ be the number of units of product A produced by XA1 machine 1, x,, be the number of units of product i produced by machine j, etc.) 1,500 1,000 1 Machine $1.00 $1.30 $1.10 2 $1.20 $1.40 $1.00 $0.90 $1.20 $1.20 3 (b) Solve the transportation model for the…
33 White & Becker Tools (W&B) requires 2,000 elec- tric motors next month for its product line of weed trimmers. Each motor is composed of three com- ponents: a coil, a shaft, and housing. W&B has the capability to produce these components or purchase them from an outside vendor. The costs of produc- ing them and purchasing them are shown in the following table. COMPONENT Coil Shaft Housing DEPART- MENT PRODUCTION COST PER UNIT Fabrication 0.5 Molding 0.4 Inspection 0.2 $2.60 $1.80 $1.40 The components that are produced by W&B must pass through three departments: fabrication, molding, and inspection. The number of hours each component requires in each department and the total number of hours available next month in each department are shown in the following table: 0.2 0.7 0.3 PURCHASE COST PER UNIT COIL SHAFT HOUSING AVAILABILITY (HR.) (HR.) (HR.) (HR.) $3.12 $2.16 $1.68 0.6 0.3 0.4 3,000 3,000 1,800 In order to determine the number of components that will be produced and the number…
5. Common resources versus private goods Spring is here, and Cho and her dad would like to go fishing for the weekend in New Hampshire. Cho could either go to the river in town where anyone can fish without a permit, or she could drive up to a pond located on her family's property PRIVATE PROPERTY in the countryside to fish. Assume that, no matter where people fish, all of the fish that are caught would be kept (that is, there is no "catch and release" policy). The fish in the private pond are considered and whereas the fish in the river are and In other words, the fish in the private pond are an example of and the fish in the river are an example of Fishing in the river will likely lead to because of which of the following reasons? All fishermen will choose to fish in the pond believing that there are more fish there. All fishermen will choose to fish in the river because of the limited access to the pond. Anyone can fish in the river, and one person's fishing activity decreases the…
L.P. Model: Minimize Subject to: Z = 15X+12Y 7X+11Y288 (C₂) (C₂) 16X+4Y280 X,Y 20 On the graph on right, constraints, C, and C₂ have been drawn. Using the point drawing tool, plot all the corner points for the feasible area. 24- 22- 20- 18- 16- 14- 12- 10 8- 64 4- 2- -N 10 12 14 16 18 20 22 24 X C G
Consider an assignment issue that has the following cost table. a. Draw a network representation of this assignment problem.b. Formulate this problem as a transport problem by drawing up the appropriate parameter table.c. Determine the optimal assignment solution using the Hungarian method!d. Use Excel Solver to get the optimal solution.
Q: The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below: Material (measured in square inches) Model 1 Model 2 Model 3 Material Available Cardstock 12 10 14 1200 Satin 24 20 15 2000 Plain fabric 40 40 30 7500 Leather 11 11 10 1000 Profit per model $50 $44 $40 a) Generate the Sensitivity Report in EXCEL for the model that you built. Interpret, in context, the Shadow Price for the Leather and the Satin constraints. Include units in your interpretations.

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