ACCT 556 RANK Learn by Doing/acct556rank.com ACCT 556 RANK Learn by Doing/acct556rank.com | Page 3

4. Which projection (question 1 or question 3) do you feel is more representative of the Schonlind Company’s historical sales? Why? Please complete the remaining questions using the revised historical data. 5. Predict the sales for 2006 using exponential smoothing. 6. Predict the sales for 2006 using a trend line technique using. (GROWTH function in Excel). 7. Predict the sales for 2006 using a graphing technique. 8. It has been suggested that sales for the company may be connected to disposal income. Using the information below regarding historical disposable income, predict the sale for 2006 using regression analysis if a reliable prediction for disposable income for 2006 is $35,430. 9. Which method do you think provides the most realistic sales projections for 2006? Why? ===================================================================================== ACCT 556 Week 3 Homework Problems FOR MORE CLASSES VISIT www.acct556rank.com ACCT 556 Week 3 Homework Problem Production Budgets The Hale Company finished their sales projections for the coming year. The company produces one product. Part of next year’s sales projections are as follows: Engineering has developed the following standards upon which the production budgets will be developed: Item Standard Materials usage 5 lbs per unit Material price per pound $1.50 per pound Labor usage 0.4 hours per unit