This is all the information needed to solve the questions.
Salty Pawz J A Case Studyr in Businesd Salty Pawz Marketing: Products: Product. Wanda sells three varieties of dog treats: Chicken Cuties, Bison Bites and Lamb Lovies. Each treat comes in a plastic pouch containing 12 treats. She has the following assortments available: Party Pooch = 4 each of 3 avors Chicken Cutie s= 12 Chicken Bison Bites = 12 Bison Lamb Lovies = 12 Lamb 0000 SaltyPawz Commitment to Healthy Ibgs Since the very beginning, Wanda has been committed to providing a healthy alternative to mass produced dog treats. Consequently, she has been very careful about sourcing her ingredients. The chicken she uses in the Chicken Cuties is from free-range chickens that are fed no artificial growth hormones or antibiotics. It took her a while, but she was able to find several ranchers who raise lamb and bison in an environment where they are fed only non-GMO grains. She does not add preservatives, dyes or fillers to her treats. Pricin gi Wanda has priced her treats on what would be considered the \"high\" end of the market. She detemnined her price based on her costs and what she wants to earn every month. Although she pays attention to what other businesses are charging, she has never conducted any research to detemnine how she stacks up against the competition. She is selling as many treats as she and her friends can make, so price is not something she is concerned about at this time. Place: Salty Pawz products are sold via the Internet and all of Wanda's business is conducted through some form of e-commerce. She has her treats listed on www.etsy.com where they are one of a large variety of treats available. Her brother-in-law recently latmched her website using Webley and she is still getting used to managing the site. In reality, when she gets a \"sale\" through her web site she is sending the customers to etsy to complete the purchase. When she told Jim this he asked her \"aren't you afraid that when your customers get to etsy they will find someone else's treats and buy them instead?\" Wanda just scratched her head. Prom otion: Salty Pawz does not have marketing materials, does no promotions or advertising. Wanda thinks it might be a good idea, but currently she relies on word of mouth to advertise her business. She Authored by Linda Williams and Lumen Learning. CC-BY. 7 V Salty Pawz Financial Information: Sales + Revenue: For the last 6 months, Wanda's sales have broken down as shown below. She has also provided you with her cost for each variety of treat. Weighted Profit Profit Products/Services % of Sales Sales Price COGS Contribution Margin Margin Party Pooch 45% 20.00 10.40 9.60 18.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% Average profit (Must equal 100%) 100% margin: 47.87% Sales Price COGS Chicken Cuties 1.25 0.65 Bison Bites 1.75 0.90 Lamb Lov 2.00 1.05 Authored by Linda Williams and Lumen Learning. CC-BY. Salty Pawz A Case Study in Business 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: Expenses Cost in USD Rent 0.00 Electricity 0.00 Telephone 100.00 Water / Sewer ).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.00Assignment: Bison is Biting into Wanda's Break-Even Point Wanda has analyzed her sales figures and decided that she is charging too much for Bison Bites because they only represent 5% of her total income. She has a good profit margin on them, so she believes she can reduce the price by $0.25 per biscuit and still make this product profitable. She comes to you with this proposal as well as a few related questions. She has provided you with income and expense information to help you figure this out and tell her what she should do. An Excel spreadsheet with financial information needed to complete this assignment has been provided Your Task Help Wanda answer the following questions. 1. What effect will this price reduction have on Salty Pawz's breakeven point? Assume that the product sales mix remains unchanged. (Tip: Re- member that because Bison Bites are included in the Party Pooch, the price change on Bison Bites would also af- fect the sales price of the Party Pooch) 2. If Wanda reduces the price on the Bi son Bites to $1.50, she believes it will cause customers buying Chicken Cuties to switch to the Bison Bites. The revised product mix is provided in the table below. What is the effect on Wanda's break-even point ifshe reduces the bison product price and customers buy more Bison Bites and fewer Chicken Cuties? (Tip: Remem ber that because Bison Bites are in- cluded in the Party Pooch, the price change on Bison Bites would also af- fect the sales price of the Party Pooch.) 3. In addition to the numbers, provide Wanda a written explanation of the changes to her break-even point un- der both of the scenarios presented. Products/Services % of Sales Party Pooch 45% Chicken Cuties 13% Bison Bites 10% Lamb Lovies 32%15.1 Break... 15.1 Break... + What effect will a $0.25 price reduction in Bison Bites have on Salty Pawz's break-even point? Assume that the product sales mix remains unchanged. 1 2 Income Statement F Based on 14,000 units sold 1 Current Price Reduced Price i INCOME: i Party Pooch lChicken Cuties i Bison Bites 1 Lamb Lovies TOTAL INCOME: _| O _| _| 15.1 Break... 15.1 Break... + A B C 12 COST OF GOODS SOLD: D E F G H 13 Party Pooch 14 Chicken Cuties 15 Bison Bites 16 Lamb Lovies 17 Total cost of sales 18 19 GROSS PROFIT 20 21 OPERATING EXPENSES: 22 Rent 23 Electricity 24 Telephone 25 Water /Sewer25 27. 23 29 30 3_1 Q g g g g g g 15.1 Break... 2 15.1 Break... Internet Website Salaries Owner's Draw Office Supplies Loan Payment Insurance Other + TOTAL EXPENSES NET INCOME BEFORE TAXES 15.1 Break... 15.1 Break... + A B C D E F G H What effect will a $0.25 price reduction in Bison Bites have on Salty Pawz's break-even point? Assume that the product sales mix changes as shown in Table 1. 2 Income Statement Table 1. 3 Based on 14,000 units sold Party Pooch 45% Price & Mix Chang 4 Current Price e Change Chicken Cuties 13% 5 INCOME: Bison Bites 10% 6 Party Pooch Lamb Lovies 32% 7 Chicken Cuties 8 Bison Bites 9 Lamb Lovies 10 TOTAL INCOME:15.1 Break... 15.1 Break... + A B C D E F G H I 12 COST OF GOODS SOLD: 13 Party Pooch 14 Chicken Cuties 15 Bison Bites 16 Lamb Lovies 17 Total cost of sales BL 19 GROSS PROFIT 20 21 OPERATING EXPENSES: 22 Rent 23 Electricity 24 Telephone 25 Water /Sewer15.1 Break... 15.1 Break... + A B C D E 26 Internet F G H 27 Website 28 Salaries 29 Owner's Draw 30 Office Supplies 31 Loan Payment 32 Insurance 33 Other 34 TOTAL EXPENSES 35 36 NET INCOME 37 BEFORE TAXES 38 39 40