I need to find the revenue, cost of goods sold, gross margin, selling and administration, pretax income, income tax (20% rate) and net income for 20x5 using the attatched documents.

AWESOME SAUCES Budget Assumptions Balance Sheet as of January 1, 20X5 Assets: Cash Accounts Receivable Finished Goods Inventory Raw Materials Inventory Building and Equipment Less: Accumulated Depreciation Total Assets $20,000 $0 $0 $0 $100,000 $0 $120,000 Liabilities and Stockholder's Equity: Account Payable Contributed Capital Retained Earnings Total Liabilities and Stockholder's Equity $0 $120,000 $0 $120,000 Moreover, Elena estimates that she will sell the following number of barbeque sauce cases in the coming years: Year 20X5 20X6 20X7 Sales in Cases 1,800 1,900 2,000 Elena provides you with the following additional information: Sales price: Each case of barbeque sauce will sell for $50. Inventory policy for finished goods: Elena will desire to have an ending finished goods inventory of 40% of the next year's forecasted demand. Production requirements: The cost of direct materials to produce each case of barbeque sauce will be $10 (including ingredients, bottles, labels, and packaging). When creating the direct materials budget, assume each case of sauce requires one unit of raw material that costs $10. Additionally, 1 hour of direct labor (cooking, bottling, and packaging) will be required to produce each case at a cost of $10 per direct labor hour. Elena will pay all wages in cash in the year worked. Fixed manufacturing overhead is expected to be $25,600 per year. Of this amount, $10,000 represents depreciation. The remaining amount, which (including insurance on the production facility, a part-time administrator to manage paperwork at the production facility, and a monthly fee paid to have the equipment maintained) will be paid in cash the year it is incurred. Elena expects variable overhead, which includes the utilities to run the production machines to be $0.50 per unit. Inventory policyraw materials: With regard to the materials needed to produce each case of barbeque sauce, Elena will want to have 20% of next year's production needs in inventory at the end of each year. Payables policy: Elena will pay 90% of her material costs in the year of purchase and the remaining 10% in the following year. Collection policy: Elena will receive 95% of her revenues in cash in the year of sale and the remaining 5% of revenues in the following year. Selling and administration costs: Yearly non-manufacturing expenses consist of sales commissions of 10% of sales revenues and fixed selling and administration costs (which includes the lease payment for the sales/administrative office and equipment) of $15,000. Taxes: Elena's tax rate is 20%. All taxes are paid in cash in the year of the expense. OPERATING & FINANCIAL BUDGETS Revenue Budget REVENUE BUDGET: EXPECTED CASE SALES VOLUME SALES PRICE PER CASE BUDGETED REVENUE 20X5 20X6 20X7 1,800.00 $50.00 $90,000.00 1,900.00 $50.00 $95,000.00 2,000.00 $50.00 $100,000.00 20X5 20X6 1,800.00 1,900.00 760.00 2,560.00 800.00 2,700.00 2,560.00 760.00 1,940.00 Production Budget PRODUCTION BUDGET: EXPECTED CASE SALES VOLUME ADD: DESIRED CASE ENDING INVENTORY TOTAL REQUIRED CASES LESS: BEGINNING INVENTORY OF CASES REQUIRED CASE PRODUCTION Direct Materials 20X5 DIRECT MATERIALS: DIRECT MATERIALS FOR REQUIRED CASE PRODUCTION ADD: DESIRED DIRECT MATERIALS ENDING INVENTORY TOTAL DIRECT MATERIALS REQUIRED LESS: BEGINNING DIRECT MATERIALS INVENTORY TOTAL DIRECT MATERIALS TO 2,560 388 2,948 2,948 PURCHASE COST PER CASE OF MATERIAL TOTAL COST OF DIRECT MATERIALS PURCHASES $10.00 $29,480.00 Direct Labor 20X5 DIRECT LABOR: REQUIRED CASE PRODUCTION DIRECT LABOR HOURS PER CASE TOTAL REQUIRED DIRECT LABOR HOURS DIRECT LABOR COST PER HOUR TOTAL DIRECT LABOR EXPENSE $2,560.00 1.00 $2,560.00 $10.00 $25,600.00 Manufacturing Overhead 20X5 MANUFACTURING OVERHEAD: VARIABLE OVERHEAD: VARIABLE OVERHEAD PER CASE PRODUCED REQUIRED CASE PRODUCTION TOTAL VARIABLE OVERHEAD FIXED OVERHEAD: DEPRECIATION OF PRODUCTION FACILITY AND EQUIPMENT OTHER FIXED MANUFACTURING OVERHEAD $0.50 $2,560.00 $1,280.00 $10,000.00 $15,600.00 TOTAL FIXED OVERHEAD $25,600.00 TOTAL OVERHEAD $26,880.00 Selling & Administration 20X5 SELLING AND ADMINISTRATION BUDGET: VARIABLE SELLING & ADMINISTRATION: SALES COMMISSION RATE TOTAL REVENUES 0.10 $90,000.00 TOTAL VARIABLE SELLING & ADMINISTRATION FIXED SELLING & ADMINISTRATION: FIXED SELLING & ADMINISTRATION TOTAL S&A $9,000.00 $15,000.00 $24,000.00 Unit Product Cost 20X5 UNIT PRODUCT COST: DIRECT MATERIAL DIRECT LABOR MANUFACTURING OVERHEAD (TOTAL MOH/ UNITS PRODUCED) UNIT PRODUCT COST $10.00 $10.00 $10.50 $30.50