+1(978)310-4246 credencewriters@gmail.com
  

Description

At this point in the course, you have completed all the necessary sections of your business plan. Your task in this assignment is to create the final version of your plan. You will include all the previous assignments you have been working on and attach the financials.

The key to this assignment is to use the feedback you have received throughout the course to polish your plan to the point that you could confidently show it to investors and potential partners or customers. One new piece you will be including is a 1–2 page executive summary.

This assignment consists of two parts:

Your final business plan (an MS Word document).

Your final business plan financials (using the Business Plan Financials Excel Template).

To successfully complete this assignment, you must attach both documents to the submission area as separate files and then click

Submit

.

Reminders and Notes

Your company, whether a startup company of your choosing or based on the snack food company scenario, will operate in a 100-mile radius from your home address. Your goal is to reach $1 million in sales by the end of the second year.

Be sure to follow the guidelines, whether you chose the snack food company scenario or the company of your choice:

Snack Food Company Guidelines [PDF]

.

Company of Your Choice Guidelines [PDF]

.Part 1: Business Plan—Final

Notes

The executive summary is a critical aspect of this assignment. Your ability to condense and highlight critical information about your chosen company to investors will determine whether they decide to invest in you and your company or not.

Chapter 4, “The Executive Summary,” pages 53–66, provides information about writing the executive summary. You may write either a synopsis or a narrative summary. Pay particular attention to the following:

Executive Summary Plan Preparation Forms on pages 58–61.

Sample Plans on pages 62–66.

Instructions

In MS Word, construct a 10–20 page business plan in which you:

Write a 1–2 page executive summary highlighting key aspects of each section of the business plan.

Incorporate feedback to produce a comprehensive business plan for the product or business. Specifically, you will be combining all of the previous assignments and revising them to build your business plan:

Week 3 Assignment: Company Overview and SWOT Matrix.

Be sure to include all the headings from the assignment.

Week 5 Assignment: Marketing Plan and Budget.

Be sure to include all the headings from the assignment; the budget part of this assignment will be addressed in Section 2.

Week 8 Assignment: Operations, Technology, Management and Organization, and Social Responsibility Plan (With Financials).

Be sure to include all the headings from this assignment; the financials part of this assignment will be addressed in Part 2.

The written section of the financials from the Week 8 discussion thread.

Be sure to include any financial information that will help to convince the investors.Part 2: Business Plan Financials—Final

Using the Business Plan Financials Excel Template, incorporate feedback from previous submissions to produce a comprehensive set of business plan financials the business’s first two years.

Be sure to refer to the appropriate guidelines for valuable information about how to complete the business plan financials section of your assignment:

Snack Food Company Guidelines [PDF]

.

Company of Your Choice Guidelines [PDF]

.

Specifically, you will want review and make sure you’ve thoroughly incorporated feedback you received from:

Weeks 7 and 8 discussion threads.

Part 2 of the Operations, Technology, Management and Organization, and Social Responsibility Plan (With Financials).

Learning Outcomes

The specific course learning outcome associated with this assignment is:

Construct a business plan with an executive summary that justifies a clear concept, a management structure, a market need, competitive advantages, and financial projections.

week 8 discussion

This business will be operating under the personal building to save the cost of renting a room (Persistence Market Research, 2021). The building in which the business will be operated is amid Washington DC, this location is selected because it is highly populated, in addition to such a huge population and according to the research which was done recently by our technical staff, the huge population has got a lot of consumers (Persistence Market Research, 2021). Our mode of operation will be five days every week which in each day we will be operating for 9 to 10 hours. At the beginning of our operation, this business will function both as a place where processing is done and ordering of some quality services can be done. In addition to such wonderful activities, various logistics activities will be done in these buildings.

In terms of our operation task, it is on a large scale with a huge number of employees who perform different tasks at their disposal, this covers the entire cooking tasks like processing of various kinds of food (Persistence Market Research, 2021). This is because we as a business will be very happy to see every customer of ours leaving while happy because of the kind of service he or she has received from our side. Therefore we will have to employ qualified personnel.

In the process of operation, we will have to depend on some supportive factors like electricity, water, and sewerage among others. It will have to cost us some amount every month. The cost of some of the services will have to go as follows, water will cost $30, electricity $50 and waste disposal will have to cost around $20.

The first activity to take place will be to receive various raw materials which will be very helpful in our operations, such raw materials will have to include things like drinks, flour, vegetable, fruits among others (Persistence Market Research, 2021). These suppliers once bring their goods to the company every Monday will have to wait for their payment every Friday after their materials have been used.

For the production of food to take place, the order will be made by the client and it is estimated to be around 2 tons on some low-income days and up to 13 tones on some high income or successful days, and these tons will be distributed to customers daily and according to their wants and needs (Persistence Market Research, 2021). Because our main aim is to meet the high-quality requirements needed, we have to place some qualification requirements upon every individual who wants to work with us.

Since we deal with raw materials, our city of operation is fertile and has got what is needed by our company, most of our suppliers come from the local (Persistence Market Research, 2021). These suppliers are known to be providing the company with high-quality, fresh farm produce which highly contributes to customer satisfaction. Therefore are always recommended.

For the business to conduct its operations according to the set guidelines and try to match the world best, it will employ the technical staff who will be conducting the research and contributing highly to the development of the company. Too, the company will have to set aside some lab where the various tests on food and raw materials can be done before they are approved for use.

References

Persistence Market Research. (2021). Food Processing Ingredients Market: Global Industry Trend Analysis 2013 to 2017 and Forecast 2018 – 2028. Persistence Market Research

SWOT analysis of Café Boomers Company

Strengths

The Café Boomers Company’s likely strengths are:

· The Café Boomers Company happens to be one of the greatest premium processors of the various fruit ingredient solutions. Café Boomers Company has strong linkages towards the various emerging markets in the industry. The Café Boomers Company has got highly intensified rates of logistics

· The boomers as a product are absolutely in one of the growing markets because of its delicacy and health benefits. Boomers have been realized to help treat lots of health complications and therefore making lots of people resorting to its consumption a great deal.

· The boomers are deeply into the niche market basically due to its ability to be consumed and its high demand by the various customers. The boomers have a very high sale since it is Very healthy and considered to be able to treat any form of illness and this is regardless of the age or the gender of the patients. Boomers have highly demanded its low market prices but it has got absolutely high-quality production.

· Some of the strengths that we bring into the Café Boomers Company are such as the concepts of unity whereby we bring and share our ideas and some of the best ways of handling the frozen fruits and thereafter realizing the best distribution channel for the same and getting to identify the most appropriate market for the product.

Weaknesses

· The Café Boomers Company has a major weakness and that is the identification of the best market of the products.

· The rate of competition in the Fruit vending markets tends to be very stiff and therefore calls for a high sense of resolution on the marketing strategies in order to come up with the best choice of events to use. Most fruit production companies really find it hard to get the best and suitable market for their products and this is mainly because of the stiff competition that we did have in the markets.

· Lack of a fully experienced management team is another great challenge affecting the Café Boomers Company since there are those individuals whom in a way or the other have no basic skills and ideas on what exactly needs to be put in place.

· Lastly is the production challenge since there are times the company might be tempted to produce the bulk of the products then end up not getting adequate and more reliable markets whereby it can deliver the produced products in the long run leading to massive losses.

Opportunities

· The Café Boomers Company has got some of the best kinds of opportunities such as the ability to interpolate and identify various kinds of markets niches and also easy access to customers whenever they are in operation. This is because of their ultimate and perfectly designed customer relations and perfect levels of marketing.

The company happens to have almost an average amount of demands and supplies in that the rates at which the customers are in high need for the boomers, this gives the company better gaps and chances to produce more products in order to avoid losses and also keep the customers and the market on toes.

Due to the company’s level of competition in the marketing niche, the larger corporations have therefore not stopped serving the smaller or niche markets that would be entered.

The new market that deals with the Boomers are rapidly emerging basically because of the demographics, immigration activities around the country and the changing tastes and preferences among others.

Threats

he biggest company threats are the ability to maintain customers and be at par with the stiff competition at hand.

There exists a very stringent market leader that is well versed with all the procurements of the Café Boomers Company and this will really be hard to displace or rather exchange with another.

Downward pricing provides pressure to the margins of making profit since;

In case there is a lower price of the products and higher quality, the demand will be increased.

In case the demand for the products gets high and the prices of the products get favorable, there is a possibility for the market to grow.

In the case of available customer flow and ready market therefore will lead to stiff competition hence a steady flow of events in the same company and its surroundings.

Company Name and its Significance

Café Boomers Company is the name of the company. To win the customers’ attention and loyalty, the company name should be impressive. Using the name stated will make it easier for the customers to grasp its name, products, and services. The word boomers will have a positive effect on the customers because they will have the urge and push to be part of the booming café. Company names normally attract customers thus the need to use a name that they can master. Additionally, individuality is a crucial component in marketing, and the name bloomers will give the impression to the customers that they are part of the booming coffee shop. It is also a good name for positive initial expression.

Product Description

Café Boomer is a coffee-selling company that offers a variety of beverages, pasta, and pastries, making it a haven for all coffee lovers. It is a coffee center where customers of all works of life can congregate, read, and even get entertainment. Other services such as music and video shows will give customers necessary entertainment while enjoying their coffee. Free Wi-Fi will also help the internet and social media lovers to enjoy their coffee while browsing their favorite sites.

I will be the major shareholder of this company with other partners being my two friends. Since the startup cost will be relatively high, I will finance three-quarters of the company cost while my two friends share the remaining quarter in the proportions of their choice. Since there are existing companies that operate within this industry, the entrance phase will be challenging. The competitiveness of the market due to product and service saturation means that we will have to take a different approach. To improve our success, we will have to partner with companies that already exist in the town so that we can share customers and referrals whenever possible. The company will also offer unique coffee products like Café Espresso Con Pan, Café Miel, and Café Latte. The mentioned beverages are rare in the selected town, and this will be an opportunity to venture into this virgin market. We will also prioritize pastries such as Strawberry Cheese, Banana Pudding, Lemon Crumb Muffins, Blueberry Muffins, and Blueberry Muffins. The ultimate goal is to provide, quality, affordable and unique products and services that meet customers’ expectations.

MISSION

“Café Boomer will boom daily for the sake of serving our customers unique coffee, pastries, and pasta. We cherish our customers and as such, our products will always be affordable, quality, and unique. With a serene and conducive environment, our customers will get to enjoy themselves and relax in our stress-free environment. We will keep growing together and walking the miles of your desires”.

VISION

To offer our customers fresh and unique coffee alongside memorable services that will create a delightful family experience across the community.

TAGLINE

“Bringing together the community through a cup of coffee and sharing pastries for a tighter relationship.

SNACK FOOD COMPANY GUIDELINES
•
•
•
•
•
You must build your business plan using the information included within these guidelines.You can add to this information as needed.
You will create a business plan for a company operating in the snack food industry.
The instructor will approve your company in a reply to your Week 1 discussion post in which you will describe this business.You will revise your
work based on feedback provided.
You will be the CEO of the new business.
You will develop the business plan with the intention to raise funds and increase sales.
Key Business Plan Parameters
Key
Parameter
Business Size
Explanation
Market Size
You are a startup not yet in operation. You have the recipe for the snack, and you have been operating from your home, but sales
are small. You were selling the product for $3 per item at a cost of $1. You will develop the business plan with the intention to raise
f unds and increase sales. Your sales must be over $1 million by the end of the second year.
You must focus on a snack. You decide what the snack will be and whether it will be sold in individual sizes or wholesale. The
Snack Food industry produces snack foods, such as potato and corn chips, pretzels, roasted and salted nuts, nut butters, popcorn
and other similar snacks.
You will start marketing and selling the product in your geographical area within a 100-mile radius from your home.
Existing Funds
You received $50,000 from your grandmother as a gift, and you borrowed $30,000 from your family and friends.
Intention to Raise
Money
To grow the business further, you will need funds from outside investors, either angels, venture capitalists, a group of individual
investors on Kickstarter.
Facility
You will rent.
Employees
You will have employees, and you will develop your own organizational hierarchy.
Annual CEO
Salary
As CEO your salary will be $60,000 the first year, $120,000 the second year, and finally adjusted to $160,000 for all remaining years
in the position.
Product
1
Specific Business Details
This table identifies specific details you must use for your snack company business plan. Reflect any costs in your business plan narrative and in the
Business Plan Financials Excel Template. The f inal column specifies the specific worksheet within the Business Plan Financials Excel Template
where you need to input data.
Item
EQUIPMENT PURCHASES AT THE START OF THE BUSINESS
AND AS THE BUSINESS GROWS
•
•
•
•
Worksheet Within the Business Plan
Financials Excel Template
Capital Expenditures Worksheet
2 machines to produce and package the product @ $10,000 each; about
50 bags per minute each
2 vans f or distribution @ $15,000 each
3 computers @ $1,400 each
Sof tware for inventory, payments, and customer accounts management
Printer
•
PERSONNEL
Staf f Budget Worksheet
Current Personnel
• CEO (you)
• 1 part-time production worker @ $15.00/hour (20 hours/week)
• 1 IT support person @ $25.00/hour (20 hours/week)
• 1 paid consultant (your neighbor); retired executive in the snack food
industry
Considerations:
Your goal is to reach sales of over $1 million by the end of the second year. You
will need to hire additional personnel to meet this goal. Potential additional hires
include:
• 2 production line foremen
• Production employees (more than one shift)
o Business size of business will determine number
• Maintenance staff
o Business size will determine number
• Additional employees according to your preferences
2
Item
Worksheet Within he Business Plan
Financials Excel Template
BUSINESS EXPENSES
Marketing Expenses
Professional Services
• Consultant (your neighbor); 1st year only
• Attorney
• Accountant
• Industry specialist
Inventory Purchases (as needed)
Additional Expenses
• Telephone/fax
• Business insurance
• Of f ice supplies
• Mailings and postage
• Building maintenance
• Utilities, including
o Water/sewer
o Gas
o Electricity
o Trash removal
Marketing Budget Worksheet
Prof essional Services Worksheet
FINANCIAL INFORMATION
Capital Investments Worksheet
Available Funds
• Balance in the bank
• Gif t from grandmother
• Loan f rom relatives and friends
o This is to be paid by the end of the second year of operation with
5% interest.
Future Funds
You will need to raise funds from investors. You will determine this based on how
much you plan to grow the business.
Reminder:
• You will need to pay taxes.
• You will determine sales projections.
Inventory Worksheet
Income Statement Worksheet
Cash Flow Statement Worksheet
Sales Projections Worksheet
3
Guide to Complete the Business Plan Financials Excel Template
The Business Plan Financials Excel Template is the base pro-forma financial statement for your business. Complete the worksheets in order.
Worksheet
Worksheet #1: Set Up and Assumptions
Worksheet #2: Sales Projections
Worksheet #3: Inventory (Adjust These Figures
As Needed)
Worksheet #4: Capital Expenditures (applies to
purchased NOT leased equipment)
Worksheet #5: Staffing Budget
Worksheet #6: Marketing Budget
Worksheet #7: Professional Services
Data Entry
Line 9–Enter the month the academic quarter starts.
Line 12—Enter the year the academic quarter starts.
Line 15–Enter 2; you choose the number of product lines you will have up to 10 lines.
Line 21—Standard default is 30 days; you may adjust this for your business.
Line 43—Enter $15,000; this is the money you currently have in the bank.
Speculate how much your company will grow and how much you will sell.
Ref lect this information in the Operations Section of your Business Plan (Week 5
Discussion and Week 8 Assignment).
You need to reach sales of over $1 million by the end of the second year.
Line 7– Enter the cost of ingredients.
Line 8—Enter the cost of bags.
Line 9—Enter the cost of cartons to package the products.
Repeat these three lines for each product line.
Insert the cost of the equipment, vehicles, computers, et cetera, you decide to purchase.
Account for every paid employee using the appropriate lines for the six categories of
employees
1. Management
2. Administrative/Support
3. Sales/Marketing
4. Operations/Production
5. Other
6. Part-Time/Hourly
Indicate when their employment will start according to the Operations and Management and
Organization sections of your business plan.
Enter the cost for the marketing vehicles you plan to use. (Discussion 4 and Assignments 2
and 3).
Line 6—Enter $3,000.00.
Line 7–Enter $2,500.00.
Line 9—Enter $2,000.00
Line 11—Enter $10,000.00 (f irst year only)
4
Worksheet
Data Entry
Worksheet #8 Capital Investments Worksheet
Equity Capital Investments
Line 6—Gif t—Enter $50,000.00.
Loans (Friends and Family)
Line 24–$30,000
Note: The loan period = 24 months; interest rate = 5%
Worksheet #9: Income Statement
Enter the cost of your expenses; see Business Expenses in the table that appears under
the Specific Business Details section of these guidelines.
Pay off taxes.
This will automatically populate from the other completed worksheets.
Worksheet #10: Cash Flow Statement
Worksheet #11: Balance Sheet
5
Resources on the Snack Food Industry
These resources are a good starting point for you as being researching the snack food industry .
C. Barnes. 2020. 2020 U.S. industry & market report–NAICS 31191: Snack food manufacturing, 1–196.
Jan Conway. 2018. U.S. Snack Foods Industry—Statistics & Facts. Statista. https://www.statista.com/topics/1496/snackfoods/
Patrick Limdico. 2019. 47 Snack Food Industry Trends and Consumption Statistics. Foodtruck Empire.
https://foodtruckempire.com/news/snack-food-industry/
Douglas J. Peckenpaugh. 2019. State of the Industry 2019: Defining the Future of Snacking. SF&WB.
https://www.snackandbakery.com/articles/93232-state-of-the-industry-2019-defining-the-future-of-snacking
L. Petrak. 2019. Mindful Munching: The Evolution of Mealtime Is Fueling the Trend Toward New Kinds of Nibbles.
Progressive Grocer, 98(5), 50–54.
Statisa. No date. Consumer Market Outlook: Snack Food; United States.
https://www.statista.com/outlook/40110000/109/snack-food/united-states
Mordor Intelligence. No date. Snack Food Market—Growth, Trends, and Forecasts (2020–2025).
https://www.mordorintelligence.com/industry-reports/snack-food-market
6
COMPANY OF YOUR CHOICE* GUIDELINES
•
•
•
•
•
•
You will create a business plan for a company of your choice.
You must focus on a very specific product or service.
*The instructor will approve your company in a reply to your Week 1 discussion post in which you will describe this business. You will revise your
work based on feedback provided.
You must adhere to the guidelines in this document.
You will be the CEO of the new business.
You will develop the business plan with the intention to raise funds and increase sales.
Key Business Plan Parameters
Key
Parameter
Explanation
Business Size
You are a startup not yet in operation. You have been operating from your home, but sales are small. You will develop the business
plan with the intention to raise funds and increase sales. Your sales must be over $1 million by the end of the second year.
Product or Service Be specific about the product or service on which you are f ocusing and how you will differentiate yourself from similar products or
services in the marketplace.
Market Size
You will start marketing and selling the product or service in your geographical area within a 100-mile radius from your home.
Existing Funds
You already have some funds (small loan, savings, et cetera).
Intention to Raise
Money
To grow the business further, you will need funds from outside investors, either angels, venture capitalists, a group of individual
investors on Kickstarter.
Facility
You will rent or purchase.
Employees
You will have employees, and you will develop your own organizational hierarchy.
Annual CEO
Salary
As CEO you have the option not to draw a salary in the first year of business.
1
Specific Business Details
This table identifies specific details you need to consider in your business plan. Reflect any costs in your business plan narrative and in the Business
Plan Financials Excel Template. The f inal column specifies the specific worksheet within the Business Plan Financials Excel Template where you
need to input data.
Item
EQUIPMENT PURCHASES AT THE START OF THE BUSINESS AND AS
THE BUSINESS GROWS
Worksheet Within the Business
Plan Financials Excel Template
Capital Expenditures Worksheet
Examples:
• Production equipment
• Vehicles for distribution
• Computers
• Sof tware
• Printer
PERSONNEL
Staf f Budget Worksheet
Current Personnel
CEO (you)
Considerations:
• Your goal is to reach sales of over $1 million by the end of the second year. You
will need to hire personnel in all areas of the business to meet this goal.
• Consider increasing the number of employees in operations in the second year as
sales increase.
BUSINESS EXPENSES
Marketing Expenses
Professional Services
• Consultants
• Attorneys
• Accountants
• Industry specialists
Inventory Purchases (as needed)
Marketing Budget Worksheet
Prof essional Services Worksheet
Inventory Worksheet
2
Item
Worksheet Within the
Business Plan Financials
Excel Template
Additional Expenses
• Telephone/fax
• Business insurance
• Of f ice supplies
• Mailings and postage
• Building maintenance
• Utilities, including
o Water/sewer
o Gas
o Electricity
o Trash removal
Income Statement Worksheet
FINANCIAL INFORMATION
Capital Investments Worksheet
Available Funds
Balance in the bank from loans and savings
Future Funds
You will need to raise funds from investors. You will determine this based on how much
you plan to grow the business.
Reminder:
• You will need to pay taxes.
• You will determine sales projections.
Cash Flow Statement Worksheet
Sales Projections Worksheet
3
Guide to Complete the Business Financials Excel Template
The Business Plan Financials Excel Template is the base pro-forma financial statement for your business. Complete the worksheets in order.
Worksheet
Worksheet #1: Set Up and Assumptions
Worksheet #2: Sales Projections
Worksheet #3: Inventory (adjust as needed)
Worksheet #4: Capital Expenditures (applies to
purchased NOT leased equipment)
Worksheet #5: Staffing Budget
Worksheet #6: Marketing Budget
Worksheet #7: Professional Services
Worksheet #8 Capital Investments Worksheet:
Worksheet #9: Income Statement
Worksheet #10: Cash Flow Statement
Worksheet 11: Balance Sheet
Data Entry
Line 9—Enter the month the academic quarter starts.
Line 12—Enter the year the academic quarter starts.
Line 15—Enter 2; you choose the number of product lines you will have up to 10 lines.
Line 21—Standard default is 30 days, you may adjust this for your business.
Line 43—Enter the balance in your bank account as you open your business. Remember
you were selling from home.
Speculate how much your company will grow and how much you will sell.
Ref lect this information in the Operations Section of Your Business Plan (Week 5
Discussion and Week 8 Assignment).
You will need to reach sales of over $1 million by the end of the second year.
Enter the cost of ingredients, packaging, bags, et cetera.
Repeat these lines for each product line.
Insert the cost of your facility, equipment, vehicles, computers, et cetera, you decide to
purchase.
Account for every paid employee using the appropriate lines for the six categories of
employees
1. Management
2. Administrative/Support
3. Sales/Marketing
4. Operations/Production
5. Other
6. Part-Time/Hourly
Indicate when their employment will start according to the Operations and Management and
Organization sections of your business plan.
Enter the cost for the marketing vehicles you plan to use (Week 4 Discussion and Weeks 5
and 8 Assignments).
Enter payments to accountants, consultants, attorneys, industry specialists as needed.
Enter equity capital investments, loans, et cetera.
Enter projections of other f unds you intend to raise.
Enter the cost of your expenses; see Business Expenses in the table that appears under
the Specific Business Details section of these guidelines.
Pay off taxes.
This will automatically populate from the other completed worksheets.
4
1
Café Boomer: Strategic Positioning
Name:
University:
2
Café Boomer: Strategic Positioning
1. Product and Service Offered
The name of the company is “Café Boomer”, a facility designed as a coffee selling
outlet with the name defining the products and services it offers to its clients, as a coffee
“Café”. Importantly, considering the primary aim of the company to make $1 million in sales
by the end of the second year, “Boomer” projects a boom in corporate performance. The
company will offer diverse beverage products, pastries, and paster. It will be designed as a
first stop-shop for coffee customers. In its design, Café Boomer forms a coffee joint for
various types of customers to meet, entertain, and/or read as they enjoy their cup of coffee
and a snack. Among the unique coffee products that the company will offer includes Café
Espresso Con Pan, Café Miel, and Café Latte, which are rare in the current market. As such,
the company will take advantage of the opportunity of entering into a new market with
minimal competition. Similarly, the company will offer unique pastries, mainly Banana
Pudding, Strawberry Cheese, Lemon Crumb Muffins, and Blueberry Muffins at affordable
prices. In addition, the company will offer other services, including free Wi-Fi to its
customers to enable them to surf the internet and social media platforms while enjoying their
coffee. Music and video shows will also be afforded to the customers for additional
entertainment to refresh their minds while sipping their beverages. The primary rationale will
be to venture into the virgin market offering quality, affordable and unique products that meet
the needs and expectations of customers.
2. Revision of Company’s Mission Statement Based on Feedback
The mission statement of Café Boomer is that:
“Café Boomer will boom daily for the sake of serving our customers unique coffee, pastries,
and pasta. We cherish our customers and as such, our products will always be affordable,
quality, and unique. With a serene and conducive environment, our customers will get to
3
enjoy themselves and relax in our stress-free environment. We will keep growing together
and walking the miles of your desires”.
3. Trends in the Specific Industry
The major trend of the coffee café industry is its marked growth in the last five years
of close to 8% (Solihat & Hamdani, 2020). Moreover, Jalan (2021) projected the growth of
coffee shops to increase by investing more than $80 billion between 2021 and 2025. The
analysis explores the market segmentation of ventured chain coffee shops and independent
coffee cafés noting that the creation and implementation of new promotional strategies, as
well as design of unique customer service, define the positive increase in growth of specialty
beverage outlets, such as coffee cafés in various markets.
Among the major trends in the coffee industry is the dynamics in customer
experience. Many coffee outlets are working towards improving customer experience taking
initiatives to integrate technology into service delivery to simplify the ordering process and
make it more convenient. de Luca et al. (2020) suggest that various coffee shops are
optimizing their ordering area exploiting tools to streamline the process, particularly with the
integration of point-of-sale systems for both customers and employees. Moreover, coffee
outlets are creating a more conducive environment that is welcoming to customers, which
includes online platforms for ordering to decrease the queuing time to pick up a beverage.
Another significant trend entails catering to the millennials, who constitute the largest
generation of customers. Consistent with their hyperactive way of life, Falkner (2020)
demonstrated the millennials value experience in customer service as opposed to the price of
a product, such as coffee. Drinking coffee is more of a lifestyle choice for most millennials as
opposed to a daily requirement to begin a day. As such, the millennials consider taking coffee
in public coffee outlets where they meet with friends and colleagues. Therefore, investing in
new ordering systems, particularly with delivery capabilities would attract the millennial
4
clientele. Moreover, investing in visually attractive packaging that is unique and potent for
social media would connect with the millennials.
Lastly, trendy new coffee flavors are coming up in the market that diverse coffee
outlets are taking advantage of to introduce in the virgin market. While new coffee flavors
are emerging, de Luca et al. (2020) assert that coffee lovers are increasingly consuming
specialty coffee outside the unique ingredients and new flavors. Evidently, penetrating the
market will require taking into consideration the trends in the market and aligning product
and service delivery to meet the customer expectations.
4. Strategic Position
The strategic positioning of Café Boomer will entail brand positioning through
differentiation. Tintara and Respati (2020) described differentiation as a positioning strategy
that sets apart corporate products, services, or brands from those of the competition by
outlaying a superior quality and associating it to customer benefits. At Café Boomer, the
company will embrace positioning by differentiation strategy tailored to provide unique
products that are not available in the selected market, and providing associated high-quality
services to the customers. Coffee products, such as Café Miel, Café Espresso Con Pan, and
Café Latte are particularly rare in the selected market. Equally, the offered pastries, including
Blueberry Muffins, Lemon Crumb Muffins, Strawberry Cheese, and Banana Pudding are
unique in the market. Moreover, the company will differentiate its products by offering a
relatively affordable pricing plan. In this regard, offering these products will actuate
differentiation and position Café Boomer since the potential competition is not offering them,
making the strategic position ideal.
5. Revision of SWOT matrix
Strengths
Weaknesses
5
i.
Café Boomer is a great premium
i.
Café Boomer is challenged by the
processor of various coffee ingredient
identification and access of market data
solutions.
to link its products to well-targeted
ii. Café Boomer offers high-quality service
level to its customers with a customer-
potential customers.
ii. Café Boomer has difficulty in accessing
centered approach.
financial input leading to an unevenly
iii. Café Boomer has a clear value
shared obligation of the founders.
proposition by integrating its coffee
iii. The rate of competition in the coffee
products with health benefits to its
shops in the market is stiff due to
customers.
substitute competitive coffee products.
iv. Café Boomer has captured a positive
iv. Café Boomer is challenged by a lack of
attitude to its coffee products from the
a fully experienced management team.
millennials, who constitute the largest
market share in the selected market.
Opportunities
Threats
i.
i.
Café Boomer has created a culture of
Café Boomer is majorly threatened by
customer relationship embedded in its
its ability to meet its cash flow needs
operations allowing easy penetration.
consistent with the increasing demand
ii. The company is able to attract and
for its coffee products.
maintain new customers by the provision ii. Competition from the already
of unique services and special offers.
iii. Café Boomer has a broad unique coffee
product range to attract new market
segments.
established market leader offering
comparable coffee products.
iii. The company is threatened by
downward pricing, which exerts
6
iv. Café Boomer pursues co-branding by
partnering with companies that are
already in the market so that it can share
customers and referrals.
pressure on the margins of making a
profit.
iv. Café Boomer is threatened by the
increases in supplier costs associated
with suppliers’ bargaining power in
procurement on unique coffee products.
Takeaways From the Analysis
In consideration of the strengths and opportunities, Café Boomer requires to capitalize
on brand positioning by differentiation to easily penetrate the market and acquire new
customers interested in unique coffee products rare in the selected market. Secondly, the idea
of co-branding is a major addition to the company assisting in creating alternatives to
customers and referrals, thereby establishing a wider client-base. In light of the weaknesses
and threats, Café Boomer is aware of the competition making it recognize the significance of
differentiation and extending it to the pricing plan. Secondly, it is evident that the company is
aware of its financial constraints, and therefore requires venturing new options to supplement
its cash flow needs.
7
References
de Luca, P., Pegan, G., & Vianelli, D. (2020). Customer Experience in the Coffee World:
Qualitative Research on the US Market. In Handbook of Research on Retailing
Techniques for Optimal Consumer Engagement and Experiences (pp. 257-283). IGI
Global.
Falkner, L. (2020). An Exploratory Study of Generational Coffee Preferences. Honors
College Theses. 50. Retrieved October 25, 2021 from
https://digitalcommons.murraystate.edu/honorstheses/50
Jalan, A. (2021). When the beans got spilled: the tragic case of cafe coffee day. Emerald
Emerging Markets Case Studies, 11(3), https://doi.org/10.1108/EEMCS-05-20200180
Solihat, A., & Hamdani, N. A. (2020). Marketing strategy based on consumer behavior in
facing competition between coffee shops. In Advances in Business, Management and
Entrepreneurship (pp. 239-240). CRC Press.
Tintara, I. D. G. W., & Respati, N. N. (2020). The Effect of Product Differentiation, Service
Differentiation, and Image Differentiation on Competitive Advantage. Am. J.
Humanit. Soc. Sci. Res, 4, 316-321.
Your Company Name
WARNING!
IT APPEARS THAT YOU DO NOT HAVE EXCEL’S MACRO CAPABILITY ENABLED. THESE FINANCIA
FUNCTION WITHOUT MACROS ENABLED.
Excel 2010 for Windows:
To enable macros:
1. Click the “Enable Content” button in the Security Warning that appears at the top of this page.
If you do not see the “Security Warning” along the top of this page, scroll down for more detailed instr
“Excel 2010 and Excel 2013 on Windows – Enabling Macros”
Excel 2013& 2016 for Windows:
To enable macros:
1. Click the “Enable Content” button in the Security Warning that appears at the top of this page.
If you do not see the “Security Warning” along the top of this page, scroll down for more detailed instr
“Excel 2010 & Excel 2013 on Windows – Enabling Macros”
Excel 2011 & 2016 for Mac:
1. A pop-up window appears. Select “Enable Macros”.
2. Your workbook should now be ready to use.
Your Company Name
Excel 2013 and Excel 2016 on Windows – Enabling Macros
Your Company Name
Your Company Name
WARNING!
L’S MACRO CAPABILITY ENABLED. THESE FINANCIAL WORKSHEETS WILL NOT
NCTION WITHOUT MACROS ENABLED.
Warning that appears at the top of this page.
e top of this page, scroll down for more detailed instructions, under
ng Macros”
Warning that appears at the top of this page.
e top of this page, scroll down for more detailed instructions, under
Macros”
Your Company Name
el 2016 on Windows – Enabling Macros
Note: The procedure is exactly the same for Excel 2013 & 2016, even
though the two versions look slightly different.
1. In the upper left corner of the Excel Ribbon, press the “File” tab.
2. Select Options, in the lower left corner.
3. Select Trust Center from the Lower Left.
4. Click the “Trust Center Settings…” button in the lower right
Your Company Name
5. Select “Macros Settings” from the left side menu
6. Select the “Disable all macros except digitally signed macros” radio
button.
7. Click “OK” twice
Welcome to Business Plan Financials!
Thank you for purchasing Business Plan Financials from PlanningShop. These worksheets will help you develop clear, compelling financial projections for your business.
If you are unfamiliar with the business planning process, we encourage you to refer to our book, Successful Business Plan: Secrets & Strategies , by Rhonda Abrams, for
comprehensive, step-by-step guidance. It is available through our website, www.PlanningShop.com.
First, a few tips to get you started:
SAVING A BLANK WORKBOOK, TO ALLOW FOR RECOVERY FROM MISTAKES
You may start directly editing this file. If you later decide to start over and need a fresh copy of this file, find the blank “ORIG_PlanningShop_BizPlanFin(2.8)” file in your
PlanningShop directory. Make a copy of this file (just in case you might need to start over yet again), and then start editing the copy.
NAVIGATING THE WORKSHEETS
You installed the Windows version of Business Plan Financials. The Excel Ribbon now contains a “PlanningShop” tab, that contains controls to let you navigate between
worksheets. The PlanningShop Ribbon looks slightly different in Excel 2013 and Excel 2016, but the functionality is the same.
Note that the riboon does not appear in Excel 2011 for Mac, due to limitations of that version of Excel.
Excel 2013 for Windows, Excel 2016 for Windows, Excel 2016 for Mac:
In Excel 2011 for Mac, there is no PlanningShop tab on the Excel Ribbon (Microsoft does not allow it).
Instead, to navigate between worksheets and charts, use the Excel worksheet tabs along the bottom edge of the Excel window.
HOW TO FILL IN THE WORKSHEETS
While you work, keep an eye out for red triangles that appear with some cells on the worksheets. These triangles indicate the presence of a “help balloon” that will popup
when you roll over the triangle, presenting you with additional information and tips about the section you are working on.
FOR MORE HELP
About Our Support of Mac vs. Windows
PlanningShop supports Business Plan Financials on the following platforms:
Windows
1. Microsoft Windows10 with Microsoft Excel 2016 / Microsoft Office 365
2. Microsoft Windows 8 or later with Microsoft Excel 2013
Mac
4 Mac OS X with Microsoft Excel 2016
5. Mac OS X with Microsoft Excel for Mac 2011
Version 3.1
Copyright © 2003-2017 PlanningShop
Setup Assumptions
Setup and Assumptions
COMPANY INFORMATION
What is your company’s name?
Café Boomer
What month will you officially start your company?
What year will you officially start your company?
October
2021
SALES ASSUMPTIONS
The Worksheets can accommodate sales projections for up to 10 major
product/service lines. How many major product/service lines do you plan Te
to have for your business?
n
Most businesses sell at least some of their products/services on credit
(e.g., “net 30” as opposed to cash). What percentage of your sales will
be made on credit?
For sales you make on credit, what terms will you extend? In other
words, how many days will pass from the date of sale to when you
expect to be paid?
Six
Six
25%
30
PERSONNEL ASSUMPTIONS
Approximately how much do you expect to spend per year on benefits
for each SALARIED/FULL TIME employee (medical insurance, etc.)?
$5,000
Approximately how much do you expect to spend per year on benefits
for each HOURLY/PART-TIME employee (medical insurance, etc.)?
$1,200
With health insurance and other benefits costing more each year, your
plan should account for annual increases. How much do you estimate
your benefit costs will increase each year?
5.00%
If you plan to increase wages (both salaried & hourly) on an annual
basis, how much to you plan to increase them by?
3.50%
Approximately what percentage of each employee’s salary or wages do
you plan to set aside for payroll taxes?
15.00%
FINANCIAL ASSUMPTIONS
What will be the opening balance in your bank account on the first day of
business? This will be the opening balance in your Cash Flow
Statements.
$25,000
At approximately what rate do you expect to be taxed on your net
income?
25.00%
If you will use an interest-bearing account for your banking, at what rate
will you accrue interest?
1.00%
Setup Assumptions
Sales Projections
Sales Projections
2021-2022
Assumptions
Product Line 1 (Café Espresso Con Pan)
Unit Volume
2.00%
Unit Price
2.50%
Gross Sales
(Commissions)
50.00% 15.00%
(Returns and Allowances)
3.00%
Net Sales
(Cost of Goods Sold)
50.00%
GROSS PROFIT
Product Line 2 (Café Con Miel)
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
Product Line 3 (Café Latte)
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
Product Line 4 (Vanilla Macchiato)
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
Product Line 5 (Caffe mocha)
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
Product Line 6 (Blueberry Muffin)
Unit Volume
Unit Price
5.00%
2.50%
50.00% 15.00%
3.00%
50.00%
2.00%
2.50%
50.00% 15.00%
3.00%
50.00%
2.00%
2.50%
50.00% 15.00%
3.00%
50.00%
2.00%
2.50%
50.00% 15.00%
3.00%
50.00%
2.00%
2.50%
October
2022-2023
November
December
January
February
March
April
May
June
July
August
September
TOTAL
900
$4.75
$4,275
$321
$128.25
$3,826
$2,137.50
$1,689
918
$4.75
$4,361
$327
$131
$3,903
$2,180
$1,722
900
$4.75
$4,275
$321
$128.25
$3,826
$2,138
$1,689
1300
$4.75
$6,175
$463
$185.25
$5,527
$3,088
$2,439
1600
$4.75
$7,600
$570
$228.00
$6,802
$3,800
$3,002
1632
$4.75
$7,752
$581
$232.56
$6,938
$3,876
$3,062
1665
$4.75
$7,907
$593
$237.21
$7,077
$3,954
$3,123
1698
$4.75
$8,065
$605
$241.96
$7,218
$4,033
$3,186
1732
$4.75
$8,226
$617
$246.79
$7,363
$4,113
$3,249
1767
$4.75
$8,391
$629
$251.73
$7,510
$4,196
$3,314
1802
$4.75
$8,559
$642
$256.77
$7,660
$4,279
$3,381
1838
$4.75
$8,730.01
$655
$261.90
$7,813
$4,365
$3,448
17751
$84,316
$6,324
$2,529
$75,463
$42,158
$33,305
650
$4.65
$3,023
$227
$91
$2,705
$1,511
$1,194
683
$4.65
$3,174
$238
$95
$2,840
$1,587
$1,254
950
$4.65
$4,418
$331
$133
$3,954
$2,209
$1,745
1300
$4.65
$6,045
$453
$181
$5,410
$3,023
$2,388
1550
$4.65
$7,208
$541
$216
$6,451
$3,604
$2,847
1628
$4.65
$7,568
$568
$227
$6,773
$3,784
$2,989
1709
$4.65
$7,946
$596
$238
$7,112
$3,973
$3,139
1794
$4.65
$8,344
$626
$250
$7,468
$4,172
$3,296
1884
$4.65
$8,761
$657
$263
$7,841
$4,380
$3,461
1978
$4.65
$9,199
$690
$276
$8,233
$4,599
$3,634
2077
$4.65
$9,659
$724
$290
$8,645
$4,829
$3,815
2181
$4.65
$10,142
$761
$304
$9,077
$5,071
$4,006
$85,484
$6,411
$2,565
$76,508
$42,742
$33,766
800
$2.75
$2,200
$165
$66
$1,969
$1,100
$869
816
$2.75
$2,244
$168
$67
$2,008
$1,122
$886
1100
$2.75
$3,025
$227
$91
$2,707
$1,513
$1,195
1550
$2.75
$4,263
$320
$128
$3,815
$2,131
$1,684
1581
$2.75
$4,348
$326
$130
$3,891
$2,174
$1,717
1613
$2.75
$4,435
$333
$133
$3,969
$2,217
$1,752
1645
$2.75
$4,523
$339
$136
$4,048
$2,262
$1,787
1678
$2.75
$4,614
$346
$138
$4,129
$2,307
$1,822
1711
$2.75
$4,706
$353
$141
$4,212
$2,353
$1,859
1746
$2.75
$4,800
$360
$144
$4,296
$2,400
$1,896
1780
$2.75
$4,896
$367
$147
$4,382
$2,448
$1,934
1816
$2.75
$4,994
$375
$150
$4,470
$2,497
$1,973
900
$3.75
$3,375
$253
$101
$3,021
$1,688
$1,333
918
$3.75
$3,443
$258
$103
$3,081
$1,721
$1,360
1400
$3.75
$5,250
$394
$158
$4,699
$2,625
$2,074
1700
$3.75
$6,375
$478
$191
$5,706
$3,188
$2,518
1734
$3.75
$6,503
$488
$195
$5,820
$3,251
$2,568
1769
$3.75
$6,633
$497
$199
$5,936
$3,316
$2,620
1804
$3.75
$6,765
$507
$203
$6,055
$3,383
$2,672
1840
$3.75
$6,901
$518
$207
$6,176
$3,450
$2,726
1877
$3.75
$7,039
$528
$211
$6,299
$3,519
$2,780
1914
$3.75
$7,179
$538
$215
$6,425
$3,590
$2,836
1953
$3.75
$7,323
$549
$220
$6,554
$3,661
$2,893
1992
$3.75
$7,469
$560
$224
$6,685
$3,735
$2,950
1100
$4.95
$5,445
$408
$163
$4,873
$2,723
$2,151
1122
$4.95
$5,554
$417
$167
$4,971
$2,777
$2,194
1100
$4.95
$5,445
$408
$163
$4,873
$2,723
$2,151
1450
$4.95
$7,178
$538
$215
$6,424
$3,589
$2,835
1479
$4.95
$7,321
$549
$220
$6,552
$3,661
$2,892
1509
$4.95
$7,467
$560
$224
$6,683
$3,734
$2,950
1539
$4.95
$7,617
$571
$229
$6,817
$3,808
$3,009
1570
$4.95
$7,769
$583
$233
$6,953
$3,885
$3,069
1601
$4.95
$7,925
$594
$238
$7,092
$3,962
$3,130
1633
$4.95
$8,083
$606
$242
$7,234
$4,042
$3,193
1666
$4.95
$8,245
$618
$247
$7,379
$4,122
$3,257
1699
$4.95
$8,410
$631
$252
$7,527
$4,205
$3,322
1000
$2.50
1020
$2.50
900
$2.50
1100
$2.50
1400
$2.50
1428
$2.50
1457
$2.50
1486
$2.50
1515
$2.50
1546
$2.50
1577
$2.50
1608
$2.50
18384
17836
$49,048
$3,679
$1,471
$43,898
$24,524
$19,374
19801
$74,253
$5,569
$2,228
$66,457
$37,127
$29,330
17466
$86,458
$6,484
$2,594
$77,380
$43,229
$34,151
16036
October
2500
$4.87
$12,172
$913
$365.16
$10,894
$6,086
$4,808
2290
$4.77
$10,915
$819
$327
$9,769
$5,457
$4,311
2200
$2.82
$6,201
$465
$186
$5,550
$3,101
$2,449
2600
$3.84
$9,994
$750
$300
$8,944
$4,997
$3,948
2750
$5.07
$13,953
$1,046
$419
$12,488
$6,976
$5,511
1640
$2.56
Sales Projections
$2,500
$188
$75
$2,238
$1,250
$988
$2,550
$191
$77
$2,282
$1,275
$1,007
$2,250
$169
$68
$2,014
$1,125
$889
$2,750
$206
$83
$2,461
$1,375
$1,086
$3,500
$263
$105
$3,133
$1,750
$1,383
$3,570
$268
$107
$3,195
$1,785
$1,410
$3,641
$273
$109
$3,259
$1,821
$1,438
$3,714
$279
$111
$3,324
$1,857
$1,467
$3,789
$284
$114
$3,391
$1,894
$1,496
$3,864
$290
$116
$3,459
$1,932
$1,526
$3,942
$296
$118
$3,528
$1,971
$1,557
$4,020
$302
$121
$3,598
$2,010
$1,588
$40,090
$3,007
$1,203
$35,881
$20,045
$15,836
$4,203
$315
$126
$3,762
$2,102
$1,660
700
$2.50
$1,750
$131
$53
$1,566
$875
$691
714
$2.50
$1,785
$134
$54
$1,598
$893
$705
900
$2.50
$2,250
$169
$68
$2,014
$1,125
$889
1200
$2.50
$3,000
$225
$90
$2,685
$1,500
$1,185
1550
$2.50
$3,875
$291
$116
$3,468
$1,938
$1,531
1581
$2.50
$3,953
$296
$119
$3,537
$1,976
$1,561
1613
$2.50
$4,032
$302
$121
$3,608
$2,016
$1,592
1645
$2.50
$4,112
$308
$123
$3,680
$2,056
$1,624
1678
$2.50
$4,194
$315
$126
$3,754
$2,097
$1,657
1711
$2.50
$4,278
$321
$128
$3,829
$2,139
$1,690
1746
$2.50
$4,364
$327
$131
$3,906
$2,182
$1,724
1780
$2.50
$4,451
$334
$134
$3,984
$2,226
$1,758
16818
3100
$2.56
$7,944
$596
$238
$7,110
$3,972
$3,138
Product Line 8 (Nutella-stuffed cinnamon sugar muffins)
Unit Volume
2.00%
Unit Price
2.50%
Gross Sales
(Commissions)
50.00% 15.00%
(Returns and Allowances)
3.00%
Net Sales
(Cost of Goods Sold)
50.00%
GROSS PROFIT
750
$3.65
$2,738
$205
$82
$2,450
$1,369
$1,081
765
$3.65
$2,792
$209
$84
$2,499
$1,396
$1,103
950
$3.65
$3,468
$260
$104
$3,103
$1,734
$1,370
1200
$3.65
$4,380
$329
$131
$3,920
$2,190
$1,730
1600
$3.65
$5,840
$438
$175
$5,227
$2,920
$2,307
1632
$3.65
$5,957
$447
$179
$5,331
$2,978
$2,353
1800
$3.65
$6,570
$493
$197
$5,880
$3,285
$2,595
1836
$3.65
$6,701
$503
$201
$5,998
$3,351
$2,647
1873
$3.65
$6,835
$513
$205
$6,118
$3,418
$2,700
1910
$3.65
$6,972
$523
$209
$6,240
$3,486
$2,754
1948
$3.65
$7,112
$533
$213
$6,365
$3,556
$2,809
1987
$3.65
$7,254
$544
$218
$6,492
$3,627
$2,865
Product Line 9 (Banana bread muffin)
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
900
$4.50
$4,050
$304
$122
$3,625
$2,025
$1,600
918
$4.50
$4,131
$310
$124
$3,697
$2,066
$1,632
850
$4.50
$3,825
$287
$115
$3,423
$1,913
$1,511
1050
$4.50
$4,725
$354
$142
$4,229
$2,363
$1,866
1450
$4.50
$6,525
$489
$196
$5,840
$3,263
$2,577
1900
$4.50
$8,550
$641
$257
$7,652
$4,275
$3,377
1938
$4.50
$8,721
$654
$262
$7,805
$4,361
$3,445
1977
$4.50
$8,895
$667
$267
$7,961
$4,448
$3,514
2016
$4.50
$9,073
$680
$272
$8,121
$4,537
$3,584
2057
$4.50
$9,255
$694
$278
$8,283
$4,627
$3,656
2098
$4.50
$9,440
$708
$283
$8,449
$4,720
$3,729
1750
$4.50
$7,875
$591
$236
$7,048
$3,938
$3,111
$85,065
$6,380
$2,552
$76,134
$42,533
$33,601
750
$3.95
$2,963
$222
$89
$2,651
$1,481
$1,170
765
$3.95
$3,022
$227
$91
$2,704
$1,511
$1,194
900
$3.95
$3,555
$267
$107
$3,182
$1,778
$1,404
1100
$3.95
$4,345
$326
$130
$3,889
$2,173
$1,716
1400
$3.95
$5,530
$415
$166
$4,949
$2,765
$2,184
1428
$3.95
$5,641
$423
$169
$5,048
$2,820
$2,228
1457
$3.95
$5,753
$432
$173
$5,149
$2,877
$2,273
1486
$3.95
$5,868
$440
$176
$5,252
$2,934
$2,318
1515
$3.95
$5,986
$449
$180
$5,357
$2,993
$2,364
1546
$3.95
$6,106
$458
$183
$5,464
$3,053
$2,412
1577
$3.95
$6,228
$467
$187
$5,574
$3,114
$2,460
1608
$3.95
$6,352
$476
$191
$5,685
$3,176
$2,509
$61,348
$4,601
$1,840
$54,907
$30,674
$24,232
1640
$4.05
$6,641
$498
$199
$5,944
$3,321
$2,623
8450
$32,318
$2,424
$970
$28,924
$16,159
$12,765
8639
$33,055
$2,479
$992
$29,584
$16,527
$13,057
9950
$37,760
$2,832
$1,133
$33,795
$18,880
$14,915
12950
$49,235
$3,693
$1,477
$44,065
$24,618
$19,448
15344
$58,249
$4,369
$1,747
$52,133
$29,124
$23,008
16118
$61,525
$4,614
$1,846
$55,064
$30,762
$24,302
16625
$63,476
$4,761
$1,904
$56,811
$31,738
$25,073
17009
$64,984
$4,874
$1,950
$58,161
$32,492
$25,669
17403
$66,534
$4,990
$1,996
$59,548
$33,267
$26,281
17807
$68,127
$5,110
$2,044
$60,974
$34,064
$26,910
18223
$69,766
$5,232
$2,093
$62,441
$34,883
$27,558
18260
$69,697
$5,227
$2,091
$62,379
$34,849
$27,530
176777
$674,725
$50,604
$20,242
$603,879
$337,363
$266,516
22533
$87,840
$6,588
$2,635
$78,617
$43,920
$34,697
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
Product Line 7 (Lemon crumb muffin)
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
50.00% 15.00%
3.00%
50.00%
2.00%
2.50%
50.00% 15.00%
3.00%
50.00%
2.00%
2.50%
50.00% 15.00%
3.00%
50.00%
Product Line 10 (Blonde, medium, and dark roast coffee)
Unit Volume
2.00%
Unit Price
2.50%
Gross Sales
(Commissions)
50.00% 15.00%
(Returns and Allowances)
3.00%
Net Sales
(Cost of Goods Sold)
50.00%
GROSS PROFIT
Totals for All Product Lines
Total Unit Volume
Total Gross Sales
(Total Commissions)
(Total Returns and Allowances)
Total Net Sales
(Total Cost of Goods Sold)
TOTAL GROSS PROFIT
$42,044
$3,153
$1,261
$37,629
$21,022
$16,607
18252
$66,618
$4,996
$1,999
$59,623
$33,309
$26,314
18903
15531
2027
$3.74
$7,584
$569
$228
$6,788
$3,792
$2,996
1785
$4.61
$8,233
$617
$247
$7,369
$4,117
$3,252
Sales Projections
2023-2024
November
December
January
February
March
April
May
June
July
August
September
TOTAL
2550
$4.87
$12,415
$931
$372.46
$11,112
$6,208
$4,904
2601
$4.87
$12,664
$950
$379.91
$11,334
$6,332
$5,002
2200
$4.87
$10,711
$803
$321.34
$9,587
$5,356
$4,231
2600
$4.87
$12,659
$949
$379.76
$11,330
$6,329
$5,000
2652
$4.87
$12,912
$968
$387.36
$11,556
$6,456
$5,100
2705
$4.87
$13,170
$988
$395.10
$11,787
$6,585
$5,202
2759
$4.87
$13,434
$1,008
$403.01
$12,023
$6,717
$5,306
2814
$4.87
$13,702
$1,028
$411.07
$12,264
$6,851
$5,412
2871
$4.87
$13,976
$1,048
$419.29
$12,509
$6,988
$5,521
2928
$4.87
$14,256
$1,069
$427.67
$12,759
$7,128
$5,631
2987
$4.87
$14,541
$1,091
$436.23
$13,014
$7,270
$5,744
32167
$156,612
$11,746
$4,698
$140,167
$78,306
$61,862
2405
$4.77
$11,461
$860
$344
$10,257
$5,730
$4,527
2525
$4.77
$12,034
$903
$361
$10,770
$6,017
$4,753
2651
$4.77
$12,635
$948
$379
$11,309
$6,318
$4,991
2784
$4.77
$13,267
$995
$398
$11,874
$6,634
$5,241
2923
$4.77
$13,931
$1,045
$418
$12,468
$6,965
$5,503
3069
$4.77
$14,627
$1,097
$439
$13,091
$7,314
$5,778
3222
$4.77
$15,358
$1,152
$461
$13,746
$7,679
$6,067
3383
$4.77
$16,126
$1,209
$484
$14,433
$8,063
$6,370
3553
$4.77
$16,933
$1,270
$508
$15,155
$8,466
$6,688
3730
$4.77
$17,779
$1,333
$533
$15,913
$8,890
$7,023
3917
$4.77
$18,668
$1,400
$560
$16,708
$9,334
$7,374
$173,735
$13,030
$5,212
$155,493
$86,868
$68,625
2244
$2.82
$6,325
$474
$190
$5,661
$3,163
$2,498
2289
$2.82
$6,452
$484
$194
$5,774
$3,226
$2,548
2335
$2.82
$6,581
$494
$197
$5,890
$3,290
$2,599
2381
$2.82
$6,712
$503
$201
$6,008
$3,356
$2,651
2429
$2.82
$6,847
$514
$205
$6,128
$3,423
$2,704
2478
$2.82
$6,984
$524
$210
$6,250
$3,492
$2,759
2527
$2.82
$7,123
$534
$214
$6,375
$3,562
$2,814
2578
$2.82
$7,266
$545
$218
$6,503
$3,633
$2,870
2629
$2.82
$7,411
$556
$222
$6,633
$3,706
$2,927
2682
$2.82
$7,559
$567
$227
$6,766
$3,780
$2,986
2735
$2.82
$7,710
$578
$231
$6,901
$3,855
$3,046
2652
$3.84
$10,194
$765
$306
$9,123
$5,097
$4,026
2700
$3.84
$10,378
$778
$311
$9,288
$5,189
$4,099
2754
$3.84
$10,586
$794
$318
$9,474
$5,293
$4,181
2809
$3.84
$10,797
$810
$324
$9,664
$5,399
$4,265
2865
$3.84
$11,013
$826
$330
$9,857
$5,507
$4,350
2923
$3.84
$11,234
$843
$337
$10,054
$5,617
$4,437
2981
$3.84
$11,458
$859
$344
$10,255
$5,729
$4,526
3041
$3.84
$11,687
$877
$351
$10,460
$5,844
$4,617
3101
$3.84
$11,921
$894
$358
$10,669
$5,961
$4,709
3163
$3.84
$12,160
$912
$365
$10,883
$6,080
$4,803
3227
$3.84
$12,403
$930
$372
$11,101
$6,201
$4,899
2805
$5.07
$14,232
$1,067
$427
$12,738
$7,116
$5,622
2861
$5.07
$14,517
$1,089
$435
$12,992
$7,258
$5,734
2918
$5.07
$14,807
$1,111
$444
$13,252
$7,403
$5,849
2977
$5.07
$15,103
$1,133
$453
$13,517
$7,551
$5,966
3036
$5.07
$15,405
$1,155
$462
$13,788
$7,703
$6,085
3097
$5.07
$15,713
$1,178
$471
$14,063
$7,857
$6,207
3159
$5.07
$16,027
$1,202
$481
$14,345
$8,014
$6,331
3222
$5.07
$16,348
$1,226
$490
$14,631
$8,174
$6,457
3287
$5.07
$16,675
$1,251
$500
$14,924
$8,337
$6,587
3352
$5.07
$17,008
$1,276
$510
$15,223
$8,504
$6,718
3419
$5.07
$17,349
$1,301
$520
$15,527
$8,674
$6,853
1673
$2.56
1900
$2.56
1938
$2.56
1977
$2.56
2016
$2.56
2057
$2.56
2098
$2.56
2140
$2.56
2183
$2.56
2226
$2.56
2271
$2.56
36451
29507
$83,172
$6,238
$2,495
$74,439
$41,586
$32,853
34816
$133,825
$10,037
$4,015
$119,773
$66,912
$52,861
36883
$187,136
$14,035
$5,614
$167,487
$93,568
$73,919
24118
2024-2025
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
TOTAL
9323
$4.99
$46,526
$3,489
$1,395.78
$41,641
$23,263
$18,378
9894
$4.99
$49,374
$3,703
$1,481.21
$44,189
$24,687
$19,503
10499
$4.99
$52,396
$3,930
$1,571.87
$46,894
$26,198
$20,696
11142
$4.99
$55,603
$4,170
$1,668.08
$49,764
$27,801
$21,963
40857
$203,898
$15,292
$6,117
$182,489
$101,949
$80,540
12965
$4.89
$63,339
$4,750
$1,900
$56,689
$31,670
$25,019
15009
$4.89
$73,323
$5,499
$2,200
$65,624
$36,662
$28,963
17374
$4.89
$84,881
$6,366
$2,546
$75,968
$42,440
$33,528
20113
$4.89
$98,260
$7,370
$2,948
$87,943
$49,130
$38,813
$319,803
$23,985
$9,594
$286,224
$159,902
$126,322
8539
$2.89
$24,671
$1,850
$740
$22,080
$12,335
$9,745
9062
$2.89
$26,181
$1,964
$785
$23,432
$13,090
$10,341
9616
$2.89
$27,783
$2,084
$834
$24,866
$13,892
$10,974
10205
$2.89
$29,484
$2,211
$885
$26,388
$14,742
$11,646
10073
$3.94
$39,685
$2,976
$1,191
$35,518
$19,842
$15,675
10689
$3.94
$42,114
$3,159
$1,263
$37,692
$21,057
$16,635
11343
$3.94
$44,691
$3,352
$1,341
$39,999
$22,346
$17,653
12038
$3.94
$47,427
$3,557
$1,423
$42,447
$23,713
$18,734
10674
$5.20
$55,509
$4,163
$1,665
$49,681
$27,755
$21,926
11327
$5.20
$58,907
$4,418
$1,767
$52,722
$29,453
$23,268
12020
$5.20
$62,513
$4,688
$1,875
$55,949
$31,256
$24,692
12756
$5.20
$66,339
$4,975
$1,990
$59,373
$33,169
$26,204
7088
$2.63
7522
$2.63
7982
$2.63
8471
$2.63
65461
37422
$108,119
$8,109
$3,244
$96,766
$54,059
$42,707
44143
$173,917
$13,044
$5,217
$155,655
$86,958
$68,697
46777
$243,268
$18,245
$7,298
$217,724
$121,634
$96,091
31064
1st Quarter
11824
$5.12
$60,481
$4,536
$1,814.44
$54,131
$30,241
$23,890
23283
$5.01
$116,592
$8,744
$3,498
$104,350
$58,296
$46,054
10829
$2.96
$32,071
$2,405
$962
$28,703
$16,035
$12,668
12775
$4.04
$51,588
$3,869
$1,548
$46,171
$25,794
$20,377
13537
$5.33
$72,159
$5,412
$2,165
$64,582
$36,080
$28,503
8990
$2.69
Sales Projections
$4,287
$322
$129
$3,837
$2,144
$1,694
$4,869
$365
$146
$4,358
$2,434
$1,923
$4,966
$372
$149
$4,445
$2,483
$1,962
$5,065
$380
$152
$4,534
$2,533
$2,001
$5,167
$388
$155
$4,624
$2,583
$2,041
$5,270
$395
$158
$4,717
$2,635
$2,082
$5,375
$403
$161
$4,811
$2,688
$2,123
$5,483
$411
$164
$4,907
$2,742
$2,166
$5,593
$419
$168
$5,005
$2,796
$2,209
$5,705
$428
$171
$5,106
$2,852
$2,253
$5,819
$436
$175
$5,208
$2,909
$2,298
$61,802
$4,635
$1,854
$55,313
$30,901
$24,412
$18,617
$1,396
$559
$16,663
$9,309
$7,354
$19,757
$1,482
$593
$17,683
$9,879
$7,804
$20,966
$1,572
$629
$18,765
$10,483
$8,282
$22,250
$1,669
$667
$19,913
$11,125
$8,789
$81,590
$6,119
$2,448
$73,023
$40,795
$32,228
$24,202
$1,815
$726
$21,661
$12,101
$9,560
3162
$2.56
$8,103
$608
$243
$7,252
$4,051
$3,201
2400
$2.56
$6,150
$461
$185
$5,504
$3,075
$2,429
2448
$2.56
$6,273
$470
$188
$5,614
$3,137
$2,478
2497
$2.56
$6,398
$480
$192
$5,727
$3,199
$2,527
2547
$2.56
$6,526
$489
$196
$5,841
$3,263
$2,578
2598
$2.56
$6,657
$499
$200
$5,958
$3,328
$2,629
2650
$2.56
$6,790
$509
$204
$6,077
$3,395
$2,682
2703
$2.56
$6,926
$519
$208
$6,199
$3,463
$2,736
2757
$2.56
$7,064
$530
$212
$6,323
$3,532
$2,790
2812
$2.56
$7,206
$540
$216
$6,449
$3,603
$2,846
2868
$2.56
$7,350
$551
$220
$6,578
$3,675
$2,903
32541
8953
$2.63
$23,517
$1,764
$706
$21,048
$11,758
$9,289
9501
$2.63
$24,956
$1,872
$749
$22,336
$12,478
$9,858
10083
$2.63
$26,484
$1,986
$795
$23,703
$13,242
$10,461
10700
$2.63
$28,105
$2,108
$843
$25,154
$14,052
$11,101
39238
11355
$2.69
$30,571
$2,293
$917
$27,361
$15,285
$12,075
2068
$3.74
$7,736
$580
$232
$6,923
$3,868
$3,056
2109
$3.74
$7,890
$592
$237
$7,062
$3,945
$3,117
3200
$3.74
$11,972
$898
$359
$10,715
$5,986
$4,729
3264
$3.74
$12,211
$916
$366
$10,929
$6,106
$4,824
3329
$3.74
$12,456
$934
$374
$11,148
$6,228
$4,920
3396
$3.74
$12,705
$953
$381
$11,371
$6,352
$5,018
3464
$3.74
$12,959
$972
$389
$11,598
$6,479
$5,119
3533
$3.74
$13,218
$991
$397
$11,830
$6,609
$5,221
3604
$3.74
$13,482
$1,011
$404
$12,067
$6,741
$5,326
3676
$3.74
$13,752
$1,031
$413
$12,308
$6,876
$5,432
3749
$3.74
$14,027
$1,052
$421
$12,554
$7,014
$5,541
11704
$3.83
$44,882
$3,366
$1,346
$40,169
$22,441
$17,728
12420
$3.83
$47,629
$3,572
$1,429
$42,628
$23,814
$18,813
13180
$3.83
$50,544
$3,791
$1,516
$45,237
$25,272
$19,965
13987
$3.83
$53,638
$4,023
$1,609
$48,006
$26,819
$21,187
1821
$4.61
$8,398
$630
$252
$7,516
$4,199
$3,317
2200
$4.61
$10,148
$761
$304
$9,082
$5,074
$4,008
2244
$4.61
$10,350
$776
$311
$9,264
$5,175
$4,088
2289
$4.61
$10,557
$792
$317
$9,449
$5,279
$4,170
2335
$4.61
$10,769
$808
$323
$9,638
$5,384
$4,254
2381
$4.61
$10,984
$824
$330
$9,831
$5,492
$4,339
2429
$4.61
$11,204
$840
$336
$10,027
$5,602
$4,425
2478
$4.61
$11,428
$857
$343
$10,228
$5,714
$4,514
2527
$4.61
$11,656
$874
$350
$10,432
$5,828
$4,604
2578
$4.61
$11,889
$892
$357
$10,641
$5,945
$4,696
2629
$4.61
$12,127
$910
$364
$10,854
$6,064
$4,790
$127,744
$9,581
$3,832
$114,331
$63,872
$50,459
8207
$4.73
$38,803
$2,910
$1,164
$34,728
$19,401
$15,327
8710
$4.73
$41,178
$3,088
$1,235
$36,854
$20,589
$16,265
9243
$4.73
$43,698
$3,277
$1,311
$39,110
$21,849
$17,261
9809
$4.73
$46,373
$3,478
$1,391
$41,504
$23,186
$18,317
$170,052
$12,754
$5,102
$152,196
$85,026
$67,170
2300
$4.05
$9,312
$698
$279
$8,334
$4,656
$3,678
2346
$4.05
$9,498
$712
$285
$8,501
$4,749
$3,752
2393
$4.05
$9,688
$727
$291
$8,671
$4,844
$3,827
2441
$4.05
$9,882
$741
$296
$8,844
$4,941
$3,903
2490
$4.05
$10,080
$756
$302
$9,021
$5,040
$3,981
2539
$4.05
$10,281
$771
$308
$9,202
$5,141
$4,061
2590
$4.05
$10,487
$787
$315
$9,386
$5,243
$4,142
2642
$4.05
$10,697
$802
$321
$9,574
$5,348
$4,225
2695
$4.05
$10,911
$818
$327
$9,765
$5,455
$4,310
2749
$4.05
$11,129
$835
$334
$9,960
$5,564
$4,396
2804
$4.05
$11,351
$851
$341
$10,160
$5,676
$4,484
$119,958
$8,997
$3,599
$107,362
$59,979
$47,383
8752
$4.15
$36,321
$2,724
$1,090
$32,507
$18,160
$14,347
9288
$4.15
$38,544
$2,891
$1,156
$34,497
$19,272
$15,225
9856
$4.15
$40,903
$3,068
$1,227
$36,608
$20,451
$16,157
10459
$4.15
$43,406
$3,255
$1,302
$38,849
$21,703
$17,146
$159,174
$11,938
$4,775
$142,460
$79,587
$62,874
11100
$4.25
$47,215
$3,541
$1,416
$42,257
$23,607
$18,650
23679
$92,462
$6,935
$2,774
$82,754
$46,231
$36,523
23931
$94,599
$7,095
$2,838
$84,666
$47,299
$37,366
25081
$98,570
$7,393
$2,957
$88,220
$49,285
$38,935
26018
$102,654
$7,699
$3,080
$91,875
$51,327
$40,548
26622
$105,105
$7,883
$3,153
$94,069
$52,552
$41,516
27242
$107,625
$8,072
$3,229
$96,324
$53,812
$42,512
27879
$110,216
$8,266
$3,306
$98,643
$55,108
$43,535
28533
$112,881
$8,466
$3,386
$101,029
$56,441
$44,588
29205
$115,623
$8,672
$3,469
$103,482
$57,811
$45,671
29896
$118,443
$8,883
$3,553
$106,007
$59,222
$46,785
30606
$121,345
$9,101
$3,640
$108,604
$60,673
$47,931
321225
$1,267,363
$95,052
$38,021
$1,134,290
$633,681
$500,608
96278
$391,869
$29,390
$11,756
$350,723
$195,935
$154,788
103421
$421,962
$31,647
$12,659
$377,656
$210,981
$166,675
111198
$454,859
$34,114
$13,646
$407,099
$227,430
$179,669
119680
$490,884
$36,816
$14,727
$439,341
$245,442
$193,899
430577
$1,759,574
$131,968
$52,787
$1,574,819
$879,787
$695,032
128944
$543,664
$40,775
$16,310
$486,579
$271,832
$214,747
$83,387
$6,254
$2,502
$74,632
$41,694
$32,938
37419
$139,992
$10,499
$4,200
$125,293
$69,996
$55,297
27695
29628
$103,062
$7,730
$3,092
$92,240
$51,531
$40,709
51292
$196,693
$14,752
$5,901
$176,040
$98,346
$77,694
35968
38355
14843
$3.93
$58,344
$4,376
$1,750
$52,218
$29,172
$23,046
10409
$4.85
$50,442
$3,783
$1,513
$45,145
$25,221
$19,924
Sales Projections
2025-2026
2nd Quarter 3rd Quarter 4th Quarter
TOTAL
12547
$5.12
$64,183
$4,814
$1,925.49
$57,444
$32,092
$25,352
13315
$5.12
$68,112
$5,108
$2,043.35
$60,960
$34,056
$26,904
14130
$5.12
$72,281
$5,421
$2,168.42
$64,691
$36,140
$28,551
51817
$265,056
$19,879
$7,952
$237,226
$132,528
$104,697
26953
$5.01
$134,970
$10,123
$4,049
$120,798
$67,485
$53,313
31202
$5.01
$156,244
$11,718
$4,687
$139,839
$78,122
$61,717
36120
$5.01
$180,873
$13,565
$5,426
$161,881
$90,436
$71,445
$588,679
$44,151
$17,660
$526,868
$294,339
$232,528
11492
$2.96
$34,034
$2,553
$1,021
$30,460
$17,017
$13,443
12196
$2.96
$36,117
$2,709
$1,084
$32,325
$18,058
$14,266
12942
$2.96
$38,328
$2,875
$1,150
$34,303
$19,164
$15,139
13556
$4.04
$54,746
$4,106
$1,642
$48,997
$27,373
$21,625
14386
$4.04
$58,096
$4,357
$1,743
$51,996
$29,048
$22,948
15267
$4.04
$61,652
$4,624
$1,850
$55,179
$30,826
$24,353
14365
$5.33
$76,576
$5,743
$2,297
$68,535
$38,288
$30,247
15245
$5.33
$81,263
$6,095
$2,438
$72,730
$40,631
$32,099
16178
$5.33
$86,237
$6,468
$2,587
$77,182
$43,118
$34,064
9540
$2.69
10124
$2.69
10743
$2.69
117558
47460
$140,549
$10,541
$4,216
$125,791
$70,274
$55,517
55984
$226,082
$16,956
$6,782
$202,344
$113,041
$89,303
59324
$316,235
$23,718
$9,487
$283,030
$158,118
$124,913
39396
65717
$5.24
$344,560
$25,842
$10,336.79
$308,381
$172,280
$136,101
211118
$5.13
$1,083,612
$81,271
$32,508
$969,833
$541,806
$428,027
60190
$3.04
$182,706
$13,703
$5,481
$163,522
$91,353
$72,169
71001
$4.14
$293,895
$22,042
$8,817
$263,036
$146,948
$116,089
75238
$5.46
$411,089
$30,832
$12,333
$367,925
$205,545
$162,380
49964
$2.76
Sales Projections
$25,683
$1,926
$770
$22,986
$12,842
$10,145
$27,255
$2,044
$818
$24,393
$13,628
$10,766
$28,923
$2,169
$868
$25,886
$14,462
$11,425
$106,063
$7,955
$3,182
$94,927
$53,032
$41,895
$137,877
$10,341
$4,136
$123,400
$68,938
$54,461
12050
$2.69
$32,442
$2,433
$973
$29,035
$16,221
$12,815
12788
$2.69
$34,428
$2,582
$1,033
$30,813
$17,214
$13,599
13570
$2.69
$36,535
$2,740
$1,096
$32,699
$18,267
$14,431
49764
63112
$2.76
$174,160
$13,062
$5,225
$155,873
$87,080
$68,793
15752
$3.93
$61,915
$4,644
$1,857
$55,414
$30,958
$24,456
16716
$3.93
$65,705
$4,928
$1,971
$58,806
$32,852
$25,953
17739
$3.93
$69,726
$5,229
$2,092
$62,405
$34,863
$27,542
11046
$4.85
$53,529
$4,015
$1,606
$47,908
$26,765
$21,144
11722
$4.85
$56,805
$4,260
$1,704
$50,841
$28,403
$22,438
12440
$4.85
$60,282
$4,521
$1,808
$53,953
$30,141
$23,812
$221,058
$16,579
$6,632
$197,847
$110,529
$87,318
11779
$4.25
$50,105
$3,758
$1,503
$44,844
$25,052
$19,791
12500
$4.25
$53,172
$3,988
$1,595
$47,589
$26,586
$21,003
13265
$4.25
$56,426
$4,232
$1,693
$50,501
$28,213
$22,288
$206,917
$15,519
$6,208
$185,191
$103,459
$81,732
61692
$4.36
$268,982
$20,174
$8,069
$240,739
$134,491
$106,248
139082
$588,182
$44,114
$17,645
$526,423
$294,091
$232,332
150193
$637,197
$47,790
$19,116
$570,291
$318,598
$251,693
162395
$691,263
$51,845
$20,738
$618,680
$345,632
$273,049
580614
$2,460,306
$184,523
$73,809
$2,201,974
$1,230,153
$971,821
798385
$3,516,630
$263,747
$105,499
$3,147,384
$1,758,315
$1,389,069
$133,975
$10,048
$4,019
$119,907
$66,987
$52,920
65050
$255,690
$19,177
$7,671
$228,843
$127,845
$100,998
45617
48644
82500
$4.03
$332,384
$24,929
$9,972
$297,484
$166,192
$131,292
57853
$4.97
$287,364
$21,552
$8,621
$257,191
$143,682
$113,509
Inventory
2021-2022
October
2022-2023
November
December
January
February
March
April
May
June
July
August
September
TOTAL
October
November
Product Line 1 (Café Espresso Con Pan)
Cost of Goods Sold
Ingredients
Coffee-to-go containers
Cofee jackets and coffee stirrers
Cup carrier trays
Total Inventory Expense
$2,138
$535
$535
$535
$535
$2,138
$2,180
$545
$545
$545
$545
$2,180
$2,138
$535
$535
$535
$535
$2,138
$3,088
$772
$772
$772
$772
$3,088
$3,800
$950
$950
$950
$950
$3,800
$3,876
$968
$969
$969
$969
$3,876
$3,954
$988
$989
$989
$989
$3,954
$4,033
$1,008
$1,008
$1,008
$1,008
$4,033
$4,113
$1,028
$1,029
$1,029
$1,029
$4,113
$4,196
$1,048
$1,049
$1,049
$1,049
$4,196
$4,279
$1,069
$1,070
$1,070
$1,070
$4,279
$4,365
$1,090
$1,092
$1,092
$1,092
$4,365
$42,158
$10,534
$10,542
$10,542
$10,542
$42,160
$6,086
$6,208
$1,522
$1,522
$1,522
$10,773
$6,208
$6,332
$1,552
$1,552
$1,552
$10,989
Product Line 2 (Café Con Miel)
Cost of Goods Sold
Ingredients
Items/Parts 2
Items/Parts 3
Items/Parts 4
Total Inventory Expense
$1,511
$378
$378
$378
$378
$1,512
$1,587
$2,209
$397
$397
$397
$3,399
$2,209
$3,074
$552
$552
$552
$4,732
$3,023
$4,207
$756
$756
$756
$6,475
$3,604
$5,016
$901
$901
$901
$7,720
$3,784
$5,267
$946
$946
$946
$8,106
$3,973
$5,530
$994
$994
$994
$8,512
$4,172
$5,807
$1,043
$1,043
$1,043
$8,937
$4,380
$6,097
$1,096
$1,096
$1,096
$9,384
$4,599
$6,402
$1,150
$1,150
$1,150
$9,853
$4,829
$6,722
$1,208
$1,208
$1,208
$10,346
$5,071
$5,457
$1,268
$1,268
$1,268
$9,263
$42,742
$56,168
$10,691
$10,691
$10,691
$88,240
$5,457
$5,730
$1,365
$1,365
$1,365
$9,826
$5,730
$6,017
$1,433
$1,433
$1,433
$10,317
Product Line 3 (Café Latte)
Cost of Goods Sold
Ingredients
Items/Parts 2
Items/Parts 3
Items/Parts 4
Total Inventory Expense
$1,100
$800
$200
$100
$0
$1,100
$1,122
$1,513
$204
$102
$0
$1,819
$1,513
$2,039
$275
$138
$0
$2,451
$2,131
$2,873
$388
$194
$0
$3,454
$2,174
$2,930
$395
$198
$0
$3,523
$2,217
$2,989
$403
$202
$0
$3,594
$2,262
$3,049
$411
$206
$0
$3,666
$2,307
$3,110
$419
$210
$0
$3,739
$2,353
$3,172
$428
$214
$0
$3,814
$2,400
$3,235
$436
$218
$0
$3,890
$2,448
$3,300
$445
$223
$0
$3,968
$2,497
$3,101
$454
$227
$0
$3,782
$24,524
$32,111
$4,459
$2,229
$0
$38,799
$3,101
$3,163
$564
$282
$0
$4,008
$3,163
$3,226
$575
$288
$0
$4,088
Product Line 4 (Vanilla Macchiato)
Cost of Goods Sold
Ingredients
Items/Parts 2
Items/Parts 3
Items/Parts 4
Total Inventory Expense
$1,688
$900
$225
$225
$338
$1,688
$1,721
$918
$230
$230
$345
$1,722
$2,625
$1,400
$350
$350
$526
$2,626
$3,188
$1,700
$425
$425
$638
$3,188
$3,251
$1,734
$434
$434
$651
$3,252
$3,316
$1,769
$442
$442
$664
$3,317
$3,383
$1,804
$451
$451
$678
$3,384
$3,450
$1,840
$460
$460
$691
$3,451
$3,519
$1,877
$469
$469
$705
$3,520
$3,590
$1,914
$479
$479
$719
$3,591
$3,661
$1,953
$488
$488
$733
$3,663
$3,735
$1,992
$498
$498
$748
$3,736
$37,127
$19,801
$4,950
$4,950
$7,436
$37,138
$4,997
$2,665
$666
$666
$1,001
$4,998
$5,097
$2,718
$680
$680
$1,021
$5,098
Product Line 5 (Caffe mocha)
Cost of Goods Sold
Ingredients
Items/Parts 2
Items/Parts 3
Items/Parts 4
Total Inventory Expense
$2,723
$681
$681
$681
$681
$2,723
$2,777
$694
$694
$694
$694
$2,777
$2,723
$681
$681
$681
$681
$2,723
$3,589
$897
$897
$897
$897
$3,589
$3,661
$915
$915
$915
$915
$3,661
$3,734
$934
$934
$934
$934
$3,734
$3,808
$952
$952
$952
$952
$3,809
$3,885
$971
$971
$971
$971
$3,885
$3,962
$991
$991
$991
$991
$3,963
$4,042
$1,011
$1,011
$1,011
$1,011
$4,042
$4,122
$1,031
$1,031
$1,031
$1,031
$4,123
$4,205
$1,051
$1,051
$1,051
$1,051
$4,206
$43,229
$10,809
$10,809
$10,809
$10,809
$43,237
$6,976
$1,744
$1,744
$1,744
$1,744
$6,978
$7,116
$1,779
$1,779
$1,779
$1,779
$7,117
Product Line 6 (Blueberry Muffin)
Cost of Goods Sold
Items/Parts 1
Items/Parts 2
Items/Parts 3
Items/Parts 4
Total Inventory Expense
$1,250
$313
$313
$313
$313
$1,250
$1,275
$319
$319
$319
$319
$1,275
$1,125
$281
$281
$281
$281
$1,125
$1,375
$344
$344
$344
$344
$1,375
$1,750
$438
$438
$438
$438
$1,750
$1,785
$446
$446
$446
$446
$1,785
$1,821
$455
$455
$455
$455
$1,821
$1,857
$464
$464
$464
$464
$1,857
$1,894
$474
$474
$474
$474
$1,894
$1,932
$483
$483
$483
$483
$1,932
$1,971
$493
$493
$493
$493
$1,971
$2,010
$503
$503
$503
$503
$2,010
$20,045
$5,011
$5,011
$5,011
$5,011
$20,045
$2,102
$525
$525
$525
$525
$2,102
$2,144
$536
$536
$536
$536
$2,144
$875
$700
$175
$0
$893
$714
$179
$0
$1,125
$900
$225
$0
$1,500
$1,200
$300
$0
$1,938
$1,550
$388
$0
$1,976
$1,581
$395
$0
$2,016
$1,613
$403
$0
$2,056
$1,645
$411
$0
$2,097
$1,678
$419
$0
$2,139
$1,711
$428
$0
$2,182
$1,746
$436
$0
$2,226
$1,780
$445
$0
$21,022
$16,818
$4,204
$0
$3,972
$3,178
$794
$0
$4,051
$3,241
$810
$0
Product Line 7 (Lemon crumb muffin)
Cost of Goods Sold
Ingredients
Items/Parts 2
Items/Parts 3
$0
$893
$0
$1,125
$0
$1,500
$0
$1,938
$0
$1,976
$0
$2,016
$0
$2,056
$0
$2,097
$0
$2,139
$0
$2,182
$0
$2,226
$0
$21,022
$0
$3,972
$0
$4,051
Product Line 8 (Nutella-stuffed cinnamon sugar muffins)
$1,369
$1,396
Cost of Goods Sold
$750
$765
Ingredients
$188
$192
Items/Parts 2
$188
$192
Items/Parts 3
$243
$248
Items/Parts 4
$1,369
$1,396
Total Inventory Expense
$1,734
$950
$238
$238
$308
$1,734
$2,190
$1,200
$301
$301
$389
$2,190
$2,920
$1,600
$401
$401
$518
$2,921
$2,978
$1,632
$409
$409
$529
$2,979
$3,285
$1,800
$451
$451
$583
$3,286
$3,351
$1,836
$460
$460
$595
$3,351
$3,418
$1,873
$469
$469
$607
$3,418
$3,486
$1,910
$479
$479
$619
$3,487
$3,556
$1,948
$488
$488
$631
$3,556
$3,627
$1,987
$498
$498
$644
$3,628
$33,309
$18,252
$4,575
$4,575
$5,914
$33,315
$3,792
$2,078
$521
$521
$673
$3,793
$3,868
$2,119
$531
$531
$687
$3,868
Product Line 9 (Banana bread muffin)
Cost of Goods Sold
Ingredients
Bags
Cartons
Items/Parts 4
Total Inventory Expense
$2,066
$516
$516
$516
$516
$2,066
$1,913
$478
$478
$478
$478
$1,913
$2,363
$591
$591
$591
$591
$2,363
$3,263
$816
$816
$816
$816
$3,263
$4,275
$1,069
$1,069
$1,069
$1,069
$4,275
$4,361
$1,090
$1,090
$1,090
$1,090
$4,361
$4,448
$1,112
$1,112
$1,112
$1,112
$4,448
$4,537
$1,134
$1,134
$1,134
$1,134
$4,537
$4,627
$1,157
$1,157
$1,157
$1,157
$4,627
$4,720
$1,180
$1,180
$1,180
$1,180
$4,720
$3,938
$984
$984
$984
$984
$3,938
$42,533
$10,633
$10,633
$10,633
$10,633
$42,533
$4,117
$1,029
$1,029
$1,029
$1,029
$4,117
$4,199
$1,050
$1,050
$1,050
$1,050
$4,199
Product Line 10 (Blonde, medium, and dark roast coffee)
$1,481
$1,511
Cost of Goods Sold
$750
$765
Ingredients
$188
$191
Bags
$188
$191
Cartons
$357
$364
Items/Parts 4
$1,482
$1,512
Total Inventory Expense
$1,778
$900
$225
$225
$428
$1,778
$2,173
$1,100
$275
$275
$524
$2,174
$2,765
$1,400
$350
$350
$666
$2,766
$2,820
$1,428
$357
$357
$680
$2,822
$2,877
$1,457
$364
$364
$693
$2,878
$2,934
$1,486
$371
$371
$707
$2,936
$2,993
$1,515
$379
$379
$721
$2,994
$3,053
$1,546
$386
$386
$736
$3,054
$3,114
$1,577
$394
$394
$750
$3,115
$3,176
$1,608
$402
$402
$765
$3,178
$30,674
$15,531
$3,883
$3,883
$7,393
$30,690
$3,321
$1,681
$420
$420
$800
$3,322
$4,656
$2,358
$589
$589
$1,122
$4,658
$22,345
$29,397
$34,594
$36,465
$37,685
$38,694
$39,736
$40,812
$41,923
$40,329
$397,179
$53,888
$56,530
Items/Parts 4
Total Inventory Expense
GRAND TOTAL INVENTORY
$0
$875
$2,025
$506
$506
$506
$506
$2,025
$16,162
$19,038
2023-2024
December
January
February
March
April
May
June
July
August
September
TOTAL
2024-2025
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
TOTAL
1st Quarter 2nd Quarter
$6,332
$6,458
$1,583
$1,583
$1,583
$11,208
$5,356
$5,463
$1,339
$1,339
$1,339
$9,480
$6,329
$6,456
$1,583
$1,583
$1,583
$11,204
$6,456
$6,585
$1,614
$1,614
$1,614
$11,428
$6,585
$6,717
$1,647
$1,647
$1,647
$11,657
$6,717
$6,851
$1,680
$1,680
$1,680
$11,890
$6,851
$6,988
$1,713
$1,713
$1,713
$12,128
$6,988
$7,128
$1,747
$1,747
$1,747
$12,370
$7,128
$7,270
$1,782
$1,782
$1,782
$12,618
$7,270
$7,416
$1,818
$1,818
$1,818
$12,870
$78,306
$79,872
$19,581
$19,581
$19,581
$138,615
$23,263
$23,728
$5,817
$5,817
$5,817
$41,179
$24,687
$25,181
$6,173
$6,173
$6,173
$43,700
$26,198
$26,722
$6,551
$6,551
$6,551
$46,375
$27,801
$28,357
$6,952
$6,952
$6,952
$49,213
$101,949
$103,988
$25,493
$25,493
$25,493
$180,467
$30,241
$30,845
$7,562
$7,562
$7,562
$53,531
$32,092
$32,733
$8,025
$8,025
$8,025
$56,808
$6,017
$6,318
$1,505
$1,505
$1,505
$10,833
$6,318
$6,634
$1,580
$1,580
$1,580
$11,374
$6,634
$6,965
$1,659
$1,659
$1,659
$11,943
$6,965
$7,314
$1,742
$1,742
$1,742
$12,540
$7,314
$7,679
$1,829
$1,829
$1,829
$13,167
$7,679
$8,063
$1,921
$1,921
$1,921
$13,825
$8,063
$8,466
$2,017
$2,017
$2,017
$14,517
$8,466
$8,890
$2,118
$2,118
$2,118
$15,243
$8,890
$9,334
$2,224
$2,224
$2,224
$16,005
$9,334
$9,801
$2,335
$2,335
$2,335
$16,805
$86,868
$91,211
$21,728
$21,728
$21,728
$156,394
$31,670
$33,253
$7,921
$7,921
$7,921
$57,017
$36,662
$38,495
$9,170
$9,170
$9,170
$66,005
$42,440
$44,562
$10,615
$10,615
$10,615
$76,408
$49,130
$51,587
$12,289
$12,289
$12,289
$88,452
$159,902
$167,897
$39,995
$39,995
$39,995
$287,883
$58,296
$61,211
$14,581
$14,581
$14,581
$104,955
$67,485
$70,859
$16,880
$16,880
$16,880
$121,498
$3,226
$3,290
$587
$293
$0
$4,170
$3,290
$3,356
$598
$299
$0
$4,254
$3,356
$3,423
$610
$305
$0
$4,339
$3,423
$3,492
$622
$311
$0
$4,425
$3,492
$3,562
$635
$317
$0
$4,514
$3,562
$3,633
$648
$324
$0
$4,604
$3,633
$3,706
$661
$330
$0
$4,696
$3,706
$3,780
$674
$337
$0
$4,790
$3,780
$3,855
$687
$344
$0
$4,886
$3,855
$3,932
$701
$350
$0
$4,984
$41,586
$42,418
$7,561
$3,781
$0
$53,759
$12,335
$12,582
$2,243
$1,121
$0
$15,946
$13,090
$13,352
$2,380
$1,190
$0
$16,922
$13,892
$14,170
$2,526
$1,263
$0
$17,958
$14,742
$15,037
$2,680
$1,340
$0
$19,057
$54,059
$55,141
$9,829
$4,914
$0
$69,884
$16,035
$16,356
$2,916
$1,458
$0
$20,729
$17,017
$17,357
$3,094
$1,547
$0
$21,998
$5,189
$2,768
$692
$692
$1,039
$5,191
$5,293
$2,823
$706
$706
$1,060
$5,294
$5,399
$2,879
$720
$720
$1,081
$5,400
$5,507
$2,937
$734
$734
$1,103
$5,508
$5,617
$2,996
$749
$749
$1,125
$5,618
$5,729
$3,056
$764
$764
$1,148
$5,731
$5,844
$3,117
$779
$779
$1,170
$5,845
$5,961
$3,179
$795
$795
$1,194
$5,962
$6,080
$3,243
$811
$811
$1,218
$6,082
$6,201
$3,307
$827
$827
$1,242
$6,203
$66,912
$35,687
$8,922
$8,922
$13,402
$66,932
$19,842
$10,583
$2,646
$2,646
$3,974
$19,848
$21,057
$11,230
$2,808
$2,808
$4,218
$21,063
$22,346
$11,918
$2,979
$2,979
$4,476
$22,352
$23,713
$12,647
$3,162
$3,162
$4,750
$23,720
$86,958
$46,378
$11,594
$11,594
$17,417
$86,984
$25,794
$13,757
$3,439
$3,439
$5,166
$25,802
$27,373
$14,599
$3,650
$3,650
$5,483
$27,381
$7,258
$1,815
$1,815
$1,815
$1,815
$7,260
$7,403
$1,851
$1,851
$1,851
$1,851
$7,405
$7,551
$1,888
$1,888
$1,888
$1,888
$7,553
$7,703
$1,926
$1,926
$1,926
$1,926
$7,704
$7,857
$1,965
$1,965
$1,965
$1,965
$7,858
$8,014
$2,004
$2,004
$2,004
$2,004
$8,015
$8,174
$2,044
$2,044
$2,044
$2,044
$8,175
$8,337
$2,085
$2,085
$2,085
$2,085
$8,339
$8,504
$2,126
$2,126
$2,126
$2,126
$8,506
$8,674
$2,169
$2,169
$2,169
$2,169
$8,676
$93,568
$23,396
$23,396
$23,396
$23,396
$93,585
$27,755
$6,940
$6,940
$6,940
$6,940
$27,760
$29,453
$7,365
$7,365
$7,365
$7,365
$29,459
$31,256
$7,815
$7,815
$7,815
$7,815
$31,262
$33,169
$8,294
$8,294
$8,294
$8,294
$33,175
$121,634
$30,414
$30,414
$30,414
$30,414
$121,656
$36,080
$9,022
$9,022
$9,022
$9,022
$36,086
$38,288
$9,574
$9,574
$9,574
$9,574
$38,295
$2,434
$609
$609
$609
$609
$2,434
$2,483
$621
$621
$621
$621
$2,483
$2,533
$633
$633
$633
$633
$2,533
$2,583
$646
$646
$646
$646
$2,583
$2,635
$659
$659
$659
$659
$2,635
$2,688
$672
$672
$672
$672
$2,688
$2,742
$685
$685
$685
$685
$2,742
$2,796
$699
$699
$699
$699
$2,796
$2,852
$713
$713
$713
$713
$2,852
$2,909
$727
$727
$727
$727
$2,909
$30,901
$7,725
$7,725
$7,725
$7,725
$30,901
$9,309
$2,327
$2,327
$2,327
$2,327
$9,309
$9,879
$2,470
$2,470
$2,470
$2,470
$9,879
$10,483
$2,621
$2,621
$2,621
$2,621
$10,483
$11,125
$2,781
$2,781
$2,781
$2,781
$11,125
$40,795
$10,199
$10,199
$10,199
$10,199
$40,795
$12,101
$3,025
$3,025
$3,025
$3,025
$12,101
$12,842
$3,210
$3,210
$3,210
$3,210
$12,842
$3,075
$2,460
$615
$0
$3,137
$2,509
$627
$0
$3,199
$2,559
$640
$0
$3,263
$2,611
$653
$0
$3,328
$2,663
$666
$0
$3,395
$2,716
$679
$0
$3,463
$2,770
$693
$0
$3,532
$2,826
$706
$0
$3,603
$2,882
$721
$0
$3,675
$2,940
$735
$0
$41,694
$33,355
$8,339
$0
$11,758
$9,407
$2,352
$0
$12,478
$9,983
$2,496
$0
$13,242
$10,594
$2,648
$0
$14,052
$11,242
$2,810
$0
$51,531
$41,225
$10,306
$0
$15,285
$12,228
$3,057
$0
$16,221
$12,977
$3,244
$0
$0
$3,075
$0
$3,137
$0
$3,199
$0
$3,263
$0
$3,328
$0
$3,395
$0
$3,463
$0
$3,532
$0
$3,603
$0
$3,675
$0
$41,694
$0
$11,758
$0
$12,478
$0
$13,242
$0
$14,052
$0
$51,531
$0
$15,285
$0
$16,221
$3,945
$2,162
$542
$542
$700
$3,946
$5,986
$3,280
$822
$822
$1,063
$5,987
$6,106
$3,346
$839
$839
$1,084
$6,107
$6,228
$3,413
$855
$855
$1,106
$6,229
$6,352
$3,481
$873
$873
$1,128
$6,354
$6,479
$3,550
$890
$890
$1,150
$6,481
$6,609
$3,621
$908
$908
$1,173
$6,610
$6,741
$3,694
$926
$926
$1,197
$6,742
$6,876
$3,768
$944
$944
$1,221
$6,877
$7,014
$3,843
$963
$963
$1,245
$7,015
$69,996
$38,354
$9,614
$9,614
$12,427
$70,009
$22,441
$12,296
$3,082
$3,082
$3,984
$22,445
$23,814
$13,049
$3,271
$3,271
$4,228
$23,819
$25,272
$13,848
$3,471
$3,471
$4,487
$25,277
$26,819
$14,695
$3,684
$3,684
$4,761
$26,824
$98,346
$53,888
$13,508
$13,508
$17,460
$98,364
$29,172
$15,985
$4,007
$4,007
$5,179
$29,177
$30,958
$16,963
$4,252
$4,252
$5,496
$30,963
$5,074
$1,268
$1,268
$1,268
$1,268
$5,074
$5,175
$1,294
$1,294
$1,294
$1,294
$5,175
$5,279
$1,320
$1,320
$1,320
$1,320
$5,279
$5,384
$1,346
$1,346
$1,346
$1,346
$5,384
$5,492
$1,373
$1,373
$1,373
$1,373
$5,492
$5,602
$1,400
$1,400
$1,400
$1,400
$5,602
$5,714
$1,428
$1,428
$1,428
$1,428
$5,714
$5,828
$1,457
$1,457
$1,457
$1,457
$5,828
$5,945
$1,486
$1,486
$1,486
$1,486
$5,945
$6,064
$1,516
$1,516
$1,516
$1,516
$6,064
$63,872
$15,968
$15,968
$15,968
$15,968
$63,872
$19,401
$4,850
$4,850
$4,850
$4,850
$19,401
$20,589
$5,147
$5,147
$5,147
$5,147
$20,589
$21,849
$5,462
$5,462
$5,462
$5,462
$21,849
$23,186
$5,797
$5,797
$5,797
$5,797
$23,186
$85,026
$21,256
$21,256
$21,256
$21,256
$85,026
$25,221
$6,305
$6,305
$6,305
$6,305
$25,221
$26,765
$6,691
$6,691
$6,691
$6,691
$26,765
$4,749
$2,405
$601
$601
$1,145
$4,752
$4,844
$2,453
$613
$613
$1,168
$4,847
$4,941
$2,502
$625
$625
$1,191
$4,944
$5,040
$2,552
$638
$638
$1,215
$5,042
$5,141
$2,603
$651
$651
$1,239
$5,143
$5,243
$2,655
$664
$664
$1,264
$5,246
$5,348
$2,708
$677
$677
$1,289
$5,351
$5,455
$2,762
$691
$691
$1,315
$5,458
$5,564
$2,817
$704
$704
$1,341
$5,567
$5,676
$2,874
$718
$718
$1,368
$5,679
$59,979
$30,369
$7,592
$7,592
$14,456
$60,009
$18,160
$9,195
$2,299
$2,299
$4,377
$18,169
$19,272
$9,758
$2,439
$2,439
$4,645
$19,282
$20,451
$10,355
$2,589
$2,589
$4,929
$20,462
$21,703
$10,989
$2,747
$2,747
$5,231
$21,714
$79,587
$40,297
$10,074
$10,074
$19,181
$79,627
$23,607
$11,953
$2,988
$2,988
$5,690
$23,619
$25,052
$12,685
$3,171
$3,171
$6,038
$25,065
$57,942
$59,436
$62,500
$64,108
$65,767
$67,477
$69,241
$71,062
$72,940
$74,879
$775,770
$242,834
$263,195
$285,668
$310,521
$1,102,218
$346,507
$377,835
2025-2026
3rd Quarter 4th Quarter
TOTAL
$34,056
$34,737
$8,516
$8,516
$8,516
$60,285
$36,140
$36,863
$9,037
$9,037
$9,037
$63,975
$132,528
$135,179
$33,140
$33,140
$33,140
$234,598
$172,280
$175,725
$43,080
$43,080
$43,080
$304,965
$78,122
$82,028
$19,540
$19,540
$19,540
$140,649
$90,436
$94,958
$22,620
$22,620
$22,620
$162,819
$294,339
$309,056
$73,621
$73,621
$73,621
$529,921
$541,806
$568,896
$135,519
$135,519
$135,519
$975,453
$18,058
$18,420
$3,283
$1,642
$0
$23,345
$19,164
$19,547
$3,484
$1,742
$0
$24,774
$70,274
$71,680
$12,777
$6,389
$0
$90,846
$91,353
$93,180
$16,610
$8,305
$0
$118,095
$29,048
$15,492
$3,873
$3,873
$5,818
$29,057
$30,826
$16,441
$4,110
$4,110
$6,174
$30,835
$113,041
$60,289
$15,072
$15,072
$22,642
$113,075
$146,948
$78,372
$19,593
$19,593
$29,433
$146,991
$40,631
$10,160
$10,160
$10,160
$10,160
$40,639
$43,118
$10,782
$10,782
$10,782
$10,782
$43,126
$158,118
$39,537
$39,537
$39,537
$39,537
$158,147
$205,545
$51,396
$51,396
$51,396
$51,396
$205,582
$13,628
$3,407
$3,407
$3,407
$3,407
$13,628
$14,462
$3,615
$3,615
$3,615
$3,615
$14,462
$53,032
$13,258
$13,258
$13,258
$13,258
$53,032
$68,938
$17,235
$17,235
$17,235
$17,235
$68,938
$17,214
$13,771
$3,443
$0
$18,267
$14,614
$3,653
$0
$66,987
$53,590
$13,397
$0
$87,080
$69,664
$17,416
$0
$0
$17,214
$0
$18,267
$0
$66,987
$0
$87,080
$32,852
$18,001
$4,512
$4,512
$5,832
$32,858
$34,863
$19,103
$4,789
$4,789
$6,189
$34,870
$127,845
$70,052
$17,560
$17,560
$22,697
$127,869
$166,192
$91,064
$22,827
$22,827
$29,505
$166,222
$28,403
$7,101
$7,101
$7,101
$7,101
$28,403
$30,141
$7,535
$7,535
$7,535
$7,535
$30,141
$110,529
$27,632
$27,632
$27,632
$27,632
$110,529
$143,682
$35,921
$35,921
$35,921
$35,921
$143,682
$26,586
$13,461
$3,365
$3,365
$6,408
$26,599
$28,213
$14,285
$3,571
$3,571
$6,800
$28,227
$103,459
$52,384
$13,096
$13,096
$24,935
$103,511
$134,491
$68,097
$17,024
$17,024
$32,414
$134,559
$412,676
$451,496
$1,588,514
$2,351,569
Capital Purchases
Capital Purchases
Item
10/1/2021
Purchase
Date
Cost
Facilities
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Equipment
Coffee maker
Oven
Oven
Milk Frother
Milk Frother
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Years of
Service
Salvage
Value
Reminder: All purchases must be on or after your business start date of:
October-2021
Month
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Year
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
1
1
1
1
1
1
1
1
1
1
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$255
$400
$400
$50
$50
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Oct
Oct
Oct
Oct
Oct
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
2021
2021
2021
2021
2021
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
5
5
5
5
5
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
$50
$50
$50
$5
$5
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$1,400
$1,400
$1,400
$3,000
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Oct
Oct
Oct
Oct
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
2021
2021
2021
2021
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
5
5
5
5
1
1
1
1
1
1
1
1
1
1
1
$300
$300
$300
$1,500
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Telecommunications
Phone
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
$100
$0
$0
$0
$0
Oct
Jan
Jan
Jan
Jan
2021
2017
2017
2017
2017
5
1
1
1
1
$100
$0
$0
$0
$0
Land
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
Computer
Computer
Computer
Computer
Softtware
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Item Name (change name here)
Land is a
non-depreciable
asset
Staffing Budget
Staffing Budget
2021-2022
October
November
December
January
February
March
April
Management
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
1.0
$3,500
$417
$525
$4,442
1.0
$3,500
$417
$525
$4,442
1.0
$3,500
$417
$525
$4,442
1.0
$3,500
$417
$525
$4,442
1.0
$3,500
$417
$525
$4,442
1.0
$3,500
$417
$525
$4,442
2.0
$3,500
$833
$1,050
$8,883
Administrative/Support
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
Sales/Marketing
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
0.0
$2,800
$0
$0
$0
0.0
$2,800
$0
$0
$0
0.0
$2,800
$0
$0
$0
0.0
$2,800
$0
$0
$0
0.0
$2,800
$0
$0
$0
0.0
$2,800
$0
$0
$0
0.0
$2,800
$0
$0
$0
Operations/Production
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
2.0
$2,500
$833
$750
$6,583
2.0
$2,500
$833
$750
$6,583
2.0
$2,500
$833
$750
$6,583
2.0
$2,500
$833
$750
$6,583
2.0
$2,500
$833
$750
$6,583
2.0
$2,500
$833
$750
$6,583
2.0
$2,500
$833
$750
$6,583
Other
Staffing Budget
# Salaried Employees
Avg Salary per employee
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
Part-Time / Hourly Employees
# Part-Time Employees
Avg. Hours per Hourly Employee
Avg Hourly Rate
Calculated Wages Per Hourly Employee
Wages
Benefits (across all employees)
Payroll Taxes (across all employees)
Total Costs
TOTAL
# Full Time Employees
# Part-Time Employees
Salary/Wages
Benefits
Payroll Taxes
GRAND TOTAL COSTS
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
1
20
$15.00
$300
$300
$100
$45
$445
1
20
$15.00
$300
$300
$100
$45
$445
1
20
$15.00
$300
$300
$100
$45
$445
1
20
$15.00
$300
$300
$100
$45
$445
1
20
$15.00
$300
$300
$100
$45
$445
1
20
$15.00
$300
$300
$100
$45
$445
2
20
$15.00
$300
$600
$200
$90
$890
$3
$1
$8,800
$1,350
$1,320
$11,470
$3
$1
$8,800
$1,350
$1,320
$11,470
$3
$1
$8,800
$1,350
$1,320
$11,470
$3
$1
$8,800
$1,350
$1,320
$11,470
$3
$1
$8,800
$1,350
$1,320
$11,470
$3
$1
$8,800
$1,350
$1,320
$11,470
$4
$2
$12,600
$1,867
$1,890
$16,357
Staffing Budget
May
June
July
August
September
TOTAL
2.0
$3,500
$833
$1,050
$8,883
2.0
$3,500
$833
$1,050
$8,883
2.0
$3,500
$833
$1,050
$8,883
2.0
$3,500
$833
$1,050
$8,883
2.0
$3,500
$833
$1,050
$8,883
$42,000
$7,500
$9,450
$79,950
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
$0
$0
$0
$0
0.0
$2,800
$0
$0
$0
0.0
$2,800
$0
$0
$0
0.0
$2,800
$0
$0
$0
0.0
$2,800
$0
$0
$0
0.0
$2,800
$0
$0
$0
$33,600
$0
$0
$0
4.0
$2,500
$1,667
$1,500
$13,167
4.0
$2,500
$1,667
$1,500
$13,167
4.0
$2,500
$1,667
$1,500
$13,167
4.0
$2,500
$1,667
$1,500
$13,167
4.0
$2,500
$1,667
$1,500
$13,167
$30,000
$14,167
$12,750
$111,917
Staffing Budget
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
$0
$0
$0
$0
2
20
$15.00
$300
$600
$200
$90
$890
2
20
$15.00
$300
$600
$200
$90
$890
2
20
$15.00
$300
$600
$200
$90
$890
2
20
$15.00
$300
$600
$200
$90
$890
2
20
$15.00
$300
$600
$200
$90
$890
$3,600
$5,400
$1,800
$810
$8,010
$6
$2
$17,600
$2,700
$2,640
$22,940
$6
$2
$17,600
$2,700
$2,640
$22,940
$6
$2
$17,600
$2,700
$2,640
$22,940
$6
$2
$17,600
$2,700
$2,640
$22,940
$6
$2
$17,600
$2,700
$2,640
$22,940
$153,400
$23,467
$23,010
$199,877
Staffing Budget
2022-2023
October
November
December
January
February
March
April
May
June
July
August
2.0
$3,623
$875
$1,087
$9,207
2.0
$3,623
$875
$1,087
$9,207
2.0
$3,623
$875
$1,087
$9,207
2.0
$3,623
$875
$1,087
$9,207
2.0
$3,623
$875
$1,087
$9,207
2.0
$3,623
$875
$1,087
$9,207
2.0
$3,623
$875
$1,087
$9,207
2.0
$3,623
$875
$1,087
$9,207
2.0
$3,623
$875
$1,087
$9,207
2.0
$3,623
$875
$1,087
$9,207
2.0
$3,623
$875
$1,087
$9,207
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$2,898
$0
$0
$0
0.0
$2,898
$0
$0
$0
0.0
$2,898
$0
$0
$0
0.0
$2,898
$0
$0
$0
0.0
$2,898
$0
$0
$0
0.0
$2,898
$0
$0
$0
0.0
$2,898
$0
$0
$0
0.0
$2,898
$0
$0
$0
0.0
$2,898
$0
$0
$0
0.0
$2,898
$0
$0
$0
0.0
$2,898
$0
$0
$0
6.0
$2,588
$2,625
$2,329
$20,479
6.0
$2,588
$2,625
$2,329
$20,479
6.0
$2,588
$2,625
$2,329
$20,479
6.0
$2,588
$2,625
$2,329
$20,479
6.0
$2,588
$2,625
$2,329
$20,479
6.0
$2,588
$2,625
$2,329
$20,479
6.0
$2,588
$2,625
$2,329
$20,479
6.0
$2,588
$2,625
$2,329
$20,479
6.0
$2,588
$2,625
$2,329
$20,479
6.0
$2,588
$2,625
$2,329
$20,479
6.0
$2,588
$2,625
$2,329
$20,479
Staffing Budget
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
2
20
$15.53
$311
$621
$210
$93
$924
2
20
$15.53
$311
$621
$210
$93
$924
2
20
$15.53
$311
$621
$210
$93
$924
2
20
$15.53
$311
$621
$210
$93
$924
2
20
$15.53
$311
$621
$210
$93
$924
2
20
$15.53
$311
$621
$210
$93
$924
2
20
$15.53
$311
$621
$210
$93
$924
2
20
$15.53
$311
$621
$210
$93
$924
2
20
$15.53
$311
$621
$210
$93
$924
2
20
$15.53
$311
$621
$210
$93
$924
2
20
$15.53
$311
$621
$210
$93
$924
$8
$2
$23,391
$3,710
$3,509
$30,610
$8
$2
$23,391
$3,710
$3,509
$30,610
$8
$2
$23,391
$3,710
$3,509
$30,610
$8
$2
$23,391
$3,710
$3,509
$30,610
$8
$2
$23,391
$3,710
$3,509
$30,610
$8
$2
$23,391
$3,710
$3,509
$30,610
$8
$2
$23,391
$3,710
$3,509
$30,610
$8
$2
$23,391
$3,710
$3,509
$30,610
$8
$2
$23,391
$3,710
$3,509
$30,610
$8
$2
$23,391
$3,710
$3,509
$30,610
$8
$2
$23,391
$3,710
$3,509
$30,610
Staffing Budget
2023-2024
September
TOTAL
2024-2025
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
TOTAL
1st Quarter 2nd Quarter 3rd Quarter
2.0
$3,623
$875
$1,087
$9,207
$43,470
$10,500
$13,041
$110,481
2.0
$11,248
$2,756
$3,374
$28,626
2.0
$11,248
$2,756
$3,374
$28,626
2.0
$11,248
$2,756
$3,374
$28,626
2.0
$11,248
$2,756
$3,374
$28,626
$44,991
$11,025
$13,497
$114,505
2.0
$11,642
$2,894
$3,492
$29,670
2.0
$11,642
$2,894
$3,492
$29,670
2.0
$11,642
$2,894
$3,492
$29,670
0.0
$0
$0
$0
$0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$2,898
$0
$0
$0
$34,776
$0
$0
$0
0.0
$8,998
$0
$0
$0
0.0
$8,998
$0
$0
$0
0.0
$8,998
$0
$0
$0
0.0
$8,998
$0
$0
$0
$35,993
$0
$0
$0
0.0
$9,313
$0
$0
$0
0.0
$9,313
$0
$0
$0
0.0
$9,313
$0
$0
$0
$31,050
$31,500
$27,945
$245,745
6.0
$8,034
$8,269
$7,231
$63,705
6.0
$8,034
$8,269
$7,231
$63,705
6.0
$8,034
$8,269
$7,231
$63,705
6.0
$8,034
$8,269
$7,231
$63,705
$32,137
$33,075
$28,923
$254,819
6.0
$8,315
$8,682
$7,484
$66,058
6.0
$8,315
$8,682
$7,484
$66,058
6.0
$8,315
$8,682
$7,484
$66,058
6.0
$2,588
$2,625
$2,329
$20,479
Staffing Budget
0.0
$0
$0
$0
$0
2
20
$15.53
$311
$621
$210
$93
$924
$8
$2
$23,391
$3,710
$3,509
$30,610
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
$3,726
$7,452
$2,520
$1,118
$11,090
2
60
$16.07
$964
$1,928
$662
$289
$2,879
2
60
$16.07
$964
$1,928
$662
$289
$2,879
2
60
$16.07
$964
$1,928
$662
$289
$2,879
2
60
$16.07
$964
$1,928
$662
$289
$2,879
$280,692
$44,520
$42,104
$367,316
$8
$2
$72,629
$11,687
$10,894
$95,210
$8
$2
$72,629
$11,687
$10,894
$95,210
$8
$2
$72,629
$11,687
$10,894
$95,210
$8
$2
$72,629
$11,687
$10,894
$95,210
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
$3,856
$7,713
$2,646
$1,157
$11,516
2
60
$16.63
$998
$1,996
$695
$299
$2,990
2
60
$16.63
$998
$1,996
$695
$299
$2,990
2
60
$16.63
$998
$1,996
$695
$299
$2,990
$290,516
$46,746
$43,577
$380,840
$8
$2
$75,171
$12,271
$11,276
$98,718
$8
$2
$75,171
$12,271
$11,276
$98,718
$8
$2
$75,171
$12,271
$11,276
$98,718
Staffing Budget
2025-2026
4th Quarter
TOTAL
TOTAL
2.0
$11,642
$2,894
$3,492
$29,670
$46,566
$11,576
$13,970
$118,678
2.0
$48,196
$12,155
$14,459
$123,006
0.0
$0
$0
$0
$0
$0
$0
$0
$0
0.0
$0
$0
$0
$0
0.0
$9,313
$0
$0
$0
$37,253
$0
$0
$0
0.0
$38,557
$0
$0
$0
$33,262
$34,729
$29,935
$264,233
6.0
$34,426
$36,465
$30,983
$274,002
6.0
$8,315
$8,682
$7,484
$66,058
Staffing Budget
0.0
$0
$0
$0
$0
2
60
$16.63
$998
$1,996
$695
$299
$2,990
$8
$2
$75,171
$12,271
$11,276
$98,718
$0
$0
$0
$0
0.0
$0
$0
$0
$0
$3,991
$7,983
$2,778
$1,197
$11,958
2
240
$17.21
$4,131
$8,262
$2,917
$1,239
$12,419
$300,684
$49,083
$45,103
$394,870
$8
$2
$311,208
$51,537
$46,681
$409,427
Marketing Budget
For a more comprehensive and detailed Marketing Budget, purchase the Excel Marketing Budge
from PlanningShop.
Marketing Budget
2021-2022
October
Professional Assistance
Marketing/PR Consultants
Advertising Agencies
Social Media Specialists
SEO Specialist
Graphic/Web Design
Brochures/Leaflets/Flyers
Signs/Billboards
Merchandising Displays
Sampling/Premiums
Media Advertising
Print (newspaper, etc.)
Television and Radio
Online
Other Media
Phone Directories
Advertising Specialties
Direct Mail
Website
Development/Programming
Maintenance and Hosting
Trade Shows
Fees and Setup
Travel/Shipping
Exhibits/Signs
Public Relations/Materials
Informal Marketing / Networking
Memberships/Meetings
Entertainment
November
December
January
February
March
April
May
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$2,000
$50
$2,000
$50
$0
$50
$0
$50
$0
$50
$0
$50
$0
$50
$0
$50
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Marketing Budget
Other
GRAND TOTAL COSTS
$0
$2,250
$0
$2,250
$0
$250
$0
$250
$0
$250
$0
$250
$0
$250
$0
$250
Marketing Budget
e and detailed Marketing Budget, purchase the Excel Marketing Budget Templates
from PlanningShop.
June
July
August
September
TOTAL
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$2,400
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$50
$0
$50
$0
$50
$0
$50
$4,000
$600
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Marketing Budget
$0
$250
$0
$250
$0
$250
$0
$250
$0
$7,000
Marketing Budget
2022-2023
October
November
December
January
February
March
April
May
June
July
August
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$50
$0
$50
$0
$50
$0
$50
$0
$50
$0
$50
$0
$50
$0
$50
$0
$50
$0
$50
$0
$50
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Marketing Budget
$0
$250
$0
$250
$0
$250
$0
$250
$0
$250
$0
$250
$0
$250
$0
$250
$0
$250
$0
$250
$0
$250
Marketing Budget
2023-2024
September
TOTAL
2024-2025
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
TOTAL
1st Quarter 2nd Quarter 3rd Quarter
$0
$0
$0
$0
$0
$200
$0
$0
$0
$0
$0
$0
$0
$0
$2,400
$0
$0
$0
$0
$0
$0
$0
$0
$600
$0
$0
$0
$0
$0
$0
$0
$0
$600
$0
$0
$0
$0
$0
$0
$0
$0
$600
$0
$0
$0
$0
$0
$0
$0
$0
$600
$0
$0
$0
$0
$0
$0
$0
$0
$2,400
$0
$0
$0
$0
$0
$0
$0
$0
$600
$0
$0
$0
$0
$0
$0
$0
$0
$600
$0
$0
$0
$0
$0
$0
$0
$0
$600
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$50
$0
$600
$0
$150
$0
$150
$0
$150
$0
$150
$0
$600
$0
$150
$0
$150
$0
$150
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Marketing Budget
$0
$250
$0
$3,000
$0
$750
$0
$750
$0
$750
$0
$750
$0
$3,000
$0
$750
$0
$750
$0
$750
Marketing Budget
2025-2026
4th Quarter
TOTAL
$0
$0
$0
$0
$0
$600
$0
$0
$0
$0
$0
$0
$0
$0
$2,400
$0
$0
$0
$0
$0
$0
$0
$0
$2,400
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$150
$0
$600
$0
$600
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
Marketing Budget
$0
$750
$0
$3,000
$0
$3,000
Professional Services Budget
Professional Services
2021-2022
2022-2023
2023-2024
2024-2025
2025-2026
General
Attorneys
Accountants
Management consultants
Industry specialists
Technology consultants
Other (change title here)
Other (change title here)
Total Costs
$3,000
$2,500
$0
$0
$0
$0
$0
$5,500
$3,000
$2,500
$0
$0
$0
$0
$0
$5,500
$3,000
$2,500
$0
$0
$0
$0
$0
$5,500
$3,000
$2,500
$0
$0
$0
$0
$0
$5,500
$3,000
$2,500
$0
$0
$0
$0
$0
$5,500
GRAND TOTAL COSTS
$5,500
$5,500
$5,500
$5,500
$5,500
Capital Investments and Loans
Capital Investments and Loans
Item
Amount
Equity Capital Investments
Alexlrod (angel investor)
Chuc Rhoades (Venture capitalist)
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Investment Source Name
Total Capital Investments
$22,000
$13,000
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$35,000
Loans
Mapesa bank
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Loan Source Name
Total Loans
$20,000
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$20,000
TOTAL INVESTMENTS AND LOANS
$55,000
Date
Loan
Period
Interest
Rate
Month Year
Feb
2022
Mar
2022
Jan
2017
Jan
2017
Jan
2017
Jan
2017
Jan
2017 Capital investments
Jan
2017 are not paid back on a
loan schedule.
Jan
2017
Jan
2017
Jan
2017
Jan
2017
Jan
2017
Jan
2017
Jan
2017
Oct
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
Jan
2021
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
2017
36
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
12
5.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
Capital Investments and Loans
Reminder: All invesments & loans must be on or after your business start date of:
October-2021
Income Statements
Income Statements
Income Statements
2021-2022
October
November
December
January
February
March
April
May
INCOME
Gross Sales
(Commissions)
(Returns and allowances)
Net Sales
(Cost of Goods)
GROSS PROFIT
$32,318
$2,424
$970
$28,924
$16,159
$12,765
$33,055
$2,479
$992
$29,584
$16,527
$13,057
$37,760
$2,832
$1,133
$33,795
$18,880
$14,915
$49,235
$3,693
$1,477
$44,065
$24,618
$19,448
$58,249
$4,369
$1,747
$52,133
$29,124
$23,008
$61,525
$4,614
$1,846
$55,064
$30,762
$24,302
$63,476
$4,761
$1,904
$56,811
$31,738
$25,073
$64,984
$4,874
$1,950
$58,161
$32,492
$25,669
EXPENSES – General and Administrative
Salaries and wages
Employee benefits
Payroll taxes
Professional services
Marketing and advertising
Rent
Equipment rental
Maintenance
Depreciation
Insurance
Telephone service
Utilities
Office supplies
Postage and shipping
Travel
Entertainment
Interest on loans
Other (change title here)
Other (change title here)
TOTAL EXPENSES
Net income before taxes and interest
$8,800
$1,350
$1,320
$458
$2,250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$83
$0
$0
$14,558
-$1,793
$8,800
$1,350
$1,320
$458
$2,250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$81
$0
$0
$14,556
-$1,500
$8,800
$1,350
$1,320
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$79
$0
$0
$12,554
$2,361
$8,800
$1,350
$1,320
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$77
$0
$0
$12,552
$6,896
$8,800
$1,350
$1,320
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$75
$0
$0
$12,550
$10,459
$8,800
$1,350
$1,320
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$72
$0
$0
$12,547
$11,755
$12,600
$1,867
$1,890
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$70
$0
$0
$17,432
$7,641
$17,600
$2,700
$2,640
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$68
$0
$0
$24,013
$1,656
Income Statements
Interest Income
Provision for taxes on income
NET PROFIT
$22
$0
-$1,771
$18
$0
-$1,482
$13
$594
$1,781
$12
$1,727
$5,181
$33
$2,623
$7,868
$45
$2,950
$8,850
$46
$1,922
$5,765
$41
$424
$1,273
Income Statements
Income Statements
2022-2023
June
July
August
September
TOTAL
October
November
December
January
February
March
$66,534
$4,990
$1,996
$59,548
$33,267
$26,281
$68,127
$5,110
$2,044
$60,974
$34,064
$26,910
$69,766
$5,232
$2,093
$62,441
$34,883
$27,558
$69,697
$5,227
$2,091
$62,379
$34,849
$27,530
$674,725
$50,604
$20,242
$603,879
$337,363
$266,516
$87,840
$6,588
$2,635
$78,617
$43,920
$34,697
$92,462.47
$6,934.69
$2,773.87
$82,753.91
$46,231.23
$36,522.68
$94,599
$7,095
$2,838
$84,666
$47,299
$37,366
$98,570
$7,393
$2,957
$88,220
$49,285
$38,935
$102,654
$7,699
$3,080
$91,875
$51,327
$40,548
$105,105
$7,883
$3,153
$94,069
$52,552
$41,516
$17,600
$2,700
$2,640
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$66
$0
$0
$24,011
$2,270
$17,600
$2,700
$2,640
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$64
$0
$0
$24,009
$2,902
$17,600
$2,700
$2,640
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$61
$0
$0
$24,006
$3,551
$17,600
$2,700
$2,640
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$59
$0
$0
$24,004
$3,526
$153,400
$23,467
$23,010
$5,500
$7,000
$2,400
$0
$0
$1,159
$0
$0
$0
$0
$0
$0
$0
$856
$0
$0
$216,792
$49,725
$23,391
$3,710
$3,509
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$57
$0
$0
$31,671
$3,025
$23,391
$3,710
$3,509
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$55
$0
$0
$31,669
$4,853
$23,391
$3,710
$3,509
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$52
$0
$0
$31,667
$5,700
$23,391
$3,710
$3,509
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$50
$0
$0
$31,665
$7,270
$23,391
$3,710
$3,509
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$48
$0
$0
$31,662
$8,886
$23,391
$3,710
$3,509
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$46
$0
$0
$31,660
$9,856
Income Statements
$35
$576
$1,728
$31
$733
$2,199
$27
$895
$2,684
$23
$887
$2,662
$345
$12,431
$37,638
$10
$759
$2,277
$2
$1,214
$3,641
$0
$1,425
$4,275
$0
$1,818
$5,453
$0
$2,221
$6,664
$0
$2,464
$7,392
Income Statements
Income Statements
April
May
June
July
August
September
TOTAL
$107,625
$8,072
$3,229
$96,324
$53,812
$42,512
$110,216
$8,266
$3,306
$98,643
$55,108
$43,535
$112,881
$8,466
$3,386
$101,029
$56,441
$44,588
$115,623
$8,672
$3,469
$103,482
$57,811
$45,671
$118,443
$8,883
$3,553
$106,007
$59,222
$46,785
$121,345
$9,101
$3,640
$108,604
$60,673
$47,931
$1,267,363
$95,052
$38,021
$1,134,290
$633,681
$500,608
$23,391
$3,710
$3,509
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$43
$0
$0
$31,658
$10,854
$23,391
$3,710
$3,509
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$41
$0
$0
$31,655
$11,880
$23,391
$3,710
$3,509
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$39
$0
$0
$31,653
$12,935
$23,391
$3,710
$3,509
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$36
$0
$0
$31,651
$14,020
$23,391
$3,710
$3,509
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$34
$0
$0
$31,648
$15,137
$23,391
$3,710
$3,509
$458
$250
$200
$0
$0
$97
$0
$0
$0
$0
$0
$0
$0
$32
$0
$0
$31,646
$16,285
$280,692
$44,520
$42,104
$5,500
$3,000
$2,400
$0
$0
$1,159
$0
$0
$0
$0
$0
$0
$0
$532
$0
$0
$379,907
$120,702
Income Statements
$0
$2,714
$8,141
$0
$2,970
$8,910
$0
$3,234
$9,701
$0
$3,505
$10,515
$0
$3,784
$11,352
$0
$4,071
$12,214
$12
$30,175
$90,538
Income Statements
Income Statements
2023-2024
2024-2025
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
TOTAL
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
TOTAL
$391,869
$29,390
$11,756
$350,723
$195,935
$154,788
$421,962
$31,647
$12,659
$377,656
$210,981
$166,675
$454,859
$34,114
$13,646
$407,099
$227,430
$179,669
$490,884
$36,816
$14,727
$439,341
$245,442
$193,899
$1,759,574
$131,968
$52,787
$1,574,819
$879,787
$695,032
$543,664
$40,775
$16,310
$486,579
$271,832
$214,747
$588,182
$44,114
$17,645
$526,423
$294,091
$232,332
$637,197
$47,790
$19,116
$570,291
$318,598
$251,693
$691,263
$51,845
$20,738
$618,680
$345,632
$273,049
$2,460,306
$184,523
$73,809
$2,201,974
$1,230,153
$971,821
$72,629
$11,687
$10,894
$1,375
$750
$600
$0
$0
$290
$0
$0
$0
$0
$0
$0
$0
$80
$0
$0
$98,305
$56,483
$72,629
$11,687
$10,894
$1,375
$750
$600
$0
$0
$290
$0
$0
$0
$0
$0
$0
$0
$59
$0
$0
$98,283
$68,391
$72,629
$11,687
$10,894
$1,375
$750
$600
$0
$0
$290
$0
$0
$0
$0
$0
$0
$0
$37
$0
$0
$98,262
$81,408
$72,629
$11,687
$10,894
$1,375
$750
$600
$0
$0
$290
$0
$0
$0
$0
$0
$0
$0
$15
$0
$0
$98,240
$95,660
$290,516
$46,746
$43,577
$5,500
$3,000
$2,400
$0
$0
$1,159
$0
$0
$0
$0
$0
$0
$0
$191
$0
$0
$393,090
$301,942
$75,171
$12,271
$11,276
$1,375
$750
$600
$0
$0
$290
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$101,732
$113,015
$75,171
$12,271
$11,276
$1,375
$750
$600
$0
$0
$290
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$101,732
$130,600
$75,171
$12,271
$11,276
$1,375
$750
$600
$0
$0
$290
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$101,732
$149,960
$75,171
$12,271
$11,276
$1,375
$750
$600
$0
$0
$290
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$101,732
$171,317
$300,684
$49,083
$45,103
$5,500
$3,000
$2,400
$0
$0
$1,159
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$406,929
$564,892
Income Statements
$0
$14,121
$42,363
$0
$17,098
$51,294
$0
$20,352
$61,056
$0
$23,915
$71,745
$0
$75,486
$226,457
$7
$28,256
$84,767
$93
$32,673
$98,020
$201
$37,540
$112,621
$332
$42,912
$128,737
$634
$141,381
$424,144
Income Statements
Income Statements
2025-2026
$3,516,630
$263,747
$105,499
$3,147,384
$1,758,315
$1,389,069
$311,208
$51,537
$46,681
$5,500
$3,000
$2,400
$0
$0
$1,159
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$421,486
$967,583
Income Statements
$4,567
$243,038
$729,113
Cash Flow Statements
Cash Flow
2021-2022
October
CASH RECEIPTS
Income from Sales
Cash Sales
Collections
Total Cash from Sales
Income from Financing
Interest Income
Loan Proceeds
Equity Capital Investments
Total Cash from Financing
Other Cash Receipts
TOTAL CASH RECEIPTS
CASH DISBURSEMENTS
Inventory
Operating Expenses
Commissions/Returns & Allowances
Capital Purchases
Loan Payments
Income Tax Payments
Investor Dividend Payments
Owner’s Draw
TOTAL CASH DISBURSEMENTS
NET CASH FLOW
Opening Cash Balance
Cash Receipts
Cash Disbursements
November
December
January
February
March
April
$24,238
$0
$24,238
$24,791
$8,079
$32,870
$28,320
$8,264
$36,584
$36,926
$9,440
$46,366
$43,687
$12,309
$55,995
$46,143
$14,562
$60,706
$47,607
$15,381
$62,988
$22
$20,000
$0
$20,022
$0
$44,260
$18
$0
$0
$18
$0
$32,888
$13
$0
$0
$13
$0
$36,597
$12
$0
$0
$12
$0
$46,379
$33
$0
$22,000
$22,033
$0
$78,028
$45
$0
$13,000
$13,045
$0
$73,751
$46
$0
$0
$46
$0
$63,034
$16,162
$14,378
$3,393
$8,455
$599
$0
$0
$0
$42,988
$19,038
$14,378
$3,471
$0
$599
$0
$0
$0
$37,487
$22,345
$12,378
$3,965
$0
$599
$3,023
$0
$0
$42,311
$29,397
$12,378
$5,170
$0
$599
$0
$0
$0
$47,544
$34,594
$12,378
$6,116
$0
$599
$0
$0
$0
$53,688
$36,465
$12,378
$6,460
$0
$599
$3,023
$0
$0
$58,926
$37,685
$17,265
$6,665
$0
$599
$0
$0
$0
$62,214
$1,272
-$4,598
-$5,714
-$1,166
$24,340
$14,825
$820
$25,000
$44,260
$42,988
$26,272
$32,888
$37,487
$21,673
$36,597
$42,311
$15,960
$46,379
$47,544
$14,794
$78,028
$53,688
$39,134
$73,751
$58,926
$53,959
$63,034
$62,214
Cash Flow Statements
ENDING CASH BALANCE
$26,272
$21,673
$15,960
$14,794
$39,134
$53,959
$54,778
Cash Flow Statements
2022-2023
May
June
July
August
September
TOTAL
October
November
December
January
$48,738
$15,869
$64,607
$49,900
$16,246
$…
Purchase answer to see full
attachment

  
error: Content is protected !!