Asean Aromatics, a manufacturer of perfumes and aromatic oils in India, has three manufacturing plants in Trichy,

Question:

Asean Aromatics, a manufacturer of perfumes and aromatic oils in India, has three manufacturing plants in Trichy, Vijayawada, and Mysore, and warehouses in Chennai, Cochin, and Vizag. The following table shows the shipping costs per hundred gallons between each manufacturing plant and warehouse, and the production capabilities (in hundreds of gallons) of each plant and the capacities (in hundreds of gallons) of each warehouse. The company would like to keep the warehouses filled to capacity to ensure most demand requirements are met.

To Production Capacity From Vizag Chennai Cochin Trichy Vijayawada Mysore Warehouse Capacity 10 $30 $50 $70 $40 $60 $40

1. Formulate this problem as a linear programming model. (Let X_ij = 100s of gallons of the product to be shipped from plant i to warehouse j.)

2. Solve the problem using Excel Solver.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Answer rating: 62% (8 reviews)

1 Subject to 2 The optimal shipping solution costs 920 and sen...View the full answer

Answered By

Asim farooq

I have done MS finance and expertise in the field of Accounting, finance, cost accounting, security analysis and portfolio management and management, MS office is at my fingertips, I want my client to take advantage of my practical knowledge. I have been mentoring my client on a freelancer website from last two years, Currently I am working in Telecom company as a financial analyst and before that working as an accountant with Pepsi for one year. I also join a nonprofit organization as a finance assistant to my job duties are making payment to client after tax calculation, I have started my professional career from teaching I was teaching to a master's level student for two years in the evening. My Expert Service Financial accounting, Financial management, Cost accounting, Human resource management, Business communication and report writing. Financial accounting : • Journal entries • Financial statements including balance sheet, Profit & Loss account, Cash flow statement • Adjustment entries • Ratio analysis • Accounting concepts • Single entry accounting • Double entry accounting • Bills of exchange • Bank reconciliation statements Cost accounting : • Budgeting • Job order costing • Process costing • Cost of goods sold Financial management : • Capital budgeting • Net Present Value (NPV) • Internal Rate of Return (IRR) • Payback period • Discounted cash flows • Financial analysis • Capital assets pricing model • Simple interest, Compound interest & annuities

4.40+ 65+ Reviews 86+ Question Solved

Related Book For book-img-for-question

Operations Management Managing Global Supply Chains

ISBN: 978-1506302935

1st edition

Authors: Ray R. Venkataraman, Jeffrey K. Pinto

See More Books

Question Posted: Nov 30, 2018 05:15 AM

See More Questions

Asean Aromatics, a manufacturer of perfumes and aromatic oils in India, has three manufacturing plants in Trichy,

Question:

To Production Capacity From Vizag Chennai Cochin Trichy Vijayawada Mysore Warehouse Capacity 10 $30 $50 $70 $40 $60 $40 $40 $30 7 $60 12 5

Step by Step Answer:

1 Subject to 2 The optimal shipping solution costs 920 and sen...View the full answer

Operations Management Managing Global Supply Chains

Students also viewed these Business questions