Question
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
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started