C LL LOUW I LALU.U NDULVAS. ALLILLI Page 1: Question 10 (10 points) Saved Nestle Inc makes two products, bottled water and baby food. Selected budgetary data for 2019 follow Bottled Water Baby Food 1.80 1.50 3.25 2.25 Requirements for each finished component: Direct Materials in (lbs) Direct Labor (hours) Product information: Sales price Sales (units) Estimated beginning inventory (units) Desired ending inventory (units) 180.00 10,500.00 950.00 500.00 150.00 11,100.00 1,000.00 775.00 Direct Material Information Cost per pound Estimated beginning inventory in pounds Desired ending inventory in pounds 2.35 3,450.00 4,050.00 The company expects the average wage rate to be $18 per hour in 2019. Nestle uses direct labor hours to apply overhead. Each year the firm determines the overhead application rate for the year based on budgeted direct labor hours for the year. Fixed Costs Variable Costs Total Factory O/H Info 255,000.00 307,500.00 562.500.00 Advertising Sales salaries Travel and entertainment Depreciation-warehouse Office salaries Executive salaries Supplies Depreciation-office Total Selling & Admin Info 62.000.00 213.500.00 56,000.00 4,200.00 58.000.00 251 000.00 4.250.00 8.150.00 655.100.00 Selain Depreciation-office Total 4,250.00 6.150.00 655,100.00 Prepare an excel sheet that contains the following schedules or statements for 2019 Sales Budget Production Budget Direct Materials Purchases Budget Direct Labor Budget Cost of Goods Sold Budget Budgeted Income Statement- last item labeled After-Tax Operating Income (32% Rate) Deep - Paragraph B u I was not able to upload photos and I wrote this all out on a sheer of pay o e Mas