Solve the following problem using an excel spreadsheer. A tobacco company is interested in hiring a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Solve the following problem using an excel spreadsheer. A tobacco company is interested in hiring a salesperson to promote smoking cigarettes in nightclubs. The position pays a flat salary of $50,000, regardless of sales levels. The firm has two applicants, Predictable Patty and Risky Ricky. Predictable Patty can produce with 100% certainty $100,000 a year in sales. Risky Ricky, on the other hand, can produce $300,000 with probability of 50%. But if he turns out to spend his time drinking and dancing in the nightclubs instead of making sales, he could actually cost the firm - $100,000 per year. a) During their first year on the job, what are the expected sales of Patty and Ricky? What are the firm's expected profits on each worker? b) Now assume both workers are currently 25, and they will work until the retirement age of 65. The firm has the option to fire its new employee after one year based on sales, but can only hire one employee. Assume that it takes only one year to discover whether Ricky is productive or not, and that he will remain that way for his lifetime. The firm's discount rate for future profits is fixed at 10 percent over the life of both workers. Which employee should it hire? e) Now relax the assumption that each employee will stay with certainty until he or she reaches age 65. Assume, instead, that each year the chances that a worker will leave the firm, given he/she has not left to date, are 20 percent (i.e. the firm's expected turnover rate for these sales positions is 20 percent per year). Which employee should it hire now? d) Use your spreadsheet program to increase the firm's discount rate higher and higher above 10 percent. What happens to its expected present value of profits for each worker? Do the same for the turnover rate. What happens in each case to the firm's decision regarding which of the two workers to hire? Why? Solve the following problem using an excel spreadsheer. A tobacco company is interested in hiring a salesperson to promote smoking cigarettes in nightclubs. The position pays a flat salary of $50,000, regardless of sales levels. The firm has two applicants, Predictable Patty and Risky Ricky. Predictable Patty can produce with 100% certainty $100,000 a year in sales. Risky Ricky, on the other hand, can produce $300,000 with probability of 50%. But if he turns out to spend his time drinking and dancing in the nightclubs instead of making sales, he could actually cost the firm - $100,000 per year. a) During their first year on the job, what are the expected sales of Patty and Ricky? What are the firm's expected profits on each worker? b) Now assume both workers are currently 25, and they will work until the retirement age of 65. The firm has the option to fire its new employee after one year based on sales, but can only hire one employee. Assume that it takes only one year to discover whether Ricky is productive or not, and that he will remain that way for his lifetime. The firm's discount rate for future profits is fixed at 10 percent over the life of both workers. Which employee should it hire? e) Now relax the assumption that each employee will stay with certainty until he or she reaches age 65. Assume, instead, that each year the chances that a worker will leave the firm, given he/she has not left to date, are 20 percent (i.e. the firm's expected turnover rate for these sales positions is 20 percent per year). Which employee should it hire now? d) Use your spreadsheet program to increase the firm's discount rate higher and higher above 10 percent. What happens to its expected present value of profits for each worker? Do the same for the turnover rate. What happens in each case to the firm's decision regarding which of the two workers to hire? Why?
Expert Answer:
Answer rating: 100% (QA)
aExpected sales for Predictable Patty 100000 Expected sales for Risky Ricky 150000 Firms expected profits on Predictable Patty 50000 Firms expected pr... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Solve the following problem using Cramer's rule:- 3x - 4y= 10; 4x + 3y= 5
-
A mail-order company is interested in whether or not order rates (the percent of catalogs mailed that result in an order) vary from one region of the country to another. Table 17.4.5 gives recent...
-
A taxi company is interested in the relationship between mileage, measured in miles per gallon, and the age of cars in its fleet. The 12 fleet cars are the same make and size and are in good...
-
A corporate entity has both preferred and common classes of shares. How is the book value of common shares calculated in this case? What is meant by the liquidation value of preferred shares?
-
Calculating the Average Collection Period. Pujols Lumber Yard has a current accounts receivable balance of $438,516. Credit sales for the year just ended were $6,257,380. What is the receivables...
-
On June 30, 2012, Imperial Inc. purchased $500,000 of Acme Corp. 5% bonds at a price to yield a market interest rate of 6%. The bonds pay interest semi-annually on June 30 and December 31, and mature...
-
For each of the following residual plots, determine whether the assumptions of the linear model are satisfied. If they are not, specify which assumptions are violated. b. C. d.
-
Frankel Inc. experienced the following transactions for 2013, its first year of operations: 1. Issued common stock for $60,000 cash. 2. Purchased $210,000 of merchandise on account. 3. Sold...
-
The Maybe Pay Life Insurance Co. is trying to sell you an investment policy that will pay you and your an amount per year forever. If the required return on this investment is 5.8 percent, how much...
-
Elwood is a pig farmer who is known to enjoy a drink or two. One day in July, after a weekend of particularly heavy drinking, he staggered into the office of Pork Bellies of America and offered to...
-
Ignatius college has provided the following data for use in Service department cost allocations:- Budgeted Department cost Student credit hours Space occupied sqm Service Departments Admin $2,070,000...
-
The new business dynamics of the printing and graphics industry is bringing more pressure on the printing machines manufacturers, for sure. Would you agree with the statement that says: "The change...
-
The court is expected to rule in late December 2022. There is no indication that the claimant will settle out of court. A 6% risk adjustment factor to the probability-weighted expected cash flows is...
-
Prepare a CVP income statement that shows both total and per unit amounts. CRANE NEWS MANUFACTURING, INC. CVP Income Statement For the Month Ended September 30, 2022 Total (b) Sales Variable costs...
-
Is the expression 15x - x6 + x8 a polynomial in x? If this expression is not a polynomial in x, what rules it out?
-
Let's explore and quantify the economic impacts of the collective bargaining agreement using a resource from the Stillman Exchange at...
-
Which one is NOT correct about Map collection? TreeMap is faster than HashMap TreeMap guarantees the order of iteration A Map is an object that maps keys to values In Java, the Map interface and has...
-
A copper sphere of 10-mm diameter, initially at a prescribed elevated temperature T;, is quenched in a saturated (1 atm) water bath. Using the lumped capacitance method, estimate the time for the...
-
Five items are to be loaded in a vessel. The weight Wi, volume Vi, and value ri for item I are tabulated below. The maximum allowable cargo weight and volume are 112 tons and 109 yd3, respectively....
-
Consider the following LP: Maximize z = x1 + 5x2 + 3x3 Subject to X1 + 2x2 + x3 = 3 2x1 - x2 = 4 X1, x2, x3 0
-
An assembly line consisting of three consecutive workstations produces two radio models: DiGi-l and DiGi-2. The following table provides the assembly times for the three workstations. The daily...
-
In order to have a correlation coefficient between traits A and B, it is necessary to have: a. one group of subjects, some of whom possess characteristics of trait A, the remainder possessing those...
-
What would you guess the value of the correlation coefficient to be for the pair of variables: "number of man-hours worked" and "number of units of work completed"? a. Approximately 0.9 b....
-
True or False: Whenever r is calculated on the basis of a sample, the value which we obtain for r is only an estimate of the true correlation coefficient which we would obtain if we calculated it for...
Study smarter with the SolutionInn App