What amount will the seller receive at the closing?

For this question, prorate using the actual number of days in the month and year. Split the escrow fee 50-50. The seller will pay the revenue stamps, and the buyer will pay title insurance and the recording fee. The buyer assumes the existing mortgage balance of $127,042.42, the buyer will pay in cash at closing the difference between the purchase price and the loan balance, and the present rnonthly payment on the loan is $1,001.40. Closing is October 15.

Use these relevant facts: • Purchase price: $350,000 • Earnest money: $3,500 • Commission rate: 60% split 50-50 • Real estate taxes: $2,900 (paid in full for the current year Jan. 1 through Dec. 31) • Escrow fee: $800 • Title insurance: $1,150 • Insurance policy: $758 (annual premium) • Revenue stamps: $126.30 • Recording fee: $30 • Interest rate: 3.75% (paid in arrears , with the next payment due Nov.1)

The correct answer is: $201,847.28

1. a) You’re a marketing analyst for Hasbro Toys. You get the following data:

   Compute and interpret the sample correlation coefficient between advertising expenditure and sales revenue.

b) An experiment results in one of the following sample points: E₁, E₂, E₃, E₄, or E₅.

    Find P(E₃) if P(E₁) = 2P(E₃), P(E₂₎= 0.1, P(E₄) =0 .2 and P(E₅) = 0.1

c) For each of the random variables defined below, what values may each of the random variables X assume?

(i) (1 point) X=the number of newspapers sold by the New York Times each month

(ii) (1 point) X= amount of ink used in printing the Sunday edition of the New York Times.

A machine purchased 3 years ago for $140,000 is now too slow to satisfy the demand of the customers. It can be upgraded now for $77,000 or sold to a smaller company internationally for $38,000. The upgraded machine will have an annual operating cost of $93,000 per year and a $28,000 salvage value in 3 years. If upgraded, the presently owned machine will be retained for only 3 more years, then replaced with a machine to be used in the manufacture of several other product lines. The replacement machine, which will serve the company now and for a maximum of 8 years, costs $208,000. Its salvage value will be $42,000 for years 1 through 5; $20,000 after 6 years; and $10,000 thereafter. It will have an estimated operating cost of $45,000 per year. Perform an economic analysis at 9% per year using a specified 3-year planning horizon.

a) Determine if the current machine should be replaced now or 3 years from now.

b) Once decided, determine the equivalent AW for the next three years.

a) The current machine should be replaced  (Click to select)  

A. now .
B. three years from now  .

b) The equivalent AW for the next three years is $ -------------

4. A Mediterranean restaurant chain with more than 25 restaurants in Southern California is trying to expand its operations. After reading the information presented in this module and other sources, write a two-page paper that outlines a mobile marketing program for this company. What are three mobile marketing strategies that you recommend for this company? What are the bases of your recommendations for reaching out to the largest number of potential customers with a moderate cost?
5. Multichannel, cross-channel, and omnichannel are being increasingly used by all types of businesses. After reading the information presented in this module and other sources, write a two-page paper that compares and contrasts these three strategies. Provide one advantage and one disadvantage of strategy. Also provide examples of three companies that are using each strategy. Why is omnichannel being adopted by a growing number of companies? Discuss.
6. The “hypersocial” model is gaining popularity. After reading the information in this module and other sources, write a two-page paper that lists four organizations that you consider to be hypersocial. What are the bases of your classification? What are two factors that make an organization hypersocial? What are two advantages of a hypersocial organization compared to a traditional model?

Floyd’s Bumpers has distribution centers in Lafayette, Indiana; Charlotte, North Carolina; Los Angeles, California; Dallas, Texas; and Pittsburgh, Pennsylvania. Each distribution center carries all products sold. Floyd’s customers are auto repair shops and larger auto parts retail stores. You are asked to perform an analysis of the customer assignments to determine which of Floyd’s customers should be assigned to each distribution center. The rule for assigning customers to distribution centers is simple: A customer should be assigned to the closest center. The worksheet Floyds in the provided datafile contains the distance from each of Floyd’s 1,029 customers to each of the five distribution centers. Your task is to build a list that tells which distribution center should serve each customer. The following functions will be helpful: =MIN(array). The MIN function returns the smallest value in a set of numbers. For example, if the range A1:A3 contains the values 6, 25, and 38, then the formula =MIN(A1:A3) returns the number 6, because it is the smallest of the three numbers: =MATCH(lookup_value, lookup_array, match type). The MATCH function searches for a specified item in a range of cells and returns the relative position of that item in the range. The lookup_value is the value to match, the lookup_array is the range of search, and match type indicates the type of match (use 0 for an exact match). For example, if the range A1:A3 contains the values 6, 25, and 38, then the formula =MATCH(25,A1:A3,0) returns the number 2, because 25 is the second item in the range. =INDEX(array, column_num). The INDEX function returns the value of an element in a position of an array. For example, if the range A1:A3 contains the values 6, 25, and 38, then the formula =INDEX(A1:A3, 2) 5 25, because 25 is the value in the second position of the array A1:A3. (Hint: Create three new columns. In the first column, use the MIN function to calculate the minimum distance for the customer in that row. In the second column use the MATCH function to find the position of the minimum distance. In the third column, use the position in the previous column with the INDEX function referencing the row of distribution center names to find the name of the distribution center that should service that customer.) Click on the datafile logo to reference the data. datafile.png (Hint: The INDEX function may be used with a two-dimensional array: =INDEX(array, row_num, column_num), where array is a matrix, row_num is the row numbers and column_num is the column position of the desired element of the matrix.) Floyd's Bumpers pays a transportation company to ship its product to its customers. Floyd's Bumpers ships full truckloads to its customers. Therefore, the cost for shipping is a function of the distance traveled and a fuel surcharge (also on a per mile basis). The cost per mile is $2.42 and the fuel surcharge is $.56 per mile. The worksheet May in the provided datafile contains data for shipments for the month of May (each record is simply the customer zip code for a given truckload shipment), as well as the distance table from the distribution centers to each customer. Use the VLOOKUP function to retrieve the distance traveled for each shipment from the exercise completed above, and calculate the \charge for each shipment. What is the total amount that Floyd's Bumpers spends on these May shipments? If required, round your answers to two decimal places.

Floyd’s Bumpers has distribution centers in Lafayette, Indiana; Charlotte, North Carolina; Los Angeles, California; Dallas, Texas; and Pittsburgh, Pennsylvania. Each distribution center carries all products sold. Floyd’s customers are auto repair shops and larger auto parts retail stores. You are asked to perform an analysis of the customer assignments to determine which of Floyd’s customers should be assigned to each distribution center. The rule for assigning customers to distribution centers is simple: A customer should be assigned to the closest center. The worksheet Floyds in the provided datafile contains the distance from each of Floyd’s 1,029 customers to each of the five distribution centers. Your task is to build a list that tells which distribution center should serve each customer. The following functions will be helpful:

=MIN(array).

The MIN function returns the smallest value in a set of numbers. For example, if the range A1:A3 contains the values 6, 25, and 38, then the formula =MIN(A1:A3) returns the number 6, because it is the smallest of the three numbers:

=MATCH(lookup_value, lookup_array, match type).

The MATCH function searches for a specified item in a range of cells and returns the relative position of that item in the range. The lookup_value is the value to match, the lookup_array is the range of search, and match type indicates the type of match (use 0 for an exact match).

For example, if the range A1:A3 contains the values 6, 25, and 38, then the formula =MATCH(25,A1:A3,0) returns the number 2, because 25 is the second item in the range.

=INDEX(array, column_num).

The INDEX function returns the value of an element in a position of an array. For example, if the range A1:A3 contains the values 6, 25, and 38, then the formula =INDEX(A1:A3, 2) 5 25, because 25 is the value in the second position of the array A1:A3. (Hint: Create three new columns. In the first column, use the MIN function to calculate the minimum distance for the customer in that row. In the second column use the MATCH function to find the position of the minimum distance. In the third column, use the position in the previous column with the INDEX function referencing the row of distribution center names to find the name of the distribution center that should service that customer.)

(Hint: The INDEX function may be used with a two-dimensional array: =INDEX(array, row_num, column_num), where array is a matrix, row_num is the row numbers and column_num is the column position of the desired element of the matrix.)

Floyd's Bumpers pays a transportation company to ship its product to its customers. Floyd's Bumpers ships full truckloads to its customers. Therefore, the cost for shipping is a function of the distance traveled and a fuel surcharge (also on a per mile basis). The cost per mile is $2.64 and the fuel surcharge is $.56 per mile. The worksheet May in the provided datafile contains data for shipments for the month of May (each record is simply the customer zip code for a given truckload shipment), as well as the distance table from the distribution centers to each customer. Use the VLOOKUP function to retrieve the distance traveled for each shipment from the exercise completed above, and calculate the charge for each shipment. What is the total amount that Floyd's Bumpers spends on these May shipments?

