please fill in all and every (?) even the (?) in the graphs and use excel for this assignment.

Ginnie Springs Company has been bottling and selling water since 1940. The company's current owner would like to know how Required Calculate Ginnie Springs' net income for the new product in the coming year by completing the operating budgets and budgeted 1. Sales budget: _x0001_ 2. Production budget: _x0001_ 3. Direct materials purchases budget: Ginnie Springs Company Direct Materials Purchases Budget For the Year Ended December 31 _x0001_ 4. Direct labor budget: _x0001_ 5. Overhead budget: _x0001_ 6. Selling and administrative expenses budget: _x0001_ 7. Cost of goods manufactured budget: Ginnie Springs Company Cost of Goods Manufactured Budget For the Year Ended December 31 _x0001_ 8. Budgeted incomestatement: Ginnie Springs Company Selling and Administrative Expenses Budget For the year Ended December 31 Sales Cost of goods sold Finished goods inventory beginning Cost of goods manufactured Cost of Goods available for sale Less finished goods inventory, ending Cost of good sold Gross margin Selling and administrative expenses Income from operations Income taxes expenses (30% tax rate) Net Income ? ? ? ? ? ? ? ? ? ? ? ? r would like to know how a new product would affect the company's net income in the coming year. ng budgets and budgeted income statement that follow. Assume that the selling price will remain constant