Homework 1 Create a Solution for a Decision-making Process. Scenario: You’re a manager for Super Joe’s Cars that operates car dealerships throughout Kansas. SJ’s just recently acquired/merged local dealerships and now needs to ‘normalize’ their employee salaries. SJ’s now employs 30 employees that are each labeled as one of the following: Sales Representative , Senior Sales Representative, and Sales Executive. Due to different dealerships paying different salaries, these salaries are all different. SJ’s merger was a success, and has $100,000 to distribute raises to employees in order to realign them and have them close as possible to the industry average. Top management would like you to design a solution that will distribute this money to employees, with the top priority of moving as many employees as possible closer to the industry average. They have provided you with the data below (yes, it’s limited data) in order to do this. They also request that each employee gets a raise of some sort. Problem: What’s the ‘best’ way to allocate these dollars to your employees? Task: Use the data to create a SPREADSHEET that distributes the $100,000 to current employees. It should be well presented (FORMAT), and automate the process – so if the $100,000 is changed, the spreadsheet updates automatically (FORMULAS). This spreadsheet should also show other important information such as: Total salaries, current average salary per rank, new salary per rank, current deviation from the industry average, new deviation from industry average (DATA). **MUST BE DONE IN MICROSOFT EXCEL!! Shane’s Tips and Tricks: Identify your goal. In this case, you are essentially coming up with a solution to ‘who gets the raise’. There are many ways to create the solution, just choose what you feel is the best way. Identify numbers! Use $ and % signs, etc. USE FORMULAS. It’s pointless to create a spreadsheet that doesn’t calculate. A good spreadsheet allows users to change the data points and test different scenarios. If you have trouble, check out Atomic Learning on the FHSU website to view tutorials if needed. Make it pretty! Your spreadsheet should be clean, concise, and formatted nicely. Ideally, I could copy your spreadsheet and present it to others without modification. Highlight important information so it can easily be found. Use an assumption table. Your formulas should not contain numbers, but instead references to cells. An assumption table holds key information that will be used in multiple areas. You should be able to make one formula, ‘pull it down or across’, and it will work for all items. Typically when you use a number from the assumption table, you want it to be an absolute reference (meaning it doesn’t change when the formula is dragged across multiple rows). To do this, simply hit the F4 key. An assumption table can be located anywhere in the spreadsheet, but should be separate from spreadsheet data. How you are graded: Refer to the rubric with the assignment for more information on how you will be graded. Data Company Sales Employee Ranks Industry Average Salary Sales Representative $50,000 Senior Sales Representative $60,000 Sales Executive $75,000 Sales Representatives Salary Davidson Kaye 55,000 Corovic,Jose 43,000 Lane, Brandon 62,000 Wei, Guang 35,000 Drew, Richard 50,000 Adams, James 33,000 Spenser, William 51,000 Ray, Tony 41,000 Ryan, Mark 38,000 Warrem, Jason 53,000 Senior Sales Representatives Salary Ashley, Jane 53,000 Corning,Sandra 46,000 Scott, Rex 56,000 Duong,Linda 52,000 Bosa, Victor 37,000 UTran,Diem Thi 45,000 Dixon, James T 53,000 Goston, Sayeh 48,000 Jordan, Matthew 38,000 Menstell,Lori Lee 65,000 Sales Executives Salary Ching, Kam Hoong 57,000 Collins,Giovanni 75,000 Dixon,Eleonor 65,000 Lee,Brandon 60,000 Lunden,Haley 55,000 Rikki, Nicole 75,000 Scott, Bryan 67,000 Angel, Kathy 88,000 Quigly, James 59,000 Pham,Mary 80,000

