This solved assignment delves into the complexities of optimizing refinery operations. It presents a mathematical model for maximizing profit by considering various factors like crude oil types, product demands, processing limitations, and economic values. The solution utilizes Excel to determine the optimal quantities of each product to be produced, given specific constraints and objectives. Additionally, the assignment explores the impact of investment in capacity expansion on profitability.