If required, round your answers to two decimal places.

$

Here is the link to the data file

https://1drv.ms/x/s!ApMP2LeBUrTssVvBH4KCoBWINZcw

*Do not round any answer until your final answer. Round your final answer to the nearest whole dollar. When entering your final answer, do not use commas or $ sign. (Sorry...Canvas is very sensitive and will mark your answer incorrect due to rounding and punctuation.) Due to possible rounding differences, all answer solutions are programmed as acceptable that are +/- 1. For example, if the correct answer is $54,372, all possible answer solutions that would be accepted would be 54,371, 54372, and 54,373.

On January 1, 20x1, ABC rendered services to Smith Corporation and accepted a $200,000, 5 year note. In exchange, Smith agreed to make quarterly payments of P&I at the end of each Mar, Jun, Sept and Dec, with the first payment to be made on March 31, 20x1. An interest rate of 8% is imputed.  

Required: Use the information above to answer the next (4) questions:

This case study concerns a bank's efforts to calculate credit risk scores (These are opposite of credit scores. Higher the value the riskier the customer) A loan officer at a bank needs to be able to identify characteristics that are indicative of people who are likely to default on loans and use those characteristics to identify good and bad credit risks. The loan officer also needs to be able to better quantify an individual’s credit risk level.

Information on 700 past customers is given in the file along with data for the following variables:

Age: customer age in years.

Employment: years that the customer has been with his/her current employer

Address: years that the customer has lived at his/her current address

Income: household annual income (in $1,000)

Debt _to _Income: debt to income ratio (x100)

Risk _Score: Credit risk score (the higher the score, the more risky)

Default _Indicator: an indicator of whether the customer had previously defaulted

Test the hypothesis that the average credit risk score of customers who have previously defaulted on their loans is higher than those who haven’t defaulted on their loans. (Divide the credit risk score into two groups those who previously defaulted and those who didn’t and then compare the two groups.)

You would like to build a regression model to predict the credit risk score based on all the other variables. What is the regression equation?

What is the predicted credit risk score of a customer aged 40, who has been with their employer for 10 years, has lived at the same address for 3 years, has an income of $200,000, debt to income ratio of 2.5 and has previously defaulted on a loan. Will the prediction be accurate? Explain

Compute the coefficient of determination (R2) and fully interpret its meaning.

Interpret the meaning of the coefficients of the independent variables income and address.

Which independent variables significant? Defend your answer.

Case Study: Marketing and Customer Service

Read the following case study to answer the questions provided below.

North Hampton Clothiers

North Hampton Clothiers, a national nature and recreation clothing brand based in New England, has a commitment to providing its customers with what the company’s Vice President of Marketing and Customer Relations calls a “kitchen sink warranty program”, meaning the company will do whatever it needs to right a customer’s problem with one of their products.

The company proudly embraces their policy, eliciting customers’ stories, which are regularly featured on their website. Stories from customers include sweaters burned by melting s’mores, backpacks clawed by bears, and boots struck by lightning; and North Hampton replaced or refunded each item, every time.

Its an expensive policy, for sure. The Vice President acknowledges that some customers abuse the policy, trading barely used items for the newest style or making a profit by returning for a full-price refund items purchased second-hand. A design defect in a product could trigger mass returns of an item. In fact, some of North Hampton’s competitors used to offer the same guarantee, but many have since returned to more traditional return policies just to limit their financial liability.

Still, New Hampton Clothiers stands by their policy with pride. They see their return policy as a sort of mascot for their customer service approach. “We love and trust our customers,” says the Vice President of Marketing and Customer Relations, “and we want them to know it! We want them to trust us, too, and that means doing whatever we can to show them that, if they have a problem, we will make it right. No matter what.”

Their approach seems to be paying off. North Hampton has topped lists across various business and industry publications when it comes to customer service rating, employee satisfaction, and brand perception. Committed customers can be found in every corner of social media singing the company’s praises and promoting their products.

Utilizing your own words, answer the following questions in detail:

• What role does North Hampton’s return policy fit into the company’s marketing mix; to which of the “four P’s” does it most closely align, and what effect does the policy have of the other elements of the marketing mix?
• In what ways does the company’s return policy influence the relationship between customers and the company’s customer service representatives?
• What characteristics and abilities should North Hampton’s customer service representative possess or be granted to ensure the return policy is exercised smoothly?
• What other considerations to policies and operations (e.g. staffing, financial, product development, etc.) should North Hampton make to support their return policy?