Workbook2.xlsx - Lucky Strike Oil Company Input Data Oil A Oil B Oil C Cost per litre(\$ Amount Available \$ 0.32 500000 \$ 0.38 275000 \$ 0.34 425000

# Workbook2.xlsx - Lucky Strike Oil Company Input Data Oil A...

• Homework Help
• 3

This preview shows page 1 - 3 out of 3 pages.

Lucky Strike Oil Company Input Data Cost per litre (\$) Amount Available Oil A \$ 0.32 500000 Oil B \$ 0.38 275000 Oil C \$ 0.34 425000 Rugular gas must be at least 45% Oil A Regular gas must be at most 25% Oil B Ultra gas must be at least 35% Oil B Ultra gas must be at most 35% Oil C Action Plan Regular Ultra Output Oil A 1.8 499998.2 500000 Oil B 0 275000 275000 Oil C 424960.45 39.55 425000 Toatal 424962.25 775037.75 Blending Constraints Rugular gas must be at least 45% Oil A 1.8 Regular gas must be at most 25% Oil B 0 Ultra gas must be at least 35% Oil B 275000 Ultra gas must be at most 35% Oil C

#### You've reached the end of your free preview.

Want to read all 3 pages?

Unformatted text preview: 39.55 Revenue and Cost info Regular Ultra Total Revenue \$ 178,484.15 \$ 395,269.25 \$ 573,753.40 Cost Oil A \$ 0.58 \$ 159,999.42 \$ 160,000.00 Oil B \$ - \$ 104,500.00 \$ 104,500.00 Oil C \$ 144,486.55 \$ 13.45 \$ 144,500.00 Profit \$ 33,997.02 \$ 130,756.38 \$ 164,753.40 1 Selling price Regular \$ 0.42 Selling price Ultra \$ 0.51 45% 25% 35% 35% Available units &lt;= 500000 litres &lt;= 275000 litres &lt;= 425000 litres &gt;= 191233.013 &lt;= 106240.563 &gt;= 271263.213 &lt;= 271263.213 2...
View Full Document

• Spring '09
• Brian

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern