Company Analysis Archives - Page 2 of 2

Excel memo

Two weeks after you have taken on a job as an analyst for the City of Miami, the Mayor’s office comes to you with the following problem.

There has been a discussion about whether the city should support the crime prevention program “Learning from LA,” targeting assaults and theft crimes.

The program would involve the exchange of officers, joint planning sessions and CompStat-like data-driven review meetings, as well as the training of Miami officers in Los Angeles. The idea is to learn best practices from the police department in Los Angeles, which has been known to be effective in preventing crimes and clearing cases.

The program, however, is quite expensive, and though the Chief of the Miami Police Department fully supports it, there has also been criticism.

An influential council man, who has been involved in Miami politics for a couple of decades, stated the following: “This program would be an unnecessary expense.

Everybody knows that Miami has done a great job decreasing its crimes rates during the last couple of years. There is nothing really to learn from a city like Los Angeles of all places.

We don’t have the time and money to send our officers on a paid vacation to California.”

The mayor wants you to provide some greater insights on this issue; he says: want to know whether L.A. has really done better than we have and whether the program would be worth it. Crunch the numbers and tell me what you think.

Go to the following websites and create a data table in Excel:

http://www.city-data.com/crime/crime-Miami-Florida.html (Links to an external site.)

http://www.city-data.com/crime/crime-Los-Angeles-California.html (Links to an external site.)

Use the tables “Crime rates in … by Year” from the websites and create a table with five columns. The first column should display the years, the other four columns should show the “assault” and “theft” data for both cities and each year.

Make sure you use the “Per 100,000 Pop” data (the numbers in parentheses), which standardize the crime data and, therefore, make them comparable.

Create two charts that compare crime trends across cities. Label the charts in a meaningful way. For example, the x-axis should show the years 2006–2019.

Determine the average growth rates for each crime category and compare them across cities.

Determine whether the crime rate differences between cities are statistically significant. Run two t-tests to compare the average crime rates for assaults and thefts across cities.

Lacks Tracks Cycles Business Analysis

See the attachment for detail instructions. Only use the referenced websites listed in the attachment as APA references.

Use only the BOLDED centered and left-justified headings to write your paper.

Introduction

Write an Introduction paragraph. The introduction paragraph is the first paragraph of the paper and will be used to describe to the reader the intent of the paper explaining the main points covered in the paper. This intent should be understood prior to reading the remainder of the paper so the reader knows exactly what is being covered in the paper. The introduction is often written after the paper is completed. (Use as needed appropriate in-text citation and include the references in the Reference section)
The body of the paper will cover the following:

Controls

Explain what control means in a business setting. (Use heading below and in-text citation as required)

Explain why Lacks Tracks must be concerned with the actual production metrics at its plants. (Use headings below and in-text citation as required)
Control Defined

Importance of Lacks Tracks Production Metrics

Standard Specifications

Compare the metrics table standards to the actual performance outcomes at each of the five (5) plants and explain your findings for each plant. (Use the headings below and citations and references as appropriate.)

Identify the four (4) most important and common deviations from the standards among the plants and explain why this data is important to Lacks Tracks management. (Use the headings below and citations and references as appropriate.)
Using course materials identify and explain two (2) types of controls that could be used by Lacks Tracks management to attempt to correct the deviations from standards at its plants.

(Use the headings below and citations and references as appropriate.)
Metrics Table Plant Performance Comparisons

Four Most Significant Deviations

Two Recommended Controls

Total Quality Management

Explain why the implementation of a Total Quality Management (TQM) program could improve operational efficiency at Lacks Tracks.