A company manufactures a product at its plants in A, B, and C,then ships the product to six customers in G, H, J, K, and L.The monthly capacity of plants A, B, and Care7300, 7400, and 7500 units, respectively.The monthly demand from customers G, H, J, K, and Lare.1200, 8900, 7600, 2600, and 1500 units, respectively.Use Excel Solver to find the optimal distribution plant that will givethe lowest total monthly shipping cost if the shipping cost per unit (in dollars per unit)are as follows:from A to G, H, J, K, and L are 4, 9, 20, 6, and 13 dollars per unit, respectively;from B to G, H, J, K, and Lare 7, 6, 12, 2, and 9 dollars per unit, respectively;from C to G, H, J, K, and Lare 12, 7, 3, 17, and 6 dollars per unit, respectively.The optimal total shipping costs isdollars per month

transportation problems can be solved using excel solver as shown below. transportation problems are…

Answered: A company manufactures a product at its…

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

Formulate but do not solve the problem.The management of Hartman Rent-A-Car has allocated $2.25 million to buy a fleet of new automobiles consisting of compact, intermediate-size, and full-size cars. Compacts cost $18,000 each, intermediate-size cars cost $27,000 each, and full-size cars cost $36,000 each. If Hartman purchases twice as many compacts as intermediate-size cars and the total number of cars to be purchased is 100, determine how many cars of each type will be purchased. (Assume that the entire budget will be used. Let x, y, and z denote the number of compact, intermediate-sized, and full-size cars purchased, respectively.) = 2,250,000 = x = 100
North Dakota Electric Company estimates its demand trend line (in millions of kilowatt hours) to be: D = 77.0 +0.43Q, where Q refers to the sequential quarter number and Q = 1 for winter of Year 1. In addition, the multiplicative seasonal factors are as follows: Quarter Winter Spring Summer Fall In year 26 (quarters 101-104), the energy use for each of the quarters beginning with winter is (round your response to one decimal place): Quarter Winter Factor (Index) 0.80 1.20 1.40 0.60 Spring Summer Fall Energy Use
Product: Online shopping site that focusing on school supplies Give Problem statement and proposed solution of this product with this format proposed solution there we will introduce the service or our product. Problem statement, there are those we have observed that problem want to isolve using our product or service
Answer correctly using excel and show workings
D1.
Klein Chemicals, Inc., produces a special oil-based material that is currently in short supply. Four of Klein's customers have already placed orders that together exceed the combined capacity of Klein's two plants. Klein's management faces the problem of deciding how many units it should supply to each customer. Because the four customers are in different industries, different prices can be charged because of the various industry pricing structures. However, slightly different production costs at the two plants and varying transportation costs between the plants and customers make a "sell to the highest bidder" strategy unacceptable. After considering price, production costs, and transportation costs, Klein established the following profit per unit for each plant-customer alternative. Plant Clifton Springs Danville Plant Clifton Springs 2 Danville D₁ D3 D₂ $32 $34 $32 $40 $38 $34 $30 $28 The plant capacities and customer orders are as follows. Customer Capacity (units) 5,000 3,000 3 4…
A bank is trying to determine which of two machinesshould be rented to process checks. Machine 1 rents for$10,000 per year and processes 1,000 checks per hour.Machine 2 rents for $15,000 per year and processes 1,600checks per hour. Assume that the machines work 8 hours aday, 5 days a week, 50 weeks a year. The bank must processan average of 800 checks per hour, and the average checkprocessed is for $100. Assume an annual interest rate of20%. Then determine the cost to the bank (in lost interest)for each hour that a check spends waiting for and undergoingprocessing. Assuming that interarrival times and servicetimes are exponential, which machine should the bank rent?
NOTE: The answer of this question should be limited to ONE page of writing with reasonable size of fonts. The provincial government plans to distribute certain types of vaccines to the 3 major urban centers of the province covering a large portion of the provincial population. The 5 million doses of vaccines are expected to arrive in large batches at one of the major cargo airports by 2 military transporter airplanes in a single day. The vaccines will then be distributed to the 3 cities with the number of doses corresponding to the population sizes of the 3 cities. They will be further distributed to the 20 hospitals and about 200 local clinics in these 3 cities. Officials of the provincial health agency must plan for the upcoming vaccine distribution. Assume that you are asked to suggest several methods/tools in Industrial Engineering and Operations Research you have learned from this course. Present 3 such methods and for EACH of these methods, briefly explain: 6.1) For solving which…
Can you solve it mathematically using an equation?
Formulate the situation in matrix form. Be sure to indicate the meaning of your rows and columns. Find the requested quantities using the appropriate matrix arithmetic. A car dealer sells sedans, station wagons, vans, and pickup trucks at sales lots in Oakdale and Roanoke. The "dealer markup" is the difference between the sticker price and the dealer invoice price. The dealer invoice prices at both locations are the same: $15,000 per sedan, $19,000 per wagon, $24,000 per van, and $26,000 per pickup. The sticker prices at the Oakdale lot are $18,900 per sedan, $23,900 per wagon, $28,900 per van, and $28,900 per pickup, while at the Roanoke lot the sticker prices are $17,900 per sedan, $22,900 per wagon, $26,900 per van, and $30,900 per pickup. Represent these prices as a dealer invoice matrix D and a sticker price matrix S. Use these matrices to find the dealer markup matrix M for these vehicles at these sales lots. (Let row 1 represent the dealer in Oakdale and row 2 represent the…
A company possesses two manufacturing plants, each of which can produce three products, X, Y, and Z, from a common raw material. However, the proportion in which the products are produced differs in each plant, and so are plant's operating costs per hour. Data on production per hour and costs are given below, together with current orders in hand of each product. Products Operating cost per hour Y Plant A 4 9. Plant B 4 2 10 Orders on hand 50 24 60 Formulate the above as a linear programming problem. Find the number of production hours needed to fulfill the orders on hand at minimum cost using the using Big M method.
Jing's Pizza wants to know to whether customers will buy the new Fancy Feijoa pizza. You are the owner's son/daughter and your mum (the owner) knows you have just completed a paper in business analytics. She asks (or tells!) you to come up with a plan to answer her question. Luckily, she has a database of frequent customers in an excel spreadsheet. You go through your notes and decide that you will use clustering and find groups of similar customers in her spreadsheet. 1. Identify the data that might use for customers who will buy the new Pizza. 2. What plan or alternative plan might use to sell the pizza?11:35 AM

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