1. Jane White has recorded the following sales figures for last year for her business: January, $35,645; February, $35,456; $35,456; March, $31,270; April, $32,129; May, $34,456; June, $35,256; November, $30,125; December, $32,275.
She wants to select from one of three models: a 3-month moving average, a weighted moving average (she believes that the weights should be 0.2, 0.3, and 0.5) and ,exponential smoothing average in which she uses an of 0.2 and an assumed forecast for January of Year 1 of $35,000.
a. Construct a table that shows each of these forecasts for the current year and provide the forecast for January of year 2.
b. Using the available data and your forecasts, which model do you suggest that lane use for her business?
2. You have just completed the first year of operation for your business and have the following information: sales, $200,000; cost of goods, $140,000; rent, $18,000; utilities, $8,4000; insurance, $2,000; equipment, $3,500; interest, $10,000. Your forecast indicates that your sales will increase by20 percent.
Your rental agreement provides for a 3 percent increase per year. You read an article indicating that utility cost in your area will increase by 10 percent next year.
You Just received a notice from your insurance company stating that your quarterly premium is increasing to $600 beginning the first quarter of next year. Your equipment expense will not change, but the amortization schedule on your current loan indicates that interest expense for next year should be $9,000.
a. Using the data, construct an actual income statement for this year and aprcifaa income statement for next year.
b. By what percentage did your net income change?
c. What are your current profit margin and your pro forma profit margin?
d. In your business, assets and liabilities have historically varied with sales. Assets are usually 80 percent of sales, and liabilities are usually 55 percent of sales.
You anticipate that you will have no owner payout of net profit. Using the percentage of sales method, determine if any additional financing is needed for your business next year.