2. (50pts) McDonald-Pelz wants to determine its oil trading strategy for the next two weeks (10...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2. (50pts) McDonald-Pelz wants to determine its oil trading strategy for the next two weeks (10 business days). The following table summarizes the estimated purchase prices (the Ask price, per thousand barrels) and sales prices (the Bid price, per thousand barrels) during each of the next 10 business days. DAY 1 2 3 4 5 6 7 8 9 10 ASK $3,220 $4,100 $6,130 $4,190 $4,050 $5,120 $5,280 $4.230 $3,150 $4,180 BID $3,060 $4,010 $6,030 $4,060 $4,010 $5,020 $5,100 $4,080 $3,010 $4,010 McDonald-Pelz currently has 150,000 barrels of oil in storage. The storage facility it rents has a maximum storage capacity of 500,000 barrels. Due to safety regulations, a maximum of 180,000 barrels can be taken out of the storage facility per day. At the same time, a maximum of than 200,000 barrels can be added to the storage each day. The storage facility's owner charges a fee equal to 5% of the bid value of the average daily oil inventory. a) Create a spreadsheet model that can be used to determine an optimal trading strategy and solve it. b) What is the optimal solution? 2. (50pts) McDonald-Pelz wants to determine its oil trading strategy for the next two weeks (10 business days). The following table summarizes the estimated purchase prices (the Ask price, per thousand barrels) and sales prices (the Bid price, per thousand barrels) during each of the next 10 business days. DAY 1 2 3 4 5 6 7 8 9 10 ASK $3,220 $4,100 $6,130 $4,190 $4,050 $5,120 $5,280 $4.230 $3,150 $4,180 BID $3,060 $4,010 $6,030 $4,060 $4,010 $5,020 $5,100 $4,080 $3,010 $4,010 McDonald-Pelz currently has 150,000 barrels of oil in storage. The storage facility it rents has a maximum storage capacity of 500,000 barrels. Due to safety regulations, a maximum of 180,000 barrels can be taken out of the storage facility per day. At the same time, a maximum of than 200,000 barrels can be added to the storage each day. The storage facility's owner charges a fee equal to 5% of the bid value of the average daily oil inventory. a) Create a spreadsheet model that can be used to determine an optimal trading strategy and solve it. b) What is the optimal solution?
Expert Answer:
Answer rating: 100% (QA)
a Spreadsheet Model To determine the optimal trading strategy we can create a spreadsheet model that calculates the daily inventory average daily inve... View the full answer
Related Book For
Operations Management in the Supply Chain Decisions and Cases
ISBN: 978-0073525242
6th edition
Authors: Roger Schroeder, M. Johnny Rungtusanatham, Susan Goldstein
Posted Date:
Students also viewed these finance questions
-
If feedforward controls are the most proactive, then why do organizations need or use feedback controls? Explain and defend your answer.
-
When a business receives cash from customers before earning the revenue, the O A. Accounts Receivable OB. Unearned Revenue OC. Accounts Payable O D. Sales Tax Payable account is credited.
-
Explain how a policies and procedures manual guides the work of an agency's branch manager and all staff. The answer should explain: What is the purpose of the manual for staff? Why is a policies and...
-
Define price and name the various types of prices described in this chapter.
-
Following are the operating data for an advertising firm for the year ended December 31, 2009. Revenues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $175,000 Supplies expense . . . . ....
-
Design a memory management scheme for a 48 bit architecture, using various types of paging and/or segmentation described in this week\'s readings. Your post should include a clear translation scheme...
-
Compute the missing amounts in the following table. (At the end of 2015, retained earnings had a balance of negative $2,086.) Comment on the companys performance over the three-year period after...
-
Calvin Jacobs is a widower who recently retired after a long career with a major Midwestern manufacturer. Beginning as a skilled craftsman, he worked his way up to the level of shop supervisor over a...
-
Describe a key difference between a mobile app and regular e-commerce site:
-
On January 1, 2012, Fishing Creek Company purchased Skull Valley Technologies for $8,800,000 cash. The book value and fair value of Skull Valleys assets as of the date of the acquisition are listed...
-
Using the South University Online Library or the Internet, research and identify a real world example of a project. Based on your research and the identified project, answer the following questions:...
-
What is China size of its economy, population, its major manufactured commodities, and its top two imported and two exported commodities. Data: Roots of Comparative Advantage: Use data, graphs,...
-
Table 1 shows information for exchange rates and price indexes for different countries and for the U.S. Country Currency Table 1 Currency per U.S. Price U.S. Dollar Index Country Price Index Bolivia...
-
Huron Company produces a cleaning compound known as Zoom. The direct materials and direct labor standards for one unit of Zoom are given below: Direct materials Direct labor Hours Standard Quantity...
-
Variable costing income statement Sports Drinks, Inc. began business in the current year selling bottles of a thirst-quenching drink. Production for the first year was 249,600 bottles, and sales were...
-
Blossom Company has recorded the following items in its financial records: Cash in bank $49,000 Cash in plant expansion fund 104.200 Cash on hand 14,900 Highly liquid investments 36,800 Petty cash...
-
The test tubes of high-speed centrifuges should be placed with care because of the very large acceleration. Part 1 Assume the centrifuge is rotating at 4000 rpm. Determine the acceleration at the end...
-
Reread the discussion leading to the result given in (7). Does the matrix sI - A always have an inverse? Discuss.
-
Why is interfunctional cooperation important for new-product design? What are the symptoms of a possible lack of interfunctional cooperation?
-
At the ABC Floral Shop, an argument developed between two of the owners, Bob and Henry, over the accuracy of forecasting methods. Bob argued that exponential smoothing with = .1 would be the best...
-
S&OP or aggregate planning sometimes is con fused with scheduling. What is the difference?
-
If there are far fewer sugar growers than sugar consumers, a. the growers are likely to be more informed and influential on policy than voters. b. the consumers are likely to be more informed and...
-
Which of the following would tend to raise voter turnout? a. a blizzard or heavy rainstorm on election day b. an election that is expected to be a landslide c. the longer the wait is expected to be...
-
_________ and _________ account for roughly half of state and local government expenditures.
Study smarter with the SolutionInn App