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]
3 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]3 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
Jones Company received $2,200 in cash during March for Service Revenue for a job that will be completed in May. This job would b
Katena32 [7]

Answer:

Explanation:

The journal entry is shown below:

Cash A/c Dr $2,200

  To Service revenue $2,200

(Being cash is received)

Since the cash is received so we debited the cash account and credited the service revenue account as the service is completed which create an income for the business organization.

We do not write unearned service revenue as the amount is actually received from the customer

7 0
3 years ago
LeCompte Corp. has $312,900 of assets, and it uses only common equity capital (zero debt). Its sales for the last year were $620
Gnom [1K]

Answer:

LeCompte Corp.

The profit margin that LeCompte Corp. would need in order to achieve the 15% ROE, holding everything else constant is:

A) 7.57%.

Explanation:

a) Data and Calculations:

Assets = $312,900

Common Equity = Assets = $312,900

Sales for the last year = $620,000

Net income after taxes = $24,655

Expected return on equity (ROE) = 15%

ROE (in amount) =  $312,900 * 15% = $46,935

Profit margin = Returns on Equity/ Sales * 100

= $46,935/$620,000 * 100

= 7.57%

b) The expected returns on equity in dollars is equal to the net income.  Therefore, we can use the ROE to calculate the profit margin.  The profit margin expresses the relationship between sales and profit.  It shows the profit made from each dollar sales.

4 0
2 years ago
Write the planning process for a profession.​
Goryan [66]

Answer:

1) Explore career options

2) conduct field research

3) determine your job target

4) Build your credentialsand resume

5) Prepare for your job search

4 0
2 years ago
At Dreher Products, management establishes monthly goals for its manufacturing teams but team members are free to determine work
sergey [27]

Answer:

Autonomy

Explanation:

correct answer is Autonomy because Autonomy is the ability to make informed, immoral decision-making, and especially in moral psychology and moral psychology and morality. Autonomous bodies or organizations are autonomous or autonomous. Autonomy can also be defined from the human resources perspective, where it refers to the level of discretion given to an employee in his or her work.

5 0
3 years ago
TP4.
timofeeve [1]

Answer:

There would be no under-applied or over-applied overhead since the overhead applied will be equal to budgeted overhead.

Explanation:

Overhead application rate is the ratio of budgeted overhead to budgeted activity level. Overhead applied is overhead application rate multiplied by actual activity level. Under/over-applied overhead is the difference between overhead applied and budgeted overhead.

7 0
3 years ago
Other questions:
  • What is the likely impact of perquisites on the employees who receive them?
    5·1 answer
  • Maria, an active partner in the Grifton/Blum CPA firm partnership, receives an annual bonus of 10% of partnership net income aft
    10·1 answer
  • Assembly department of Zahra Technologies had 200 units as work in process at the beginning of the month. These units were 45% c
    10·1 answer
  • Marketing research conducted by a consumer products producer reveals that some consumers buy toothpaste to whiten their​ teeth,
    15·1 answer
  • On July 1m 2017, Ling Co. pays $12,400 to Marsh Insurance Co., for a 2-year insurance contract. Both companies have fiscal years
    15·1 answer
  • Milton Corp. has beginning retained earnings of $800. During the year Milton had $2,000 of revenues and $900 in expenses. Milton
    11·1 answer
  • When Larry purchased a Jet Ski personal watercraft for $4,999, he was also given free financing and three hours of free lessons
    15·1 answer
  • You have chosen to take a trip during spring break. If you had not gone, you would either have worked at a temporary job or stud
    11·1 answer
  • In a market there is a shortage of a good. What change would cause the market to come to an equilibrium?
    11·1 answer
  • uppose that Rowan, Inc. builds a high-speed, magnetically powered transportation system from New York to Los Angeles, which is t
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!