1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Orlov [11]
2 years ago
8

Consider the data in the Excel file Consumer Price Index. Use simple linear regression to forecast the data. What would be the f

orecasts for the next two months? (Your regression equation should be look like CPI = a + b T. The T is year and 1990=1; 1991=2; 1992=3; 1993=4; 1994=5; 1995=6; 1996=7; 1997=8; 1998=9; 1999=10) Year CPI 1990 169.3 1991 170.0 1992 172.4 1993 175.3 1994 177.2 1995 176.8 1996 179.1 1997 180.1 1998 ? 1999 ?

Business
1 answer:
Digiron [165]2 years ago
3 0

Answer:

CPI(1998) = 182.32

CPI(1999) = 183.94

Explanation:

1.  

Using excel regression analysis, the regression results are below:

This gives regression equation as: CPI = 167.73 + 1.62T

Kindly check the attached image below for the step by step explanation.

In order to find CPI values for 1998 and 1999, substitute value of T = 9 and 10 respectively

This gives:

CPI(1998) = 182.32

CPI(1999) = 183.94

You might be interested in
CA5-5 WRITING (Cash Flow Analysis) The partner in charge of the Kappeler Corporation audit comes by your desk and leaves a lette
zvonat [6]

Answer:

Explanation statement of cash flow for the year ended December 31.2017

Cash flow from operating activities

Net income                                              100,000

Add back depreciation          10,000

Add back amortization              1,000

Add back loss on asset sales   5,000

Increase in account receivable(40,000)

Increase in inventory                 (35,000)

Decrease in accounts payable (41,000)   (100,000)

Net cash from operating activities                  0

Cash flow from investing activities

Sales of land                                  25,000

Purchase of equipment                (100,000)

Purchase of Land                          (200,000)

Net cash from investing activities                     (275,000)

Cash from financing activities

Payment of dividends                    (10,000)

Redemption of bonds                    (100,000)

Bet cash from financing activities                       (110,000)

Net decrease in Cash                                         ( 385,000)    

Cash balance in January 1, 2017                         400,000

Cash balance in December 31 , 2017                    15,000

<u>Workings</u>

1)

The disparity between the net income and the cash floe are as a result loss of cash to operating activities as a result of  cash tied down to increase in receivable and inventory and also to an increase in payable leading to an overall cash generated by operating activities of 0

Moreover , a larger portion (300,000) of the opening cash balance(400,000) for the year was used in acquiring land and equipment and also 100,000 used in the redemption of bond. , even though this reduced the interest expense and improve equity , yet it was a big blow to the cash flow.

2)

The importance of cash flow is that it helps to analyse and monitor cash movement and cash available for the purpose of business activities towards liquidity and long term solvency.

3)

Renewable sources of cash flow are generated from the company's operating activities as the cash used for the financing and operating activities are generated from this medium.

4)

Suggestion to improve cash flow for Kappler are

  1. Reduce the level of inventory held
  2. Negotiate with the account payable for a longer trade payable payment period
  3. Reduce the trade receivable collection period
  4. Payment of dividends and redemption of bonds van be suspended till alter date when adequate cash is available
  5. it can also negotiate for external sources of financing

       

4 0
3 years ago
List four decision making techniques
Elenna [48]
Command – decisions are made with no involvement.
Consult – invite input from others.
Vote – discuss options and then call for a vote.
Consensus – talk until everyone agrees to one decision
3 0
3 years ago
ABC Company is considering investing in new production equipment at a cost of $60,000 with a 10-year useful life and no salvage
ikadub [295]

Answer:

a. Operating Income = Sales - Production Cost - Depreciation Expense

Operating Income = $100,000 - $82,600 - $6,000

Operating Income = $11,400

b. Average Investment = (Initial Equipment Cost + Residual Value) / 2

Average Investment = ($60,000 + $0) / 2

Average Investment = $60,000 / 2

Average Investment = $30,000

c. Accounting Rate of Return = (Operating Income / Average Investment) * 100

Accounting Rate of Return = ($11,400 / $30,000) * 100

Accounting Rate of Return = 0.38 * 100

Accounting Rate of Return = 38%

7 0
2 years ago
Lush Lawns, a new landscaping company, uses the same logo and shade of green in all forms of communication including its online
Fofino [41]

Integrated marketing communications is being used by Lush Lawns to promote its business, as they are using the same logo and shade of green in all forms of communication including its online ads, truck signage, Web site, and business cards.

<h3 /><h3>What is Integrated marketing communications?</h3>

IMC is the process of combining marketing communication aspects such as public relations, social media, and audience analytics to create an integrated marketing communication strategy.

Business development concepts, and advertising into a brand identity that is consistent across many media channels.

Thus they are using Integrated marketing communications.

For more details about  Integrated marketing communications, click here

brainly.com/question/13962154

#SPJ1



5 0
1 year ago
Technological advances are difficult to predict. One great advance can replace or substitute for existing products in a relative
deff fn [24]

Answer:

The answer is: 3) Printed media

Explanation:

This is already happening, cell phones and tablets have already replaced digital cameras, Netflix is replacing cable TV and sooner than later cell phones and tablets will replace printed media completely.

Ask yourself, when was the last time you bought a newspaper? I haven´t bought a newspaper in years but I can also guarantee that I read more news outlets today that ever before. I can read the New York Times, The Washington Post, Sports Illustrated, etc. all on my cellphone. Using my phone is cheaper and faster (and also more ecological) than buying a printed version. In a few years probably no newspaper will have a printed edition, not even magazines will be printed anymore.

5 0
3 years ago
Other questions:
  • Hercules Company purchased a computer for $4,800 on December 1. It is estimated that annual
    6·1 answer
  • Jensen performed legal services to assist Balm Co. in accomplishing its initial organization. Jensen accepted 1,000 shares of $5
    12·1 answer
  • If fixed costs are $400,000 and the unit contribution margin is $20, how many units must be sold in order to realize an operatin
    11·1 answer
  • In the short run, contractionary monetary policy _________ real gross domestic product (GDP), _________ unemployment, and ______
    8·2 answers
  • The customers, employees, stockholders, suppliers, creditors, and others who stand to gain or lose by the policies and activitie
    6·1 answer
  • The statement of cash flows reports all but which of the following: Multiple Choice
    14·1 answer
  • According to the growth accounting studies, if you lived in a country where illiteracy was high and 40% of the children left sch
    5·1 answer
  • A company had net cash flows from operations of $341,000, net income of $286,000 and average total assets of $1,850,000. The cas
    8·1 answer
  • A sale should always satisfy both a customer’s wants and his or her needs.<br><br> True<br> False
    6·2 answers
  • Employees at House of Pancakes pretend that they like their boss even though most of the time they do not. These employees are e
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!