A company commercializes his products,manufactured in 3 different factories, in 3 different regions. The capacity of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A company commercializes his products,manufactured in 3 different factories, in 3 different regions. The capacity of factories is 200, 160, and 90 pallets of product respectively. The demand of regions is 180, 120,150 pallets of product respectively. Unit cost of transportation is given below: Dist./Factory 1 2 3 1 16 14 36 2 20 8 24 3 12 18 16 If any circumstance of not supplying the demand .Find the optimal solution for the transportation model (on Excel) A company commercializes his products,manufactured in 3 different factories, in 3 different regions. The capacity of factories is 200, 160, and 90 pallets of product respectively. The demand of regions is 180, 120,150 pallets of product respectively. Unit cost of transportation is given below: Dist./Factory 1 2 3 1 16 14 36 2 20 8 24 3 12 18 16 If any circumstance of not supplying the demand .Find the optimal solution for the transportation model (on Excel)
Expert Answer:
Answer rating: 100% (QA)
stepby atch is open Mi Excel and spredsheet foll empty u Set up ta... View the full answer
Related Book For
Financial Institutions Management A Risk Management Approach
ISBN: 978-0071051590
8th edition
Authors: Marcia Cornett, Patricia McGraw, Anthony Saunders
Posted Date:
Students also viewed these banking questions
-
To answer the following questions use the financial statements for Home Depot, Inc., in Appendix A at the end of the textbook: a. Compute the companys current ratio and quick ratio for the most...
-
A money market mutual fund manager is looking for some profitable investment opportunities and observes the following one-year interest rates on government securities and exchange rates: rUS = 12%,...
-
Use the diagram to answer the following questions (ac). a. At the initial equilibrium price, what area represents consumer surplus? What area represents producer surplus? b. After the price ceiling...
-
Which of the following statements about Visa credit card sales is incorrect? (a) The credit card issuer makes the credit investigation of the customer. (b) The retailer is not involved in the...
-
Consider again the situation in Problem 15.16. Suppose that the portfolio has a beta of 2.0, the risk-free interest rate is 5% per annum, and the dividend yield on both the portfolio and the index is...
-
If an event is unforeseeable, how can a good contingency plan help?
-
Asphalt at \(120^{\circ} \mathrm{F}\), considered to be a Newtonian fluid with a viscosity 80,000 times that of water and a specific gravity of 1.09, flows through a pipe of diameter \(2.0...
-
The Midwest Division of the Paibec Corporation manufactures subassemblies that are used in the corporations final products, Lynn Hardt of Midwests Profit Planning Department has been assigned the...
-
The solid shaft of radius r = 0.5 inches and shear modulus G = 10,000ksi is subjected to the torques shown, and T = 10,000lb - in. At the surface of the shaft, the angle between the "line before...
-
Elizabeth is moving from a one bedroom apartment in one city to a similar apartment in another city. She has been quoted a flat fee for the truck rental and has two estimates for wages of the movers...
-
Explain in detail the static trade-off theory of capital structure. The reader should clearly understand each individual component involved in the trade-off. What does this theory have to say about...
-
A 20 kVA, 1000 V/200 V, 50 Hz single-phase transformer gave the following test results:- Open Circuit Test: 200 V, 3.5 A, 400 W on L.V. side Measurement Short Circuit Test: 50 V, 30 A, 1200 W on H....
-
The IRS can impose a penalty of 75% of the underpayment in what circumstance? When the underpayment is caused by losses in investment securities. When the taxpayer is shown to have intentionally...
-
liabilities divided by assets amount saved each month divided by gross income liquid assets divided by current liabilities liquid assets divided by monthly expenses. How is the savings ratio...
-
"Imagine you are going to build e-commerce software for an online store. The software will need authentication and there are two kinds of users, the customer, and the administrator. The customer can...
-
Data for M. Oriole, interior decorator, are presented as follows. Jan. 2 Invested $13,900 cash in business. 3 9 11 16 20 23 28 Purchased used car for $4,170 cash for use in business. Purchased...
-
If 8 , 0 0 0 units are produced, what is the total amount of manufacturing overhead cost incurred to support this level of production? What is this total amount expressed on a per unit basis?Martinez...
-
Prove the following D,(cos x) = - sin x (Hint: Apply the identity cos(A + B) = cos A cos B sin A sin B)
-
An FI has purchased a $200 million cap of 9 percent at a premium of 0.65 percent of face value. A $200 million floor of 4 percent is also available at a premium of 0.69 percent of face value. a. If...
-
Why is the measurement of market risk important to the manager of a financial institution?
-
An FI is planning to hedge its $100 million bond instruments with a cross hedge using Eurodollar interest rate futures. How would the FI estimate br = [(Rf/(1+Rf) / (R/(1+R)] to determine the exact...
-
Fran frequently attends flea markets looking for good bargains. On a recent trip, she purchased a nightstand for \($25\) and an armoire for \($45.\) When she got them home and took a closer look, she...
-
Tanika passed away in the current year and her daughter, Shanika, received life insurance proceeds of \($500,000.\) Tanika had paid \($12,000\) in premiums on the life insurance policy to date....
-
Todd has received the following payments in the current year: How much must Todd include in his income? Unemployment compensation Food stamps $12,000 $ 1,500 Lottery winnings $ 1,000 Gambling...
Study smarter with the SolutionInn App