QMB Project Assignment | Homework Help Websites

Only 1st question (chart)

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper

The company has hired your group as consultants to determine whether they should expand their services. Using the case and information provided, groups will conduct analyses. A decision of whether or not to expand will be made based on the results of the analyses conducted. 2 paragraphs explaining.


Group Project

QMB 3200

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper


Miami Investigations, Inc. provides investigative solutions to its customers. Its customers include both individuals and businesses. The company is a successful local mid-sized organization located in Miami-Dade County and employs approximately 200 individuals. Within the company there are several departments. These departments include Finance and Accounting, Marketing, Sales, HR, Customer Support, and IT. Miami Investigations, Inc. currently has established processes and is utilizing several systems for its business, including a MS SQL Server DBMS, a SalesForce CRM, and MS SharePoint among other common tools such as MS Office. Additionally, an intranet is utilized for communication of information to and between employees. The Company offers the following as part of its portfolio of services to its customers:

  • Infidelity and personal investigations
  • Background checks
  • Corporate investigations
  • Worker’s compensation investigations
  • Computer fraud and forensics
  • Fraud and theft investigations


Miami Investigations, Inc. is growing and considering expansion of its services to another market segment, Broward County. You have been provided the following data on the company: 1) 5-yr budget forecast of expansion; 2) Price list of services offered; 3) Sample customer information from CRM; and 4) community income statistics for both Broward and Miami-Dade Counties.


Using the data provided, conduct an analysis using each the methods as described below. Using the results obtained from the analyses, determine if Miami Investigations, Inc. should expand to Broward County. You should provide a full explanation of the decision and use the results from items 1 – 4 below to support your decision.



Methods of Analysis

  1. Using the Net Revenues provided in the income statement, graph a trend analysis (line graph) of the forecasted revenue (loss). Be sure to label the graph.


  1. Using the data provided from the CRM on its customers and the price list of services, a) create a pivot table to summarize the data into a table (this will be a frequency table which should show the breakdown of services by customer type and the average revenue for each service by customer type; b) perform descriptive statistics (should include mean, median, and standard deviation) on the prices each customer paid for services for all customer types together; and c) using pivot table created in part a), create two graphs of the data – one based on revenue and the other based on count of customers. These graphs can be any type of your choosing (i.e. pie, line, bar, stacked bar, etc.) The graphs must include labels.
  2. Conduct a hypothesis test comparing the mean median income of Broward County and Miami-Dade County.
  3. Looking at the services businesses purchased versus consumers purchased, conduct a one-way ANOVA to compare the average amount spent between the two groups.

Use z for hypothesis test α = .05 Should graphs in 2) be the same?


Income Statement 2016 Expansion Forecast Expansion Forecast Expansion Forecast Expansion Forecast Expansion Forecast
Miami, FL Office Year 1 Year 2 Year 3 Year 4 Year 5
Services  $10,000,000  $   1,000,000  $     2,000,000  $   3,500,000  $   5,000,000  $   6,500,000
Total Revenues  $10,000,000  $   1,000,000  $   2,000,000  $   3,500,000  $   5,000,000  $   6,500,000
Salaries       4,100,000           325,000             325,000           325,000           325,000           325,000
Rent expense             60,000               8,200                  8,200               8,200               8,200               8,200
Utlities expense               6,200               2,800                  2,800               2,800               2,800               2,800
Office supplies           625,000             75,000                75,000             75,000             75,000             75,000
Office equipment                        –           500,000                           –                        –                        –                        –
Subscriptions & licensing       1,200,000             75,000                75,000             75,000             75,000             75,000
Total Expenses  $   5,991,200  $      986,000  $      486,000  $      486,000  $      486,000  $      486,000
Net Income (Loss)  $   4,008,800  $         14,000  $   1,514,000  $   3,014,000  $   4,514,000  $   6,014,000

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Entertainment & Gaming
Avoid plagiarism.
Customer 452441, April 12th, 2022
I'm beyond grateful for this paper to be completed on time. I recently had a major surgery on my chest and sternum and was in so much pain and didn't want to fail from one paper. The work is awesome!!!! Very knowledgeable and informative, just excellent.
Customer 454165, March 17th, 2020
Well-written and well-researched content. Followed the instructions to the letter. Good job mate!!
Customer 463679, April 27th, 2023
Excellent work.
Customer 463001, June 12th, 2022
Awesome! Thanks
Customer 454007, June 19th, 2020
The writer did a phenomenal job with the Research Report #1: Data Breach Incident Analysis & Report. All expectations were met and exceeded! Thank you for delivering an amazing product and a HUGE thank you to the customer service department for sending me an email to let me know the paper was checked to quality assurance team to ensure the paper was within standards of the instructions.
Customer 452455, February 3rd, 2023
excellent paper
Customer 456821, January 14th, 2023
Good response.
Customer 454463, May 5th, 2022
Always proofread before submitting to eliminate minor errors.
Customer 462495, April 3rd, 2022
I am pleased with my paper. The support team helping me to receive this finally was phenomenal. Thank you
Customer 453993, February 10th, 2020
Excellent job
Customer 456821, June 30th, 2022
Good job.
Customer 459155, May 31st, 2022
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat