Answered step by step
Verified Expert Solution
Question
1 Approved Answer
With this information below, Create a balance sheet for an online-based bakery for a sole proprietorship. Average number of items sold in a month/year Cakes:
With this information below, Create a balance sheet for an online-based bakery for a sole proprietorship.
Average number of items sold in a month/year Cakes: month- 72 , year- 864 Cupcake packs: 80 month, 960 year Cupcake Singles: 64 month, 768 year Donut packs: 32 month, 384 year Donut Singles: 48 month, 576 a year Cookies packs: 32 month, 384 year Cookie single: 48 month, 576 year Treat bag: 64 month, 786 year 440 a month, 5280 year 60% : 264 month, 3,168 year delivery- +$5 40% pick-up \begin{tabular}{|l|r|} \hline Ingredients List & Price \\ \hline Ont Flour (2lb) & $6.99 \\ \hline Uakweetened almond milk (gallon) & $7.99 \\ \hline Oats (2 lb bagder (1 lb) & $3.49 \\ \hline Honey (32oz) & $4.00 \\ \hline Peanut butter (non-toxic 16oz) & $11.99 \\ \hline Coconut oil (32 oz) & $3.00 \\ \hline Strawberries ( 2lb container) & $11.99 \\ \hline Pumpkin Puree (15oz) & $4.99 \\ \hline Carob powder (1.5 lb bag) & $2.00 \\ \hline Carrots ( 5lb bag) & $8.99 \\ \hline Natural spices (cinnamon 2.5oz) & $3.99 \\ \hline 24 count eggs & $2.50 \\ \hline Cottage Cheese (32 oz container) & $3.49 \\ \hline Unsalted butter 2lbs & $5.99 \\ \hline Beet powder 1.5lbbag & $6.00 \\ \hline Turmeric powder 1.5lb bag & $8.99 \\ \hline Total & $8.99 \\ \hline For the Month & $105.38 \\ \hline For the Year & $421.52 \\ \hline \end{tabular} How many sales approximately per week: Cakes- 18 x profit x 4 weeks x 12 months: 12,766.04 Cupcakes- 20- 4 packs, 16 individuals: packs: 13,948.8, each: 1,909.32 Donuts- 88 packs, 12 individual: packs: 3,483.88 each: 1,589.76 Cookies 12,8 packs: 4,896 , each: 1,278.72 Bag of treats- 16 profit 4 weeks 12 months 6.33:4,861.44 =43,243.96 Plus $5 delivery fee for 60% of orders: 264 month, 3,168 year delivery =15,840 more profit a year, 1320 month =59,083.96 Income Statement \begin{tabular}{|l|r|} \hline Sales Revenue & $59,083.96 \\ \hline Costs of Goods Sold & $5,058.24 \\ \hline Gross Profit & $54,025.72 \\ \hline Expenses & \\ \hline Business License & $100.00 \\ \hline Food Handler & $27.00 \\ Buisness Bank & $500.00 \\ \hline Marketing & $300.00 \\ \hline Salary (40\%) & $23,633.58 \\ \hline Payroll Tax & $3,339.32 \\ \hline Insurance & $510.00 \\ \hline Notal Expenses & $28,409.90 \\ \hline Net Profit & $25,615.82 \end{tabular} \begin{tabular}{l|r|r} \hline Equipment/Fixures & Price per month & Price per year \\ \hline Oven (Gas Bill) & $50.00 & $600.00 \\ \hline Mixers (Own) & $0.00 & $0.00 \\ \hline Packaging (Treats) & $18.74 & $224.88 \\ \hline Packaging (Cakes) & $29.04 & $348.38 \\ \hline Packaging (Cupcakes & 67.65 (6 months) & $135.30 \\ \hline Packaging (Donuts/Cookies) & $58.42 & $701.04 \\ \hline Label & N/A & $120.60 \\ \hline Single Packaging Bags & 58.45 (6 months) & $116.90 \\ \hline Piping bags (5) & & $19.95 \\ \hline Nozzles (5) & & $5.00 \\ \hline Refrigerator (Electricity Bill) & $20.00 & $240.00 \\ \hline Cake Display Stand (3) & & $60.00 \\ \hline Total & $302.30 & $2,572.05 \\ \hline \end{tabular} Average number of items sold in a month/year Cakes: month- 72 , year- 864 Cupcake packs: 80 month, 960 year Cupcake Singles: 64 month, 768 year Donut packs: 32 month, 384 year Donut Singles: 48 month, 576 a year Cookies packs: 32 month, 384 year Cookie single: 48 month, 576 year Treat bag: 64 month, 786 year 440 a month, 5280 year 60% : 264 month, 3,168 year delivery- +$5 40% pick-up \begin{tabular}{|l|r|} \hline Ingredients List & Price \\ \hline Ont Flour (2lb) & $6.99 \\ \hline Uakweetened almond milk (gallon) & $7.99 \\ \hline Oats (2 lb bagder (1 lb) & $3.49 \\ \hline Honey (32oz) & $4.00 \\ \hline Peanut butter (non-toxic 16oz) & $11.99 \\ \hline Coconut oil (32 oz) & $3.00 \\ \hline Strawberries ( 2lb container) & $11.99 \\ \hline Pumpkin Puree (15oz) & $4.99 \\ \hline Carob powder (1.5 lb bag) & $2.00 \\ \hline Carrots ( 5lb bag) & $8.99 \\ \hline Natural spices (cinnamon 2.5oz) & $3.99 \\ \hline 24 count eggs & $2.50 \\ \hline Cottage Cheese (32 oz container) & $3.49 \\ \hline Unsalted butter 2lbs & $5.99 \\ \hline Beet powder 1.5lbbag & $6.00 \\ \hline Turmeric powder 1.5lb bag & $8.99 \\ \hline Total & $8.99 \\ \hline For the Month & $105.38 \\ \hline For the Year & $421.52 \\ \hline \end{tabular} How many sales approximately per week: Cakes- 18 x profit x 4 weeks x 12 months: 12,766.04 Cupcakes- 20- 4 packs, 16 individuals: packs: 13,948.8, each: 1,909.32 Donuts- 88 packs, 12 individual: packs: 3,483.88 each: 1,589.76 Cookies 12,8 packs: 4,896 , each: 1,278.72 Bag of treats- 16 profit 4 weeks 12 months 6.33:4,861.44 =43,243.96 Plus $5 delivery fee for 60% of orders: 264 month, 3,168 year delivery =15,840 more profit a year, 1320 month =59,083.96 Income Statement \begin{tabular}{|l|r|} \hline Sales Revenue & $59,083.96 \\ \hline Costs of Goods Sold & $5,058.24 \\ \hline Gross Profit & $54,025.72 \\ \hline Expenses & \\ \hline Business License & $100.00 \\ \hline Food Handler & $27.00 \\ Buisness Bank & $500.00 \\ \hline Marketing & $300.00 \\ \hline Salary (40\%) & $23,633.58 \\ \hline Payroll Tax & $3,339.32 \\ \hline Insurance & $510.00 \\ \hline Notal Expenses & $28,409.90 \\ \hline Net Profit & $25,615.82 \end{tabular} \begin{tabular}{l|r|r} \hline Equipment/Fixures & Price per month & Price per year \\ \hline Oven (Gas Bill) & $50.00 & $600.00 \\ \hline Mixers (Own) & $0.00 & $0.00 \\ \hline Packaging (Treats) & $18.74 & $224.88 \\ \hline Packaging (Cakes) & $29.04 & $348.38 \\ \hline Packaging (Cupcakes & 67.65 (6 months) & $135.30 \\ \hline Packaging (Donuts/Cookies) & $58.42 & $701.04 \\ \hline Label & N/A & $120.60 \\ \hline Single Packaging Bags & 58.45 (6 months) & $116.90 \\ \hline Piping bags (5) & & $19.95 \\ \hline Nozzles (5) & & $5.00 \\ \hline Refrigerator (Electricity Bill) & $20.00 & $240.00 \\ \hline Cake Display Stand (3) & & $60.00 \\ \hline Total & $302.30 & $2,572.05 \\ \hline \end{tabular} Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started