Questions
Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility...

Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company’s costs:

Fixed Cost
per Month
Cost per
Car Washed
Cleaning supplies $ 0.70
Electricity $ 1,300 $ 0.06
Maintenance $ 0.15
Wages and salaries $ 4,700 $ 0.30
Depreciation $ 8,200
Rent $ 1,900
Administrative expenses $ 1,600 $ 0.02

For example, electricity costs are $1,300 per month plus $0.06 per car washed. The company expects to wash 8,300 cars in August and to collect an average of $6.20 per car washed.

The actual operating results for August appear below.

Lavage Rapide
Income Statement
For the Month Ended August 31
Actual cars washed 8,400
Revenue $ 53,560
Expenses:
Cleaning supplies 6,310
Electricity 1,768
Maintenance 1,485
Wages and salaries 7,550
Depreciation 8,200
Rent 2,100
Administrative expenses 1,666
Total expense 29,079
Net operating income $ 24,481

Required:

Prepare a flexible budget performance report that shows the company’s revenue and spending variances and activity variances for August. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)

Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company’s costs:

Fixed Cost
per Month
Cost per
Car Washed
Cleaning supplies $ 0.70
Electricity $ 1,300 $ 0.06
Maintenance $ 0.15
Wages and salaries $ 4,700 $ 0.30
Depreciation $ 8,200
Rent $ 1,900
Administrative expenses $ 1,600 $ 0.02

For example, electricity costs are $1,300 per month plus $0.06 per car washed. The company expects to wash 8,300 cars in August and to collect an average of $6.20 per car washed.

The actual operating results for August appear below.

Lavage Rapide
Income Statement
For the Month Ended August 31
Actual cars washed 8,400
Revenue $ 53,560
Expenses:
Cleaning supplies 6,310
Electricity 1,768
Maintenance 1,485
Wages and salaries 7,550
Depreciation 8,200
Rent 2,100
Administrative expenses 1,666
Total expense 29,079
Net operating income $ 24,481

Required:

Prepare a flexible budget performance report that shows the company’s revenue and spending variances and activity variances for August. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)

Lavage rapide

Flexibgle Budget Performance Report

For the the Month Ended August 31

   actual results revenue and speanding variances flexible budget activity variance planning budget
cars washed 8,400
revenue 53560 F
expenses
cleaning supplies 6310 u
electricty 1768 f
maintenance 1485 u
wages and salaries 7550
depreciation 8200
rent 2100
adminsitrative expenses 1666
total expense 29079
net operating income 24481

In: Accounting

#9 Lenci Corporation manufactures and sells a single product. The company uses units as the measure...

#9

Lenci Corporation manufactures and sells a single product. The company uses units as the measure of activity in its budgets and performance reports. During May, the company budgeted for 5,100 units, but its actual level of activity was 5,050 units. The company has provided the following data concerning the formulas used in its budgeting and its actual results for May:

Data used in budgeting:

Fixed element per month Variable element per unit
Revenue - $ 39.60
Direct labor $ 0 $ 5.50
Direct materials 0 15.70
Manufacturing overhead 41,500 1.30
Selling and administrative expenses 22,700 0.20
Total expenses $ 64,200 $ 22.70

Actual results for May:

Revenue $ 197,810
Direct labor $ 28,565
Direct materials $ 80,265
Manufacturing overhead $ 47,905
Selling and administrative expenses $ 22,680

The overall revenue and spending variance (i.e., the variance for net operating income in the revenue and spending variance column on the flexible budget performance report) for May would be closest to:

Garrison 16e Rechecks 2018-06-07

$2,750 F

$3,595 F

$3,595 U

$2,750 U

#10

Neubert Corporation manufactures and sells a single product. The company uses units as the measure of activity in its budgets and performance reports. During December, the company budgeted for 5,300 units, but its actual level of activity was 5,340 units. The company has provided the following data concerning the formulas used in its budgeting and its actual results for December:

Data used in budgeting:

Fixed Element per Month Variable element per unit
Revenue - $ 30.00
Direct labor $ 0 $ 3.50
Direct materials 0 10.40
Manufacturing overhead 33,300 1.50
Selling and administrative expenses 25,000 0.50
Total expenses $ 58,300 $ 15.90

Actual results for December:

Revenue $ 156,340
Direct labor $ 17,980
Direct materials $ 56,566
Manufacturing overhead $ 41,040
Selling and administrative expenses $ 28,870

The direct labor in the planning budget for December would be closest to:

Garrison 16e Rechecks 2018-06-07

$18,690

$18,550

$17,845

$17,980

#16

Pippin Inc. has provided the following data concerning one of the products in its standard cost system. Variable manufacturing overhead is applied to products on the basis of direct labor-hours.

Inputs Standard Quantity or Hours per Unit of Output Standard Price or Rate
Direct materials 5.0 grams $ 7.00 per gram
Direct labor 0.30 hours $ 21.30 per hour
Variable manufacturing overhead 0.30 hours $ 9.60 per hour

The company has reported the following actual results for the product for June:

Actual output 8,500 units
Raw materials purchased 48,100 grams
Actual price of raw materials $ 7.70 per gram
Raw materials used in production 42,490 grams
Actual direct labor-hours 2,300 hours
Actual direct labor rate $ 21.70 per hour
Actual variable overhead rate $ 9.80 per hour

The labor rate variance for the month is closest to:

$1,020 U

$920 U

$1,020 F

$920 F

In: Accounting

PLEASE POST EXCEL SPREADSHEET Please show all computation and underline your final answer in your submission....

PLEASE POST EXCEL SPREADSHEET

  1. Please show all computation and underline your final answer in your submission.
  1. Income statements and balance sheets follow for Microsoft Corporation. Refer to these financial statements to answer the requirements. (non-operating items are red-marked)

MICROSOFT CORPORATION

Income Statements

For the years ended June 30,

(in millions)

2016

2015

Revenue

     Product

$61,502

$75,956

     Service

23,818

17,624

Total revenue

85,320

93,580

Cost of revenue

     Product

17,880

21,410

     Service and other

14,900

11,628

Total cost of revenue

32,780

33,038

Gross margin

52,540

60,542

Research and development

11,988

12,046

Sales and marketing

14,697

15,713

General and administrative

4,563

4,611

Impairment, integration, and restructuring

   1,110

10,011

Operating income

20,182

18,161

Other income (expense), net

(431)

346

Income before taxes

19,751

18,507

Provision for income taxes

   2,953

6,314

Net income

$16,798

$ 12,193

MICROSOFT CORPORATION

Balance Sheet

As of June 30,

(in millions)

2016

2015

Current assets:

   Cash and cash equivalents

$    6,510

$    5,595

   Short-term investments

106,730

90,931

   Accounts receivable, net

18,277

17,908

   Inventories

2,251

2,902

   Other current assets

     5,892

5,461

Total current assets

139,660

122,797

Property and equipment, net

18,356

14,731

Equity and other investments

10,431

12,053

Goodwill

17,872

16,939

Intangible assets, net

3,733

4,835

Other long-term assets

     3,642

3,117

Total assets

$193,694

$174,472

Current liabilities:

   Accounts payable

$    6,898

$     6,591

   Short-term debt

12,904

4,985

   Current portion of long-term debt

0

2,499

   Accrued compensation

5,264

5,096

   Income taxes

580

606

   Short-term unearned revenue

27,468

23,223

   Other current liabilities

     6,243

6,647

Total current liabilities

59,357

49,647

Long-term debt

40,783

27,808

Long-term unearned revenue

6,441

2,095

Deferred income taxes

1,476

1,295

Other long-term liabilities

   13,640

13,544

Total liabilities

121,697

94,389

Stockholders' equity:

   Common stock and paid-in capital

68,178

68,465

   Retained earnings

2,282

9,096

   Accumulated other comprehensive income

      1,537

2,522

Total stockholders' equity

    71,997

80,083

Total liabilities and stockholders' equity

$193,694

$ 174,472

Required:

  1. (8 points) Compute net operating profit after tax (NOPAT) for 2016 and 2015. Assume that combined federal and state statutory tax rates are 37% for both years.
  1. (8 points) Compute net operating assets (NOA) for 2016 and 2015. Assume Equity and other investments are operating assets.
  1. (8 points) Compute return on net operating assets (RNOA) for 2016 and 2015. Net operating assets are $26,720 million in 2014.
  1. (4 points) Compute return on equity (ROE) for 2016 and 2015. (Stockholders’ equity in 2014 is $89,784 million.)
  1. (4 points) What is nonoperating return component of ROE for 2016 and 2015?
  1. (4 points)Comment on the difference between ROE and RNOA. What inference do you draw from this comparison?

PLEASE POST EXCEL SPREADSHEET

In: Accounting

Freedom Airlines recently started operations in the Southwest. The airline owns two airplanes, one based in...

Freedom Airlines recently started operations in the Southwest. The airline owns two airplanes, one based in Phoenix and the other in Denver. Each airplane has a coach section with 140 seats available. Each afternoon, the Phoenix based airplane flies to San Francisco with stopovers in Las Vegas and in San Diego. The Denver-based airplane also flies to San Francisco with stopovers in Las Vegas and in San Diego. Each airplane returns to its home-base with no stopovers.

