Answer
The answer and procedures of the exercise are attached in the following archives.
Explanation
You will find the procedures, formulas or necessary explanations in the archive attached below. If you have any question ask and I will aclare your doubts kindly.
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)
Organizations typically rely on fixed interval and fixed ratio schedules, such as hourly wages and annual reviews and raises. A fixed interval schedule is when an employer gives an employee a raise or reward after a set amount of time has passed. A fixed ratio schedule is when there is a reinforcement after a certain number of responses has happened.
Answer:
A.
Explanation:
Based on the information provided within the question it can be said that another great department to rotate to would be customer service, so that they can learn how the chemicals are implemented and used by the customer. Doing so would allow them to understand why the customers use them and what kind of implementations would be useful for the customers, which would in term generate more profits.
Answer:
1. The company's profit margin is 13.4% percent.
profit margin = net income / net sales = $45,064 / $336,329 = 13.4%
2. The total asset turnover is 0.82 times.
asset turnover ratio = net sales / average assets = $336,329 / [($387,891 + $432,000)/2] = $336,329 / $409,945.50 = 0.82
3. The equity multiplier is 1.7 times.
equity multiplier = average total assets / average total equity = $409,945.50 / [($205,936 + $275,000)/2] = $409,945.50 / $240,468 = 1.70
4. Using the Du Pont Identity, the company's ROE is 18.68% percent.
ROE = profit margin x asset turnover x equity multiplier (or financial leverage) = 0.134 x 0.82 x 1.7 = 0.1868 = 18.68%