Question

In: Accounting

Review chapter 17 in Modern Business Statistics. Read Case Problem 1, Forecasting Food and Beverage Sales,...

  1. Review chapter 17 in Modern Business Statistics.
  2. Read Case Problem 1, Forecasting Food and Beverage Sales, on page 868.
  3. Perform an analysis of the sales data.
  4. Prepare a report that summarizes your findings in five pages maximum, forecasts, and recommendations. Include the following:
    • A time series plot. Comment on the underlying pattern in the time series.
    • Analysis of the seasonality of the data. Indicate seasonal indexes for each month and comment on the high and the low seasonal sales months. Do the seasonal indexes make intuitive sense? Explain.
    • Deseasonalize the time series. Does there appear to be any trend in the deseasonalized time series?
    • Using the time series decomposition method, forecast sales for January through December of the fourth year.
    • Using the dummy variable regression approach, forecast sales for January through December of the fourth year.
    • Provide summary tables of your calculations and any graphs in the appendix of your report.
  5. Submit your assignment for review and feedback.

Solutions

Expert Solution

Your sales forecast is the backbone of your business plan. People measure a business and its growth by sales, and your sales forecast sets the standard for expenses, profits and growth.

When it comes to forecasting sales, don't fall for the trap that says forecasting takes training, mathematics or advanced degrees. Forecasting is mainly educated guessing. So don't expect to get it perfect; just make it reasonable. There's no business owner who isn't qualified to forecast sales--you don't need a business degree or accountant's certification. What you need is common sense, research of the factors, and motivation to make an educated guess.

Your sales forecast in a business plan should show sales by month for the next 12 months--at least--and then by year for the following two to five years. Three years, total, is generally enough for most business plans.

If you have more than one line of sales, show each line of sales separately and add them up. If you have more than 10 or so lines of sales, summarize them and consolidate. Remember, this is business planning, not accounting, so it has to be reasonable, but it doesn't need too much detail. Here are some tips to get you started:

  • Develop a unit sales projection. Where you can, start by forecasting unit sales per month. Not all businesses sell by units, but most do, and it's easier to forecast by breaking things down into their component parts. Product-oriented businesses obviously sell in units, but so do a lot of service businesses. For example, accountants and attorneys sell hours, taxis sell rides, and restaurants sell meals.
  • Use past data if you have it. Whenever you have past sales data, your best forecasting aid is the most recent past. There are some statistical analysis techniques that take past data and project it forward into the future. You can get just about the same results by projecting your two most recent years of sales by month on a line chart and then visually tracking it forward along the same line. Statistical tools are a nice addition, but they're rarely as valuable in a business plan as human common sense, particularly if it's guided by analysis.
  • Use factors for a new product. Having a new product is no excuse for not having a sales forecast. Of course you don't know what's going to happen, but that's no excuse for not drafting a sales projection. Nobody who plans a new product knows the future--you simply make educated guesses. So break it down by finding important decision factors or components of sales. If you have a completely new product with no history, find an existing product to use as a guide. For example, if you have the next great computer game, base your forecast on sales of a similar computer game. If you have a new auto accessory, look at sales of other auto accessories. Analysts projected sales of fax machines before they were released to the market by looking at typewriters and copiers.
  • Break the purchase down into factors.For example, you can forecast sales in a restaurant by looking at a reasonable number of tables occupied at different hours of the day and then multiplying the percent of tables occupied by the average estimated revenue per table. Some people project sales in certain kinds of retail businesses by investigating the average sales per square foot in similar businesses.
  • Be sure to project prices. The next step is prices. You've projected unit sales monthly for 12 months and then annually, so you must also project your prices. Think of this as a simple spreadsheet that adds the units of different sales items in one section, then sets the estimated prices in a second section. A third section then multiplies units times price to calculate sales. The math is simple--the hard part is making that estimated guess of unit sales.
  • A fourth section of your projected prices will set the average costs per unit. You want to set costs because a lot of financial analysis focuses on gross margin, which is sales less cost of sales. For financial reasons, cost of sales, also known as costs of goods sold and direct costs, are different from the other expenses that come out of profits.

    The cost of sales isn't what you pay salespeople or for advertising. It's the amount you pay to buy what you sell. This is usually easy to understand. In any retail store, for example, the cost of goods sold is what the store pays for the products it sells. In service businesses, the costs of sales can be less obvious, but it can still be


Related Solutions

Read and review chapter 31 Analyze the following case study and answer the question bellow CASE...
Read and review chapter 31 Analyze the following case study and answer the question bellow CASE STUDY Mrs. Angstrom is an 83-year-old patient who was admitted to the hospital after she fell outside her home and broke her hip. She has been living alone in her apartment since her husband died 4 years ago. Mrs. Angstrom has no long-term history of mental illness, but she has recently shown signs of cognitive impairment and dementia, according to her neighbor Jeanine Finch,...
Read the Blumberg v. Ambrose case that begins on page 597 of the text (Chapter 17)....
Read the Blumberg v. Ambrose case that begins on page 597 of the text (Chapter 17). answer this question according to Blumberg Ambrose case. Miscommunication is often the basis for litigation - what should the parties have done in this case? How do you define a partnership? What should you do before engaging in a business operation?
1) Below is last month's income statement for Aday’s Taqueria: Sales:    Food Sales $42,500.00    Beverage Sales...
1) Below is last month's income statement for Aday’s Taqueria: Sales:    Food Sales $42,500.00    Beverage Sales $21,500.00 Total Sales $64,000.00 Less Costs Of Sales:    Food Costs $14,450.00    Beverage Costs $3,010.00 Gross Profit $46,540.00 Less Expenses:    Insurance $2,500.00    Rent $3,000.00    Labor $18,000.00    Miscellaneous $1,400.00    Utilities $1,600.00    Advertising $2,400.00    Office Supplies $800.00    Depreciation $2,000.00 $31,700.00 Net Profit $14,840.00 The managers at ACME Factory have decided to classify costs as follows: 1.   All of Insurance, Rent, Advertising and Depreciation as Fixed Costs. 2.   All of...
Can a complete solution to Problem 34E from Chapter 15 of the Business Statistics Communicating with...
Can a complete solution to Problem 34E from Chapter 15 of the Business Statistics Communicating with Numbers Textbook (2nd edition), please be provided? An automotive workers union, in conjunction with top management, is negotiating a new hourly pay policy for union workers based on three variables: (1) job class, (2) years with the company, and (3) years as a union member at any company. The goal is to develop an equitable model that can objectively specify hourly pay, thereby reducing...
Review Question 1. What is sales revenue forecasting? 2. What types of data are needed to...
Review Question 1. What is sales revenue forecasting? 2. What types of data are needed to forecast sales or revenues? 3. What is cost estimation? 4. What is the first step managers need to complete when estimating costs? 20. How does technology affect costs? 22. Identify three environmental factors that affect business decisions related to costs. 25. How does technological innovation generally affect a firm' s costs? 27. What is meant by the learning curve? 28. What are controllable costs?...
Read case 1 of the Tanglewood casebook. Review the thirteen Strategic Staffing decisions, and the material...
Read case 1 of the Tanglewood casebook. Review the thirteen Strategic Staffing decisions, and the material you have read about Tanglewood. Then consider each of the decisions and briefly indicate which way you think Tanglewood should position itself along the continuum and why. For example, the first decision is to develop or acquire talent. Indicate whether you think it is best for Tanglewood to focus more on acquiring talent internally or externally, and why? Repeat this process for each of...
Unit 1 Discussion Forum 2: Transforming Leaders. Read the case at the end of Chapter 1...
Unit 1 Discussion Forum 2: Transforming Leaders. Read the case at the end of Chapter 1 on Transforming Leaders. Respond to the discussion questions at the end of case to frame your post. You don't need to answer every question, but use them to guide your responses in the case analysis. The case is also listed below: Cameryn is the vice president for professional development at a large metropolitan hospital in the Midwest. She has been in her role for...
1. Read the following article excerpt: Sweetened-beverage sales in Seattle dropped 30% after soda tax, new...
1. Read the following article excerpt: Sweetened-beverage sales in Seattle dropped 30% after soda tax, new study says The Columbian https://www.columbian.com/news/2020/feb/23/sweetened-beverage-sales-in-seattle-dropped-30- after-soda-tax-new-study-says/ By Daniel Beekman, The Seattle Times Published: February 23, 2020, 1:45pm Sales of sugar-sweetened beverages at stores in Seattle dropped about 30.5% in the months after the city adopted a tax on such beverages, says a new study that also looked at sales at stores in Portland, which has no such tax. Sales in Portland declined only 10.5%,...
Chapter 5 - Electronic Commerce (course- business) Number of Questions: 17 1. E-commerce breaks down business...
Chapter 5 - Electronic Commerce (course- business) Number of Questions: 17 1. E-commerce breaks down business barriers such as currency. List three other barriers that e-commerce breaks down. 2. When you create an e-commerce website you have to follow sound business fundamentals and principles to be successful. What do you call a formal business plan that outlines key business issues such as customer targets, marketing strategies, and operations strategies? 3. What is G2C e-commerce? Give an example. 4. What is...
Elementary Statistics (7th edition) Chapter 8 review question 7 For Exercises 1 through 20, perform each...
Elementary Statistics (7th edition) Chapter 8 review question 7 For Exercises 1 through 20, perform each of the following steps. State the hypotheses and identify the claim. Find the critical value(s). Compute the test value. Make the decision. Summarize the results 7. Weights of Men’s Soccer Shoes Is lighter better? A random sample of men’s soccer shoes from an inter-national catalog had the following weights (in ounces). 10.8 9.8 8.8 9.6 9.9 10 8.4 9.6 10 9.4 9.8 9.4 9.8...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT