Prime Service is a large service company that provides maintenance and repair services for close to 1,200 commercial businesses in New York, New Jersey, and Connecticut.

Assignment Instructions

For this week’s assignment, you will propose (or illustrate) a database solution enabling service representatives to identify the most important customers so that they could receive priority service. You will use an APA-formatted, illustrative essay to share your proposal.

Scenario: Prime Service is a large service company that provides maintenance and repair services for close to 1,200 commercial businesses in New York, New Jersey, and Connecticut. Its customers include businesses of all sizes. Customers with service needs call into its customer service department with requests for repairing heating ducts, broken windows, leaky roofs, broken water pipes, and other problems. The company assigns each request a number and writes down the service request number, the identification number of the customer account, the date of the request, the type of equipment requiring repair, and a brief description of the problem. The service requests are handled on a first-come-first-served basis. After the service work has been completed, Prime calculates the cost of the work, enters the price on the service request form, and bills the client. This arrangement treats the most important and profitable clients—those with accounts of more than $70,000—no differently from its clients with small accounts. Management would like to find a way to provide its best customers with better service. It would also like to know which types of service problems occur most frequently so that it can make sure it has adequate resources to address them.

Goal: Prime Service has a small database with client account information—including identifiers, account numbers, previous transactions, and the name of service representatives. Create and illustrate a database solution that would enable Prime’s customer service representatives to identify the most important customers so that they could receive priority service.

As your solution requires a UML diagram, read the following sources to create it. Ensure to include these sources in your essay’s appendix.

  • Easy Guide to UML Class Diagrams
  • UML Class Diagram Relationships

In your paper, be sure to utilize the textbook and integrate at least five peer-reviewed sources along with their citations and references. Your paper must be APA formatted and include at least 1250 words. The cover page and references are not included in the number of words.

1250 words, delivery date and time is 3rd September 10 am.

find the cost of your paper

Strategic Management Project

Assignment Content Review the Strategic Management Project Background and your strategic management research journal entries from Weeks 1–4. Create a 10-slide presentation for Caterpillar Inc. leadership in which you summarize your key findings, propose….

Case Problem Investment Strategy

Case Problem Investment Strategy J. D. Williams, Inc. is an investment advisory firm that manages more than $120 million in funds for its numerous clients. The company uses an asset allocation model that recommends the portion of each client’s portfolio to be invested in a growth stock fund, an income fund and a money market fund. To maintain diversity in each client’s portfolio, the firm places limits on the percentage of each portfolio that may be invested in each of the three funds. General guidelines indicate that the amount invested in the growth fund must be between 20% to 40% of the total portfolio value. Similar percentages for the other two funds stipulate that between 20% to 50% of the total portfolio must be in the income fund and at least 30% of the total portfolio value must be in the money market fund.   In addition, the company attempts to assess the risk tolerance of each client and adjust the portfolio to meet the needs of the individual investor. For example, Williams just contracted with a new client who has $800,000 to invest. Based on an evaluation of the client’s risk tolerance, Williams assigned a maximum risk index of 0.05 for the client. The firm’s risk indicators show the risk of the growth fund at 0.10, the income fund at 0.07 and the money market fund at 0.01. An overall portfolio risk index is computed as a weighted average of the risk rating for the three funds where the weights are the fraction of the client’s portfolio invested in each of the funds. Additionally, William’s is currently forecasting annual yields of 18% for the growth fund, 12.5% for the income fund and 7.5% fir the money market fund. Based on the information provided, how should the new client be advised to allocate $800,000 among the growth, income and money market funds? Develop a linear programming model that will provide the maximum yield for the portfolio. Use your model to develop a managerial report.   Managerial Report: a.Recommend how much of the $800,000 should be invested in each of the three funds. What is the annual yield you anticipate for the investment recommendation change? b.Assume that the client’s risk index could be increased to 0.055. How much would the yield increase and how would the investment recommendation change? c.Refer again to the original situation where the client’s risk index was assessed to be 0.05. How would your investment recommendation change if the annual yield for the growth fund were revised downward to 16% or even to 14%? d.Assume that the client expressed some concern about having too much money in the growth fund. How would the original recommendation change if the amount invested in the growth fund is not allowed to exceed the amount invested in the income fund? e.The asset allocation model you developed may be useful in modifying the portfolios for all the firm’s clients whenever the anticipated yields for the three funds are periodically revised. What is your recommendation as to whether use of this model is possible?  

Case Analysis

You can view the article (the case), “The Man Who Got Honeywell’s Groove Backt”, by linking to the course EReserves  Follow the Case Analysis Outline given in your syllabus. This is….