The following total fixed operating cost schedule is provided with fixed costs spilt between olive oil and extra virgin olive oil based on percentage of oil yields from fruit: The following schedule applies to all variable costs which are spilt between olive oil and extra virgin olive oil based on percentage of oil yields from fruit: Instructions: You have been hired as an external consultant by Extra Virgin Olive Oil Incorporated (EVOOI) to advise them on their cost of setting up an olive oil producing facility in southern Victoria. Please provide advice to the questions provided by the CEO (Dr Pit) below. Please present your responses to the questions in a slide PowerPoint style (save as PDF and upload). Provide your name and Student ID on the title page of the PDF upload. Also please upload the excel file used to create your graphs. Victorian Olive Oil Project A foreign investor, Extra Virgin Olive Oil Incorporated (EVOOI) is considering establishing an irrigated olive-growing and oil-processing project in Southern Victoria. Extra virgin olive oil production is represented by a competitive industry and a market determined wholesale price of $3.55 per litre. It is estimated that each hectare (Ha) of land used for the production of olive oil will produce 200 trees. Fruit yield per tree is 25kg. Oil yield is expected to be 0.30 litres per kg of fruit with a 30%/70% split of olive oil/extra virgin olive oil. 1a. Calculate total trees, fruit yield (in kg ) and output of extra virgin olive oil (in litres) for 100,200,300,400,500,600,700,800,900 and 1,000Ha of total land use and present your answers in a table format (half a mark for each set of output related estimates =1.5 marks) 1b. For each of the extra virgin olive oil yield output levels, calculate the total fixed cost, total variable cost, total cost, average fixed cost, average variable cost, average total cost and marginal cost and present your answers in a table format (1.5 marks for each set of cost estimates =10.5 marks). 2a. Using a chart created in Excel, provide an illustration of the total cost, total variable cost and total fixed cost of extra virgin olive oil ( 3 marks). 2b. Using a chart created in Excel, provide an illustration of average total cost, average variable cost and average fixed cost and marginal cost of extra virgin olive oil (4 marks). 3a. Why do the average costs curves and marginal cost curve demonstrate a U shape as shown in 2b ? (in your answer refer to the respective quantity of litres) ( 3 marks). 3b. How many litres of extra virgin olive oil should the business produce? Explain your answer by referring to the profit maximising condition ( 3 marks)