Freedom Airlines uses two coach-fare classes: A discount fare (A) and a full fare (B). Discount fares are available with a 21-day advance purchase. Full fares applied at any time, up to the time of the flight.

Below is the daily fare and demand data for 16 selected Freedom Airline itineraries. Itineraries 1 through 6 apply to the Phoenix based airplane (leg 1); itineraries 7 through 12 apply to the Denver based airplane (leg 2); itineraries 13 and 14 apply to the Phoenix based airplane (leg 3); itineraries 15 and 16 apply to the Denver based airplane (leg 4):

1

Phoenix

Las Vegas

A

$ 180.00

50

2

Phoenix

San Diego

A

$ 270.00

40

3

Phoenix

San Francisco

A

$ 230.00

35

4

Phoenix

Las Vegas

B

$ 380.00

15

5

Phoenix

San Diego

B

$ 460.00

10

6

Phoenix

San Francisco

B

$ 560.00

15

7

Denver

Las Vegas

A

$ 200.00

50

8

Denver

San Diego

A

$ 250.00

45

9

Denver

San Francisco

A

$ 350.00

40

10

Denver

Las Vegas

B

$ 385.00

15

11

Denver

San Diego

B

$ 445.00

10

12

Denver

San Francisco

B

$ 580.00

10

13

San Francisco

Phoenix

A

$ 250.00

70

14

San Francisco

Phoenix

B

$ 600.00

10

15

San Francisco

Denver

A

$ 325.00

50

16

San Francisco

Denver

B

$ 585.00

10

  1. Develop a revenue management (maximizing) model based on the information given in the scenario.
  2. How many seats should be allocated to each of the 16 itineraries to maximize revenue?
  3. What is the (maximum) expected revenue to be earned per day for all 16 flights?
  4. Assume operating costs for each of the legs is as follows:
  5. Leg 1 = $20,250
  6. Leg 2 = $19,750
  7. Leg 3 = $20,500
  8. Leg 4 = $19,500

What is the expected operating income for each of the legs? And in total for Freedom Airlines, given these 16 itineraries?

  1. Develop a revenue management (maximizing) model based on the information given in the scenario.
  2. How many seats should be allocated to each of the 16 itineraries to maximize revenue?
  3. What is the (maximum) expected revenue to be earned per day for all 16 flights?
  4. Assume operating costs for each of the legs is as follows:
    1. Leg 1 = $20,250
    2. Leg 2 = $19,750
    3. Leg 3 = $20,500
    4. Leg 4 = $19,500

What is the expected operating income for each of the legs? And in total for Freedom Airlines, given these 16 itineraries?

In: Finance

observation_date FEDFUNDS 1954-07-01 0.80 1954-08-01 1.22 1954-09-01 1.06 1954-10-01 0.85 1954-11-01 0.83 1954-12-01 1.28 1955-01-01 1.39...

