Question

In: Operations Management

Q3. Premium Toyota dealership wants to develop forecasts for next year’s quarterly sales of a midsize...

Q3.

Premium Toyota dealership wants to develop forecasts for next year’s quarterly sales of a midsize SUV. Sales were 80,000 in 2018 and 84,000 in 2019. It has collected quarterly sales for the past two years. It has also forecast total annual sales for next year to be 90,000 SUVs. What is the forecast for each of the four quarters of next year?

Quarter Sales (in thousands)

2018

2019

Fall

24

26

Winter

23

22

Spring

19

19

Summer

Q4

Mister Baker wants to evaluate performance of its pastries forecast. Mister Baker sales in last four weeks were 80, 100, 105, and 90 units, respectively. In addition, the sales forecasts (for the same four weeks) were 60, 80, 95, and 75 units, respectively. Calculate the MAD, MSE, and MAPE for these four weeks.

Sales

Forecast

80

60

100

80

105

95

90

75

Solutions

Expert Solution

Answer for Q3

Quarter Sales (in thousands)
Fall 27
Winter 25
Spring 21
Summer 17

Answer for Q4.

MAD,Mean Absolute Deviation 16.25
MSE,Mean Square Error 281.25
MAPE,Mean Absolute Percentage Error 0.1780 or 17.80%

Explanation


Related Solutions

The manager of a utility company in the Texas panhandle wants to develop quarterly forecasts of...
The manager of a utility company in the Texas panhandle wants to develop quarterly forecasts of power loads for the next year. The power loads are? seasonal, and the data on the quarterly loads in megawatts? (MW) for the last four years are as? follows: ???????????????????????????????????????????????????????????????????????????????????????? Quarter Year 1 Year 2 Year 3 Year 4 1.102.1 93.6 120.6 107.7 2.129.4 119.9 142.5 131.2 3. 142.9 136.5 169.9 149.1 4. 168.6 156.1 181.6 169.0 The manager estimates the total demand for...
Problem Details: A major beverage company needs forecasts of sales for next year. Quarterly sales data...
Problem Details: A major beverage company needs forecasts of sales for next year. Quarterly sales data for the previous 13 years can be found in the “Beverage_Sales” worksheet of the Excel file titled Group Case #2 Data. Requirements (You will NOT follow the PLAN-DO-REPORT algorithm. Address/answer all requirements in the order given.): 1. (2 points) Create a Time Series plot of the sales data. Briefly describe what you see in the plot. 2. (5 points) Develop a model to forecast...
The Longmont company in Charlette, North Carolina, asked you to develop quarterly forecasts of combine sales...
The Longmont company in Charlette, North Carolina, asked you to develop quarterly forecasts of combine sales for next year. Combine sales are seasonal, and the data on the quarterly sales for the last four years are as follows: Quarter Year 1 Year 2 Year 3 Year 4 1 55 85 178 256 2 37 23 101 193 3 89 130 145 209 4 110 156 167 167 Chad Johnson estimates the total demand for the next year (Year 5) at...
Q3 Ibrahim Corporation manufactures product A.  Following is information for next year’s operations, based on an estimated...
Q3 Ibrahim Corporation manufactures product A.  Following is information for next year’s operations, based on an estimated volume of 40,000 units: Expected revenues                                    $2,000,000 Unit costs: Direct materials                                              $  7 Direct labor                                                       16 Variable overhead                                               6 Fixed manufacturing overhead                           3 Total                                                          $32 Other fixed costs: Administration, marketing, etc.             $230,000 Income tax rate                                                    30% a.   What is the breakeven point for next year? b.   What is next year’s projected after-tax income? c.   Chose a target after-tax income.  Estimate the number of units that must be sold to reach this target.
Suppose you are a salesperson and your company's CRM forecasts that your quarterly sales will be...
Suppose you are a salesperson and your company's CRM forecasts that your quarterly sales will be substantially under quota. You call your best customers to increase sales, but no one is willing to buy more. Your boss says that it has been a bad quarter for all the salespeople. It's so bad, in fact, that the vice president of sales has authorized a 20 percent discount on new orders. The only stipulation is that customers must take delivery prior to...
You’ve been asked to use the following historical sales information to forecast next year’s sales for...
You’ve been asked to use the following historical sales information to forecast next year’s sales for Worldwide Widget Manufacturing, Inc. The actual sales for 2016 were $1,950,000. Year Sales 2011 $1,750,000 2012 $2,000,000 2013 $1,350,000 2014 $2,250,000 2015 $1,800,000 What would be the next year's forecast according to the naïve approach and the average sales approach? What would be the MAPE according to the naïve approach and the average sales approach? Kindly show all detailed calculations.
Next Year’s Sales Projections: Product Sales Price # of Units Handbags $400.00 10,000 Wallets $120.00 15,000...
Next Year’s Sales Projections: Product Sales Price # of Units Handbags $400.00 10,000 Wallets $120.00 15,000 Inventories: Product Beginning of Next Year End of Next Year Handbags 1,000 1,500 Wallets 1,500 500 Direct Materials: Direct Material Handbag Wallet Leather 3 feet 1 foot Zipper 3 zippers 1 zipper Embellishments 20 5 Direct Material Costs: Purchase Price Inventory – Beg Inventory - End Leather $40.00 foot 100 feet 50 feet Zipper $10 zipper 20 zippers 20 zippers Embellishments $5 30 20...
You are a sales manager for a car dealership who wants to effectively target potential customers....
You are a sales manager for a car dealership who wants to effectively target potential customers. Write a paper that details how you would create a data system to reach potential customers and addresses the following questions: What kind of data would you find helpful in populating your system? What sources would you find helpful in the selection process? What ethical considerations must be part of this process? What BI tools would you utilize to manipulate that data in order...
The Boswell Corporation forecasts its sales in units for the next four months as follows:   March...
The Boswell Corporation forecasts its sales in units for the next four months as follows:   March 16,000   April 18,000   May 15,500   June 14,000 Boswell maintains an ending inventory for each month in the amount of three times the expected sales in the following month. The ending inventory for February (March's beginning inventory) reflects this policy. Materials cost $8 per unit and are paid for in the month after production. Labour cost is $12 per unit and is paid for in...
All That Remains Products has projected sales for next year of: Q1 Q2 Q3 Q4 Sales...
All That Remains Products has projected sales for next year of: Q1 Q2 Q3 Q4 Sales $ 76,000 $ 79,775 $ 86,500 $ 93,480 The company places orders each quarter that are 52 percent of the following quarter's sales and has a 60-day payables period. What is the accounts payable balance at the end of the third quarter?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT