Use the information above to forecast the next two year revenue for Exxon Mobil. Based your forecasts on the average of the actual revenue growth between 2009 to 2010 and 2010 to 2011.

Use the information above to forecast the next two years cost of revenue and selling, general, and administrative expenses for Exxon Mobil. Base your forecasts on the actual relationship between these expenses and revenue for 2011.

The National Basketball League is a professional sports league in North America. Each team in the league must participate the revenue sharing system. For the purposes of the revenue sharing plan, there are no limits to the amount each team may contribute to the plan. Each team is subject to a receipt limits based their designated market area (DMA). For teams with a DMA between 1.5-2.249 households, the final receipt limit is set at 75% of the initial receipt; for a DMA of 2.5-3.249M, the final receipt limit is set at 25% of the initial receipt; for DMAs over 3.25M, the final receipt limit is set at 0%.

If a team rents their arena, items such as fixed signage, temporary signage, and leased luxury suites are included in the plan at 100%. If the team controls their arena with no cotenants, the team must include these items at 70%. For a team that has another professional team as a cotenant, the respective inclusion percentage is 40%. If luxury suites are sold on an individual event-basis, the revenue that is generated from NBL-games is included in the revenue sharing plan at 100% (revenue generated from suite sales to other events are not subject to revenue sharing). Post-season revenues and expenses are excluded from the revenue sharing calculation. Player salary and other expenses are taken at the league average, which were $86M and $7.2M respectively for the 2017-18 year.

Each team in the league plays 82 regular season games a year, half of which are home. The league’s national television deal provides each team with $30M annually in revenue with $500k in associated expenses. Additional league managed items such a licensing provided the teams with $17M in revenue and $3M in expenses. Each team also received a $900k post-season distribution from the league.

If there is no inclusion percentage specified, items are included in the revenue sharing plan at 100%.

Team A

Team A is an arena controller with an NHL cotenant. The team has 3.0M households in their DMA. The team has a related party media deal worth $35M annually which took effect for the 2017-18 season. The fair market value for the media rights has been valued at $40M for the 2017-18 season. The average gate attendance per game was 15,100 people. The team had one of the highest average ticket prices in the league at $103 and a novelties and concession per cap of $7.25. The team’s associated gate expenses were $1.65M and concessions expenses totalled $1.25M. The team also leases 20 suites for a total of $6M per year. Since the team had 5 suites that did not have a lease holder in the 2017-18 season, they were able to sell these unleased suites on a single event basis. Throughout the 2017-18 season, the team generated $1.6M from selling the unleased suites, where $0.9M came from suite sales to NBL games. Fixed signage inventory generated $4M with an 85% margin, while temp signage revenue was $3M with a 90% margin. The team’s main expenses were player salaries ($85M), basketball operations ($15M), G&A ($10M), and other expenses ($2.4M). The team has been in a rebuilding phase and has not qualified for the playoffs the past three seasons.

Team B

Team B is an arena renter. The team has 1.85M households in their DMA. The team signed a local cable deal worth $25M annually. The deal, which took effect for the 2015-16 season, stipulated that the $25M fee was based on the television network broadcasting 60 games. However, the team did not fulfil its obligations as the network only had access to 58 games for 2017-18 so the team’s revenue was adjusted proportionally.

The average gate attendance per game was 13,400 people. The team’s average ticket price in the league was $90 and a novelties and concession per cap of $6.25. The team must pay their concessionaire $2.95 per transaction. The team also leases 22 suites for a total of $6.65M per year. Fixed signage inventory generated $3M with a 75% margin, while temp signage revenue was $4M with a 90% margin. The team has been successful the past few seasons, making it to the second round of playoffs in 2017-18, earning net revenues of $8.6M. The team’s largest expenses were player salaries ($93M), basketball operations ($32M), G&A ($4M), and other expenses ($3.2M). The team also had expenses tied to gate receipts where they had a 90% margin.

Assignment

Based on the information above, first create a P&L for each team for the 2017-18 season. Then apply the revenue sharing plan criteria noted above to determine the P&L amounts subject to revenue sharing.

A student interested in alternative sleep aids has heard that valerian root, melatonin and 5-htp have very few side effects and may be able to help with her recent insomnia. She decides to run a little experiment with her sorority sisters to determine which of the three makes people fall asleep the fastest. She randomly assigns her twelve sisters to one of three sleep aid groups and has each consume a similar dosage just before getting in to bed. A video camera in each room allows her to record the amount of time, in minutes it takes each sister to fall asleep. The data is below.

Identify the independent variable -

and the dependent variable in this study-

Then also determine how many levels (conditions) of the IV there are-

State the null hypothesis and alternative hypothesis in words-

Calculate the degrees of freedom within groups

the degrees of freedom between groups

and determine the F critical value using an alpha level of α = .05

At this point, knowing the F-test and F-critical values, what conclusion can be made

Calculate R 2and explain what the calculated value tells us regarding the effectiveness of the sleep aids.

Calculate the F c o n t r a s t post-hoc tests for each of the three sleep aid comparisons and determine the F c r i t i c a l value for the contrast (use an α= .05).

1. Valerian - Melatonin =   

2. Valerian - 5htp =

3. Melatonin - 5htp =

