Supermarket Logistics System (SLS)

RFP*: Supermarket Design

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

INTRODUCTION AND OVERVIEW

Downtown Brooklyn is experiencing a renaissance. Polytechnic University 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, SIAC, 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 EG1004 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.

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 may either build a model (scale 1:240) using the materials provided, or create a 3-D 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.

MICROSOFT PROJECT

Your team must create a time management plan using Microsoft Project (MS Project). This plan must include all tasks related to the project. Each task must be named, assigned a duration and assigned to a specific person (or people). You must begin your work by creating an MS Project plan. Follow your project plan throughout the semester. If the team falls behind schedule, explain the reasons for the delays when you present your progress reports, list the steps being taken to get the project back on track, and create a revised MS Project plan.

There should be at least twenty tasks/subtasks and three Milestones. Milestones should be noted with the duration of "0day". Moreover, the copy picture function included in MS Project Software should be used instead of the print screen function of the computer.

You can get help on making your project schedule by reading the page "How to plan the schedule and calculate costs for a project" in the "Material to help you with the project" section of the online manual.

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, EG1004 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 supermarkt 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" in the "Material to help you with the project" section of the online manual.

MILESTONES

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.

Milestone 1 Deliverables: A presentation. Include a preliminary layout of your store, cost estimate, and MS Project plan. Include a brief description of the store and any special features and benefits of your design.

Note: Whenever you revise your drawing(s), your cost estimate, or your MS Project plan, you must include the initial drawing, the initial cost estimate, or the initial MS Project plan, in addition to the revision.

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

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. A signed Component Testing Form must be submitted to your Recitation TA.

Milestone 2 Deliverables: A copy of your presentation slides that includes your floor plan and elevation drawings, your LabVIEW program, a revised cost estimate, your revised MS Project plan, and your signed Component Testing Form.

Note: Whenever you revise your drawing(s), your cost estimate, or your MS Project plan, you must include the initial drawing, the initial cost estimate, or the initial MS Project plan, in addition to the revision.

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

Milestone 3

Include plumbing and electrical drawings, revised MS Project (from Progress Presentation 2), and updated MS Project that reflects schedule changes, a revised first cost estimate, and a revised LabVIEW program. 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.

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 the completion of the project?

COMPETITON

Five customers visit the supermarket. They start and end at the entrance door.

Each buys five unique items in the supermarket. (The list of items will be provided on the last day of the project.) What is the total distance traversed by the five shoppers? The design with the shortest total distance wins. For example, Customer 1 might have to buy, milk, coffee, white bread, orange juice, and strawberry jelly.

FINAL PRESENTATION

The exact specifications for your final presentation will be provided by your instructor. Some of these requirements will be: the features and benefits of your design, project specifications, all drawings, LabVIEW programs, cost estimates, and your completed MS Project plan. A 3D model or an actual model of the supermarket should be present as well. After you deliver your final presentation, you will proceed to the Model Shop to have your work commissioned (tested). A signed Commissioning Statement must be included with your final presentation materials.

Final Submission

Your final submission should include:

• Component testing statement
• Commissioning statement
• Model (if physical model)
• Hardcopy and CD containing:
• Final presentation
• Cover page and table of appendices.
• Appendices:
• Final LabVIEW program
• Initial sketch
• All the drawings of your final design
• Chart with power, air conditioning, and heat tabulations
• Model (if electronic 3D model submitted)
• Final MS Project Schedule
• Final Cost estimate
• Resume(s)

Early Acceptance

If you complete 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 by 5PM one week before your section is scheduled to present (see syllabus for exact date). To commission 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 commissioned will be accepted.

LIQUIDATED DAMAGES

If you do not complete all your deliverables and do not commission during the Final Presentation, you will incur liquidated damages as defined in the grading policy.

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

Return to Table of Contents