Question

Create a balance sheet for the period ending May 15, 2018 from the information below.

Catherine’s Cookies

In August, 2017, Cathy asked her mom to loan her $100 for baking supplies (ingredients, bowls, cookie cutters, and baking sheets). Turns out, she only spent $43.71 at Safeway for ingredients and $34.53 at Walmart for tools.


She and her friends made 10 dozen treats:
-5 dozen were peanut butter/sold for $6.50/dozen.
-4 dozen were chocolate chip/ sold for $7.25/dozen
-1 dozen were birthday cookies/ sold for $2.50/each.

AFTER first years success in August 2017, Cathy decided to set up a stand in early May of 2018. The market manager charged Cathy $30 for a table for the day (plus registration fee of $15) in May, 2018.

Cathy and her friend Steven and Elisha worked for her all week and made $10/hr each. They all spent a total of 27 hrs baking for the weekend.

Cathy made an additional purchase for ingredient for this round of baking. She bought 15 pounds of whole wheat flower. 8 pounds of peanut butter, 9 ilbs of Apple sauce, 32 ounces of liquids, 40 ounces of baking soda, 4.5 ilbs of chocolate chips, 72 ounces of oats, 5.5 ilbs of pumpkin purée, 48 ounces of vegetable oil, 3 dozen eggs, 10 ilbs of carrots, and 6 pounds of cream cheese. The Winco bill was $178.20, she used up all ingredients she purchased to make cookies.

Her and her friends made:
-36 dozen peanut butter cookies
-72 dozen chocolate chip cookies
-144 individual birthday treats
-and 1,000 cranberry cookies to be sold in packages of 50 ( a new addition)

Cathy buys goody bags to put cookies in, $7.69 for 100 bags on amazon. She bought 300 bags.

On market day, Cathy used a table from her mom. Which was topped with a cloth from Amazon for $8.70. She stitched embroidery floss on it from Joannes which costed $2.98. As well as some baskets to display products, which came out to $5.00 at the dolllar store.

By 9am, she sold $100 worth of cookies. She’s sold most of what she brought. the duck/cranberry treats sold for $6.00 for a package of 50.
She sold half of what she brought:
- She had 10 packages left over at the end of the day.
- She sold 28 dozen peanut butter cookies
- She sold 60 dozen chocolate cookies
- She sold 135 individual birthday treats.
- Making the total sales $1,014.50

3 customers return one individual birthday treat.

IMPORTANT: For Ending Inventory, use the amount of $146.09. The explanation for this calculation will be covered in the live session on the case.

Answer 1

Balance Sheet As at May 15,2018
	($)
Assets
Current Assets:
Cash	289.81
Inventories	146.09
Total Current Asset	435.09
Total Assets	435.09
Liabilities & Equity
Non-current Liabilities:
Loan	100
Total Non-current Liabilities	100
Equity:
Revenue from operation	335.90
Total Liabilities & Equity	435.09

Workings:

Cash A/c
	Dr. ($)		Cr. ($)
To Loan	100	By Purchase	43.71
To Sales – Peanut Butter{5*6.50}	32.50	By Tools	34.53
Chocolate chip{4*7.25}	29	By Registration fee	15
Birthday cookies{1*2.50}	2.50	By Table Reservation	30
To Sales – Peanut Butter{28*6.50}	182	By Wages {27*10}	540
Chocolate chip{60*7.25}	435	By Purchase	178.20
Birthday cookies{135*2.50}	337.50	By Goody bags {7.69*300/100}	23.07
duck/cranberry{10*6}	60	By Table cloth	8.70
		By Stitching cost	2.98
		By Baskets	5
		By Sale return {3*2.50}	7.50
		By Balance c/d	289.81
Total	1178.50	Total	1178.50

Statement of Operation
	($)	($)
Revenue:
Sales	1078.50
Less: Sales Return	(7.50)	1071.00
Cost of Revenue:
Purchase	221.91
Less: Closing inventories	(146.09)	75.82
Gross Profit		995.18
Operating Expenses-
a) Tools	34.53
b) Registration fee	15
c) Table Reservation	30
d) Wages	540
e) Goody bags	23.07
f) Table cloth	8.70
g) Stitching cost	2.98
h) Baskets	5	659.28
Income from Operation		335.90