Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A sample of cost WBS for seting up a new business please? | Excel Discussion (Misc queries) | |||
TV station business plan | Excel Worksheet Functions | |||
How do I set up a 3 year business plan for a new company justific | Setting up and Configuration of Excel | |||
looking for a business plan form | Excel Discussion (Misc queries) | |||
Anyne have a template for a start-up business plan? | Excel Discussion (Misc queries) |