Rock Climber's Store & Café
Rock Climber's Store & Café
BUSINESS PLAN THE BOULDER STOP
1455 Portland Street
Bend, Oregon 97701
This store will offer rock climbing gear to people heading to Smith Rock State Park. It is hoped this will become a regular stop for their three main target markets: weekend warriors, hard-core climbers, and the curious. The Boulder Stop will offer mrechandise that complements that of our competition, and their café, which will offer specialty Northwest coffees, will further distinguish them. This business plan was compiled using Business Plan Pro, © 1998, Palo Alto Software, www.paloaltosoftware.com, 800-229-7526.
- executive summary
- company summary
- products
- market analysis summary
- strategy & implementation summary
- management summary
- financial plan
EXECUTIVE SUMMARY
- The Boulder Stop will offer high-end rock climbing gear and classic Northwest coffee. We will purchase the gear wholesale and have it shipped via FedEx and UPS, both of which serve the Bend/Redmond business community. We will buy our freshly roasted coffee beans from Espresso Harvest, a Bend area distributor and reseller of gourmet coffee beans.
- The store is located one mile from Smith Rock State Park in the central Oregon desert. It is conveniently located in an area frequented by national and international tourists.
- 50 percent of profits will go to the owner, 25 percent to employees, and 25 percent to Smith Rock State Park restoration projects.
- This plan outlines the rewards—community and financial—of investment in the Boulder Stop.
Objectives
- To make the Boulder Stop a local favorite for tourists, hikers, and climbers on their way to/from Smith Rock.
- To achieve the largest market share in the region for rock climbing gear. We will use State of Oregon economic data to compile an estimate of market share goals for 1998.
- To be an active and vocal member of the community, and to provide continual reinvestment through sponsorship of community activities and celebrations. We will sponsor five or more events during the year, including fun climbs, family bouldering, and celebrity hosted competitions.
- To achieve a 65 percent gross margin within the first year. Our conservative projected gross margin is 45 percent.
- To achieve a net profit of $30,000 by year two. We will re-invest these profits in our business and our community's future.
Mission
The Boulder Stop is an equipment store and café specializing in premium rock climbing gear and coffee/espresso drinks. We believe rock climbing should be safe and fun. We understand that rock climbers need a healthy dose of the newest gear, fresh snacks, and raw caffeine.
Our goal is to be the centrifuge for rock climbers living in and visiting central Oregon. Smith Rock State Park is one of the finest rock climbing parks in the world. Our staff is fluent in several languages, including Spanish, German, and French. Locals and tourists alike will long for our hip, lively shop because of our staff, our setting, our gear, and our coffee.
We believe it is important to remain an active member of the community—to impact people's lives in more ways than deriving a profit from them. We host community events that bring out the best in people.
We will be the region's destination for those who want to know all there is to know about rock climbing gear, safety, rules, and events. The future of rock climbing in central Oregon will be determined by our level of commitment.
Keys to Success
To succeed in this business we must:
- Sell products that are of the highest reliability and quality. We must offer as many or more premium products than REI offers online and through their Eugene and Portland stores. This means we must carry all premium brands of harnesses, active protection, passive protection, helmets, ice-climbing gear, camping gear, and mountaineering gear.
- Offer loss leaders and other promotions that bring customers into the store to buy goods, explore our line of services, and sign up for future events.
- Provide for the satisfaction of 100 percent of our customers and vendors. Both are very valuable to us and we will design a customer care plan to manage complaints, implement employee and customer feedback, manage supplier accounts, and predict potential conflicts.
- Be an active member of the community: i.e., host sportclimbing and rock climbing events.
- Negotiate valuable contracts with great distributors such as Trago, Petzl, Black Diamond, Beal, Ushba Mountain Works, and others. To maintain a high margin business plan, we must negotiate a good cost structure.
COMPANY SUMMARY
The Boulder Stop is a purveyor of premium coffee and gear. The café is located one mile from Smith Rock State Park in central Oregon.
The Boulder Stop was incorporated in the state of Oregon on January 1, 1997. It is privately held and managed by Luke Walsh. The company has established a central office at 1455 Portland St., Bend, OR 97701. This location is designed for purchasing, storage, and contract negotiations. Service purchases will be forwarded to this office for review and approval. All PO authorizations will also be approved at this office.
Company Ownership
The Boulder Stop is a privately held corporation. Luke Walsh owns 60 percent of the Boulder Stop and his wife, Lisa, owns 40 percent. This company operates under the jurisdiction of the state of Oregon and the United States of America as an "S" Corporation. If the company shows steady exponential growth, the owners will prepare the company for re-establishment as a "C" corporation. As a "C" corporation, the owners will not be taxed at the higher maximum personal rate of 39.6 percent, but rather the company will be taxed at the maximum corporate rate of 34 percent. If the owners elect to administer the Boulder Stop as a "C" corporation, it will not be taken lightly. A company that moves from "S" to "C" status must remain in "C" status for a minimum of five years.
At the moment, the owners wish to benefit from the single taxation of an "S" corporation.
Start-up Summary
Our incorporation costs are listed below, as well as the cost of retaining a marketing consultant to manage local impact-management teams and to issue a community impact report to major public and private agencies within the region. Their job will be to inform the Boulder Stop owners about how to effectively communicate with the community leaders. Our lawyer will be responsible for preempting any local government conflicts having to do with zoning and/ or permit allowance.
There will be other normal business costs such as a $1,000,000 liability umbrella, rent, interior design costs, and opening day promotions.
The largest equipment purchase will be that of a Conti brand commercial espresso machine. This machine, named "The Twin Star," comes with an 18-month warranty on parts and 12 months warranty on labor. Their espresso machines are world renowned for their high quality and performance features. The machine will push steam through the espresso grounds at temperatures set by the user.
The company will start with two months' inventory on hand. The majority of company assets will reside in inventory. The starting cash balance will be $3,000.
The purpose of this business plan is to secure a $11,700 SBA loan. This loan appears in the long-term liability row of the following Start-up costs table.
Start-up Costs | |
Start-up Expenses | |
Legal | $300 |
Marketing consultant | $4,500 |
Business and liability insurance | $600 |
First month's payment + deposit | $2,500 |
Design costs | $3,500 |
First week promotion | $1,100 |
Expensed equipment | $3,500 |
Other | $0 |
Total Start-up Expenses | $16,000 |
Start-up Assets Needed | |
Cash Requirements | $3,000 |
Start-up inventory | $7,000 |
Other Short-term Assets | $1,000 |
Total Short-term Assets | $11,000 |
Long-term Assets | $0 |
Total Assets | $11,000 |
Total Start-up Requirements: | $27,000 |
Left to finance: | $0 |
Start-up Funding Plan | |
Investment | |
Luke Walsh | $10,900 |
Lisa Walsh | $2,900 |
Other | $0 |
Other | $0 |
Total investment | $13,800 |
Short-term Liabilities | |
Unpaid Expenses | $500 |
Short-term Loans | $0 |
Interest-free Short-term Loans | $1,000 |
Subtotal Short-term Liabilities | $1,500 |
Long-term Liabilities | $11,700 |
Total Liabilities | $13,200 |
Loss at Start-up | ($16,000) |
Total Capital | ($2,200) |
Total Capital and Liabilities | $11,000 |
Checkline | $0 |
Company Locations and Facilities
The company office is located in the owner's residence, 1455 Portland St., Bend, Oregon 97701. The office is about 1,000 square feet and has ample space for the first three years of growth. Deliveries and shipments are serviced through the store located at 432 Smith Rock Drive, Redmond, OR 97756. The 5,000-square-foot retail building is owned by the Boulder Stop and there is no excess storage capacity.
PRODUCTS & SERVICES
Espresso is the big money maker for the Boulder Stop, with coffee peripherals coming in at a close second. The rock climbing gear is a long-term sales project that will rely on future catalog and "word-of-mouth" sales to achieve a positive return on investment.
The Boulder Stop sells high-quality rock climbing gear to serious climbers. The gear is checked by knowledgeable employees who use and recommend equipment to customers and management. The gear is purchased from well-known manufacturers like Black Diamond, Boreal, and Petzl. Management will rely on employees and customers to shorten the feedback loop in product and service offerings. Climbing gear is delivered every Thursday via UPS.
Straight espresso bean rebuys arrive on Mondays and Thursdays, ensuring the freshest beans possible. Modified rebuys begin on the first of each month. The owner will oversee all purchases, shipments, and deliveries.
Product Description
The Boulder Stop sells the entire raft of coffee drinks: lattes, mochas, cappuccino, espresso, and a delicious house blend. The coffee and espresso beans are freshly roasted by Espresso Harvest. Our team of two part-time high school students will create the beverages for customers. They will be trained in "The Art of Making the Proper Espresso Beverage" at Espresso Harvest, which hosts such classes once a month.
The Boulder Stop also sells carabiners, friends, nuts, ropes, webbing, shoes, and harnesses; our product mix is sufficient to satisfy even the most hard-core enthusiast. Below is a listing of some high-end products that we market:
- Black Diamond Camalot Camming Device - $50 to $100
- Wild Country Forged Friends with Sling - $35 to $65
- Hugh Banner HMS Locking Carabiner - $12 to $17
- The North Face Bouldering Sweatshirt, Men's - $85 to $105
- Mammut Flash Duodess 10.5mm Dry Rope - $185 to $200
- Boreal Ace Rock Shoes - $150 to $170
All products are quality checked when they arrive and quality checked before the customer takes them home.
Competitive Comparison
The Boulder Stop has several advantages over its leading competitor.
- Newer inventory and more modern interior fixtures.
- Espresso drinks are made available to consumers while they shop, increasing marketing message impact. Our competitor offers the shopping experience that lacks the thrill of being able to sit down with friends, munch on a cookie, drink espresso, and "talk shop."
- The Boulder Stop is a fun, spacious store catering to both the climbing pros and the inexperienced. Our competitor, Rockage, is an exclusive Pro shop that discourages some newcomers to the sport. Our positioning encourages those just getting started, a one-stop destination for equipment advice and purchasing opportunities, technique and safety instruction, and conversation with other enthusiasts.
- We expect a high degree of expertise and enthusiasm from our employees and we compensate them accordingly. All employees are hired for their expertise and enthusiasm and will be paid at a rate well above the minimum wage to facilitate low-turnover and long-term loyalty.
Sales Literature
The Boulder Stop will use advertising and sales programs to get the word out to customers.
- 2,000 four-color brochures to be distributed throughout Bend and area facilities: outdoor clothing shops, hotels, ranger stations, chambers of commerce, tourism council offices, area eateries, and other tourist-frequented spots one month before the grand opening in May.
- Half-page newspaper advertisements in Oregon regional newspapers, advertising the following sales promotion: introductory rock-climbing classes, two days for $100 per person. Copy: magazine and newspaper advertisements.
- Web promotions: we will administer a website at www.boulder-stop.com. This website will present promotional material such as new marketing programs, product white papers, and contests. The site will allow for immediate purchase of gear online and will use a secure server to process transactions through Cybercash.
Sourcing
Sourcing is critical for any enterprise, especially a retail operation. The Espresso Harvest will be our coffee vendors, and will handle many in-store merchandising issues for their line of coffee products. Operational supplies for the coffee bar will be purchased from the regional supply wholesaler, who will handle special merchandising issues, such as point-of-sale materials. The sport and recreation inventory will be sourced directly from manufacturers like Black Diamond, Boreal, and Petzl.
We will solidify relationships with vendors so that we may achieve decreased cost-of-goods. Our competitor buys from some of the same vendors we do, yet we believe that through marketing programs and strategic alliances we will gain more loyalty from these vendors. This is our long-term strategy for gaining a sourcing competitive advantage.
Advertising costs are outsourced. Most sales promotion and public relations work is handled in-house by Luke. Luke will write all product white-papers and combine those with literature supplied by the manufacturer.
Future seminars and climbing clinics will be handled either by the owner or by several certified and experienced tour and adventure professionals. We will use local contacts to research the availability of celebrity climbers to sponsor some of these clinics and events. We believe this tactic will build a grassroots network of climbers that will help us to differentiate the Boulder Stop as a "hang-out" for serious and curious climbers.
Technology
We use off-the-shelf, PC-based software for accounting purposes, including AR/AP, inventory, purchasing, sales, and returns.
Our business plan is generated on an annual basis using Business Plan Pro from Palo Alto Software, and reviewed quarterly for evaluation. Further functionality is provided by Palo Alto Software's companion package, Marketing Plan Pro, which allows us to make the most use of our marketing dollars by focusing our communications on target markets and enhancing our marketing knowledge.
We are in the process of implementing a website for the Boulder Stop. Online commerce is becoming an increasingly attractive option due to the relatively low cost-of-goods, the global reach of the medium, and the increasing security. Our business model could quite conceivably expand to include a form of Internet commerce in a variety of adventure equipment.
Future Products
Future expansion may allow for a horizontal increase of our product line by offering additional product categories: water sport gear, camping gear, and mountain biking accessories. We won't rule out the possibility of vertically integrating through our own line of climbing gear and/or espresso. We will also explore new services such as gear storage lockers, cellular phone rentals, and same-day guide services.
One dream the owner has is to develop an Internet environment within the store, not to remove people from those surrounding them, but to help them stay in touch with friends, family, and the latest information about rock climbing.
MARKET ANALYSIS SUMMARY
Consumer expenditures for rock climbing equipment rose to $4,000,000 in central Oregon in 1997. We expect sales to increase steadily as Oregon's population grows and the rock climbing industry becomes increasingly popular.
The western Oregon presence of several large universities helps fuel our business, as does the status of Smith Rock as an international destination spot for rock climbing enthusiasts. Individuals from as far away as Japan, Europe, South America, and Australia seek out Smith Rock as a beautiful and challenging sport and rock climbing destination. We count worldwide readers of such publications as Rock & Ice magazine and Outdoor Adventure among our target audience.
Our three main target markets are weekend warriors, hard-core climbers, and the curious. We predict that the number of hard-core climbers will grow faster than the number of weekend warriors. Climbing is becoming more and more technical, an "Insider's sport," and we believe this will fuel the growth of dedicated, highly sophisticated climbers.
This market analysis is somewhat conservative when compared with Oregon's predicted population growth of 2 percent per year and Bend's 5 percent average gains over the last five years.
Market Segmentation
- The weekend warriors purchase during weekends. When these climbers are on a rock wall, they want to look cool. They want to hang out with their friends at Smith Rock and enjoy a nice pre-climb or post-climb espresso drink or ice cream cone. Weekend warriors plan special events with family members and friends. This market is our target for special events and climbing services such as tours and fun climbs.
- Hard-core climbers are very fickle about the gear they use. This segment is very brand loyal and provides the company with powerful word-of-mouth marketing. They are highly sophisticated climbers who know the jargon and want to let everyone know they are serious about the sport and its image.
- The curious want to stop in for a gander on their way to their campsites or hotel rooms. They may be into hiking Smith Rock State Park, or just taking a driving tour, it doesn't matter. They may be travelers or locals, depending upon the season and the event.
Market Analysis | |||||||
Potential Customers | Growth | 1997 | 1998 | 1999 | 2000 | 2001 | CAGR |
Weekend warriors | 2% | 40,000 | 40,600 | 41,209 | 41,827 | 42,454 | 1.50% |
Hard-core climbers | 2% | 2,300 | 2,337 | 2,374 | 2,412 | 2,451 | 1.60% |
The curious | 2% | 30,000 | 30,570 | 31,151 | 31,743 | 32,346 | 1.90% |
Other | 0% | 0 | 0 | 0 | 0 | 0 | 0.00% |
Total | 1.67% | 72,300 | 73,507 | 74,734 | 75,982 | 77,251 | 1.67% |
Target Market Segment Strategy
We will focus on the highly discriminating hard-core climber segment first, because these are the opinion leaders. Both the weekend warrior and the curious will follow the hard-core climbers. If we can attract and keep the hard-core climbers, then they will attract others. To attract hard-core climbers, we will carry all the best high-tech gear, know the jargon, use the latest technology, and become a "futurist" product and services company.
We want to clearly differentiate the weekend warriors from the hard-core climbers. Less competitive, or at least at a different competitive level, these climbers are usually at Smith Rock to hike or explore. They respect the hard-core climbers, but don't want to be classified as having "rock on the brain." Twenty to 30 percent of these climbers will respond to family events by bringing their families, the other 70-80 percent climb with friends and occasionally try to outdo each other. This market is highly susceptible to getting stuck in a coffee shop with friends, they will talk about their latest romance, conflicts with other friends, the future, or the fine espresso at the Boulder Stop. We will market the weekend warriors with a combination of amateur climbing events and family fun climbs.
Market Needs
There are two important underlying needs, and the combination of gear and coffee serves both. In many ways the Boulder Stop mimics the positioning of a ski lodge; selling crucial gear while providing a place for coffee, snacks, and talk.
- There is a real need for a highly professional provider of climbing gear near the Smith Rock location. People forget to pack exactly what they need, and things break.
- There is also a practical need for coffee, a meeting place, and conversation. This is the activity focus of the location.
Market Trends
Trends are in our favor. There are three major trends at work in our market:
- Outdoor sports in general and rock climbing in particular are gaining exposure. The rock climbing gyms in the Silicon Valley, Seattle, Eugene, and other locations are clear evidence of this trend.
- Central Oregon is becoming a major vacation destination and recreation spot.
- The gourmet coffee trend started in the Northwest, and is spreading throughout the nation. A growing number of people look to their high-end coffee drinks as a way to enjoy a moment, and as an integral part of any outing or activity.
Market Growth
- Vacation spending in Oregon is growing more than 25 percent per year.
- Over the last five years, spending on climbing has grown faster than spending on skiing or mountain biking, although from a much smaller base. The industry will experience 130 percent growth over the next three years.
- Coffee spending is up 15 percent this year.
Industry Analysis
The rock-climbing industry is expanding faster than ever. Although climbing gear is priced at a premium, people buy it because it provides them with adventurous and, naturally, safer climbs.
High profit margins on coffee sales and low overhead costs lead to high profit margins in the espresso industry. Expansion of coffee and espresso retail outlets has increased exponentially in the last five years as large companies such as Starbucks have increased their reach to the East Coast in cities such as Boston, New York, and Washington D.C.
Industry Participants
The rock climbing gear industry is still fairly young. Climbing stores are generally small in size and community oriented. These stores seek to attract the most knowledgeable $6-8/hour employees. There are some bigger players that serve a larger, less targeted community with rock gear and gear for dozens of other outdoor sports. These national participants are consistent about their message and carry an impressive array of gear, but only the largest stores combine an espresso shop with the "Yuppie" shopping experience.
Participants in the espresso market are big name retailers. These retailers focus on the standardized model. Under this model, a buyer will get the same service and same beverage in New York as the one they will get in downtown Bend. This leads to a backlash of sorts, as local consumers move to industry participants that differentiate their companies from the national standardized model. The product becomes localized and the buyer recognizes the value of supporting a business that keeps its profits in the community that created the profit.
Distribution Patterns
Traditional distribution channels are followed. The products are bought from wholesalers who have little say in how products are marketed, beyond the occasional sales promotion display provided via the manufacturer. This is beneficial in keeping the marketing and product costs low, while maintaining profit margins of 60 percent or more.
Customers are very brand oriented and affect the distribution patterns (rebuys) on the retail end. As consumers become increasingly aware of the Internet's potential, they will begin to buy product directly from the manufacturer. This will not hurt our business because a.) we have a website, direct distribution model of our own and b.) our location and convenience create an advantage for us. We will create in-store kiosks linked to our website. For now we will build on the strengths of location. If distribution patterns shift to a direct model, we build our business under the direct model.
Competition and Buying Patterns
Climbers demand knowledgeable employees in a convenient location.
- Comparison: Rock Stop has placed its stores in urban industrial areas. Mountain Gear, a wholesaler, implements a similar strategy that draws the suburban dweller out of the house. This strategy keeps these customers isolated from the competition.
- Products and services are the most important factors when selling rock climbing gear. Brand name products sell well in stores that maintain a good selection, good location, and knowledgeable, friendly employees.
- Espresso shops need to be fast, efficient, and friendly. Fortunately, there are no espresso shops in close proximity to the Boulder Stop.
Main Competitors
Our nearest competitor is Sportswhere. Our next closest competitor is Blue Mountain Climbing Gear, located in Redmond, 7 miles from our store. Neither of these retailers offers espresso to their customers.
- Sportswhere sells limited gear (clothes), they do not promote, or otherwise market their products extensively. They sell ice cream and carry more GenX apparel than the Boulder Stop. In fact, their biggest strength may be that they may potentially become our ally. We see their products as complementary to ours: Ice Cream vs. Espresso. Their biggest weakness is limited store space.
- Blue Mountain Climbing Gear will be our toughest competitor, for they have already established themselves in the rock climbing community. They have a very experienced and knowledgeable staff of expert climbers, and are located on highway 97, 2 miles from Smith Rock. They carry 75-80 percent of the same gear that we do.
STRATEGY & IMPLEMENTATION SUMMARY
The Boulder Stop uses a strategy of total market service.
Assumptions:
- Every person is a potential customer and all our potential markets will experience growth.
- Marketing to one segment of the population will lead to an expansion in overall market growth.
Strategy Pyramids
Our main strategy is to develop the Boulder Stop experience as part of the rock climbing activity. We don't intend to be just a store, but rather a rock climbing cultural center for regulars and visitors to Smith Rock.
Underneath this strategy, our first tactic emphasizes the needs of the hard-core climber. We assume that participation of the hard-core set will generate interest for others.
Value Proposition
The Boulder Stop gives Smith Rock visitors the highest quality climbing gear, good coffee, and a place to meet, in a convenient locale.
Competitive Edge
Our location is a very important competitive edge. It will be difficult for our competitors to match our location.
The other competitive edge in development is our reputation and involvement with the community. The Boulder Stop is part of the Smith Rock experience, like the photography store used to be, in Yosemite Valley. That is why we are developing a community of employees who are rock climbers, and promoting rock climbing events, bulletin boards, etc. This advantage is important to us because our prices are slightly higher than other cafés and other gear stores in Oregon.
Marketing Strategy
Our marketing strategy will focus on three segments. Those three segments are described in the following subtopics.
- The plan will benchmark our objectives for sales promotion, mass selling, and personal selling.
- We are focusing our marketing effort on the weekend warriors and the hard-core climbing community. We will implement a strategy that treats these customers as a community. This means our marketing resources will be centered around both sales promotions (events, displays) and personal sales (customer service, friendly atmosphere).
- The marketing budget will not exceed $5,000 per year.
- Marketing promotions will be consistent with the mission statement.
Positioning Statements
For climbers who need a place to stop for gear and coffee near Smith Rock, the Boulder Stop offers high quality climbing gear, gourmet espresso drinks, and a comfortable place to meet and talk. Unlike our competitors, our store is near the park and offers exactly what most climbers and tourists need.
Pricing Strategy
We will encourage impulse buying, therefore it is important that we maintain a flexible pricing strategy.
- Our pricing strategy will be based on competitive parity guidelines. We will not exceed competitors' prices by more than 10 percent, and if a customer sees a price elsewhere for less, we will give it to them for that price.
- Price says a lot about a product. The products that are innovative and not available elsewhere in the region will be marked up to meet the demand curve. We are not afraid of premium pricing a premium product.
- Espresso beverages will be priced slightly above the industry average. Although we will still make money off our house coffee (not espresso), we consider this a "loss leader" product. Word-of-mouth advertising brings customers in for the house coffee, simply to make them aware of our additional products and services.
Promotion Strategy
The Boulder Stop will implement a strong sales promotion strategy. Advertising will be secondary.
- Wewill pay to $4,000 to determine the needs of the surrounding population and how the company may best meet those needs with promotions, literature, and other marketing programs.
- Promotional campaigns will be partially outsourced.
- Advertising will be consistent.
- Sales promotions and public relation strategies will work together to inform customers of new products, to encourage an image of community involvement for the Boulder Stop, and to limit environmental impact.
Distribution Strategy
The customers will buy our products directly from the store, in the store. We will also generate sales through our website and its secure server and we will ship all ordered products from the store. All telephone orders will be taken at the store through either our singletoll free line or the local number. Mail orders will be processed at the main office in Bend and shipped from the store. All debits and credits, order transactions, charge backs, and price discounts will be accounted for on the SBT Accounting system at the Bend office.
Sales Strategy
We will appeal to the weekend warriors by hosting fun events like the "Fun Summer Climb." Our part-time sales clerks, also trained in the ways of promotional tactics, will call businesses within the Bend area and establish additional sponsors for these events. They will close the sale immediately, if possible, enter the closure into the software accounting system, and provide post sales follow-up.
For in-store sales, our strategy will be to maintain as much on-site point-of-purchase literature as is physically possible. Our part-timers will be responsible for informing customers of the products and creating the best fit between customer and product. Our salespeople will understand that selling is about filling a need, not pressuring the customer to buy. Seventy to 80 percent of returns will be sent back to the distributor or vendor.
Sales Forecast
The following table and chart give a rundown on forecasted sales. We expect sales to increase at a rate of 1-2 percent per month for each product in the first few months.
November through January will be slow months for the Boulder Stop. For February through March, we expect 1 percent monthly sales growth becoming 2 percent growth as we reach the second summer. In 1999 and 2000, we expect solid 20-25 percent sales growth as the Boulder Stop becomes well-known in central Oregon. 1999 and 2000 costs will decrease 4-7 percent due to lower agency and efficiency costs.
Note: For company purchases, the per-unit price of inventory purchases includes cost of shipping.
Sales Forecast | |||
Sales | FY1998 | FY1999 | FY2000 |
Carabiners | $16,784 | $20,141 | $25,176 |
Ropes | $9,791 | $11,749 | $14,686 |
Books and Magazines | $1,798 | $2,158 | $2,697 |
Cookies | $1,573 | $1,888 | $2,360 |
Espresso regulars | $57,695 | $69,233 | $86,542 |
Espresso shakes | $7,418 | $8,901 | $11,127 |
Gear rentals | $1,961 | $2,353 | $2,941 |
Other | $0 | $0 | $0 |
Total Sales | $97,019 | $116,423 | $145,529 |
Direct Cost of Sales | |||
Carabiners | $9,754 | $8,779 | $7,462 |
Ropes | $6,069 | $5,462 | $4,643 |
Books and Magazines | $1,300 | $1,170 | $995 |
Cookies | $748 | $673 | $572 |
Espresso regulars | $30,148 | $27,134 | $23,064 |
Espresso shakes | $4,547 | $4,092 | $3,479 |
Gear rentals | $1,286 | $1,158 | $984 |
Other | $0 | $0 | $0 |
Subtotal Cost of Sales | $53,854 | $48,468 | $41,198 |
Sales Programs
Sales programs will include sales awards for highest sales and customer service awards for those employees who best exemplify the Boulder Stop's commitment to customers. The owner will award these valuable employees yearly with a $200-300 vacation to the Sunriver Resort in Bend.
- We will request rebate info from manufacturers and use those rebates to drive traffic to the store. We will also offer coupons in local area newspapers. These coupons will offer buyers from 100 to 50 percent off any espresso drink and/or buy-one-get-one-free espresso programs.
- We will offer gear rentals all week. This will let climbers who don't have 100 percent of the gear climb with their friends, creating goodwill and repeat customers. We will not rent carabiners, ropes, or cams; only shoes, bags, and helmets.
Milestones
The milestone table shows purchasing, sales, and marketing goals. The owner will conduct straight rebuys while touching base with Espresso Harvest. We have paid a deposit of $700 (06/28/97) to establish a 30-day grace period on all purchases from Espresso Harvest. There is no franchise fee and Espresso Harvest will donate advertising, consulting, and literature, provided that 40 percent of sales from Espresso Harvest mugs, cups, and T-shirts go directly to Espresso Harvest, Inc.
Milestones | |||||
Milestone | Start Date | End Date | Budget | Manager | Department |
COGS | 6/30/98 | 7/30/98 | $4,000 | Luke Walsh | Purchasing |
Meet with rep | 6/25/98 | 6/30/98 | $700 | Luke Walsh | Sales |
Complete advertising | 6/26/98 | 6/26/98 | $500 | Luke Walsh | Marketing |
COGS | 7/30/98 | 8/30/98 | $4,000 | Luke Walsh | Purchasing |
Perry Claw Rock Festival | 8/23/98 | 9/23/98 | $650 | Luke Walsh | Marketing |
COGS | 8/30/98 | 9/30/98 | $4,000 | Luke Walsh | Purchasing |
Straight rebuy | 9/30/98 | 9/30/98 | $4,000 | Luke Walsh | Purchasing |
Straight rebuy | 10/30/98 | 10/30/98 | $2,500 | Luke Walsh | Purchasing |
Straight rebuy | 11/30/98 | 11/30/98 | $500 | Luke Walsh | Purchasing |
Other | 1/1/98 | 1/1/98 | $0 | ABC | Department |
Totals | $20,850 |
MANAGEMENT SUMMARY
The owner of the Boulder Stop believes very strongly that relationships should be forthright, work should be structured with enough room for creativity, and pay should be commensurate with the amount and quality of work completed. The company is young enough that the only manager this philosophy applies to is the president.
The president will assess the productivity of the two part-time employees every six months.
Organizational Structure
The Boulder Stop is not departmentalized. The owner, Luke Walsh, is also the president, CFO, and lead manager. The company makes all decisions in accordance with the company mission. Employees are given specific tasks based upon their creativity, knowledge, and social ability.
Management Team
Luke Walsh: Manager and founder.
Luke spent four years selling shoes and apparel for Nordstrom, Inc. He graduated from the University of Oregon in 1997 with a degree in Business Management. Luke's success at Nordstrom, the university, and in building a network of close friends has hinged upon his "common sense" approach to solving ambiguous problems, his ability to identify strengths and weaknesses in the marketplace and exploit them, as well as his commitment to building strong relationships through trust, not politics. These skills, combined with formal business training make him an ideal community leader and business owner.
Personnel Plan
The personnel plan is included in the following table. It shows the owner's salary (Other) followed by two part-time salaries for espresso servers/gear experts. Part-time employees will not be included in the profit-sharing program until they have worked with the company for twelve months. All part-time employees will start at $8/hr and receive full health benefits.
Personnel Plan
Personnel Plan | |||
Personnel | FY1998 | FY1999 | FY2000 |
Part-time employee #1 | $4,700 | $4,935 | $5,182 |
Part-time employee #2 | $4,700 | $4,935 | $5,182 |
Other | $0 | $0 | $0 |
Total Payroll | $9,400 | $9,870 | $10,364 |
Total Headcount | 0 | 0 | 0 |
Payroll Burden | $376 | $395 | $415 |
Total Payroll Expenditure | $9,776 | $10,265 | $10,778 |
Financial Plan
- Growth will be moderate, cash balance always positive.
- Marketing will remain at or below 15 percent of sales.
- The company will invest residual profits into company expansion and personnel.
Important Assumptions
We do not sell anything on credit. The personnel burden is very low because benefits are not paid to part-timers. And the short-term interest rate is extra ordinarily low because of the owner's long-standing relationship with the USAA Credit Union.
General Assumptions | |||
FY1998 | FY1999 | FY2000 | |
Short-term Interest Rate % | 7.00% | 7.00% | 7.00% |
Long-term Interest Rate % | 7.50% | 7.50% | 7.50% |
Payment Days Estimator | 35 | 35 | 35 |
Collection Days Estimator | 30 | 30 | 30 |
Inventory Turnover Estimator | 12.00 | 12.00 | 12.00 |
Tax Rate % | 30.00% | 30.00% | 30.00% |
Expenses in Cash % | 25.00% | 25.00% | 25.00% |
Sales on Credit % | 0.00% | 0.00% | 0.00% |
Personnel Burden % | 4.00% | 4.00% | 4.00% |
Break-even Analysis
For our Break-even Analysis, we have chosen $3.00 to represent our average revenue per unit. Although revenue from ropes and other gear amount to significantly more revenue per unit, such items skew the revenue curve toward less units sold. We want to engage in a practical analysis of precisely what it will take to turn the company profitable by using the P&L statement. The Break-even Analysis is a gauge by which we can measure our monthly revenue streams to predict long-term profitability.
According to the analysis, we will break-even at approximately $6,000 in monthly sales.
Break-even Analysis: | |
Monthly Units Break-even | 2,000 |
Monthly Sales Break-even | $6,000 |
Assumptions: | |
Average Per-Unit Revenue | $3.00 |
Average Per-Unit Variable Cost | $0.75 |
Estimated Monthly Fixed Cost | $4,500 |
Projected Profit and Loss
We predict advertising costs and consulting costs will go up in the next three years. This will give the Boulder Stop a profit-to-sales ratio of nearly 31 percent by the year 2000. Normally, a start-up concern will operate with negative profits through the first two years. We will avoid that kind of operating loss by knowing our competitors, our target markets, industry direction, and the products we sell.
Note that we predict we will exceed our objective of 65 percent gross margin by the year 2000.
Profit and Loss (Income Statement) | FY1998 | FY1999 | FY2000 |
Sales | $97,019 | $116,423 | $145,529 |
Direct Cost of Sales | $53,854 | $48,468 | $41,198 |
Production Payroll | $0 | $0 | $0 |
Other | $0 | $0 | $0 |
—————— | —————— | —————— | |
Total Cost of Sales | $53,854 | $48,468 | $41,198 |
Gross Margin | $43,165 | $67,955 | $104,331 |
Gross Margin % | 44.49% | 58.37% | 71.69% |
Operating expenses: | |||
Advertising/Promotion | $3,740 | $3,100 | $3,500 |
Travel | $300 | $0 | $0 |
Miscellaneous | $0 | $0 | $0 |
Payroll Expense | $9,400 | $9,870 | $10,364 |
Payroll Burden | $376 | $395 | $415 |
Depreciation | $1,200 | $1,236 | $1,273 |
Leased Equipment | $0 | $0 | $0 |
Utilities | $1,569 | $1,616 | $1,665 |
Insurance | $780 | $803 | $828 |
Lease | $20,400 | $21,012 | $21,642 |
Other | $0 | $0 | $0 |
Total Operating Expenses | $37,765 | $38,032 | $39,686 |
Profit Before Interest and Taxes | $5,400 | $29,922 | $64,645 |
Interest Expense Short-term | $0 | $0 | $0 |
Interest Expense Long-term | $770 | $572 | $356 |
Taxes Incurred | $1,389 | $8,805 | $19,287 |
Extraordinary Items | $0 | $0 | $0 |
Net Profit | $3,241 | $20,546 | $45,003 |
Net Profit/Sales | 3.34% | 17.65% | 30.92% |
Projected Cash Flow
We are positioning ourselves in the market as a medium risk concern with steady cash flows. Accounts payable is paid at the end of each month while sales are in cash, and this gives the Boulder Stop an excellent cash flow structure. Solid Net Working Capital and intelligent marketing will secure a cash balance of $31,000 by January 1, 2000. Any amounts above $10,000 will be invested into semi-liquid stock portfolios to decrease the opportunity cost of cash held. The interest will show up as Dividends in the Projected Cash Flow table and will be updated quarterly.
Projected Cash Flow | |||
FY1998 | FY1999 | FY2000 | |
Net Profit | $3,241 | $20,546 | $45,003 |
Plus: | |||
Depreciation | $1,200 | $1,236 | $1,273 |
Change in Accounts Payable | $9,997 | ($719) | $786 |
Current Borrowing (repayment) | $0 | $0 | $0 |
Increase (decrease) Other Liabilities | $0 | $0 | $0 |
Long-term Borrowing (repayment) | ($2,640) | ($2,880) | ($2,880) |
Capital Input | $0 | $0 | $0 |
Subtotal | $11,798 | $18,182 | $42,610 |
Less: | |||
Change in Accounts Receivable | $0 | $0 | $0 |
Change in Inventory | $2,821 | ($982) | ($1,326) |
Change in Other ST Assets | $0 | $0 | $0 |
Capital Expenditure | $0 | $0 | $0 |
Dividends | $0 | $0 | $0 |
Subtotal | $2,821 | ($982) | ($1,326) |
Net Cash Flow | $8,978 | $19,164 | $43,935 |
Cash Balance | $11,978 | $31,142 | $75,078 |
Projected Balance Sheet
All of our tables will be updated monthly to reflect past performance and future assumptions. Future assumptions will not be based on past performance but rather economic cycle activity, regional industry strength, and future cash flow possibilities. We expect solid growth in Net Worth beyond the year 2000.
Projected Balance Sheet | |||
Assets | |||
Short-term Assets | FY1998 | FY1999 | FY2000 |
Cash | $11,032 | $28,390 | $73,735 |
Accounts Receivable | $0 | $0 | $0 |
Inventory | $9,821 | $8,838 | $7,513 |
Other Short-term Assets | $1,000 | $1,000 | $1,000 |
Total Short-term Assets | $21,853 | $38,229 | $82,247 |
Long-term Assets | |||
Capital Assets | $0 | $0 | $0 |
Accumulated Depreciation | $1,200 | $2,436 | $3,709 |
Total Long-term Assets | ($1,200) | ($2,436) | ($3,709) |
Total Assets | $20,653 | $35,793 | $78,538 |
Projected Balance Sheet
Liabilities and Capital | FY1998 | FY1999 | FY2000 |
Accounts Payable | $9,552 | $7,026 | $7,649 |
Short-term Notes | $0 | $0 | $0 |
Other Short-term Liabilities | $1,000 | $1,000 | $1,000 |
Subtotal Short-term Liabilities | $10,552 | $8,026 | $8,649 |
Long-term Liabilities | $9,060 | $6,180 | $3,300 |
Total Liabilities | $19,612 | $14,206 | $11,949 |
Paid in Capital | $13,800 | $13,800 | $13,800 |
Retained Earnings | ($16,000) | ($12,759) | $7,787 |
Earnings | $3,241 | $20,546 | $45,003 |
Total Capital | $1,041 | $21,587 | $66,589 |
Total Liabilities and Capital | $20,653 | $35,793 | $78,538 |
Net Worth | $1,041 | $21,587 | $66,589 |
Business Ratios
We expect our net profit margin, gross margin, and ROA to increase steadily over the three-year period. ROE will decrease due to lower equity needs and higher cash inflow. Our net working capital will increase to almost $74,000 by year three, proving that we have the cash flows to remain a going concern. The following table shows these important financial ratios.
Ratio Analysis | ||||
Profitability Ratios: | FY1998 | FY1999 | FY2000 | RMA |
Gross Margin | 44.49% | 58.37% | 71.69% | 0 |
Net Profit Margin | 3.34% | 17.65% | 30.92% | 0 |
Return on Assets | 15.69% | 57.40% | 57.30% | 0 |
Return on Equity | 311.31% | 95.18% | 67.58% | 0 |
Activity Ratios | ||||
AR Turnover | 0.00 | 0.00 | 0.00 | 0 |
Collection Days | 0 | 0 | 0 | 0 |
Inventory Turnover | 6.40 | 5.20 | 5.04 | 0 |
Accounts Payable Turnover | 6.72 | 10.43 | 10.43 | 0 |
Total Asset Turnover | 4.70 | 3.25 | 1.85 | 0 |
Debt Ratios | ||||
Debt to Net Worth | 18.84 | 0.66 | 0.18 | 0 |
Short-term Liability to Liability | 0.54 | 0.56 | 0.72 | 0 |
Liquidity Ratios | ||||
Current Ratio | 2.07 | 4.76 | 9.51 | 0 |
Quick Ratio | 1.14 | 3.66 | 8.64 | 0 |
Net Working Capital | $11,301 | $30,203 | $73,598 | 0 |
Interest Coverage | 7.01 | 52.36 | 181.84 | 0 |
Additional Ratios | ||||
Assets to Sales | 0.21 | 0.31 | 0.54 | 0 |
Debt/Assets | 95% | 40% | 15% | 0 |
Current Debt/Total Assets | 51% | 22% | 11% | 0 |
Acid Test | 1.14 | 3.66 | 8.64 | 0 |
Asset Turnover | 4.70 | 3.25 | 1.85 | 0 |
Sales/Net Worth | 93.19 | 5.39 | 2.19 | 0 |
Dividend Payout | $0 | $0 | $0 | $0 |
APPENDIX
Projected Balance Sheet
Assets | ||||||
Short-term Assets | Starting Balances | May | Jun | Jul | Aug | Sep |
Cash | $3,000 | $10,046 | $14,369 | $16,708 | $18,790 | $20,484 |
Accounts Receivable | $0 | $0 | $0 | $0 | $0 | $0 |
Inventory | $7,000 | $3,805 | $3,729 | $3,654 | $3,581 | $3,402 |
Other Short-term Assets | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
Total Short-term Assets | $11,000 | $14,851 | $19,097 | $21,362 | $23,372 | $24,887 |
Long-term Assets | ||||||
Capital Assets | $0 | $0 | $0 | $0 | $0 | $0 |
Accumulated Depreciation | $0 | $100 | $200 | $300 | $400 | $500 |
Total Long-term Assets | $0 | ($100) | ($200) | ($300) | ($400) | ($500) |
Total Assets | $11,000 | $14,751 | $18,897 | $21,062 | $22,972 | $24,387 |
Liabilities and Capital | ||||||
Accounts Payable | $500 | $2,995 | $5,556 | $5,909 | $5,954 | $5,459 |
Short-term Notes | $0 | $0 | $0 | $0 | $0 | $0 |
Other Short-term Liabilities | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
Subtotal Short-term Liabilities | $1,500 | $3,995 | $6,556 | $6,909 | $6,954 | $6,459 |
Long-term Liabilities | $11,700 | $11,480 | $11,260 | $11,040 | $10,820 | $10,600 |
Total Liabilities | $13,200 | $15,475 | $17,816 | $17,949 | $17,774 | $17,059 |
Paid in Capital | $13,800 | $13,800 | $13,800 | $13,800 | $13,800 | $13,800 |
Retained Earnings | ($16,000) | ($16,000) | ($16,000) | ($16,000) | ($16,000) | ($16,000) |
Earnings | $0 | $1,476 | $3,281 | $5,313 | $7,397 | $9,527 |
Total Capital | ($2,200) | ($724) | $1,081 | $3,113 | $5,197 | $7,327 |
Total Liabilities and Capital | $11,000 | $14,751 | $18,897 | $21,062 | $22,972 | $24,387 |
Net Worth | ($2,200) | ($724) | $1,081 | $3,113 | $5,197 | $7,327 |
Oct | Nov | Dec | Jan | Feb | Mar | Apr |
$20,563 | $21,488 | $19,401 | $18,599 | $20,938 | $13,302 | $11,032 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 |
$2,552 | $1,914 | $1,435 | $1,005 | $10,667 | $9,821 | $9,821 |
$1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
$24,114 | $24,402 | $21,836 | $20,603 | $32,605 | $24,122 | $21,853 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 |
$600 | $700 | $800 | $900 | $1,000 | $1,100 | $1,200 |
($600) | ($700) | ($800) | ($900) | ($1,000) | ($1,100) | ($1,200) |
$23,514 | $23,702 | $21,036 | $19,703 | $31,605 | $23,022 | $20,653 |
$3,867 | $3,210 | $1,586 | $1,356 | $16,347 | $9,918 | $9,552 |
$0 | $0 | $0 | $0 | $0 | $0 | $0 |
$1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 |
$4,867 | $4,210 | $2,586 | $2,356 | $17,347 | $10,918 | $10,552 |
$10,380 | $10,160 | $9,940 | $9,720 | $9,500 | $9,280 | $9,060 |
$15,247 | $14,370 | $12,526 | $12,076 | $26,847 | $20,198 | $19,612 |
$13,800 | $13,800 | $13,800 | $13,800 | $13,800 | $13,800 | $13,800 |
($16,000) | ($16,000) | ($16,000) | ($16,000) | ($16,000) | ($16,000) | ($16,000) |
$10,467 | $11,532 | $10,710 | $9,827 | $6,958 | $5,024 | $3,241 |
$8,267 | $9,332 | $8,510 | $7,627 | $4,758 | $2,824 | $1,041 |
$23,514 | $23,702 | $21,036 | $19,703 | $31,605 | $23,022 | $20,653 |
$8,267 | $9,332 | $8,510 | $7,627 | $4,758 | $2,824 | $1,041 |
Projected Cash Flow
May | Jun | Jul | Aug | Sep | Oct | |
Net Profit | $1,476 | $1,806 | $2,031 | $2,085 | $2,130 | $940 |
Plus: | ||||||
Depreciation | $100 | $100 | $100 | $100 | $100 | $100 |
Change in Accounts Payable | $2,495 | $2,561 | $353 | $45 | ($495) | ($1,592) |
Current Borrowing (repayment) | $0 | $0 | $0 | $0 | $0 | $0 |
Increase (decrease) Other Liabilities | $0 | $0 | $0 | $0 | $0 | $0 |
Long-term Borrowing (repayment) | ($220) | ($220) | ($220) | ($220) | ($220) | ($220) |
Capital Input | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal | $3,851 | $4,247 | $2,264 | $2,010 | $1,515 | ($772) |
Less: | ||||||
Change in Accounts Receivable | $0 | $0 | $0 | $0 | $0 | $0 |
Change in Inventory | ($3,195) | ($76) | ($75) | ($73) | ($179) | ($851) |
Change in Other Short-term Assets | $0 | $0 | $0 | $0 | $0 | $0 |
Capital Expenditure | $0 | $0 | $0 | $0 | $0 | $0 |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal | ($3,195) | ($76) | ($75) | ($73) | ($179) | ($851) |
Net Cash Flow | $7,046 | $4,323 | $2,339 | $2,083 | $1,694 | $78 |
Cash Balance | $10,046 | $14,369 | $16,708 | $18,790 | $20,484 | $20,563 |
Nov | Dec | Jan | Feb | Mar | Apr |
$1,065 | ($821) | ($883) | ($2,869) | ($1,934) | ($1,783) |
$100 | $100 | $100 | $100 | $100 | $100 |
($657) | ($1,625) | ($230) | $14,991 | ($6,428) | ($366) |
$0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 |
($220) | ($220) | ($220) | ($220) | ($220) | ($220) |
$0 | $0 | $0 | $0 | $0 | $0 |
$288 | ($2,566) | ($1,233) | $12,002 | ($8,483) | ($2,269) |
$0 | $0 | $0 | $0 | $0 | $0 |
($638) | ($478) | ($431) | $9,662 | ($846) | $0 |
$0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $0 | $0 | $0 |
($638) | ($478) | ($431) | $9,662 | ($846) | $0 |
$926 | ($2,088) | ($802) | $2,340 | ($7,637) | ($2,269) |
$21,488 | $19,401 | $18,599 | $20,938 | $13,302 | $11,032 |
General Assumptions
May | Jun | Jul | Aug | Sep | Oct | |
Short-term Interest Rate % | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% |
Long-term Interest Rate % | 7.50% | 7.50% | 7.50% | 7.50% | 7.50% | 7.50% |
Payment Days Estimator | 35 | 35 | 35 | 35 | 35 | 35 |
Collection Days Estimator | 30 | 30 | 30 | 30 | 30 | 30 |
Inventory Turnover Estimator | 12.00 | 12.00 | 12.00 | 12.00 | 12.00 | 12.00 |
Tax Rate % | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% |
Expenses in Cash % | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% |
Sales on Credit % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
Personnel Burden % | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% |
Personnel Plan
Personnel | May | Jun | Jul | Aug | Sep | Oct |
Part-time employee #1 | $500 | $500 | $500 | $500 | $500 | $500 |
Part-time employee #2 | $500 | $500 | $500 | $500 | $500 | $500 |
Other | $0 | $0 | $0 | $0 | $0 | $0 |
Total Payroll | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,100 |
Total Headcount | 0 | 0 | 0 | 0 | 0 | 0 |
Payroll Burden | $40 | $40 | $40 | $40 | $40 | $44 |
Total Payroll Expenditures | $1,040 | $1,040 | $1,040 | $1,040 | $1,040 | $1,144 |
Nov | Dec | Jan | Feb | Mar | Apr |
7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% |
7.50% | 7.50% | 7.50% | 7.50% | 7.50% | 7.50% |
35 | 35 | 35 | 35 | 35 | 35 |
30 | 30 | 30 | 30 | 30 | 30 |
12.00 | 12.00 | 12.00 | 12.00 | 12.00 | 12.00 |
30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% |
25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% |
0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% |
4.00% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% |
Nov | Dec | Jan | Feb | Mar | Apr |
$550 | $0 | $0 | $0 | $550 | $550 |
$550 | $0 | $0 | $0 | $550 | $550 |
$0 | $0 | $0 | $0 | $0 | $0 |
$0 | $0 | $0 | $1,100 | $1,100 | $1,100 |
0 | 0 | 0 | 0 | 0 | 0 |
$0 | $0 | $0 | $44 | $44 | $44 |
$0 | $0 | $0 | $1,144 | $1,144 | $1,144 |
Projected Profit and Loss (Income Statement)
May | Jun | Jul | Aug | Sep | Oct | |
Sales | $9,715 | $9,909 | $10,207 | $10,309 | $9,793 | $7,345 |
Direct Cost of Sales | $3,805 | $3,729 | $3,654 | $3,581 | $3,402 | $2,552 |
Production Payroll | $0 | $0 | $0 | $0 | $0 | $0 |
Other | $0 | $0 | $0 | $0 | $0 | $0 |
———————————————————————— | ||||||
Total Cost of Sales | $3,805 | $3,729 | $3,654 | $3,581 | $3,402 | $2,552 |
Gross Margin | $5,910 | $6,180 | $6,552 | $6,727 | $6,391 | $4,793 |
Gross Margin % | 60.83% | 62.37% | 64.20% | 65.26% | 65.26% | 65.26% |
Operating expenses: | ||||||
Advertising | $700 | $500 | $250 | $650 | $250 | $250 |
Travel | $0 | $0 | $300 | $0 | $0 | $0 |
Miscellaneous | $0 | $0 | $0 | $0 | $0 | $0 |
Payroll Expenses | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,100 |
Payroll Burden | $40 | $40 | $40 | $40 | $40 | $44 |
Depreciation | $100 | $100 | $100 | $100 | $100 | $100 |
Leased Equipment | $0 | $0 | $0 | $0 | $0 | $0 |
Utilities | $120 | $121 | $121 | $122 | $122 | $122 |
Insurance | $70 | $70 | $70 | $70 | $70 | $70 |
Lease | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 |
Other | $0 | $0 | $0 | $0 | $0 | $0 |
Contract/Consultants | $0 | $0 | $0 | $0 | $0 | $0 |
———————————————————————— | ||||||
Total Operating Expenses | $3,730 | $3,531 | $3,581 | $3,682 | $3,282 | $3,386 |
Profit Before Interest and Taxes | $2,180 | $2,650 | $2,971 | $3,046 | $3,109 | $1,407 |
Interest Expense Short-term | $0 | $0 | $0 | $0 | $0 | $0 |
Interest Expense Long-term | $72 | $70 | $69 | $68 | $66 | $65 |
Taxes Incurred | $632 | $774 | $871 | $893 | $913 | $403 |
Extraordinary Items | $0 | $0 | $0 | $0 | $0 | $0 |
Net Profit | $1,476 | $1,806 | $2,031 | $2,085 | $2,130 | $940 |
Net Profit/Sales | 15.19% | 18.22% | 19.90% | 20.22% | 21.75% | 12.79% |
Nov | Dec | Jan | Feb | Mar | Apr | |
$5,509 | $1,377 | $1,239 | $10,296 | $10,502 | $10,817 | |
$1,914 | $478 | $431 | $10,667 | $9,821 | $9,821 | |
$0 | $0 | $0 | $0 | $0 | $0 | |
$0 | $0 | $0 | $0 | $0 | $0 | |
———————————————————————— | ||||||
$1,914 | $478 | $431 | $10,667 | $9,821 | $9,821 | |
$3,595 | $899 | $809 | ($370) | $682 | $997 | |
65.26% | 65.26% | 65.26% | -3.60% | 6.49% | 9.22% | |
$0 | $0 | $0 | $540 | $250 | $350 | |
$0 | $0 | $0 | $0 | $0 | $0 | |
$0 | $0 | $0 | $0 | $0 | $0 | |
$0 | $0 | $0 | $1,100 | $1,100 | $1,100 | |
$0 | $0 | $0 | $44 | $44 | $44 | |
$100 | $100 | $100 | $100 | $100 | $100 | |
$0 | $0 | $0 | $0 | $0 | $0 | |
$160 | $160 | $160 | $115 | $123 | $123 | |
$50 | $50 | $50 | $70 | $70 | $70 | |
$1,700 | $1,700 | $1,700 | $1,700 | $1,700 | $1,700 | |
$0 | $0 | $0 | $0 | $0 | $0 | |
$0 | $0 | $0 | $0 | $0 | $0 | |
———————————————————————— | ||||||
$2,010 | $2,010 | $2,010 | $3,669 | $3,387 | $3,487 | |
$1,585 | ($1,111) | ($1,201) | ($4,039) | ($2,705) | ($2,490) | |
$0 | $0 | $0 | $0 | $0 | $0 | |
$64 | $62 | $61 | $59 | $58 | $57 | |
$456 | ($352) | ($379) | ($1,230) | ($829) | ($764) | |
$0 | $0 | $0 | $0 | $0 | $0 | |
$1,065 | ($821) | ($883) | ($2,869) | ($1,934) | ($1,783) | |
19.33% | -59.64% | -71.27% | -27.86% | -18.42% | -16.48% |
Sales Forecast
Sales | May | Jun | Jul | Aug | Sep | Oct |
Carabiners | $1,680 | $1,714 | $1,765 | $1,783 | $1,694 | $1,270 |
Ropes | $980 | $1,000 | $1,030 | $1,040 | $988 | $741 |
Books and Magazines | $180 | $184 | $189 | $191 | $181 | $136 |
Cookies | $158 | $161 | $165 | $167 | $159 | $119 |
Espresso regulars | $5,775 | $5,891 | $6,067 | $6,128 | $5,821 | $4,366 |
Espresso shakes | $743 | $757 | $780 | $788 | $748 | $561 |
Gear rentals | $200 | $204 | $210 | $212 | $202 | $151 |
Other | $0 | $0 | $0 | $0 | $0 | $0 |
Total Sales | $9,715 | $9,909 | $10,207 | $10,309 | $9,793 | $7,345 |
Direct Cost of Sales | ||||||
Carabiners | $735 | $720 | $706 | $692 | $657 | $493 |
Ropes | $490 | $480 | $471 | $461 | $438 | $329 |
Books and Magazines | $120 | $118 | $115 | $113 | $107 | $80 |
Cookies | $42 | $41 | $40 | $40 | $38 | $28 |
Espresso regulars | $1,980 | $1,940 | $1,902 | $1,864 | $1,770 | $1,328 |
Espresso shakes | $363 | $356 | $349 | $342 | $325 | $243 |
Gear rentals | $75 | $74 | $72 | $71 | $67 | $50 |
Other | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Cost of Sales | $3,805 | $3,729 | $3,654 | $3,581 | $3,402 | $2,552 |
Nov | Dec | Jan | Feb | Mar | Apr |
$953 | $238 | $214 | $1,783 | $1,818 | $1,873 |
$556 | $139 | $125 | $1,040 | $1,061 | $1,093 |
$102 | $26 | $23 | $191 | $195 | $201 |
$89 | $22 | $20 | $167 | $170 | $176 |
$3,275 | $819 | $737 | $6,128 | $6,250 | $6,438 |
$421 | $105 | $95 | $788 | $804 | $828 |
$113 | $28 | $26 | $200 | $204 | $210 |
$0 | $0 | $0 | $0 | $0 | $0 |
$5,509 | $1,377 | $1,239 | $10,296 | $10,502 | $10,817 |
$370 | $92 | $83 | $1,747 | $1,730 | $1,730 |
$246 | $62 | $55 | $1,019 | $1,009 | $1,009 |
$60 | $15 | $14 | $187 | $185 | $185 |
$21 | $5 | $5 | $164 | $162 | $162 |
$996 | $249 | $224 | $6,005 | $5,945 | $5,945 |
$183 | $46 | $41 | $772 | $764 | $764 |
$38 | $9 | $8 | $772 | $25 | $25 |
$0 | $0 | $0 | $0 | $0 | $0 |
$1,914 | $478 | $431 | $10,667 | $9,821 | $9,821 |