View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Juergen L Juergen L is offline
external usenet poster
 
Posts: 1
Default Month calculation from cost for a business plan - please help

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