1. Calculate the monthly mortgage payment of principal and interest for the a loan with an initial balance of 150,000, an annual stated interest rate of 6%, and 30 years to maturity. Use Excel to develop this response and present your result within a separate page of the spreadsheet.
2. Develop  the amortization table for the loan outlined in problem 1.  Use an Excel spreadsheet to develop and present this table.  Present this result in a separate page of the spreadsheet. 
3. Further, given the structure of problem 1, develop a summary table showing how the monthly payment would adjust for all options with an interest rate at 5%, 6% and 7% as well as a maturity at 15 years, 20 years and 30 years. Use Excel to develop and present this summary table.  Present the results in a separate page of the spreadsheet.
4. Assume that you want to retire in 30 years. You intend to invest $200 per month into a mutual fund that you expect to return 12% per year (1% monthly). If you continue making these monthly investments for 30 years, what amount of money will you have at the end of the 30th year? Use Excel to develop and present this result.  Present the result in a separate page of the spreadsheet.
5. Given problem number 4, please develop a summary table showing the accumulation for all options with an assumed return of 10%, 11%, 12%, 13% and 14% as well as an investment of $150, $200 and $250.  Use Excel to develop and present this summary table.  Present the result in a separate page of the spreadsheet.

 

Read the project case for this assignment.

 

As the project manager for the District 4 Warehouse Move project, you will need to determine who your stakeholders and project team members are for this project. Remember that anyone connected to the project who has an interest or stake in the project should be considered as a stakeholder. This would include the project team, vendors and management among possible others.  

 

After you have determined who your stakeholders are, determine who will need to be a part of the project team. Develop a 2-3 page paper (650-750 words) in the form of a Microsoft Word document, not including the header and reference pages, defining the following:

 

1. How will project communications and interactions work between the project manager, the stakeholders and the project team?
2. What are some of the issues you, as the project manager will need to be concerned about in forming the project team?
3. What, if any, situational factors exist that may affect the project team’s performance?
4. What are some project pitfalls you will want to watch out for as you execute this project?

 

Save the Word file as ProjectTeamManagement_<name>, where “<name>” will be your name.

 

Assignment 2 Grading Criteria
A description of a project communication plan is provided
Team forming and development concerns are identified and described
Situational factors are described in relation to the D4 Warehouse Move project
A discussion of project pitfalls from a project manager’s perspective is provided
Paper is 650-750 words and provides depth of discussion
Used correct grammar, spelling, and word choice and cited all sources using correct APA style.

 

 

 

 

You are working for a large, apparel design and manufacturing company, Trillo Apparel Company (TAC), headquartered in Albuquerque, New Mexico. TAC employs around 3000 people and has remained profitable through tough economic times. The operations are divided into 4 districts; District 1 – North, District 2 – South, District 3 – West and District 4 – East. The company sets strategic goals at the beginning of each year and operates with priorities to reach those goals.

 

Trillo Apparel Company Current Year Priorities

 

• Increase Sales and Distribution in the East
• Improve Product Quality
• Improve Production in District 4
• Increase Brand Recognition
• Increase Revenues

 

Company Details

 

Company Name:  Trillo Apparel Company (TAC)

 

Company Type: Apparel design and production

 

Company Size: 3000 employees

 

Position	# Employees
Owner/CEO	1
Vice President	4
Chief Operating Officer	1
Chief Financial Officer	1
Chief Information Officer	1
IT Department	38
District Manager	4
Sales Team	30
Accountant	12
Administrative Assistant	7
Order Fullfilment	45
Customer Service	57
Designer	24
Project Manager	10
Maintenance	25
Operations	2500
Shipping Department	240
Total Employees	3000

 

 

 

Products: Various Apparel

 

Corporate Location:Albuquerque, New Mexico

 

TAC Organization Chart

 

 

 

 

 

 

 

District 4 Production Warehouse Move Project Details

 

The business has expanded considerably over the past few years and District 4 in the East has outgrown its current production facility.  Because of this growth the executives want to expand the current facility, moving the whole facility 10 miles away. The location selected has enough room for the production and the shipping department. However, the current warehouse needs some renovation to accommodate the district’s operational needs.

 

The VP of Operations estimates the production and shipping warehouse move for District 4 will provide room required to generate the additional $1 million/year product revenues to meet the current demand due to the expanded production capacity. Daily production generates $50,000 revenue so a week of downtime will cost $250,000 in lost revenues.

 

The move must be completed in 4 months.

 

Mileage between the old and new facilities is 10 miles.

 

Bids have been received from contractors to build out the new office space and production floor and have signed contracts for work as follows:

 

Activity	Company Providing Services	Total Contract	Supplies	Time Needed
Pack, move and unpack production equipment	City Equipment Movers	$150,000	n/a	5 Days
Move non-production equipment and materials	Express Moving Company	$125,000	n/a	5 Days
Framing	East Side Framing & Drywall	$121,000	$125,000	15 Days
Electrical	Sparks Electrical	$18,000	$12,000	10 Days
Plumbing	Waterworks Plumbing	$15,000	$13,000	10 Days
Drywall	East Side Framing & Drywall	$121,000	$18,000	15 Days
Finish Work	Woodcraft Carpentry	$115,000	$15,000	15 Days
Build work benches for production floor	Student Workers Carpentry	$112,000	$110,000	15 Days

 

 

 

