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...
-
Bruce Leichtman is president of Leichtman Research Group, Inc. (LRG), which specializes in research and consulting on broadband, media, and entertainment industries. In a recent survey, the company...
-
Which techniques comprise special offers and special communication methods?
-
What is the main difference between environmental accounting and ecological accounting?
-
HHG Consultants has been asked to analyze Carol & Carroll Co. (C&C), which has one retail division. C&C is concerned that it is not focused on its core mission of sales despite only having one...
-
Wasim takes out a loan on April 17, 2023 for $8,000 at a variable interest rate of 4% annually. On June 25, 2023 the interest rate increases to 4.25% annually. If Wasim repays the loan on September...
-
This unadjusted trial balance is for Challenger Construction at the end of its fiscal year, September 30, 2023. The beginning balance of the owners capital account was $46,000 and the owner invested...
-
Exercise B-13 (Algo) Present value of an amount and of an annuity LO P1, P3 Compute the amount that can be borrowed under each of the following circumstances: (PV of $1, FV of $1, PVA of $1, and FVA...
-
When walking on a flat surface, all the mechanical energy developed to move arms and legs is eventually dissipated into heat through various friction mechanisms because there is no change in overall...
-
On 1 May 2 0 1 5 , Cik Reeha, a chartered accountant with Harga Air Rumah Accountants and Partners advertised auditing services at RM 2 0 0 0 per client for a limitation period between 4 to 1 1 May 2...
-
0-1 2 1 0 3 0 0 1 Which of the following statements about the matrix M is true? Consider the matrix M: = Select one: a. M represents a rotation of -90, followed by a translation of vector (2, 3). b....
-
1. Suppose a monopolist Fp in the burgers market produces patties (p) at zero cost and the demand for patties is given by: = Qp-1-Pp-P where Qp is the quantity of patties demanded, P is the price of...
-
An object moving in a liquid experiences a linear drag force: B = (bv, direction opposite the motion), where b is a constant called the drag coefficient. For a sphere of radius R, the drag constant...
-
A student observes a very thick liquid as it flows and noticed that the velocity of particles passing through a particular point remains the same, and that the fluid layers move smoothly over each...
-
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...
-
Prove that van der Waals constants \((a, b)\) can be expressed in terms of critical temperature and pressure as follows: a = 27 R 2 T 2 c 64 P c b = R T c 8 P c a = 27 R 2 T c 2 64 P c b = R T c 8 P c
-
Justify the following statement with illustration: 'Violation of Kelvin-Planck statement leads to the violation of Clausius statement'.
-
Show that where \[ \left(\frac{\partial U}{\partial V} ight)_{T}=\frac{T \beta}{\kappa}-P \] \(\beta=\) Coefficient of volume expansion \(\kappa=\) Isothermal compressibility.
Study smarter with the SolutionInn App