I recently started in my new role as cost accountant. I need a excel template do make budgets and forecast for a productions assembly unit. Kind of agile planning. We have different types of machines, which requires different types of handling. So if i put in the sales forecast of the entire year i need to see how many different types of employees in need, how many hours they are going to spend. A profit and loss statement untill gross profit level. Finance only need to update the base information on a yearly / quarterly basis. That is Machine x takes 1 engineer 8 hours, 1 purchaser 16 hours and 4 production employees 30 hours to assemble. The costs of materials and other outsourced work ect. And then once the sales forecasts is filled in you would automaticly see the number and type of people needed to make your machines and a automatic profit and loss statements comes out. This needs to be made in excel.
December 28, 2017
I am looking for freelancers with the lowest rates