Homework 1 Create a Solution for a Decision-making Process. Scenario: You’re a manager for Super Joe’s Cars that operates car dealerships throughout Kansas. SJ’s just recently acquired/merged local dealerships and now needs to ‘normalize’ their employee salaries. SJ’s now employs 30 employees that are each labeled as one of the following: Sales Representative , Senior Sales Representative, and Sales Executive. Due to different dealerships paying different salaries, these salaries are all different. SJ’s merger was a success, and has $100,000 to distribute raises to employees in order to realign them and have them close as possible to the industry average. Top management would like you to design a solution that will distribute this money to employees, with the top priority of moving as many employees as possible closer to the industry average. They have provided you with the data below (yes, it’s limited data) in order to do this. They also request that each employee gets a raise of some sort. Problem: What’s the ‘best’ way to allocate these dollars to your employees? Task: Use the data to create a SPREADSHEET that distributes the $100,000 to current employees. It should be well presented (FORMAT), and automate the process – so if the $100,000 is changed, the spreadsheet updates automatically (FORMULAS). This spreadsheet should also show other important information such as: Total salaries, current average salary per rank, new salary per rank, current deviation from the industry average, new deviation from industry average (DATA). **MUST BE DONE IN MICROSOFT EXCEL!! Shane’s Tips and Tricks: Identify your goal. In this case, you are essentially coming up with a solution to ‘who gets the raise’. There are many ways to create the solution, just choose what you feel is the best way. Identify numbers! Use $ and % signs, etc. USE FORMULAS. It’s pointless to create a spreadsheet that doesn’t calculate. A good spreadsheet allows users to change the data points and test different scenarios. If you have trouble, check out Atomic Learning on the FHSU website to view tutorials if needed. Make it pretty! Your spreadsheet should be clean, concise, and formatted nicely. Ideally, I could copy your spreadsheet and present it to others without modification. Highlight important information so it can easily be found. Use an assumption table. Your formulas should not contain numbers, but instead references to cells. An assumption table holds key information that will be used in multiple areas. You should be able to make one formula, ‘pull it down or across’, and it will work for all items. Typically when you use a number from the assumption table, you want it to be an absolute reference (meaning it doesn’t change when the formula is dragged across multiple rows). To do this, simply hit the F4 key. An assumption table can be located anywhere in the spreadsheet, but should be separate from spreadsheet data. How you are graded: Refer to the rubric with the assignment for more information on how you will be graded. Data Company Sales Employee Ranks Industry Average Salary Sales Representative $50,000 Senior Sales Representative $60,000 Sales Executive $75,000 Sales Representatives Salary Davidson Kaye 55,000 Corovic,Jose 43,000 Lane, Brandon 62,000 Wei, Guang 35,000 Drew, Richard 50,000 Adams, James 33,000 Spenser, William 51,000 Ray, Tony 41,000 Ryan, Mark 38,000 Warrem, Jason 53,000 Senior Sales Representatives Salary Ashley, Jane 53,000 Corning,Sandra 46,000 Scott, Rex 56,000 Duong,Linda 52,000 Bosa, Victor 37,000 UTran,Diem Thi 45,000 Dixon, James T 53,000 Goston, Sayeh 48,000 Jordan, Matthew 38,000 Menstell,Lori Lee 65,000 Sales Executives Salary Ching, Kam Hoong 57,000 Collins,Giovanni 75,000 Dixon,Eleonor 65,000 Lee,Brandon 60,000 Lunden,Haley 55,000 Rikki, Nicole 75,000 Scott, Bryan 67,000 Angel, Kathy 88,000 Quigly, James 59,000 Pham,Mary 80,000

For any additional help, please contact: info@checkyourstudy.com Call and Whatsapp … Read More...
The best way to minimize project risk is to: a. Perform better planning b. Select a project manager who has advanced degrees c. Select a project manager who is a technical expert d. Have a senior executive assigned as the sponsor e. Implement a project management cost control system

The best way to minimize project risk is to: a. Perform better planning b. Select a project manager who has advanced degrees c. Select a project manager who is a technical expert d. Have a senior executive assigned as the sponsor e. Implement a project management cost control system

The best way to minimize project risk is to:   … Read More...
After reading the supplement article on Business Analytics linked to the week 1 schedule, write an essay on how business analytics impacts you today, or its potential role in your chosen career path. Do research for your paper, or interview someone who works in your area. The goals of this paper are two-fold: (1) focus on high quality writing, using the COBE Writing Styles Guide for writing help and citations. (2) consider the importance of BI from a personal/work/career perspective.

After reading the supplement article on Business Analytics linked to the week 1 schedule, write an essay on how business analytics impacts you today, or its potential role in your chosen career path. Do research for your paper, or interview someone who works in your area. The goals of this paper are two-fold: (1) focus on high quality writing, using the COBE Writing Styles Guide for writing help and citations. (2) consider the importance of BI from a personal/work/career perspective.

  Business analytics importance and its potential     Introduction … Read More...
Explain the significant impact this career development experience has had and will continue to have on your life.

Explain the significant impact this career development experience has had and will continue to have on your life.

Most corporate individuals instinctively comprehend the connection between well-designed creativities … Read More...
Develop a 4 page-500 word précis on Chapter 7 “How to Monitor & Control a TPM Project” of the Wysocki 7th Ed. text.”

Develop a 4 page-500 word précis on Chapter 7 “How to Monitor & Control a TPM Project” of the Wysocki 7th Ed. text.”

Summary of ‘How to Monitor and Control a TPM Project’ … Read More...
Tutorial 4 – Management 1. Andy works as a manager for Baskervilles Dog Food Company. Because they have several different suppliers of ingredients and the suppliers’ prices fluctuate from time to time, he has to produce several different formulas for each dog food product, depending on the availability and price of ingredients from the suppliers. He then orders the ingredients accordingly. Even though he cannot predict when ingredients will become available at a particular price, his ordering of ingredients can be considered routine. a. On what level of management is Andy working? (briefly explain your reasons)

Tutorial 4 – Management 1. Andy works as a manager for Baskervilles Dog Food Company. Because they have several different suppliers of ingredients and the suppliers’ prices fluctuate from time to time, he has to produce several different formulas for each dog food product, depending on the availability and price of ingredients from the suppliers. He then orders the ingredients accordingly. Even though he cannot predict when ingredients will become available at a particular price, his ordering of ingredients can be considered routine. a. On what level of management is Andy working? (briefly explain your reasons)

This is a case of supply chain management. Since, Andy … Read More...
2. For a restaurant, local authority, and paint manufacturer identify: • a strategic decision • a tactical decision • an operational decision What information support is required for each of the decisions?