observation_date FEDFUNDS
1954-07-01 0.80
1954-08-01 1.22
1954-09-01 1.06
1954-10-01 0.85
1954-11-01 0.83
1954-12-01 1.28
1955-01-01 1.39
1955-02-01 1.29
1955-03-01 1.35
1955-04-01 1.43
1955-05-01 1.43
1955-06-01 1.64
1955-07-01 1.68
1955-08-01 1.96
1955-09-01 2.18
1955-10-01 2.24
1955-11-01 2.35
1955-12-01 2.48
1956-01-01 2.45
1956-02-01 2.50
1956-03-01 2.50
1956-04-01 2.62
1956-05-01 2.75
1956-06-01 2.71
1956-07-01 2.75
1956-08-01 2.73
1956-09-01 2.95
1956-10-01 2.96
1956-11-01 2.88
1956-12-01 2.94
1957-01-01 2.84
1957-02-01 3.00
1957-03-01 2.96
1957-04-01 3.00
1957-05-01 3.00
1957-06-01 3.00
1957-07-01 2.99
1957-08-01 3.24
1957-09-01 3.47
1957-10-01 3.50
1957-11-01 3.28
1957-12-01 2.98
1958-01-01 2.72
1958-02-01 1.67
1958-03-01 1.20
1958-04-01 1.26
1958-05-01 0.63
1958-06-01 0.93
1958-07-01 0.68
1958-08-01 1.53
1958-09-01 1.76
1958-10-01 1.80
1958-11-01 2.27
1958-12-01 2.42
1959-01-01 2.48
1959-02-01 2.43
1959-03-01 2.80
1959-04-01 2.96
1959-05-01 2.90
1959-06-01 3.39
1959-07-01 3.47
1959-08-01 3.50
1959-09-01 3.76
1959-10-01 3.98
1959-11-01 4.00
1959-12-01 3.99
1960-01-01 3.99
1960-02-01 3.97
1960-03-01 3.84
1960-04-01 3.92
1960-05-01 3.85
1960-06-01 3.32
1960-07-01 3.23
1960-08-01 2.98
1960-09-01 2.60
1960-10-01 2.47
1960-11-01 2.44
1960-12-01 1.98
1961-01-01 1.45
1961-02-01 2.54
1961-03-01 2.02
1961-04-01 1.49
1961-05-01 1.98
1961-06-01 1.73
1961-07-01 1.17
1961-08-01 2.00
1961-09-01 1.88
1961-10-01 2.26
1961-11-01 2.61
1961-12-01 2.33
1962-01-01 2.15
1962-02-01 2.37
1962-03-01 2.85
1962-04-01 2.78
1962-05-01 2.36
1962-06-01 2.68
1962-07-01 2.71
1962-08-01 2.93
1962-09-01 2.90
1962-10-01 2.90
1962-11-01 2.94
1962-12-01 2.93
1963-01-01 2.92
1963-02-01 3.00
1963-03-01 2.98
1963-04-01 2.90
1963-05-01 3.00
1963-06-01 2.99
1963-07-01 3.02
1963-08-01 3.49
1963-09-01 3.48
1963-10-01 3.50
1963-11-01 3.48
1963-12-01 3.38
1964-01-01 3.48
1964-02-01 3.48
1964-03-01 3.43
1964-04-01 3.47
1964-05-01 3.50
1964-06-01 3.50
1964-07-01 3.42
1964-08-01 3.50
1964-09-01 3.45
1964-10-01 3.36
1964-11-01 3.52
1964-12-01 3.85
1965-01-01 3.90
1965-02-01 3.98
1965-03-01 4.04
1965-04-01 4.09
1965-05-01 4.10
1965-06-01 4.04
1965-07-01 4.09
1965-08-01 4.12
1965-09-01 4.01
1965-10-01 4.08
1965-11-01 4.10
1965-12-01 4.32
1966-01-01 4.42
1966-02-01 4.60
1966-03-01 4.65
1966-04-01 4.67
1966-05-01 4.90
1966-06-01 5.17
1966-07-01 5.30
1966-08-01 5.53
1966-09-01 5.40
1966-10-01 5.53
1966-11-01 5.76
1966-12-01 5.40
1967-01-01 4.94
1967-02-01 5.00
1967-03-01 4.53
1967-04-01 4.05
1967-05-01 3.94
1967-06-01 3.98
1967-07-01 3.79
1967-08-01 3.90
1967-09-01 3.99
1967-10-01 3.88
1967-11-01 4.13
1967-12-01 4.51
1968-01-01 4.60
1968-02-01 4.71
1968-03-01 5.05
1968-04-01 5.76
1968-05-01 6.11
1968-06-01 6.07
1968-07-01 6.02
1968-08-01 6.03
1968-09-01 5.78
1968-10-01 5.91
1968-11-01 5.82
1968-12-01 6.02
1969-01-01 6.30
1969-02-01 6.61
1969-03-01 6.79
1969-04-01 7.41
1969-05-01 8.67
1969-06-01 8.90
1969-07-01 8.61
1969-08-01 9.19
1969-09-01 9.15
1969-10-01 9.00
1969-11-01 8.85
1969-12-01 8.97
1970-01-01 8.98
1970-02-01 8.98
1970-03-01 7.76
1970-04-01 8.10
1970-05-01 7.94
1970-06-01 7.60
1970-07-01 7.21
1970-08-01 6.61
1970-09-01 6.29
1970-10-01 6.20
1970-11-01 5.60
1970-12-01 4.90
1971-01-01 4.14
1971-02-01 3.72
1971-03-01 3.71
1971-04-01 4.15
1971-05-01 4.63
1971-06-01 4.91
1971-07-01 5.31
1971-08-01 5.56
1971-09-01 5.55
1971-10-01 5.20
1971-11-01 4.91
1971-12-01 4.14
1972-01-01 3.50
1972-02-01 3.29
1972-03-01 3.83
1972-04-01 4.17
1972-05-01 4.27
1972-06-01 4.46
1972-07-01 4.55
1972-08-01 4.80
1972-09-01 4.87
1972-10-01 5.04
1972-11-01 5.06
1972-12-01 5.33
1973-01-01 5.94
1973-02-01 6.58
1973-03-01 7.09
1973-04-01 7.12
1973-05-01 7.84
1973-06-01 8.49
1973-07-01 10.40
1973-08-01 10.50
1973-09-01 10.78
1973-10-01 10.01
1973-11-01 10.03
1973-12-01 9.95
1974-01-01 9.65
1974-02-01 8.97
1974-03-01 9.35
1974-04-01 10.51
1974-05-01 11.31
1974-06-01 11.93
1974-07-01 12.92
1974-08-01 12.01
1974-09-01 11.34
1974-10-01 10.06
1974-11-01 9.45
1974-12-01 8.53
1975-01-01 7.13
1975-02-01 6.24
1975-03-01 5.54
1975-04-01 5.49
1975-05-01 5.22
1975-06-01 5.55
1975-07-01 6.10
1975-08-01 6.14
1975-09-01 6.24
1975-10-01 5.82
1975-11-01 5.22
1975-12-01 5.20
1976-01-01 4.87
1976-02-01 4.77
1976-03-01 4.84
1976-04-01 4.82
1976-05-01 5.29
1976-06-01 5.48
1976-07-01 5.31
1976-08-01 5.29
1976-09-01 5.25
1976-10-01 5.02
1976-11-01 4.95
1976-12-01 4.65
1977-01-01 4.61
1977-02-01 4.68
1977-03-01 4.69
1977-04-01 4.73
1977-05-01 5.35
1977-06-01 5.39
1977-07-01 5.42
1977-08-01 5.90
1977-09-01 6.14
1977-10-01 6.47
1977-11-01 6.51
1977-12-01 6.56
1978-01-01 6.70
1978-02-01 6.78
1978-03-01 6.79
1978-04-01 6.89
1978-05-01 7.36
1978-06-01 7.60
1978-07-01 7.81
1978-08-01 8.04
1978-09-01 8.45
1978-10-01 8.96
1978-11-01 9.76
1978-12-01 10.03
1979-01-01 10.07
1979-02-01 10.06
1979-03-01 10.09
1979-04-01 10.01
1979-05-01 10.24
1979-06-01 10.29
1979-07-01 10.47
1979-08-01 10.94
1979-09-01 11.43
1979-10-01 13.77
1979-11-01 13.18
1979-12-01 13.78
1980-01-01 13.82
1980-02-01 14.13
1980-03-01 17.19
1980-04-01 17.61
1980-05-01 10.98
1980-06-01 9.47
1980-07-01 9.03
1980-08-01 9.61
1980-09-01 10.87
1980-10-01 12.81
1980-11-01 15.85
1980-12-01 18.90
1981-01-01 19.08
1981-02-01 15.93
1981-03-01 14.70
1981-04-01 15.72
1981-05-01 18.52
1981-06-01 19.10
1981-07-01 19.04
1981-08-01 17.82
1981-09-01 15.87
1981-10-01 15.08
1981-11-01 13.31
1981-12-01 12.37
1982-01-01 13.22
1982-02-01 14.78
1982-03-01 14.68
1982-04-01 14.94
1982-05-01 14.45
1982-06-01 14.15
1982-07-01 12.59
1982-08-01 10.12
1982-09-01 10.31
1982-10-01 9.71
1982-11-01 9.20
1982-12-01 8.95
1983-01-01 8.68
1983-02-01 8.51
1983-03-01 8.77
1983-04-01 8.80
1983-05-01 8.63
1983-06-01 8.98
1983-07-01 9.37
1983-08-01 9.56
1983-09-01 9.45
1983-10-01 9.48
1983-11-01 9.34
1983-12-01 9.47
1984-01-01 9.56
1984-02-01 9.59
1984-03-01 9.91
1984-04-01 10.29
1984-05-01 10.32
1984-06-01 11.06
1984-07-01 11.23
1984-08-01 11.64
1984-09-01 11.30
1984-10-01 9.99
1984-11-01 9.43
1984-12-01 8.38
1985-01-01 8.35
1985-02-01 8.50
1985-03-01 8.58
1985-04-01 8.27
1985-05-01 7.97
1985-06-01 7.53
1985-07-01 7.88
1985-08-01 7.90
1985-09-01 7.92
1985-10-01 7.99
1985-11-01 8.05
1985-12-01 8.27
1986-01-01 8.14
1986-02-01 7.86
1986-03-01 7.48
1986-04-01 6.99
1986-05-01 6.85
1986-06-01 6.92
1986-07-01 6.56
1986-08-01 6.17
1986-09-01 5.89
1986-10-01 5.85
1986-11-01 6.04
1986-12-01 6.91
1987-01-01 6.43
1987-02-01 6.10
1987-03-01 6.13
1987-04-01 6.37
1987-05-01 6.85
1987-06-01 6.73
1987-07-01 6.58
1987-08-01 6.73
1987-09-01 7.22
1987-10-01 7.29
1987-11-01 6.69
1987-12-01 6.77
1988-01-01 6.83
1988-02-01 6.58
1988-03-01 6.58
1988-04-01 6.87
1988-05-01 7.09
1988-06-01 7.51
1988-07-01 7.75
1988-08-01 8.01
1988-09-01 8.19
1988-10-01 8.30
1988-11-01 8.35
1988-12-01 8.76
1989-01-01 9.12
1989-02-01 9.36
1989-03-01 9.85
1989-04-01 9.84
1989-05-01 9.81
1989-06-01 9.53
1989-07-01 9.24
1989-08-01 8.99
1989-09-01 9.02
1989-10-01 8.84
1989-11-01 8.55
1989-12-01 8.45
1990-01-01 8.23
1990-02-01 8.24
1990-03-01 8.28
1990-04-01 8.26
1990-05-01 8.18
1990-06-01 8.29
1990-07-01 8.15
1990-08-01 8.13
1990-09-01 8.20
1990-10-01 8.11
1990-11-01 7.81
1990-12-01 7.31
1991-01-01 6.91
1991-02-01 6.25
1991-03-01 6.12
1991-04-01 5.91
1991-05-01 5.78
1991-06-01 5.90
1991-07-01 5.82
1991-08-01 5.66
1991-09-01 5.45
1991-10-01 5.21
1991-11-01 4.81
1991-12-01 4.43
1992-01-01 4.03
1992-02-01 4.06
1992-03-01 3.98
1992-04-01 3.73
1992-05-01 3.82
1992-06-01 3.76
1992-07-01 3.25
1992-08-01 3.30
1992-09-01 3.22
1992-10-01 3.10
1992-11-01 3.09
1992-12-01 2.92
1993-01-01 3.02
1993-02-01 3.03
1993-03-01 3.07
1993-04-01 2.96
1993-05-01 3.00
1993-06-01 3.04
1993-07-01 3.06
1993-08-01 3.03
1993-09-01 3.09
1993-10-01 2.99
1993-11-01 3.02
1993-12-01 2.96
1994-01-01 3.05
1994-02-01 3.25
1994-03-01 3.34
1994-04-01 3.56
1994-05-01 4.01
1994-06-01 4.25
1994-07-01 4.26
1994-08-01 4.47
1994-09-01 4.73
1994-10-01 4.76
1994-11-01 5.29
1994-12-01 5.45
1995-01-01 5.53
1995-02-01 5.92
1995-03-01 5.98
1995-04-01 6.05
1995-05-01 6.01
1995-06-01 6.00
1995-07-01 5.85
1995-08-01 5.74
1995-09-01 5.80
1995-10-01 5.76
1995-11-01 5.80
1995-12-01 5.60
1996-01-01 5.56
1996-02-01 5.22
1996-03-01 5.31
1996-04-01 5.22
1996-05-01 5.24
1996-06-01 5.27
1996-07-01 5.40
1996-08-01 5.22
1996-09-01 5.30
1996-10-01 5.24
1996-11-01 5.31
1996-12-01 5.29
1997-01-01 5.25
1997-02-01 5.19
1997-03-01 5.39
1997-04-01 5.51
1997-05-01 5.50
1997-06-01 5.56
1997-07-01 5.52
1997-08-01 5.54
1997-09-01 5.54
1997-10-01 5.50
1997-11-01 5.52
1997-12-01 5.50
1998-01-01 5.56
1998-02-01 5.51
1998-03-01 5.49
1998-04-01 5.45
1998-05-01 5.49
1998-06-01 5.56
1998-07-01 5.54
1998-08-01 5.55
1998-09-01 5.51
1998-10-01 5.07
1998-11-01 4.83
1998-12-01 4.68
1999-01-01 4.63
1999-02-01 4.76
1999-03-01 4.81
1999-04-01 4.74
1999-05-01 4.74
1999-06-01 4.76
1999-07-01 4.99
1999-08-01 5.07
1999-09-01 5.22
1999-10-01 5.20
1999-11-01 5.42
1999-12-01 5.30
2000-01-01 5.45
2000-02-01 5.73
2000-03-01 5.85
2000-04-01 6.02
2000-05-01 6.27
2000-06-01 6.53
2000-07-01 6.54
2000-08-01 6.50
2000-09-01 6.52
2000-10-01 6.51
2000-11-01 6.51
2000-12-01 6.40
2001-01-01 5.98
2001-02-01 5.49
2001-03-01 5.31
2001-04-01 4.80
2001-05-01 4.21
2001-06-01 3.97
2001-07-01 3.77
2001-08-01 3.65
2001-09-01 3.07
2001-10-01 2.49
2001-11-01 2.09
2001-12-01 1.82
2002-01-01 1.73
2002-02-01 1.74
2002-03-01 1.73
2002-04-01 1.75
2002-05-01 1.75
2002-06-01 1.75
2002-07-01 1.73
2002-08-01 1.74
2002-09-01 1.75
2002-10-01 1.75
2002-11-01 1.34
2002-12-01 1.24
2003-01-01 1.24
2003-02-01 1.26
2003-03-01 1.25
2003-04-01 1.26
2003-05-01 1.26
2003-06-01 1.22
2003-07-01 1.01
2003-08-01 1.03
2003-09-01 1.01
2003-10-01 1.01
2003-11-01 1.00
2003-12-01 0.98
2004-01-01 1.00
2004-02-01 1.01
2004-03-01 1.00
2004-04-01 1.00
2004-05-01 1.00
2004-06-01 1.03
2004-07-01 1.26
2004-08-01 1.43
2004-09-01 1.61
2004-10-01 1.76
2004-11-01 1.93
2004-12-01 2.16
2005-01-01 2.28
2005-02-01 2.50
2005-03-01 2.63
2005-04-01 2.79
2005-05-01 3.00
2005-06-01 3.04
2005-07-01 3.26
2005-08-01 3.50
2005-09-01 3.62
2005-10-01 3.78
2005-11-01 4.00
2005-12-01 4.16
2006-01-01 4.29
2006-02-01 4.49
2006-03-01 4.59
2006-04-01 4.79
2006-05-01 4.94
2006-06-01 4.99
2006-07-01 5.24
2006-08-01 5.25
2006-09-01 5.25
2006-10-01 5.25
2006-11-01 5.25
2006-12-01 5.24
2007-01-01 5.25
2007-02-01 5.26
2007-03-01 5.26
2007-04-01 5.25
2007-05-01 5.25
2007-06-01 5.25
2007-07-01 5.26
2007-08-01 5.02
2007-09-01 4.94
2007-10-01 4.76
2007-11-01 4.49
2007-12-01 4.24
2008-01-01 3.94
2008-02-01 2.98
2008-03-01 2.61
2008-04-01 2.28
2008-05-01 1.98
2008-06-01 2.00
2008-07-01 2.01
2008-08-01 2.00
2008-09-01 1.81
2008-10-01 0.97
2008-11-01 0.39
2008-12-01 0.16
2009-01-01 0.15
2009-02-01 0.22
2009-03-01 0.18
2009-04-01 0.15
2009-05-01 0.18
2009-06-01 0.21
2009-07-01 0.16
2009-08-01 0.16
2009-09-01 0.15
2009-10-01 0.12
2009-11-01 0.12
2009-12-01 0.12
2010-01-01 0.11
2010-02-01 0.13
2010-03-01 0.16
2010-04-01 0.20
2010-05-01 0.20
2010-06-01 0.18
2010-07-01 0.18
2010-08-01 0.19
2010-09-01 0.19
2010-10-01 0.19
2010-11-01 0.19
2010-12-01 0.18
2011-01-01 0.17
2011-02-01 0.16
2011-03-01 0.14
2011-04-01 0.10
2011-05-01 0.09
2011-06-01 0.09
2011-07-01 0.07
2011-08-01 0.10
2011-09-01 0.08
2011-10-01 0.07
2011-11-01 0.08
2011-12-01 0.07
2012-01-01 0.08
2012-02-01 0.10
2012-03-01 0.13
2012-04-01 0.14
2012-05-01 0.16
2012-06-01 0.16
2012-07-01 0.16
2012-08-01 0.13
2012-09-01 0.14
2012-10-01 0.16
2012-11-01 0.16
2012-12-01 0.16
2013-01-01 0.14
2013-02-01 0.15
2013-03-01 0.14
2013-04-01 0.15
2013-05-01 0.11
2013-06-01 0.09
2013-07-01 0.09
2013-08-01 0.08
2013-09-01 0.08
2013-10-01 0.09
2013-11-01 0.08
2013-12-01 0.09
2014-01-01 0.07
2014-02-01 0.07
2014-03-01 0.08
2014-04-01 0.09
2014-05-01 0.09
2014-06-01 0.10
2014-07-01 0.09
2014-08-01 0.09
2014-09-01 0.09
2014-10-01 0.09
2014-11-01 0.09
2014-12-01 0.12
2015-01-01 0.11
2015-02-01 0.11
2015-03-01 0.11
2015-04-01 0.12
2015-05-01 0.12

