The business analyst for Video Sales, Inc. wants to forecast this year's demand for DVD decoders...

The business analyst for Video Sales, Inc. wants to forecast this year's demand for DVD decoders based on the following historical data:

Year	Demand
5 years ago	900
4 years ago	700
3 years ago	600
2 years ago	500
Last year	300

What is the forecast for this year using the naive approach?

What is the forecast for this year using a three-year weighted moving average with weights of .5, .3, and .2?

What is the forecast for this year using exponential smoothing with alpha = .4, if the forecast for two years ago was 750?

What is the forecast for this year using the least squares trend line for these data?

What is the forecast for this year using trend-adjusted (double) smoothing with alpha = .3 and beta = .2, if the forecast for last year was 310, the forecast for two years ago was 430, and the trend estimate for last year's forecast was -150?

The chair of the operations management department at Quality University wants to construct a p-chart for determining whether the four faculty teaching the basic POM course are under control with regard to the number of students who fail the course. Accordingly, he sampled 100 final grades from last year for each instructor, with the following results:

Instructor	Number of Failures
Prof. A	13
Prof. B	0
Prof. C	11
Prof. D	16

What is the sample proportion of failures (p) for Prof. D? What is the estimate of the mean proportion of failures for these instructors?

What is the estimate of the standard deviation of the sampling distribution for an instructor's sample proportion of failures?

What are the .95 (5 percent risk of Type I error) upper and lower control limits for the p-chart?

Using .95 control limits (5 percent risk of Type I error), which instructor(s), if any, should he conclude is (are) out of control?

Solutions

Expert Solution

Amanda K answered 2 years ago

Next > < Previous

Related Solutions

The business analyst for Video Sales, Inc. wants to forecast yearly demand for DVD decoders based...

The business analyst for Video Sales, Inc. wants to forecast yearly demand for DVD decoders based on the following historical data:YearDemand5 years ago9004 years ago7003 years ago6002 years ago500Last year300What is the forecast for this year using a three-year simple moving average? What is the forecast for last year using simple exponential smoothing with smoothing constant alpha = 0.4, if the forecast for two years ago was 750? What is the forecast for this year using simple exponential smoothing with smoothing constant...

1) A business analyst wants to know if there is a correlation in a sales person’s...

1) A business analyst wants to know if there is a correlation in a sales person’s intelligence and the average weekly sales. The Excel spreadsheet list the data for a random selection of 15 sales persons. The intelligence is measured by an inventory each employee takes. a)Create the scatterplot on your Excel Spreadsheet. Does it appear to be a positive linear correlation? Why or why not? b)Fill out the necessary cells in the spreadsheet to calculate the correlation coefficient ?....

Sales forecast based on external data. Raspberry Phones uses external data to forecast the coming year's...

Sales forecast based on external data. Raspberry Phones uses external data to forecast the coming year's sales. The company has 7.5 % of all new-phone sales in the United States and 5.6 % of all replacement-phone sales. Industry forecasts predict 18.9 million new-phone buyers and 31.8 million replacement-phone buyers in 2014. If the average Raspberry phone costs $84.05, what sales revenues is the company forecasting for 2014?

Exhibit 1: Sales and Cost Forecast The sales forecast is based on projected levels of demand....

Exhibit 1: Sales and Cost Forecast The sales forecast is based on projected levels of demand. All the numbers are expressed in today’s dollars. The forecasted average inflation per year is 3.0% . Price per bus $220,000 Units sold per year 11,000 Labor cost per bus $50,000 Components & Parts per bus $95,000 Selling General & Administrative (fixed) $250,000,000 NOTE: Average warranty cost per year per bus for the first five years is $1,000. The present value of this cost...

Exhibit 1: Sales and Cost Forecast The sales forecast is based on projected levels of demand....

Exhibit 1: Sales and Cost Forecast The sales forecast is based on projected levels of demand. All the numbers are expressed in today’s dollars. The forecasted average inflation per year is 3.0% Price per bus $220,000 Units sold per year 11,000 Labor cost per bus $50,000 Components & Parts per bus $95,000 Selling General & Administrative (fixed) $250,000,000 NOTE: Average warranty cost per year per bus for the first five years is $1,000. The present value of this cost will...

Cavalier's Journals has forecast next year's demand to be 41,000. The journals are considered to incur...

Cavalier's Journals has forecast next year's demand to be 41,000. The journals are considered to incur annual fixed costs of $26,000 and per-unit variable costs of 35 cents. a. If journals can be sold for $1 each, what is the break-even quantity?. (Round your answer to the next whole number.) QBEP units b. If we assume that the forecast is correct, what should be the per-unit price of journals, if the company seeks to earn an annual profit of...

Business Decision Case The sales department of Donovan Manufacturing, Inc. has completed the following sales forecast...

Business Decision Case The sales department of Donovan Manufacturing, Inc. has completed the following sales forecast for the months of January through March 20X1 for its only two products: 50,000 units of J to be sold at $90 each and 30,000 units of K to be sold at $70 each. The desired unit inventories at March 31, 20X1, are 10% of the next quarter’s unit sales forecast, which are 60,000 units of J and 30,000 units of K. The January...

A sales analyst wants to determine whether there is difference in the mean monthly sales (in...

A sales analyst wants to determine whether there is difference in the mean monthly sales (in RM) of cosmetic company of six sales region in Johor. Several salespersons from each region are chosen and their monthly sales were recorded in Table Q2. Monthly sale (RM) Company A Company B Company C Company D Company E Company F 4250 3930 3960 4350 4150 3970 3980 4010 4020 4450 3890 4160 4020 4050 4130 3880 4568 4370 4130 4220 4350 4574 4480...

As an airline financial analyst, your forecast of 2015 for DirectJet is as follows: Sales: $200...

As an airline financial analyst, your forecast of 2015 for DirectJet is as follows: Sales: $200 million Cost of goods sold: $100 million You plan to use the following information to forecast next year’s balance sheet: Inventory turnover = 5 Current ratio = 2 Asset turnover = 0.50 Debt ratio = 40% Cash = $70 million Accounts receivable turnover = 20 a. Forecast total assets. b. Estimate the current assets. c. Estimate the current liabilities. d. Forecast the total shareholder...

Zeebadee Inc. wants to forecast free cash flow to equity (FCFE) using the percent-of-sales method. Prior...

Zeebadee Inc. wants to forecast free cash flow to equity (FCFE) using the percent-of-sales method. Prior year sales were $10,000. Year 1 Year 2 Year 3 Year 4 Year 5 Sales growth 8.00% 14.00% 12.00% 10.00% 6.00% Profit margin 8.00% 10.00% 12.00% 12.00% 11.00% Net FCInv (% of Sales) 8.00% 8.00% 8.00% 6.00% 3.00% WCInv (% of Sales) 3.00% 3.00% 3.00% 2.00% 1.00% DR 30.00% 30.00% 30.00% 30.00% 30.00% What is net borrowing in Year 4? $364.04 $386.66 $406.30 $455.05...

Subjects