Question: i need to solve this by excel solver Example_1.5 A ship has three cargo holds: forward, aft and centre. The capacity limits are: Forward 2000

i need to solve this by excel solver

i need to solve this by excel solver Example_1.5

Example_1.5 A ship has three cargo holds: forward, aft and centre. The capacity limits are: Forward 2000 tons 100,000 cu ft Centre 3000 tons 135,000 cu ft Aft 1500 tons 30,000 cu ft The following cargoes are offered and the shipowners may accept all or any part of each commodity Commodity Amount Vol per ton Profit(/ton) A 6,000 60 6 B 4,000 50 8 2,000 25 5 Formulate an LP model to determine how the cargo should be distributed so as to maximise profits. 30

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

I need help with the following problems in document the Midterm Applied Business Modeling posted below. I have also attached my current progress (Midterm Exam BUSA 542) excel document so you can...

Week 3: No Plagiarism No content from other students papers. Post should be in APA 6th edition format, I will need References and in-text citations. This website should be useful for all APA...

read and analysis financial report, some strategy questions BACK COVER FRONT COVER OUTSIDE FLAP Contents Tesco PLC Annual Report and Financial Statements 2014 Strategic report IFC Tesco at a glance...

Two major themes from the introduction to module 4 are "Project Management" and "Managing Risk." Discuss, in depth, your analysis of the company's actions in relation to the concepts of these two...

1 What are the main components of personal financial planning? Solve What is the purpose of a financial plan? Solve Identify some common actions taken to achieve financial goals. How does a job...

H L RETAIL MATH: MARKUP MARKDOWN NEW REVISED REVISED MARKUP in New Markup Percentage After Markdown Rate New Retail Price CHANGE CHANGE Build the formulas Women's Wear using Excel ORIGINAL RETAIL...

Please use attached file 1. ?/1 pointsBerrFinMath1 3.1.001. Solve the system by graphing. (Enter your answers as a commaseparated list. If the system is inconsistent, enter INCONSISTENT. If the...

UNIVERISTY HELPP IN HERE NOT for TUTOR: dont submit if you dont do full THEM OR BAD RATE And in full explanation show all your work Solve the following system of nonlinear equations:x^2 + y^2 = 9 x^2...

HOMEWORK NOT for TUTOR: dont submit if you dont do full THEM OR BAD RATE And in full explanation show all your work Solve the following system of nonlinear equations:x^2 + y^2 = 9 x^2 - y^2 = 1 Find...

Tem Technology has a first-quarter operating loss of $100,000 and expects the following income for the other three quarters: Second quarter .......$ 80,000 Third quarter......... 160,000 Fourth...

Kragle Corporation reported the following financial data for one of its divisions for the year; average invested assets of $470,000; sales of $930,000; and income of $105,000. The investment center...

La empresa A tiene un total de 1 4 0 , 0 0 0 acciones, la empresa B , 5 0 , 0 0 0 , la empresa C , 2 0 , 0 0 0 , la empresa D , 1 0 , 0 0 0 y la empresa E , 3 0 , 0 0 0 . Encuentre el valor total de...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...