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

Determine the net present value-discount cash flows, Suppose GeKay Inc. has...

Suppose GeKay Inc. has a two-year lease over a small copper deposit; the government acquires all rights to the property at the end of the lease.  It is known that the deposit conta

Mergers and Acquisitions , a) Cookie Monster Inc. (a $15 billion snack food...

a) Cookie Monster Inc. (a $15 billion snack food company) is considering acquiring Keebler Elves but is unsure of how much is should be willing to pay for the target firm. At the

571, Trevor Price bought 10-year bonds issued by Harvest Foods five years a...

Trevor Price bought 10-year bonds issued by Harvest Foods five years ago for $936.05. The bonds make semiannual coupon payments at a rate of 8.4 percent. If the current price of th

Stocks, The stock price of Jenkins Co. is $53. Investors require a 12 perce...

The stock price of Jenkins Co. is $53. Investors require a 12 percent rate of return on similar stocks. If the company plans to pay a dividend of $3.15 next year, what growth rate

Stock market, Who regulates the stock market and the reason for the need fo...

Who regulates the stock market and the reason for the need for such standard and heavy regulations

Mr, PROBLEM 1 A friend of yours, employed as a Tier 2 field service repres...

PROBLEM 1 A friend of yours, employed as a Tier 2 field service representative for a telephony corporation, wants your help as a financial specialist to determine the financial co

Abu dhabi investment council - adic, ADIC is a sovereign wealth fund posses...

ADIC is a sovereign wealth fund possessed by Abu Dhabi which is the capital of the United Arab Emirates (UAE). It is completely owned and managed by the UAE. The Abu Dhabi Investme

What do you understand by the term hedging effectiveness, Question: (a)...

Question: (a) You have just been recruited as risk analyst at the Air Mauritius Limited. Your risk manager is trapped between diverging expectations. He is not sure whether oil

Renowned Cola, corporate finance, Financial Accounting Calculate the market...

corporate finance, Financial Accounting Calculate the market value of Renowned Cola''''s debt at year-end 2005. What is the book value of debt? Why do usually use market or book va

Standard deviations and correlations, Suppose you are given the expected ye...

Suppose you are given the expected yearly returns and standard deviations and correlations shown in the tables below: The market portfolio has an expected return of 18% and

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