icon

Usetutoringspotscode to get 8% OFF on your first order!

Management communication

Management communication

Spreadsheet

Objective/Overview:
This assignment provides students the opportunity to utilize advanced features of a spreadsheet application and perform analysis to establish a business decision. This project uses different features such as functions, absolute addressing, and charts. The student is expected to create a single file that consists of the elements listed below to calculate and illustrate the grades for a fictitious Info 309 class. The information will then be analyzed and presented in a report.
1. Create a series of correlation matrices to examine HR practices and performance.

a. Turnover (full time and part time) and HR practices
b. Financials (earnings as a % of revenue, revenue per car) and HR practices
c. Safety (WC per 10,000 cars , OSHA per 10,000 cars , lot damage per car) and HR practices

Which HR practices are significantly correlated with (a) turnover, (b) financial results, and (c) safety? HINT: PLEASE DON’T PASTE THE CORRELATION TABLES INTO WORD (THEY ARE TOO BIG!). INSTEAD USE THE FOLLOWING TABLE AND NOTE WHICH PRACTICES ARE SIGNIFICANTLY RELATED AT p<.05 WITH THE OUTCOMES.

Full time turnover % Part time turnover % Earnings as % of Revenue Revenue per Car WC claims per 10000 cars OHSA accidents per 10000 cars Lot damage per car
Auction Provides Formal Training
New Hire Orientation
Managerial Supervisory Training
Vehicle Inspection Training
Training hours per year
% of Workers Given Performance Eval
% of Workers with Job Descriptions
Selection Tests
Grievance Procedures
Share Financial Information
Share Business Information
Job Rotation
Cross Training
Bonus or Profit Sharing
Merit Raises
Seniority Based Pay
Internal Promotion
Internal Job Posting

Examine the following HR practices:
Training Auction Provides Formal Training
t1 New Hire Orientation
t2 Managerial Supervisory Training
t3 Vehicle Inspection Training
Trhrs Training hours per year
Pfevale % of Workers Given Performance Eval
Jobdesc % of Workers with Job Descriptions
Selection Selection Tests
Griev Grievance Procedures
Fininf Share Financial Information
Plninf Share Business Information
Rotat Job Rotation
Cross Cross Training
Bonus Bonus or Profit Sharing
Merit Merit Raises
Senpay Seniority Based Pay
Intprom Internal Promotion
Intpost Internal Job Posting
2. Conduct appropriate t-tests and/or ANOVA’s. Include test output with your answers. Use p < .05 for hypotheses tests.
a. Is auction type related to auction size (cars consigned) or financial results (ebitdal % of revenue and gross revenue per car consigned)?

HINT: YOU CAN RUN AN ANOVA OR TTEST FOR MULTIPLE DEPENDENT VARIABLES AT THE SAME TIME BY ENTERING THEM INTO ONE COMMAND. FOR EXAMPLE:

ONEWAY consign earningspercent revpercar BY type
/MISSING ANALYSIS.

b. Is formal training related to auction performance (turnover, financials, and safety)?
c. Is the frequency of performance evaluations related to auction performance (turnover, financials, and safety)?
d. Are selection tests related to part time and full time turnover?

3. Create a bar chart that illustrates one of the significant relationships found in #2.

4. Create a contingency table and conduct a Chi Square test. Is auction legacy status related to auction type?

Please turn in a copy of your syntax file and a word document with your findings summarized. For each test paste the important output into the document and please INTERPRET EACH TEST IN A SENTENCE OR TWO with your conclusion.
Required – Report

Overview:
You are an analysts assigned to research the accusation that student grades do not reflect the school standards. To start out the research you have decided to take the grades from an Info 309 class and evaluate them and see if you can find any discrepancies.
Requirements:
To get a better understanding of the situation you will perform the following:

1) Utilize the information generated in the spreadsheet above
2) Generate a report to your supervisor indicating your findings. Include the following:
a) Introduction explaining why you have decided to perform this analysis
b) Methodology utilized
c) Findings of you analysis. Discuss, as a minimum, the grade distribution and what you would expect the results to look like. Feel free to discuss any other conclusions.
d) Recommendations. Describe what you think should be done to correct any issues.

You can leave a response, or trackback from your own site.

Leave a Reply

Management Communication

Each document should be one page each except for two parts. Breakdown
Email 1: 1 page
Email 2: 1 Page
Blog Entry: 1 Page
Persuasive Letter: 1.5 Pages
Customer Response: 0.5 pages
Evaluation: 1 page
Evaluation 2: 1 page

As a business manager, you may encounter situations that require a wide variety of communication responses. For this assessment, you will be creating a portfolio of communication documents. Please format each communication appropriately for the message type.

Scenario #1:

You are a manager of a company that has recently purchased a smaller company. The purchased company has an existing product, which will now be part of your product offering. The product is a weight-loss supplement called Weight Loss Optimizer. The product has been very successful for the previous owner, but the company had limited ability to adjust its manufacturing system to accommodate growth, as well as a limited potential sales audience. Your role is to oversee and coordinate all aspects of launching the product from the newly acquired company. You have a far greater manufacturing capacity and more potential customers readily available because you already sell several weight-loss related products to a large base of customers.

Weight Loss Optimizer has been proven successful by a research study. The study consisted of 100 participants, 90% of whom lost at least 15 pounds over a reasonable time period. To date, the study participants have successfully maintained their weight loss by continuing to use the product. Of the users, 80% were able to maintain their weight loss with continued use of Weight Loss Optimizer. The 10% of study participants who were not successful may have been unsuccessful because they did not follow the program’s protocol as set forth. An inherent risk in a weight loss product is the inability to determine if the product has failed to produce results or if the user has not followed directions. Dissatisfied customers present a challenge as a result.

Your success relies upon your external business partner, Pills Inc., who manufactures the pill casing for the Weight Loss Optimizer. You will need to work closely with this partner to ensure your manufacturing operation is able to increase as needed in a just-in-time environment to meet sales demands. Your contact’s name at Pills Inc. is Susan Jones.

You have received a customer complaint via the company’s social media page. The customer’s complaint is as follows: “Weight Loss Optimizer does not work! I’ve been using this for a week, and I haven’t lost anything! No one should buy this product!”

—–

B. Develop an e-mail to motivate and encourage the staff within your company from your chosen scenario.

1. Discuss two advantages of the newly acquired product.
2. Predict two disadvantages that may appear.
a. Explain how to mitigate these disadvantages, should they occur.

C. Develop an e-mail to motivate and encourage external stakeholders of your company in your chosen scenario.

1. Discuss two advantages of the newly acquired product.
2. Predict two disadvantages that may appear.
a. Explain how to mitigate these disadvantages, should they occur.

D. Develop a company blog entry in support of the new product from your chosen scenario.

1. Discuss three of the product’s benefits for users.

E. Develop a persuasive letter to the business partner in your chosen scenario in which your goal is to overcome your business partner’s objections to a shorter manufacturing lead time.

Note: Manufacturing lead time refers to the total time required from the time of ordering to fulfillment (i.e. shipment/delivery).

F. Develop a response to the customer from your chosen scenario who posted a complaint about the product to the company’s social media page.

Note: There is a specific complaint within each scenario. The customer is extremely dissatisfied with the product from your chosen scenario.

1. Discuss the necessary steps to resolve the conflict.

2. Discuss your resolution offer to the customer.

G. Evaluate the effectiveness of the positive and negative communication strategies used throughout your communication portfolio for both internal and external stakeholders.

H. Evaluate the effectiveness of the different communication modalities (e.g., e-mail, blogs, social media, formal letters) used throughout your communication portfolio for both internal and external stakeholders.

I. When you use sources, include all in-text citations and references in APA format.

You can leave a response, or trackback from your own site.

Leave a Reply

Powered by WordPress | Designed by: Premium WordPress Themes | Thanks to Themes Gallery, Bromoney and Wordpress Themes