Deleon Inc. is preparing its annual budgets for the year ending December 31, 2020 Accounting assistants furnish the data shown below. Product NL 50 Product NL 60 Sales budget: Anticipated volume in units Quarter 1 Quarter 2. Quarter 3 Quarter 4 Unit selling price 2,000 1,800 2,200 1,500 $95 500 800 400 600 $60 20% 20% of the same quarter's expected sales units Production budget: Desired ending finished goods each quarter Beginning finished goods Units Cost 300 $18000 200 $7000 2 3 si Direct materials budget: Direct materials per unit (pounds) Item (x) 3 Item (Y) 4 Desired ending direct 10% materials pounds Beginning direct materials pounds Units 200 Cost per pound S4 Cost per pound $3 Cost per pound of the same quarter's production requirements 10% 150 $2 Direct labor budget: Direct labor time per unit Direct labor rate per hour 2 S15 1 $15 Manufacturing Overhead Variable overhead costs per direct labor hour Indirect materials S0.5 Indirect labor $1.5 Utilities S0.75 Maintenance S0.25 Fixed overhead costs per quarter: Supervisory salaries $20.000 Depreciation $3,800 $2,300 is related to buildings and $1.500 is attributable to equipment Insurance Maintenance $9,000 $5,700 Selling and Administrative Expense Variable costs per dollar of sales Delivery expense. 0.75% Sales commissions 4.50% Utilities 2.75% Fixed overhead costs per quarter: Sales salaries $15,000 Office salaries $7,500 Depreciation $1,000 $600 is related to buildings and $400 is attributable to equipment. Insurance Advertising Repaire Expense $1,500 $5,000 $900 All sales are on account. Collections are expected to be 50% in the month of sale, 30% in the first month following the sale, and 20% in the second month following the sale. Sixty percent (60%) of direct materials purchases are paid in cash in the month of purchase, and the balance due is paid in the month following the purchase. All other items above are paid in the month incurred. Other data: 1. Accounts Receivable: December 2019, $29.000. are expected to be collected in 2020: the first quarter $17,400; and second quarter $11.600. 2. Accounts Payable: December 2016. $10,800; are expected to be collected in the first quarter 2020 3. Other receipts: January--proceeds from sale of securities $2.000 4. Other disbursements: April-payment of $20,000 for Equipment July-Notes payable of $9,800 were redeemed at their face value for cash 5. Income taxes are estimated to be $9.000. Paid in three equal quarterly installments started at the end of quarter 2. 8. Deleon uses the FIFO inventory method for evaluating all endings inventories. 7. The company's cash balance on January 1, 2020, is expected to be $180.000. The company wants to maintain a minimum cash balance of $85.000 8. Loans and interest are repaid in the earliest quarter in which there is sufficient cash (interest expense: $580) Deleon Inc.' balance sheet at December 31, 2019. is presented below Deleon Inc Balance Sheet December 31, 2018 Assets Current assets Cash 180.000 29,000 2,000 25,000 1,100 26,100 237,100 150,000 230,000 -57,500 172,500 160 000 -40,000 120,000 Accounts receivable Marketable securities Finished goods inventory Raw Material inventory Total current assets Property, plant, and equipment Land Buildings Less: Accumulated depredation Equipment Less: Accumulated depredation Total property, plant and equipment Total assets Liabilities and Stockholders' Equity Liabilities Accounts payable Notes payable Total liabilities Stockholders' equity Common stock Retained earnings Total stockholders' equity Total liabilities and stockholders equity 442,500 679,600 10.800 9,800 500,000 159,000 659.000 679,600 Instructions Prepare the following budgets for the year. Show data for each product. Quarterly budgets should be prepared. a. Sales b. Production C. Direct materials. d. Direct labor e. Manufacturing overhead f. Selling and administrative expense g. Multiple-step budgeted income statement h. schedules for (1) expected collections from customers and (2) expected payments for direct materials purchases i. Cash budget