Project 1

((

Susans Consulting Company (SCC) – Problem Overview

Susans Consulting Company (SCC) has been in business for ten years and has experienced a significant

turnover in the project management group, which has prompted senior leadership to investigate. 

A preliminary review by senior leadership has determined that Project Managers are frustrated with the

amount of required project management documentation, which has impacted their ability to manage

projects successfully. 

A recent review of the project management process has determined that SCC has spent between 30-40%

of its total project budget on projects' overhead costs to include project management costs. A review of

industry standards is between 5-15% higher than most companies. In addition, senior leaders found that

projects are being delivered between 25% and 50% over budget and late 95% of the time.

Note: Project Management overhead includes the PM's time managing the project, attending meetings,

and developing the required documentation.   

SCC Request: SCC has reached out to your team because you are experts in defining project

management processes and delivering projects on time. The SCC request includes the following:

 The development of a new project management process which at a minimum should include the

following:



o The ability to track issues, risks, changes

o The ability to view project activities consists of a view of what has been completed and

what activities the team is working on over the next reporting period

o The company must have a view into total life cycle project costs to include what has been

spent to date, baseline budget, any changes to the budget, remaining budget, and cost of

the project at completion

 In addition, to the new process request, SCC has a new project they need to complete by the end

of the year with a limited budget and no project management staff.  

Assignment

 Identify a project manager – this individual is responsible for the team assignment ensuring that

team members are completing their assigned work on time.

 I will act as the sponsor both for the project and for the methodology build-out.  Any questions

should be directed to me.

))

OVERVIEW- For Understanding the Project

((Your paper should include the following information:  

 Project scope statement

 Using the methodology outlined above, describe each phase of the project and its deliverables))

MY PART

USE SPIRAL Methodology

-Need references as well.

Please prepare the below slides for the company “Target”.  Conduct online research of Target and present the following strategic capabilities addressing the following areas: 

 ·        How would you distinguish between an organizational weakness and a threat to the organization? How would you distinguish between strength and opportunity?

·       Is there a difference between project time management and personal time management? Can someone be “good” at one but not the other?

Please prepare the 2 slides and provide some additional notes. 

#Exp19_Excel_AppCapstone_Intro_Collection

#ExcelAppCapstoneIntroCollection

You are the financial manager for Judi’s Art Gallery. One of your clients, Raymond Chancellor, has a large collection of limited edition signed art by James C. Christensen (1942-2017). Over the years, you have helped Raymond maintain a list of his collection, including the title of the art, medium, issue date, issue price, the price he paid, and current market values. Most of the art is sold out from the publisher, which increases the value of the art. Other art is still readily available or is available in limited quantities. You want to update the list so that he can properly insure his collection.

Select   the range A1:A6 on the Christensen worksheet, merge the cells, and apply Middle Align vertical   alignment.

Change the width of column K to   17.00, select the range K1:K3, and apply Thick Outside Borders.

Click cell C9, and freeze panes   so that rows 1 through 8 and columns A and B are frozen.

Select the range E9:E54 and   apply the Mar-12 date format.

Find all occurrences of Retired and replace them with Sold Out.

Click cell H9 on the Christensen   worksheet, and insert a formula that calculates the percentage Raymond paid   of the issue price by dividing the amount Paid by the Issue Price. Copy the   formula from cell H9 to the range H10:H54.

Click cell J9, and insert a   formula that calculates the percentage change in value by subtracting the   Issue Price from the Current Value and then dividing that result by the Issue   Price. Copy the formula from cell J9 to the range J10:J54.

Apply Percent Style with one   decimal place to the ranges H9:H54 and J9:J54.

Insert in the Current Values   section at the top of the worksheet summary functions that use the range   I9:I54. In cell I2, calculate the total of all the Current Values. In cell   I3, calculate the average current value. in cell I4, calculate the lowest current   value. In cell I5, calculate the highest current value.

Click cell C9 and insert a   VLOOKUP function that looks up the code in cell B9, compares it to the codes   and types of art in the range B2:C6, and returns the type of art. Copy the   function in cell C9 to the range C9:C54. Hide column B that contains the   codes.

Click cell K9 and insert an IF   function that determines if the Issue Price is equal to the Current Value. If   the values are the same, display Same as Issue (using the cell reference K2); otherwise, display Increased in   Value (using   the cell reference K3). Copy the function from cell K9 to the range K10:K54.

Display the Purchase worksheet,   insert a row above Monthly Payment. Type Monthly Payments in 1 Year in cell A5 and type 12 in cell B5.

In cell B6 in the Purchasing   sheet, insert the payment function to calculate the monthly payment using   cell references, not numbers, in the function, and make sure the function   displays a positive result. Apply Accounting Number Format and the Output   cell style to cell B6.

Display the Christensen   worksheet, select the range C1:E6, and create a clustered column chart.

Cut the chart and paste it in   cell A57, change the height to 4″, and change the width to 6.5″.   Add Alt Text The column chart compares total issue prices to total   current values by type of art. (include the period).

Type Raymond’s Art Collection for the chart title, apply   bold, and Black, Text 1 font color. Place the legend at the top of the chart.   Add Primary Minor Horizontal gridlines.

Create a pie chart using the   ranges C2:C6 and E2:E6, and then move the chart to a new chart sheet named Current   Values. Move   the Current Values sheet to the right of the Purchase sheet.

Type Percentage of Total Current Value as the chart title and change   the font size to 18 pt. Choose Colorful Palette 3 for the chart colors. Add   this description for Alt Text: The pie chart shows each art type by percentage of   total current value. (include   the period). 

