Develop and provide the linear regression equation

Assignment Help Advanced Statistics
Reference no: EM13334272

Holding goods in inventory is costly because inventoried goods are susceptible to breakage and other forms of physical damage. Typically, the amount of damage (in dollars) increases with the level of inventory (expressed in dollars), but some of the damage is unrelated to the amount of inventory. The following data show a company's inventory damage experience.

Period

Inventory Level (Millions of Dollars)

Damage (Thousands of Dollars)

Average Age of Inventory (Days)

1

$11

$80

31

2

$15

$90

45

3

$13

$70

98

4

$10

$60

15

5

$7

$50

25

6

$9

$70

31

7

$13

$80

82

You are interested in developing a forecast for the Damage for period 9.

a) You believe that there is a cause-and-effect relationship between damage and the inventory level. You believe that the damage is a function of the inventory level.

Develop and provide the linear regression equation for the damage given the inventory level using the appropriate independent and dependent variables.

b) How good is the relationship you found in a)? Based on the considerations used during class related to the strength of the relationship, would you recommend using this relationship? Explain your reasoning.

c) If the forecasted inventory level for period 9 is $15,000,000, what is the forecasted damage for Period 9?

d) Your boss believes that there might be a cause-and-effect relationship between damage and the average age of the inventory. He wonders if the damage level might be influenced by the average age of the inventory. Based on the information provided, what would you tell him? Explain your answer. If you do agree with your boss, what would you forecast the damage level for inventory with an average age of 60 days?

Reference no: EM13334272

Questions Cloud

Find the direction of the owners velocity : A 17.6kg dog is running northward at 2.87m/s , while a 6.33kg cat is running eastward at 3.99m/s. Find the direction of the owner's velocity
Explain aluminum phosphate and calcium hydroxide : Using the Solubility Product Constants for Compounds at 25°C from Appendix II of our book, Determine which of the following compounds would be the LEAST soluble. a) Aluminum phosphate b) Calcium hydroxide c) Copper (I) cyanide d) Lead (II) chlorid..
What is the tension in each cable segment : A cable is stretched horizontally across the top of two vertical poles 20 m apart. What is the tension in each cable segment
Find the magnitude of the net force on the piston : A cylindrical piston sits on top of hydraulic fluid that exerts a force of 240 N on the piston. Find the magnitude of the net force on the piston
Develop and provide the linear regression equation : Develop and provide the linear regression equation for the damage given the inventory level using the appropriate independent and dependent variables.
Explain born-haber cycle to calculate the lattice energy : Use the Born-Haber cycle to calculate the lattice energy of LiCl(s) given the following data: ?H(sublimation) Li = 155.2 kJ/mol; I1 (Li) = 520 kJ/mol; Bond energy (Cl Cl) = 242.8 kJ/mol; EA (Cl) = 348 kJ/mol; ?Hf (LiCl(s)) = -408.8 kJ/mol. A
How does human resource planning relate to organizational : 1. How does human resource planning relate to organizational ?
Based econometric model on the data : Please state what data from either a company, from the internet, or from some other source which contains at least 3 independent variables and 1 dependent variable. This can be cross sectional (recommended) or time series (not recommended). Produce a..
Calculate the crankshafts angular acceleration : The crankshaft in a race car goes from rest to 3480 rpm in 2.7s. What is the crankshaft's angular acceleration

Reviews

Write a Review

 

Advanced Statistics Questions & Answers

  Determining various accounting problems

Josh sold a piece of business equipment that had an adjusted basis to him of $50,000. In return for the equipment, Josh received $80,000 cash and a painting with a fair market value of $20,000 from the buyer.

  Application methods for financial management

Prepare a cash budget with borrowing needed or repayments for November and December. (You will need to prepare a cash receipt schedule first).

  Break-even point and equilibrium point

A company, sells and repairs old bicycles and parts for replacement. Sell reconstructed pictures at a unit price of $ 50. The fixed cost of equipment for re construction of the tables is $ 500.

  Forecast errors for sophisticated models

All forecasts contain some error whether the model is simple or sophisticated, because forecasts are predictions of the future based on past data. Forecast errors can be caused by changes in conditions that generated the past data

  Computing budgeted gross profit

For Nolte Company, the budgeted cost for one unit of product is direct materials $10, direct labor $20 and manufacturing overhead 90% of direct labor cost.

  Determining present value and cash deposited

What is the present value of nine annual cash payments of $4,000, to be paid at the end of each year using an interest rate of 6%?

  Estimating common equity from retained earnings

Your firm has been hired to help ABC Company to estimate the cost of common equity. The yield on the firm's bonds is 5.75%, and your firm's economists believe that the cost of common equity can be estimated using a risk premium of 2.5% over a firm..

  Advantages and disadvantages of statistical analysis

Why is statistical analysis preferable to visual inspection ("eye-balling") of data when making managerial decisions?

  Information about research and evaluation

Explain primary data and describe at least three types and how they are gathered. Explain the financial aspect of secondary data. How has the internet changed research processes

  Making t-ledger and a journal

I just need help with setting this accounting question up on a t-ledger and a journal it has to be on an excel format as well. I am just confused on how to set it up

  Impact of fluctuations in currency values

What will happen to this company's sales if the dollar appreciates by 15 percent? What will happen to the company's sales if the dollar depreciates by 10 percent?

  Interpreting mean and fuzzy data

You have been asked to ship a package from Pennsylvania to California. You need to get it there in 2 days, heads will roll if it is late.You call 2 carriers, and ask them what their average transit time is to California.

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