Week 4: Assignment 1 Peters Financial needs to develop an investment portfolio for Mrs. Charles… 1 answer below »

Week 4: Assignment 1

Peters Financial needs to develop an investment portfolio for Mrs. Charles from the following list of possible investments.

Investment

Cash Required ($)

Expected Annual Return ($)

A

5,000

500

B

8,000

640

C

3,500

390

D

10,000

700

E

8,500

750

F

12,000

1,000

G

4,000

300

Ms. Charles has a total of $30,000 to invest. The following conditions must be met:

· If Investment F is chosen, then Investment G must also be part of the portfolio.

· Only one of investments, A or B, can be included.

Which stocks should be included in Ms. Charles’ portfolio?

Week 4: Assignment 2

Kent County plans to develop several new recreational facilities that must be completed within the $3.5-million budget. A survey of county residents has given information about the type of facilities that county residents would like to see built. The information is described in the following table. Specifically, this table provides the cost to construct and maintain each facility, the acres each facility will require, and the average monthly use of each facility. The county has decided that at least 15 facilities will be built and has set aside 55 acres for construction.

Facility Cost per

Facility

Acres per Facility

Use in People per Month

Annual Maintenance

Basketball Courts

$300,000

3

700

$3,000

Baseball Fields

$250,000

5

1,000

$6,000

Playgrounds

$75,000

2

800

$3,000

Soccer Fields

$175,000

3

1,200

$7,000

The county has also established the following list of prioritized goals:

P1: The county would like to spend the entire budget.

P2: The county would like to build enough facilities so that 15,000 people or more each month can use them.

P3: The county does not want to use more than the 55 acres set aside for the project.

Need complete question and answers and QM4 Excel format solution by 10 October 2014 at 12:00pm. Please give me a reasonable price because I still have two more weeks for getting answers to my homework. I am runing short of funds, so any assistance you can give in lowing the price is greatly appreciated. I can afford $10 to $20 for each assignment. There is only two. Also, greatly appreciate any discounts coupons or lowing of requested fees for getting these answers. Greatly appreciate your help. Sincerely, Horace Hogan

P4: The county does not want to spend more than $80,000 per year on maintenance costs for the new facilities.

How many of each type of facility should be constructed?