Methods based on advance demand information, Corporate Finance

Assignment Help:

Table gives the average MAPE for all SKUs with positive preview demand together (overall) and also per preview demand class. Furthermore, the error percentages in bold were signi?cantly lower (based on Tukey tests at a 5% signi?cance level) than those for other methods (if any) that are not in bold, but not signi?cantly different from each other.

It appears that all methods perform considerably better in Season 2 than in Season 3. An important contributing factor to the poor performance in Season 3 is that demand dropped sharply compared to previous years, although preview demand was comparable to previous years. This may have been caused by a number of factors, including macro-economic and weather conditions. We discussed this with company experts, but neither they nor we could identify important explanatory market or economic conditions as part of the cause.We remark that all data was collected before the start of the current global recession.

As expected, Method based on equal division performs worst on average. Method 1 (preview) provides the best overall performance. However, as is especially evident for Season 3, Method 1 can lead to large forecast errors for SKUs with high preview demand. Method 1 often results in much too large forecasts for those SKUs. This leads to large stocks remaining at the end of the season that either become obsolete or have to be sold below the cost price. Methods 3 avoids those large forecast errors for SKUs with high preview demand. Apparently, although high preview demand is indeed a reliable indicator of whether an SKU will be top, the exact ranking of the top SKUs based on preview demand is no guarantee that the ?nal ranking based on realized demand will be the same. This is illustrated for a speci?c product group with 9 SKUs in Table.

For this group, the three SKUs with the highest (lowest) preview demand indeed turn out to be the top (?op) SKUs. However, the realized demand for the SKU with the highest preview demand of 8, is only about half of that for the SKU with preview demand 7. For the above example with 9 SKUs, the three top SKUs and the three ?op SKUs are all correctly identi?ed. In general, especially for larger numbers of SKUs, the classi?cation is not perfect. However, most SKUs do typically end up in the correct class. To illustrate this, we consider a second example of a product group with 37 SKUs in Season 3. Table 4 shows the preview demand and the Forecast errors (MAPE) averaged over the SKUs of all three assortment groups for Seasons 2 (top) and 3 (bottom). All forecast methods are applied at the product group level. Errors in bold are signi?cantly lower (based on Tukey tests at a 5% signi?cance level) than those (if any) not in bold, but not signi?cantly different from each other.


Related Discussions:- Methods based on advance demand information

American petroleum institute, This institute is a leading oil and gas indus...

This institute is a leading oil and gas industry trade association. The American Petroleum Institute is concerned with public policy and industry lobbying efforts, health and safet

Homework Help, Look back to Section 13–1 (Table 13.2 on p. 329). Suppose th...

Look back to Section 13–1 (Table 13.2 on p. 329). Suppose that Ms. Macbeth’s investment bankers have informed her that since the new issue of debt is risky, debt holders will deman

Project Help, 1. Use the bond price, yield-to-maturity, and quantity availa...

1. Use the bond price, yield-to-maturity, and quantity available you collected for each bond in Component 2 for this project to estimate an average current bond price and an averag

Use of forecasting method, Cooper Toys sells a portable baby stroller calle...

Cooper Toys sells a portable baby stroller called the Tot n' Trot. The past two years of demand for Tot n'Trots are shown in the table below. Use an appropriate method to forecast

Amortizing a loan, Suppose you take out a loan of $10,000, repayable by fiv...

Suppose you take out a loan of $10,000, repayable by five equal annual instalments. The interest rate is 10% per year. (a) How much do you need to repay per year to the nearest ce

Impact on uncertainty in the global foreign exchange markets, Question 1: ...

Question 1: i) Each of the following statements has been put forward as an explanation of determinants of exchange rate: a) ‘the increase in the value of a currency is becau

Compare the financial system of the mauritius and usa, Question : (a) ...

Question : (a) Compare the financial system of the Mauritius and USA. Give differences between the two systems. (b) One of the facilities given by the financial system is

Bonds, you buy a car for ths 10000000 to be repaid in 3 years, with annua i...

you buy a car for ths 10000000 to be repaid in 3 years, with annua interest of 12%. preapare a loan amortization table

How competitive is the market for banking services?, How competitive is the...

How competitive is the market for banking services? A: With more than 7,000 banks and thrifts in the U.S., banking is one of the most competitive industries in the world. Consi

Commercial insurance example, The East Coast Conglomerate Co (ECCC) a small...

The East Coast Conglomerate Co (ECCC) a small manufacturing company is doing a risk management assessment and a total review of their insurance policies. They have asked you,  know

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd