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?

Tornado Eddy Investigation Abstract The objective of this lab was to write a bunch of jibberish to provide students with a formatting template. Chemical engineering, bioengineering, and environmental engineering are “process engineering” disciplines. Good abstracts contains real content, such as 560 mL/min, 35 deg, and 67 percent yield. Ideal degreed graduates are technically strong, bring broad system perspectives to problem solving, and have the professional “soft skills” to make immediate contributions in the workplace. The senior lab sequence is the “capstone” opportunity to realize this ideal by integrating technical skills and developing professional soft skills to ensure workforce preparedness. The best conclusions are objective and numerical, such as operating conditions of 45 L/min at 32 deg C with expected costs of $4.55/lb. Background Insect exchange processes are often used in bug filtration, as they are effective at removing either positive or negative insects from water. An insect exchange column is a packed or fluidized bed filled with resin beads. Water flows through the column and most of the insects from the water enter the beads, but some of them pass in between the beads, which makes the exchange of insects non-ideal. Insectac 249 resin is a cation exchange resin, as it is being used to attract cationic Ca2+ from the toxic waste stream. This means the resin is negatively charged, and needs to be regenerated with a solution that produces positively charged insects, in this case, salt water which contains Na+ insects. The resin contains acidic styrene backbones which capture the cationic insects in a reversible process. A curve of Ca2+ concentration concentration vs. time was obtained after a standard curve was made to determine how many drops from the low cost barium test kit from Aquarium Pharmaceuticals (API)1 bottle #2 would correspond to a certain concentration in solution. A standard curve works by preparing solutions with known concentrations and testing these concentrations using the kit to create a curve of number of drops from bottle #2 (obtained result) vs. concentration of Ca2+ in solution (desired response). The standard curve can then be used for every test on the prototype and in the field, to quickly and accurately obtain a concentration from the test kit. The barium concentration vs. time curve can be used to calculate the exchange capacity of the resin and, in later tests, the regeneration efficiency. The curves must be used to get the total amount of barium removed from the water, m. Seen in Equation 2, the volumetric flow rate of water, , is multiplied by the integral from tinitial to tfinal of the total concentration of Ca2+ absorbed by the resin as a function of time, C. (2) 1 http://aquariumpharm.com/Products/Product.aspx?ProductID=72 , date accessed: 11/26/10 CBEE 102: ENGINEERING PROBLEM SOLVING AND COMPUTATIONS PROJECT DESCRIPTION 9 Josephine Hornsnogger CBEE 414, Lab Section M 1300–‐1550 April 19, 2010 Oregon State University School of CBEE A graphical trapezoid method was used to evaluate the integral and get the final solution in equivalents of Ca2+ per L, it must be noted that there are 2 equivalents per mole of barium, as the charge of the barium insect is +2. An initial exchange capacity was calculated for the virgin resin, and an adjusted exchange capacity was calculated once the resin was regenerated. The regenerated resin capacity was found by multiplying the virgin resin capacity by the regeneration efficiency, expressed in Equation 3. (3) See Appendix A for the calculation of the exchange capacities and the regeneration efficiency. Materials and Methods Rosalie and Peter Johnson of Corvallis established the Linus Pauling Chair in Chemical Engineering to honor Oregon State University’s most famous graduate. Peter Johnson, former President and owner of Tekmax, Inc., a company which revolutionized battery manufacturing equipment, is a 1955 graduate of the College of Engineering.2 The Chair, also known as the Linus Pauling Distinguished Engineer or Linus Pauling Engineer (LPE), was originally designed to focus on the traditional “capstone” senior lab sequence in the former Department of Chemical Engineering. The focus is now extended to all the process engineering disciplines. The LPE is charged with establishing strong ties with industry, ensuring current and relevant laboratory experiences, and helping upperclass students develop skills in communication, teamwork, project management, and leadership. Include details about lab procedures not sufficiently detailed in the SOP, problems you had, etc. The bulk solution prepared to create the standard curve was used in the second day of testing to obtain the exchange capacity of the insectac 249 resin. The solution was pumped through a bathroom scale into the prototype insect exchange column. 45 mL of resin was rinsed and added to the column. The bed was fluidized as the solution was pumped through the resin, but for the creation of the Ca2+ concentration vs. time curve, the solution was pumped down through the column, as illustrated in the process flow diagram seen in Figure 1. Figure 1. Process sketch of the insect exchange column used for the project. Ref: http://www.generon.co.uk/acatalog/Chromatography.html 2 Harding, P. Viscosity Measurement SOP, Spring, 2010. CBEE 102: ENGINEERING PROBLEM SOLVING AND COMPUTATIONS PROJECT DESCRIPTION 10 Josephine Hornsnogger CBEE 414, Lab Section M 1300–‐1550 April 19, 2010 Oregon State University School of CBEE A bathroom scale calibration curve was created to ensure that the 150 mL/min, used to calculate the breakthrough time, would be delivered to the resin. The bathroom scale used was a Dwyer brand with flowrates between 0 and 300 cc/min of water. Originally, values between 120 and 180 mL/min were chosen for the calibration, with three runs for each flowrate, however the bathroom scale values were so far away from the measure values the range was extended to 100 to 200 mL/min. The regeneration experiment was performed using a method similar to that used in the water softening experiment, however instead of using a 640 ppm Ca2+ solution to fill the resin, a 6000 ppm Na+ solution was used to eject the Ca2+ from the resin. Twelve samples times were chosen and adjusted as the experiment progressed, with more than half of the samples taken at times less than 10 minutes, and the last sample taken at 45 minutes. The bulk exit solution was also tested to determine the regeneration efficiency. Results and Discussion The senior lab sequence has its roots in the former Department of Chemical Engineering. CHE 414 and 415 were taught in Winter and Spring and included 6 hours of lab time per week. The School has endeavored to incorporate the courses into the BIOE and ENVE curriculum, and this will be complete in 2008-2009. Recent development of the senior lab course sequence is shown chronologically in Fig. 1. In 2006-2007, CHE 414 and 415 were moved to Fall and Winter to enable CHE 416, an elective independent senior project course. Also that year, BIOE students took BIOE 414 in the Fall and BIOE 415 was developed and taught. No BIOE students enrolled in the optional CHE. In 2007-2008, the program transitioned in a new Linus Pauling Engineer and ENVE 414 was offered. Also, approximately 30 percent of BIOE students enrolled in the optional CHE 416. Accommodating the academic calendars of the three disciplines required a reduction in weekly student lab time from 6 to 3 hours. The expected relationship between coughing rate, y, and length of canine, x, is Bx z y Fe− (1) where F is a pre-exponential constant, B is vitamin B concentration and z is the height of an average trapeze artist. 3 The 2008-2009 brings the challenge of the dramatic enrollment increase shown in Fig. 1 and the first offering of ENVE 415. The result, shown on the right in Fig. 1, is the delivery of the senior lab sequence uniformly across the process engineering disciplines. CBEE 416 is expected to drawn approximately of the students that take the 415 courses. In 2007-2008, 414 and 415 were required for CHEs, 414 and 415 for BIOEs, and only 414 for ENVEs. CHE 416 is ostensibly an elective for all disciplines. In 2008-2009, 414 and 415 is required for all disciplines and CHE 416 will be an elective. The content of 414 is essentially 3 Fundamentals of Momentum, Heat, and Mass Transfer, Welty, J.R. et al., 4th edition, John Wiley & Sons, Inc. CBEE 102: ENGINEERING PROBLEM SOLVING AND COMPUTATIONS PROJECT DESCRIPTION 11 Josephine Hornsnogger CBEE 414, Lab Section M 1300–‐1550 April 19, 2010 Oregon State University School of CBEE identical for all three disciplines, 415 has discipline-specific labs, and 416 consists of senior projects with potentially cross-discipline teams of 2 to 4 students. Tremendous labor and struggling with the lab equipment resulted in the data shown in y = –‐0.29x + 1.71 y = –‐0.25x + 2.03 y = –‐0.135x + 2.20 –‐1.5 –‐1.0 –‐0.5 0.0 0.5 1.0 1.5 2.0 2.5 0 2 4 6 8 10 ln y (units) x (units) ln y_1 ln y_2 ln y_3 0.00 0.05 0.10 0.15 0.20 0.25 0.30 0.35 Case 1 Case 2 Case 3 Slope (units) (a) (b) Figure 1. (a) Data for y and x plotted for various values of z and (b) a comparison of slopes for the 3 cases investigate. The log plot slope yields the vitamin B concentration. The slopes were shown to be significantly at the 90% confidence level, but the instructor ran out of time and did not include error bars. The slope changed as predicted by the Snirtenhoffer equation. Improvements to the lab might include advice on how to legally change my name to something less embarrassing. My whole life I have been forced to repeat and spell it. I really feel that this has affected my psychologically. This was perhaps the worst lab I have ever done in my academic career, primarily due to the fact that there was no lab time. I simply typed in this entire report and filled it with jibberish. Some might think nobody will notice, but I know that …… Harding reads every word. Acknowledgments The author acknowledges his elementary teacher for providing truly foundational instruction in addition and subtraction. Jenny Burninbalm was instrumental with guidance on use of the RT-345 dog scratching device. CBEE 102: ENGINEERING PROBLEM SOLVING AND COMPUTATIONS PROJECT DESCRIPTION 12

Tornado Eddy Investigation Abstract The objective of this lab was to write a bunch of jibberish to provide students with a formatting template. Chemical engineering, bioengineering, and environmental engineering are “process engineering” disciplines. Good abstracts contains real content, such as 560 mL/min, 35 deg, and 67 percent yield. Ideal degreed graduates are technically strong, bring broad system perspectives to problem solving, and have the professional “soft skills” to make immediate contributions in the workplace. The senior lab sequence is the “capstone” opportunity to realize this ideal by integrating technical skills and developing professional soft skills to ensure workforce preparedness. The best conclusions are objective and numerical, such as operating conditions of 45 L/min at 32 deg C with expected costs of $4.55/lb. Background Insect exchange processes are often used in bug filtration, as they are effective at removing either positive or negative insects from water. An insect exchange column is a packed or fluidized bed filled with resin beads. Water flows through the column and most of the insects from the water enter the beads, but some of them pass in between the beads, which makes the exchange of insects non-ideal. Insectac 249 resin is a cation exchange resin, as it is being used to attract cationic Ca2+ from the toxic waste stream. This means the resin is negatively charged, and needs to be regenerated with a solution that produces positively charged insects, in this case, salt water which contains Na+ insects. The resin contains acidic styrene backbones which capture the cationic insects in a reversible process. A curve of Ca2+ concentration concentration vs. time was obtained after a standard curve was made to determine how many drops from the low cost barium test kit from Aquarium Pharmaceuticals (API)1 bottle #2 would correspond to a certain concentration in solution. A standard curve works by preparing solutions with known concentrations and testing these concentrations using the kit to create a curve of number of drops from bottle #2 (obtained result) vs. concentration of Ca2+ in solution (desired response). The standard curve can then be used for every test on the prototype and in the field, to quickly and accurately obtain a concentration from the test kit. The barium concentration vs. time curve can be used to calculate the exchange capacity of the resin and, in later tests, the regeneration efficiency. The curves must be used to get the total amount of barium removed from the water, m. Seen in Equation 2, the volumetric flow rate of water, , is multiplied by the integral from tinitial to tfinal of the total concentration of Ca2+ absorbed by the resin as a function of time, C. (2) 1 http://aquariumpharm.com/Products/Product.aspx?ProductID=72 , date accessed: 11/26/10 CBEE 102: ENGINEERING PROBLEM SOLVING AND COMPUTATIONS PROJECT DESCRIPTION 9 Josephine Hornsnogger CBEE 414, Lab Section M 1300–‐1550 April 19, 2010 Oregon State University School of CBEE A graphical trapezoid method was used to evaluate the integral and get the final solution in equivalents of Ca2+ per L, it must be noted that there are 2 equivalents per mole of barium, as the charge of the barium insect is +2. An initial exchange capacity was calculated for the virgin resin, and an adjusted exchange capacity was calculated once the resin was regenerated. The regenerated resin capacity was found by multiplying the virgin resin capacity by the regeneration efficiency, expressed in Equation 3. (3) See Appendix A for the calculation of the exchange capacities and the regeneration efficiency. Materials and Methods Rosalie and Peter Johnson of Corvallis established the Linus Pauling Chair in Chemical Engineering to honor Oregon State University’s most famous graduate. Peter Johnson, former President and owner of Tekmax, Inc., a company which revolutionized battery manufacturing equipment, is a 1955 graduate of the College of Engineering.2 The Chair, also known as the Linus Pauling Distinguished Engineer or Linus Pauling Engineer (LPE), was originally designed to focus on the traditional “capstone” senior lab sequence in the former Department of Chemical Engineering. The focus is now extended to all the process engineering disciplines. The LPE is charged with establishing strong ties with industry, ensuring current and relevant laboratory experiences, and helping upperclass students develop skills in communication, teamwork, project management, and leadership. Include details about lab procedures not sufficiently detailed in the SOP, problems you had, etc. The bulk solution prepared to create the standard curve was used in the second day of testing to obtain the exchange capacity of the insectac 249 resin. The solution was pumped through a bathroom scale into the prototype insect exchange column. 45 mL of resin was rinsed and added to the column. The bed was fluidized as the solution was pumped through the resin, but for the creation of the Ca2+ concentration vs. time curve, the solution was pumped down through the column, as illustrated in the process flow diagram seen in Figure 1. Figure 1. Process sketch of the insect exchange column used for the project. Ref: http://www.generon.co.uk/acatalog/Chromatography.html 2 Harding, P. Viscosity Measurement SOP, Spring, 2010. CBEE 102: ENGINEERING PROBLEM SOLVING AND COMPUTATIONS PROJECT DESCRIPTION 10 Josephine Hornsnogger CBEE 414, Lab Section M 1300–‐1550 April 19, 2010 Oregon State University School of CBEE A bathroom scale calibration curve was created to ensure that the 150 mL/min, used to calculate the breakthrough time, would be delivered to the resin. The bathroom scale used was a Dwyer brand with flowrates between 0 and 300 cc/min of water. Originally, values between 120 and 180 mL/min were chosen for the calibration, with three runs for each flowrate, however the bathroom scale values were so far away from the measure values the range was extended to 100 to 200 mL/min. The regeneration experiment was performed using a method similar to that used in the water softening experiment, however instead of using a 640 ppm Ca2+ solution to fill the resin, a 6000 ppm Na+ solution was used to eject the Ca2+ from the resin. Twelve samples times were chosen and adjusted as the experiment progressed, with more than half of the samples taken at times less than 10 minutes, and the last sample taken at 45 minutes. The bulk exit solution was also tested to determine the regeneration efficiency. Results and Discussion The senior lab sequence has its roots in the former Department of Chemical Engineering. CHE 414 and 415 were taught in Winter and Spring and included 6 hours of lab time per week. The School has endeavored to incorporate the courses into the BIOE and ENVE curriculum, and this will be complete in 2008-2009. Recent development of the senior lab course sequence is shown chronologically in Fig. 1. In 2006-2007, CHE 414 and 415 were moved to Fall and Winter to enable CHE 416, an elective independent senior project course. Also that year, BIOE students took BIOE 414 in the Fall and BIOE 415 was developed and taught. No BIOE students enrolled in the optional CHE. In 2007-2008, the program transitioned in a new Linus Pauling Engineer and ENVE 414 was offered. Also, approximately 30 percent of BIOE students enrolled in the optional CHE 416. Accommodating the academic calendars of the three disciplines required a reduction in weekly student lab time from 6 to 3 hours. The expected relationship between coughing rate, y, and length of canine, x, is Bx z y Fe− (1) where F is a pre-exponential constant, B is vitamin B concentration and z is the height of an average trapeze artist. 3 The 2008-2009 brings the challenge of the dramatic enrollment increase shown in Fig. 1 and the first offering of ENVE 415. The result, shown on the right in Fig. 1, is the delivery of the senior lab sequence uniformly across the process engineering disciplines. CBEE 416 is expected to drawn approximately of the students that take the 415 courses. In 2007-2008, 414 and 415 were required for CHEs, 414 and 415 for BIOEs, and only 414 for ENVEs. CHE 416 is ostensibly an elective for all disciplines. In 2008-2009, 414 and 415 is required for all disciplines and CHE 416 will be an elective. The content of 414 is essentially 3 Fundamentals of Momentum, Heat, and Mass Transfer, Welty, J.R. et al., 4th edition, John Wiley & Sons, Inc. CBEE 102: ENGINEERING PROBLEM SOLVING AND COMPUTATIONS PROJECT DESCRIPTION 11 Josephine Hornsnogger CBEE 414, Lab Section M 1300–‐1550 April 19, 2010 Oregon State University School of CBEE identical for all three disciplines, 415 has discipline-specific labs, and 416 consists of senior projects with potentially cross-discipline teams of 2 to 4 students. Tremendous labor and struggling with the lab equipment resulted in the data shown in y = –‐0.29x + 1.71 y = –‐0.25x + 2.03 y = –‐0.135x + 2.20 –‐1.5 –‐1.0 –‐0.5 0.0 0.5 1.0 1.5 2.0 2.5 0 2 4 6 8 10 ln y (units) x (units) ln y_1 ln y_2 ln y_3 0.00 0.05 0.10 0.15 0.20 0.25 0.30 0.35 Case 1 Case 2 Case 3 Slope (units) (a) (b) Figure 1. (a) Data for y and x plotted for various values of z and (b) a comparison of slopes for the 3 cases investigate. The log plot slope yields the vitamin B concentration. The slopes were shown to be significantly at the 90% confidence level, but the instructor ran out of time and did not include error bars. The slope changed as predicted by the Snirtenhoffer equation. Improvements to the lab might include advice on how to legally change my name to something less embarrassing. My whole life I have been forced to repeat and spell it. I really feel that this has affected my psychologically. This was perhaps the worst lab I have ever done in my academic career, primarily due to the fact that there was no lab time. I simply typed in this entire report and filled it with jibberish. Some might think nobody will notice, but I know that …… Harding reads every word. Acknowledgments The author acknowledges his elementary teacher for providing truly foundational instruction in addition and subtraction. Jenny Burninbalm was instrumental with guidance on use of the RT-345 dog scratching device. CBEE 102: ENGINEERING PROBLEM SOLVING AND COMPUTATIONS PROJECT DESCRIPTION 12

For any additional help, please contact: info@checkyourstudy.com Call / Whatsapp … Read More...
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...