Management is planning to increase menu prices this year by 5 percent in Month 2 and another 3 percent in Month 4. Forecast food sales for months 1-6 this year by using the following historical information: Month Sales Volume Last Year Month 1 $140,000 Month 2 175,000 Month 3 190,000 Month 4 225,000 Month 5 265,000 Month 6 310,000

Management is planning to increase menu prices this year by 5 percent in Month 2 and another 3 percent in Month 4. Forecast food sales for months 1-6 this year by using the following historical information: Month Sales Volume Last Year Month 1 $140,000 Month 2 175,000 Month 3 190,000 Month 4 225,000 Month 5 265,000 Month 6 310,000

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter8: Time Series Analysis And_forecasting

Section: Chapter Questions

Problem 11P: For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12...

See similar textbooks

Similar questions

Management is planning to increase sales volume 3.75 percent and leave menu prices the same. Forecast food sales for months 1-3 this year by using the following historical information: Month Sales Volume Last Year Month 1 $140,000 Month 2 175,000 Month 3 190,000
7. Short-Term Planning. Paymore Products places orders for goods equal to 75% of its sales forecast in the next quarter. What will orders be in each quarter of the year if the sales forecasts for the next 5 quarters are as shown in the following table? Quarter in Coming Year Following Year First Second Third Fourth Sales forecast $372 $360 $336 $384 First Quarter $384
Management is planning to increase menu prices 4 percent and also expects a 3 percent increase in sales volume. Forecast food sales for months 1-3 by using the following historical information: Month Sales Volume Last Year Month 1 $140,000 Month 2 175,000 Month 3 190,000
The sales forecast for birdhouses built by Splish Enterprises follows. Beginning inventory for the year is expected to be 8,000 birdhouses, and the production manager prefers to maintain an ending inventory of 15% of the next quarter's sales. Quarter Number of Birdhouses First 8,000 Second 24,000 Third 29,000 Fourth 40,000
The Toro Cutlery Company has collected monthly sales information below: MONTH MONTH May January February June March April SALES 15,000 18,000 33,000 115,000 SALES 77,000 30,000 80,000 44,000 MONTH September October November December SALES 34,000 101,000 68,000 84,000 July August The company is examining two forecasting methods, moving average and exponential smoothing for forecasting sales. a. What will the forecast be for January the following year using a three-, four-, and five-month moving averages? Do not round intermediate calculations. Round your answers to the nearest whole number. Forecast (January, 3-month MA): Forecast (January, 4-month MA): Forecast (January, 5-month MA): b. What will the forecast be for January the following year using exponential smoothing with a = 0.4? Assume the forecast for February this year is 15,000. Do not round intermediate calculations. Round your answer to the nearest whole number.
15. Texas Company has begun selling new chili recipe and they want you to help with next year's budgeted financial statements. Using the worksheet below, complete Texas Company forecast and answer the questions which follow. Assumptions: To begin with, Texas Company is sure sales will grow 40% next year. Assume that is true. Then assume that COGS, Current Assets, and Current Liabilities all vary directly with Sales (that means if sales grow a certain percentage, then the account in question will grow by that same percentage). Assume that fixed expenses will remain unchanged, and that $3,000 worth of new Fixed Assets will be obtained next year. Lastly, the current dividend policy will be continued next year. Texas Company Financial Forecast Estimated This Year for next year $45,000 $5,000 40,000 Sales COGS Gross Profit 3,000 37,000 Fixed Expenses Before-Tax Profit Tax @ 33.3333% Net Profit 12.332 24,668 Dividends $0 Current Assets $30,000 20,000 $50,000 Net Fixed Assets Total Assets…
Kraft Bakeries introduced in 2019 a new line of frozen apple pie. For 2019, sales by quarter were as follows: 21,000 units, 26,900 units, 24,500 units, and 30,400 units. Because of aggressive marketing and promotion, the company expects that sales for each quarter of 2020 will be 25% higher than the respective quarter in 2019. The selling price per unit in 2020 is expected to be $5.80. What are the expected sales, in units and dollars, for the second quarter of 2020? For the third quarter of 2020?
A July sales forecast projects that 8,000 units are going to be sold at a price of $9.00 per unit. Management forecasts 2% growth in sales each month. Total August sales are anticipated to be: Multiple Choice $72,000. $70,560. $74,880. $73.440. $68,000.
Hannon Retailing Company prices its products by adding 30% to its cost. Hannon anticipates sales of $715,000 in July, $728,000 in August, and $624,000 in September. Hannon’s policy is to have on hand enough inventory at the end of the month to cover 25% of the next month’s sales. What will be the cost of the inventory that Hannon should budget for purchase in August?a. $509,600b. $540,000c. $565,000d. $680,000
Mungus Coffee has recently recruited you to assist them with the financial aspect of their business. One component of your job is prepare budgets. The Income Statement for last year is presented below and you are required to create a Proforma Income Statement for July 31st 2021 using the fixed variable method. The company expects Sales to increase by 5%. Mungus Coffee Income Statement For the period July 31st 2020 Sales 126,000 Less Cost of Goods Sold 54,000 (variable) Gross Profit 72,000 Less Operating Expenses: Marketing Expense 28,400 (6000 variable and 22,400 fixed) General and Admin. Expense 8,600 (3000 variable and 5,600 fixed) Total Operting Expense 37,000 Operating Income 35,000 Less Interest Expense 1,800 (fixed)…
Service volume for the coming budget year will be 10,000 units per week of service type 1 and 20,000 per week of service type 2. You plan to charge $200 for type 1 and $100 for type 2 services. Experience tells you that you will collect 75% of what you bill. Based on this information, how much gross and net revenue will you expect in the coming budget year?
The marketing department of Gaeber Industries has submitted the following sales forecast for the upcoming fi scal year: 1st Quarter 2nd Quarter 3rd Quarter 4th QuarterBudgeted unit sales . . . . . . . 8,000 7,000 6,000 7,000 The company expects to start the fi rst quarter with 1,600 units in fi nished goods inventory. Management desires an ending fi nished goods inventory in each quarter equal to 20% of the next quarter’s budgeted sales. The desired ending fi nished goods inventory for the fourth quarter is 1,700 units.In addition, the beginning raw materials inventory for the fi rst quarter is budgeted to be3,120 pounds and the beginning accounts payable for the fi rst quarter is budgeted to be $14,820.Each unit requires 2 pounds of raw material that costs $4.00 per pound. Management desires to end each quarter with an inventory of raw materials equal to 20% of the following quarter’s production needs. The desired…