Using the data in the Federal Funds Rate tab in the data file, perform the following analysese.

a) Create a new column in the data file with the 5 period moving average series of the Federal Funds rate.

b) Create a new column in the data file with the expontential smoothing series with W=0.25.

c) Plot the three columns against the date.

d) Fit an Autoregressive model to this data, assume that the true model has only one lag in it.

In: Statistics and Probability

Bug-Off Exterminators provides pest control services and sells extermination products manufactured by other companies. The following...

Bug-Off Exterminators provides pest control services and sells extermination products manufactured by other companies. The following six-column table contains the company’s unadjusted trial balance as of December 31, 2018.

BUG-OFF EXTERMINATORS
December 31, 2018
Unadjusted
Trial Balance
Cash $ 15,800
Accounts receivable 4,300
Allowance for doubtful accounts $ 824
Merchandise inventory 11,100
Trucks 30,900
Accum. depreciation—Trucks 0
Equipment 53,000
Accum. depreciation—Equipment 14,000
Accounts payable 4,700
Estimated warranty liability 1,200
Unearned services revenue 0
Interest payable 0
Long-term notes payable 15,000
Common stock 11,000
Retained earnings 48,200
Dividends 11,000
Extermination services revenue 45,000
Interest revenue 860
Sales (of merchandise) 88,211
Cost of goods sold 46,000
Depreciation expense—Trucks 0
Depreciation expense—Equipment 0
Wages expense 33,000
Interest expense 0
Rent expense 7,400
Bad debts expense 0
Miscellaneous expense 1,205
Repairs expense 8,400
Utilities expense 6,890
Warranty expense 0
Totals $ 228,995 $ 228,995

