Strayer University Difficult Conversations Discussion

Description

Please respond to the two discussion responses below using in-text citation and using a reference list. Keep each response separate. I have included the initial discussion question for you. Please be in-depth with the responses.

Initial Discussion Question

Difficult Conversations

Scenario: The performance of your top employee has recently slipped. You had a conversation with the employee to address it. The employee improved for a period of time, but slipped again. Now, your boss has noticed, which questions your leadership. You do not want to terminate this employee because you know the value of this person and their work, and you trust and respect this employee. However, you are starting to look bad.

It is time to take action, so you schedule a meeting with the employee.

Part One: Considering the course materials for this week, discuss your strategy for the meeting, including:

  • What you will do to make your point clear and candid during the conversation.
  • How you will remove your own personal emotion from the conversation while still maintaining empathy and trust with the employee.
  • What techniques you will employ to build effective working relationships, and why you would choose these techniques.
  • Part Two: Write a brief dialogue recording the conversation between you and this employee that demonstrates your use of the strategies outlined above. Include at least 4 interchanges between you and them.

    Response 1

    Mika Beckley

    Part One:

    Pulling a subordinate aside can sometimes be an intimidating task for some, especially if he/she is one of your top performers. Those motivated self-starters of your team need minimal supervision. I believe it has to be remembered though, that they are human and no one can run at 110% all day, every day. If it is not common to see this individual, it’s important to get them into a comfortable, private setting. Establish rapport and be clear and concise about why you are having a one-on-one with them. Woods stated, “The individual tends to ramble, unable to focus on the main point of the conversation.” (1). It is vital to get to the point and ensure it is clearly understood by the receiving party. Allow them to ask questions or repeat in their own words what was just conveyed to them. Once they are aware of their performance, empathy should be injected deeper into this conversation. This is because if it is not normal behavior, it is possible there may be something occurring in their personal life that is affecting them.

    I’ve had situations where my top performers had fallen below standard and because I had built a trusting relationship with them, they were comfortable opening up to me as to why their work quality was suffering. One specific example was one of my Airmen who was an award winner, top performer, live and bubbly individual who started showing up to work late, not being present at work meetings, looking exhausted, and just not himself. After pulling him to the side in a private setting, he divulged his wife was in the process of divorcing him and the result was his sleepless nights and now stressful life of a broken household with two small children. I always say, be kind because you never know what someone is going through or what inside battles they are fighting. The majority of the time, they just need to be heard. Week 2 Lecture Notes stated, “Properly listening to someone requires more than the mere acknowledgment and it takes practice. You should absorb what they say, while gleaning new information and finding ways to relate to them.” (2) While it is important to relate to them, removing your emotions from the situation is important so that any advice given is given from a subjective standpoint instead of an emotional one. While I agree, that being able to relate in some form or manner can humanize the experience and cause your subordinate to gain deeper trust in you, the point of the conversation is to not only guide them back to the right path but most importantly receive the help they need to do so.

    Techniques that I will employ to build effective relationships are to listen more and talk less. Ross stated, “Presence can be somewhat passive, but empathy requires you to actively listen and hear what is going on for someone else.” I’ve learned that true leadership involves listening and truly knowing your people. It will be easier to tell when they have off days and can get ahead of situations like the example I stated earlier. It’s easier to lead when you can look at a person and know that they aren’t themselves and sometimes it’s a simple venting session that can steer them back on the right track. Being in the military is a 24/7 job, so it is important my subordinate’s quality of life is taken into account. A person cannot be fully present at work to complete their mission if their mind is stressed elsewhere. Johnson stated, “Show that you are an approachable and pleasant person to interact with by smiling honestly and with your whole face, not just your mouth.” (4)

    Part Two:

    Me: Hey John, how are you doing today? (Uses inviting warm (not creepy) smile). How has your family been doing? How’s work today? I’d like to talk to you for a bit if you wouldn’t mind following me to my office.

    John/Employee: Hey boss. I’m okay today. I found out my grandma is sick and has been battling it for a while now. There is a possibility to fly home before things get really bad or to say my last goodbyes. I feel like I haven’t been able to focus at work because of it. I’m really close to her and I’ve been losing sleep and my appetite.

    Me: John, I’m really sorry to hear about your grandmother. I pulled you aside because it’s been noticed that the quality of your work has been suffering lately. I had talked to you about it previously and you were doing okay for a little and then reverted back. You are usually a top performer so I can see why you are struggling. I can understand that losing a family member can be devastating and I will ensure that you get the time off you need to get through this. There is no point in being here if you aren’t present and your mental health is the I’d like to let you know that I am here for you if you need to talk and I ask that you, please come to me if you experiencing a life stressor that will not only cause your work to suffer but also that is affecting your mental health. We have resources that can assist you. Is there anything else going on that I need to be aware of to better help you? What are your plans to get home?

    John: Thank you for being supportive. I plan on getting with my family to find the best time to fly out and I will let you know the details. I have nothing else significantly affecting my life but my grandmother’s deteriorating health has been weighing on me so it’s nice to be seen and heard. I will ensure to keep you in the loop of anything in the future. Thank you for being there.

    Response 2

    Catherine McGuire

    This week‘s discussion prompt and related hypothetical scenario affords us multiple opportunities for expressing our acquired knowledge of leadership, interpersonal relations, the value of empathy, and applying constructive, motivating pressure. We are also challenged to demonstrate the specifics of this week’s lessons by incorporating them into our responses. In my opinion, this is no small task, but as JWMI students, we should be ready.

    Empathy is a vital component of leadership, so much so that to be without it diminishes one’s ability to properly function as the decision-making motivator of an organizational body or team. Serving as the elemental fabric which connects both personal and professional relationships, empathy and social skills are social intelligence, which comprises the interpersonal portion of emotional intelligence (Goleman, 1). Placing this in motion, manifesting empathy looks like listening more and talking less, the intentional practice of mindfulness and focus upon others, and active curiosity (Ross, 2). Empathy can be learned and perfected over time, increasing one’s leadership skills.

    Jack Welch’s 4th Rule for Leadership guides us to establish trusting relationships with others by being candid, transparent, keeping promises, and giving full credit to others for their accomplishments (Welch, 3). Trusting, candid relationships serve as a platform for spring boarding action towards a mission. Gary Vaynerchuk, CEO of VaynerMedia, testifies that empathy has allowed him to build a culture of trust which supersedes the politics and fears which run rampant within a business environment and ushers in speed, which delivers results (JWI505, 4). These strategies directly relate to the manner in which we successfully conduct integral interpersonal discussions, most importantly, difficult conversations.

    Our discussion prompt asks us to discuss our strategy for a meeting with a valuable employee who has exhibited a patterned instability and decline in their performance at work. In a conversation to address their behavior, we must address the following points:

  • What we will do to make a clear and candid point during the conversation
  • How we will remove personal emotion while still maintaining empathy and trust
  • What techniques we should employ to build effective working relationships and why
  • I’ve previously addressed the value of candor in forging trusting relationships, the likes of which every leader should endeavor to build. Empathy greases the works into a team member or employee’s favor, paving the way for taking the edge off of tense discussions. If a leader has competently established a healthy relationship with the team member in question using these foundational elements, then subtracting personal emotion from a conversation will not feel like a cold, robotic encounter from the employee’s perspective. Regarding the hypothetical scenario, the leader should:

  • Incorporate polite candor into the discussion in the same manner as they have built a rapport with the employee
  • Make clear points within the discussion by avoiding extensive trivial chatter and emphasizing the two or three main takeaways from the encounter
  • Kindly explain why you’ve called for a meeting and briefly explain the predicament in which your employee’s behavior places you
  • Avoid personal, emotive words besides that of “I empathize” and “I care” and focus on action words that reinforce redirected behaviors, all while maintaining soft eye contact
  • Spend no more than 50% of your time within the meeting disciplining your employee and listen to their feedback
  • Avoid insulting words or gestures and refrain from enforcing belittling reprimands and disciplinary actions
  • Be sure not to ramble on, engage in a “deer in the headlights” staring contest, and ask the right questions, such as “Do you think there’s a connection between your demanding schedule and your inability to complete projects at the workplace?” (Woods, 5)
  • Incorporate the leadership techniques outlined within Jack Welch’s 8 Rules for Leadership (3)
  • A brief dialogue recording the conversation between myself, the leader, and my employee who has exhibited patterned instability and a decline in their work performance

    Me: Hi, Jim. I wanted to take a few minutes of your time to reflect upon and redirect your priorities here at ACME Inc. It’s been a while since we’ve had a candid, informal review, and there are a few issues at hand which compel me to sit down with you.

    Jim: Hi, Catherine. Ok. Are we going to talk now?

    Me: Now’s a good time as any. I certainly don’t want the dam to break with accumulation; I know I’m being somewhat nebulous, but first, I wanted to ask how you’re doing.

    Jim: Great.

    Me: Well, great.

    Jim: ……

    Me: *chuckling* Look, I don’t want to have a deer-in-the-headlights conversation with you. I don’t want to talk at you, I want to talk to you. I have you on my team because I’ve seen what you can do, and, frankly, I’ve never seen anyone add the flair and personality to their work the way you do. My bosses, however, don’t see it that way. They afford me the autonomy to occupy a position on my team with anyone I choose, as long as that employee remains productive according to their standards. So really, now, it’s just you and me chatting. Tell me, what’s going on at home?

    Jim: My son is growing up too soon! He’s in the third grade already and keeps me busy as his chauffeur to karate and basketball practice. Sandy has her hands full with the baby and claims to want to lose the baby weight, but she’s breastfeeding, so she says she’s not hungry during the day but always sends me out for a late-night sandwich or Chinese food because she’s hungry but doesn’t want to pay $15 extra for DoorDash. And I’m really trying to keep my MBA on track, so instead of painting the garage on my days off, I’m glued to the computer; I’d really rather be going to the gym for a quality workout instead of doing either of those things, but somehow, at the end of the day, I’m content. I guess this is where my ADD comes in handy because I’m doing a little bit of everything on the daily.

    Me: I would agree, except that I need to be sure that the quality of your work doesn’t suffer from it. Did you know that people with ADD tend to be more creative and humorous?

    Jim: Really?

    Me: Yes, really. And a plethora of other endearing things. Let me tell you what I need from you; I need you to log the inventory after every shift without error.

    Jim: That’s always been my duty, and I’m sorry if I haven’t been diligent in doing it every day.

    Me: So you see what I’m referring to? That’s a relief; it saves me from having to retrain you to do your job. I get the feeling that you know most of what I need to say to you about your recent job performance, because I know that you know how to do your job. Jim, can I ask you a question?

    Jim: Uh, yeah. Yes.

    Me: Do you think that your full plate, so to speak, is preventing you from doing your job to your best ability? Do you think you’re spread too thin? I ask this because I want you to help me reach a mutually beneficial solution.

    Jim: Well, in all honesty, I am spread thin, but the baby is sleeping through the night now, and I’ve decided to take the next semester off so that life won’t be as intense for a while.

    Me: Great. Here’s what I’m thinking, I can either write down a list of necessary processes which you’ll complete by the end of every shift and text me when they’re done – I’ll handle the accountability texts with discretion, because I’m not aiming to micromanage you in front of other team members – or you can consider reducing your workload to 30 hours per week. I’ll hire a part-time entry-level employee or two and pay them roughly half of your hourly wage. I want you to take some time to consider these options, and I want you to feel that you have a say in how things are changing at ACME Inc. I want you to sleep on it, so I’ll be checking in with you tomorrow morning so that you can voice your decision. Does that sound fair?

    Jim: I think so. I definitely have a lot of thinking to do.

    Me: Yes, think about it, and if you have any questions in the morning, we’ll discuss those details. For now, I want to go home with the task of steering your role within this company in the right direction. There’s nothing else that I need to know for now. Is there anything you’d like to add?

    Jim: No, Catherine, I’m good.

    Me: Great. Say “hi” to Sandy and the kids for me. Goodnight.

    AMU Online Sales During Buy 1 Get 1 Free Sale Excel Project

    Description

    In this project, you will work with sales data from Top’t Corn, a popcorn company with an online store, multiple food trucks, and two retail stores. You will begin by copying the sales data for one of the retail stores from another workbook. Next, you will insert a new worksheet and enter sales data for the four food truck locations, formatting the data, and calculating totals. You will create a pie chart ton this project, you will work with sales data from Top’t Corn, a popcorn company with an online store, multiple food trucks, and two retail stores. You will begin by copying the sales data for one of the retail stores from another workbook. Next, you will insert a new worksheet and enter sales data for the four food truck locations, formatting the data, and calculating totals. You will create a pie chart to represent the total units sold by location and a column chart to represent sales by popcorn type. You will format the charts, and then set up the worksheet for printing. Next, you help Top’t Corn calculate payments for a loan and decide whether or not the purchase is a good idea. Working with the daily sales data for one of the brick-and-mortar stores, you will apply conditional formatting to find the top 10 sales dates. Y ou will also calculate the sales for each date, and the average, minimum, and maximum sales. You will use Goal Seek to find the appropriate price to reach a higher daily average sales goal. You will use VLOOKUP to look up sales data for a specific date. Finally, you will work with their online sales data to format it as an Excel table and apply sorting and filtering. You will create a PivotTable and a PivotChart from a copy of the online sales data to summarize the sales.

    Skills needed to complete this project: 

    Open a workbook

    Copy a worksheet to another workbook

    • Close a workbook
    • Insert a worksheet
    • Name a worksheet
    • Move a worksheet
    • Enter text
    • Enter numbers
    • Edit text
    • Autofit a column
    • Apply a cell style
    • Add cell shading
    • Change font color
    • Merge and center text across cells
    • Apply bold formatting
    • Apply number formatting
    • Enter a SUM function
    • Copy formula using AutoFill
    • Insert a pie chart
    • Apply a chart Quick Layout
    • Move a chart
    • Insert a column chart
    • Switch the row/column in a column chart
    • Change the chart title
    • Apply a chart Quick Style
    • Show chart data labels
    • Preview how a worksheet will look when printed
    • Change worksheet orientation
    • Change the print margins
    • Scale a worksheet for printing
    • Change the color of a worksheet tab
    • Apply a column width
    • Calculate a loan payment with PMT
    • Enter a simple formula using multiplication
    • Enter a simple formula using subtraction
    • Add cell borders
    • Create a formula referencing cells in another worksheet
    • Enter an AVERAGE function
    • Use the IF function
    • Hide a worksheet
    • Apply date formats
    • Apply Top Ten conditional formatting
    • Use an absolute reference in a formula
    • Name a range of cells
    • Use a named range in a formula
    • Use the MIN function in a formula
    • Use the MAX function in a formula
    • Wrap text
    • Analyze data with Goal Seek
    • Use the VLOOKUP function in a formula
    • Convert data into a table
    • Apply a table Quick Style
    • Use the table Total row
    • Sort data in a table
    • Filter data in a table
    • Create a PivotTable
    • Create a PivotChart
    • Unhide a worksheet
    • Important: Download the resource files needed for this project from the Resources link. If the files download in a zipped folder, make sure to extract the files after downloading the resources zipped folder. Visit the SIMnet instant help for step-by-step instruction.
    • Open the start file EX2019-Capstone-Level3.
      Note: If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the worksheet so you can modify it

    The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it 

    Copy the OldTownStore worksheet from the OldTownSales workbook (downloaded from the Resources link) to the capstone project. 

    Open the Excel file OldTownSales

    Copy the worksheet OldTownStore. In the Move or Copy dialog, be sure to check the Create a copy check box and select your capstone project Excel file from the To book drop-down list. Make the correct selection to ensure the copied worksheet will appear at the end after the TysonsStore2018 worksheet in your capstone workbook.

    1. Close the OldTownSales workbook when you have successfully copied the OldTownStore worksheet to the capstone workbook.

    Before continuing, verify that you are working in the capstone project that you downloaded and not the OldTownSalesworkbook that you downloaded from the Resources link. 

    Insert a new worksheet and rename it: MobileSales

    If necessary, move the MobileSales worksheet so it appears first in the workbook.

    1. In the MobileSales worksheet, enter the text and sales data as shown in the table below. Check your work carefully. 

    A

    B

    1. C

    D

    1. E

    1

    Top’t Corn Mobile Sales (July)

    2

    1. Truck Location

    3

    Farragut Square

    GW

    1. Georgetown

    K Street

    4

    Old Bay

    1. 2500

    800

    600

    900

    1. 5

    Truffle

    3200

    600

    1. 1200

    1500

    6

    1. Sea Salt and Caramel

    4200

    1500

    1400

    1200

    Still working with the MobileSales worksheet, format the data as follows: 

    Apply the Title cell style to cell A1.

    Apply the Purple fill color to cell A1. Use the first color at the right in the row of Standard colors.

    Apply the White, Background 1 font color to cell A1. Use the first color at the left in the first row of Theme colors.

    Merge and center the worksheet title across cells A1:E1. 

    Apply the Heading 2 cell style to cell B2.

    Merge and center cells B2:E2. 

    Bold cells B3:E3.

    Apply the Accounting Number Format with 0 digits after the decimal to cells B4:E6.

    AutoFit columns A:E.

    In the MobileSales worksheet, calculate total sales for each of the truck locations. 

    Enter the word Total in cell A7. 

    Enter a SUM function in cell B7 to calculate the total of cells B4:B6. 

    Use AutoFill to copy the formula to cells C7:E7.

    Apply the Total cell style to cells A7:E7.

    In the MobileSales worksheet, insert a pie chart (2-D Pie) to show the Old Bay sales for the month by location. Each piece of the pie should represent the Old Bay sales for a single location.
    Note: You must complete this step correctly in order to receive points for completing the next step. Check your work carefully.

    Working with the pie chart you just created, modify the pie chart as follows: 

    Apply the Layout 6 Quick Layout. 

    Move the chart so it appears below the sales data.

    In the MobileSales worksheet insert a clustered column chart (2-D Column) to show the sales for each type of popcorn for each location. Do not include the totals.
    Note: You must complete this step correctly in order to receive points for completing the next step. Check your work carefully.

    Working with the column chart you just created, modify the column chart as follows:

    If necessary, modify the chart so each location is represented by a data series and the popcorn types are listed along the x axis. 

    Change the chart title to: July Sales by Popcorn Type

    Apply the Style 5 chart Quick Style.

    Display the chart data labels using the Outside End option. 

    If necessary, move the chart so it is next to the pie chart and the top of the charts are aligned. 

    Preview how the MobileSales worksheet will look when printed, and then apply print settings to print the worksheet on a single page. Hint: If you have one of the charts selected, deselect it before previewing the worksheet. Preview the worksheet again when you are finished to check your work. 

    Change the orientation so the page is wider than it is tall. 

    Change the margins to the preset narrow option.

    Change the printing scale so all columns will print on a single page. 

    Top’t Corn is considering a new truck purchase. Calculate the monthly loan payments and total cost
    of the loan. 

    Insert a new worksheet between the MobileSales sheet and the OnlineSales sheets.

    Name the new worksheet: TruckLoan

    Change the color of the TruckLoan worksheet tab to Orange. Use the third color from the left in the row of Standard colors. 

    Enter the loan terms in the TruckLoan worksheet as shown below. 

    A

    B

    1

    Price

    55000

    2

    Interest (annual)

    3%

    3

    Loan term (in months)

    24

    4

    Monthly payment

    AutoFit column A.

    Set the width of column B to 16.

    Apply the Currency number format to cell B1. Display two digits after the decimal.

    Enter a formula using the PMT function in cell B4. Be sure to use a negative value for the
    Pv argument.

    In cell A6, type: Total payments

    In cell B6, enter a formula to calculate the total paid over the life of the loan (the monthly payment amount * the number of payments). Use cell references. 

    In cell A7, type: Interest paid

    In cell B7, enter a formula to calculate the total interest paid over the life of the loan (the total payments – the original price of the truck). Use cell references. 

    Apply borders using the Thick Outside Borders option around cells A6:B7.

    In cell A9, type: Average sales

    In cell B9, enter a formula to calculate the average sales per month for the truck locations. Hint: Use cells B7:E7 from the MobileSales worksheet as the function argument.

    Apply the Currency number format to cell B9. Display two digits after the decimal.

    In cell A10, type: Buy new truck?

    In cell B10, enter a formula using the IF function to display Yes if the monthly payment for the truck loan is less than the average sales per month for the current trucks. Display
    No if it is not. 

    This workbook includes two worksheets for data from the Tysons store. You should only be working with the latest data from 2019. 

    Hide the TysonsStore2018 worksheet.

    Complete the following steps in the TysonsStore2019 worksheet:

    Select cells A2:A32, and apply the Short Date date format.

    Find the top ten sales items for the month. Select cells B2:D32 and use conditional formatting to apply a green fill with dark green text to the top 10 values.

    In cell F2, enter a formula to calculate the daily total in dollars. Multiply the value in the Daily Total (# Sold) column by the current price per box in cell K1. Use an absolute reference where appropriate and copy the formula to cells F3:F32.

    In cell G2, enter a formula using the IF function to determine whether the daily sales goal in cell K2 was met. Display yes if the value in the Daily Total ($) column is greater than or equal to the daily sales goal. Display no if it is not. Use an absolute reference where appropriate and copy the formula to cells G3:G32.

    Create a named range DailyTotals for cells F2:F32. 

    In cell K3, enter a formula using the named range DailyTotals to calculate the average daily
    sales in dollars. 

    In cell K4, enter a formula using the named range DailyTotals to find the lowest daily sales
    in dollars.

    In cell K5, enter a formula using the named range DailyTotals to find the highest daily sales
    in dollars.

    Wrap the text in cell J7. 

    Use Goal Seek to find the new price per box (cell K8) to reach a new daily average sales goal of $3,000 in cell K7. Accept the solution found by Goal Seek. 

    Modify cell K8 to show two places after the decimal. 

    Create a named range SalesData for cells A2:G32. 

    In cell K10, enter 8/19/2019 as the lookup date.

    In cell K11, enter a formula using VLOOKUP to display whether or not the sales goal was met for the date listed in cell K10. Use the named range SalesData for the Table_array argument. The formula should return the value in the Sales Goal Met?column (column 7 in the data array) only when there is an exact match.

    Make a copy of the OnlineSales worksheet and name it PivotData. The PivotData worksheet should be the last worksheet in the workbook.

    Go to the OnlineSales worksheet and format the sales data as a table using the table style
    Aqua, Table Style Light 9.

    Continue working with the table on the OnlineSales worksheet and display the table Total row. 

    Display the total for the Quantity column.

    Remove the count from the State column.

    Continue working with the table on the OnlineSales worksheet and sort the data alphabetically by values in the Item column.

    Continue working with the table on the OnlineSales worksheet and filter the table to show only rows where the value in the Statecolumn is MD.

    Create a PivotTable using the data in cells A3:D120 from the data in the PivotData worksheet. The PivotTable should appear on its own worksheet. Use values from the Item column as the rows and the sum of values in the Quantity column as the values.

    Name the PivotTable worksheet: PivotTable It should be located to the left of the PivotData worksheet.

    Insert a PivotChart on the PivotTable worksheet. Use a pie chart to represent the total quantity
    for each item. If necessary, move the PivotChart to the right of the PivotTable so it does not cover the data.

    This workbook includes a hidden worksheet with online sales data from the 2018 buy one get one free sale. 

    Unhide the BOGOSale2018 worksheet.

    Save and close the workbook.

    Upload and save your project file.

    Submit project for grading.

    represent the total units sold by location and a column chart to represent sales by popcorn type. You will format the charts, and then set up the worksheet for printing. Next, you help Top’t Corn calculate payments for a loan and decide whether or not the purchase is a good idea. Working with the daily sales data for one of the brick-and-mortar stores, you will apply conditional formatting to find the top 10 sales dates. Y ou will also calculate the sales for each date, and the average, minimum, and maximum sales. You will use Goal Seek to find the appropriate price to reach a higher daily average sales goal. You will use VLOOKUP to look up sales data for a specific date. Finally, you will work with their online sales data to format it as an Excel table and apply sorting and filtering. You will create a PivotTable and a PivotChart from a copy of the online sales data to summarize the sales.

    Skills needed to complete this project: 

    Open a workbook

    Copy a worksheet to another workbook

    Close a workbook

    Insert a worksheet

    Name a worksheet

    Move a worksheet

    Enter text

    Enter numbers

    1. Edit text

    Autofit a column

    Apply a cell style

    1. Add cell shading

    Change font color

    Merge and center text across cells

    1. Apply bold formatting

    Apply number formatting

    Enter a SUM function

    1. Copy formula using AutoFill

    Insert a pie chart

    Apply a chart Quick Layout

    1. Move a chart

    Insert a column chart

    Switch the row/column in a column chart

    1. Change the chart title

    Apply a chart Quick Style

    Show chart data labels

    1. Preview how a worksheet will look when printed

    Change worksheet orientation

    Change the print margins

    1. Scale a worksheet for printing

    Change the color of a worksheet tab

    Apply a column width

    1. Calculate a loan payment with PMT

    Enter a simple formula using multiplication

    Enter a simple formula using subtraction

    1. Add cell borders

    Create a formula referencing cells in another worksheet

    Enter an AVERAGE function

    1. Use the IF function

    Hide a worksheet

    Apply date formats

    1. Apply Top Ten conditional formatting

    Use an absolute reference in a formula

    Name a range of cells

    Use a named range in a formula

    1. Use the MIN function in a formula

    Use the MAX function in a formula

    Wrap text

    1. Analyze data with Goal Seek

    Use the VLOOKUP function in a formula

    Convert data into a table

    1. Apply a table Quick Style

    Use the table Total row

    Sort data in a table

    1. Filter data in a table

    Create a PivotTable

    Create a PivotChart

    Unhide a worksheet

    Important: Download the resource files needed for this project from the Resources link. If the files download in a zipped folder, make sure to extract the files after downloading the resources zipped folder. Visit the SIMnet instant help for step-by-step instruction.

    Open the start file EX2019-Capstone-Level3.
    Note: If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the worksheet so you can modify it

    1. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it 

    Copy the OldTownStore worksheet from the OldTownSales workbook (downloaded from the Resources link) to the capstone project. 

    1. Open the Excel file OldTownSales

    Copy the worksheet OldTownStore. In the Move or Copy dialog, be sure to check the Create a copy check box and select your capstone project Excel file from the To book drop-down list. Make the correct selection to ensure the copied worksheet will appear at the end after the TysonsStore2018 worksheet in your capstone workbook.

    Close the OldTownSales workbook when you have successfully copied the OldTownStore worksheet to the capstone workbook.

    1. Before continuing, verify that you are working in the capstone project that you downloaded and not the OldTownSalesworkbook that you downloaded from the Resources link. 

    Insert a new worksheet and rename it: MobileSales

    If necessary, move the MobileSales worksheet so it appears first in the workbook.

    1. In the MobileSales worksheet, enter the text and sales data as shown in the table below. Check your work carefully. 

    A

    B

    C

    D

    1. E

    1

    1. Top’t Corn Mobile Sales (July)

    2

    Truck Location

    1. 3

    Farragut Square

    GW

    Georgetown

    1. K Street

    4

    Old Bay

    1. 2500

    800

    600

    1. 900

    5

    Truffle

    1. 3200

    600

    1200

    1500

    1. 6

    Sea Salt and Caramel

    4200

    1. 1500

    1400

    1200

    1. Still working with the MobileSales worksheet, format the data as follows: 

    Apply the Title cell style to cell A1.

    Apply the Purple fill color to cell A1. Use the first color at the right in the row of Standard colors.

    1. Apply the White, Background 1 font color to cell A1. Use the first color at the left in the first row of Theme colors.

    Merge and center the worksheet title across cells A1:E1. 

    Apply the Heading 2 cell style to cell B2.

    1. Merge and center cells B2:E2. 

    Bold cells B3:E3.

    Apply the Accounting Number Format with 0 digits after the decimal to cells B4:E6.

    AutoFit columns A:E.

    In the MobileSales worksheet, calculate total sales for each of the truck locations. 

    1. Enter the word Total in cell A7. 

    Enter a SUM function in cell B7 to calculate the total of cells B4:B6. 

    Use AutoFill to copy the formula to cells C7:E7.

    Apply the Total cell style to cells A7:E7.

    1. In the MobileSales worksheet, insert a pie chart (2-D Pie) to show the Old Bay sales for the month by location. Each piece of the pie should represent the Old Bay sales for a single location.
      Note: You must complete this step correctly in order to receive points for completing the next step. Check your work carefully.

    Working with the pie chart you just created, modify the pie chart as follows: 

    Apply the Layout 6 Quick Layout. 

    Move the chart so it appears below the sales data.

    1. In the MobileSales worksheet insert a clustered column chart (2-D Column) to show the sales for each type of popcorn for each location. Do not include the totals.
      Note: You must complete this step correctly in order to receive points for completing the next step. Check your work carefully.

    Working with the column chart you just created, modify the column chart as follows:

    If necessary, modify the chart so each location is represented by a data series and the popcorn types are listed along the x axis. 

    Change the chart title to: July Sales by Popcorn Type

    Apply the Style 5 chart Quick Style.

    Display the chart data labels using the Outside End option. 

    If necessary, move the chart so it is next to the pie chart and the top of the charts are aligned. 

    Preview how the MobileSales worksheet will look when printed, and then apply print settings to print the worksheet on a single page. Hint: If you have one of the charts selected, deselect it before previewing the worksheet. Preview the worksheet again when you are finished to check your work. 

    Change the orientation so the page is wider than it is tall. 

    Change the margins to the preset narrow option.

    Change the printing scale so all columns will print on a single page. 

    Top’t Corn is considering a new truck purchase. Calculate the monthly loan payments and total cost
    of the loan. 

    Insert a new worksheet between the MobileSales sheet and the OnlineSales sheets.

    Name the new worksheet: TruckLoan

    Change the color of the TruckLoan worksheet tab to Orange. Use the third color from the left in the row of Standard colors. 

    Enter the loan terms in the TruckLoan worksheet as shown below. 

    A

    B

    1

    Price

    55000

    2

    Interest (annual)

    3%

    3

    Loan term (in months)

    24

    4

    Monthly payment

    AutoFit column A.

    Set the width of column B to 16.

    Apply the Currency number format to cell B1. Display two digits after the decimal.

    Enter a formula using the PMT function in cell B4. Be sure to use a negative value for the
    Pv argument.

    In cell A6, type: Total payments

    In cell B6, enter a formula to calculate the total paid over the life of the loan (the monthly payment amount * the number of payments). Use cell references. 

    In cell A7, type: Interest paid

    In cell B7, enter a formula to calculate the total interest paid over the life of the loan (the total payments – the original price of the truck). Use cell references. 

    Apply borders using the Thick Outside Borders option around cells A6:B7.

    In cell A9, type: Average sales

    In cell B9, enter a formula to calculate the average sales per month for the truck locations. Hint: Use cells B7:E7 from the MobileSales worksheet as the function argument.

    Apply the Currency number format to cell B9. Display two digits after the decimal.

    In cell A10, type: Buy new truck?

    In cell B10, enter a formula using the IF function to display Yes if the monthly payment for the truck loan is less than the average sales per month for the current trucks. Display
    No if it is not. 

    This workbook includes two worksheets for data from the Tysons store. You should only be working with the latest data from 2019. 

    Hide the TysonsStore2018 worksheet.

    Complete the following steps in the TysonsStore2019 worksheet:

    Select cells A2:A32, and apply the Short Date date format.

    1. Find the top ten sales items for the month. Select cells B2:D32 and use conditional formatting to apply a green fill with dark green text to the top 10 values.

    In cell F2, enter a formula to calculate the daily total in dollars. Multiply the value in the Daily Total (# Sold) column by the current price per box in cell K1. Use an absolute reference where appropriate and copy the formula to cells F3:F32.

    In cell G2, enter a formula using the IF function to determine whether the daily sales goal in cell K2 was met. Display yes if the value in the Daily Total ($) column is greater than or equal to the daily sales goal. Display no if it is not. Use an absolute reference where appropriate and copy the formula to cells G3:G32.

    1. Create a named range DailyTotals for cells F2:F32. 

    In cell K3, enter a formula using the named range DailyTotals to calculate the average daily
    sales in dollars. 

    In cell K4, enter a formula using the named range DailyTotals to find the lowest daily sales
    in dollars.

    1. In cell K5, enter a formula using the named range DailyTotals to find the highest daily sales
      in dollars.

    Wrap the text in cell J7. 

    Use Goal Seek to find the new price per box (cell K8) to reach a new daily average sales goal of $3,000 in cell K7. Accept the solution found by Goal Seek. 

    1. Modify cell K8 to show two places after the decimal. 

    Create a named range SalesData for cells A2:G32. 

    In cell K10, enter 8/19/2019 as the lookup date.

    In cell K11, enter a formula using VLOOKUP to display whether or not the sales goal was met for the date listed in cell K10. Use the named range SalesData for the Table_array argument. The formula should return the value in the Sales Goal Met?column (column 7 in the data array) only when there is an exact match.

    Make a copy of the OnlineSales worksheet and name it PivotData. The PivotData worksheet should be the last worksheet in the workbook.

    1. Go to the OnlineSales worksheet and format the sales data as a table using the table style
      Aqua, Table Style Light 9.

    Continue working with the table on the OnlineSales worksheet and display the table Total row. 

    Display the total for the Quantity column.

    Remove the count from the State column.

    1. Continue working with the table on the OnlineSales worksheet and sort the data alphabetically by values in the Item column.

    Continue working with the table on the OnlineSales worksheet and filter the table to show only rows where the value in the Statecolumn is MD.

    Create a PivotTable using the data in cells A3:D120 from the data in the PivotData worksheet. The PivotTable should appear on its own worksheet. Use values from the Item column as the rows and the sum of values in the Quantity column as the values.

    1. Name the PivotTable worksheet: PivotTable It should be located to the left of the PivotData worksheet.

    Insert a PivotChart on the PivotTable worksheet. Use a pie chart to represent the total quantity
    for each item. If necessary, move the PivotChart to the right of the PivotTable so it does not cover the data.

    This workbook includes a hidden worksheet with online sales data from the 2018 buy one get one free sale. 

    Unhide the BOGOSale2018 worksheet.

    1. Save and close the workbook.

    MGT 430 SLU Google Case Study Analysis

    Description

    Integrate the core values of Saint Leo University that you believe should apply to this issue.

    Case Studies guidelines: Each case study will include issues/questions to address. The cases are intended for students to take a comprehensive look at the current event topics as related to business and society. Students should explore the issue using the text as well as personal, intellectual, academic references, and/or experiences, thus applying their knowledge to these cases. Where sources are used, proper notation must be included. Responses to each assigned question in all assigned case studies should be in paragraph form, be double-spaced, and be between 250-300 words in.

    St Leo Core Values: Core Values: The SLU core values of responsible stewardship, excellence, and integrity will be emphasized in this course. Responsible Stewardship: Our Creator blesses us with an abundance of resources. We foster a spirit of service to employ our resources to university and community development. We must be resourceful. We must optimize and apply all of the resources of our community to fulfill Saint Leo University’s mission and goals. Excellence: Saint Leo University is an educational enterprise. All of us, individually and collectively, work hard to ensure that our students develop the character, learn the skills, and assimilate the knowledge essential to become morally responsible leaders. The success of our University depends upon a conscientious commitment to our mission, vision, and goals. Integrity: The commitment of Saint Leo University to excellence demands that its members live its mission and deliver on its promise. The faculty, staff, and students pledge to be honest, just, and consistent in word and deed.

    CASE- Google and the Right to Be Forgotten

    In 2009, Mario Costeja Gonzalez, a self-employed attorney living in a small town outside Madrid, Spain, casually “googled” himself and was startled by what came up on his computer screen. Prominently displayed in the search results was a brief legal notice that had appeared more than a decade earlier in a local newspaper, La Vanguardia, which listed property seized and being auctioned by a government agency for nonpayments of debts. Among the properties was a home jointly owned by Costeja and his wife.

    Costeja immediately realized that this information could damage his reputation as an attorney. Equally troubling, the information was no longer factual. He had paid his debt nearly a decade earlier. Abanlex, Costeja’s small law firm, depended on the Internet to gain much of its new business, which was often generated by a Google search. Potential clients might choose not to hire him, based on the old auction notice, he reflected. His mind then turned to the possible effects of this kind of information on other people’s livelihoods. “There are people who cannot get a job because of content that is irrelevant,” he thought.1 “I support freedom of expression and I do not defend censorship. [However, I decided] to fight for the right to request the deletion of data that violates the honor, dignity and reputation of individuals.”2

    The next week, Costeja wrote to La Vanguardia and requested that it remove the article about his debt notice, because it had had been fully resolved a number of years earlier and reference to it now was therefore entirely irrelevant.3 In doing so, he was making use of his rights under Spain’s strong data protection policies, which recognized the protection and integrity of personal data as a constitutional right under Section 18 of the nation’s Data Protection Act.4 In response, the newspaper informed him that it had recently uploaded to the Internet all its past archives, dating back to 1881, to allow them to be searched by the public. It also noted that the auction notice had originally been publicly posted in order to secure as many bidders as possible. The newspaper refused Costeja’s request, stating that the information was obtained from public records and had thus been published lawfully.5

    To be sure, the real problem for Costeja was not that the notice had appeared in La Vanguardia’s digital library, but that it had shown up in the results of the most widely used search engine in the world, Google, where potential clients might use it to judge his character.6 Following this reasoning, Costeja then wrote to Google Spain, the firm’s Spanish affiliate, only to be told that the parent company, Google Inc., was the entity responsible for the development of search results.7 Costeja was taken aback by this development. “The resources Google has at their disposal aren’t like those of any other citizens,” he reflected.8 Costeja felt he would be at a disadvantage in a lawsuit against an industry giant like Google.

    In March 2010, after his unsuccessful attempts with the newspaper and Google Spain, Costeja turned to Spain’s Data Protection Agency (SDPA), the government agency responsible for enforcing the Data Protection Act. “Google in Spain asked me to address myself to its headquarters in the U.S., but I found it too far and difficult to launch a complaint in the U.S., so I went to the agency in Spain to ask for their assistance. They said I was right, and the case went to court,” he explained.9 In a legal filing, Costeja requested, first, that the agency issue an administrative order requiring La Vanguardia either to remove or alter the pages in question (so that his personal data no longer appeared) or to use certain tools made available by search engines in order to shield the data from view. Second, he requested that the agency require that Google Spain or Google Inc. remove or conceal his personal data so that it no longer appeared in the search results and in the links to La Vanguardia. Costeja stated that his debt had been fully resolved.10

    With these steps, a small-town Spanish lawyer had drawn one of the world’s richest and best-known companies, Google, into a debate over the right to be forgotten.

    Google, Inc.

    Google Inc. was a technology company that built products and provides services to organize information. Founded in 1998 and headquartered in Mountain View, CA, Google’s mission was to organize the world’s information and make it universally accessible and useful. It employed more than 55,000 people and had revenues of $45 billion. The company also had 70 offices in more than 40 countries.

    The company’s main product, Google Search, provided information online in response to a user’s search. Google’s other well-known products provided additional services. For example, Google Now provided information to users when they needed it, and its Product Listing Ads offered product image, price, and merchant information. The company also provided AdWords, an auction-based advertising program and AdSense, which enabled websites that were part of the Google network to deliver ads. Google Display was a display advertising network; DoubleClick Ad Exchange was a marketplace for the trading display ad space; and YouTube offered video, interactive, and other ad formats.

    Search Technology

    In its core business, Google conducted searches in three stages: crawling and indexing, applying algorithms, and fighting spam.

    Crawlers, programs that browsed the web to create an index of data, looked at web pages and followed links on those pages. They then moved from link to link and brought data about those web pages back to Google’s servers. Google would then use this information to create an index to know exactly how to retrieve information for its users. Algorithms were the computer processes and formulas that took users’ questions and turned them into answers. At the most basic level, Google’s algorithms looked up the user’s search terms in the index to find the most appropriate pages. For a typical query, thousands, if not millions, of web pages might have helpful information. Google’s algorithms relied on more than 200 unique signals or “clues” that made it possible to guess what an individual was really looking for. These signals included the terms on websites, the freshness of content, the region, and the page rank of the web page.11 Lastly, the company fought spam through a combination of computer algorithms and manual review. Spam sites attempted to game their way to the top of search results by repeating keywords, buying links that passed Google’s Page Rank process, or putting invisible text on the screen. Google scouted out and removed spam because it could make legitimate websites harder to find. While much of this process was automated, Google did maintain teams whose job was to review sites manually.

    Policy on Information Removal

    Google’s policy on the general removal of information was the following:

    Upon request, we’ll remove personal information from search results if we believe it could make you susceptible to specific harm, such as identity theft or financial fraud. This includes sensitive government ID numbers like U.S. Social Security numbers, bank account numbers, credit card numbers and images of signatures. We generally don’t process removals of national ID numbers from official government websites because in those cases we consider the information to be public. We sometimes refuse requests if we believe someone is attempting to abuse these policies to remove other information from our results.1

    Apart from this general policy, Google Inc. also removed content or features from its search results for legal reasons. For example, in the United States, the company would remove content with valid notification from the copyright holder under the Digital Millennium Copyright Act (DMCA), which was administered by the U.S. Copyright Office. The DCMA provided recourse for owners of copyrighted materials who believed that their rights under copyright law had been infringed upon on the Internet.14 Under the notice and takedown procedure of the law, a copyright owner could notify the service provider, such as Google, requesting that a website or portion of a website be removed or blocked. If, upon receiving proper notification, the service provider promptly did so, it would be exempt from monetary liability.

    Google regularly received such requests from copyright holders and those that represented them, such as the Walt Disney Company and the Recording Industry Association page 483of America. Google produced and made public a list of the domain portions of URLs that had been the subject of a request for removal, and noted which ones had been removed. As of July 2015, it had removed more than 600,000 URLs out of more than 2.4 million requests.

    Likewise, content on local versions of Google was also removed when required by national laws. For example, content that glorified the Nazi party was illegal in Germany, and content that insulted religion was illegal in India.16 The respective governments, via a court order or a routine request as described above, typically made these requests. Google reviewed these requests to determine if any content should be removed because it violated a specific country’s law.

    When Google removed content from search results for legal reasons, it first displayed a notification that the content had been removed and then reported the removal to www.chillingeffects.org, a website established by the Electronic Frontier Foundation and several law schools. This website, which later changed its name to lumendatabase.org, collected and analyzed legal complaints and requests for removal of a broad set of online materials. It was designed to help Internet users know their rights and understand the law. Researchers could use the data to study the prevalence of legal threats and the source of content removals. This database also allowed the public to search for specific takedown notifications.17

    Google removed content quickly. Its average processing time across all copyright infringement removal requests submitted via its website was approximately 6 hours. Different factors influenced the processing time, including the method of delivery, language, and completeness of the information submitted.

    The Right to Be Forgotten

    The right to be forgotten can be understood as peoples’ right to request that information be removed from the Internet or other repositories because it violated their privacy or was no longer relevant. This right assumed greater prominence in the digital era, when people began finding it increasingly difficult to escape information that had accumulated over many years, resulting in expressions such as “the net never forgets,” “everything is in the cloud,” “reputation bankruptcy,” and “online reputation.”18 According to Jeffrey Rosen, professor of law at George Washington University, the intellectual roots of the right to be forgotten could be found in French law, “which recognizes le droit à l’oubli—or the ‘right of oblivion’—a right that allows a convicted criminal who has served his time and been rehabilitated to object to the publication of the facts of his conviction and incarceration.”19

    Although the right to be forgotten was rooted in expunging criminal records, the rise of the Internet had given the concept a new, more complex meaning. Search engines enabled users to access information on just about any topic with considerable ease. The ease with which information could be shared, stored, and retrieved through online search raised issues of both privacy and freedom of expression. On the one hand, when opening a bank account, joining a social networking website, or booking a flight online, a consumer would voluntarily disclose vital personal information such as name, address, and credit card numbers. Consumers were often unsure of what happened to their data and were concerned that it might fall into the wrong hands—that is, that their privacy would be violated.

    On the other hand, by facilitating the retrieval of information, search engines enhanced individuals’ freedom to receive and impart information. Any interference with search engine activities could therefore pose a threat to the effective enjoyment of these rights.20 As Van Alsenoy, a researcher at the Interdisciplinary Center for Law and Information Communication Technology, argued, “In a world where search engines are used as the main tool to find relevant content online, any governmental interference in the provisioning of these services presents a substantial risk that requires close scrutiny.

    Europe

    Since the 1990s, both the European Union and its member states (such as Spain) had enacted laws that addressed the right to privacy and, by extension, the right to be forgotten.

    A fundamental right of individuals to protect their data was introduced in the EU’s original data protection law, passed in 1995. Specifically, the European Data Protection Directive 95/46 defined the appropriate scope of national laws relating to personal data and the processing of those data. According to Article 3(1), Directive 95/46 applied “to the processing of personal data wholly or partly by automatic means, and to the processing otherwise than by automatic means of personal data which form part of a filing system or are intended to form part of a filing system.”22 Article 2(b) of the EU Data Protection Directive 95/46 defined the processing of personal data as

    any operation or set of operations which is performed upon personal data, whether or not by automatic means, such as collection, recording, organization, storage, adaptation or alteration, retrieval, consultation, use, disclosure by transmission, dissemination or otherwise making available, alignment or combination, blocking, erasure or destruction.

    Individual countries within the European Union also enacted their own laws, which were sometimes stronger than those of the EU. For example, in Spain, the protection of data was a constitutional right. The Spanish Constitution recognized the right to personal privacy, secrecy of communications, and the protection of personal data. These rights were protected through the Data Protection Act (the “Act”), passed in 1999, which incorporated the 1995 European Directive on data protection, and was enforced by the Spanish Data Protection Agency (SDPA). Created in 1993, this agency was relatively inactive until the passing of the Act, which gave it more powers and a mandate to enforce privacy rules in a wide range of situations.23

    The Spanish agency exercised its powers broadly. For example, in 2013, it fined telecom firm Telefonica SA €20,000 for twice listing an individual’s phone number in local phone books without the individual’s prior consent. In 2008, the agency fined a marketing company €600 for using “recommend this to a friend” icons on websites, saying that senders of recommendation e-mails had to first request the recipient’s permission. The agency had also successfully required anyone using security cameras to clearly mark their presence with a recognizable icon. Supporters of this move have highlighted the importance of transparency in protecting one’s privacy.24

    Over time, however, differences in the way that each EU country interpreted privacy rights led to an uneven level of protection for personal data, depending on where an page 485individual lived or bought goods and services. This led the European high court to take a second look, in 2013, at the original law.25 A European Commission memo at that time noted that the right “is about empowering individuals, not about erasing past events or restricting freedom of the press.”26 The changes were intended to give citizens more control over their personal data, making it easier to access and improve the quality of information they received about what happened to their data once they decided to share it. An unanswered question, however, was the latitude given to national courts and regulators across Europe to set the parameters by which these requests could be made.

    The United States

    U.S. courts had taken a very different approach to privacy and to the right to be forgotten. A few U.S. laws recognized the right to be forgotten; the Fair Credit Reporting Act of 1970, for example, gave individuals the right to delete certain negative information about their credit—such as late payments, tax liens, or judgments—seven years from the date of the delinquency. But, for the most part, fundamental differences in legal philosophy made this right less likely to become widely supported in the United States. In an article published in the Atlantic in May 2014, Matt Ford suggested that in the U.S. context, one person’s right to be forgotten logically imposed a responsibility to forget upon someone else, a notion that was alien to American law. The First Amendment to the Constitution barred the government from interfering with free speech. Law professor Rosen argued that the First Amendment would make a right to be forgotten virtually impossible, not only to create but to enforce. For example, the U.S. Supreme Court ruled in 1989 that penalizing a newspaper for publishing truthful, lawfully obtained information from the public record was unconstitutional

    The Lawsuit and Court Decision

    The main focus of Costeja’s complaint before Spanish Data Protection Agency (SDPA) was his request that La Vanguardia remove the debt notice from its archives. In doing so, he was claiming his constitutional right to protect the integrity of his personal data. Costeja’s request had two parts: that (1) La Vanguardia be required either to remove or alter the pages in question or to use certain tools made available by search engines in order to protect the data and (2) that Google Spain or Google Inc. be required to remove or conceal the personal data relating to him so that the data no longer appeared in search results.

    In July 2010, two months after Costeja’s original request, the SDPA ordered Google Spain and Google Inc. to take “all reasonable steps to remove the disputed personal data from its index and preclude further access,” upholding that part of the complaint.29 However, the SDPA rejected Costeja’s complaint as it related to La Vanguardia, because it considered that the publication by it of the information in question was legally justified.

    A year later, Google filed an appeal against the decision by the SDPA before the Audiencia Nacional in Madrid, Spain’s highest national court. In March 2012, this court referred the case to the European Court of Justice, the EU’s high court, for a preliminary ruling.31

    In their briefs, Google Spain and Google Inc.’s argument hinged on the meaning of “personal data” and “crawling.” Crawling, as noted above, was the use of software programs to find multiple websites that responded to requests for information online.32 These programs were configured to look for information on the Internet, according to a set of criteria that told them where to go and when.33 Once the relevant web pages had been copied and collected, their content was analyzed and indexed.34 Google compared its search engine index to an index at the back of a textbook, in that it included information about words and their locations.35

    Specifically, Google argued before the European Court of Justice that because it crawled and indexed websites “indiscriminately” (that is, without a deliberate intent to process personal data as such), no processing of personal data within the meaning of Article 2 (b) of the EU Data Protection Directive 95/46 actually took place. This absence of intent, the company argued, clearly distinguished Google’s activities as a search engine provider from the processing of personal data as interpreted by the Court.

    Google’s other main argument was that the publisher of the information should be the sole controller of data, not the search engine. After all, its attorneys argued, Google’s intervention was purely accessory in nature; it was merely making information published by others more readily accessible. If a publisher, for whatever reason, decided to remove certain information from its website, this information would (eventually) be removed from Google’s index and would no longer appear in its search results. As a result, Google’s counsel argued, the role of a search engine should be thought of as an “intermediary.”

    In May 2014, the European Court of Justice ruled against Google. The court found the Internet search provider was responsible for the processing of personal data that appeared on web pages published by third parties. It further required Google to remove links returned in search results based on an individual’s name when those results were deemed to be “inadequate, irrelevant or no longer relevant, or excessive.” At the heart of the court’s logic was the process that Google used to produce its search results. The official ruling explained the court’s rationale:

    The Court points out in this context that processing of personal data carried out by such an operator enables any Internet user, when he makes a search on the basis of an individual’s name, to obtain, through the list of results, a structured overview of the information relating to that individual on the internet. The Court observes, furthermore, that this information potentially concerns a vast number of aspects of his private life and that, without the search engine, the information could not have been interconnected or could have been only with great difficulty.

    In essence, the Court ruled that an activity, “whether or not by automatic means” could be considered to be the “processing of personal data” within the meaning of Article 2(b), even page 487if no intention to process such data existed.37 The court’s ruling applied to any search engine operators that had a branch or a subsidiary in any of the 28 member states of the EU.

    Costeja’s lawyer, Joaquín Muñoz, was pleased with the ruling. “When you search for something in Google, they don’t scour the entire Internet for you and then give you a result. They’ve stored links, organized them, and they show them based on a criteria they’ve decided upon.”39 As for Costeja, he expressed satisfaction with the result of his four-year legal crusade. Speaking of the court’s decision, he said, “I think this is the correct move. You have to provide a path for communication between the user and the search engine. Now that communication can take place.

    Google’s Application of the Ruling

    For its part, Google—although disappointed with the ruling—set about complying with it. Soon after the court decision, it removed Costeja’s disputed information from its search results. But, the company also took mre general action.

    The Court’s decision recognized Google as a data controller, or the operator of the search engine and the party responsible for its data. As such, the court said, Google was required to police its links and put into place a mechanism to address individual concerns. Accordingly, shortly after the ruling was announced, Google set up an online form for users (from the European Union only) to request the right to be forgotten. The company website stated that each request would be evaluated individually and that Google would attempt to “balance the privacy rights of the individual with the public’s interest to know and the right to distribute information.”41 Once an individual had filled out the form, he or she received a confirmation. Each request was assessed on a case-by-case basis. Occasionally, Google would ask for more information from the individual. Once Google had made its decision, it notified the individual by e-mail, providing a brief explanation if the decision was against removal. If so, the individual could request that a local data protection authority review Google’s decision.

    In evaluating a request, Google looked at whether the results included outdated or inaccurate information about the individual. It also weighed whether or not the information was of public interest. For example, Google generally retained the information if it related to financial scams, professional malpractice, criminal convictions, or a government official’s public conduct.42

    At the same time, Google invited eight independent experts to form an advisory council expressly to “advise it on performing the balancing act between an individual’s right to privacy and the public’s interest in access to information.”43 The committee included three professors (two of law and one of ethics), a newspaper editorial director, a former government page 488official, and three privacy and freedom of speech experts (including one from the United Nations). Google’s CEO and chief legal officer served as conveners. The committee’s job was to provide recommendations to Google on how to best implement the EU court’s ruling.

    The majority recommendation of the advisory council, published on February 6, 2015, was that the right to be forgotten ruling should apply only within the 28 countries in the European Union.44 As a practical matter, this meant that Google was only required to apply removals to European domains, such as Google.fr or Google.co.uk, but not Google.com, even when accessed in Europe. Although over 95 percent of all queries originating in Europe used European domains, users could still access information that had been removed via the Google.com site.

    The report also explained that once the information was removed, it was still available at the source site (e.g., the newspaper article about Costeja in La Vanguardia). Removal meant merely that its accessibility to the general public was reduced because searches for that information would not return a link to the source site. A person could still find the information, since only the link to the information had been removed, not the information itself.

    The advisory council also recommended a set of criteria Google should use in assessing requests by individuals to “delist” their information (that is, to remove certain links in search results based on queries for that individual’s name). How should the operator of the search engine best balance the privacy and data protection rights of the subject with the interest of the general public in having access to the information? The authors of the report felt that whether the data subject experienced harm from such accessibility to the information was relevant to this balancing test. Following this reasoning, they identified four primary criteria for evaluating delisting requests:

    • First, what was the data subject’s role in public life? Did the individuals have a clear role in public life (CEOs, politicians, sports stars)? If so, this would weigh against delisting.
    • Second, what type of information was involved? Information that would normally be considered private (such as financial information, details of a person’s sex life, or identification numbers) would weigh toward delisting. Information that would normally be considered to be in the public interest (such as data relevant to political discourse, citizen engagement, or governance) would normally weigh against delisting.
    • Third, what was the source of the information? Here, the report suggested that journalistic writing or government publications would normally not be delisted.
    • Finally, the report considered the effect of time, given that as circumstances change, the relevance of information might fade. Thus, the passage of time might favor delisting.

    The advisory council also considered procedures and recommended that Google adopt an easily accessible and easy-to-understand form for data subjects to use in submitting their requests.

    The recommendations of the advisory council were not unanimous. Jimmy Wales, the cofounder of Wikipedia and one of the eight group members, appended a dissenting comment to the report. “I completely oppose the legal situation in which a commercial company is forced to become the judge of our most fundamental rights of expression and privacy, without allowing any appropriate procedure for appeal by publishers whose work in being suppressed,” Mr. Wales wrote. “The recommendations to Google contained in this report are deeply flawed due to the law itself being deeply flawed.

    Norfolk State University COVID 19 Vaccines Discussions Replies

    Description

    Discussion #1-

    As the United States and other wealthy nations paid drug companies for stockpiles of COVID-19 vaccines lower income countries, who were fighting the same pandemic, were left in an anxious state. In 2020 Moderna announced that they would not enforce its intellectual property during the COVID-19 pandemic.   According to Kubasek (2020), “The laws of intellectual property protect property that is primarily the result of mental creativity rather than physical efforts” (p. 163).  Moderna’s decision to not enforce its patents was meant to “encourage low- and middle-income countries that couldn’t afford to purchase billions of doses of the vaccine to develop their own versions of the shot using less expensive resources” (Park, 2022).  But could others outside of Moderna actually make the vaccine?  As wealthier countries vaccinated the masses and poor countries remained without vaccines for even the elderly and immunocompromised, vaccine inequity was on full display.  A response to ending vaccine inequity began in July 2021 with the creation of the World Health Organization’s Initiative for Vaccine Research.  Scientists and researchers at Afrigen, a South African biotech company, were tasked with learning the technology and generating vaccines for human trials (Park, 2022). “The idea behind the hub was to bring scientists with expertise in the mRNA vaccine-making process together to share their knowledge with colleagues in other low- and middle-income countries who might not have access to such information” (Park, 2022).  Although Moderna did not enforce its patent, it did not agree to transfer its technology for making the vaccine.  Moderna’s patents play a small role in the innovation process, the value is in the knowledge capital (Boldrin & Levine, 2021). Afrigen was tasked with reverse engineering the vaccine, starting from nothing to formulate the RNA and create the delivery system for the viral genetic material in lipid nanoparticles. “That made the process take longer and delayed having safe and effective locally produced vaccines available for countries in Africa and other parts of the world” (Park, 2022).   As Moderna was applauded for not enforcing its patents during the pandemic, corporate leadership should have elevated their assistance by providing the scientists, researchers and technology to actually help the lower income countries develop their own vaccines.

    Last month Moderna announced it will extend its patent waiver but only for lower-income countries.  There are 92 lower- and middle-income countries that will be included in this waiver while the remaining countries will be required to work with Moderna on license agreements for Moderna patented related technology (Gardner, 2022).   In higher-income countries Moderna has indicated that vaccine supply is a non-issue and “licensing its COVID-19 intellectual property is appropriate for drug makers who want to make use of its mRNA technology” (Gardner, 2022). Moderna intends for license fees to provide advancements in research and development of new vaccines (Gardner, 2022).  Moderna’s announcement has received backlash from public health officials.  Moderna originally stated that it would not enforce its patents during the COVID-19 pandemic.  The pandemic has not yet been declared over by the World Health Organization who has concerns that Moderna’s recent change could affect their vaccine research hubs in South Africa, Brazil and Argentina (Gardner, 2022).   

    Leaders in the pharmaceutical companies should be working together to help end vaccine inequity in underdeveloped countries.  As a leader, I would be providing funds and scientists to assist the established and future World Health Organizations vaccine hubs.  I would want my organization to be a global resource and put people over profits. “Each of you should give what you have decided in your heart to give, not reluctantly or under compulsion, for God loves a cheerful giver” (New International Version, Holy Bible, 2011, 2 Corinthian 9:7).

    References

    Boldrin, M., & Levine, D. (2021). Reforming patent law: the case of COVID-19. Cato Journal, 41(3), 773-784. http://dx.doi.org.ezproxy.liberty.edu/10.36009/CJ.41.3.15.

    Gardner, J. (2022). Moderna extends patent waiver for COVID vaccine, but only for lower-income countries. HR Dive, http://ezproxy.liberty.edu/login?qurl=https%3A%2F%…

    Kubasek, N. K., Browne, M. N., Barkacs, L., Herron, D., & Dhooge, L. (2020). Biblical worldview edition of dynamic business law (2nd ed.). N. J. Kippenhan (Ed.). New York, NY: McGraw Hill Education.

    Discussion #2-

    The coronavirus pandemic brought out the best, worst and in some cases creative sides of everyone and big pharmaceutically CEOs were no exception. This era has seen pharmaceutical companies partner with governments, non-profit organizations, and even competitors for the betterment of society; we have seen creative allocating of vaccines to ensure low income countries have an opportunity to purchase vaccines; but we have also seen large profitable companies accept taxpayer dollars with huge returns (Moderna accepted $483 million in US government funding and expects to bring in $18.5 billion) and no plans to share their vaccine IP (D’Eminio, 2021; Rowland et al., 2021; Taylor & Parker, 2021). Which of these approaches’ best cares for all stakeholders or is there another option?

    If I were the CEO of one of the pharmaceutical companies faced with this incredibly challenging scenario, I would take a radical (almost) unheard-of stance . . . Before we get to the radical stance let’s consider what investors in today’s world are looking for and if/how this idea can be successful.

    Historically environmental, social, and governance (ESG) issues have been secondary concerns for investors, but this view has changed, and investors now favor social impact organizations in their portfolios (Eccles & Svetlana, 2020). Eccles & Svetlana interviewed 70 executives from global investment institutions with 43 of the 70 stating “that ESG is now a priority . . . and that corporations will soon be held accountable by shareholders for their ESG performance” (Eccles & Svetlana, 2020, para. 2). Understanding the importance of ESG on an organization’s sustainability should not only be a priority for investors but also all corporate executives.

    Not only have investors said ESG is important to them, but studies prove organizations are more likely to succeed financially when taking a positive social stance. Berbegal-Mirabent et al. concludes that firms with mission statements that clearly considers the customers and product/service offerings along with stating social intentions are more likely to have greater economic performance (Berbegal-Mirabent, 2021).

    With this information it is clear I will take a giving-socially responsible approach. The bible tells us over and over the importance of caring for the poor. In the Old Testament Deuteronomy 24 and 25 tells us not to forget where we come from, reminding the Israelites they were slaves in Egypt before the Lord redeemed them and commanding them to treat the poor fairly and generously (Deuteronomy 24:18-22, NIV Life Application Study Bible, 2011). In the New Testament Paul wrote a letter to his companion Timothy providing direction for leadership. 1 Timothy 6:18 – “Command them to do good, to be rich in good deeds, and to be generous and willing to share” (1 Timothy 6:18, NIV Life Application Study Bible, 2011). The NIV commentary reminds us with great riches comes great responsibility and goes on to say, “Use your money to do good. Be rich in good works, generous, and ready to share” (NIV Life Application Study Bible, 2011, p. 2039). This biblical insight encourages me that my radical stance is the right one.

    For this stance to work, I must have developed the right environment inside and outside of your organization. This environment starts with the foundation. An organizations’ missions statement forms its’ foundation. “Mission statements are a strategic tool that can provide a company with a purpose of being, a being that communicates the core of the business to internal and external stakeholders” (Berbegal-Mirabent et al., 2021, p. 705). Creating a mission statement that clearly communicates a balanced approach between profit and social intent will ensure all parties understand the organizations expectations around both areas. By including social intentions in your mission statement, you are not only telling investors what you plan to do, you are also telling them what they want to hear (you are an organization that prioritizes ESG).

    Once I have set the expectations with internal and external stakeholders and I am presented with an opportunity to make a social impact, no one will be surprised by the radical decision to lead the organization through this pandemic donating all proceeds from the Coronavirus vaccine. This decision will allow me to openly partner and share any IP related information around the vaccine with non-profits, competitors, and governments always prioritizing and ensuring the safety of production and distribution. How does this care for all stakeholders?

    Investors and shareholders – Investors and shareholders care about an organizations social impact and prioritize it when making investment decisions (Eccles & Svetlana, 2020).

    Employees – Refinitiv Perspectives published a report finding “A higher [ESG] score indicates more positive workplace sentiment and happier employees” (Refinitiv Perspectives, 2021, para. 5).

    Consumers – “83% of consumers think companies should be actively shaping ESG best practices” (PricewaterhouseCoopers, 2021, para. 1).

    Does this still sound crazy? Consider that my company has brought large profits to its shareholders year after year developing and selling drugs and will continue these same profits in the future. I am choosing to not profit of this one unexpected global epidemic that was not forecasted (or budgeted) and will not change any other creations or sales. Finally, this same decision was successfully executed the during the pandemic by Wells Fargo & Co. Wells Fargo participated in the Payroll Protection Program and pledged to donate all proceeds toward helping small businesses recover from the pandemic, these proceeds ended up being over $400 million (Moise, 2020). Wells Fargo’s successful navigation of such a strong social stance, along with research proving these types of decisions can be made without financial harm to the organization, making the employee happier, and this is what investors want gives me the confidence needed to proceed with this decision.

    References

    Berbegal-Mirabent Jasmina, Mas-Machuca, M., & Guix, P. (2021). Impact of mission statement components on social enterprises’ performance. Review of Managerial Science, 15(3), 705-724. http://dx.doi.org/10.1007/s11846-019-00355-2

    D’Eminio, F. (2021, October 11). Moderna has no plans to share its COVID-19 vaccine recipe. AP. https://apnews.com/article/coronavirus-pandemic-techology-business-inited-nations-europe-d4aff7ddb273194b312354a57c244ce6

    Eccles, R., & Svetlana, K. (2020, November 24). Shareholders are getting serious about sustainability. Harvard Business Review. https://hbr.org/2019/05/the-investor-revolution

    Moise, I. (2020, July 9). Wells Fargo pledges $400 million in support of small business after PPP payout. Reuters. https://www.reuters.com/article/us-health-coronavi…

    PricewaterhouseCoopers. (2021). 2021 consumer intelligence series survey on ESG. PwC. https://www.pwc.com/us/en/services/consulting/libr…

    Refinitiv Perspectives. (2021, May 4). ESG analysis: Happier employees predict higher stock prices. Refinitiv Perspectives. https://www.refinitiv.com/perspectives/future-of-i…

    Rowland, C., Rauhala, E., & Berger, M. (2021, March 20). Drug companies defend vaccine monopolies in face of global outcry. The Washington Post. https://link.gale.com/apps/doc/A655745537/BIC?u=vic_liberty&sid=summon&xid=4321e4f8

    Liberty University Operations Management Discussion

    Description

    You are required to write 2 separate substantive replies to the 2 discussion threads below. Each reply must be a minimum of 300 words and include at least 4 scholarly resources.

    Acceptable sources include the textbook, the Bible, outside scholarly articles, etc.

    Substantive replies, in contrast to perfunctory replies, add value to the discussion, enhance learning, and contain references to any new concepts or ideas presented.

    The following suggestions will aid you in successfully composing substantive responses:
    – Compare/contrast the findings of others with your research.
    – Compare how the findings of others relate/add to the concepts learned in the required
    readings.
    – Share additional knowledge regarding the key topic that relates to the thread

    – All citations and references must be in current 7th edition APA format (see attached)

    DISCUSSION THREAD 1 (JD)

    Discussion Board: Balanced Scorecard

    Key Concept Explanation

    Robert Kaplan and David Norton first introduced the concept of the balanced scorecard in 1992. They conducted a year-long research project with 12 companies to develop the balanced scorecard, which gives managers a balanced presentation of both financial and operational measures of success (Kaplan & Norton, 1992). The balanced scorecard considers four perspectives on success. The perspectives are an internal business perspective, an innovation and learning perspective, a customer perspective, and a financial perspective. In my position in the military, I am not setting out to achieve financial goals. I oversee 5 other people with a specific operational function. Therefore, I chose to research the balanced scorecard in order to learn more about operational measures of success versus purely financial objectives.

    Comparison

    The balanced scorecard uses operational measures of success instead of antiquated methods that only measured financial objectives. It has been used as a tool to help organizations transform their business strategy into applicable performance measures to monitor business success (Meredith & Shafer, 2019). One of the keys to developing the balanced scorecard is creating a strategy map linking the causes and effects of strategy actions. There has been some debate over the years if those cause-and-effect relationships actually exist between the operational measures of the balanced scorecard method. In their research, Kober and Northcott (2020) established statistical evidence that cause-and-effect relationships do, in fact, exist in the balanced scorecard in the public sector.

    The balanced scorecard tool has been widely adopted across businesses, industry, government, and non-profit organizations around the world. Some organizations have applied a balanced scorecard approach and expanded it to include a corporate social responsibility aspect (Hansen & Schaltegger, 2016). The balanced scorecard specializes in translating organizational strategy into actions that can be measured with key performance indicators (Balanced Scorecard Institute, 2020). The balanced scorecard uses a diversified set of indicators to reflect the strategy of the organization. Clearly defining a balanced set of objectives helps the business to meet the needs and expectations of the relevant stakeholders (Quesado et al, 2018). Some organizations have used cascading balanced scorecards to refine the organization-level scorecard for use at the team and even individual level (Balanced Scorecard Institute, 2020).

    Article Summary

    Robert Kaplan and David Norton wrote the definitive work that introduced the balanced scorecard in the 1992, and later revised it in 1996, in their article “The Balanced Scorecard-Measures That Drive Performance.” Kaplan and Norton assert that simply tracking financial accounting measures can be misleading when pursuing continuous improvement and innovation. In today’s modern business environment, businesses must track operational objectives as well in order to maintain a competitive edge in the market. Instead of just tracking return on investment or earnings per share, companies should track things like cycle times and defect rates. The balanced scorecard incorporates a financial perspective, as well as an internal business perspective, and innovation and learning perspective, and a customer perspective. This balanced scorecard can give management a succinct, overview of the organization’s total performance by focusing on a small group of the most critical metrics. Another advantage of the balanced scorecard method is that it prevents information overload by focusing on a small set of critical metrics. At the same time, the balanced scorecard causes top management executives to view the success of the business through various operational measures beyond just finances. Considering the customer perspective causes the organization to have to think about what kinds of metrics the customer cares about. The internal business perspective causes the organization to consider what they must excel at to meet customer expectations (Kaplan & Norton, 1992).

    Biblical Integration

    1st Peter 5:8 says to “be sober minded; be watchful” (New International Version, 2011). And that is the goal of the balanced scorecard: to be watchful over the success of an organization. Being sober minded is to think clearly about the objectives of the organization and a balanced scorecard is one tool that can help with that.

    Proverbs 25:11 tells us, “A word fitly spoken is like apples of gold in a setting of silver” (New International Version, 2011). This verse is about clear communication, and the balanced scorecard clarifies and communicates the goals of the organization by translating the mission into actions.

    “Commit to the Lord whatever you do, and he will establish your plans” Proverbs 16:3 (New International Version, 2011). Whatever business endeavor one undertakes, it should be committed to the Lord and one should work as if working for the Lord and not for men.

    Application

    The balanced scorecard is more applicable than ever before. It arose out of a need for a better way to measure organizational success beyond financial measures as stakeholder needs became more diversified and customers became more informed than ever before. According to a recent global study, the balanced scorecard was ranked 5th of the top ten most widely used management tools in the world (Balanced Scorecard Institute, 2020). It is used by more than half of all major companies in the U.S. Europe and Asia. The balanced scorecard tool is growing in other areas such as Africa and the middle east as well.

    DISCUSSION THREAD 2 (JB)

    Discussion Board: Project Life Cycle

    Key Concept

    There are many types of projects that can be undertaken in business. These projects have many different forms and scales. In order to better study project life cycles, it is easier to break them into a few common categories. Meredith and Shafer (2019) describe the stretched S and exponential project life cycles. The stretched S model is very common and shows a slow start during planning, which slowly picks up speed and then tapers off at the end as resources begin to be directed elsewhere. The exponential form, however, sees basically no return until the project is completed. It is critical to understand where in the project lifecycle output will be produced so as not to misunderstand performance compared to resources invested.

    Comparison

    There are many things to consider when studying the life cycle of a project. Measham et al. (2019) focus on the impact that supply chain can have on managing the project life cycle. A delay in the delivery of one component could delay the project output. That could make it appear that the project is no longer successful. It is important to remember, however, that the relationship between the percentage of inputs used and the percentage of output created is rarely linear. If one input component is missing for a time, other parts of production could still be continuing, allowing a sharp increase in production when that final input is received. Of course, this type of flexibility is dependent on the project at hand. This is why it is important for managers to understand their project life cycle, so they can tell the difference between a shuffling of steps and an actual impact to production. Galli (2020) describes just how important this understanding can be by pointing out that these projects are one of the key driving factors of the world economy. Conversely, the economic environment can impact the project as costs of supplies vary as does the demand for the product. It is critical, therefore, for managers to forecast these changes and time their projects accordingly. This type of planning can be quite involved. Zheng et al. (2021) lay out some of the many variables that can impact managing a project life cycle and it is a very complex issue.

    Article Summary

    Cha and Maytorena-Sanchez (2019) raise some very good points about the effective management of project life cycles. In the stretched S model, it is likely that managerial inputs will be mor necessary during the project initiation and project termination phases. These are the times when plans are being drawn up and decisions are being made about where resources should be allocated. Compare this with the project implementation phase, which hopefully can just be monitored and not require as much hands-on management. An effective manager will realize this difference in demand for attention during the project life cycle. This is important because many managers will have multiple projects at one time. It is important to prioritize and deconflict these projects so that each can be given the attention that it requires. This concept applies not only to managerial attention, but to other resources as well. For exponential projects, it may be more difficult for a manager to oversee multiple projects. This is because exponential projects require a more constant level of attention throughout the process. Furthermore, Cha and Maytorena-Sanchez (2019) define project management competences that can help to identify what type of oversight is required during which phase of the lifecycle. For some companies, it may be beneficial to have different leadership on projects during different life cycle phases according to what that leader’s strengths are.

    Biblical Integration

    Life cycle management is all about planning and understanding deviations from that plan. Proverbs 21:5 teaches, “The plans of the diligent lead surely to abundance, but everyone who is hasty comes only to poverty” (English Standard Version). Luke 14:28 says, “For which of you, desiring to build a tower, does not first sit down and count the cost, whether he has enough to complete it” (ESV). It is also important to realize that, no matter how much planning and preparation is done, it is still important to trust in the Lord. Proverbs 16:9 says, “The heart of man plans his way, but the Lord establishes his steps” (ESV).

    Application

    Planning a life cycle of a project has many benefits. One of the main things is to understand the relationship between resources used and output produced. I have spent a great deal of time and money working on my MBA, and yet I have nothing tangible to show for it. If I expected to have eighty percent of the benefit because I have put in eighty percent of the time and effort, this endeavor would be deemed a failure and I would have to quit. Instead, I recognize that grad school is an exponential life cycle and only after completing one hundred percent of the work will the benefit of a degree be realized.

    BC JUSTLEE Books Activity Worksheet

    Description

    There are two different things

    Scenario Overview

    Your boss, Michael, is back in the office. The office ordered pizza, and a working lunch ensued. You are congratulated for successfully completing adding join conditions that combined data from more than one table. Last week, you were not feeling very confident because you had only worked with one table, but now you have experience with queries that combine data from more than one table. You were really pleased with yourself because you figured it out on your own without needing to contact Michael at his conference. Michael is all fired up from his conference and full of new ideas and innovative ways to run data, among other things, for his small staff. He is particularly excited to have you play around in the database with the single-row and multiple-row SQL functions. He also wants to introduce you to character and date functions and other functions and regular expressions.

    Image credits: People Eating Pizza. Canva.

    Work Project Details

    Michael explains that he is interested in more fine-grained reports that include formatting results different from that shown in the database. He knows that you are up for the task and has given you the week to work through this small project. At the end of the week, he also wants to chat with you about your long-term plans for coming aboard full-time with JustLee Books. To perform the following assignment, refer to the tables in the JustLee Books database.

    1. Determine the length of data stored in the ISBN field of the BOOKS table. Make sure each different length value is displayed only once (not once for each book).
    2. Produce a list of all customer names in which the first letter of the first and last names is in uppercase, and the rest are in lowercase.
    3. Create a list of all customer numbers along with text indicating whether the customer has been referred by another customer. Display the text “NOT REFERRED” if the customer wasn’t referred to JustLee Books by another customer or “REFERRED” if the customer was referred.
    4. Determine the amount of total profit generated by the book purchased on order 1002.
    5. Display the book title and profit. The profit should be formatted to display a dollar sign and two decimal places. Take into account that the customer might not pay the full retail price, and each item ordered can involve multiple copies.
    6. Display a list of all book titles and the percentage of markup for each book. The percentage of markup should be displayed as a whole number (that is, multiplied by 100) with no decimal position, followed by a percent sign (for example, .2793 = 28%). (The percentage of markup should reflect the difference between the retail and cost amounts as a percent of the cost.)
    7. Display the current day of the week, hour, minutes, and seconds of the current date setting on the computer you’re using.
    8. Create a list of all book titles and costs. Precede each book’s cost with asterisks so that the width of the displayed Cost field is 12.
    9. Using today’s date, determine the age (in months) of each book that JustLee sells. Make sure only whole months are displayed; ignore any portions of months. Display the book title, publication date, current date, and age.
    10. Determine the calendar date of the next occurrence of Wednesday, based on today’s date.
    11. Produce a list of each customer number and the third and fourth digits of his or her zip code. The query should also display the position of the first occurrence of a 3 in the customer number if it exists Second assignment Scenario Overview You have been getting up to speed with grouping functions after that challenging project last week. You continue to learn about character and date functions, and other functions and regular expressions. Now that you understand and have a good grasp of grouping functions, your boss is excited to have you learn more about groups and how they compare to one another. Michael shared that groups can be created by any of the attributes of your database tables. He is ready for you to start thinking about how orders are grouped by customer, customers by state, profit by publisher, or any other number of attributes grouped by another attribute. (ERD – Figure 1.5 is attached).Image credits: Fresh Coffee, Canva and Laptop, Coffee Cup, Graph Chart on a Wooden Surface, Canva.
    12. Work Project Details

      First, you better get a tall and hot cup of coffee because, in this next small project, your boss has a renewed interest in orders. He is apparently still excited about the rich information he discovered at that conference a couple of weeks ago. Your boss wants to know where orders are coming from and which books, categories, and publishers are most profitable. He knows that you are up for the task and has given you a week to work through this small project. Last week was pretty busy, and the two of you did not get a chance to chat about your long-term plans. To perform the following assignment, refer to the tables in the JustLee Books database.

      1. Determine how many orders have been placed by each customer. Do not include in the results any customer who hasn’t recently placed an order with JustLee Books.
      2. Determine the average retail price of books by publisher name and category. Include only the categories Children and Computer and the groups with an average retail price greater than $50.
      3. List the customers living in Georgia or Florida who have recently placed an order totaling more than $80.
      4. What’s the retail price of the most expensive book written by Lisa White?
      5. Determine how many books are in the Cooking category.
      6. Display the number of books with a retail price of more than $30.00.
      7. Display the most recent publication date of all books sold by JustLee Books.
      8. Determine the total profit generated by sales to customer 1017. Note: The total profit calculation should reflect the quantity.
      9. List the retail price of the least expensive book in the Computer category.
      10. Determine the average profit generated by orders in the ORDERS table. Note: The total profit by order must be calculated before finding the average profit.

      Scenario Overview

      You have been getting up to speed with grouping functions after that challenging project last week. You continue to learn about character and date functions, and other functions and regular expressions. Now that you understand and have a good grasp of grouping functions, your boss is excited to have you learn more about groups and how they compare to one another. Michael shared that groups can be created by any of the attributes of your database tables. He is ready for you to start thinking about how orders are grouped by customer, customers by state, profit by publisher, or any other number of attributes grouped by another attribute. (ERD – Figure 1.5 is attached).Image credits: Fresh Coffee, Canva and Laptop, Coffee Cup, Graph Chart on a Wooden Surface, Canva.

      Work Project Details

      First, you better get a tall and hot cup of coffee because, in this next small project, your boss has a renewed interest in orders. He is apparently still excited about the rich information he discovered at that conference a couple of weeks ago. Your boss wants to know where orders are coming from and which books, categories, and publishers are most profitable. He knows that you are up for the task and has given you a week to work through this small project. Last week was pretty busy, and the two of you did not get a chance to chat about your long-term plans. To perform the following assignment, refer to the tables in the JustLee Books database.

      1. Determine how many orders have been placed by each customer. Do not include in the results any customer who hasn’t recently placed an order with JustLee Books.
      2. Determine the average retail price of books by publisher name and category. Include only the categories Children and Computer and the groups with an average retail price greater than $50.
      3. List the customers living in Georgia or Florida who have recently placed an order totaling more than $80.
      4. What’s the retail price of the most expensive book written by Lisa White?
      5. Determine how many books are in the Cooking category.
      6. Display the number of books with a retail price of more than $30.00.
      7. Display the most recent publication date of all books sold by JustLee Books.
      8. Determine the total profit generated by sales to customer 1017. Note: The total profit calculation should reflect the quantity.
      9. List the retail price of the least expensive book in the Computer category.
      10. Determine the average profit generated by orders in the ORDERS table. Note: The total profit by order must be calculated before finding the average profit.

        Scenario Overview

        You have been getting up to speed with grouping functions after that challenging project last week. You continue to learn about character and date functions, and other functions and regular expressions. Now that you understand and have a good grasp of grouping functions, your boss is excited to have you learn more about groups and how they compare to one another. Michael shared that groups can be created by any of the attributes of your database tables. He is ready for you to start thinking about how orders are grouped by customer, customers by state, profit by publisher, or any other number of attributes grouped by another attribute. (ERD – Figure 1.5 is attached).Image credits: Fresh Coffee, Canva and Laptop, Coffee Cup, Graph Chart on a Wooden Surface, Canva.

        Work Project Details

        First, you better get a tall and hot cup of coffee because, in this next small project, your boss has a renewed interest in orders. He is apparently still excited about the rich information he discovered at that conference a couple of weeks ago. Your boss wants to know where orders are coming from and which books, categories, and publishers are most profitable. He knows that you are up for the task and has given you a week to work through this small project. Last week was pretty busy, and the two of you did not get a chance to chat about your long-term plans. To perform the following assignment, refer to the tables in the JustLee Books database.

        1. Determine how many orders have been placed by each customer. Do not include in the results any customer who hasn’t recently placed an order with JustLee Books.
        2. Determine the average retail price of books by publisher name and category. Include only the categories Children and Computer and the groups with an average retail price greater than $50.
        3. List the customers living in Georgia or Florida who have recently placed an order totaling more than $80.
        4. What’s the retail price of the most expensive book written by Lisa White?
        5. Determine how many books are in the Cooking category.
        6. Display the number of books with a retail price of more than $30.00.
        7. Display the most recent publication date of all books sold by JustLee Books.
        8. Determine the total profit generated by sales to customer 1017. Note: The total profit calculation should reflect the quantity.
        9. List the retail price of the least expensive book in the Computer category.
        10. Determine the average profit generated by orders in the ORDERS table. Note: The total profit by order must be calculated before finding the average profit.

    Park University Business Discussion

    Description

    Please respond to each student 200-300 words use references

    First one is responding to teacher

    This is what the teacher asked me

    Time Management can definitely impact the WBS. For example, if the estimated time of activity A was 10 days yet it took 15 days you would need to update the WBS to show the overall impact to the project. Can you give an example of how cost management might impact the WBS?

    Student 1 is Belinda

    After reading and watching this week’s material, engage in an active discussion regarding how cost and time management impact the WBS. Review the following information and answer the following questions:Cost and time management can impact many aspects of the project. One of the major deliverables that cost, and time can impact is the WBS. In this week’s teamwork, your team will be reviewing the current cost and time estimates and updating the WBS with more realistic information based on feedback and comments from the professor and the other various team members. Discuss the potential items to review and if you think there are any major updates to the WBS after reviewing the time and cost management chapters. Do your thoughts differ from your teammates? Why and what will you do to resolve?

    A work breakdown structure (WBS) is a description of the work that will be completed for a project. It is a hierarchy of tasks that represents the project team’s understanding of the composition of work, and of the size, cost, and duration of each component or task. A WBS has three major purposes:

    • Describe the breakdown or composition of work in tasks.
    • Schedule the project work.
    • Estimate the cost of each task (Yowelle et al, 2022).

    The items to review to establish if there are any needed changes on the current WBS are your cost and time management estimates. There are several methods to cost estimation and we chose to use the bottom-up approach. More specifically we will use parametric estimation which compares past projects costs and times with our current project. After reviewing estimates of each it is important to realize if you choose to change the WBS in any way it can change the scope of the project. There are other considerations such as resource allocation, budgeting, and risk management all ride on a properly broken-down project. If you change something, no matter how small it seems, you could wind up creating greater costs, needing a different resource, or worse—project failure due to a risk associated with the change (Mathis, 2019). The last reason to be cautious when changing the WBS is that it serves as a part of your change control and changes may cause the deliverables that follow to fail and cause scope creep. When considering changing the WBS the Project team needs to consider the scope, schedule and budget. If it is determined that there needs to be a change in the WBS it needs to go through the formal approval process. If the change is going to cause problems with any of the three considerations, then the request should be denied.

    Fortunately, all team members are on the same page for the WBS update. Our project’s estimates for the time and cost management are on point and we feel there are no needed changes.

    Mathis, Micah. (2019). Work breakdown structure (WBS) purpose, process, and pitfalls. Retrieved April 20,2022 from https://www.projectsmart.co.uk/work-breakdown-stru…

    Yowelle et al., (04/13/2022) Work breakdown structures overview, https://docs.microsoft.com/en-us/dynamics365/proje…

    Student 2 is Will

    Hello,

    After considering the impacts costs and time management has on the WBS, my team felt it was important that we reviewed the project’s schedule, critical and non-critical paths, and the budget. Every project has its own unique attributes. These attributes create variances in projects that are similar to one another. “Project teams can also factor in the time and cost of project management processes. Processes that are not tailored may add little value to the project or its outcomes while increasing cost and lengthening schedule. Tailoring their approach along with appropriate processes, methods, and artifacts can help project teams make decisions about process related costs and the related value contribution to project outcomes.” (Project Management Institute, 2021, p. 45) Time and cost management is the act of planning for the variables that feed these variances and budgeting both time and money so that the project meets it required goals. With this information in mind, our team discussed how scheduling work to be completed during weekends and holidays would impact the schedule and the budget. To do this we needed to modify our WBS to act as both a WBS and a project calendar. This allowed us to identify what days and shift were available for scheduled activities.

    After identifying the weekends and holidays over the course of our project, we accepted the fact that working holidays and weekends would increase costs. This trade off seemed to be acceptable to many members of our team because it ensured that we would meet the project deadline, while also remaining on budget. PMBOK describes the project schedule as, “An output of a schedule model that present linked activities with planned dates, durations, milestones, and resources.” (Project Management Institute, 2021, p. 246) This schedule is vital to project management because it allows the project manager to control the project schedule and predict the expenditure of funds.

    A group of students at Franklin University found that by applying project management time and cost principles they were able to improve the value of course instruction. “In many cases, we also used a course manuscript…that provides consistency among all courses. Essentially, the template provides a structure for all instructional designers…By implementing the manuscript, the content editors were able to significantly decrease their build time, which decreases the overall budget for the project.” (Gardner, Bennett, Hyatt, & Stoker, 2017) Failure to meet a project’s deployment date can result in significant revenue loss and costs related to the extension of the project. At the start of every project, management must conduct a critical analysis of all activities to identify their associated risks. From there management can use a decision tree analysis to determine whether the schedule or the budget is of a higher value/importance to the success of the project. Knowing this helps the project team build the WBS and shapes actions at decision points. This shaping helps project managers to establish contingency reserves for both time and money.

    Student 3 Marjan

    Marjan Kia

    Department of Business, Park university

    PM691DLS2P2022 Time and Cost Management

    Professor Lashawn Johnson

    Apr 20, 2022

    Week 6 Discussion

    WBS provides a framework as a basis for other planning processes, including the process of defining activities in the field of scheduling management knowledge, the process of estimating costs in the field of project cost management knowledge, the process of estimating resources in the field of resource management knowledge? The risk identification process should be in the field of project risk knowledge. The last level of the work breakdown structure is called work packages, in which a work package can be timed, cost, and monitored. If you cannot define the scope of the project, then you will certainly not be able to define the schedule, resource planning, or budgeting for your project. WBS first helps you define the scope of the project and then acts as a framework for defining project details in planning, scheduling, estimating, budgeting, outsourcing, cost aggregation, and more. This framework is developed by the project manager and team in the operations necessary to achieve the project objectives. Allows the project manager to interpret the project plan.

    Cost estimation is an approximate estimate of the financial resources needed to complete project activities based on available information and assumptions at a point in time. Usually, the accuracy of estimates at the beginning of the project is not good during the project implementation because more detailed information will be available during the project implementation, so in many projects, re-estimation is inevitable.

    If the general deviation from the budget is clear, the detail of this issue means what parts of the project the deviation from the budget is related to and what are the reasons for this deviation, and therefore it is not possible for the managers of the organization and the project to make correct and effective decisions. More accurate results in the project can be achieved with precise cost and time control and using WBS. Team-building techniques are interesting and special. Just as building a sports or art team requires practice, we must use the normal activities of the project as team-building events. Our team did well in creating the WBS structure. People who do the work are allowed to do the job definition work. This is a great opportunity to build trust and relationships through teamwork.

    Our team took the time to review the WBS again. We reviewed it again and made sure it made sense. We asked team members to submit their scenarios to the rest of the team for review and discussion. In this way, we were able to understand the whole effort of the team. We worked on re-examining the time and correcting it. We re-examined the costs according to our budget and tried to eliminate the extra costs. There is no disagreement in our team. We review the cost, time, quality, and scope of the project together and finally make a summary of each other’s opinions and continue the project. I think if my teammates’ thoughts were different, we would still be able to continue our work by talking in business meetings and getting ideas from each other, and using it as a challenge.

    References

    Larson, E. W., & Gray, C. F. (2021). Project Management: The Managerial Process. New York: McGraw-Hill.

    Practice Standard for Work Breakdown Structures (2001). Newtown Square, Pennsylvania: Project Management Institute Inc.

    Globerson, Shlomo, Cohen, Izack, Vardi, Sivan. (2016). Identifying the Criteria Used for ESTABLISHING WORK PACKAGE SIZE FOR PROJECT WBS. (Park University).

    Buchtik, Liliana. (2013). Secrets to Mastering the WBS. (Park University).

    Here is the original directions for reference you DO NOT have to do this it is to help you.

    Directions

    After reading and watching this week’s material, engage in an active discussion regarding how cost and time management impact the WBS. Review the following information and answer the following questions:

    Cost and time management can impact many aspects of the project. One of the major deliverables that cost and time can impact is the WBS. In this week’s team work, your team will be reviewing the current cost and time estimates and updating the WBS with more realistic information based on feedback and comments from the professor and the other various team members. Discuss the potential items to review and if you think there are any major updates to the WBS after reviewing the time and cost management chapters. Do your thoughts differ from your teammates? Why and what will you do to resolve?

    Please find an additional reference source and cite the source in your discussion post. Sources must be used to enhance the learning experience. By finding a referenced source, you are enhancing the learning experience by searching for another source of information on the topic. Also, please ensure you are using a source that is peer reviewed to ensure accuracy of information (select peer-reviewed journal articles in the Park Library search engine)

    Your original post should be in the format of an executive summary (must contain verbiage and bullet points to name the key points). Use APA formatting.

    PM 691 Park University Cost of Quality Discussion

    Description

    After reading and watching this week’s material, engage in an active discussion regarding cost quality. Answer the following questions:

    What is the cost of quality and who determines when there is enough quality in the project?

    Please find an additional reference source and cite the source in your discussion post. Sources must be used to enhance the learning experience. By finding a referenced source, you are enhancing the learning experience by searching for another source of information on the topic. Also, please ensure you are using a source that is peer reviewed to ensure accuracy of information (select peer-reviewed journal articles in the Park Library search engine)

    Your original post should be in the format of an executive summary (must contain verbiage and bullet points to name the key points). Use APA formatting.

    Student 1

    Belinda is her name

    After reading and watching this week’s material, engage in an active discussion regarding cost quality. Answer the following questions: What is the cost of quality and who determines when there is enough quality in the project?

    As a project manager you want to be known to produce a quality product. The cost of quality, or COQ, is the accumulated cost of not creating a quality product. These costs can include reworking a product, testing it, field service to make corrections after a product has been installed, and replacing a faulty product. This aggregate cost is reported to management to give them a basis for ensuring that processes always produce to customer expectations (n.a, 2021). The entire project team from the Stakeholders down to the customer determine if the end product is quality deliverable. In the end, the customers are satisfied with the quality of a product if it conforms to their expectations at delivery.
    There are several types of costs that are impacted by the quality of a product.
    1. Prevention costs – These are costs incurred to prevent product failure. Examples include equipment and maintenance, planning, staff training, documentation, human resources, quality assurance, process control(Goodwin, 2017)

    2. Appraisal costs – These are the costs of inspection needed to reduce the risk of sending defective products to customers (n.a, 2021). In other words, any testing related to making sure the product is quality and safe product. Examples include evaluating products and services, completing inspections, field testing, implementing quality control, identifying, and fixing defects before products get to market(Goodwin, 2017).

    3. Internal failure costs- These are the costs the company accrue from identifying product defects before it is reaches to the customer. These costs include lost revenue from customers who will not buy from the company again, the processing of returned goods, administering warranty claims, field service costs, liability lawsuits, and possibly even a comprehensive product recall( na.,2021)

    4. External failure costs- these are costs that are incurred after the delivery of the product to the customer. These costs include the legal fees related to customer lawsuits, the loss of future sales from dissatisfied customers, product recalls, product return costs, and warranty costs. These costs can be substantial if the result is the loss of customers – and especially when customers tend to buy a company’s products many times (n.a, 2021).

    As a project manager it is crucial to pay for failure cost that are internal rather than external after delivery to the customer. The reason is that external costs can not only hurt your pocket, but they can also kill a reputation.

    Project quality management is all the processes and activities needed to determine and
    achieve project quality. At its most basic level, quality means meeting the needs of customers (Project Management Skills, 2019).

    There are three key quality management concepts that will help you deliver a high-quality project:
    1. Customer Satisfaction – Ensuring that all the requirements are met within the project is part of the quality aspects but also ensuring the customer is satisfied is also equally important to a project.

    2. Prevention over inspection – It is less costly and time consuming to spend money during the project then when the project is complete and have failures externally like stated above.
    3. Continuous improvement – this is of utmost importance in any project to ensure quality the entire project duration and to use approaches such as Six Sigma and Total Quality Management (TQM). The ongoing effort to improve your products, services, or processes over time. These improvements can be small, incremental changes or major, breakthrough type changes (Project Management Skills, 2019).

    Picture1.gif
    As a project manager the most important tool is prevention and customer satisfaction. If you can detect problems early on, it’s going to save you time and money.

    Goodwin, J. (September, 14,2017)Cost of Quality: PMP Topics to Learn for the Exam https://magoosh.com/pmp/cost-of-quality-pmp/

    Project Management Skills. (2021) Project Quality Management Retrieved 4/12/2022 from https://www.project-management-skills.com/project-quality-management.htmlLinks to an external site.

    Project Management Skills. (2019). Project Quality Management: What is quality? Retrieved 4/12/2022 from https://www.project-management-skills.com/project-quality-Links to an external site. management.html

    n.a.(May 30,2021)What is the Cost of Quality?, ttps://www.accountingtools.com/articles/2017/5/14/the-cos…

    Student 2

    Will is his name

    Hello,

    The level of quality that a project will produce is determined during the early planning stages of the project and are adjusted as needed throughout the project through the use of change control measures. PMBOK describes Cost of Quality as; “All costs incurred over the life of the product by investment in preventing nonconformance to requirements, appraisal of the product or service for conformance to requirements, and failure to meet requirements.” (Project Management Institute, 2021, p. 81) Project sponsors, owners, and senior level managers are responsible for establishing the expected level of quality for the project. This expectation is reflected in the project’s requirements documentation, statement of work, definition of done, and or completion criteria.

    The cost of quality methodology uses four cost categories to strike a balance with a project’s overall cost and the quality of the product the project produces. These categories include prevention, appraisal, internal failure, and external failure. The amount of costs related to a project’s quality is decided on by project sponsors, owners, and senior level managers. As such they must consider how much of that cost should be spent on each of the four categories.

    Prevention costs are associated with actions taken to prevent defects and failures out of the project. Prevention costs are applied to the design, implementation, and maintenance of the project’s quality management system.

    Appraisal costs “…are incurred to determine the degree of conformance to quality requirements.” (Project Management Institute, 2021, p. 88) These are the same requirements that are established in the project’s requirements documentation, statement of work, definition of done, and or completion criteria. Project managers must be able to balance the capabilities the project’s product provides the end user with the project’s budget and scope.

    Internal failure occurs when internal actions, policies of procedures cause a dilution of the project’s efficacy. Internal failures include wasted time and materials, defective products produced, rework, and failure analysis.

    External failures are costs associated with fixing or rectifying defects found in products after they have been deployed. These defects often involve recalls or sending out updates to patch or replace defects. Projects can consider these costs and budget them into the project accordingly. Accepting external failures is frequently done when being the first to the market is more important than producing the best quality product.

    Will,

    References

    Larson, E. W., & Gray, C. F. (2021). Project Management: The Managerial Process. New York: McGraw-Hill.

    Project Management Institute. (2021). A Guide to the Project Management Body of Knowledge (17th ed.). Pennsylvania: Project Management Institute.

    Student 3

    Marjan is her name

    Department of Business, Park university

    PM691DLS2P2022 Time and Cost Management

    Professor Lashawn Johnson

    Apr 12, 2022

    Week 5 Discussion

    Cost of Quality refers to the costs incurred in ensuring high-quality products and the costs of incomplete delivery. In other words, the COQ measures the total cost required to prevent, identify, and deal with defective results in project deliverables. Calculating COQ can help make decisions; Because there is a balance between investing in quality during the project and dealing with future costs due to failure to prevent or detect errors. These costs are known as compliance costs and non-compliance costs. Compliance costs include the prevention and evaluation of defects to ensure quality throughout the project. The cost of non-compliance covers the costs of external and internal failures to achieve quality. When added together, the result is the total COQ.

    Quality costs after project completion may be imposed due to product return and warranty; Therefore, due to the temporary nature of the projects and the potential benefits of reducing post-project quality costs, the sponsoring organization may choose to invest in improving product quality. These investments are usually made in the field of matching work. Work performed to prevent defects or to reduce the costs of defects or inspections of nonconforming units.

    The purpose of the Quality Cost System (COQ) system is to increase customer satisfaction by reducing downtime and adapting products and services to specified requirements.

    Features of the quality cost management system

    The COQ technique has unique properties. Some features of the quality cost system are listed below:

    Estimate and analyze the set of costs associated with ensuring the quality of products and services.

    A criterion for measuring the extent to which an organization turns to quality and examines its effect on profit and loss.

    Inform employees of the costs of poor quality.

    Grounding to ensure the reduction of business costs and increase the competitiveness of the organization.

    Benefits of quality cost system

    Facilitate the set of efforts made to improve quality.

    Evaluate the performance of the organization and set goals for improvement.

    Many quality experts believe that 25 to 40 percent of the cost of each operation leads to losses, which can be minimized by implementing a COQ system.

    Improving quality by eliminating waste immediately leads to increased capacity without additional investment and appears directly in the form of profits in the financial balances.

    In general, the project manager has overall responsibility for the quality management process. In fact, the quality of the project is not the responsibility of one or two people. It is the responsibility of all team members. These tasks include:

    Project Manager – Responsible for developing the quality management process and ensuring accurate delivery.

    Team members – responsible for quality assurance and quality control for each of the tasks and activities assigned to them.

    Organization – Responsible for standardizing quality controls and standards in all projects.

    Stakeholders – are responsible for transferring their expectations from quality products and services to the project and organization and are responsible for accepting and confirming the delivery of all goods and services.

    Finally, quality is achieved by product users, customers, or clients, not the community. The quality of any project cannot be ideal. However, project managers must anticipate the potential costs of failure and be prepared to deal with them. Early detection problems save time and money.

    References

    Larson, E. W., & Gray, C. F. (2021). Project Management: The Managerial Process. New York: McGraw-Hill.

    Sandra F. Rowe. (2020). Project Management for Small Projects, Third Edition. (Park University Library).

    Robin A. Buser, Miriam Pollack. (2014). Project Management for Libraries: A Practical Approach. (Park University Library).

    Obi, Lovelin Ifeoma, Arif, Mohammed, Awuzie, Bankole, Islam, Rubina, Gupta, Aman Deep, Walton, Robert. (2021). Critical success factors for cost management in public-housing projects. (Park University Library).

    • Asfoor H.M.A. AL-Jandeel A.A.T. Igorevich K.K. Ivanovna L.A. (2022). Control of Time, Cost, and Quality of Construction Project Management. (Park University Library).
    • Dedy Achmad Kurniady, Nurochim, Aan Komariah, Turwelis, Huynh Tan Hoi, Vo Hoang Ca. (2022). Construction project progress evaluation using a quantitative approach by considering time, cost, and quality. (Park University Library).
    • Rodolfo Siles, PMP. Who is Responsible for Project Quality? https://www.pm4dev.com/pm4dev-blog/entry/who-is-re…

    MGT 301 Organizational Behaviour Paper

    Description

    Q1-Think of a job that requires very high levels of certain cognitive abilities. Can you think of a way to redesign that job so that people who lack those abilities could still perform the job effectively? Now respond to the same question with regard to emotional and physical abilities.

    Q2- Consider the personality dimensions included in the Myers-Briggs Type Inventory and the RIASEC model. If you had to “slot” those dimensions into the Big Five, would you be able to do so? Which dimensions don’t seem to fit?

    Q3-Think about a highly successful team with which you are familiar. What types of task, goal, and outcome interdependence does this team have? Describe how changes in task, goal, and outcome interdependence might have a negative impact on this team.

    Q4-Think of a team you’ve worked in that performed poorly. Were any of the causes of the poor performance related to the forces that tend to create process loss? If so, which force was most problematic? What steps, if any, did your team take to deal with the problem?

    Q5- Who is the most influential leader you have come in contact with personally? What forms of power did they have, and which types of influence did they use to accomplish objectives?

    Q6-You are required to reply to at least two peer discussion question post answers to this weekly discussion question and/ These post replies need to be substantial and constructive in nature.

    1- My first colleague’s post:

    1- There is no human being in the world that has all the abilities i.e. cognitive, physical and emotional abilities. People with different abilities can achieve the goals of an organization.

    Let us take the example of car manufacturing. People who have higher cognitive ability design the parts of the car and the assembly plan. People who have physical ability assemble a car using machines and psycho-motor skills. People who have emotional abilities organize the people in the factory floor and administer sales of cars. Every organization requires human abilities to achieve its goals; it is impractical to replace human abilities with their systems, which includes job redesign.

    2- Personality assessments tools helps to understand people based on their personality make up.

    Though these tools attempt to understand personality of a person, they are based on distinct theoretical model and empirical research. The context of development and the theoretical basis of each assessment tool is different.

    The Myers Briggs Type Indicator, Big five Personality factors and Holland’s RIASEC model are taxonomies of personality characteristics. Each of these is developed based on distinct theoretical foundations and empirical research. Though some factors appear to be similar in all taxonomies, many are unique for interpretation. It would be ideal to use the tools independently rather than comparing their commonality.

    3- A team is a group of individuals who are interacting, influencing and are interdependent on each other with the target and commitment of achieving the common goals of the organization as whole.

    The example of a successful football team can be where all the players are interdependent Interdependence removes the redundancies of work efforts and is therefore very efficient. The team has a task interdependency of scoring a goal against the opposition to achieve an outcome interdependence of winning the match. Therefore, their task is a collective interdependence, and the effort is a collective one with constant interaction.

    If any change in the interdependence occurs, each individual player would think about personal achievements and therefore only play for himself. But working in teams require proper coordination and cooperation among the members, which makes teamwork challenging. The outcome interdependence will change and even if the player scores high number of goals, still there is a little probability the team would succeed.

    4- Researchers have identified two kinds of team processes i.e. one that enhances the outcomes of the teamwork and the other one which diminishes the outcomes of team work. The scholar calls the former outcome as ‘process gain’ and the latter is called ‘process loss.

    The student had the experience of working in a team whose teamwork process lead to a process loss. The team was a community volunteering group, and it had the following characteristics:

  • The team members had personal conflicts with other members and were considering each
  • other as rivals

  • The team members focused only on their work and did not coordinate with other members
  • Due to lack of coordination, many of the team initiatives did not brought expected outcomes
  • The motivation to work in the team was weak and most members were focused on gossiping
  • about rival members

  • Many team members withdrew from the activities and were least participating in the team
  • meetings

    The team leaders should have taken the following steps to avoid the process loss:

  • Conduct a brainstorming session to create a team goal
  • Encourage members to participate in the decision making process
  • Allocate each member a specific role and tasks
  • Organize sessions to resolve interpersonal issues and promote healthy relationships among team members
  • Involve members to gather information about the community situation
  • Create specific communication channels to enable expression of feelings, ideas and
  • Suggestions Teamwork process has moderate contribution to outcome but has tremendous effect on the commitment of team members.

    5- True leaders enjoy the art of persuading and motivating other individuals and controlling their thought process through consultation, appeals, and various tactics of ingratiation, coalition pressure and exchange and therefore leading and guiding them to achieve the common goal.

    The immediate reporting manager of the current organization is a perfect example of the most influential leader who inveigled her subordinates to identify their potentials. Being the manager,

    she promotes basic individual rights and freedom of speech, privacy and thought processes through the legitimate power and even foster integrity and fair treatment to every individual by being just, honest, and reasonable by exerting the required coercive power. The power tactics complementing the legitimate power to meet the deadlines on time is through legitimating and imposing pressure tactics by using the authoritative power or even coercive power. At times exchange tactics are used to motivate the employees to enhance their productivity through reward power.

    Having an insatiable learning agility can leverage her analyzing skills, decision making abilities, thereby nurturing her expert power. Even being an avid learner by approaching and learning from those who already possess the knowledge even if they are subordinates is the best way to gain expert power as per her ideology. She has a modern and positive outlook towards the employees. She believes in democratic leadership rather than autocratic one.

    Confidence is one of her important traits and has adequate zeal and conviction on herself. By being an effective communicator, she exchanges ideas and suggestions with every level of subordinate of the organization but acts strategically applying personal intellect. She is demanding but at the same time maintains sociability. She is a true enthusiast towards her job and maintains integrity, loyalty, and competency and has the best decisiveness.

    My second colleague’s post:

    Question one:

    There is no human being in the world that has all the abilities i.e. cognitive, physical and emotional abilities. People with different abilities can achieve the goals of an organization.

    Let us take the example of car manufacturing. People who have higher cognitive ability design the parts of the car and the assembly plan. People who have physical ability assemble a car using machines and psycho-motor skills. People who have emotional abilities organize the people in the factory floor and administer sales of cars. Every organization requires human abilities to achieve its goals; it is impractical to replace human abilities with their systems, which includes job redesign.

    Question two:

    Personality assessments tools helps to understand people based on their personality make up.

    Though these tools attempt to understand personality of a person, they are based on distinct theoretical model and empirical research. The context of development and the theoretical basis of each assessment tool is different.

    The Myers Briggs Type Indicator, Big five Personality factors and Holland’s RIASEC model are taxonomies of personality characteristics. Each of these is developed based on distinct theoretical foundations and empirical research. Though some factors appear to be similar in all taxonomies, many are unique for interpretation. It would be ideal to use the tools independently rather than comparing their commonality.

    Question three:

    A team is a group of individuals who are interacting, influencing and are interdependent on each other with the target and commitment of achieving the common goals of the organization as whole.

    The example of a successful football team can be where all the players are interdependent Interdependence removes the redundancies of work efforts and is therefore very efficient. The team has a task interdependency of scoring a goal against the opposition to achieve an outcome interdependence of winning the match. Therefore, their task is a collective interdependence, and the effort is a collective one with constant interaction.

    If any change in the interdependence occurs, each individual player would think about personal achievements and therefore only play for himself. But working in teams require proper coordination and cooperation among the members, which makes teamwork challenging. The outcome interdependence will change and even if the player scores high number of goals, still there is a little probability the team would succeed.

    Question Four:

    Researchers have identified two kinds of team processes i.e. one that enhances the outcomes of the teamwork and the other one which diminishes the outcomes of team work. The scholar calls the former outcome as ‘process gain’ and the latter is called ‘process loss.

    The student had the experience of working in a team whose teamwork process lead to a process loss. The team was a community volunteering group, and it had the following characteristics:

  • The team members had personal conflicts with other members and were considering each
  • other as rivals

  • The team members focused only on their work and did not coordinate with other members
  • Due to lack of coordination, many of the team initiatives did not brought expected outcomes
  • The motivation to work in the team was weak and most members were focused on gossiping
  • about rival members

  • Many team members withdrew from the activities and were least participating in the team
  • meetings

    The team leaders should have taken the following steps to avoid the process loss:

  • Conduct a brainstorming session to create a team goal
  • Encourage members to participate in the decision making process
  • Allocate each member a specific role and tasks
  • Organize sessions to resolve interpersonal issues and promote healthy relationships among team members
  • Involve members to gather information about the community situation
  • Create specific communication channels to enable expression of feelings, ideas and
  • Suggestions Teamwork process has moderate contribution to outcome but has tremendous effect on the commitment of team members.

    Question Five:

    True leaders enjoy the art of persuading and motivating other individuals and controlling their thought process through consultation, appeals, and various tactics of ingratiation, coalition pressure and exchange and therefore leading and guiding them to achieve the common goal.

    The immediate reporting manager of the current organization is a perfect example of the most influential leader who inveigled her subordinates to identify their potentials. Being the manager,

    she promotes basic individual rights and freedom of speech, privacy and thought processes through the legitimate power and even foster integrity and fair treatment to every individual by being just, honest, and reasonable by exerting the required coercive power. The power tactics complementing the legitimate power to meet the deadlines on time is through legitimating and imposing pressure tactics by using the authoritative power or even coercive power. At times exchange tactics are used to motivate the employees to enhance their productivity through reward power.

    Having an insatiable learning agility can leverage her analyzing skills, decision making abilities, thereby nurturing her expert power. Even being an avid learner by approaching and learning from those who already possess the knowledge even if they are subordinates is the best way to gain expert power as per her ideology. She has a modern and positive outlook towards the employees. She believes in democratic leadership rather than autocratic one.

    Confidence is one of her important traits and has adequate zeal and conviction on herself. By being an effective communicator, she exchanges ideas and suggestions with every level of subordinate of the organization but acts strategically applying personal intellect. She is demanding but at the same time maintains sociability. She is a true enthusiast towards her job and maintains integrity, loyalty, and competency and has the best decisiveness

    MR 638 University of Toronto Accounting Employee Benefits Paper

    Description

    STAND-ALONE PROJECT   

    MR 638 Employee Benefits

    Your Stand-Alone Project responses should be both grammatically and mechanically correct, and formatted in the same fashion as the project itself. If there is a Part A, your response should identify a Part A, etc. In addition, you must appropriately cite all resources used in your response and document in a bibliography using APA style.

    In preparation for your work on the Stand-Alone Project, we will begin with some background material on the consulting company that you represent and the client company that you will be serving. 

    The Consulting Company. In this project you serve as an Employee Benefits Consultant for the Human Resources Group (HRG). HRG is a national consulting company with proven expertise in the areas of Human Resource Management. The firm is divided into three specialty practices: Organizational Development, Employee Benefits, and Compensation. You are the lead consultant in the Employee benefits practice with several analysts working for you. Your practice involves both on-site client evaluations and internal research designed to develop and deliver benefit solutions

    The Client Company. Apex Manufacturing is an Atlanta based diversified manufacturing company. It is a $2 billion organization that has been in business for 15 years. It is publicly traded on the New York Stock Exchange. Its operating companies are very decentralized and have little connection with one another. Each operating company has its own HR department headed by a VP of human resources and a support staff. The Apex Corporate HR group coordinates all human resource activity throughout the company and is headed by an SVP of HR. There is no senior level Employee Benefits officer at either the corporate or operating unit level. The company has a total employee population of 15,000 spread over 12 states. Most of the operating unit personnel are blue-collar workers, high school educated, and earning in the $15,000-$25,000 range. There is a small executive and management group at each business unit.

    The Scenario. The last several years have been rough for Apex. As the economy has worsened, its profitability has suffered. Its competitors have developed manufacturing plants in Mexico where labor costs are low, and this has translated into lower product prices than Apex can afford to match. As a result, they have seen erosion in their book of business and a steady decrease in their stock price. The Board of Directors has expressed its concern and has admonished Apex to keep a close watch on all expenses.

    Apex has always been protective of its employees. It has tried to keep wages competitive and be responsive to the employees’ needs. The company has a history of paying 100% of the cost of health benefits. Apex values the relationship that it maintains with its employees and sees that relationship as a factor in its ability to hire and retain good workers. However, employee benefit costs have skyrocketed with costs for the fully insured medical plan exceeding 45% of payroll. Premiums have increased over 15% for each of the last several years and show no signs of weakening. The President of Apex is concerned that he can no longer afford to offer cost-free benefits and is thinking of introducing employee premiums. This issue has become common knowledge among the workers who have stated their refusal to begin paying premiums.

    There is no champion for employee benefits at Apex and, therefore, there has been no strategic planning in this area. The rapidly spiraling cost of benefits is of major concern to the president. He knows that if he does not find a way to control these costs, the Board of Directors may force him to cut the benefit program significantly. This will create dissention among the employees, destroy their motivation, and further add to the operating problems at Apex. The president does not believe that he should have to call in outside consultants since he has a large internal HR group. Thus he looks to the senior vice president of HR for solutions. The SVP has no current experience in handling benefit issues of this magnitude. The Benefits Manager at Corporate is a good administrator, but also not qualified to work through these issues. The SVP has used the services of HRG in the past and knows that outsourcing is the only way to address these issues effectively.

    The Consulting Project. The SVP has contacted you at HRG asking for your assistance. He has gotten the president to agree to a meeting with you, although the president is still very leery of using outside help. He will have to be convinced that the expenditure for your services is justified. The meeting lasts for forty-five minutes, and the SVP has given you every chance to explain how you might be of service. 

    Part A The first phase of your consulting assignment is to respond to the president with a detailed answer to each of his three questions.

     1. Why are health care costs rising so rapidly? 

     2. What can Apex do to control costs? 

     3. What guarantee of success is HRG willing to make to Apex? 

     Use material from the text and outside readings to help you formulate your responses.  You may want to search the Internet for additional background information and statistics on the rising cost of health care. Use APA style when citing sources. Be particularly careful when considering the third question. Your response may well determine whether you get the business, but the overriding question is whether you can ethically guarantee results. Try to be creative as you come up with ways that both HRG and Apex can come out winners in this project.

    Congratulations! Your responses to the President of Apex have helped him to understand the complexity of health care issues in America. He now sees that it is very difficult for any single employer to combat effectively the systemic causes of rising health care costs. He also realizes the inability of his internal staff to address the problems and, therefore, reluctantly agrees to the project.

    Part B For the second phase of the project, two of your analysts came on-site to conduct the medical plan audit. After a series of meetings with Apex staff and a review of their plan documents, your analysts found the following about the Apex medical report.

     Medical Plan

     1. A fully insured indemnity plan is included.

     2. There is a $200 deductible per family member.

     3. The coinsurance plan includes paying 90% and the employee paying 10%.

     4. The out-of-pocket maximum is $2000 per family member.

     5. The prescription drug plan includes a $5 co-pay for generic drugs and a $10 co-pay for brand name drugs.

     6. The company pays 100% of the premium for both the employee and their dependents.

     You have had time to review the Apex health plan audit results. Your initial assessment is that it is a very rich plan that puts the entire burden of cost on the company.  Although it does make them unique in their industry and will attract workers, it is not an approach that can continue to be cost justified. The material in your text, as well as the Lecture and Research Updates and the Required Readings, will help you in this evaluation. You should use Internet resources to research how other companies have responded to these kinds of challenges. The next step in the project is to provide an analysis of each of the plan components listed above. For each one, you are to evaluate the advantages and disadvantages of the current provision and suggest alternatives.  Again, remember to cite all sources used. As you prepare your response, you should consider the following. (2-page, double-spaced, response is required.)

     1. Self-Insured v. Fully Insured Plan:  Would it be in the best interest of Apex to self-insure its plans, using stop loss coverage to limit their liability? 

     2. Introduction of Managed Care: Are there other forms of a health plan that would be more appropriate for a company the size of Apex?  Consider the use of Managed Care programs. 

     3. Handling of Deductibles, Coinsurance, and Out-pf-Pocket Maximums: How could Apex use utilization review and case management techniques to isolate high cost areas of the plan? 

     4. Restructure of the Drug Plan: Prescription drug costs are responsible for a major part of spiraling health care costs.  How might you change the co-pay structure to try to reduce costs? 

     5. Introduction of Employee Premiums:  What changes would you suggest to restructure the deductibles, co-insurance, and out-of-pocket maximums?

     6. Formal Recommendation: It is said that employees will never become prudent users of health care if they don’t have “any skin in the game.” How might you adjust health care premiums at Apex? 

     Once you have finished your evaluation, you should conclude with a formal recommendation to Apex senior management. 

    Part C As lead consultant for HRG, you have reviewed the evaluations and recommendations of your analysts and agree that they have come up with several ways to re-design the medical plan to reduce costs. It is also clear that these suggestions will require employees to begin making contributions to the plan and paying more in deductibles and co-pays. The employees have already voiced their disapproval of employee contributions. The third phase in the project is, therefore, to develop a plan designed to get Apex employees to buy into the proposed changes. One way that this can often be accomplished is to look at additional low-cost benefits that can be introduced as a trade-off against the medical premiums.

    As you look at the other benefits currently available to Apex employees, you determine the following:

     1. Company pays for a flat $15,000 of life insurance. No voluntary coverage.

     2. No retirement plan is available to employees.

     3. No form of flexible benefits is available.

     As you review these other benefits of the Apex plan, you begin to see a number of ways that you might be able to temper the cost of the health plan with the introduction of other employer-paid benefits. You will again need to use the text, lectures, and reading assignments to determine how you might create these new benefits.

    In this section of the project plan you will want to consider the following when preparing your plan:

     1. Life Insurance Alternatives:  The advisability of increasing the amount of company paid life insurance. You may find it helpful to check Internet providers to determine the costs of increased term insurance. Are there other types of life insurance programs that might be offered on a voluntary basis? 

     2. Retirement Plan Introduction:  Review the types of retirement plans that would be available to Apex.  You might want to concentrate your efforts on defined contribution plans that don’t require pre-funding. Remember, a 401(k) plan does not need initially to offer a company match on contributions to be successful.  

     3. Flexible Benefits Plan Given that employees may be responsible for more out-of-pocket costs, think about the use of flexible benefits. Check out the tax benefits available to both employer and employee.  

     Once you have completed your research, create a document that outlines these incremental benefits and why you believe they will enhance the overall benefit plan and reduce the negative reactions to the health care premiums. (3-page, double-spaced, response is required.)

    Part D It is now two months into your consulting project with Apex. You have identified issues regarding the Apex medical plan and have presented plan changes to senior management. You have also proposed the introduction of several new benefits that the employees are sure to like. Your final phase of the project will consist of coming up with an effective communication program.

    As you develop a communication plan, concentrate on the following issues:

     1. What is to be communicated? 

     2. How is it to be communicated? 

     3. When is it to be communicated? 

     4. Who will handle the communication? 

     As you conduct your research, you will be reminded that there are certain legal obligations in communicating benefit information. In addition, you will want to review options for creating internal, informal communication pieces that describe the “total” package being introduced. Also, consider what types of electronic communication may be available. The Internet is a great source of finding information about creative benefit communication. Remember that utilizing company managers and supervisors, as well as vendor representatives, makes for better acceptance of the message. Check to see when the Apex Open Enrollment is and be prepared to discuss the advantages of rolling out the new plans on a benefit anniversary date. As indicated above, all phases of the project must be fully annotated and all references cited. (A 3-page, double-spaced, response is required.)