Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need this question to answered in excel as much as you can thanks ECON 5140 Fall 2017 Project Description This project requires a 1-page

image text in transcribed

i need this question to answered in excel as much as you can thanks

image text in transcribed ECON 5140 Fall 2017 Project Description This project requires a 1-page memorandum for each of 3 parts. It is perfectly acceptable (perhaps encouraged) to group those 3 memoranda into 1 file. Make certain that the file name has includes your name as part of it. If you need an example, the following link contains an example of a perfectly fine memorandum: https://en.wikipedia.org/wiki/Memorandum This project requires 3 analyses, one for each part. It is perfectly acceptable (perhaps encouraged) to group those 3 analyses into one file by using tabs. Please ensure that the file name includes your name. You will need to submit your work electronically, via Blackboard. Part I Solve the following problem: The table below shows the nutritional contents of five foods in grams per 100 g, the costs of the foods per 100 g, and the minimum weekly requirements for an adult (in grams). Find the least cost combination of foods that will meet the weekly adult minimum requirements. Food Protein Fat Carbohydrate Wholemeal Bread Margarine Cheese Breakfast Cereal Diet Snack Bar 8 0 25 10 10 1 84 35 2 - 56 0 0 77 49 Weekly Adult requirements (g) 500 600 2100 Cost, $ 0.08 0.16 0.38 0.24 0.40 Part II Your friend recently inherited $20,000 from a wealthy relative. His stockbroker has advised him to invest in three particular stocks. Because of the volatility of the market, your friend requires the stockbroker to provide him with historical yearly returns for these stocks over the past four years. This data is shown in the table below. Find the efficient frontier of this portfolio. Year 1 2 3 4 (continued) Stock A 0.202 0.024 0.159 0.049 Stock B 0.109 0.187 0.098 0.121 Stock C 0.153 0.068 0.185 0.057 Part III In an effort to fine-tune their marketing strategy, a computer contractor has collected cost and performance data on 8 installations, as shown in the table below. Use data envelopment analysis to determine which installations are efficient and which are not. Installation INPUTS OUTPUTS Labor Costs Operational Costs Processing Mistake Decrease (number of policies) Decrease in Turnaround Time (minutes per policy) 1 7260 4372 3.597 0.7143 2 7825 3494 3.571 0.7457 3 8900 3483 3.953 0.7278 4 7863 4000 3.571 0.7547 5 7555 4244 4.926 0.7496 6 3050 4746 3.731 0.7072 7 980 4421 3.534 0.7072 8 3600 4159 3.846 0.7262 Data Envelopment Analysis or DEA is described in the following link: https://en.wikipedia.org/wiki/Data_envelopment_analysis I recommend reading only the first two paragraphs lest madness ensue. The following formulation is the one that you will program in Excel: Minimize E s.t. Weighted outputs > Unit k's output (for each measured output) Weighted inputs 0 Where \"E\" is the efficiency of the installation in

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

Basic Finance An Introduction to Financial Institutions, Investments and Management

Authors: Herbert B. Mayo

11th Edition

1285425790, 1285425795, 9781305464988 , 978-1285425795

More Books

Students also viewed these Finance questions