Question: please help quick i have a time limit started working on it let me know if im correct 5. 16 points) A local moving company
please help quick i have a time limit
started working on it let me know if im correct
5. 16 points) A local moving company has collected data on the number of moves they have been asked to perform over the past two years. Moving is highly seasonal, so the owner operator decides to apply the multiplicative seasonal method to forecast the number of moves for the coming year. The owner estimates the total number of moves for year 3 is 180. What is his forecast for quarter 4 in year 3? Show your detailed calculations in the space below. (All numbers round to 2 decimal places) Year 2 Quarter Quarter Year! Demand 13 40 45 30 2 1 4 Demand 20 15 50 10 18 points) A firm must decide whether to construct a small, medium, or large stamping plant. A consultants report indicates the demand could be either low or high with a 20 probability that demand will be low. If the firm builds a small facility and demand turns out to be low, the profit will he $42 million. If demand turns out to be high, the firm can either subcontract and realize the profit of S50 million or expand greatly for a profit of $48 million. The firm could build a medium-si facility as a hedge: If demand turns out to be low, medium plant will result in a profit of 522 million in demand turns out to be high, the firm could do nothing and realize a profit of $46 million, or it could outsource and realize a profit of $55 million. If the firm builds a large facility and demand is low, the payoll will be a loss of $20 million, whereas high demand will result in a profit of $72 million 4. Draw decision tree in the space below. b. Solve the decision tree: Label each decision node and event node with the expected Please clearly indicate your choice at each decision node. 4. Spoints) A textbook publisher for books used in business schools is trying to forecast the number of sales calls made by their sales force. A sampling of the number of stes calls made and the number of books sold from past month is shown in the following table. NUMBER OF SALES NUMBER OF BOOKS CALIS MADE SOLD 20 15 250 600 15 34 40 25 22 550 650 420 400 a. 3 points] Using Excel, calculate a regression line for the data, complete the table below. All numbers round to 3 decimal places) Y-intercep, a 15.209 slope, 16.755 The sample correlation coefficient, The standard error of the estimate. Sx 22.505 b. [1 point) Use the information provided in the table above. For every sale call increase, the number of books sold increases by 16.755 c. (2 point) Use the information provided in the table above. If a sales representative makes 59 sales calls, what is the number of book sales the publisher should expect? 15.209 + 16,755/55) = $ 1936.734) d. (2 points] Use the information provided in the table above. In order to realize the sale of books, how many sales calls will the sales representative have to make? 15.209 + 16.755x = 700 15.009 - 15.209 16.155x = % - 16.155 168479 x =
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
