Please see attached. Need to create budget. The problem is in MS doc document:

The results of operations for the Preston Manufacturing Company for the fourth quarter of 2014 were as follows: Sales Less variable cost of sales $ 510,000 306,000 Contribution margin 204,000 Less fixed production costs Less fixed selling and administrative expenses $ 102,000 51,000 Income before taxes Less taxes on income 153,000 51,000 20,400 Net income $ 30,600 Note: Preston Manufacturing uses the variable costing method. Thus, only variable production costs are included in inventory and cost of goods sold. Fixed production costs are charged to expense in the period incurred. The company's balance sheet as of the end of the fourth quarter of 2014 was as follows: Assets: Cash Accounts receivable Inventory Total current assets Property, plant, and equipment Less accumulated depreciation Total assets Liabilities and owners' equity: Accounts payable Common stock Retained earnings Total liabilities and owners' equity $ 160,000 255,000 378,000 793,000 500,000 120,000 $1,173,000 $ 48,960 529,000 595,040 $1,173,000 Additional information: 1. Sales and variable costs of sales are expected to increase by 10 percent in the next quarter. 2. All sales are on credit with 50 percent collected in the quarter of sale and 50 percent collected in the following quarter. 3. Variable cost of sales consists of 40 percent materials, 40 percent direct labor, and 20 percent variable overhead. Materials are purchased on credit. 60 percent are paid for in the quarter of purchase, and the remaining amount is paid for in the quarter after purchase. The inventory balance is not expected to change. Also, direct labor and variable overhead costs are paid in the quarter the expenses are incurred. 4. Fixed production costs (other than $8,000 of depreciation expense) are expected to increase by 1 percent. Fixed production costs requiring payment are paid in the quarter they are incurred. 5. Fixed selling and administrative costs (other than $7,000 of depreciation expense) are expected to increase by 3 percent. Fixed selling and administrative costs requiring payment are paid in the quarter they are incurred. 6. The tax rate is expected to be 40 percent. All taxes are paid in the quarter they are incurred. 7. No purchases of property, plant, or equipment are expected in the first quarter of 2015. (a) Prepare a budgeted income statement for the first quarter of 2015. Preston Manufacturing Company Budgeted Income Statement for the Quarter Ended March 31, 2015 $ : : $ : $