Production workdays are Monday through Saturday. The actual move must be completed in 5 days for as little disruption to production activities as possible. All contractors are on other projects but have been booked in advance. The contractors will gain the necessary permits and schedule city and county inspections but these tasks need to be identified separately due to the length of time it can take. Permitting and inspections can take from one to three weeks, depending upon schedule and the flexibility of the inspector. The new warehouse is empty and can be accessed immediately. Framing cannot start until the permits are received. Electrical and plumbing can begin as soon as the framing is finished. Drywall cannot start until the electrical and plumbing inspections are complete. After the drywall is completed, final inspections will be completed by the county and city. After both the county and city have passed the new construction, finish work can begin. Building the product floor work benches can occur at any time before the move occurs.

 

 

Write a 700- to 1,050-word paper on police corruption, police misconduct, and police brutality.Include the following in your paper:

• Describe the extent of police corruption, misconduct, and brutality in the United States.
• Research two current cases within the last 10 years: one case on police corruption and misconduct and one case on police brutality.
• Describe the details of the cases.
• Explain the outcomes of the cases. Did you agree with the outcomes? Why or why not?
• APA format

Assignment 2.2: Justification Report – Part 2
Due Week 5 and worth 150 points

In Part 1 of your Justification Report assignment, you built up the following sections: Problem Statement, Overview of Alternatives, Criteria, and Methods. In Part 2, you will revise Part 1 based on your instructor’s suggestions and add to it the following sections: Evaluation of Alternatives, Findings and Analysis, and References.

Use the basic outline below to draft your paper. Organize your responses to each question under the following section headings:

• Evaluation of Alternatives (for Questions 1-3)
• Findings and Analysis (for Questions 4-5)
• References (for Question 6)

Using the provided template, write Part 2 of a single-spaced report in which you:

1. Include and revise the sections from Assignment 2.1 (Problem Statement, Overview of Alternatives, Criteria, and Methods) per instructor suggestions.
2. Research the two (2) alternatives (i.e. possible solutions) that you’ve identified in your Part 1 Evaluation of Alternatives section. Record bibliographic information during research.
   1. Example: You might research other organizations that have attempted similar solutions to the problem you have identified and explore the results of those experiments. 
3. Use what you discover in your research to evaluate each alternative by each of your five (5) criteria.
   1. Example: If your research revealed that four (4) companies similar to yours increased productivity after allowing their workers to telework from home three days per week, you might conclude that one of your suggested alternatives – in this case, the option to telework from home three days per week – satisfies one of your criterion of “Productivity” as a high-potential solution to a problem you’ve identified (of decreased worker morale and productivity at Doe’s Electronics). However, additional research might frustrate a recommendation of this alternative if it is found to fall short of other criteria while a second alternative fares better. For instance, a telework alternative might be found to be too costly to implement; too frustrating for consumers who prefer daily, in-person customer service; or too divergent from the company’s brand, “Always there for you!”
4. Organize the assignment by your criteria. Explain in narrative form how each of your two (2) alternatives stacks up against your first criterion. Next, explain how each alternative stacks up against your second criterion, etc.
   1. Example: An abbreviated outline of what this longer section might look like based on the above example is below (Note: Only the first two [2] of five [5] required criteria are included to give you a feel for the structure). Your researched findings, represented as circled bullets below, should be explained in two to five (2-5) sentences. Include in-text citations and follow up with References in APA style):

      Evaluation of Alternatives

      • Productivity
      1. • Alternative A: Telework from home three (3) days per week
           • {narrate findings based on research article 1 here}
         • Alternative B: Offer two (2) extra Floating Holidays to each employee per year
           • {narrate findings based on research article 2 here}
      • Cost
      1. • Alternative A: Telework from home three (3) days per week
           • {narrate findings based on research article 1 here}
         • Alternative B: Offer two extra Floating Holidays to each employee per year
         • • {narrate findings based on research article 2 here}
5. Briefly summarize in narrative form the major discoveries that emerged from the Evaluation of Alternatives section.
6. Include a chart like the ones below to illustrate at a glance:

   Figure 1: Alternatives Analyzed by Criteria

   Criteria	Telework Option	Floating Holiday Option
   Productivity	Very high	Negligible increase
   Cost	Very high	Moderate
   Company Image	Increased	Negligible increase
   Worker Morale	Increased	Negligible increase
   Practicality	Moderate	Low
   TOTAL Feasibility* of Alternatives based on Criteria?	Moderate to High	Low to Moderate

   *Feasability = Capability of an alternative being carried out with success

7. Include an APA style (6th edition) References page that documents the two (2) sources (minimum) that you used and cited in-text in your Evaluation of Alternatives section. You may use secondary resources, or you may include one primary source and one secondary source. Remember that both in-text citations and References must be included (to avoid plagiarism) whenever you are directly quoting, summarizing, or paraphrasing researched material.

Your assignment must:

• Be typed, single spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, your name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

• Support ideas or claims in body paragraphs with clear details, examples, and explanations.
• Organize ideas logically by using transitional words, phrases, and sentences.
• Use sentence variety and effective word choice in written communication.
• Apply writing process strategies to develop formal business reports and / or proposals.
• Use technology and information resources to research issues related to selected topics.
• Write clearly and concisely using proper writing mechanics.