Cost per cake - Can someone check my maths on this?

[Nathanial Essex]

Hi all

I built an Excel spreadsheet to calculate the cost per cake for a business I am doing. I am by no means a maths person, worst subject at school, so thought I would double check before I took it as gospel.

Step 1

What I first did was list out all my ingredients and their cost and size (by grams as purchased in the store)

Ingredients	Size	Cost
Flour	1500	£0.80
Butter	250	£1.80
Caster Sugar	1000	£1.60
Brown Sugar	1000	£2.30
Chocolate	200	£1.50
Cinnamon	39	£0.99

Step 2

I then listed my ingredients by the amount of it takes to make one batch.

Chocolate Chip	Usage
Flour	250
Butter	200
Caster Sugar	62.5
Brown Sugar	62.5
Cinnamon	6.25
Chocolate	11

Step 3

I used flour initially to figure out how many batches 1 packets produces. 1500g of flour produces 6 batches as I use 250 grams per batch. I then calculated how much of the other ingredients I need to create 6 batches.

6 Batches	Quantity	Batches Created	How many packages needed
Flour	1500	6	1
Butter	1200	6	5
Caster Sugar	375	6	0.4
Brown Sugar	375	6	0.4
Chocolate	66	6	0.3
Cinnamon	37.5	6	1

I then multiplied the amount of packages needed by the cost of each package and got the below.

Flour	£0.80​
Butter	£8.64​
Caster Sugar	£0.60​
Brown Sugar	£0.86​
Chocolate	£0.50​
Cinnamon	£0.95​

The total for the above £12.35.
Each batch creates 9 cakes
6 (batches) x 9 (cakes) =54
£12.35 / 54 = £0.23
So my cost per cake is 23p

Make sense?