Supermarket Logistics System (SLS)

From EG1003 Lab Manual
Jump to: navigation, search

RFP*: Supermarket Logistics System (SLS)

* RFP is an acronym for Request For Proposal. Internationally, RFPs are called ITTs, an acronym for Invitation To Tender governmental agencies use RFPs to solicit new business.

Introduction and Overview

Downtown Brooklyn is experiencing a renaissance. NYU Polytechnic School of Engineering spearheaded the first leg of this resurgence over 20 years ago when it proposed an urban renewal project designed to develop a Metropolitan Technology Center in Brooklyn.

Now known as Metrotech, the area has been transformed. It features new construction that houses Keyspan Energy, Chase Manhattan Bank, Bear Sterns, Empire Blue Cross / Blue Shield, and other corporate heavyweights. The city has recognized Metrotech's success and intends to expand on it.

Since 9/11, Manhattan-based companies have had to add back office space outside of that Borough in order to prevent the catastrophic effects another terrorist attack could have on their businesses. The City, driven by the desire to keep these companies in New York, is planning a massive Downtown rezoning and redevelopment plan for Brooklyn. The plan would allow for the construction of 6.7 million square feet of office space, 1 million square feet of retail development, 1,000 housing units and 2,500 parking spaces.

Retail giants like Target, which just opened a store in the new Atlantic Terminal Mall on the corner of Flatbush and Atlantic Avenues, and Ikea, whose plan for a location in Red Hook has just been approved by the City Planning Commission, are moving to the area. There is even a proposal by the owner of the New Jersey Nets, Bruce Ratner, to move the team to a proposed site in Downtown Brooklyn called The Atlantic Yards.

But despite all this activity, there is still a shortage of supermarkets in the area. Operating on the theory that all these people must eat, Whole Foods, the Austin, Texas based natural and organic food seller, is building a 52,000 square foot store south of Park Slope. However, this site is still some distance from Downtown Brooklyn.

Our company, Poly Foods, Inc., is launching a design competition for our new location on Jay Street. Right in the heart of Metrotech, this site had enormous potential. The right design concept will guarantee success.

Your plan must be innovative. The winning proposal will be the one that incorporates a bold scheme for the space that combines solid engineering with a broad vision of the future of food retailing. The architectural ideas embodied in your plans must be discussed fully. Your proposal should include information on your company and its lead developers with at least one reference to a previous commission.

Please refer to the specifications that follow as you prepare your submission.

Specifications

A major Supermarket chain has commissioned your firm to design a store for their recently purchased 400'X400' lot. It is bounded by Jay and Tillary Streets. Your clients have asked you to include a parking lot and a loading dock. The overall lot must hold both the supermarket and its parking lot. The parking lot can be "at grade", or above or beneath the supermarket.

Your supermarket must be only one story tall.

The EG1003 staff will supply foam board. Any other materials you may want to use will have to be purchased by you at your own expense. There will be no reimbursement for these materials.

Extra Credit

Leadership in Energy & Environmental Design (LEED) is a green building certification program. To receive LEED certification, building projects satisfy prerequisites and earn points to achieve different levels of certification. Teams choose the best fit for their project. The different categories for the LEED checklist[1] correspond to principles of design, construction, and maintenance. For the purposes of this project, the checklist has been streamlined. All prerequisites from a category must be incorporated into the supermarket design to count toward certification. LEED Silver certification requires completion of at least two categories; LEED Gold, at least four categories, and LEED Platinum, all six categories. Achievement of each prerequisite will be accomplished through drawings, cost estimates, and explanations of the design.

Streamlined checklist:

  1. Location and Transportation
    1. Diverse land use (p.16[1]) – Design provides space for goods and services not directly related to the grocery store. (Examples: food truck court, deli, bank, post office)
    2. Disability access – Detailed features are provided for Americans with Disability Act. (Examples: reserved parking, wheelchair accessible ramps)
    3. Bicycle and EV facilities (p.22[1]) – Bike racks and electric vehicle charging stations labeled in drawings.
    4. Reduced parking footprint (p.26[1]) – Realistic dimensions for parking spaces with minimal allocated space for parking lot.
  2. Sustainable Sites
    1. Open space (p.36[1]) – Inclusion of green space on the supermarket grounds. (Examples: gardens, park space, rooftop vegetation, pond)
    2. Rainwater management (p.37[1]) – Reducing storm water runoff and built land impact on hydrologic cycle. (Examples: rainwater retention pond, rainwater storage, rainwater reuse)
    3. Heat island reduction (p.39[1]) – Minimizing paved and rooftop surfaces. (Examples: vegetative surfaces, trees, shade from energy generation systems)
    4. Light pollution reduction (p.41[1]) – Detailed placement of outdoor lighting fixtures, maximizing security and minimizing light pollution.
  3. Water Efficiency
    1. Water quality management – Real-time quality monitoring system, shutoff VI for cases of contamination.
    2. Water use reduction (p.51[1]) – Use of low flow appliances and minimal irrigation, details for all water uses. (Example: sprinklers, sinks, toilets)
    3. Water heating and cooling (p.60[1]) – Intelligent placement of high efficiency systems.
    4. Advanced water metering – Real-time quantity monitoring system of all water use. (Examples: irrigation, indoor plumbing, reclaimed water, boiler usage)
  4. Energy and Atmosphere
    1. Optimize energy performance (p.74[1]) – Use of low energy systems. (Examples: HVAC, lighting, refrigeration, appliances)
    2. Advanced energy metering (p.77[1]) – All electrical use run through a single meter.
    3. Demand response (p.79[1]) – LabVIEW VI similar to automatic heat control, energy use changes throughout the day.
    4. Renewable energy production (p.80[1]) – Location and connection to electrical system. (Examples: solar, wind, thermal)
  5. Indoor Environmental Quality
    1. Air quality management (p.107[1]) – Ventilation and monitoring of air. (Examples: carbon monoxide detectors, exhaust vents, air filtration system)
    2. Interior lighting/daylight (p.129[1]) – Enhanced interior lighting. (Examples: dimmers, daylight, window shades)
    3. Thermal comfort (p.127[1]) – Enhanced temperature control for individual comfort. (Examples: localized heating and cooling, circulating fans, radiant flooring)
    4. Acoustic performance (p.136[1]) – Sound absorbent surfaces are greater than the ceiling area. (Examples: acoustic tiles, acoustic wall panels)
  6. Innovation (p.140[1])
    1. Connected building – Design a VI for internet connectivity and connected devices. (Examples: Wi-Fi router, networked registers, inventory systems)
    2. Intelligent inventory – Real-time monitoring of inventory. (Examples: shelves with sensors, database connected to registers, exit door scanners)
    3. Security and safety – Enhanced security VIs. (Examples: automatic police contact, automatic fire contact, notifications)
    4. Sustainability – Focus on innovative green technologies not included in other categories.

Site Visits

The first step is to make a number of site visits. Start by visiting the new Target at the Atlantic Terminal Market at 139 Flatbush Avenue. Their store hours are M-Sat 8-10 and Sun 8-9. Make note of the store's layout and the features that have been incorporated that allow a downtown store to use space efficiently. Next, visit a typical supermarket that is about 40,000 square feet. The Whole Foods in the Chelsea section of Manhattan is a good choice, but you may visit any one you like. On your visit, create a parts list of typical store fixtures like shelves, freezers, refrigerators, lighting fixtures, registers, display cases, shopping carts, restocking carts and so on. Write down the brand names of the fixtures you see to aid your research later. Determine the average checkout time per shopper at three different times of the day, 9AM on a weekday, 12PM on a Sunday, and 6PM on a weekday. Using the same three data points, calculate their average waiting time and how many shoppers enter the store per hour for each of the three hours. Tabulate this data neatly in a table, graph, or chart that presents the information clearly.

Power/AC/Heat Calculations

Using the information you gathered on your site visit, calculate the total power requirement for the store. Then calculate the energy costs for a typical year. Determine the total A/C requirement. What is the dollar cost per year for air conditioning? Determine the total heat requirement. What is the dollar cost per year for heat? Tabulate this data neatly in a table, graph, or chart that presents the information clearly.

Model

Design your Supermarket using AutoCAD as your primary design tool. Create a convenient layout, with aisles (at least wide enough for 2 shopping carts to pass), shelves, registers, deli counter, for all items, on the master list provided, of store items from the Port Washington King Kullen.

Your team will create a 3D computer-simulated model.

LabVIEW

