Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Azucar & Sons is involved in the sugar business in Florida. The president of the company, Octavio Azucar, goes to a commodity sale once a

Azucar & Sons is involved in the sugar business in Florida. The president of the company, Octavio Azucar, goes to a commodity sale once a month where he buys and sells sugar in bulk. Azucar uses a local warehouse for storing his sugar inventory. This warehouse charges $10 per average ton of sugar stored per month (based on the average between the beginning and ending inventory each month). The warehouse guarantees Azucar the capacity to store up to 400 tons of sugar at the end of each month. Azucar estimates the price per ton of sugar in each of the next six months to be $135, $110, $150, $175, $130, and $145, for both buying and selling. Assume Azucar currently has 70 tons of sugar in storage. How many tons of sugar should Azucar buy and sell during each of the next six months to maximize their profit trading this commodity? Write a linear optimization model for this problem and solve it in Excel.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions