Must be shown in excel with forumulas
1. A sales projection in units using the methods suggested.
2. Sales budget
3. Production budget
4. Direct materials budget
5. Direct labor budget
6.Manufacturing overhead budget
7. Projected Cost of Goods Manufactured (absorption costing)
2012 INFORMATION STUPENDOUS SUPER DEPARTMENT ME Number of machines available Annual capacity per machine 15,000 gallons 15,000 gallons 300,000 gallons Annual production capacity 390,000 gallons Machine hours available per machine 1,800 hours 800 hours Standard machine hour per gallon 12 hour gall 12 hour gall 1.25 labor hrlmach.hr 25 labor hr/mach hr Standard labor hour per machine hour 420,000 gallons Actual sales volume 268,200 gallons Number of hourly employees 29 21 Supervisors (one per each eight hourly employees Raw material prices Cans 40e each 40 each. $2.75 per pound Pigments $3.75 per pound Raw material usage one per gallon one per gallon Pigment two pounds per gallon two pounds per gall Direct labor rate $8.25 per hour $8.25 per hour 2013 PROJECTED SALES INFORMATION The Sales Department feels very good about the prospects for 2013. The reputation of the new product, Stupendous Paint, has increased significantly due to effective advertising in the past few years. The Sales Department is ready to launch a major advertising campaign, which is expected to continue the trend of the last three years for the Stupendous brand, even with a small price increase per gallon. Super Paint has been produced since the company began production. The sales level of this product has been rather stagnant for the last 5 years, and that trend is expected to continue in the future. The following information regarding the two products has been gathered Super Stupendous Paint. Paint Anticipated 2013 Sales Price. $10.30per gallon. $15.45. per gallon Actual 2008 Sales 411,000 gallons None Actual 2009 Sales 412,000 gallons None 405,000 gallons Actual 2010 Sales 6,250 gallons Actual 2011 Sales 430,000 gallons 223,500 gallons 268,200 gallons Actual 2012 Sales 420,000 gallons 2013 DIRECT MATERIAL AND INVENTORY BUDGET INFORMATION The Production Department worked in conjunction with both the sales and purchasing departments in developing desired projected inventory levels for December 31, 2013. Information regarding beginning and desired ending inventories for 2013 are as follows
