View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default Month calculation from cost for a business plan - please help

Before you can determine the break even point (point at which income meets
expenses), you are going to have to determine the selling price of each piece.

The cost of the piece must account for all expenses incurred to acquire it.
Some, but not all of these costs will be:
employee salaries
cost of employee benefits (insurance, 401K, training, paid off-time, etc)
cost of utilities (gas, electricity, phone, water, sewer, internet service)
cost of rent, insurance, delivery vehicles (and their upkeep, licensing,
insurance, etc)
cost of storage of the pieces if that's not included as part of the rent.

Personally, my recommendation at this point is to find a reasonably priced
CPA and take your business plan to him, be prepared to provide information
about those costs I've mentioned and probably some I haven't. Pay him/her to
assist you in coming up with the numbers you need - ask him to also provide
the formulas to calculate those values: with those formulas you can set up an
Excel workbook to repeat the process and update it with time.

"Juergen L" wrote:

hello all

i have to prepare a cost calculation but i stock
following variable are the

- normal employees / cost per month
- special employees / cost per month and commission
- Material per 13000 peaces is 1000 dollar
- electricity and gas 2000 doller per 13000 peaces
- rent 3000 dollar / month

how can i prepare a calculation based on the 13000 peaces. the products will
sold always more and more and more. i need to see how many peaces i have to
sell to get the expenses in and when starts the business.

i really stock in that case how i can material cost calculating
how many times i have to sell 13000 peaces to get the cost down

the first week the sales person should/must sell following table
after 3 days - 1000 peaces / per day
after 6 days - 2000 peases / per day
after 15 days - 3000 peases / per day
end of the month i want to sell 5000 peaces per day
(i am the boss and that is my privilege to sett limits for the sales peoples
;-) )

i need for that use a grafik

additional infos: this is a product which the people buy always. As example:
Shop A buy every day 200 peaces, Shop B every day 500 Peaces and so on

thx to all
Juergen