This topic contains a solution. Click here to go to the answer

Author Question: Time is an objective measure, hence timeline data are always highly reliable. Examine the validity ... (Read 57 times)

awywial

  • Hero Member
  • *****
  • Posts: 577
Time is an objective measure, hence timeline data are always highly reliable. Examine the validity of this statement.
 
  What will be an ideal response?

Question 2

High-low, regression
 
  Mandy Knox is the new manager of the materials storeroom for Timken Manufacturing. Mandy has been asked to estimate future monthly purchase costs for part 696, used in two of Timken's products. Mandy has purchase cost and quantity data for the past 9 months as follows:
 
  Estimated monthly purchases for this part based on expected demand of the two products for the rest of the year are as follows:
 
  Required:
  1. The computer in Mandy's office is down, and Mandy has been asked to immediately provide an equation to estimate the future purchase cost for part 696. Mandy grabs a calculator and uses the high- low method to estimate a cost equation. What equation does she get?
  2. Using the equation from requirement 1, calculate the future expected purchase costs for each of the last 3 months of the year.
  3. After a few hours Mandy's computer is fixed. Mandy uses the first 9 months of data and regression analysis to estimate the relationship between the quantity purchased and purchase costs of part 696. The regression line Mandy obtains is as follows:
 
  Evaluate the regression line using the criteria of economic plausibility, goodness of fit, and significance of the independent variable. Compare the regression equation to the equation based on the high-low method. Which is a better fit? Why?
  4. Use the regression results to calculate the expected purchase costs for October, November, and December. Compare the expected purchase costs to the expected purchase costs calculated using the high-low method in requirement 2. Comment on your results.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

frejo

  • Sr. Member
  • ****
  • Posts: 349
Answer to Question 1

When timelines are used as evidence, it is necessary that they be reliable. Of course, the reliability of a timeline depends on the reliability of its components-the timing of individual events. Although time is an objective measure, this does not mean that all measurements of time are reliable. As with all forms of data, a primary factor in assessing reliability is the source. Time can be obtained from any device that has a clock, which includes most computerized devices (such as personal computers, cell phones, cash registers, and ATMs). Investigators can also obtain timing information from other documents. For example, checks are dated, receipts are time-stamped, and computers record the time a file was created, accessed, and modified. The investigator must be aware that, while time is objective, the measurement of time is vulnerable to human manipulation and error. Computer clocks can be adjusted, power failures can produce inaccuracies, and people can misdate documents, either intentionally or unintentionally. Thus, it is important to assess the validity of time measurements before relying on them.

Answer to Question 2

1. Mandy will pick the highest point of activity, 4,068 parts (March) at 17,280 of cost, and the lowest point of activity, 2,316 parts (August) at 10,272.

Cost driver:
Quantity Purchased Cost
Highest observation of cost driver 4,068 17,280
Lowest observation of cost driver 2,316 10,272
Difference 1,752  7,008

Purchase costs = a + b Quantity purchased

Slope Coefficient = 7,008/1,752 = 4 per part

Constant (a) = 17,280  (4 4,068) = 1,008

The equation Mandy gets is:

Purchase costs = 1,008 + (4 Quantity purchased)

2. Using the equation above, the expected purchase costs for each month will be:

Month Purchase Quantity
Expected Formula Expected
cost
October 3,360 parts y = 1,008 + (4 3,360) 14,448
November 3,720 y = 1,008 + (4 3,720) 15,888
December 3,000 y = 1,008 + (4 3,000) 13,008

3. Economic Plausibility: Clearly, the cost of purchasing a part is associated with the quantity purchased.

Goodness of Fit: As seen in Solution Exhibit 10- 27, the regression line fits the data well. The vertical distance between the regression line and observations is small. An r-squared value of greater than 0.98 indicates that more than 98 percent of the change in cost can be explained by the change in quantity.

Significance of the Independent Variable: The relatively steep slope of the regression line suggests that the quantity purchased is correlated with purchasing cost for part 696.

EXHIBIT 10- 27

According to the regression, Mandy's original estimate of fixed cost is too low given all the data points. The original slope is too steep but only by 33 cents. So, the variable rate is lower, but the fixed cost is higher for the regression line than for the high-low cost equation.

The regression is the more accurate estimate because it uses all available data (all nine data points), while the high-low method only relies on two data points and may therefore miss some important information contained in the other data.

4. Using the regression equation, the purchase costs for each month will be:

Month Purchase
Quantity
Expected Formula Expected cost
October 3,360 parts y = 2,135.50 + (3.67 3,360) 14,466.70
November 3,720 y = 2,135.50 + (3.67 3,720) 15,787.90
December 3,000 y = 2,135.50 + (3.67 3,000) 13,145.50

Although the two equations are different in both fixed element and variable rate, within the relevant range they give similar expected costs. This implies that the high and low points of the data are a reasonable representation of the total set of points within the relevant range.





 

Did you know?

The top 10 most important tips that will help you grow old gracefully include (1) quit smoking, (2) keep your weight down, (3) take supplements, (4) skip a meal each day or fast 1 day per week, (5) get a pet, (6) get medical help for chronic pain, (7) walk regularly, (8) reduce arguments, (9) put live plants in your living space, and (10) do some weight training.

Did you know?

All patients with hyperparathyroidism will develop osteoporosis. The parathyroid glands maintain blood calcium within the normal range. All patients with this disease will continue to lose calcium from their bones every day, and there is no way to prevent the development of osteoporosis as a result.

Did you know?

There are actually 60 minerals, 16 vitamins, 12 essential amino acids, and three essential fatty acids that your body needs every day.

Did you know?

In 1886, William Bates reported on the discovery of a substance produced by the adrenal gland that turned out to be epinephrine (adrenaline). In 1904, this drug was first artificially synthesized by Friedrich Stolz.

Did you know?

Eat fiber! A diet high in fiber can help lower cholesterol levels by as much as 10%.

For a complete list of videos, visit our video library