LotCode: A unique code that identifies the parking lot LotCapacity: A number with the respective parking lot capacity LotOccupancy: A number with the current number of cars in the parking lot LotCode LotCapacity LotOccupancy TimeStamp Day Lot01 863 174 11/20/2016 8:01 Sunday Lot01 863 179 11/20/2016 8:27 Sunday Lot01 863 189 11/20/2016 9:01 Sunday Lot01 863 197 11/20/2016 9:27 Sunday Lot01 863 226 11/20/2016 10:01 Sunday Lot01 863 247 11/20/2016 10:27 Sunday Lot01 863 331 11/20/2016 11:01 Sunday Lot01 863 400 11/20/2016 11:27 Sunday Lot01 863 469 11/20/2016 12:01 Sunday Lot01 863 510 11/20/2016 12:34 Sunday Lot01 863 594 11/20/2016 13:07 Sunday Lot01 863 618 11/20/2016 13:27 Sunday Lot01 863 637 11/20/2016 14:01 Sunday

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

Scenario: A city’s administration isn’t driven by the goal of maximizing revenues or profits but instead looks at improving the quality of life of its residents. Many American cities are confronted with high traffic and congestion. Finding parking spaces, whether in the street or a parking lot, can be time-consuming and contribute to congestion. Some cities have rolled out data-driven parking space management to reduce congestion and make traffic more fluid. 

 

You’re a data analyst working for a mid-size city that has anticipated significant increments in population and car traffic. The city is evaluating whether it makes sense to invest in infrastructure to count and report the number of parking spaces available at the different parking lots downtown. This data would be collected and processed in real-time, feeding an app that motorists can access to find parking space availability in different parking lots throughout the city. 

 

Instructions: Work with the provided Excel database. This database has the following columns:

  • LotCode: A unique code that identifies the parking lot
  • LotCapacity: A number with the respective parking lot capacity
  • LotOccupancy: A number with the current number of cars in the parking lot
LotCode LotCapacity LotOccupancy TimeStamp Day
Lot01 863 174 11/20/2016 8:01 Sunday
Lot01 863 179 11/20/2016 8:27 Sunday
Lot01 863 189 11/20/2016 9:01 Sunday
Lot01 863 197 11/20/2016 9:27 Sunday
Lot01 863 226 11/20/2016 10:01 Sunday
Lot01 863 247 11/20/2016 10:27 Sunday
Lot01 863 331 11/20/2016 11:01 Sunday
Lot01 863 400 11/20/2016 11:27 Sunday
Lot01 863 469 11/20/2016 12:01 Sunday
Lot01 863 510 11/20/2016 12:34 Sunday
Lot01 863 594 11/20/2016 13:07 Sunday
Lot01 863 618 11/20/2016 13:27 Sunday
Lot01 863 637 11/20/2016 14:01 Sunday
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 5 images

Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.