LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A sample of cost WBS for seting up a new business please? VuongBui Excel Discussion (Misc queries) 0 January 24th 07 06:31 PM
TV station business plan MJ Excel Worksheet Functions 0 August 9th 05 01:46 PM
How do I set up a 3 year business plan for a new company justific jojeve Setting up and Configuration of Excel 1 July 10th 05 11:10 AM
looking for a business plan form Deano Excel Discussion (Misc queries) 1 June 7th 05 08:22 PM
Anyne have a template for a start-up business plan? dbb Excel Discussion (Misc queries) 0 May 30th 05 11:35 PM


All times are GMT +1. The time now is 11:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"