Answered: Note: This question requires Solver.… | bartleby

Practical Management Science

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

Related questions

Question

A manufacturing firm has three 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:

| Factory (capacity) | Customer 1 (25) | Customer 2 (50) | Customer 3 (125) | Customer 4 (75) |
|--------------------|-----------------|------------------|------------------|------------------|
| A (100) | $15 | $10 | $20 | $17 |
| B (75) | $20 | $12 | $19 | $20 |
| C (100) | $22 | $20 | $25 | $14 |

Note: This question requires Solver.
Formulate the problem in Solver and find the optimal solution. What is the optimal quantity to ship from Factory A to Customer 2?

**Multiple Choice Question**

Select the correct number of units:

- ( ) 125 units
- ( ) 50 units
- ( ) 25 units
- ( ) 75 units
- ( ) 100 units

*Note: Each option is presented as a choice with a circular selection button next to it. Select one option to submit your answer.*

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 4 steps with 5 images

SEE SOLUTION Check out a sample Q&A here

Blurred answer

Similar questions

Davis Inc. produces three product lines in its manufacturing facility in St. John's, NL: Product Line (1), Product Line (2), Product Line (3). Davis is considering dropping Product Line (2) because it has been unprofitable for the past two years. Which of the following items is (are) irrelevant to Davis' decision to drop/keep Product Line (2)? O a) Total cost of rent on the manufacturing facility. O b) Customer demand for Product Line (2). Oc) Savings in direct materials cost associated with Product Line (2). O d) All of the above items are considered relevant in the decision.
Georgia Cabinets manufactures kitchen cabinets that are sold to local dealers throughout the Southeast. Because of a large backlog of orders for oak and cherry cabinets, the company decided to contract with three smaller cabinetmakers to do the final finishing operation. For the three cabinetmakers, the number of hours required to complete all the oak cabinets, the number of hours required to complete all the cherry cabinets, the number of hours available for the final finishing operation, and the cost per hour to perform the work are shown here: Cabinetmaker 1 Cabinetmaker 2 Cabinetmaker 3 Hours required to complete all the oak cabinets 47 40 27 Hours required to complete all the cherry cabinets 64 51 36 Hours available 40 30 35 Cost per hour $34 $41 $52 For example, Cabinetmaker 1 estimates it will take 47 hours to complete all the oak cabinets and 64 hours to complete all the cherry cabinets. However, Cabinetmaker 1 only has 40 hours available for the final…
a. Goods have to be transported from sources S1, S2 and S3, to destinations D1, D2 and D3. The transportation cost per unit capacities of the sources and requirements of destinations are given in the following table: Destination Source S1 S2 S4 D1 8 15 3 150 D2 5 10 9 Demand 80 50 Determine the transportation schedule so that cost is minimized. D3 6 12 10 Supply 120 80 80
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…
Problem 3 A shipping company is planning on purchasing three different types of boats: A, B and C. The relevant data is summarized in the following table: Cost (million $) per unit Seating capacity Expected profit ($) per unit A 6.5 • Required seating capacity: at least 660. • At most 8 type C boats may be purchased 45 150,000 B 7.8 75 218,000 The objective is to minimize the expansion costs under the following restrictions: • Required returns: $1,800,000. 60 175,000 с 9.2 • At most 12 boats in all. a. Formulate the linear program that represents this problem and solve it. For the purposes of this exercise you can assume that is possible to buy fractions of a boat, no need to make the variables integer. b. What is the optimal solution (purchase plan)? How many of each container should be purchased, and what should the resultant cost be? c. Suppose that the requirement of at least 660 for seating capacity is reduced to 650. Without resolving the problem, can you determine how this would…
Problem 2 The University of South Wisconsin has had steady enrollments over the past five years. The school has its one bookstore, called University Book Store, but there are also three private bookstores in town: Bill’s Book Store, College Book Store, and Battle’s Book Store. The university is concerned about the large number of students who are switching to one of the private stores. As a result, South Wisconsin’s president, Andy Lange, has decided to give a student three hours of university credit to look into the problem. The following matrix of transition probabilities was obtained: University Bill’s College Battle’s University 0.5 0.2 0.2 0.1 Bill’s 0.1 0.6 0.2 0.1 College 0.1 0.1 0.7 0.1 Battle’s 0.05 0.1 0.1 0.75 At the present time, market shares for University, College, Battle’s and Bill’s book stores are 0.3, 0.3, 0.2, 0.2. What will the market share…
(Problem 1) A manager of Drexel Clothing Company has to make a decision on shipping. There are two shippers, A and B. Both offer a two-day rate: A for $500 and B for $525. In addition, A offers a three-day rate of $450 and a nine-day rate of $325 and B offers a four-day rate of $400 and a seven-day rate for $375. Annual holding costs are 25% of unit price. Four hundred boxes are to be shipped, and each box has a price of $250. The shipping charges are for the entire batch of 400 boxes. Which shipping alternative would you recommend? Explain.
9-7 The management of the Executive Furniture Corporation decided to expand the production capacity at its Des Moines factory and to cut back the production capacities at its other two factories. It also recognizes a shifting market for its desks and revises the requirements at its three warehouses. The table on this page provides the requirement at each of the warehouses, the capacity at each of the factories, and the shipping cost per unit to ship from each factory to each warehouse. Find the least-cost way to meet the requirements given the capacity at each factory.
Chapter 5: Food Goblin Supermarkets use both cashiers and baggers to serve customers at check out. During the peak hours, 8 cashiers and 6 baggers serve approximately 75 customers per hour. On average, a cashier spends 6 minutes at checkout and a bagger spends 4 minutes at bagging to serve a customer. Calculate the utilization of cashiers and their capacity cushion during a peak hour?
The demand for subassembly Sis 130 units in week 7. Each unit of S requires 1 unit of T and 2 units of U. Each unit of T requires 1 unit of V. 1 unit of W. and 2 units of X. Finally, each unit of U requires 2 units of Y and 3 units of Z One firm manufactures all items It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U. 1 week to make V. 3 weeks to make W. 2 weeks to make X. 2 weeks to make Y, and 2 weeks to make Z W Click the icon to view the product structure and the time-phased product structure. In addition to 130 units of S, there is also a demand for 30 units of U, which is a component of S. The 30 units of U are needed for maintenance purposes These units are needed in week 6 Modify the gross material requirements plan to reflect this change (type 0f the input bax is nat used) Lead Time (weeks) Week Item Gross req Order release The product structure. The time-phased product structure. Level Q V W U/2) X Y 2 V(1) W1) X2) Y(2) Z3) 4 6. Time in weeks -co
Problem 20-36 (Algo) Palin's Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to manage inventory of this standard muffler. Use the information in the following table to determine the optimal inventory target level (or order-up-to level). Annual demand standard deviation of daily demand Item cost Annual holding cost Review period 2, 240 6 $35.00 20 28 Optimal target level mufflers mufflers per working day per muffler % of item value working days Ordering cost Service probability Lead time Working days $60 per order 89 % 2 working days per year 280 a. What is the optimal target level (order-up-to level)? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.)
The manager of a company wishes to assign three jobs to four machines on one-on-one basis. The cost of each job on each machine if given on the following table. Solve it through Branch and Bound on Assignment Problem.

Recommended textbooks for you

Practical Management Science

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

Operations Management

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

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

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

Operations Management

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

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

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

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…

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS