Thank you in advance for answering, just wanted to make sure my answers and work are correct on this one, PLEASE DO ON EXCEL will upvote!

Please complete the following budgets for 2023:

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)

11) Nestle Inc makes one product, bottled water. Selected budgetary data for 2023 follows: Requirements for each finished component: Direct Materials in (lbs) Direct Labor (hours) 1.60 Product information: 1.50 Sales price Sales (units) Estimated beginning inventory (units) Desired ending inventory (units) Direct Material Information Cost per pound Estimated beginning inventory in pounds Desired ending inventory in pounds S 2.35 3,450.00 4,050.00 Bottled Water The company expects the average wage rate to be $20 per hour in 2023 . Nestle uses direct labor hours to apply overh Each year the firm determines the overhead application rate for the year based on budgeted direct labor hours for the ) Fixed Costs Variable Costs Total Advertising Sales salaries Travel and entertainment Depreciation-warehouse Office salaries Executive salaries Supplies Depreciation-office Total Selling \& Admin Info