The following information in a through h applies to the company at the end of the current year.

a. The bank reconciliation as of December 31, 2018, includes the following facts.

Cash balance per bank $ 15,100
Cash balance per books 17,000
Outstanding checks 1,800
Deposit in transit 2,450
Interest earned (on bank account) 52
Bank service charges (miscellaneous expense) 15

Reported on the bank statement is a canceled check that the company failed to record. (Information from the bank reconciliation allows you to determine the amount of this check, which is a payment on an account payable.)

b. An examination of customers’ accounts shows that accounts totaling $679 should be written off as uncollectible. Using an aging of receivables, the company determines that the ending balance of the Allowance for Doubtful Accounts should be $700.

c. A truck is purchased and placed in service on January 1, 2018. Its cost is being depreciated with the straight-line method using the following facts and estimates.

Original cost $ 32,000
Expected salvage value 8,000
Useful life (years) 4

d. Two items of equipment (a sprayer and an injector) were purchased and put into service in early January 2016. They are being depreciated with the straight-line method using these facts and estimates.

Sprayer Injector
Original cost $ 27,000 $ 18,000
Expected salvage value 3,000 2,500
Useful life (years) 8 5

e. On August 1, 2018, the company is paid $3,840 cash in advance to provide monthly service for an apartment complex for one year. The company began providing the services in August. When the cash was received, the full amount was credited to the Extermination Services Revenue account.

