A New Sales Representative:After 10 years in business, John Shurtman has determined that it is time to hire a sales representative. As the founder and president of United Fleet Service (UFS), John has been the main driver of new business sales for the company. However, as UFS has grown, John has found that he must spend more time on planning and administration, leaving little time to generate new sales leads or call on potential customers. UFS provides maintenance, mechanical repair services, and body repair services to organizations that maintain fleets of large vehicles. UFS customers include mostly school districts that own bus fleets and municipalities that own fleets of fire and police vehicles. While UFS has a strong hold on these public sector organizations, John sees many opportunities for expansion through targeting other potential customers such as utility companies and commercial trucking companies. UFS has several competitors in its geographic area, but none provide as comprehensive a service as UFS. For example, several competitors provide mechanical repair services, but do not provide body repair services; on the other hand, several competitors provide body repair services, but do not provide mechanical repair services. UFS also has a reputation for high-quality repairs and fast turnaround times on service. With these strengths in mind, John is convinced that an effective sales representative that can take the time to contact and develop relationships with potential customers can help lead the organization to expansion. John has experienced steady growth over the past 10 years, acquiring just two or three new customers each year. Leads on potential new customers have come primarily through referrals from current customers. John personally called on the leads to secure sales. Once a target was established as a customer, John handed the customer account over to a service advisor. The service advisor's role is to process incoming vehicles and communicate work progress with customers. Service advisors are also encouraged to generate new sales from current customers by suggesting add-on services or establishing ongoing maintenance schedules. Due to increased volume growth, the service advisors have had little time to develop more significant relationships with customers. Because of this, UFS has missed out on many add-on sales opportunities. Therefore, John plans to hire a new sales representative to both call on new customers and develop better relationships with current customers. Cultivating new customers will require cold-calling on potential customers as well as following up on referrals from current customers. Because most companies that have vehicle fleets establish contractual relationships with mechanical service providers, some new customers may take a long time to acquire. That is, the sales representative may have to interact with a potential new customer over an extended period of time until the company's contract with another service provider expires. Working with current customers will require significant interaction with the service advisors to understand each customer's past history of services and identify opportunities to increase the number and frequency of services provided. Growing business from current customers will also require spending time developing relationships with each customer. Before he begins recruiting for this position, John must determine how to compensate the new sales representative. He's researched market rates for sales representatives in his industry and has a targeted salary range, but he wants to make sure that the compensation plan provides enough incentive to both secure new sales and spend time developing relationships with current customers.(Minimum of 500 words for each question, this excludes the reference section at the bottom from your word count. You are also required to use a minimum of FOUR scholarly external sources references. Use proper APA guidelines, you only have to make reference to the author and year of publication in your in-text reference, but APA guidelines encourage you to also provide the page number. Failure to do so will result in an incomplete with 0 points for the question)1. Identify and describe at least three sales objectives for the new sales representative. (500 word minimum)2. Describe the role the compensation design will play in motivating the new sales representative. (500 word minimum)3. Describe the sales incentive plan you recommend. Explain how the sales incentive plan you are recommending will motivate the new sales representative to meet the sales objectives you identified. (500 word minimum)

Use Excel to answer all of the following questions. Label all output accordingly.3-1. A sample of 20 automobiles was taken, and the miles per gallon, MPG, horsepower, and total weight were recorded. Please see attached excel documentYou may assume X1 = HorsPwr, and X2 = Weight. Or you may define using different variables, but be consistent.(a). Develop a linear regression model to predict MPG, using horsepower as the only independent variable. Develop another model with weight as the independent variable. Which of the two models is better? Why? Make sure you appropriately label all Excel outputs.(b). Using the same data given, develop multiple regression model. How does this compare with each of the models in (a)? Just all the relevant information to support your responses.(c). (i) Use just the multiple regression model you developed in (b) to predict MPG if HrsPwr is set at 150 and Weight is 4400. (ii) Next use the regression models for HrsPwr and Weight separately (independently) for HrsPwr= 150 and Weight= 4400 and predict MPG.(iii). Based on you analyses above c (i & ii), and information gathered from a & b, which forecast do you think would be more accurate/realistic and why?3-2. (a). ABC company records during the past six weeks indicate the number of jobs requests:WEEK123456Requests (Actual)464038424445Required: Predict the number of requests for Week 7 using each of the following methods: iA four-period moving average. ii. Exponential smoothing with a = .40. Forecast for Week 1 was 50. 2. (b). Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months Compute MAD and MSE {sum of squared errors divided by (n-1)} for each forecast. Does either forecast seem superior? Explain.The forecasts and actual sales are as follows:MonthSALES (ACTUAL)FORECAST IFORECAST II17807707782789785790379479079247807847855778770774677276877077657617598775771775978678479110790788788Please use the QM add in when answering questions for each and explain how the answer was computed.