ACCT 556 RANK Great Stories Here/acct556rank.com ACCT 556 RANK Great Stories Here/acct556rank.com | Page 3

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
Labor rate $30 per hour
Machine hours 3 machine hours per unit