A LabVIEW program that will control the lighting, temperature, and security systems for your Supermarket must be created. Please refer to the course syllabus for all due dates.

Use LabVIEW to design a lighting system and a heating/cooling system for your Supermarket. Both systems must be included in the same LabVIEW VI.

Your design must include plumbing. The municipal water and sewer lines enter the Supermarket from the street. Your plumbing design must include piping for spray nozzles in the produce area, sinks in the deli area,sewage, hot water, and cold water.

For your security system VI, you may want to take the following into consideration:

  • Fire Alarm
  • Video Surveillance
  • Manual/Automatic Alarm System

Be creative and make sure to label the security system appropriately in your VI implementation.

Microsoft Project

A time management plan using Microsoft Project (MS Project) must be created. You can learn Microsoft Project by doing the MS Project Skill Builder. This plan must include all tasks related to the project. The MS Project schedule should include the following:

  • Minimum of 20 tasks.
  • Milestones should be clearly indicated on the project plan (duration of zero days).
  • Each task must include the person responsible for completing the task (resource names).
  • Use the Copy Picture function to include the project plan in the presentations. DO NOT take a screenshot.
  • Gantt chart must be displayed alongside the tasks list (fit onto one slide).
  • Gantt chart must clearly show a progress line.
  • Clearly state during the presentation whether the project is on time, behind schedule or ahead of schedule

For help in planning the project, review the page called How to plan the schedule and calculate costs for a project.

Drawings

The following paragraphs discuss the drawings required for the project, and AutoCAD. If you have access to another drawing system capable of producing 3D drawings, you may use that instead if you wish. However, EG1003 will only provide access to AutoCAD, and AutoCAD is the preferred solution.

