The file S12_70.xlsx lists annual revenues (in millions of dollars) for Nike. Forecast the company’s revenue in each of the next two years with a linear or exponential trend. Are there any outliers in your predictions for the observed period?
Answer to relevant QuestionsThe file S11_44.xlsx contains data on pork sales. Price is in dollars per hundred pounds sold, quantity sold is in billions of pounds, per capita income is in dollars, U.S. population is in millions, and GDP is in billions ...The Sales2 variable in the file from the previous problem was created from the Sales1 variable by multiplying by monthly seasonal factors. Basically, the summer months are high and the winter months are low. This might ...Continuing the previous problem, perform a sensitivity analysis on the selling price of VXPs. Let this price vary from $500 to $650 in increments of $10, and keep track of the values in the changing cells and the objective ...In the product mix model it makes sense to change the maximum sales constraint to a “minimum sales” constraint, simply by changing the direction of the inequality. Then the input values in row 23 can be considered ...As indicated by the algebraic formulation of the Pigskin model, there is no real need to calculate inventory on hand after production and constrain it to be greater than or equal to demand. An alternative is to calculate ...
Post your question