Hide the legend. Add data labels   for categories and percentages; remove value data labels. Change the font   size to 16 pt, bold, and Black, Text 1 font color for the data labels. 

Explode the Masterwork   Anniversary Edition slice by 15% and change the fill color to Light Blue.

Display the Christensen   worksheet, click in any cell within the dataset, convert the data to a table,   assign a table name Collection, and apply Green, Table Style Light 14.

Apply a conditional format to   the range J9:J54 that highlights cells where the value is greater than 200%   with Green Fill with Dark Green Text.

Sort the dataset by Type of Art   in alphabetical order and then within Type of Art, sort by Current Value from   largest to smallest.

Set a filter to display art that   equals Sold Out as the status.

Add a total row to display the   sum of the Issue Price, Paid, and Current Values columns. Remove the total   for the Note column.

Select the Purchase sheet, set   2″ top margin, and center horizontally on page.

Select the Christensen sheet,   select Landscape orientation, Legal paper size, set 0.2″ left and right   margins, 0.5″ top and bottom margins, and set row 8 to repeat at the top   of pages.

On the Christensen worksheet,   change the width of column A to 27, the width of column D to 11, the width of column J to 12. Wrap text in cell A1 and cell   J8.

Create a footer with Exploring   Series on the   left side, the sheet tab code in the center, and file name code on the right   side on the Christensen sheet.

1. How to Ensure Customer Satisfaction Using God’s Word

2. Analyze the four performance measures of cost, quality, duration, and customer satisfaction. What additional metrics or measurement could be important (beyond the additional measurement of size noted in the text)?

3. Compare and contrast quantitative versus qualitative data in evaluating performance of IT systems. Is one data collection methodology better at assessing the overall effectiveness of operations?

Need 600 words and 3 minimum references

 Looking for the excel spreadsheet for:

Exp19 Excel AppCapstone Intro Collection 

Raymond’s Art Collection 

DB 1 400 to 600 words

Compare and contrast audits and assessments. Include the following in your discussion:

• Pick      at least 3 things that are the same and 3 things that are different.
• Compare      the goals, the timing, and the roles that are involved.

DB 2 400 to 600 words

What does compliance mean? Include the following in your discussion:

• Explore      compliance from an internal and external perspective.
• What      kinds of businesses have a stronger possibility of being under some sort      of compliance regulation from an external point of view?

DB 3 400 to 600 Words

Describe 3 separate security standards (either internal or external) that may apply to the company that you are studying. The following are examples of such standards:

• Encryption      standards
• Digital      signature standards
• Password      standards
• Physical      security standards
• Training      standards
• Health      Insurance Portability and Accountability Act (HIPAA)
• ISO27002

As part of your discussion, include possible controls and possible challenges of implementing these standards.

Assignment Content

1. Even though this class is new to you, none of you should be new to Computer Architecture as it exists in the real world…in fact, everyone who has used an iteration of computer architecture over the years and this is evidenced by the Desktop or laptop computers you own.

   For this week’s assignment, Please provide a write-up as an answer to the question below

   Why is the cache memory so important to a computer’s performance even though all systems have MAIN MEMORY (RAM)?

   As part of this assignment, make sure to answer the following sub-questions as part of your assignment

   • Explore the different types of Cache memory and how they differ from one another?
   • How the cache memory differs from the main memory (RAM) in terms of functions?
   • You should submit at least TWO FULL PAGES OF CONTENT…meaning sources, title, etc. do NOT count…be sure to include any reference material you used…

 A” – and C were partners in a firm sharing profits in +@2@1 ratio. the firm closes its boo,s on +1 st Barch every year. – died in 126!%62!!#. &n -‘s death the goodwill of the firm was valued at $s.%!!!!. &n -‘s death his share in the profit of the firm till the time of his death was to be calculated on the basis of previous years which was $s.1!!!!. Calculate -‘s share in the profit of the firm. 9ass necessary 4ournal entries for the treatment of goodwill and -‘s share of profit at the time of his death 

• Define and describe a SAN.
• Define and describe NAS.
• Describe how cloud-based data storage works.
• Assume that you must select a cloud-based data storage solution for your company. List the factors you would consider when selecting a vendor.
• Many users do not yet feel comfortable storing data within the cloud. Discuss some steps you can take to reduce their concerns.
• Assume that you must select a cloud-based data storage solution for your company. List the factors you would consider when selecting a vendor.
• List the pros and cons of cloud-based data storage.
• List the pros and cons of a cloud-based database

• Define collaboration.
• Define and describe cloud-based collaboration.
• The CIO of Ace Accounting Services suggests that the company can save considerable money using VoIP for phone calls. Define and describe VoIP. Then present three companies that provide VoIP offerings. Compare and contrast each company’s offering. Also, discuss whether or not you agree with the CIO and justify why.
• List the questions one should consider when evaluating a cloud-based collaborative solution.

A Gas pump calculates the cost of gas at a local gas station. The station charges $2.69 per gallon for regular grade gas, $2.79 per gallon for special grade gas, and $2.89 for super grade. Create an application that simulates the functionality of the gas pump. The user enters the number of gallons to purchase and clicks the desired grade (each grade is represented by a button whose text properties are set to Regular, Special, and Super+). The Click event handler for each button calls a method to compute the total cost from the number of gallons entered and the selected grade. (note: use the text property of each button to pass the selected grade to your method)