1. 8. BONUS: Nilam Patel is the primary stockholder in two hotel corporations. One corporation owns a 90‐room economy property located in the suburbs of a large western town. The other corporation is a 350‐room full‐service convention hotel in the downtown city center for which Nilam has employed a management company to operate the property. Nilam is preparing balance sheets for both properties using a common size format. Complete the two balance sheets. Then answer the questions that follow.

   Nilam Patel's Two Hotel's Balance Sheets

   	December 31		Common Size
   	90‐Room Property	350‐Room Property	90‐Room Property (%)	350‐Room Property (%)
   ASSETS
   Current Assets
   Cash
   Cash in House Banks		$86,000
   Cash in Demand Deposits	85,000	330,250
   Total Cash	103,500	416,250
   Short‐Term Investments	56,000	165,000
   Receivables
   Accounts Receivable	150,000	327,150
   Notes Receivable	35,000	136,250
   Other	750	30,800
   Total Receivables	185,750	494,200
   Less Allowance for Doubtful Accounts	19,250
   Net Receivables	166,500	431,900	1.4	1.1
   Due from Management Company	—	50,000	0.0	0.1
   Food Inventories	15,125	69,750	0.1	0.2
   Beverage Inventories	—	42,550	0.0	0.1
   Gift Shop Inventories	300	6,950	0.0	0.0
   Supplies Inventories	6,550	13,550	0.1	0.0
   Prepaid Expenses	56,000	120,100	0.5	0.3
   Deferred Income Taxes—Current	48,000	135,000	0.4	0.3
   Total Current Assets
   Investments	72,500	274,150	0.6	0.7
   Property and Equipment
   Land	2,000,000	8,450,000
   Building	6,500,000	18,500,000
   Leaseholds and Leasehold improvements	2,037,250	5,850,000
   Furnishings and Equipment	1,288,000	3,105,000
   Total Property and Equipment	11,825,250	35,905,000
   Less Accumulated Depreciation and Amortization	575,000	2,575,000
   Net Property and Equipment	11,250,250	38,480,000
   Other Assets
   Intangible Assets	—	75,000	0.0	0.2
   Deferred Income Taxes—Non‐current	66,000	158,000	0.6	0.4
   Operating Equipment	35,100	111,000	0.3	0.3
   Restricted Cash	25,000	95,000	0.2	0.2
   Total Other Assets	126,100	439,000	1.1	1.1
   TOTAL ASSETS			100.0	100.0
   LIABILITIES AND OWNERS' EQUITY
   Current Liabilities
   Notes Payable
   Banks	17,500	116,250	0.1	0.3
   Others	8,000	17,500	0.1	0.0
   Total Notes Payable	25,500	133,750	0.2	0.3
   Accounts Payable	2,500	125,100
   Accrued Expenses	45,000	42,500
   Advance Deposits	500	42,250
   Income Taxes Payable	15,000	78,000
   Deferred Income Taxes—Current	40,000	235,000
   Current Maturities of Long‐Term Debt	420,000
   Other	50,000	58,000
   Total Current Liabilities	598,500	2,399,600	5.0	5.9
   Long‐term Debt, Net of Current Maturities
   Mortgage Note		24,383,030
   Obligations Under Capital Leases	18,000	385,000	0.2	0.9
   Total Long‐Term Liabilities	6,868,000
   Owners' Equity
   Common Stock	500,000	2,000,000
   Paid in Capital		8,711,500
   Retained Earnings	879,325	2,765,070
   Total Owners' Equity	4,434,325	13,476,570
   TOTAL LIABILITIES AND OWNERS' EQUITY			100	100

   1. What was the amount of cash in the 90‐room property's Cash in House Banks account at year end?
   2. What is the amount of Allowance for Doubtful Accounts in the 350‐room property? Do you think it is excessive? Explain your answer?
   3. What would explain the lack of a beverage inventory value in the 90‐room hotel?
   4. What was the dollar amount of Total Assets in the 90‐room hotel?
   5. What was the dollar amount of Total Assets in the 350‐room hotel?
   6. What was the dollar amount of Current Maturities of Long‐Term Debt in the 350‐room property? Why is that amount likely so much higher than for the 90‐room property?
   7. What was the dollar amount of Paid in Capital for the 90‐room property?
   8. What is the Owners' Equity percentage of Total Assets in the 90‐room property? What is it in the 350‐room property?

Consider the following data for two variables, x and y.

(a)

Compute the standardized residuals for these data. (Round your answers to two decimal places.)

Do the data include any outliers? Explain. (Round your answers to two decimal places.)

The standardized residual with the largest absolute value is  , corresponding to y_i =  . Since this residual is  ---Select--- less than −2 between −2 and +2 greater than +2 , it  ---Select--- is definitely not could be an outlier.

(b)

Plot the standardized residuals against ŷ.

A standardized residual plot has 7 points plotted on it. The horizontal axis ranges from 105 to 140 and is labeled: y hat. The vertical axis ranges from −2.5 to 2.5 and is labeled: Standardized Residuals. There is a horizontal line that spans the graph at 0 on the vertical axis. There are 4 points below the line and 3 points above it. 6 of the points appear to vary randomly between −0.8 to 0.1 on the vertical axis; however, the maximum residual is at approximately (121, 2.2).

A standardized residual plot has 7 points plotted on it. The horizontal axis ranges from 105 to 140 and is labeled: y hat. The vertical axis ranges from −2.5 to 2.5 and is labeled: Standardized Residuals. There is a horizontal line that spans the graph at 0 on the vertical axis. There are 3 points below the line and 4 points above it. 6 of the points appear to vary randomly between −0.1 to 0.8 on the vertical axis; however, the minimum residual is at approximately (121, −2.2).

A standardized residual plot has 7 points plotted on it. The horizontal axis ranges from 105 to 140 and is labeled: y hat. The vertical axis ranges from −2.5 to 2.5 and is labeled: Standardized Residuals. There is a horizontal line that spans the graph at 0 on the vertical axis. There are 4 points below the line and 3 points above it. The points are plotted from left to right in a downward, diagonal direction starting from the upper left corner of the graph. Most of the points are between −0.8 to 0.1 on the vertical axis; however, the maximum residual is at approximately (112, 2.2).

A standardized residual plot has 7 points plotted on it. The horizontal axis ranges from 105 to 140 and is labeled: y hat. The vertical axis ranges from −2.5 to 2.5 and is labeled: Standardized Residuals. There is a horizontal line that spans the graph at 0 on the vertical axis. There are 4 points below the line and 3 points above it. The points are plotted from left to right in an upward, diagonal direction starting from the lower left corner of the graph. Most of the points are between −0.8 to 0.1 on the vertical axis; however, the maximum residual is at approximately (134, 2.2).

Does this plot reveal any outliers?

The plot shows no possible outliers.The plot shows one possible outlier.    The plot shows two possible outliers.The plot shows more than two possible outliers.

(c)

Develop a scatter diagram for these data.

A scatter diagram has 7 points plotted on it. The horizontal axis ranges from 100 to 180 and is labeled: x. The vertical axis ranges from 90 to 150 and is labeled: y. The points are plotted from left to right in an upward, diagonal direction starting from the lower left corner of the diagram. The points are between 110 to 175 on the horizontal axis and between 105 to 145 on the vertical axis. Most of the points are plotted reasonably close together, but the fourth point from the left is noticeably higher than the others at 145 on the vertical axis.

A scatter diagram has 7 points plotted on it. The horizontal axis ranges from 100 to 180 and is labeled: x. The vertical axis ranges from 90 to 150 and is labeled: y. The points are plotted from left to right in a downward, diagonal direction starting from the upper left corner of the diagram. The points are between 110 to 175 on the horizontal axis and between 105 to 145 on the vertical axis. The points are fairly scattered, though the seventh point from left is slightly farther away from the others at 120 on the vertical axis.

