Find Initial Basic Feasible Solution:Plant€123Demand(i)(ii) Least Cost MethodNorth-West Corner MethodA84480Vogel's Approximation MethodB1462090WarehouseC748120D11610160Supply100200150

The following values of the cost of shipping from the three plants to four warehouses are provided.…

Answered: Find Initial Basic Feasible Solution:…

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

A producer of pottery is considering the addition of a new plant to absorb the backlog of demand that now exists. The primary location being considered will have fixed costs of $11,152 per month and variable costs of $1.23 per unit produced. Each item is sold to retailers at a price that averages $2.07 a) The volume per month is required in order to break even = Blank 1 (in whole number) b) The profit or loss would be realized on a monthly volume of 61,000 units Blank 2 c) The volume is needed to obtain a profit of $16,000 per month = Blank 3 (in whole number) d) The volume is needed to provide revenue of $23,000 per month = Blank 4 (in whole number)
solve it using solver with clear steps. please attach youe excel
Here is the initial tableau (by the NorthWest method) of a Min transportation problem. 1 2 3 Demand 19 Dual(v) 1 15 9 S1: 11 10 14 0 S2: 0 S3: B 0 B 3 N 15 Demanders 2 8 0 9 12 188 15 9 21 5 N 0 B 0 B 13 10 8 8 20 3 0 20 -4 N -6 N 0 B 17 7 5 4 0 0 1 -14 N -8 N 0 B Supply Dual(u) 0 (188 188 188 188 Using the Loop method fill in the values of the next tableau Each 2x2 matrix is the relevant square in the tableau. 9 (For grading convenience, in bottom right corner of each box use 1 for "B" and 0 for "N") 22 188 188 188 30 -4 2
1. The drug distribution company LOS PAISAS wants to build a new warehouse in Carretera a Masaya area in which they intend to store the following products: equipment and products for babies. With these products, they plan to serve a total of 10,000 pharmacies in Managua. Equipments Baby products Demand (quantity pharmacies served) 2,000 8,000 Cost per product $1,000.00 $30.00 To achieve balanced use of products, baby product must be equal to 60% of authorized product units. Additionally, the number of units requested in medical equipment must be at least 20% of the total authorized. There are a total of 10,000 pharmacies. The optimal plan needs to be determined to maximize the amount of products they must have to meet demand and maximize profits. Can you please explain it Step-by-step and typed? Thank you in advance!
Hickory Manufacturing Company forecasts the following demand for a product (in thousands of units) over the next five years. Year 1 2 3 4 5 Forecast demand 62 84 86 90 90 Currently the manufacturer has seven machines that operate on a two-shift (eight hours each) basis. Thirty days per year are available for scheduled maintenance of equipment with no process output. Assume there are 250 workdays in a year. Each manufactured good takes 20 minutes to produce. What is the effective capacity of the factory? Round your answer down to the nearest whole number. units/year Given the five-year forecast, how much extra capacity is needed each year? Use a minus sign to enter an answer, if there is excess capacity. Round your answers to the nearest whole number. Year 1 2 3 4 5 Extra capacity needed (units) Does the firm need to buy more machines? If so, how many? When? If your answer is zero, enter "0". Round your answers up to the nearest whole number.…
SUBJECT: Fundamentals of Business Analytics How does analytics be useful in the sector of: A. TourismB. AgricultureC. Economics
#4. The Pelican Company has four distribution centers (A, B, C, and D) that require 50,000, 40,000, 60,000 and 40,000 liters of diesel fuel, respectively, per month for their long-haul trucks. Three fuel wholesalers (1, 2 and 3) have indicated their willingness to supply as many as 60,000, 80,000, and 50,000 liters of fuel, respectively. The total cost (shipping and price) of delivering 1000 liters of fuel from each wholesaler to each distribution center is shown in the following table. Distribution center Wholesaler A B C D • 1 1700 1600 1600 1600 2 1500 1800 1600 1700 3 1800 1500 1800 1600 I. Determine the optimal solution. Check if all capacities have been exhausted and that all demands can be met with this solution. II. What is the total cost of the solution?
Please do not give solution in image formate thanku.
Q2. Al-Ward Company provides a product to different customers in different sectors. Managing director evaluated the company production capacity and decided to provide the product to only any one country from where they can earn maximum profit. On the basis of below information, solve question (a) and (b) below. Consider variable cost is 3.50 R.O per unit and fixed cost is 70000 R.O. Sales Per Unit (currency in R.O) Estimated Sales per year (units) *********** Selling and Overheads (Per Unit) Clothes 15.00 160,000 distribution 1.00 Manufacturing 22.00 140, 000 1.00 Food 5.00 410,000 1.00 (a) In which sector company should sale its product and why. Calculate profit for all three sectors. (b) Provide suggestions and recommendations based on analysis.
Q Let us assume that a new medical facility, Health-care, is to be located in XYZ city. The location factors, factor rating and scores for two potential sites are shown in the following table. Which is the best location based on factor rating method? Sr Location factor Factor Rating Rating Location 1 Location 2 1 Facility utilization 10 5 4 2 Total patient per month 8 4 2 3 Average time per emergency trip 5 4 5 4 Land and construction costs 6 3 4 5 Employee preferences 7 4 4 6 Operations Facility 8 4 3
S C 0 r e 4 b) 3.5 3+ 2.5 2 1.5 1 0.5 + 0 4 3.17 3.18 Malaysian Logistics Performance Index 3.45 3.49 Custom Logistics Efficiency Infrasturcture 3.65 Based on the above chart: a) 3.21 World Bank Logistics Performance Index 3.46 3.57 *Note: Score: 0 - Poor, 5- Excellent 3.34 Timeliness Track and Trace Quality and Logistics Cost Competency Malaysia Logistics Performance Index 3.52 Source: https://www.lpimy.com The above chart shows the comparison between the average Malaysia Logistics Performance Index (MLPI) and the World Bank Logistics Performance Index (WBLPI). Discuss five (5) key components measured in the survey. 3.48 The MLPI is a survey based measurement of the Malaysia logistics performance from the views of industry professionals. The objective of the survey is to evaluate the status of logistics performance for Malaysia. 3.28 Compare the trend of performance between MLPI and WBLPI.

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

Find Initial Basic Feasible Solution: (i) (ii) Plant 1 2 3 Demand A84 А 4 80 North-West Corner Method Least Cost Method Vogel's Approximation Method B 14 6 20 90 Warehouse C 7 4 8 120 D 1 16 10 160 Supply 100 200 150