The file S12_79.xlsx contains data on mass layoff events in all industries in the U.S. There are two versions of the data: non-seasonally adjusted and seasonally adjusted. Presumably, seasonal factors can be found by dividing the non-seasonally adjusted values by the seasonally adjusted values. For example, the seasonal factor for April 1995 is 1431/1492 = 0.959. How well can you replicate these seasonal factors with appropriate StatTools analyses?
Answer to relevant QuestionsThe Eastland Plaza Branch of the Indiana University Credit Union was having trouble getting the correct staffing levels to match customer arrival patterns. On some days, the number of tellers was too high relative to the ...Again continuing problem 2, suppose that you want to force the optimal solution to be integers. Do this in Solver by adding a new constraint. Select the changing cells for the left side of the constraint, and in the middle ...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 ...Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Don’t forget to modify range names. Then modify the model again so that there ...During the next four months, a customer requires, respectively, 500, 650, 1000, and 700 units of a commodity, and no backlogging is allowed (that is, the customer’s requirements must be met on time). Production costs are ...
Post your question