Question

In: Operations Management

A textbook publisher for books used in business schools believes that the number of books sold...

A textbook publisher for books used in business schools believes that the number of books sold is related to the number of campus visits to decision makers made by their sales force. A sampling of the number of sales calls made and the number of books sold is shown in the following table.

# OF SALES CALLS MADE ----- # OF BOOKS SOLD

25 375

15 250

25 525

45 825

35 550

25 575

25 550

35 575

25 400

15 400

---------------------------------------------------------------------------------------------------------------------------------------

Sales Calls Made Versus Number of Books Sold Summary

Measure Value

Error Measures

Cummulative For. Error = 0

MAD = 72.5

MSE = 5550.986

Standard Error (denom=n=8) = 83.299

MAPE = 0.163

Regression Line

Books Sold = 104,605

+ 14.737 * Sales Calls Made

Statistics

----------------------------------------------------------------------------------------------------------------------------------------

1. What percent in the variation of the variable Books Sold is explained by the value of the variable Sales Calls Made?

A) 86.5%

B) 83.3%

C) 74.8%

D) 72.5%

2. For every sale call made, the number of books sold increases by:

A) 14.74 books.

B) 104.6 books.

C) 83.30 books.

D) 7.25 books.

3. If a sales representative makes 55 sales calls, the number of book sales the publisher should expect is:

A) 105.

B) 4,581.

C) 114.

D) 915.

4. To realize the sale of 700 books, how many sales calls will the sales representative have to make?

A) 40.4

B) 45.9

C) 32.7

D) 37.6

Please provide explantions and/or show your work.

Solutions

Expert Solution

1. R2-value measures the percentage of variation in the values of the dependent variable that can be explained by the variation in the independent variable.

So, percent in the variation of the variable Books Sold is explained by the value of the variable Sales Calls Made will be measured R2

Plot the Sales Calls Made (x) and Number of Books Sold (Y) with trend line as linear

R2 = 0.7483 = 74.83 %

Answer C) 74.8 %

2. For every sale call made, the number of books sold increases is slope of regression line

y = 14.737x+ 104.61

Slope = 14.737 = 14.74

Answer A ) 14.74

3. Sales Calls Made (x) and Number of Books Sold (Y)

x= 55, Putting x = 55 in linear regression equation

y = 14.737x+ 104.61 = 915.145 = 915

Answer D) 915

4.

y = 700

y = 14.737x+ 104.61 = 700

=> x = (700-104.61)/14.737 = 40.40

Answer A) 40.4


Related Solutions

A textbook publisher is in monopolistic competition. This company cannot sell books at a price of...
A textbook publisher is in monopolistic competition. This company cannot sell books at a price of $ 100 pesos per book. But for every decrease of $ 10 pesos that you make to the price, the number of books you sell increases by 20 books a day. The fixed cost of the company is $ 2,400 pesos a day. The average variable cost and the marginal cost of the company is constant at $ 20 pesos per book. If the...
A publisher of books has produced seven comparable Statistical Management books with the following costs. Quantity...
A publisher of books has produced seven comparable Statistical Management books with the following costs. Quantity produced (000) 1 2 4 5 7 9 13 Manufacturing Cost(000£) 5 5.9 6.5 7.5 8 9.5 10.8 a) (5 pts) Construct the regression line for predicting manufacturing costs from quality produced. b) (5 pts) Calculate the predicted values and the residuals of this data. c) (5 pts) Construct a 99% two-sided confidence interval for the intercept. d) (5 pts) Construct a 99% two-sided...
The quarterly sales data (number of copies sold) for a college textbook over the past three...
The quarterly sales data (number of copies sold) for a college textbook over the past three years follow: Year Quarter Sales 1 1 1690 2 940 3 2625 4 2500 2 1 1800 2 900 3 2900 4 2360 3 1 1850 2 1100 3 4 2930 2615 a. Construct a time series plot. What type of pattern exists in the data?   b. Show the four‐quarter and centered moving average values for this time series. c. Compute the seasonal and...
The quarterly sales data (number of copies sold) for a college textbook over the past three...
The quarterly sales data (number of copies sold) for a college textbook over the past three years follow. Quarter Year 1 Year 2 Year 3 1 1690 1800 1850 2 940 900 1100 3 2625 2900 2930 4 2500 2360 2615 a. Construct a time series plot. What type of pattern exists in the data? b. Show the four-quarter and centered moving average values for this time series. c. Compute the seasonal and adjusted seasonal indexes for the four quarters....
The quarterly sales data (number of copies sold) for a college textbook over the past three...
The quarterly sales data (number of copies sold) for a college textbook over the past three years follow. Click on the datafile logo to reference the data. quarter year 1 year 2 year 3   1 1690 1800 1850 2 940 900 1100 3 2625 2900 2930 4 2500    2360    2615 e. Deseasonalize the time series (to 3 decimals). Year Quarter Deseasonalized Value 1 1 2 3 4 2 1 2 3 4 3 1 2 3 4 f....
The quarterly sales (number of books sold) over the past 3 years are as shown below....
The quarterly sales (number of books sold) over the past 3 years are as shown below. Year Quarter Period Sales 1 1 1 1700 1 2 2 1000 1 3 3 2700 1 4 4 2500 2 1 5 1800 2 2 6 900 2 3 7 2900 2 4 8 2400 3 1 9 1800 3 2 10 1100 3 3 11 2900 3 4 12 2600 Construct a time series plot for this data. Paste the time series...
PLEASE POST IN EXCEL WITH SOLUTIONS! You’re a publisher of University Mac Books. A teacher at...
PLEASE POST IN EXCEL WITH SOLUTIONS! You’re a publisher of University Mac Books. A teacher at MSU has written a new Finance text book & has asked your firm to prepare & print the text book. She is willing to commit to purchasing 22,000 text books over four years. You are at full production, so you need to purchase new printing equipment at a cost of $3.6Million which will be depreciated on a straight line basis over the life of...
A publisher of adult coloring books is currently selling 800 pper week at a price of...
A publisher of adult coloring books is currently selling 800 pper week at a price of $25 each. A consultant tells them the own-price elasticity of demand at that price is -4. a. if the consultant is correct, how will sales change if they drop te price by 1%? b. Estimate a linear demand curve for the coloring books c. At what price will the own-price elasticity of demand be -1 d. If P=$25 is profit-maximizing, what is the implied...
A newsletter publisher believes that more than 24% of their readers own a personal computer. Is...
A newsletter publisher believes that more than 24% of their readers own a personal computer. Is there sufficient evidence at the 0.10 level to substantiate the publisher's claim? State the null and alternative hypotheses for the above scenario.
A local tire dealer wants to predict the number of tires sold each month. He believes...
A local tire dealer wants to predict the number of tires sold each month. He believes that the number of tires sold is a linear function of the amount of money invested in advertising. He randomly selects 6 months of data consisting of tire sales (in thousands of tires) and advertising expenditures (in thousands of dollars). Based on the data set with 6 observations, the simple linear regression model yielded the following results. ?X =24 ?X2=124 ?Y  = 42 ?Y2 =338...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT