HomeMy WebLinkAboutPurchase Software-Hardware for DWGR Restaurant C�
��r:t '1 N T R
(,----' ,„.H. ,,, , MEMO
4, vrii•
%,,. .4.:„
9-4: OFFICE
To: Honorable Mayor and City Council members
From: Paul S. Gibson, Finance Director/City Treasurer
Subject: Purchase of Software for Desert Willow Restaurant operations.
Date: October 27, 1999
Recommendation:
By minute motion, approve purchase of software and hardware from Squirrel for an amount not to exceed $46,000.
Background:
This is being requested as an emergency item due to: (1) Last site visit was on Tuesday October 27; (2) In order to
have the hardware loaded with the software it will require 60 days to do the necessary work prior to receiving training
in the first week of January 2000(3) Due to Y2k issues the earliest Squirrel can train staff is January based on their
current signed agreements. If staff waits until November 18, 1999 City Council meeting we probably will not have
this installed until late January or early February. Currently, the restaurant operation is using a cash register to handle
the current sales. This will not be sufficient when we move into the new clubhouse with extended restaurant,bar and
snack bar operations.
Desert Willow requested bids from various vendors that specifically do software for handling restaurant business.
Staff review the costs, maintenance support and actual restaurant sites using software of the three vendors. The three
vendors providing bids were(excluding sales tax and shipping):
Squirrel $39,995.46
Appel Company(Aloha Software) $39,380.30 (Did not provide all aspects of hardware required)
Micros $47,580.00 (Previously installed at a Kemper site and had major problems
with training installation and backup support)
Staff has review the Squirrel software at L.G. Steakhouse and found that it met our concerns on security and inventory
issues. Menu's are set up based on the specific type of user(server, manager,bartender, etc.). Screens are touch
activated and we can have separate department for banquets, bar, snack bar, cabana and restaurant operations.
Attached is a copy a brochure from squirrel showing the screen layouts. Items included in bid are Windows NT
server, 6 stations for servers, cash draws, printers, software($5,970), credit card machines, installation and training.
Staff recommends that the City Council approve the purchase of software and hardware from Squirrel.
Reco nd Approval: wed Concur:
/dA/_
Paul S. Gibson, Finance Director amon Diaz, City nager
CITY COUNCIL,A�CTION:
APPROVED 'V/ DENIED
RECEIVED OTHER
MEET INIG DATE
AYES: Pr►
'TOES: 4� �
ABSENT: /Vl t2) `.-�� �•1
ABSTAIN: /IA)14,0
VERIFIED BY: . A
Original on File with Ci C rk' s OffiC .
ORDER SUMMARY AND PRICING Desert Willow Golf Resort
04-Oct SCHEDULE"a" -(EQUIPMENT UST) UNIT EXTENDED
QUANTITY PART s DESCRIPTION PRICE PRICE
$0.00
92-451 NT SERVER,PII 450,256M,CD,2x4G 3780.00 $0.00
92-400 PH 400,192M,CD,6GHD,NT,ETHR,S 1879.00 $0.00
1 92-402 P11450,192M,C D,6GHD,NT,ETHR,Sr 2212.00 $2,212.00
1 SQ-7533 ZIP Drive Parallel Port 201.00 3201.00
2 91-007 (OMEGA 250MB Zip Disks 4 Peck 64.00 $128.00
1 91-577 VGA MONITOR COLOR 15"-110V 155.00 $155.00
91-578 VGA MONITOR COLOR 17"-110V 271.00 $0.00
1 SQ-3860 HP 1100 LASER PRINTER 425.00 $425.00
SQ-7519 UPS 280 UNINTERRUPTIBLE POW 108.00 $0.00
1 SQ-7521 UP8 650 UNINTERRUPTIBLE POW 199.00 $199.00
SO-7572 78VA for req printer 144.00 $0.00
SQ-7574 180VA for terminal/chk printer 218.00 $0.00
SO-7576 480VA for host/monitor 415.00 $0.00
8Q-7554 Poweivar 1 Amp(TERMINAL) 98.00 $0.00
SQ-7560 Powervar 3Amp(FOR HOST w COLC 195.00 $0.00
2 SO-7538 56K BAUD EXT.MODEM-110V 138.00 $278.00
2 SO-7335 Modem cable 7.00 $14.80
14 SO-7701 CAT 5 Wall Jack Surface Mount 4.10 $57.40
SO-7702 CAT5 Wall Jack Flush Mount 4.10 $0.00
2 SQ-7772 ETHERNET/Serial Hub Two Port 369.00 $738.00
SO-7774 ETHERNET/Serial Hub Far Port 479.00 $0.00
15 SO-7706 ETHERNET patch cable-6' 2.35 $35.25
1 SQ-7780 ETHERNET 10-BaseT Hub 99.70 $99.70
1 1-006 MICROSOFT SQL Run Time for Tart 450.00 $450.00
SO-7232 CATS Shielded Twisted Pair CABLE 130.00 $0.00
SO-7233 CAT5 Shielded PLENUM CABLE 299.00 50.00
SO-7345 CABLE ASSY RJ11-RJ45 PRINTER 13.30 $0.00
SQ-2070 12.1"WS VII(ver 1.t)32M+STAND 3100.00 $0.00
6 SO-2069 10.4"WS VI(ver 1.1)32M + STAND 2800.00 $15,800.00
6 SO-2902 Credit Card Reader WSVI 150.00 S900.00
0 SQ-2903 OPEN CREDIT CARD RDR 200.00 $0.00
SO-2907 Mag Cards for ID 4.00 $0.00
5 SQ-7035 Interface Cable 5.60 328.00
1 SO-7500 Wall Jack 2.50 $2.50
9 SQ-3031 Impact-Standard 399.00 $3,591.00
SO-3005 Thermal Cutter Printer 599.00 30.00
SQ-3022 Slip/Hard Check 880.00 $0.00
-SQ-3032 Impact/Cutter-Standard 480.00 $0.00
3 SO-7547 Cash Drawer(black) 302.00 $908.00
SO-7544 Locking Till Cover 29.00 $0.00
3 SQ-7175 Cash Drawer Cable-WSVM 15.00 $45.00
95-028 Dual Cash Drawer Adapter 50.00 S0.00
SO-2950 Tower Display 475.00 30.00
$0.00
$0.00
Page 1 of 2
ORDER SUMMARY AND PRICING Desert Willow Golf Resort
04-Oct SCHEDULE`8"-(EQUIPMENT LIST)
$0.00
$0.00
92-108 Printer Opto 422 50-00 $0.00
92-111 422 Term/Pmtr Power Supply 20.00 $0.00
120 SQ-2806 Badge Cards Series 2 4.00 $480.00
SQ-7930 HOTEL LINK KIT 200.00 $0.00
1 SO-9900 POS HOST SW 2000-00 $2,000.00
SO-6808 Club+POS SW+manuals 3000.00 $0.00
SO-9609 Hotel intrfc+POS +manuals 3000.00 $0.00
8 SQ-9901 SQUIRREL Terminal Software 995.00 $5,970.00
SQ-9663 PRO PACK(CCAI AB!F&B) 2750.00 $0.00
SQ9664 PLUS PACK(CCATTCHCLKIFBB) 2000.00 $0.00
SO9665 BASIC PACK(CCATTCHCLK) 1800.00 $0.00
SQ-96291 Toudtdock 500.00 $0.00
SO-9616 Food 8 Beverage incl. PO 1600.00 $0.00
SQ-9629 Labor 1000.00 $0.00
SQ-9654 Security 300.00 $0.00
1 SQ-9717 PC Anywhere Host Program 99.00 $99.00
$0.00
1 SO-9860 Credit Card Authorization(CCA) 1500.00 $1,500.00
1 SQ-9190 Site Log 31.25 S31.25
OTHER SPECIAL ITEMS-"Please Enter from price list
‘J:,ANTITY PART a DESCRIPTION UNIT PRICE
$0.00
$0.00
_a.
--- _-___, 0-'SQ-7530 8G Tape Backup 956.00 30.00
INSERT OTHER ITEMS HERE $.00
0 0.00 $0.00
0 0.00 $0.00
0 0.00 $0.00
0 0.00 $0.00
0 0.00 $0.00
0 SQ-7605 SIMPLE SWIVEL BASE 250.00 $0.00
0 0.00 $0.00
0 0.00 $0.00
0 0.00 $0.00
TOTAL 38143.1
Prig. 2 of 2
Alm f
SCHEDULE"A" Desert Willow Golf Resort 04-Oct-99
SQUIRREL FOR WINDOWS NT SYSTEM PROPOSAL
6 TERMINAL 9 PRINTER CONFIGURATION $33,743.10
1 CREDIT CARD AUTHORIZATION& 8 CARD READERS $2,400.00
0 OPTIONAL SOFTWARE MODULES $0.00
VOLUME PURCHASE DISCOUNT $1,557.84
TOTAL HARDWARE&SOFTWARE S34,585.48
(see attached Schedule 'B"equipment Iist)
Programming&Installation 31,610.00
8 Man-DAYS SYSTEM TRAINING AT $450.00 per day $3,600.00
SYSTEM TOTAL $39,995.46
PRICE DOES NOT INCLUDE FREIGHT OR SALES TAX
IF LEASIN 30.33 =APPROXIMATE DAILY LEASE RATE
(BASED ON A 60 MONTH LEASE TERM)
QUOTED PRICES VALID FOR 30 DAYS••
ESIAU ' I a A Gt t ' I S S I E
i
S Q U I R R E L
Squirrel POS terminal include the ability to -
display on-line "real-time" net and gross
sales statistics for a server or the house, Guest checks may be printed individually or in any combination of groups
preview"cashout and revenue" reports at or seats. Flexible checkpresentation guarantees customer satisfaction when
any time of the day, add new servers,add f
new menu items, indicate out of stock guests wish to pay separately-even after the check has been printed. .
status, and activate happy hour discounts SPLIT CHECK
and promotions. COMBINED CHECK
CHECK« 495 DATE 0422/93 CHECK N 498 DATE 04/22/93
Management control is built into the system • TABLE« 5 TIME 11:31 TABLE N 5 _- TIME -11-29
through numerous features, including the DINING ROOM DAVID -- DINING ROOM:DAVID --
capability to view the time a check was TEMS ORDERED SEATN fTEMS ORDERED AMOUNT
opened,view an open drawer count and COKE 1 COKE
lai5 F
FR.ONION SOUP SIRLOIN-60z.
require that an authorization code be SIRLOIN-6oz. B.P°t 10.95
B.Pot GLASS BLUSH 2.95
GLASS BLUSH
entered for refunds.Additionally, corporate CHEESECAKE CHEESECAKE 4.95
VODKA,w/Ton,c SUBTOTAL 23.f15
headquarters have greater control of SM.CAESAR SALAD
VEAL PICCATA
individual store menus, as menu files SPUMONI 23.85
CAFE AU LAIT 2 VODKA,w/Ton,c 2.95
SOUP OF THE DAY SMCAESAR SALAD 3.50
may be edited only by those who are SALMON STEAK VEAL PICCATA 12.95
Rice SPUMONI 2.95
given special access. APPLE PIE
a la mode
SUBTOTAL 22.35
CREDIT CARD ------._.,«=,lirJ_l;ig/_1ii1:14-� 22.35
S 3 CAFE AU LAIT 3.25
OUPTHE DAY 2.50
Squirrel communicates electronically and GRA1 CHECK« 496 DAT SAALMONFSTEAK,Rice 12.95
TABLE N 5 TIM APPLE PIE
is compatible with almost every transaction «OF --_-----_____---___= ala mode 3.95
processor,credit card provider and payment RATE NET -- DINING ROOM:DAVID SUBTOTAL 22.65
10.0% 57.23
network.An integrated magnetic stripe 15.0% 5.13 SEATa ITEMS ORDERED 22.65
reader and receipt printer eliminate the TOTAL 66.65
GRATUI1 1 COKE
FR ONION SOUP
mistakes,confusion and extra cost associated GRAND TOT B.S IRLPoOIN6oz
G
ROOM«: NAME: GLASS BLUSH
CHEESECAKE SUBTOTAL 68.85
with mechanical imprinters and separate SIGNATURE: SUBTOTAL GRAND TOTAL 68.85
credit card terminals.To further reduce the «OF GUESTS 3
transaction costs of processing credit card 2 VODKA.w/Tonic RATE NET TAX GROSS
SM CAESAR SALAD 10.0% 57.23 5.72 62.95
charges, Squirrel requires only a single VEAL PICCATA 15.0% 5.13 0.77 5.90
SPUMONI
telephone line and supports both "split- GRATUITY:
P PPSUBTOTAL
GRAND TOTAL
dialing"for simultaneous authorization of111
ROOM A NAME.
different credit cards and "split-posting" TOTAL SIGNATURE
for transfer of authorized charges to the II
payment network. Plus, a restaurant that SEPARATE CHECK SUBTOTAL 46.20
pays transaction fees for credit card server RAND TOTAL 46.20
w OF GUESTS 2
tips has the option to automatically recover CHECK 497 DATE 04/2293
this expense from employees. TABLE N__5- TIME - TAX GROSS 11:32 3.66 4030
0.77 5.90-- DINING ROOM:DAVID -
-
TUITY:
SOLUTION PARTNERS SEAT II ITEMS ORDERED AMOUNT OTAL
The automation of full-service restaurants 3 CAFE AU LAIT 3.25 ME:
SOUP OF THE DAY 2.50
has expanded beyond the Point-of-Sale SALMON STEAK,Rice 12.95
APPLE PIE
application to include Frequent Diner, alamode 3.95
SUBTOTAL 22.65 '
Table&Guest Management Systems, and 2265
sophisticated Inventory, Labor and TOTAL 22.65
Financial Management software applications.
Squirrel has always followed an Open SUBTOTAL 22.65 A wider variety of guest
System product development philosophy, GRAND TOTAL 22.65 check and requisition
developing enhanced interfaces with many «OF GUESTS 1 order styles are available.
of the leading providers of complementary RATE NET TAX GROSS
10.0% 20.59 2.06 22.65
applications designed especially for GRATUITY:
full-service restaurants. GRAND TOTAL
ROOM II: NAME:
SIGNATURE: .
Customers can be assured that, in most
SALES ANALYSIS REPORT situations,the applications upon which
they already depend,or applications
Volume Detail for Dept 1 - COFFEE SHOP which they may want to add after Squirrel
has been installed,will be compatible
MENU ITEMS MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY S1N4DAY TOTAL 1El% with the Squirrel System.
APPT7R
SOAP
SOUP OF THE DAY 15.0 280 18.0 29.0 860 142 HOTEL
CLAM CHOWDER 7.0 4.0 17.0 20.0 480 7.7
FR.ONION SOUP 190 130 23.0 27.0 62.0 132
TOTAL Soup 410 43.0 580 76.0 2,80 35.1 With the available Hotel Interface to
Salad
TOSSED SALAD 80 170 21.0 20.0 66.0 10.6
SM.CAESAR SALAD 6.0 110 15.0 160 480 77 Property Management Systems,a hotel
SM.SPINACH SALAD 4.0 160 18.0 11.0 47.0 7.6
TOTAL Salad 180 440 52.0 470 1610 259 that utilizes the Squirrel System in its food
Cold
SHRIMP COCKTAIL 80 2.0 15.0 8.0 33.0 5.3 TOTAL COW 8.0 2.0 15.0 8.0 33.0 5.3 and beverage outlets can be assured of
Hot
BEEF TERI SAUTE 6.0 20 13.0 8.0 290 4.7 timely and accurate posting to guest and
CHICKEN FINGERS 8.0 5.0 16.0 11.0 40.0 6.4
NACHOS GRANDE 14.0 18.0 180 13.0 ILO 10.1
SCALLOP SAUTE 5.0 2.0 120 6.0 .. city ledger accounts.The POS posting
ZUCCHINI STICKS 0 37.0 74.0 .0
TOTAL Hot 45.0 26.0 990 53.0 GRAPHIC process requestspre-verification ofguest
TOTAL ANTRA 112.0 1260 IWO 18/.0
TOTAL 112.0 126.0 1990 1840 INTERFACE name, room number, credit limit and
in-house status.A real-time connection
Daily Appetizer Sales eliminates lost revenue and late billing
$350 ESuo.SWo.Cm.Ho,- errors due to guest departure. For the
The Sales Analysis report is available in both $250 _ convenience of the hotel and guests alike,
Gross and Net amounts, based on volume or $2 0 0 .. ' k
Squirrel has the ability to read different
dollar sales. Variable report parameters per- $'55 card formats. For example,a guest could
$ o use a key card to pay for purchases in food
mit printing in summary or detail,for one "" �' Wed
and beverage outlets.A hotel may also
or all departments and/or time zones in day, display information such as check-out
week, month or year-to-date format. times and tour itineraries at its Squirrel
POS terminals.
Extensive reporting capabilities enhance the system's functionality. Daily CLUB
revenue and sales information may be exported to produce spreadsheets and The Squirrel Club System is designed to
graphic displays of POS data. meet the unique needs of different club
environments.To assure the ultimate in
member service,the Squirrel Club System
1.L�9:[iiuI :aWW14►111ailael I 1 :4'.1 :L1J 41'1 stores personal information on members,
spouses and dependents. Data may be
Gross Server Sales imported from an existing billing system or
EMPLOYEE APPTZR W YO BAREST ENTREE ADDONS DESSNT BEVRAG LIQUOR NE BEER TOTAL ACNK COVER entered manually.When ordering, member
account information may be accessed by
Bill 76.55 557.20 25.65 44.50 59.70 85.15 111.50 960.45 24.01 40
Steve 74.05 442.65 20.90 49.00 70.85 27.90 354.90 53.75 1094.00 16.83 65 member name, member number or check
Brian 69.80 486.60 24.40 48.45 66.30 20.65 58.80 43.00 818.00 12.98 63 number in thepre-verification process to
Sam 67.65 465.60 27.35 38.60 51.50 142.70 244.85 28.50 1066.75 18.08 59
Judy 144.40 42.00 186.40 4.91 38 display pertinent member data.All orders
John 87.25 458.80 24.75 38.15 63,35 27.20 147.30 16.45 863.25 13.92 62
Edle 45.65 430.90 11.65 30.25 55.25 270.65 108.75 53.25 1006.65 20.13 50 for a given member automatically accumu-
Barry 133.00 104.40 237.40 6.59 36
late throughout the day. Of course,Squirrel
TOTALS 420.95 277.40 2841.75 135.10 248.95 51325 574.45 1026.10 194.95 6232.90 15.09 413 Club includes the flexible check billing
and presentation of the standard Squirrel
GRAPHIC System, and charges may be split and/or
- INTERFACE posted to multiple members'accounts.
When it is time to process member billing,
Server Sales POS transactions may be exported by
Daily management reports provide a
Bill __�11.• individual line item or in summary. With
convenient listing of sales performance Stave ____'
Brian the Squirrel Club System, member service
____
for each server. J dY =ENE' is heightened while billing accuracy and
John staff productivity are increased.
Edie
Barry iN---
50 5200 WO 5600 S000 51003 S1200
SQUiRREL teamed up with
human factors engineers, industrial designers , graphic
artists , our customers, and Microsoft® Windows NT®•
• CANCEL APPETIZERS SPAGO-DR DEAN Q
4
J OREENS NAYACNISALAO
y DELETE
I CHECKi NEW
4 SEAT
' SALAD MAINE SKATE MOUSSE 8 TERRINE 18 50
SEAT 1
PL
y REPLACE TOMATO w;ROO 1500
y 1 SOUP wfLOB MOUSSE i TERRINE SEAT S
CRAB B UNI 1800
MOP / CRAWFISH SALAD '4 0
•
MOVE I a UNI SARDINES SEATS
WARM SQUAB SAL 14 00
y
J +TEMPURA SM.SALMON A STUR
II PROMO
4 WISH SALAD TOMATO'MOO
yaSA 'TARTARE WARM SQUAB SAL
•
- GRAS a WAYS
.� .. • Entrees Beverages
• , L_ _
SELECT FUNCTION OR TAB
-J
Now restaurateurs have a "goof proof" graphical
user interface which is dramatically Easier
to Use • Naturally •
TM
Teamwork is magic=
n, 1r�
w � �
LATE CITY COUNCIL ITEM
Meeting Date: OCTOBER 28, 1999
1) Reason for the delay: CIRCUMSTANCES JUST PRESENTED THEMSELVES FOLLOWING
PREPARATION OF THIS AGENDA.
2) a) This document was not previously submitted per#1 above: x
b) This document incorporates the following changes to the original report which was
submitted with the Agenda packet:
3) The sense of urgency in presenting this to the City Council at this meeting is as follows:
EQUIPMENT NECESSARY FOR OPERATION OF THE NEW CLUBHOUSE AT
DESERT WILLOW THAT NEEDS TO BE OBTAINED PRIOR TO NOV. 18 MEETING.