Please help

ABC Company manufactures and sells a single product. The following information is evailable concerning the operations for 2018. a. The company's single product sells fo 2018 Quarter 1 3,000 Budgeted sales in units 2018 Quarter 2 3,500 Budgeted sales in units 2018 Quart ng informationis r $60 per unit. Budgeted sales in units for the next four quarters are: r 2018 2019 er 3 Quarter 4 4,000 Budgeted sales in units 4,500 Budgeted sales in units Quarter 1 5,000 Budgeted sales in units b. Sales are collected in the following patter followin showed n: 80% in the quarter in which the sale is made, 19% in the ing quarter, and 1% is considered uncollectable. On January 1, 2018, the c $60,000 in account receivables, all of which will be collected in the first q company's balance sheet uarter of the year 2018. company requires an ending inventory of finished units on hand at the end of each q c. The 20% of the budgeted sales for the next quarter. This requirement was met on December 31, 2017 company had 600 units on hand to start the new-year). uarter equal to (The ( d. Two pounds (2lbs) of raw materials are required to complete one unit of product. The company requires an ending inventory of raw materials on hand at the end of each quarter equal to 10% of the production needs of the following quarter, This requirement was met on December 31, 2017. [The company had 620 ibs of raw materials on hand to start the new year]. Quarter 1 of the next year lyear 2019) is estimated at 10,200 lbs needed for production e. The raw material costs $4.00 per pound. Purchases of raw material are paid for in the following pattern 50% paid in the quarter in which the purchase was made, and the remaining 50% is paid in the following quarter. On January 1, the 2018 company's balance sheet showed $10,600 in accounts payable for raw material purchases. All of which will be paid for in the first quarter of the year 2018. curred. The only f. Manufacturing overhead and selling & administrative expenses are paid in the quarter in exception is depreciation. 8. The manufacturing overhead budget distinguishes between variable and fixed overhead costs. Variable costs fluctuate with production volume on the basis of the following rates per direct labor hour: indirect materials $1.00, indirect labor $1.40, utilities $0 40, and maintenance $0.20. Fixed costs per quarter are: pervisory Salaries $20,000, Depreciation $3,a00, Property Taxes & Insurance $9,000 and Maintenance $5,700. Overhead is applied to production on the basis of direct labor hours. The annual rate is $8 per hour Hint: Total Manufacturing Overhead for 2018 $246,400/ Direct Labor hours 30,800 hours $8/direct labor hour). h. Selling & administrative expense budget distinguishes between variable and fixed overhead costs. Variable costs are Sales Commissions of $3.00 and Freight-Out $1.00. Variable expenses per quarter are based on the unit sales projected in the sales budget. Fixed costs, per quarter, are: Advertising $5,000, Sales Salaries $15,000, Office Salaries $7,500 Depreciation $1,000 and Property Taxes & Insurance $1,500 i. January 1, 2018, cash balance is expected to be $38,000. j. Marketable securities are expected to be sold for $2,000 cash in the first quarter k. 2 hours of direct labor are required to produce each unit of finished goods and the anticipated hourly wage rate is $10. Direct Labor is paid 100% in the quarter incurred. I. Management plans to purchase new factory equipment in the second quarter for $50,000. Depreciation is calculated using the straight-line method, useful life estimated at ten years, with no residual value. m. Loans are repaid in the first subsequent quarter in which there is sufficient cash (incuring 8% interest if funds are borrowed.) n. A minimum cash balance of $20,000 is maintained per quarter o. Budgeted balance sheet information as of December 31, 2017 were: Building & Equipment $ 182,000 Common Stock $ 225,000, Accumulated Depreciation$ 28,800 and Retained Earnings of $ 46,480. Requirement: 1. Budgeted income statement (Budgeted financial Statement) 2. Budgeted balance sheet (Budgeted financial statement)