Who is good at making spread sheets?

[devo]

What I am looking for is a spread sheet (Microsoft Excel) that you can input the cost of what ever you are making such as sausage. Inputting the cost of the meat, casings, spices and your time for making them and adding say ten percent on top so that people who buy from you are getting a fair price.
So basically it would be X-amount of ingredients at a cost of X and you are buying X-amount of finished product so you will be paying X-amount of money.
Am I asking to much for Christmas?  ;D
I know grocery stores use something like this on their scales and it prints out the amount you owe. So if you know how to do this or a software that can do this please let me know.
Thanks

[oakville smoker]

Devo

just use Excel.   List all the things you buy and what you pay for them
Then add a quick formula to multiply the  total by whatever mark up
Dont forget that your meat loses wieght as it cooks, it takes hydro to power your smoker
Plus wrapping and packaging and all that stuff

Hope that helps

[Keymaster]

I made one and got it to total all the ingrediants costs but could not figure out how to add 10% to the total. I'll try again if no one produces a working model. :) I use excel all the time but don't use formulas much. Also when you send someone a excel spreadsheet the macros show up kind of weird like viruses nd it will ask you to if you really want to open it. :o

[Tiny Tim]

Key - adding the 10% is pretty easy.  If you just have a standard straight line addition of a column, the formula in the total line should be similar to =sum(c3:c15)*110%

You can also total the column, then figure your profit separately by having cell c17 have the =sum(c3:c15) then in C18 do your profit with =sum(c17*10%), followed by Cell C20 giving the total =sum(c17+C18).

[Keymaster]

Key - adding the 10% is pretty easy.  If you just have a standard straight line addition of a column, the formula in the total line should be similar to =sum(c3:c15)*110%

Thanks for the tip but sounds like you could easily do this for our friend Devo. I took a couple basic classes on excel back in 2002 and have just muddled along through life since :)  I will try to use your info Tim and see what happens later. Thank you :)

[Tiny Tim]

I don't have enough confidence in myself to take on the project, although I did write basically every spreadsheet the City used when Dad was the City Clerk here.  Pretty much self taught in it, but did have a couple people help on some of my early formulas.

[GusRobin]

Devo, what version of excel you using. I can put something together but it will be very somple, not too sophisticated but will do the job.

[GusRobin]

Devo, sent you a PM

[devo]

Thanks Gus the PM is sent back.
I have excel 2010 if that matters.
thanks

[Sailor]

When you are in the food business they say you need to have your sell price at 1/3 cost of product, 1/3 overhead and 1/3 profit.

[Keymaster]

Key - adding the 10% is pretty easy.  If you just have a standard straight line addition of a column, the formula in the total line should be similar to =sum(c3:c15)*110%

You can also total the column, then figure your profit separately by having cell c17 have the =sum(c3:c15) then in C18 do your profit with =sum(c17*10%), followed by Cell C20 giving the total =sum(c17+C18).

Thanks Tim, That worked really good. I like it when I learn something new.

[devo]

Thanks to every one who has replied and sent off a spread sheet. I missed excel 101 so all your help is appreciated.
Merry Christmas