Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Statistics and Probability Expert

Statistics


Home >> Statistics and Probability

Read the article “Apple turns over entire inventory every five days.”1
It is not surprising that, the
success of managing inventory can lead to the success of a firm’s operational performance.
Although we have not talked about the inventory management models, we will first look at real
inventory data to identify some of the important factors that affect a firm’s inventory
performance.
The Excel file of Assignment 5 contains the quarterly information (Q1 to Q4) for more than 250
firms (mostly in the retailer and wholesaler industries, where inventory management is crucial to
firms’ performance) in the fiscal year of 20102
. Most of the variables are fairly straightforward,
except the following ones whose definitions are shown below:
Account Payable = can be approximated to be the trade credit owed to the
firm’s suppliers.
Inventory turnover = how fast a firm turns their inventory into sales
= (cost of goods sold)/(this period and last period’s
inventory average)
Gross Margin = (sales – cost of goods sold)/sales
Capital Intensity = (Gross fixed assets)/( Gross fixed assets + inventory)
Trade Credit Ratio = Account Payable/sales
You may use Excel and turn in the printout as well as the Excel file (by email). You still need to
answer all questions asked in the problem by writing on your printout. For the significance level,
you can test for ?=1%, 5%, and 10%, respectively.
Two inventory performance measures can be used here: the inventory level (Column H) or the
inventory turnover (Column L). First, we investigate the variables that are correlated with the
inventory level.
Hypothesis 1: The inventory level is positively correlated with the assets.
Hypothesis 2: The inventory level is positively correlated with the market value.
Hypothesis 3: The inventory level exhibits a seasonality pattern.
Hypothesis 4: The inventory level is generally higher in Q3 than Q1, Q2, and Q4, after
controlling for the firm size measured by assets.
Hypothesis 5: The inventory level is positively correlated with the natural logarithm of
(Account payable+1) after controlling for the firm size.
Hypothesis 6: The inventory level is positively correlated with Account payable after
controlling for the firm size.
1
http://appleinsider.com/articles/12/05/31/apple_turns_over_entire_inventory_every_five_days
2
See COMPUSTAT for data source.1. Build a regression model to test Hypothesis 1. Does the data support Hypothesis 1? Explain
why.
2. Build a regression model to test Hypothesis 2. Does the data support Hypothesis 2? Explain
why.
3. Build a regression model to jointly test Hypotheses 1 and 2. Does the data support both in
this test? Explain why. Do you observe any issues?
4. Build a regression model to test Hypothesis 3. Does the data support Hypothesis 3? Explain
why.
5. Build a regression model to test Hypothesis 4. Does the data support Hypothesis 4? Explain
why. (Hint: you can “control” an independent variable simply by adding this variable into the
regression model.)
6. Build models to test Hypotheses 5 and 6. Which model is better? Why?
Next, we investigate the variables that are correlated with the inventory turnover.
Hypothesis 7: The inventory turnover is negatively correlated with the gross margin.
Hypothesis 8: The inventory turnover is positively correlated with the capital intensity.
Hypothesis 9: The inventory turnover is negatively correlated with the trade credit to
sales ratio.
7. Build a model to jointly test Hypotheses 7-9, with and without controlling for the firm size
measured by log(asset). Comment on the results and the insights you learn from the
regression model.
also an excel data file

Statistics and Probability, Statistics

  • Category:- Statistics and Probability
  • Reference No.:- M9527654

Have any Question?


Related Questions in Statistics and Probability

What is the sample size for studies with moe of -35 and -28

What is the sample size for studies with MOE of +/-3.5% and +/-2.8%, with a confidence level of 95%, sample statistics of 50. Suppose the category population was 7500 (less than 10,000)? Remember the FPC. What would be t ...

Question you are throwing a party and fill a bowl with 63

Question: You are throwing a party and fill a bowl with 63 ounces of punch. Suppose the expected size of each cup of punch is 2 ounces and the standard deviation of the size of a cup of punch is A ounce and each cup is p ...

Anbsphow much money would you have to invest today to

a.  How much money would you have to invest today to accumulate ?$3,100   after  4 years  if the rate of return on your investment is 15?%? b.  What is the present value of ?$3,100 that you will receive after 4 years if ...

The average starting salary for graduates at a university

The average starting salary for graduates at a university is $33,000 with a standard deviation of $2,000. If a histogram of the data shows that it takes on a mound shape, the empirical rule says that approximately 68% of ...

According to an article in the american heart associations

According to an article in the American Heart Association's publication Circulation, 24% of patients who had been hospitalized for an acute myocardial infarction, did not fill their cardiac medication by the seventh day ...

1nbspis the magnitude of an earthquake related to the depth

1) Is the magnitude of an earthquake related to the depth below the surface at which the quake occurs? Let  x  be the magnitude of an earthquake (on the Richter scale), and let  y  be the depth (in kilometers) of the qua ...

Sppose a and b are collectively exhaustive in addition pa

Suppose A and B are collectively exhaustive. In addition, P(A) = 0.2 and P(B) = 0.8. Suppose C and D are both mutually exclusive and collectively exhaustive. Further, P(C|A) = 0.7 and P(D|B) = 0.5. What are P(C) and P(D) ...

A lot contains 15 items and 6 are defective if two items

A lot contains 15 items and 6 are defective. If two items are drawn at random from the lot, without replacement, what is the probability there is exactly one non-defective? (Hint: You have to use both Multiplication and ...

On a correlation matrix you will usually see two values per

On a correlation matrix, you will usually see two values per comparison. The top value for a correlation measurement will be the Pearson correlation, right under that you will see a p-value. I understand when you have a ...

The height of 5th grade boys is normally distributed with

The height of 5th grade boys is normally distributed with mean μ=57 inches and standard deviation σ=2 inches. What is the probability that the height of a randomly selected 5th grade boy will be between 53 inches and 61 ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As

Follow Us

© Copyright 2013-14 mywordsolution.com All rights reserved