You will need to log into the Harvard Business Publishing – Organizational Behavior Simulation: Judgement in Crisis simulation environment and review the instructions on how to participate.
Students play the role of a product manager at Matterhorn Health, a medical device manufacturer. The company recently launched the GlucoGauge blood glucose monitor, the company’s most expensive product development effort to date. In spite of vigorous pre-release testing, there are problems reported by customers almost immediately after launch. Throughout the simulation, students will use a series of desktop applications to receive communications from their colleagues about the problem at hand. They will receive a barrage of information through various channels – email, video messages, voicemail messages, and instant message chats – requesting that they determine the root cause of the issue and make recommendations on how Matterhorn can get ahead of this problem.
Although there is no wrong way to complete the simulation, be sure to follow all of the instructions.
Once you complete the simulation, please answer the following questions in a word document and submit your document for grading:
What are the decisions you made?
Why did you make each of your decisions?
What have you learned from this simulation?
Completed Simulation with Press Release: 50 Points.
Questions Rubric – 25 points. The total assignment is 75 points.
Project Description Assignment | Homework For You mba essay help
OMP_GRADER_CAP_AS – Manufacturing 1.4 Project Description: You have recently become the CFO for Beta Manufacturing, a small cap company that produces auto parts. As you step into your new position, you have decided to compile a report that details all aspects of the business, including: employee tax withholding, facility management, sales data, and product inventory. To complete the task, you will duplicate existing formatting, utilize various conditional logic functions, complete an amortization table with financial functions, visualize data with PivotTables, and lastly import data from another source. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Open eApp_Cap2_Manufacturing.xlsx and save the workbook as eApp_Cap2_Manufacturing_LastFirst. 0.000 2 Group all the worksheets in the workbook and fill the range A1:F1 from the Insurance worksheet across all worksheets maintaining the formatting. Ungroup the worksheets after the fill is complete and ensure the Insurance worksheet is active. 4.000 3 Click cell I5 and enter a function that determines the number of full-time employees, (FT). 2.000 4 Enter a function in cell I6 that determines the average salary of all full-time employees. Format the results in Accounting Number Format. 2.000 5 Enter a lookup function in cell E5 that returns the tax deduction amount for the number of dependents listed in the cell C5. Use the table in range H13:I17 to complete the function. The maximum deduction is $500.00; therefore, employees with more than four dependents will receive no additional deductions. 2.000 6 Use Auto Fill to copy the function down, completing column E.
Be sure to use the appropriate cell referencing. Format the data in column E with the Accounting Number Format. 4.000 7 Enter a logical function in cell F5 that calculates employee FICA withholding. If the employee is full-time and has at least one dependent, then he or she pays 7% of the annual salary minus any deductions. All other employees pay 5% of the annual salary minus any deductions. Copy the function down through column F. Format the data in column F with Accounting Number Format. 3.000 8 Apply conditional formatting to the range C5:C34 that highlights any dependents that are greater than 3 with Light Red Fill and Dark Red Text. 4.000 9 Click cell H10, and enter an AVERAGEIFS function to determine the average salary of full-time employees with at least one dependent.
Format the results in Accounting Number Format. 3.000 10 Use Advanced Filtering to restrict the data to only display full-time employees with at least one dependent. Place the results in cell A37. Use the criteria in the range H24:M25 to complete the function. 2.000 11 Ensure that the Facilities worksheet is active. Use Goal Seek to reduce the monthly payment in cell B6 to the optimal value of $6000. Complete this task by changing the Loan amount in cell E6. 5.000 12 Create the following three scenarios using Scenario Manager. The scenarios should change the cells B7, B8, and E6. Good B7 = .0325 B8 = 5 E6 = 275000 Most Likely B7 = .057 B8 = 5 E6 = 312227.32 Bad B7 = .0700 B8 = 3 E6 = 350000 Create a Scenario Summary Report based on the value in cell B6. Format the new report appropriately. 5.000 13 Ensure that the Facilities worksheet is active. Enter a reference to the beginning loan balance in cell B12 and enter a reference to the payment amount in cell C12.
4.000 14 Enter a function in cell D12, based on the payment and loan details, that calculates the amount of interest paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references. 3.000 15 Enter a function in cell E12, based on the payment and loan details, that calculates the amount of principal paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references. 3.000 16 Enter a formula in cell F12 to calculate the remaining balance after the current payment. The remaining balance is calculated by subtracting the principal payment from the balance in column B. 2.000 17 Enter a function in cell G12, based on the payment and loan details, that calculates the amount of cumulative interest paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references.
3.000 18 Enter a function in cell H12, based on the payment and loan details, that calculates the amount of cumulative principal paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references. 3.000 19 Enter a reference to the remaining balance of payment 1 in cell B13. Use the fill handle to copy the functions created in the prior steps down to complete the amortization table. 3.000 20 Ensure the Sales worksheet is active. Enter a function in cell B8 to create a custom transaction number. The transaction number should be comprised of the item number listed in cell C8 combined with the quantity in cell D8 and the first initial of the payment type in cell E8. Use Auto Fill to copy the function down, completing the data in column B. 7.000 21 Enter a nested function in cell G8 that displays the word Flag if the Payment Type is Credit and the Amount is greater than or equal to $4000. Otherwise, the function will display a blank cell.
Use Auto Fill to copy the function down, completing the data in column G. 7.000 22 Create a data validation list in cell D5 that displays Quantity, Payment Type, and Amount. 5.000 23 Type the Trans# 30038C in cell B5, and select Quantity from the validation list in cell D5. 2.000 24 Enter a nested lookup function in cell F5 that evaluates the Trans # in cell B5 as well as the Category in cell D5, and returns the results based on the data in the range A8:F32. 3.000 25 Create a PivotTable based on the range A7:G32. Place the PivotTable in cell I17 on the current worksheet. Place Payment Type in the Rows box and Amount in the Values box. Format the Amount with Accounting Number Format. 5.000 26 Insert a PivotChart using the Pie chart type based on the data. Place the upper-left corner of the chart inside cell I22. Format the Legend of the chart to appear at the bottom of the chart area. Format the Data Labels to appear on the Outside end of the chart.
Note, Mac users, select the range I18:J20, on the Insert tab, click Recommended Charts, and then click Pie. Format the legend, and apply the data labels as specified. 4.000 27 Insert a Slicer based on Date. Place the upper-left corner of the Slicer inside cell L8. 3.000 28 Ensure the Inventory worksheet is active. Import the Access database eApp_Cap2_Inventory.accdb into the worksheet starting in cell A3. Note, Mac users, download and import the delimited Inventory.txt file into the worksheet starting in cell A3. 5.000 29 Create a footer with your name on the left, the sheet code in the center, and the file name on the right for each worksheet. 2.000 30 Save and close the file. Based on your instructor’s directions, submit eApp_Cap2_Manufacturing_LastFirst.xlsx. 0.000 Total Points 100.000. Get Finance homework help today
Culture And Society In Korea Assignment | College Homework Help mba essay help
- 5-7 pages essay
- Essay Topic A: Pick one film viewed in class. In what ways does the film depart from the historical record or literary sources it is based on? What do you think is the significance of these departures? Please refer to specific scenes and passages as you make your analysis.
- Essay Topic B: Compare two films viewed in class. What are the themes they have in common? How are these themes treated differently in each of these films? What choices did the film make to impart these different messages? Please refer to specific scenes and passages as you make your analysis.
Choice of Film:
1. Tyrant Yeonsa(1962): https://www.youtube.com/watch?v=KU3zNR40aE8
2. The Happy Day of Maeng Jin-sa(1962): https://www.youtube.com/watch?v=S1MXH1gMJeg
3. Chunhyang (1961): https://www.youtube.com/watch?v=DmYVrjINoa8
4. Untold Scandal (2003): https://www.youtube.com/watch?v=SzpoMU4h_00&t=4744s
- Focus on a specific issue/topic/theme pertaining to the film[s]. E.g. treatment of women, use of color, relationship to source text, characterization, moral message etc.
- Present a cogent ARGUMENT about the film and the issue/topic/theme. I.e. “I argue Film A uses the female characters in the film to highlight different attitudes towards the meaning of loyalty.”
- Use the events, camera shots, mise-en-scene (scenery, props, framing) of specific scenes, identified by timestamp, to illustrate and back up the ARGUMENT
- Cite or quote passages from relevant assigned readings to illustrate or back up the ARGUMENT
- Have a logical organization, with a beginning, middle, and end. Get English homework help today
McLuhan and the Critical Perspective Assignment | College Homework Help mba essay help
To successfully complete this assignment, carefully re-read the McLuhan Playboy interview, the chapter from Understanding Media, and review the lectures on McLuhan and the Critical Perspective. Next, determine if McLuhan used the critical perspective in his thinking about the medium is the message. Specifically, does McLuhan:
- Question commonly held assumptions?
- Expand the bounds of debate?
- Aim for the betterment of society?
Is McLuhan using the critical perspective? If so, explain how his thinking utilizes the above hallmarks of the critical perspective. If not, explain how his approach differs from the above. Get English homework help today
Article Reading & Respond Assignment | College Homework Help mba essay help
Prepare to make a case both in support and against the following statement:
More of the world should rely on virtual water trade
On Monday, groups on one side of the classroom will argue for the affirmative side of the statement while the groups on the other side of the room will argue the negative side. You should come prepared with a list of arguments to support either side.
Calculate your Water Footprint in three ways, taking note of the information the calculators are using to make their estimates, along with your results. First, use the quick calculator (first citation below), then work through the extended calculator (second citation below) and see how your footprints compare. Third, work through either calculator, but change your country or some other input. Bring your results to class on Monday.
Water Footprint Calculators
Chapagain, AK, Hoekstra, AY and Mekonnen, M (2007). Your Water Footprint – The Quick Calculator. University of Twente. http://waterfootprint.org/en/resources/interactive-tools/personal-water-footprint-calculator/
Chapagain, AK, Hoekstra, AY and Mekonnen, M (2007). Your Water Footprint – Extended Calculator. University of Twente. http://waterfootprint.org/en/resources/interactive-tools/personal-water-footprint-calculator/personal-calculator-extended/
Read the following short web page from the Water Footprint Network, then read one of the articles/reports in the numbered list below. This will prepare you to discuss the concepts, value, and uncertainties of national scale water footprints.
Water Footprint Network (2016). National Water Footprint. http://waterfootprint.org/en/water-footprint/national-water-footprint/
Plus one of the following…
Aldaya, MM and Hoekstra, AY (2010). The Water Needed for Italians to Eat Pasta and Pizza. Agricultural Systems, 103: 351–360. http://www.waterfootprint.org/Reports/Report36-WaterFootprint-Pasta-Pizza.pdf
Type up your responses to the prompts below. This is what you will submit for a grade on Homework 2.
2) Write a paragraph comparing the results, your take on their relative accuracy, and the impact of changing your country of origin or some other input. (3pts)
3) Write a paragraph consisting of your evaluation of the value of water footprint analysis. What is to be learned from it? How can it be used? What are its limitations? (3pts) Get English homework help today
Management Assignment | College Homework Help mba essay help
Imagine that you are a HR manager within that organization. You have been tasked with developing a training to help prevent future violations of the HR law.
Compile research and information to include in your training.
Address the following in 700 to 1,050 words from your research:
Summarize the situation.
Recommend steps that organizational leadership should take in order to avoid challenges such as this one from happening in the future.
Cite your outside sources with APA formatting. Please submit assignment in APA paper format. Get Business and Finance homework help today
Management Assignment | College Homework Help mba essay help
What are the pertinent components of Process Improvement? Examine a local store or business with which you are familiar.What specifically needs to improve? What processes are in place and what is not in place? For example, you can discuss customer service issues or product concerns.
- Write between 700 – 1,000 words using Microsoft Word in APA style, see example below.
- Use font size 12 and 1” margins.
- Include cover page and reference page.
- At least 80% of your paper must be original content/writing.
- No more than 20% of your content/information may come from references.
- Use at least three references from outside the course material, one reference must be from EBSCOhost. Text book, lectures, and other materials in the course may be used, but are not counted toward the three reference requirement.
- Cite all reference material (data, dates, graphs, quotes, paraphrased words, values, etc.) in the paper and list on a reference page in APA style.
References must come from sources such as, scholarly journals found in EBSCOhost, CNN, online newspapers such as, The Wall Street Journal, government websites, etc. Sources such as, Wikis, Yahoo Answers, eHow, blogs, etc. are not acceptable for academic writing. Get Business and Finance homework help today
Enterprise Risk Management Assignment | College Homework Help mba essay help
“What are the main financial risk management issues that Cathy and the rest of the management team at Kilgore need to focus on?” Get Information System homework help today
Statistics Assignment | Professional Writing Services mba essay help
1. A families value group claims that the average cost for a family of four to attend a Major League Baseball game is not equal (≠)to $172.
A random sample of 22 families reported an average cost of $189.34, with a sample standard deviation of $33. 65. Use α = 0.10.
Get Statistics homework help today
Comprehensive Coverage Assignment | Homework For You mba essay help
|b.||collision with a bird or animal.|
|d.||Falling tree branch from the neighbor’s property|
Get Finance homework help today
Social Science Assignment/Buy Homework Help mba essay help
October 25, 2065. Individuals who believe they might have been subjects of the study may request data (subject to redaction) from the Jewish Board of Family and Children’s Services, who own the records. If subjects don’t ask for the data — because they’ve never heard of the study or they don’t have the technological or institutional literacy required — they will never know if they were included in this study. They will never know if they have a twin.
Would Internal Review Boards (IRBs) — the institutional committees that hold research protocols to ethical standards—all such a study design to proceed?
What ethical standards come into question? Do you think participants would want to be contacted? How do you weigh one potential ill, the harm of contacting someone who wouldn’t want to know, with another, the harm of not contacting someone who would want to be told? How do you notify someone that information they might want to have is available, without revealing too much? What if a subject’s twin has died since the experiment — should the subject still be contacted? Discuss any ethical concerns you have. Get Social Science help today
Essay Writing at Profs Only
Review This Service