PLEASE HELP ASAP!! (Image is attached)

In the "Input Analysis" section of the spreadsheet model, calculate the correlations between the sales of each type of product a

rodikova [14]

Answer:

The correct formula will be :

=average(past event tab then col in that tab) use this for att, programs, food, and merch

=AVERAGE('Past Events'!C4:C103)

Explanation:

To calculate the correlation between the sales of each kind of product and event attendance, from the Input analysis part of the spreadsheet model.

According to the information provided, in the targeted cell, we will use formula

=Average(data cells)

and for other part of the question is to calculate sales. For this part we can simply use the sum formula, first, we will sum the sales for a single item in past events column than at the end of the past column.

Thus, the correct formula will be :

=average(past event tab then col in that tab) use this for att, programs, food, and merch

=AVERAGE('Past Events'!C4:C103)

7 0

3 years ago

The following December 31, 2021, fiscal year-end account balance information is available for the Stonebridge Corporation:

Dvinal [7]

Answer:

1. $132,600

2. $7,700

3. $25,600

Explanation:

1. Calculation to determine Total current assets

First step is to calculate the Current liabilities using this formula

Current liabilities = salaries payable + accounts playable + accrued interest

Let plug in the formula

Current liabilities= 19000 + 58000 + 1000

Current liabilities= 78000

Now let calculate the Total current assets using this formula

Total current assets = current ratio * current liabilities

Let plug in the formula

Total current assets = 1.7* 78000

Total current assets = $132,600

Therefore Total current assets is $132,600

2. Calculation to determine Short-term investments

Using this formula

Short term investments = Current assets - [cash + accounts receivables + inventory]

Let plug in the formula

Short term investments = 132,600 - [6900 + 39,000 + 79,000]

Short term investments = $7,700

Therefore Short term investments will be $7,700

3. Calculation to determine the Retained earnings

Using this formula

Current assets + fixed assets = Current liabilities + Long term liabilities + paid in capital + retained earnings

Let plug in the

132,600 + 215,000 = 78,000 + 49,000 + 195,000 + Retained earnings

347,600 = 322,000 + retained earnings

Retained earnings = 347,600 - 322,000

Retained earnings = $25,600

Therefore Retained earnings will be $25,600

8 0

3 years ago

Ron Jones has been a trusted employee for over 10 years. He is responsible for ordering merchandise inventory, receiving the inv

ch4aika [34]

Answer:

Segregation of duties.

Explanation:

Segregation of duties -

The concept of segregation of duties is based on the shared responsibilities .

It refers to the method of assigning different person for different task , is referred to as segregation of duties .

It is the fundamental building block for running a business efficiently , in order to reduce any management risk .

In the business it is the major case of any fraud or error , as one person is responsible for maximum duties functioning in the business .

Therefore , it is import to divide various duties .

Hence , from the given scenario of the question,

The correct answer is segregation of duties .

5 0

3 years ago

You are an economist studying the small country of Mardodus. As you look at the data, you see Mardodus has experienced an influx

WINSTONCH [101]

Answer: Natural rate of unemployment will decrease because the productivity growth in the short term has passed up wage growth.

Explanation:

The natural unemployment rate simply means the lowest unemployment rate where the inflation in the economy is stable.

Based on the information given in the question, if the natural unemployment rate for this time frame.is analyzed, the natural rate of unemployment will reduce due to the fact that the productivity growth in the short term has passed up wage growth.

3 0

3 years ago

When an individual consumes high protein food while drinking, the alcohol

valentina_108 [34]

When an individual consumes high protein food while drinking, the alcohol remains in the stomach longer

Hope this helps!

6 0

3 years ago