Reference no: EM133162551

I need assistance in creating a yearly budget with 10 employees in the department. Each employee makes $40,000 per year. Your salary is $55,000 per year. Utilities are estimated at $50 per employee per month. In addition you must also do the following:

• Find and budget for three team building activities (Not all in the same month)
• Budget for Green Belt training for your team - find actual cost (spread out over 2 months)
• Develop one Six Sigma project for the month of September Budget for training 5 employees 5 hours per month for the months on June, July and August. Training is budgeted separately and the time in training is deducted from regular pay. (rate of pay is the same)
• During October the warehouse will be expanded and you will have to staff it with 5 employees each making $24,000 per year. Employees will remain for the rest of the year
• Buy or lease two battery operated  forklifts in October for the warehouse - uses real data
• In November you will need to reduce the inside sales staff by three

Using Excel: 

Describe three actual team building activities- use actual costs if possible

I must Write a proposal for a Six Sigma project. Project should center around one of the following issues - low attendance, orders being entered into system incorrectly, or high turnover

Write an announcement explaining that three positions are being eliminated in November. Keep in mind reassuring the remaining employees that their jobs are not be effected if productivity and profits go up.