Many regions in North and South Carolina and Georgia have experienced rapid population growth over the last 10 years. It is expected that the growth will continue over the next 10 years. This has motivated many of the large grocery store chains to build new stores in the region. The Kelley’s Super Grocery Stores Inc. chain is no exception. The director of planning for Kelley’s Super Grocery Stores wants to study adding more stores in this region. He believes there are two main factors that indicate the amount families spend on groceries. The first is their income and the other is the number of people in the family. The director gathered the following sample information.

Food and income are reported in thousands of dollars per year, and the variable size refers to the number of people in the household.

a-1. Develop a correlation matrix. (Round your answers to 3 decimal places. Negative amounts should be indicated by a minus sign.)

b-1. Determine the regression equation. (Round your answer to 3 decimal places.)

b-2. How much does an additional family member add to the amount spent on food? (Round your answer to the nearest dollar amount.)

c-1. What is the value of R²? (Round your answer to 3 decimal places.)

c-2. Complete the ANOVA (Leave no cells blank - be certain to enter "0" wherever required. Round SS, MSto 4 decimal places and F to 2 decimal places.)

c-3. State the decision rule for 0.05 significance level. H₀: = ?₁ = ?₂ = 0; H₁: Not all ?_i's = 0. (Round your answer to 2 decimal places.)

d-1. Complete the table given below. (Leave no cells blank - be certain to enter "0" wherever required. Round Coefficient, SE Coefficient, P to 4 decimal places and T to 2 decimal places.)c-4. Can we reject H₀: = ?₁ = ?₂ = 0?

d-2. Would you consider deleting either of the independent variables?

West Hills Village (WHV) in Rapid City, South Dakota is evaluating a guideline lease agreement on laundry equipment that costs $250,000 and falls into the MACRS three-year class. The home can borrow at an 8 percent rate on a four-year loan if WHV decided to borrow and buy rather than lease. The laundry equipment has a four-year economic life, and its estimated residual value is $50,000 at the end of Year 4. If WHV buys the equipment, it would purchase a maintenance contract which costs $5,000 per year, payable at the beginning of each year. The lease terms, which include maintenance, call for a $71,000 lease payment at the beginning of each year. WNV's tax rate is 40 percent. Should the home lease or buy?

Please show how to do this in excel

Many regions in North and South Carolina and Georgia have experienced rapid population growth over the last 10 years. It is expected that the growth will continue over the next 10 years. This has motivated many of the large grocery store chains to build new stores in the region. The Kelley’s Super Grocery Stores Inc. chain is no exception. The director of planning for Kelley’s Super Grocery Stores wants to study adding more stores in this region. He believes there are two main factors that indicate the amount families spend on groceries. The first is their income and the other is the number of people in the family. The director gathered the following sample information.

Complete the ANOVA (Leave no cells blank - be certain to enter "0" wherever required. Round SS, MSto 4 decimal places and F to 2 decimal places.)

State the decision rule for 0.05 significance level. H₀: = β₁ = β₂ = 0; H₁: Not all β_i's = 0

Complete the table given below. (Leave no cells blank - be certain to enter "0" wherever required. Round Coefficient, SE Coefficient, P to 4 decimal places and T to 2 decimal places.)

Go Party Ltd (GPL) is a successful New Zealand catering company, operating in South Island. It has a balance date of 30 June. During the preparation of the 30 June 2020 financial statements, the following two issues have come into the light. The details of these issues are as follows:

(a) After a wedding party held by a customer in January 2020, 60 people became seriously ill, possibly as a result of food poisoning from food served by GPL. Legal proceedings were commenced seeking damages from GPL. The company lawyers advised that owing to developments in the case, and it was probable that the company would be found liable and the estimated damages were $85,000 that would be material to the company’s reported profits.

(b) On 15 February 2020, the Department of Occupational Health and Safety undertook an audit against the complaints regards to the company’s unsafe storage practices. If found to be negligent by the court, the company will have to pay a fine and incur cleaning costs. At the end of the financial year, the outcome of the audit is unknown. The company directors are of the opinion that there is a 50% chance that Go Party Ltd will be found negligent.

Required: Determine how GPL should treat the above two issues in its financial statements for the year ended 30 June 2020. Include in your answer the criteria as per NZ IAS 37, necessary journal entries (if required) or any disclosure note/s required.

1. police car is traveling south towards the intersection that a robber’s car has just crossed traveling east. The robber’s car is currently traveling 55 mph. The police car’s speed is currently 63 mph. How is the distance between the cars changing when the cop is 1.2 miles from the intersection, and the robber is .5 miles from it? Be sure to answer in a complete sentence.

2. In calm water, an oil spill spreads out in a circular fashion. Suppose the radius, r, of the spill is increasing by 3 feet per minute. How fast is the area, A, of the spill growing when the radius is 10 feet? Be sure to answer in a complete sentence.

3. We want to construct a box whose base is length is 5 times the width.  The material used to build the top and bottom cost $9 per sq. ft. and the material used to build the sides cost $7 per sq. ft.  If the box must have a volume of 75 cu. ft., determine the dimensions that will minimize the cost to build the box.