Given the calculations of your F c o n t r a s t s in the previous question, what conclusion should one make regarding the effectiveness of the three sleep aides used in this study?

The income statement for The TJX Companies, Inc., follows.

Assume that the combined federal and state statutory tax rate is 38.9%.

a. Compute NOPAT using the formula: NOPAT = Net income + NNE.

Round to the nearest whole number.  

b. Compute NOPAT using the formula: NOPAT = NOPBT − Tax on operating profit.

Round to the nearest whole number.

Please use the following information for Questions 2, 3, and 4.

To determine whether there was a relationship between the region of the world that you live in and the amount of beer that you drink, suppose we took 3 samples of 25 people per region from Asia, Europe and America.

2) If we let µ₁, µ₂, and µ₃ be the average calcium intake per day in milligrams for people with diagnosed osteopenia, osteoporosis or neither (healthy controls), respectively, the appropriate hypotheses in this case are:

a) H₀: μ₁ = μ₂ = μ₃

H_a: μ₁, μ₂, μ₃, are not all equal

b) H₀: μ₁, μ₂, μ₃, are not all equal

H_a: μ₁ = μ₂ = μ₃

c) H₀: μ₁ ≠ μ₂ ≠ μ₃

H_a: μ₁ = μ₂ = μ₃

d) None of the above are correct.

3) Here are the three sample standard deviations for the calcium intake for the three groups (osteopenia, osteoporosis or neither (healthy controls)):

Based on this information, do the data meet the condition of equal population standard deviations for the use of the ANOVA?

a) Yes, because 287.7 - 147.2 < 2.

b) Yes, because 287.7147.2<2287.7147.2<2.

c) No, because 287.7 - 147.2 > 2.

d) No, because the standard deviations are not equal.

4)

The analysis was run on the data and the following output was obtained:
ANOVA table

Based on this information, we :

a) Fail to reject the H₀ and conclude that the data do not provide sufficient evidence that there is a relationship between calcium intake and bone health.

b) Fail to reject the H₀ and conclude that the data provide strong evidence that the three means (representing calcium intake and bone health) are not all equal.

c) Reject the H₀ and conclude that the data provide strong evidence that there is a relationship between between calcium intake and bone health.

d) Reject the H₀ and conclude that the data provide strong evidence that calcium intake is related to bone health in the following way: the mean for healthy people is higher than the mean for people with Osteopenia, which in turn is higher than that for people with Osteoporosis.

Joshua company had the following information in 2016.

Accts Rec 12/31/16.....$15000

Allowance for uncollected account 12/31/16 (before adjustment).....$950

credit service revenue during 2016.....$45000

Cash service revenue during 2016.....$15000

Collections from customers on account during 2016.......$45000

If uncollectible accounts are determined by the​ aging-of-receivables method to be $ 1 240​, the uncollectible account expense for 2016 would be $ 290. Using the​ aging-of-receivables method, the balance of the Allowance account after the adjusting entry at​ year-end 2016 would be

1. A company produces electric motors for use in home appliances. One of the company’s production managers is interested in examining the relationship between the dollars spent per month in inspecting finished motor products (X) and the number of motors produced during that month that were returned by dissatisfied customers (Y). He has collected the data in the file P11_32.xlsx to explore this relationship for the past 36 months.

a. Estimate a simple linear regression equation using the given data.

If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300)

Q1: The predicted change in number of motors returned that is associated with an increase of $1,000 in inspection expenditures: (_____________)

A bank randomly selected 249 checking account customers and found that 113 of them also had savings accounts at this same bank. Construct a 95% confidence interval for the true proportion of checking account customers who also have savings accounts. (Round your answers to three decimal places.)

Choose three types of communications and describe each briefly.

Which forms of communications do you prefer as a consumer? Why?

If you owned a small retail store selling flowers (like an FTD florist), how would you communicate with customers and prospective customers using the e-marketing communications on the Australian government web site.

Santana Rey expects second-quarter 2020 sales of Business Solutions’s line of computer furniture to be the same as the first quarter’s sales (reported below) without any changes in strategy. Monthly sales averaged 39 desk units (sales price of $1,200) and 15 chairs (sales price of $450).

* Reflects revenue and expense activity only related to the computer furniture segment.
† Revenue: (117 desks × $1,200) + (45 chairs × $450) = $140,400 + $20,250 = $160,650
‡ Cost of goods sold: (117 desks × $700) + (45 chairs × $200) + $28,500 = $119,400

Santana Rey believes that sales will increase each month for the next three months (April, 47 desks, 27 chairs; May, 51 desks, 30 chairs; June, 55 desks, 33 chairs) if selling prices are reduced to $1,080 for desks and $400 for chairs and advertising expenses are increased by 10% and remain at that level for all three months. The products’ variable cost will remain at $700 for desks and $200 for chairs. The sales staff will continue to earn a 10% commission, the fixed manufacturing costs per month will remain at $9,500 and other fixed expenses will remain at $5,500 per month.

Required:
1. Prepare budgeted income statements for the computer furniture segment for each of the months of April, May, and June that show the expected results from implementing the proposed changes. Use a three-column format, with one column for each month.
2. Recommend whether Santana should implement the proposed changes. Hint: Compare quarterly income for the proposed April-May-June period to the quarterly income for the January-February-March period.