Ransom Global Communications (RGC) Inc., sells communications systems to companies that have worldwide operations. Over the next year, RGC will be instituting important improvements in its manufacturing operations. The CEO and majority stockholder, Thomas Ransom, has been extremely optimistic about the outlook for the firm and made the statement that sales will certainly exceed$6 million in the first half of next year. Semiannual data for RGC over the past 19 years are presented in Table 10.13. The Spending Index is related to the amount of disposable income that consumers have, adjusted for inflation and averaged over the industrial nations. System Price is the average sales price of systems that RGC sells, Capital Investment refers to net capital investment in the business, and Advertising and Marketing and Sales are self explanatory.
a. Use the data in Table 10.13 to run a regression analysis with Sales as the response variable and the other four variables as explanatory variables. Write out the expression for Expected Sales, conditional on the other variables. Interpret the coefficients.
b. The forecast for the Spending Index in the first half of next year is 45.2. The company has committed $145,000 for capital improvements during this time. In order to make his goal of $6 million in sales, Ransom has indicated that the company will offer discounts on systems (to the extent that the average system price could be as low as $70,000) and will spend up to $90,000 on advertising and various marketing programs. If the firm drops the price as much as possible and spends the full $90,000 on Advertising and Marketing, what is the expected value for Sales over the next 6 months? Estimate the probability that Sales will exceed $6 million.
c. Given that the company spends the full $90,000 on Advertising and Marketing, how low would Price have to be in order to ensure a 90% chance that Sales will exceed $6 million? What advice would you give Thomas?
Table 10.13

Transcribed Image Text:

02 72 0 2 0 2 2 4 9 3 8 3 234 97 49- 2547 36 76 2 31852 gs 9836 ,7 76 40 3 2 6 2 6 9 4 2 72 2 2 3 3 2 9 74 6 3 4 9 8 74 87 74 2 2 4 2 5 3 9 85352 46470 .1 8 7 4 8 1 2 9 6 ,5 6 1 2 2 0 1 3 0 4 604646 . 1, 969 887926 82187 2 -274121-2122- 12-41-4600 2 5 4 2 2-4-2 14 1 2078 1 1 8 1 1 3 9 9 4 6 0 9 2 9 9 4 3 7 2 4 1 9 2 2 3161290963 , 1,0 6 9 5 7 9 6 5 6 6 6 6 6 6 6 6 6 6 6 6 7 6 9 3 3 3 74 73 74 74 7 8 77 78 77 8 9 08 .8 9 8 4 4 2 6 3 5 7 6 5 .4 0 1 2 8 3 9 6 5 0 6 2 6 5 2 9 7 8 8 5 2 5 4 1 71 33 26 4 3 3 3 3 2 2 5 3 3 3 3 3 4 3 3 4 4 4 3 3 3 4 4 4 5 3 4 5 4 5 5 4 4 4 893 5444 Y-1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2