1. Motion in two dimensions.
   1. A plane is flying due south at 560 km/h. A wind blows the plane from east to west at 95 km/hr (yikes!) Find the plane’s velocity with respect to the ground.
   2. A projectile is shot from the edge of a cliff 258 m above ground level with an initial speed of 95.0 m/s at an angle of 22 degrees with the vertical. Find the time taken by the projectile to hit the ground.
   3. Now find the distance away from the base of the cliff the projectile will hit
   4. Then find the horizontal and vertical components of its velocity just before it hits the ground
   5. Next find, the overall velocity and the angle of the velocity vector with the horizontal
   6. Finally, calculate the maximum height above the cliff top the projectile reaches.
   7. Could the projectile travel any farther? Defend your answer.
   8. BONUS: A boat is moving through still water at a speed of 1.75 m/s. The engine propels the boat perpendicular to the banks. However, there is a strong current of 5.63 m/s that also impacts the boat, and a person is walking aft on the deck of the boat (towards the rear) at a speed of 0.80 m/s. What is the person’s velocity relative to the bank (include an angle)? If the river is 20 m wide, and the boat is 4 m long, will the person reach the back before the boat makes it to shore? How far downstream will the boat drift before it makes it across?

Go Party Ltd (GPL) is a successful New Zealand catering company, operating in South Island. It has a balance date of 30 June. During the preparation of the 30 June 2020 financial statements, the following two issues have come into the light. The details of these issues are as follows:

(a)   After a wedding party held by a customer in January 2020, 60 people became seriously ill, possibly as a result of food poisoning from food served by GPL. Legal proceedings were commenced seeking damages from GPL. The company lawyers advised that owing to developments in the case, and it was probable that the company would be found liable and the estimated damages were $85,000 that would be material to the company’s reported profits.

(b)   On 15 February 2020, the Department of Occupational Health and Safety undertook an audit against the complaints regards to the company’s unsafe storage practices. If found to be negligent by the court, the company will have to pay a fine and incur cleaning costs. At the end of the financial year, the outcome of the audit is unknown. The company directors are of the opinion that there is a 50% chance that Go Party Ltd will be found negligent.

Required:

Determine how GPL should treat the above two issues in its financial statements for the year ended 30 June 2020. Include in your answer the criteria as per NZ IAS 37, necessary journal entries (if required) or any disclosure note/s required.

1.    South Side manufacturing produces a product called A710, a major component of which is called R37. Currently, the company purchases 4,000 units per year of R37 from a supplier at a cost of $ 90 per unit. The company is considering manufacturing R37 and has compiled the following data:

•           This process would require the purchase of a special machine costing $160,000. This machine would be used for four years, at which time it would be sold for $10,000. The machine would be included with other assets in a class with a CCA rate of 20 percent.

• At the end of the second year of operation the machine will require $14,000 upgrades. Upgrades of $15,000, and $ 16,000 will be needed at the end of years 3 and 4.

•           Direct materials for the R37 would consist of 6 kilograms at a cost of $3.00 per kilogram.

•           Direct labour would be three hours per unit of R37, with an average labour rate of $15 per hour (fringe benefit costs average 20 percent).

•           Supervision of the production of R37 would be handled by a manager who is currently paid $50,000 per year. He would continue with his present duties as well as supervising the production of R37 (expected to occupy 20 percent of his time) and would be paid an additional $ 10,000 per year.

•           Variable overhead costs to produce R37 are expected to be $4.00 per direct labour hour per unit.

•           The main factory is rented to a customer for $100,000 per year for 5,000 square metres. The production of R37 should require an area of 1,500 square metres that of this area. The remaining area can still be rented for $ 60,000 per year.

•           Other fixed overhead costs (all cash) would be applied at the rate of $6 per labour hour per unit. The fixed overhead would exist even if R37 is not produced

•           The manufacture of R37 would require an investment in working capital at the beginning of the project of $40,000.

•           The demand for R37 is expected to remain stable at 4,000 units per year during the four years.

•           South Side weighted average cost of capital is 10 percent and the income tax rate is 30 percent.

Required:

1. Should the company continue to purchase outside or manufacture

            internally R37?   Show computations

Role of Technology in Long-Term Care

Using the South University Online Library and the Internet, find three articles describing the role technology will play in addressing the challenges ahead in long-term care. Summarize your findings and based on your learning, respond to the following questions:

• Which challenges in long-term care system remain unmet? Why?
• What changes can we expect to occur with the influx of baby boomers entering into the long-term care system?
• Why do you think technology is important to long-term care? Support your answer with relevant examples.
• What are the pros and cons of the implementation of technology in long-term care? Consider both providers and consumers while describing.
• How does technology improve the type and quality of care received by long-term care consumers?
• How important is the commitment by top management for the use of information technology in long-term care to be successful? Why?
• How can the challenges be proactively addressed as opposed to being reactive?