A command of AutoCAD is necessary for you to complete the drawings required for this project. Refer to the AutoCAD handout for more information. The main layer of your AutoCAD drawings will be the floor plan. The dimensioning, electrical, and plumbing drawings must be added as separate layers. Print your drawings separately using a scale of 1:240 (1" = 20'). You may use the symbols preloaded in AutoCAD to draw fixtures, appliances, windows, and doors. You will have to create some of the symbols required for your drawings. Make sure you include a title block.

Use AutoCAD to draw a floor plan of your design, labeling all the fixtures and design elements you have included.

Use AutoCAD to prepare two elevation drawings of your design. Your first drawing is the front elevation. It must be fully dimensioned and include:

  1. All door and window openings.
  2. Your choice of façade material, e.g., aluminum siding, brick, or stucco.

Your second drawing is the most detailed side or back elevation. It must be fully dimensioned and include:

  1. All door and window openings.
  2. Your choice of façade material e.g. aluminum siding, brick, or stucco.

Use AutoCAD to prepare a dimensioned drawing of your design. Your drawing must include:

  1. Detailed dimensions of your floor plan.
  2. You must be able to construct the store from this drawing. To preserve clarity, dimensions should be located outside the store when possible. Dimensions may not overlap.

Use AutoCAD to prepare an electrical drawing of your design. Your drawing must include:

  1. All items in the electrical system in this drawing.
  2. Outlets, switches, light fixtures, and wiring.
  3. A legend.

Use AutoCAD to prepare a plumbing drawing of your design. Your drawing must include:

  1. Spray nozzles in the produce area and sinks in the deli area.
  2. Sewage pipes (must be solid and be drawn with continuous line type).
  3. Cold water pipes (must be blue and be drawn with hidden line type).
  4. Hot water pipes (must be red and drawn with center line type).
  5. A legend.

Use AutoCAD to prepare an overall drawing of the site, showing the outline of the supermarket and the parking lot. If the parking lot is above or below ground, include a floor plan of the garage.

First Cost Estimate

After the design is complete, a cost estimate must be generated that calculates the cost of all the items specified on your parts list that will be incorporated into your design. Do not include construction costs. Conduct your research on the internet. The brand names you collected on your site visit will help. Tabulate the information clearly in an Excel spreadsheet.

Have all the materials and parts used categorized in different groups instead of including individual parts. Make sure to include the units of each part used in a group and total them up for that individual group. Moreover, the cost of labor should be included. You can get help on the labor cost by reading the page How to plan the schedule and calculate costs for a project.

Milestones and Benchmarks

As you work on your project, you will be required to present periodic reports on your progress. We call these Milestones. All the items assigned in each Milestone are called deliverables. These deliverables often consist of a combination of written submissions, presentations, and demonstrations.

Milestone 1

Prepare a preliminary sketch of your design, a cost estimate, and an MS Project plan.

Look Ahead: What tasks do you plan between now and Milestone 2?

See How To Give a Milestone Presentation for the format of a Milestone presentation.

Milestone 1 Deliverables:

  • Presentation:
    • Project description
    • Design approach
    • Mission statement
    • Preliminary layout of store
    • Cost estimate
    • MS Project schedule
    • Progress update: current state of the project

Benchmark Assessment A

Benchmark assessments evaluate the progress of the project. Benchmark Assessment A is due at the end of Model Shop Session 1. There are penalties for not completing on time. Refer to the EG1003 Grading Policy for more information.

To pass, the design must complete all of the following:

  • Lighting System VI with at least 8 lights individually controlled and collectively by a master switch
    • When master switch is off, all lights off
  • AutoCAD drawings (1:240 scale):
    • Floor plan
    • Front elevation
    • Most detailed side elevation

Milestone 2

Using AutoCAD, prepare a floor plan and elevation drawings (be sure to include a title box). Complete your latest LabVIEW program and your latest MS Project plan. Then, calculate an initial cost estimate.

Look Ahead: What tasks do you plan between now and Milestone 3?

See How To Give a Milestone Presentation for the format of a Milestone presentation.

Milestone 2 Deliverables:

  • Presentation:
    • Project description
    • Design approach
    • Design changes since Milestone 1
    • Mission statement
    • AutoCAD drawings:
      • Dimensions must be included
      • 1:240 scale
      • Floor plan
      • Front elevation
      • Most detailed side elevation
    • LabVIEW VI: lighting system
      • Screenshot of the VI while running with the master switch ON
      • Screenshot of the VI while running with the master switch OFF
      • Include both the front and back panels
    • Cost estimate (previous and current). What changes were made?
    • MS Project schedule (previous and current). What changes were made?
    • Progress update: current state of the project (time, budget, etc.)

Benchmark Assessment B

Benchmark Assessment B is due at the end of Model Shop Session 2. There are penalties for not completing on time. Refer to the EG1003 Grading Policy for more information.

To pass, the design must complete all of the following:

  • Lighting System VI
  • Heating and Cooling System VI
  • AutoCAD drawings (1:240 scale):
    • Floor plan
    • Plumbing
    • Electrical
    • Front elevation
    • Most detailed side

Milestone 3

Using AutoCAD, prepare plumbing and electrical drawings. Complete your latest LabVIEW program and your latest MS Project plan, reflecting any schedule changes. Calculate a revised cost estimate. If your design is successful, your client would like to expand to 100 locations nationwide. Discuss how this would affect the cost of building each store.

Look Ahead: What tasks do you plan between now and the completion of the project?

See How To Give a Milestone Presentation for the format of a Milestone presentation.

Milestone 3 Deliverables:

  • Presentation:
    • Project description
    • Design approach
    • Design changes since Milestone 2
    • Mission statement
    • AutoCAD drawings:
      • Dimensions must be included
      • 1:240 scale
      • Floor plan
      • Front elevation
      • Most detailed side elevation
      • Plumbing drawing
      • Electrical drawing
    • LabVIEW VIs: lighting system and heating/cooling system
      • Include both the front and back panels
      • Screenshot of the VI while running with the master switch ON
      • Screenshot of the VI while running with the master switch OFF
    • Cost estimate (previous and current). What changes were made?
    • MS Project schedule (previous and current). What changes were made?
    • Progress update: current state of the project (time, budget, etc.)

Commissioning

Refer to the syllabus for the commissioning deadline. There are penalties for not completing on time. Refer to the EG1003 Grading Policy for more information.

To pass, the design must complete all of the following:

  • LabVIEW VIs
    • Lighting System
    • Heating and Cooling System
    • Security System
  • AutoCAD drawings (1:240 scale):
    • Floor plan
    • Plumbing system
    • Electrical system
    • Front elevation
    • Most detailed side
  • Model of Building and Parking Lot (3-D AutoCAD or Revit) (1:240 scale)

Final Presentation

The final presentation will be a technical briefing, similar to the milestones, but also serves as a sales presentation explaining why your company should be selected instead of the competition. Please include the following:

  • Problem statement
  • Solution overview
  • Company description and qualifications
  • Drawings
  • LabVIEW VIs
  • Cost estimate
  • Microsoft Project schedule
  • Model demonstration
  • Why should the company be awarded this contract?

Submission

Beginning Fall 2016, students must submit online. Please visit https://eg.poly.edu/finalSLDP.php for login information and the link to the Project Submission form.

Students must be logged into the account provided at https://eg.poly.edu/finalSLDP.php. Submitting with your NYU account or any other account will generate an error.

Submissions may be edited at any time before the deadline. Please note that submission times are based on the last submission. Submissions that qualify for Early Submission will lose the Early Submission Extra Credit if the submission is edited after the Early Submission deadline.

Please note the deliverables for this project are as follows. If any of the following items are omitted, you will be penalized. Be sure to click SUBMIT at the bottom of the form.

  • Project deliverables:
    • Final presentation
    • Cover page and table of contents
    • Final LabVIEW VIs
    • Initial sketch
    • All the drawings of your design (initial through final)
    • Model
    • Final MS Project Schedule
    • Final cost estimate
    • Chart with power, air conditioning, and heat tabulations
    • Resume(s) (No fictitious resumes will be accepted.)

Early Acceptance

If you submit your project one week early, you are eligible for a bonus that will be added to your final semester-long project grade. You must submit all deliverables one week before the submission deadline (see syllabus for exact date). To submit early, all required information on the form titled Project Submission Form, found on the EG web site, must be approved, accepted, and signed by a TA. The deliverables received early are the ones you will use in your presentation. No adjustments to the deliverables submitted will be accepted.

Late Delivery

Late delivery is not allowed. If you do not commission by the deadline set forth in the syllabus, you will not receive full credit for commissioning. In order to receive partial credit, all deliverables except the commissioning statement must be submitted by the submission deadline. Please refer to the EG1003 Grading Policy for more information.

Appendix: King Kullen(Port Washington) Supermarket List

This is a list of typical items sold in a supermarket and is for layout purposes only. It is not to be used for costing purposes.

  • Aluminum Foil
  • Baby Food
  • Bakery
  • Bakeware & Baking Soda
  • Barbecue Sauce
  • Bathroom Tissue
  • Beans, Dried
  • Beverages
  • Bleach
  • Bread Crumbs
  • Brooms
  • Cake Mixes
  • Candy
  • Cat Food
  • Cereal, Hot & Cold
  • Chocolate, Baking
  • Chocolate, Syrup
  • Cleansers
  • Cocktail Mixes
  • Cocoa
  • Coconut
  • Coffee
  • Cookies/Crackers
  • Dairy
  • Deli
  • Desserts
  • Detergents
  • Diapers
  • Diet Foods
  • Dishwashing Aids
  • Dog Food, Canned & Bagged
  • Drinks, Powdered
  • Extracts
  • Facial Tissues
  • Feminine Products
  • Fish, Canned
  • Flour
  • Frozen Foods
  • Fruit, Canned or Dried
  • Gelatin
  • Granola
  • Gravy
  • Greeting Cards
  • Hair Care
  • Health Needs
  • Honey
  • Housewares
  • International Foods
  • Jams & Jellies
  • Juices, Canned & Glass
  • Ketchup
  • Kosher Foods
  • Light Bulbs
  • Macaroni & Noodles
  • Mayonnaise
  • Meat, Fresh & Frozen
  • Milk, Powdered
  • Mops
  • Mustard
  • Napkins
  • Nuts
  • Oil
  • Olives
  • Pancake Mix
  • Peanut Butter
  • Pet Supplies
  • Pickles
  • Popcorn
  • Potato Chips
  • Produce
  • Relishes
  • Rice
  • Salad Dressings
  • Salt
  • Shortening
  • Soap, Bar
  • Soap Pads
  • Soap, Powdered
  • Soda
  • Soft Goods
  • Soups, Canned & Dried
  • Spaghetti Sauce
  • Spices
  • Stationery
  • Sugar
  • Syrup
  • Tea
  • Toilet Tissue
  • Tomato Sauce
  • Towels, Paper
  • Vegetables, Canned
  • Vinegar
  • Water, Bottled
  • Waxed Paper
  • Waxes & Polishes

References