Must use excel with formulas

1. Capital expenditures budget

2. Selling expenses budget

3. Administrative expenses budget

4. Proforma income statement (absorption costing)

5. Cash budget

6. Proforma balance sheet

7. Comment on the strengths and weaknesses of this company. What concerns do you have? What recommendations do you have for the future?

2012 INFORMATION STUPENDOUS SUPER ME IMENU 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 Standard labor hour per machine hour 1,25 labor hrlmach.hr 25 labor hr/mach hr 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 Pigments $2.75 per pound $3.75 per pound. Raw material usage one per gallon one per gallon two pounds per gallon two pounds per gallon Pigment Direct labor rate S8.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: Stupendous Super Paint. Paint Anticipated 2013 Sales Price. .$1020 per gallon. $15.45 per gallon Actual 2008 Sales 411,000 gallons None Actual 2009 Sales 412,000 gallons None Actual 2010 Sales 405,000 gallons 186,250 gallons Actual 2011 Sales 430,000 gallons 223,500 gallons 268,200 gallons Actual 2012 Sales 420,000 gallons You have made the following conclusions about the two different products Super Paint Sales growth in units will continue to be stagnant. The more recent years are more representative of continuing unit sales than years in the further past. Exponential Smoothing will be an appropriate unit sales projection method to use