A scatter diagram has 7 points plotted on it. The horizontal axis ranges from 100 to 180 and is labeled: x. The vertical axis ranges from 90 to 150 and is labeled: y. The points are plotted from left to right in a downward, diagonal direction starting from the upper left corner of the diagram. The points are between 110 to 175 on the horizontal axis and between 105 to 145 on the vertical axis. The points are fairly scattered, though the second point from the left is noticeably farther away from the others at 105 on the vertical axis.

A scatter diagram has 7 points plotted on it. The horizontal axis ranges from 100 to 180 and is labeled: x. The vertical axis ranges from 90 to 150 and is labeled: y. The points are plotted from left to right in an upward, diagonal direction starting from the lower left corner of the diagram. The points are between 110 to 175 on the horizontal axis and between 105 to 145 on the vertical axis. The points are reasonably close together and each consecutive point is higher than or just as high on the the diagram as the previous point.

Does the scatter diagram indicate any outliers in the data?

The diagram indicates that there are no possible outliers.The diagram indicates that there is one possible outlier.    The diagram indicates that there are two possible outliers.The diagram indicates that there are more than two possible outliers.

In general, what implications does this finding have for simple linear regression?

For simple linear regression, we must calculate standardized residuals, plot a standardized residual plot, and construct a scatter diagram to identify an outlier.For simple linear regression, we can determine an outlier by looking at the scatter diagram.     For simple linear regression, it is impossible to determine whether there is an outlier using standardized residuals, a standardized residual plot, or a scatter diagram.

Iconic memory is a type of memory that holds visual information for about half a second (0.5 seconds). To demonstrate this type of memory, participants were shown three rows of four letters for 50 milliseconds. They were then asked to recall as many letters as possible, with a 0-, 0.5-, or 1.0-second delay before responding. Researchers hypothesized that longer delays would result in poorer recall. The number of letters correctly recalled is given in the table.

(a) Complete the F-table. (Round your values for MS and F to two decimal places.)

(b) Compute Tukey's HSD post hoc test and interpret the results. (Assume alpha equal to 0.05. Round your answer to two decimal places.)

The critical value is  for each pairwise comparison.

Which of the comparisons had significant differences? (Select all that apply.)

1)Recall following no delay was significantly different from recall following a half second delay.

2)Recall following no delay was significantly different from recall following a one second delay.

3)The null hypothesis of no difference should be retained because none of the pairwise comparisons demonstrate a significant difference.

4)Recall following a half second delay was significantly different from recall following a one second delay.

A few months ago, the upper management at a large corporation decided they wanted to make major changes in the organization. Leadership is concerned that employees may be resistant to the change, and they want to find out if there is a change management method that would help employees accept change more effectively and keep employee satisfaction high. Two methods they have considered are the ADKAR Framework and the Prosci Change Management Methodology. The company wants to implement a small change in two departments before they make any major organization changes and would like to test the methods. The corporation uses the Devine Company to measure employee satisfaction with an anonymous survey.

• • What is the significance level of the comparison?
  • What was the alpha level you identified in Week 3?
  • What was the means and variance for each variable?
  • What was the test statistic?
  • What was the critical value for both the one- and two-tailed test?
  • Was your test one-tailed or two-tailed?
  • Were you able to reject the null hypothesis? In other words, did you prove there was a difference?
• Talk about what these results mean in everyday language and in context to your chosen scenario.

Make a recommendation based on the findings

Analyze the data from Part 1 using Microsoft^® Excel^® software.

Example of Output You Would Use to Answer These Questions

THANK YOU!!!!

In the following study, researchers wanted to determine if a relationship existed between the minutes of light therapy a patient receives and the patient’s reported score on a seasonal affective disorder (SAD) test.

1. What is ΣX, What is ΣY, What is (ΣX)2, What is (ΣY)2, What is (ΣX2), What is (ΣY2), What is (ΣXY), What is (ΣX)(ΣY), What is N? What is r (round to two decimal places)?

2. What is the slope (b) of the regression line made by this data (round to two decimal places)?