2. For a restaurant, local authority, and paint manufacturer identify: • a strategic decision • a tactical decision • an operational decision What information support is required for each of the decisions?

  Strategic decisions -are long term, multifaceted decisions made by … Read More...
4. Describe “functional aggregation” and discuss how this is relevant to logistics.

4. Describe “functional aggregation” and discuss how this is relevant to logistics.

The inspiration motivating functional aggregation was a rising faith that … Read More...
1000 words Total. Answer each question in paragraph form https://www.youtube.com/watch?v=wzicXbnmllc In the video, presented by Brooke Deterline, talks about creating ethical cultures in a business. One of Brooke’s main point was courage. She defines courage as our ability to act from our hearts in the face of fear and is a skill that we can build with practice. Brooke gives an example of life without courage and shows us many scenarios where it is still happening today, 10 years after the ENRON scandal. Courage is something that lacks in social situations where wrong is being done. She states that we all are vulnerable to situation influence all the time and that it is natural human wiring. It seems that most of us, including myself, can become a bystander to follow a leader or a group that we know is doing wrong because we want to be accepted. (1) Why do you think that the most ethical and compassionate among us can easily betray our values, in the face of challenging situations? What challenges does one face when they are presented with a difficult situation? (2) Do you believe that with practice we can retrain our brains to override our natural fear response when we are put in these challenging situations? Managers sometimes face business problems that raise difficult questions. When being faced with these problems they must choose between two ways of resolving it. Each of these alternatives is the right thing to do, but they can not do both ways. Badaracco characterizes right-versus-right dilemmas as “dirty-hands problems,” where managers or any employee often have to “get their hands dirty” by making tough choices between competing virtues such as honesty, fairness, respect, objectivity, and responsibility. He shows us three managers that face different right- versus-right conflicts. We see that these managers have the responsibilities to live up to the commitments they have made and the standards by which they want live by. However, it is not that simple to choose from wanting to be a successful manager and a decent, responsible person. (3) After reading the three different extremes of right- versus- right, why do you think that Badaracco emphasizes on the statement made by Oliver Wendell Holmes, “I do not give a fig for the simplicity on the this side complexity, but i would give my life for the simplicity on the other side of complexity,” and what do you think it means? A manager often encounters right-versus-right dilemmas where professional responsibilities conflict with personal values. For example, a senior manager may have knowledge of plans to lay off an employee-friend who is planning the purchase of a new home. Warning the friend about the upcoming layoff would certainly help the friend avoid the difficulty of paying for a new home without a job, but it may also violate an agreement with senior management and shareholders to keep such plans confidential until these plans are properly implemented. (4) In a challenging situation like this, should mangers rely on fundamental ethical principles and the company’s mission statement to help them decide what to do or should they consult their own moral instincts and intuitions?

1000 words Total. Answer each question in paragraph form https://www.youtube.com/watch?v=wzicXbnmllc In the video, presented by Brooke Deterline, talks about creating ethical cultures in a business. One of Brooke’s main point was courage. She defines courage as our ability to act from our hearts in the face of fear and is a skill that we can build with practice. Brooke gives an example of life without courage and shows us many scenarios where it is still happening today, 10 years after the ENRON scandal. Courage is something that lacks in social situations where wrong is being done. She states that we all are vulnerable to situation influence all the time and that it is natural human wiring. It seems that most of us, including myself, can become a bystander to follow a leader or a group that we know is doing wrong because we want to be accepted. (1) Why do you think that the most ethical and compassionate among us can easily betray our values, in the face of challenging situations? What challenges does one face when they are presented with a difficult situation? (2) Do you believe that with practice we can retrain our brains to override our natural fear response when we are put in these challenging situations? Managers sometimes face business problems that raise difficult questions. When being faced with these problems they must choose between two ways of resolving it. Each of these alternatives is the right thing to do, but they can not do both ways. Badaracco characterizes right-versus-right dilemmas as “dirty-hands problems,” where managers or any employee often have to “get their hands dirty” by making tough choices between competing virtues such as honesty, fairness, respect, objectivity, and responsibility. He shows us three managers that face different right- versus-right conflicts. We see that these managers have the responsibilities to live up to the commitments they have made and the standards by which they want live by. However, it is not that simple to choose from wanting to be a successful manager and a decent, responsible person. (3) After reading the three different extremes of right- versus- right, why do you think that Badaracco emphasizes on the statement made by Oliver Wendell Holmes, “I do not give a fig for the simplicity on the this side complexity, but i would give my life for the simplicity on the other side of complexity,” and what do you think it means? A manager often encounters right-versus-right dilemmas where professional responsibilities conflict with personal values. For example, a senior manager may have knowledge of plans to lay off an employee-friend who is planning the purchase of a new home. Warning the friend about the upcoming layoff would certainly help the friend avoid the difficulty of paying for a new home without a job, but it may also violate an agreement with senior management and shareholders to keep such plans confidential until these plans are properly implemented. (4) In a challenging situation like this, should mangers rely on fundamental ethical principles and the company’s mission statement to help them decide what to do or should they consult their own moral instincts and intuitions?