f. The company offers a warranty for the services it sells. The expected cost of providing warranty service is 2.5% of the extermination services revenue of $42,760 for 2018. No warranty expense has been recorded for 2018. All costs of servicing warranties in 2018 were properly debited to the Estimated Warranty Liability account.

g. The $15,000 long-term note is an 8%, five-year, interest-bearing note with interest payable annually on December 31. The note was signed with First National Bank on December 31, 2018.

h. The ending inventory of merchandise is counted and determined to have a cost of $11,700. Bug-Off uses a perpetual inventory system.

e. The adjusted 2018 ending balances of the Extermination Services Revenue and Unearned Services Revenue accounts.

f. The adjusted 2018 ending balances of the Warranty Expense and the Estimated Warranty Liability accounts.

g. The adjusted 2018 ending balances of the Interest Expense and the Interest Payable accounts.

(Need answers for h-g)

In: Accounting

Which of the following items would be classified as liabilities on a not-for-profit organization’s balance sheet?...

Which of the following items would be classified as liabilities on a not-for-profit organization’s balance sheet? (select ALL that apply)

A. Investments

B. Contingent liability

C. Prepaid expenses

D. Accounts receivable

E. Unearned Revenue

F. Post-employment benefit obligations

In: Accounting

Write a 700- to 1,050-word paper that includes the following: Explain the primary sources of tax...

Write a 700- to 1,050-word paper that includes the following: Explain the primary sources of tax law. Define secondary sources of tax law. Define substantial authority. Describe the role of the courts and the Internal Revenue Service in interpreting and applying the sources of tax law

In: Accounting

As a hospital administrator, what plan including solutions and activities would you present to the Board...

As a hospital administrator, what plan including solutions and activities would you present to the Board of Directors to increase the reputation of the hospital in the community, keeping the physicians, bringing in more financial resources?

Select five goals that would be ethical, realistic, and successful and increase revenue

In: Nursing

Think about the “industry” the company started in, or perhaps which industry has historically generated most...

Think about the “industry” the company started in, or perhaps which industry has historically generated most of its revenue or profits.
Are these acquisitions and new brands related to that industry or something entirely new?
Do their acquisitions indicate a vertical integration strategy –or a diversification strategy?

In: Operations Management