The weekly price at an extended-staty (renting by the week for business traveler
ID: 2419724 • Letter: T
Question
The weekly price at an extended-staty (renting by the week for business travelers) is $900. Operating costs average $25,000 per month, regardless of the number of rooms rented. Construct a spreadsheet model to determine the profit if 40 rooms are rented. The manager has oberved that the number of rooms rented during a given week varies between 32 and 50 (the total number of rooms availabloe).
A. Use data tables to evaluate the profit for this range of unit rentals.
Show all work, please. So I can see how you got answer.
Demographic Data Unemployment Cost of Living Population Metropolitan Area State (July 1999) 1999 - US Avg = 100 (July 1999) ANCHORAGE AK 3.60% 125.90 257,808 BIRMINGHAM AL 2.70% 99.10 915,077 HUNTSVILLE AL 2.70% 95.20 343,418 MOBILE AL 3.60% 91.80 535,472 MONTGOMERY AL 2.90% 92.40 322,441 LITTLE ROCK AR 3.20% 87.20 559,074 PHOENIX AZ 2.60% 99.90 3,013,696 TUCSON AZ 2.30% 99.70 803,618 BAKERSFIELD CA 12.50% 106.10 642,495 FRESNO CA 13.80% 105.80 879,829 LOS ANGELES CA 6.30% 122.00 25,366,576 SACRAMENTO CA 4.10% 114.00 3,328,431 SAN DIEGO CA 3.20% 122.80 2,820,844 SAN FRANCISCO CA 2.50% 144.70 8,559,292 COLORADO SPRINGS CO 3.70% 96.80 499,994 DENVER CO 2.60% 105.30 4,417,908 PUEBLO CO 5.80% 92.50 136,987 HARTFORD CT 3.40% 121.80 1,147,504 WASHINGTON DC 2.90% 132.00 4,739,999 WILMINGTON DE 3.20% 108.10 571,420 FORT MYERS FL 4.40% 97.20 400,542 JACKSONVILLE FL 2.90% 95.40 1,056,332 MIAMI FL 6.70% 104.50 2,175,634 ORLANDO FL 2.90% 97.00 1,535,004 PENSACOLA FL 3.70% 93.60 403,384 TALLAHASSEE FL 3.10% 100.10 200,003 TAMPA FL 2.90% 97.80 2,278,169 WEST PALM BEACH FL 5.60% 104.70 1,049,420 ATLANTA GA 3.00% 97.40 3,857,097 COLUMBUS GA 4.40% 93.90 271,417 MACON GA 4.70% 95.10 321,586 DES MOINES A 1.80% 94.70 443,496 DUBUQUE A 2.60% 107.50 88,112 BOISE ID 3.30% 102.70 407,844 POCATELLO ID 4.50% 99.80 74,881 CHICAGO IL 4.00% 121.60 8,008,507 ROCKFORD IL 4.10% 103.60 358,640 SPRINGFIELD IL 3.60% 95.10 358,640 FORT WAYNE IN 2.40% 93.30 484,320 INDIANAPOLIS IN 2.30% 94.90 2 SOUTH SEND IN 2.40% 90.90 258,537 TOPEKA KS 4.30% 95.10 170,773 WICHITA KS 3.30% 94.80 548,714 LEXINGTON KY 1.90% 95.90 455,617 LOUISVILLE KY 2.70% 92.80 1,005,849 BATON ROUGE LA 3.70% 98.50 578,946 NEW ORLEANS LA 4.00% 94.50 1,305,479 SHREVEPORT LA 4.80% 94.90 377,673 BOSTON MA 2.20% 136.80 3,297,201 BALTIMORE MD 4.70% 102.30 2,491,254 DETROIT MI 2.80% 113.00 4,474,614 GRAND RAPIDS MI 2.50% 102.10 1,052,092 LANSING MI 2.10% 102.90 450,789 MINNEAPOLIS-ST.PAUL MN 1.50% 99.70 2,872,109 ROCHESTER MN 1.20% 97.50 119,077 COLUMBIA MO 1.40% 93.10 130,179 KANSAS CITY MO 3.20% 96.10 1,756,899 SPRINGFIELD MO 2.50% 94.50 308,332 ST. LOUIS MO 3.50% 97.40 2,569,029 JACKSON MS 2.80% 94.30 432,647 BILLINGS MT 3.80% 102.70 127,258 GREAT FALLS MT 5.70% 102.50 782,132 MISSOULA MT 5.20% 101.80 89,344 ASHEVILLE NC 3.30% 100.00 215,180 CHARLOTTE NC 5.00% 96.80 1,417,217 GREENSBORO-WNSTN-S NC 2.80% 97.50 1,179,384 RALEIGH NC 1.90% 97.30 1,106 WILMINGTON NC 4.20% 97.80 222,109 BISMARCK ND 1.80% 99.90 91,939 FARGO ND 1.10% 100.80 170,122 LINCOLN NE 1.40% 88.80 237,057 OMAHA NE 1.90% 92.30 698,875 CONCORD NH 2.30% 108.80 239,069 ATLANTIC CITY NJ 12.70% 132.60 337,635 ALBUQUERQUE NM 4.60% 102.80 678,820 LAS VEGAS NV 3.30% 105.60 1,381,086 RENO NV 2.80% 111.80 319,816 ALBANY NY 3.10% 109.70 869,474 BUFFALO NY 4.50% 97.30 1,142,121 NEW YORK NY 7.60% 226.50 20,196,649 ROCHESTER NY 3.50% 110.40 1,079,073 SYRACUSE NY 3.40% 102.90 732,920 AKRON om 3.70% 96.30 689,435 CINCINNATI OH 3.20% 101.10 1,960,995 CLEVELAND OH 4.20% 106.00 2,221,181 COLUMBUS OH 2.50% 101.40 1,489,487 TOLEDO OH 4.60% 96.90 608,976 OKLAHOMA CITY OK 3.00% 90.20 1,046,283 TULSA OK 3.00% 89.40 786,117 EUGENE OR 5.10% 108.90 314,901 PORTLAND OR 4.30% 107.30 1,845,840 SALEM OR 5.50% 103.30 335,156 ALLENTOWN PA 4.40% 104.40 618,350 ERIE PA 4.70% 101.60 276,993 HARRISBURG PA 2.70% 104.90 618,375 PHILADELPHIA PA 4.00% 127.40 4,949,567 PITTSBURGH PA 4.31% 113.30 2,331,336 WILLIAMSPORT PA 5.10% 97.50 116,709 CHARLESTON SC 2.50% 95.20 552,803 COLUMBIA SC 1.80% 94.20 516,251 GREENVILLE SC 2.50% 95.20 929,565 RAPID CITY SO 2.40% 100.20 88,117 SIOUXFALLS SO 1.40% 96.60 164,481 KNOXVILLE TN 3.40% 93.80 672,087 MEMPHIS TN 3.20% 95.30 1,105,050 NASHVILLE TN 2.50% 91.70 1,171,755 ABILENE TX 3.40% 91.80 122,478 AMARILLO TX 3.10% 90.00 208,691 AUSTIN TX 2.40% 100.90 1,146,050 CORPUS CHRISTI TX 6.40% 93.60 387,105 DALLAS-FORT WORTH TX 2.90% 101.80 3,280,310 ELPASO TX 9.80% 95.00 701,908 HOUSTON TX 3.80% 96.80 4,010,969 SAN ANTONIO TX 3.20% 99.60 1,564,949 WACO TX 3.30% 92.10 204,244 SALT LAKE CITY UT 2.70% 100.90 1,275,076 NORFOLK VA 3.30% 100.50 1,562,635 RICHMOND VA 2.80% 102.00 961,416 ROANOKE VA 2.10% 93.00 277,741 BURLINGTON VT 1.90% 109.60 165,917 OLYMPIA WA 4.80% 103.40 205,459 SEATTLE WA 3.10% 119.70 2,334,934 SPOKANE WA 5.30% 106.70 409,736 YAKIMA WA 11.70% 102.60 220,785 GREEN BAY Wl 2.40% 97.00 216,522 LA CROSSE WI 2.50% 98.50 121,927 MILWAUKEE Wl 3.30% 107.50 1,462,422 CHARLESTON WV 4.40% 96.60 251,199 HUNTINGTON WV 5.80% 100.80 312,447 CASPER WY 5.00% 101.40 63,157 CHEYENNE WY 3.30% 95.00 78,877Explanation / Answer
Answer:
No of room rented Revenue Operating cost profit 32 28800 25000 3800 33 29700 25000 4700 34 30600 25000 5600 35 31500 25000 6500 36 32400 25000 7400 37 33300 25000 8300 38 34200 25000 9200 39 35100 25000 10100 40 36000 25000 11000 41 36900 25000 11900 42 37800 25000 12800 43 38700 25000 13700 44 39600 25000 14600 45 40500 25000 15500 46 41400 25000 16400 47 42300 25000 17300 48 43200 25000 18200 49 44100 25000 19100 50 45000 25000 20000Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.