Related questions
PLEASE USE EXCEL
Paul Bergey is in charge of loading cargo ships for International Cargo Company
(ICC) at the port in Newport News, Virginia. Paul is preparing a loading plan for an ICC freighter destined for Ghana. An agricultural commodities dealer wants to transport the following products aboard this ship.
Commodity Amount Available Volume per Ton Profit per Ton
(tons) (cubic feet) ($)
A 4,800 40 70
B 2,500 25 50
C 1,200 60 60
D 1,700 55 80
Paul can elect to load any and/or all of the available commodities. However, the
ship has three cargo holds with the following capacity restrictions.
Cargo Hold Weight Capacity Volume Capacity
(tons) (cubic feet)
Forward 3,000 145,000
Center 6,000 180,000
Read 4,000 155,000
More than one type of commodity can be placed in the same cargo hold. However,
because of balance considerations, the weight in the forward cargo hold must be
within 10% of the weight in the rear cargo hold, and the center cargo hold must be
between 40% and 60% of the total weight on board.
1. Formulate the LP model for this problem.
2. Create the spreadsheet model and use Solver to solve the problem.
Trending nowThis is a popular solution!
Step by stepSolved in 6 steps with 7 images
- ch.12arrow_forwardhelp please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all workingarrow_forwardeBook Show Me How Print Item Decision on Accepting Additional Business Brightstone Tire and Rubber Company has capacity to produce 170,000 tires. Brightstone presently produces and sells 130,000 tires for the North American market at a price of $106 per tire. Brightstone is evaluating a special order from a European automobile company, Euro Motors. Euro is offering to buy 20,000 tires for $88.6 per tire. Brightstone's accounting system indicates that the total cost per tire is as follows: Direct materials $40 Direct labor 15 Factory overhead (70% variable) 24 Selling and administrative expenses (40% variable) 21 Total $100 Brightstone pays a selling commission equal to 5% of the selling price on North American orders, which is included in the variable portion of the selling and administrative expenses. However, this special order would not have a sales commission. If the order was accepted, the tires would be shipped overseas for an additional shipping cost of $6 per…arrow_forward
- QUESTION-5 Megabyte Inc. of France and R Ltd. of India are associated enterprises. R Ltd. imports 3,000 compressors for Air Conditioners from Megabyte Inc. at 7,500 per unit and these are sold to Pleasure Cooling Solutions Ltd at a price of 11,000 per unit. R Ltd. had also imported similar products from Cold Inc. Poland and sold outside at a Gross Profit of 20% on Sales. Megabyte Inc. offered a quantity discount of 1,500 per unit. Cold Inc. could offer only 500 per unit as Quantity Discount. The freight and customs duty paid for imports from Cold Inc. Poland had cost R Ltd. 1,200 per piece. In respect of purchase from Cold Inc., R Ltd. had to pay ₹ 200 only as freight charges. Determine the Arm's Length Price and the amount of increase in Total Income of R Ltd.arrow_forwardProblem 4 (JIT Purchasing, Relevant Benefits, Relevant Costs) The Josefina Corporation is an automotive supplier that uses automatic turning machines to manufacture precision parts from steel bars. Josefina's inventory of raw steel averages P600,000. JC Tan, president of Josefina, and Patrick Argante, Josefina's controller, are concerned about the costs of carrying inventory. The steel supplier is willing to supply steel in smaller lots at no additional charge. Patrick Argante identified the following effects of adopting a JIT inventory program to virtually eliminate steel inventory: Without scheduling any overtime, lost sales due to stockouts would increase by 35,000 units per year. However, by incurring overtime premiums of P40,000 per year, the increase in lost sales could be reduced to 20,000 units. This would be the maximum amount of overtime that would be feasible for Josefina. Two warehouses presently used for steel bar storage would no longer be needed. Josefina rents one…arrow_forwardonly need answer for question 2 with workingarrow_forward
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education