Assign 1

Complete the following problems:

• The following project is at the end of its first week. Find the cost and schedule variances, the cost performance index, the schedule performance index and the estimate at completion.

Task	Predecessors	Duration in days	Planned Value ($)	Actual Cost ($)	Percent Complete
A	None	2	500	650	100
B	None	3	1000	1500	100
C	A	2	200	300	50
D	A	5	600	600	20
E	B ,C	6	1200	550	10

 

To do this exercise, it is best to start with a Gantt chart depicting the task relationships.

CV  A= -150, B= -500, C= -100, D= 0, E= 650     CPI ________________

 

SV ______________________      SPI ________________

 

EAC _____________________

 

 

 

• Using the following information, calculate the cost performance index and the schedule performance index. Then calculate the estimate at c

Planned value: 6700

Earned value: 6100

Actual costs: 7300

Budget at completion: 38900

CPI _______________________                    SPI  _____________________________

 

EAC ______________________

 

 

 

 

• The following project is at the end of its third week. Find the cost and schedule variances, the cost performance index, the schedule performance index and the estimate at completion.

Task	Predecessors	Duration in days	Planned Value ($)	Actual Cost ($)	Percent Complete
A	None	3	600	650	100
B	A	5	1000	1500	100
C	A	2	200	300	100
D	A	5	1000	600	100
E	B ,C	6	1200	1200	100
F	C	10	10000	12000	75
G	F	7	700	0	0
H	G	8	1600	0	0

 

To do this exercise, it is best to start with a Gantt chart depicting the task relationships.

CV ______________________     CPI ________________

 

SV ______________________      SPI ________________

 

EAC _____________________

 

 

 

• Mary is the project manager for a web design project for Newberry Pet Foods. So far in the six weeks (of the twelve week project), Mary's team has completed five tasks which had a combined planned value of $7800. However, the team spent $8200 to complete those tasks. She has five additional tasks to complete the project.  What are the PV, EV, AC, CV, SV, CPI, and SPI for Mary's project? 

 

 

 

• Consider the following information:

 

Expected weeks

Calculate the following:

CV __________________

 

SV __________________

 

CPI __________________

 

SPI __________________

 

EAC __________________

 

Duration at Completion _______________

Assign 2

 I need helps with this question. The complete case question is attached below.

The town of Easley, South Carolina, has experienced tremendous growth over the past few years. After a long and spirited discussion, the town council has unanimously decided to build Easley's first big shopping center. On the recommendation of the town planner, Jimmy Barnes, the council has decided to hire the Ray Development Company (RDC) to help in the shopping center's planning and construction. RDC has a great deal of experience in building malls and shopping centers in the southeastern U.S, and the town council is confident they will help Easley identify the right stores for its new shopping center.

Jennifer Ray, president of RDC, has quickly identified and signed two major anchor stores as well as several other attractive tenants for the shopping center. After assigning suitable spaces to these tenants, Jennifer has 32,000 square feet of space still available for allocation. She and Jimmy are now tasked with deciding which stores to locate in this available space. Due to the significant market interest in Easley's new shopping center, Jennifer and Jimmy are confident that they will not have any trouble finding tenants to suit whatever allocation plan they decide to use.

After extensive study, Jennifer has drawn up a list of 20 different stores she thinks she and Jimmy should consider for the available space. Table 9 below lists these stores in alphabetical order, along with the floor space required by each store, the annual rent the store would pay for the space, the expected annual sales at the store and the expected upfit cost to renovate the allotted space to make it suitable for the store.

As per the leasing agreement developed by RDC, each store would pay the town an annual rent for its allotted space. The town council has mandated that the total rent payments each year must be sufficient to cover the annual fixed cost of maintaining the shopping center. This cost, which includes items such as security, janitorial services, maintenance and utilities, is estimated to be $500,000 per year. In addition, the town council has specified that the total upfit amount spent on renovating the space to suit these stores cannot exceed 60% of the actual total annual rent that would be collected.

In order to make the shopping center attractive to a broad range of customers, Jennifer believes it must adhere to certain conditions in terms of the mix of stores. Taking into account the tenants that have already been signed for the shopping center, she thinks the remaining space should contain at least two stores each in the apparel, food and specialty types and at least one store each in the housewares and services types. She also thinks that there should be no more than three stores of any type and that the number of food and services stores should not exceed the total number of stores in the other three types.

RDC has proposed an arrangement under which the town would receive a fixed percentage of the total annual sales generated by the stores. The town council therefore wants to identify the solution that would generate the maximum total sales from these stores.

Requirements:
1. Create a spreadsheet model for this problem and solve it to determine the optimal solution.
2. Can you recommend an alternate plan to Jennifer's that would maximise total sales from the stores? Provide support for your answer.

 

 

 

1. BX3032 – Advanced Business ModellingAssignment 2, 20161Assignment 2Due Date:5pm on Friday6 May, 2016Case Scenario:Easley Shopping CentreThe town of Easley, South Carolina, has experiencedtremendous growth over the past few years.After along and spirited discussion, the town council hasunanimously decided to build Easley’s first big shoppingcenter.On the recommendation of the town planner,Jimmy Barnes, the council has decided to hire the Ray Development Company (RDC) to help in theshopping center’s planning and construction.RDC has a great deal of experience in building mallsand shopping centers in the southeastern U.S, and the town council is confident they will help Easleyidentify the right stores for its new shopping center.Jennifer Ray, president of RDC, has quickly identified and signed two major anchor stores as well asseveral other attractive tenants for the shopping center.After assigning suitable spaces to thesetenants, Jennifer has 32,000 square feet of space still available for allocation.She and Jimmy arenow tasked with deciding which stores to locate in this available space.Due to the significantmarket interest in Easley’s new shopping center, Jennifer and Jimmy are confident that they will nothave any trouble finding tenants to suit whatever allocation plan they decide to use.After extensive study, Jennifer has drawn up a list of 20 different stores she thinks she and Jimmyshould consider for the available space.Table 9 below lists these stores in alphabetical order, alongwith the floor space required by each store, the annual rent the store would pay for the space, theexpected annual sales at the store and the expected upfit cost to renovate the allotted space tomake it suitable for the store.As per the leasing agreement developed by RDC, each store would pay the town an annual rent forits allotted space.The town council has mandated that the total rent payments each year must besufficient to cover the annual fixed cost of maintaining the shopping center.This cost, whichincludes items such as security, janitorial services, maintenance and utilities, is estimated to be$500,000 per year.In addition, the town council has specified that the total upfit amount spent onrenovating the space to suit these stores cannot exceed 60% of the actual total annual rent thatwould be collected.In order to make the shopping center attractive to a broad range of customers, Jennifer believes itmust adhere to certain conditions in terms of the mix of stores.Taking into account the tenants thathave already been signed for the shopping center, she thinks the remaining space should contain atleast two stores each in the apparel, food and specialty types and at least one store each in thehousewares and services types.She also thinks that there should be no more than three stores ofany type and that the number of food and services stores should not exceed the total number ofstores in the other three types.RDC has proposed an arrangement under which the town would receive a fixed percentage of thetotal annual sales generated by the stores.The town council therefore wants to identify the solutionthat would generate the maximum total sales from these stores.

Attachments:

• 1495500732-BX3032_Assignment 2_2016.pdf