Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Estimating Utilities at ABCLiveHere ( MO - 2 . 4 ) ABCLiveHere is making several apartments available for new leases. Renters will frequently call the

Estimating Utilities at ABCLiveHere (MO-2.4)
ABCLiveHere 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, ABCLiveHere has modified its Rental workbook to include information on its apartments electricity usage and average amount of food the renters 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 ABCRental(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:
4. In D23:28, calculate the ratio of each cities median household income to Murfreesboros 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 Murfreesboros. Assume that ABCLiveHere 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 youd 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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transact SQL Cookbook Help For Database Programmers

Authors: Ales Spetic, Jonathan Gennick

1st Edition

1565927567, 978-1565927568

More Books

Students also viewed these Databases questions