MTSULiveHere is making several apartments available for new leases. Renters will frequently call the staff to...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
MTSULiveHere is making several apartments available for new leases. Renters will frequently call the staff to receive quotes for rental expenses, including electricity and pets. As pet food prices have been fluctuating the last few years, customers have become more conscious of the price per pound and its impact on their total cost of housing. As a potential service to its renters, MTSULiveHere has modified its Rental workbook to include information on its apartments' electricity usage and average amount of food the renter's pets consume. All that remains to be added is a more detailed analysis of the interaction between pet food prices and total cost of housing, and the amount of pet food per week consumed and its impact on the total cost of housing. Complete the following: 1. Open the workbook named Rental.xlsx file and save it as MTSURental(your last name).xlsx. 2. Examine the Analysis worksheet and apply appropriate range names to cells D17:D20. 3. In cells A23:A28, enter the following cities in Tennessee: Murfreesboro, Smyrna, Manchester, Nashville, Franklin, and Woodbury. The values to enter are: Murfreesboro Smyma Mancheste Nashville Franklin Woodbury 146.900 $ 57,753 51,586 $ 58,302 11,038 $ 48,280 670,820 $52,858 83,097 $92,589 2.889 $ 33,333 4. In D23:28, calculate the ratio of each cities' median household income to Murfreesboro's median household income. Murfreesboro will have a ratio of 1 (its income divided by itself), and other cities will be > 1 when the income is higher than Murfreesboro's. Assume that MTSULiveHere keeps the rental rates for its apartments based on the differences in income in the cities as compared to Murfreesboro (meaning that cities with a greater household income will charge more for rent). You decide that you'd like to live in Smyrna. If Murfreesboro charges MTSULiveHere is making several apartments available for new leases. Renters will frequently call the staff to receive quotes for rental expenses, including electricity and pets. As pet food prices have been fluctuating the last few years, customers have become more conscious of the price per pound and its impact on their total cost of housing. As a potential service to its renters, MTSULiveHere has modified its Rental workbook to include information on its apartments' electricity usage and average amount of food the renter's pets consume. All that remains to be added is a more detailed analysis of the interaction between pet food prices and total cost of housing, and the amount of pet food per week consumed and its impact on the total cost of housing. Complete the following: 1. Open the workbook named Rental.xlsx file and save it as MTSURental(your last name).xlsx. 2. Examine the Analysis worksheet and apply appropriate range names to cells D17:D20. 3. In cells A23:A28, enter the following cities in Tennessee: Murfreesboro, Smyrna, Manchester, Nashville, Franklin, and Woodbury. The values to enter are: 146,900 $ 57,753 51,586 $ 58,302 11,038 $ 48,280 670,820 $ 52,858 Murfreesboro Smyma Mancheste Nashville Franklin Woodbury 83,097 $ 92,589 2,889 $ 33,333 4. In D23:28, calculate the ratio of each cities' median household income to Murfreesboro's median household income. Murfreesboro will have a ratio of 1 (its income divided by itself), and other cities will be > 1 when the income is higher than Murfreesboro's. Assume that MTSULiveHere keeps the rental rates for its apartments based on the differences in income in the cities as compared to Murfreesboro (meaning that cities with a greater household income will charge more for rent). You decide that you'd like to live in Smyrna. If Murfreesboro charges $1000 per month for rent, calculate the rental price for Smyrna in cell D7 (use an outside reference for the $1000 base rate, Label in cell F16, the rate in cell G16). 5. Set up the structure of a one variable data table in the marked cells that shows the apartment rental price, electricity charge, pet food expense, and projected housing expense given changes in the average price of pet food from $1.50 to $3.10 by increments of $0.20. 6. Instruct Excel to complete the one-variable data table. 6. Instruct Excel to complete the one-variable data table. HINT: To complete the one-variable data table successfully, be sure to select the correct data table range. If you instruct Excel to complete an incorrect range, you cannot just delete any "extra" results that might have appeared at the bottom or right of the intended data table area. When you try to do so, you will receive the "Cannot change part of a data table” error message. You cannot delete only some results from a filled-in data table; you must delete all results values from a one-variable data table if you want to delete any results. 7. Add headings and basic formatting to the data table so it has a more professional appearance. MTSULiveHere is making several apartments available for new leases. Renters will frequently call the staff to receive quotes for rental expenses, including electricity and pets. As pet food prices have been fluctuating the last few years, customers have become more conscious of the price per pound and its impact on their total cost of housing. As a potential service to its renters, MTSULiveHere has modified its Rental workbook to include information on its apartments' electricity usage and average amount of food the renter's pets consume. All that remains to be added is a more detailed analysis of the interaction between pet food prices and total cost of housing, and the amount of pet food per week consumed and its impact on the total cost of housing. Complete the following: 1. Open the workbook named Rental.xlsx file and save it as MTSURental(your last name).xlsx. 2. Examine the Analysis worksheet and apply appropriate range names to cells D17:D20. 3. In cells A23:A28, enter the following cities in Tennessee: Murfreesboro, Smyrna, Manchester, Nashville, Franklin, and Woodbury. The values to enter are: Murfreesboro Smyma Mancheste Nashville Franklin Woodbury 146.900 $ 57,753 51,586 $ 58,302 11,038 $ 48,280 670,820 $52,858 83,097 $92,589 2.889 $ 33,333 4. In D23:28, calculate the ratio of each cities' median household income to Murfreesboro's median household income. Murfreesboro will have a ratio of 1 (its income divided by itself), and other cities will be > 1 when the income is higher than Murfreesboro's. Assume that MTSULiveHere keeps the rental rates for its apartments based on the differences in income in the cities as compared to Murfreesboro (meaning that cities with a greater household income will charge more for rent). You decide that you'd like to live in Smyrna. If Murfreesboro charges MTSULiveHere is making several apartments available for new leases. Renters will frequently call the staff to receive quotes for rental expenses, including electricity and pets. As pet food prices have been fluctuating the last few years, customers have become more conscious of the price per pound and its impact on their total cost of housing. As a potential service to its renters, MTSULiveHere has modified its Rental workbook to include information on its apartments' electricity usage and average amount of food the renter's pets consume. All that remains to be added is a more detailed analysis of the interaction between pet food prices and total cost of housing, and the amount of pet food per week consumed and its impact on the total cost of housing. Complete the following: 1. Open the workbook named Rental.xlsx file and save it as MTSURental(your last name).xlsx. 2. Examine the Analysis worksheet and apply appropriate range names to cells D17:D20. 3. In cells A23:A28, enter the following cities in Tennessee: Murfreesboro, Smyrna, Manchester, Nashville, Franklin, and Woodbury. The values to enter are: 146,900 $ 57,753 51,586 $ 58,302 11,038 $ 48,280 670,820 $ 52,858 Murfreesboro Smyma Mancheste Nashville Franklin Woodbury 83,097 $ 92,589 2,889 $ 33,333 4. In D23:28, calculate the ratio of each cities' median household income to Murfreesboro's median household income. Murfreesboro will have a ratio of 1 (its income divided by itself), and other cities will be > 1 when the income is higher than Murfreesboro's. Assume that MTSULiveHere keeps the rental rates for its apartments based on the differences in income in the cities as compared to Murfreesboro (meaning that cities with a greater household income will charge more for rent). You decide that you'd like to live in Smyrna. If Murfreesboro charges $1000 per month for rent, calculate the rental price for Smyrna in cell D7 (use an outside reference for the $1000 base rate, Label in cell F16, the rate in cell G16). 5. Set up the structure of a one variable data table in the marked cells that shows the apartment rental price, electricity charge, pet food expense, and projected housing expense given changes in the average price of pet food from $1.50 to $3.10 by increments of $0.20. 6. Instruct Excel to complete the one-variable data table. 6. Instruct Excel to complete the one-variable data table. HINT: To complete the one-variable data table successfully, be sure to select the correct data table range. If you instruct Excel to complete an incorrect range, you cannot just delete any "extra" results that might have appeared at the bottom or right of the intended data table area. When you try to do so, you will receive the "Cannot change part of a data table” error message. You cannot delete only some results from a filled-in data table; you must delete all results values from a one-variable data table if you want to delete any results. 7. Add headings and basic formatting to the data table so it has a more professional appearance.
Expert Answer:
Answer rating: 100% (QA)
Completing the Tasks in Excel Heres how you can complete the tasks in Excel based on the provided context 1 Open a new Excel workbook and save it as MTSURentalyour last namexlsx Open Microsoft Excel C... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these finance questions
-
Executive Transport, Inc. is a company that rents cars, vans, and limos to a wide range of customers. Customers frequently call Executive Transports sales staff to receive quotes for rental expenses....
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
What freedom does an international organisation have in regard to imposing its own approaches to HRM on its operations throughout the world? How can an international organisation, aware of the need...
-
Helium in a steel tank is at 40 psia, 540 R with a volume of 4 ft3. It is used to fill a balloon. When the tank pressure drops to 24 psia the flow of helium stops by itself, if all the helium still...
-
Repeat Exercise 5 for the anxiety measurements. Data from exercise 5 Perform a matched-pairs t test to determine whether there is a significant increase in heart rate from baseline to the prequiz...
-
Erie Co. has most of its business in the United States, except that it exports to Belgium. Its exports were invoiced in euros (Belgiums currency) last year. It has no other economic exposure to...
-
The following is the ending balances of accounts at June 30, 2018 for Excell Company. Additional Information: 1. The short-term investments account includes $18,000 in U.S. treasury bills purchased...
-
What is P(heads or tails)? Simplify your answer and write it as a fraction or whole numb
-
. With the information generated from the following table derivate from the Bureau of Economic Analysis (https://apps.bea.gov/iTable/index_nipa.cfm), please do the regression analysis, with the...
-
The momentum of a photon of energy 1 MeV in kg m/s, will be (a) 7 10-24 (c) 5 x 10-2 (b) 10-22 (d) 0.33 x 106
-
The standard cost card for the single product manufactured by Cutter, Incorporated, is given below: Inputs Direct materials (1) Standard Quantity or Hours 4.5 yards 0.7 hours (2) Standard Price or...
-
Bemidji, Minnesota, needed $3,850,000 for its budget. If total assessed value of property in Bemidji was $353,211,009, what was the tax rate expressed as a percent, per $100, per $1,000, and in...
-
Define what the "medical loss ratio" provision of the Affordable Care Act is. Part 2: Give three (3) examples that would qualify for the medical loss ratio and three (3) examples that would not...
-
Who were the leaders of the moral panic movement and what did they hope to accomplish? How did this approach contribute to the result of the juvenile justice system? What led to the creation of the...
-
What is an autoethnography? An ethnography is a portrait (graph) of a group of people (ethnos). It's a common genre in the fields of anthropology and sociology, since it's a genre that studies human...
-
Sabas Company has 20,000 shares of $100 par, 2% cumulative preferred stock and 100,000 shares of $50 par common stock. The following amounts were distributed as dividends: Year 1: $10,000 Year 2:...
-
Hardin Services Co. experienced the following events in 2016: 1. Provided services on account. 2. Collected cash for accounts receivable. 3. Attempted to collect an account and, when unsuccessful,...
-
What is the main advantage and the main obstacle in using market-based transfer prices?
-
In September, TEE Company, a merchandising firm that sells one product, assembled the following information and estimates to prepare a budget for October. Expected sales are 40,000 units at a price...
-
Variable and fixed costs, profitability of order, opportunity cost Healthy Hearth specializes in lunches for health-conscious people. The company produces a small selection of lunch offerings each...
-
Dominiques Frozen Food Company makes frozen dinners and sells them to retail outlets near London. Dominique has just inherited 10,000 and has decided to invest it in the business. She is trying to...
-
Bastille Corporation produces two grades of wine from grapes that it buys from California growers. It produces and sells roughly 3,000,000 liters per year of a low-cost, high-volume product called...
-
Metro Hospital has been under pressure to keep costs down. Indeed, the hospital administrator has been managing various revenue-producing centres to maximize contributions to the recovery of the...
Study smarter with the SolutionInn App