Your manager is trying to determine what forecasting method to use. based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. month actual demand 1 62 2 65 3 67 4 68 5 71 6 73 7 76 8 78 9 78 10 80 11 84 12 85 a) calculate the simple three-month moving average forecast for periods 4-12. b) calculate the weighted three-month moving average using weights of 0.5, 0.3, and 0.2 for periods 4-12. c) calculate the mean absolute deviation (mad) for the forecasts made by each technique in periods 4-12. which forecasting method do you prefer?

Fanning company is considering the addition of a new product to its cosmetics line. the company has three distinctly different options: a skin cream, a bath oil, or a hair coloring gel. relevant information and budgeted annual income statements for each of the products follow. skin cream bath oil color gel budgeted sales in units (a) 110,000 190,000 70,000 expected sales price (b) $8 $4 $11 variable costs per unit (c) $2 $2 $7 income statements sales revenue (a × b) $880,000 $760,000 $770,000 variable costs (a × c) (220,000) (380,000) (490,000) contribution margin 660,000 380,000 280,000 fixed costs (432,000) (240,000) (76,000) net income $228,000 $140,000 $204,000 required: (a) determine the margin of safety as a percentage for each product. (b) prepare revised income statements for each product, assuming a 20 percent increase in the budgeted sales volume. (c) for each product, determine the percentage change in net income that results from the 20 percent increase in sales. (d) assuming that management is pessimistic and risk averse, which product should the company add to its cosmetics line? (e) assuming that management is optimistic and risk aggressive, which product should the company add to its cosmetics line?

Amanager of a store that sells and installs spas wants to prepare a forecast for january and june of next year. her forecasts are a combination of trend and seasonality. she uses the following equation to estimate the trend component of monthly demand: ft = 30+5t, where t = 1 in january of this year. seasonal relatives are 0.60 for january and 1.50 for june. what demands should she predict for january and june of next year

Here are the expected cash flows for three projects: cash flows (dollars) project year: 0 1 2 3 4 a − 6,100 + 1,275 + 1,275 + 3,550 0 b − 2,100 0 + 2,100 + 2,550 + 3,550 c − 6,100 + 1,275 + 1,275 + 3,550 + 5,550 a. what is the payback period on each of the projects? b. if you use a cutoff period of 2 years, which projects would you accept?