Salty Pawz Financial Information

Sales + Revenue

For the last six months, Wanda’s sales have broken down as shown below. She has also provided you with her cost for each variety of treat.

Products/Services % of Sales Sales Price COGS Contribution Profit Margin Weighted Profit Margin
Party Pooch 45% 20.00 10.40 9.60 48.00% 21.60%
Chicken Cuties 18% 15.00 7.80 7.20 48.00% 8.64%
Bison Bites 5% 21.00 10.80 10.20 48.57% 2.43%
Lamb Lovies 32% 24.00 12.60 11.40 47.50% 15.20%
(Must equal 100%) 100% Average profit margin 47.87%
Sales Price COGS
Chicken Cuties 1.25 0.65
Bison Bites 1.75 0.90
Lamb Lovies 2.00 1.05

Cost of Goods Sold

Wanda’s COGS include the packaging, labeling, the ingredients, and the time it takes to make the treats. Since she can bake them in big batches, her labor cost per unit is very low.

When Wanda ships her products, she charges just what it costs her. Shipping is done on a cost recovery basis and currently she doesn’t consider it in her income/expenses.

Monthly Expenses

Currently Wanda’s monthly expenses are:

Rent 0.00
Electricity 0.00
Telephone 100.00
Water/Sewer 0.00
Internet 60.00
Website 175.00
Salaries 0.00
Owner’s Draw 1000.00
Office Supplies 50.00
Loan Payment 0.00
Insurance 85.00
Other 0.00
Total Overhead $1,470.00

Sales Mix

Currently Wanda’s customers purchase her products at the following ratios:

Products/Services % of Sales
Party Pooch 45%
Chicken Cuties 18%
Bison Bites 5%
Lamb Lovies 32%
100%

Break Even Calculation

Based on her current monthly expenses and sales mix, this is what Wanda has to sell in order to break-even:

Products/Services Sales Price COGS Contribution Profit Margin Weighted Profit Margin
Party Pooch 45% 20.00 10.40 9.60 48.00% 21.60%
Chicken Cuties 18% 15.00 7.80 7.20 48.00% 8.64%
Bison Bites 5% 21.00 10.80 10.20 48.57% 2.43%
Lamb Lovies 32% 24.00 12.60 11.40 47.50% 15.20%
(Must equal 100%) 100% Average profit margin: 47.87%
Total Overhead $1,470.00
divided by Average Profit Margin 47.87%
= BREAKEVEN $3,070.91

Average Sales per customer is $20.00

BREAKEVEN Party Pooch Chicken Cuties Bison Bites Lamb Lovies
Monthly In Dollars $3,070.91 $1,381.91 $552.76 $153.55 $982.69
In Units 69 37 7 41

Forecasting Supply and Demand

Wanda is at capacity for production out of her kitchen, so she believes that she is at the maximum income she can generate with her current structure. If Wanda changes her pricing structure, the following quantities demanded and quantities supplied will result.

Chicken Cuties Chicken Cuties Chicken Cuties
Price ($) Demand (Q) Price($) Supply (Q) Price ($) Demand (Q) Supply (Q)
$0.75 1000 $0.75 500 $0.75 1000 500
$1.00 900 $1.00 650 $1.00 900 650
$1.25 800 $1.25 800 $1.25 800 800
$1.75 700 $1.50 1000 $1.50 700 1000
$2.00 600 $1.75 1400 $1.75 600 1400
$2.25 500 $2.00 1500 $2.00 500 1500
Bison Bites Bison Bites Bison Bites
Price ($) Demand (Q)   Price($) Supply (Q)   Price ($) Demand (Q) Supply (Q)
$1.00 1200 $1.00 500 $1.00 1200 500
$1.25 1100 $1.25 600 $1.25 1100 600
$1.50 900 $1.50 700 $1.50 900 700
$1.75 800 $1.75 900 $1.75 800 900
$2.00 700 $2.00 1000 $2.00 700 1000
$2.25 400 $2.25 1400 $2.25 400 1400
Lamb Lovies Lamb Lovies Lamb Lovies
Price ($) Demand (Q)   Price($) Supply (Q)   Price ($) Demand (Q) Supply (Q)
$1.75 1500 $1.75 800 $1.75 1500 800
$2.00 1400 $2.00 900 $2.00 1400 900
$2.25 1200 $2.25 1000 $2.25 1200 1000
$2.50 1000 $2.50 1200 $2.50 1000 1200
$2.75 800 $2.75 1400 $2.75 800 1400
$3.00 700 $3.00 1600 $3.00 700 1600
Party Pooch Party Pooch Party Pooch
Price ($) Demand (Q)   Price($) Supply (Q)   Price ($) Demand (Q) Supply (Q)
$16.00 1400 $16.00 600 $16.00 1400 600
$18.00 1200 $18.00 700 $18.00 1200 700
$20.00 1100 $20.00 800 $20.00 1100 800
$22.00 1000 $22.00 1000 $22.00 1000 1000
$24.00 900 $24.00 1200 $24.00 900 1200
$26.00 800 $26.00 1400 $26.00 800 1400

Income Information

Here is a summary of Wanda’s Salty Pawz income information for the past 6 months.

INCOME:
Party Pooch $                 40,500.00
Chicken Cuties $                 16,200.00
Bison Bites $                   4,515.00
Lamb Lovies $                 28,800.00
TOTAL INCOME: $                 90,015.00
COST OF GOODS SOLD:
Party Pooch $                 21,060.00
Chicken Cuties $                   8,424.00
Bison Bites $                   4,515.00
Canine Craving $                 15,120.00
Total cost of sales $                 49,119.00
GROSS PROFIT $                 40,896.00
OPERATING EXPENSES:
Rent $                            –
Electricity $                            –
Telephone $                      600.00
Water /Sewer $                            –
Internet $                      360.00
Website $                   1,050.00
Salaries $                            –
Owner’s Draw $                   6,000.00
Office Supplies $                      300.00
Loan Payment $                            –
Insurance $                      510.00
Other $                            –
TOTAL EXPENSES $                   8,820.00
NET INCOME
BEFORE TAXES $                 32,076.00