What is the Y intercept (a) of the regression line made by this data (round to two decimal places)?

Given a stress level of 7, what is the predicted SAD test score (round to two decimal places)?

What is the error of participant 6's SAD test score (round to two decimal places)?

3. What is SY (round to two decimal places)? What is the standard error of the estimate (round to two decimal places)?What is the variance in test scores accounted for by variance in stress levels (round to two decimal places)? For this data set, what is the coefficient of alienation?

4. What's the slope of this data (round to two decimal places)? What's the Y intercept (round to two decimal places)?

What's the predicted test score for a stress level of 10 (round to two decimal places)? What's the error of participant 5's score (round to two decimal places)? What's the standard error of the estimate? What is the coefficient of determination?

Explain SEVEN (7) conditions necessary for a perfectly competitive market to exist. (7)

Break-Even in Sales Revenue, Variable-Costing Ratio, Contribution Margin Ratio, Margin of Safety

Hammond Company runs a driving range and golf shop. The budgeted income statement for the coming year is as follows.

Required:

1. What is Hammond’s variable cost ratio? Enter your answer as a decimal value rounded to two decimal places.

What is the contribution margin ratio? Enter your answer as a decimal value rounded to two decimal places. (Express as a decimal-based amount rather than a whole percent.)

2. Suppose Hammond’s actual revenues are $200,000 greater than budgeted. By how much will before-tax profits increase? Calculate the answer without preparing a new income statement.
$

3. How much sales revenue must Hammond earn in order to break even? Round your answer to the nearest dollar.
$

What is the expected margin of safety? Round your answer to the nearest dollar.
$

4. How much sales revenue must Hammond generate to earn a before-tax profit of $130,000? Round your answer to the nearest dollar.
$

How much sales revenue must Hammond generate to earn an after-tax profit of $90,000? Round your answer to the nearest dollar.
$

Prepare a contribution margin income statement to verify the accuracy of your last answer. Round your answers to the nearest dollar.

Assume in each case that the selling expenses are $8 per unit and that the normal profit is $5 per unit. Calculate the limits for each case. Then enter the amount that should be used for lower of cost or market.

How would I put this in a balance sheet and income statement?

You have been approached by a person who would like you to help him organize his financial information into financial statements in preparation for filing income taxes. He has a goat operation that runs approximately 350 does who have kids yearly. He sells the kids to other breeders and the fleece/wool from her goats to an out-of-state fiber mill.

He needs to put together Balance Sheets and Income Sheets for the last two yearends - (2017 and 2018).

1. Use the following information to create 1) a Balance Sheet for yearends 2017 and 2018 and 2) an Income Statement for 2018:

• He took out a mortgage on the farm several years ago. He makes annual principle payments of $12,000 and interest payments of 6% of the balance of the loan. He makes payments on Dec 31st each year. His balance as of December 31, 2016 was $275,000.

• As of December 31, 2017, he had accounts receivable from his primary fleece buyer of $18,000, and from the wool mill of $3,200. He also had an account payable with the local farm supply store with a balance of $5,300, which he charged all his feed and supplies to. As of December 31, 2018, his lamb buyer owed him $24,000 and the wool mill owed $2,500. His farm store account decreased to $3,200.

EZ-Seat, Inc., manufactures two types of reclining chairs, Standard and Ergo. Ergo provides support for the body through a complex set of sensors and requires great care in manufacturing to avoid damage to the material and frame. Standard is a conventional recliner, uses standard materials, and is simpler to manufacture. EZ-Seat’s results for the last fiscal year are shown in the statement below.

EZ-Seat currently uses labor costs to allocate all overhead, but management is considering implementing an activity-based costing system. After interviewing the sales and production staff, management decides to allocate administrative costs on the basis of direct labor costs but to use the following bases to allocate the remaining costs:

Required:

a. Complete the income statement using the preceding activity bases. (Do not round intermediate calculations.)

c. Restate the income statement for EZ-Seat using direct labor costs as the only overhead allocation base. (Do not round intermediate calculations.)