Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need in excel sheet Double Olive Oil. Ltd. is a producer of high-quality Olive oil. The company buys raw Olives directly from large agricultural companies

need in excel sheet
image text in transcribed
image text in transcribed
Double Olive Oil. Ltd. is a producer of high-quality Olive oil. The company buys raw Olives directly from large agricultural companies and refines them into Olive oil that it sells in the wholesale market. The company has a maximum input capacity of 150 tons of raw Olives every day (or 54,750 tons per year). Of course the company cannot run at full capacity every day as it is required to shut down or reduce capacity for maintenance periods every year, and it experiences the occasional mechanical problem. The facility is expected to run at 90% capacity over the year (or on average 150 x 90%-135 tons per day). Double Olive Oil is planning to purchase its supply of raw Olives from three primary growers, Supplier A, Supplier B, and Supplier C. Purchase prices will not set until the orders are actually placed so Double Olive Oil will have to forecast purchase prices for the raw material and sales prices for the refined Olive oil. The contract is written such that Double Olive Oil is only required to commit to 75% of total capacity up front. Any amounts over that can be purchased only as required for the same price. Historical prices for the last 15 years are in the table below (note that year 15 is the most current year). 11 M 1724 Hoss 1 213 he 373 416 135) 403 11 14 14 12 13 114 418 12 15 Olive oil contains a number of fatty acids, some which are desirable in food products and others that are not. One desirable fatty acid is Oleic acid. Double Olive Oil produces high Oleic oil for the wholesale market and requires that the Oleic acid content be a minimum of 76%. Olive oil also contains trace amounts of lodine. The market requires that that lodine content be a minimum of 0.77% and maximum of 0.87% Double Olive Oil. Ltd. is a producer of high-quality Olive oil. The company buys raw Olives directly from large agricultural companies and refines them into Olive oil that it sells in the wholesale market. The company has a maximum input capacity of 150 tons of raw Olives every day (or 54,750 tons per year). Of course the company cannot run at full capacity every day as it is required to shut down or reduce capacity for maintenance periods every year, and it experiences the occasional mechanical problem. The facility is expected to run at 90% capacity over the year (or on average 150 x 90% - 135 tons per day). Double Olive Oil is planning to purchase its supply of raw Olives from three primary growers, Supplier A. Supplier B, and Supplier C. Purchase prices will not set until the orders are actually placed so Double Olive Oil will have to forecast purchase prices for the raw material and sales prices for the refined Olive oil. The contract is written such that Double Olive Oil is only required to commit to 75% of total capacity up front. Any amounts over that can be purchased only as required for the same price. Historical prices for the last 15 years are in the table below (note that year 15 is the most current year). ve Prendel Angie Mag 163 1724 195 230 3 re 011 3 1416 10 1300 11 1396 1491 1972 112 1650 13 SIS 1014 14 JUX 15 Olive oil contains a number of fatty acids, some which are desirable in food products and others that are not. One desirable fatty acid is lic acid Double Olive Oil

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Research On Professional Responsibility And Ethics In Accounting Volume 21

Authors: Cynthia Jeffrey

1st Edition

1787549739, 9781787549739

More Books

Students also viewed these Accounting questions