ABC Company manufactures racing tires for bicycles. The selling price is $50 for each tire. ABC Company is planning for the next year by developing a master budget by quarters. The balance sheet for December 31, 2018 follows: ABC COMPANY Balance Sheet 31-Dec-2018 Cash $20,000 Accounts Payable $5,000 Accounts Receivable 25,000 Raw Material Inventory 3,000 Finished Goods Inventory (200 tires) 5,800 Common Stock 125,000 Equipment 175,000 Retained Earnings 41,800 Less Accumulated Depreciation (57,000) Total Liabilities and Equity $171,800 Total Assets $171,800 The budget committee of the company has provided the following data: Budget sales are 900 tires for the first quarter and expected to increase by 100 tires per quarter. Cash sales are expected to be 30% of total sales, with the remaining 70% sales on account. Desired ending Finished Goods Inventory is 40% of the next quarter's sales; first quarter sales for 2020 are expected to be 1,300 tires. Direct material cost is $15 per tire. Desired ending Raw Material Inventory is 20% of the next quarter's direct materials needed for production; desired ending Raw Material Inventory for December 31 2019 is $3,000. Each tire require 0.2 hours of direct labor, direct labor costs average $18 per hour. Variable manufacturing overhead is $2 per tire. Fixed manufacturing overhead includes $3,000 per quarter in depreciation and $4,232 per quarter for other costs, such as utilities, insurance. Cash receipts for sales on account are 50% in the quarter of the sale and 50% in the quarter following the sale; December 31 2018 Accounts Receivable would be received in the first quarter of 2019. Required: 1) Prepare the production budget in units for 2019 by quarter. (10 marks) 2) Prepare the direct material budget in dollars for 2019 by quarter. (10 marks) 3) Prepare the manufacturing overhead budget for 2019 by quarter and calculate the predetermined overhead rate. (12 marks) 4) Prepare the schedules of expected cash collection for 2019 by quarter. (15 marks)