Reference no: EM133145796
Sunco Oil manufactures three types of gasoline (gas 1, gas 2, and gas 3). Each type is produced by blending three types of crude oil (crude 1, crude 2, and crude 3). The sales price per barrel of gasoline and the purchase price per barrel of crude oil are given in the sheet. Sunco can purchase up to 5,000 barrels of each type of crude oil daily. The three types of gasoline differ in their octane rating and sulfur content. The crude oil blended to form gas 1 must have an average octane rating of at least 6 and contain at most 2% sulfur. The crude oil blended to form gas 2 must have an average octane rating of at least 10 and contain at most 1% sulfur. The crude oil blended to form gas 3 must have an octane rating of at least 8 and contain at most 3% sulfur. The octane rating and the sulfur content of the three types of oil are also given in the sheet. It costs $5 to transform one barrel of oil into one barrel of gasoline, and Sunco's refinery can produce up to 16,000 barrels of gasoline daily. Sunco's customers require the following amounts of each gasoline: gas 1, 4000 barrels per day; gas 2, 3000 barrels per day; and gas 3, 2000 barrels per day. The company considers it an obligation to meet these demands. Sunco also has the option of advertising to stimulate demand for its products. Each dollar spent daily in advertising a particular type of gas increases the daily demand for that type of gas by 15 barrels (e.g., if Sunco decides to spend $30 daily in advertising gas 2, the daily demand for gas 2 will increase by 250 barrels).
Determine how Sunco can maximize its profit.
Formulate the problem as a linear model.
In Solver, to select Changing Variable Cells that are not in "contiguous" addresses, separate the ranges by a comma.
Crude 1 $45 Gas 1 $70
Crude 2 $35 Gas 2 $60
Crude 3 $25 Gas 3 $50
|
Prepare all of the relevant journal entries from the time
: Prepare all of the relevant journal entries from the time of sale June 1, 2021 until the date of repurchase October 1, 2022
|
|
Show the journal entries for each of the four transactions
: Show the journal entries for each of the four transactions outlined, alongside all relevant workings
|
|
Creating long-term relationships
: You are the new National Sales Manager for Elite Golfers, which is a high-end business-to-consumer golf equipment and apparel provider. The company has multiple
|
|
Determine how sunco can maximize its profit
: Sunco Oil manufactures three types of gasoline (gas 1, gas 2, and gas 3). Each type is produced by blending three types of crude oil (crude 1, crude 2, and crud
|
|
Determine how sunco can maximize its profit
: Sunco Oil manufactures three types of gasoline (gas 1, gas 2, and gas 3). Each type is produced by blending three types of crude oil (crude 1, crude 2, and crud
|
|
Proposed practice of legally requiring individual investors
: Frederick and Hoffman present us with an argument that concludes that we ought to restrict individual investor rights by requiring people to go through an exper
|
|
What is balanced scorecard
: What is balanced scorecard? What are the major parts of a balanced scorecard? Why are these parts needed?
|
|
Basic group structure-controlling interest
: Basic group structure & controlling interest Analyse investmentassociate, significant interest control the key differences in these levels of equity status in a
|
|
Effective and ethical management
: How can effective and ethical management provide a better business environment (defined and interpreted to include sustainability-related issues and implication
|