Answered step by step
Verified Expert Solution
Link Copied!

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.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Online Auditing Tool Towards A Generic Approach To Audit Business Processes Of An Information System On The Fly

Authors: Bhawna Mallic, Kopal Gakkhar

1st Edition

3838395115, 978-3838395111

More Books

Students also viewed these Accounting questions

Question

6. Describe why communication is vital to everyone

Answered: 1 week ago