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
EastWind [94]
2 years ago
7

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

nd event attendance. Use appropriate ranges from the "Past Event" worksheet for your calculations.
Business
1 answer:
rodikova [14]2 years ago
7 0

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)

You might be interested in
You are considering two investment alternatives. The first is a stock that pays quarterly dividends of $0.32 per share and is tr
MrMuchimi

Answer:

The 1-year HPR for the second stock is <u>12.84</u>%. The stock that will provide the better annualized holding period return is <u>Stock 1</u>.

Explanation:

<u>For First stock </u>

Total dividend from first stock = Dividend per share * Number quarters = $0.32 * 2 = $0.64

HPR of first stock = (Total dividend from first stock + (Selling price after six months - Initial selling price per share)) / Initial selling price = ($0.64 + ($31.72 - $27.85)) / $27.85 = 0.1619, or 16.19%

Annualized holding period return of first stock = HPR of first stock * Number 6 months in a year = 16.19% * 2 = 32.38%

<u>For Second stock </u>

Total dividend from second stock = Dividend per share * Number quarters = $0.67 * 4 = $2.68

Since you expect to sell the stock in one year, we have:

Annualized holding period return of second stock = The 1-year HPR for the second stock = (Total dividend from second stock + (Selling price after six months - Initial selling price per share)) / Initial selling price = ($2.68+ ($36.79 - $34.98)) / $34.98 = 0.1284, or 12.84%

Since the Annualized holding period return of first stock of 32.38% is higher than the Annualized holding period return of second stock of 12.84%. the first stock will provide the better annualized holding period return.

The 1-year HPR for the second stock is <u>12.84</u>%. The stock that will provide the better annualized holding period return is <u>Stock 1</u>.

6 0
3 years ago
A pre-concert rehearsal is an example of
Mrrafil [7]

Answer:

Quality control

Explanation:

Six Sigma is a quality business management strategy which helps business organizations to improve the quality of processes, products and services by discovering and eliminating defects, variations or errors. It is a strategic business concept that was developed in 1986 by Motorola.

Under the six sigma approach, any process that doesn't provide customer satisfaction or causes challenges in an organisation's process should be eliminated from the system in order to produce quality products and services. It allows only 3.4 defective features for every million opportunities and as such expects processes to be defect free 99.99966 percent of the time.

Generally, there are two (2) main methods of achieving the six sigma approach;

1. DMAIC: define, measure, analyze, improve and control.

2. DMADV: define, measure, analyze, design and verify.

Hence, a pre-concert rehearsal is an example of quality control because the participants or team members are made to practice their routines so as to master them and prevent mistakes on the day of the concert. Thus, a pre-concert is aimed at getting the best out of a team in order to deliver a quality performance to the audience.

5 0
2 years ago
As an accountant for hartley enterprises, you are responsible for preparing the statement of cash flows. you have transactions f
Ganezh [65]

"Cash flow from financial activities" is the heading." This section of the cash flow statement displays all of your company's financing activity, including equity, loan, and dividend transactions.

<h3>What is cash flow statement?</h3>

A cash flow statement is a financial statement that outlines all cash inflows a company receives from ongoing operations and outside investment sources.

It also includes all cash outflows for business and investment operations over a set period of time.

Thus, "Cash flow from financial activities" is the heading.

For more details about cash flow statement, click here

brainly.com/question/21306581

#SPJ1

5 0
2 years ago
The financial reporting for private not-for-profit entities primarily focuses on: Multiple Choice basic information for the orga
Romashka [77]

Answer: basic information for the organization as a whole.

Explanation:

Private Not-for-profit organization as the term implies, are not operating to make a profit therefore their financial statements will generally not include measures that are aimed at showing profit like profit making organizations.

They will instead focus on talking about the entire organization as whole and what it has done so far in the current period. This is what is required of them by U.S. GAAP.

7 0
3 years ago
"The Marlene Doll Co. uses a process costing system. Consider the following data for Dept. A. UNITS: W-1-P Nov. 1: 8,000 units,
Law Incorporation [45]

Answer:

The Marlene Doll Co.

Weighted-AVerage Method

Cost of production:

COSTS: W-1-P Nov. 1:                    $9,600         $4,800

Costs added in November:           15,600         14,400

Total costs for the month          $25,500       $19,200

Equivalent units of production:

                                       Units   Materials  Conversion

Transferred to Dept B: 12,000     12,000        12,000

W-1-P Nov. 30:               6,000       6,000         3,000

Equivalent units                            18,000        15,000

Cost per equivalent units:

                                            Materials    Conversion

Total costs for the month   $25,500       $19,200

Equivalent units                      18,000         15,000

Cost per equivalent unit       $1.42           $1.28

Costs assigned to:

Units Transferred to Dept B:  $17,040      $15,360              $32,400

                                     (12,000 *$1.42)     (12,000 * $1.28)  

W-1-P Nov. 30:                           8,520           3,840                 12,360

                                     (6,000 *$1.42)     (3,000 * $1.28)

Total costs assigned           $25,560       $19,200              $44,760

 

FIFO Method

Equivalent units of production:

                                                Units   Materials  Conversion

W-1-P Nov. 1:                           8,000      0 (0%)        2,000  (25%)

Units started & completed: 10,000     10,000        10,000

W-1-P Nov. 30:                       6,000      6,000         3,000

Equivalent units                                   16,000        15,000

Cost per equivalent units:

                                            Materials    Conversion

Total costs for the month    $15,600         14,400

Equivalent units                      16,000        15,000

Cost per equivalent unit       $0.975        $0.96

Costs assigned this month to:

Work-in-Process                      $0                 $1,920                $1,920

                                     (0 *$0.975)         (2,000 * $0.96)  

Units completed                      $9,750        $9,600              $19,350

                                     (10,000 *$0.975)   (10,000 * $0.96)  

W-1-P Nov. 30:                           5,850           2,880                 8,730

                                     (6,000 *$0.975)    (3,000 * $0.96)

Total costs assigned            $15,600        $14,400            $30,000

Total costs of:

Units transferred out         $19,350       $16,320         $35,670

W-1-P Nov. 30:                       5,850           2,880              8,730

Total costs                        $25,200       $19,200         $44,400

Explanation:

a) Data and Calculations:

Dept. A. UNITS:

                                        Units   Materials  Conversion

W-1-P Nov. 1:                    8,000      100%           75%

Started in November:   10,000

Transferred to Dept B: 12,000      100%          100%

W-1-P Nov. 30:                6,000      100%           50%

6 0
2 years ago
Other questions:
  • Shaw Company engages Maya Company to produce a large machine, install the machine, and train their employees on the machine. The
    13·1 answer
  • If a new firm was launched to help businesses comply with the affordable care act, that opportunity was created by ________.
    9·1 answer
  • Bill wants to increase his herd of cattle on his farm. Right now, he his herd numbers around 100, and he has 100 acres of his fa
    15·1 answer
  • The global distribution of computing resources raises issues of equity, access, and power. briefly describe one of these issues
    8·1 answer
  • Economic studies have generally found that professional sports players have salaries that
    5·1 answer
  • Which of the following situations might convince an employer to choose a nonqualified retirement plan over a qualified profit-sh
    15·1 answer
  • As the percentage of the consumer's income accounted for by a particular good decreases, demand for the good will:
    15·1 answer
  • Which of the following is a severe and long-lasting economic downturn that is worse and deeper than a recession?
    10·1 answer
  • In each of the following cases, determine how supply or demand shifts and how the equilibrium changes.
    10·1 answer
  • If nominal GDP is $900 billion and, on average, each dollar is spent six times in the economy over a year, then the quantity of
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!