For 2019 Year OPERATING BUDGET Sales Budget Quarter 3. Year last year next year 9 Units 10 Unit selling price 11 Budgeted sales 12 13 Production Budget Quarter 14 Year 15 16 Sales in units 17 Desired ending inventory 18 Total needs 19 Less: Beginning inventory 20 Units to be produced 21 Direct Materials Purchases Budget Quarter 22 23 Direct Materials Purchases Budget 22 23 24 25 Units to be produced 26 Direct materials per unit 27 Production needs 28 Desired ending inventory 29 Total needs 30 Less: Beginning inventory 31 Direct materials to be purchased 32 Cost per unit 33 Total material purchase cost Quarter Year 1 34 Direct Labor Budget 35 36 Quarter 37 38 Units to be produced 39 Direct labor time per unit in hours 40 Total hours needed 41 Average wage per hour 42 Total direct labor cost 43 3 4. Year 43 Overhead Budget 44 Quarter 45 Year 4 46 47 Budgeted direct labor hours 48 Variable overhead rate 49 Budgeted variable overhead 50 Budgeted fixed overhead 51 Total overhead 52 53 Note: depreciation in fixed overhead 54 55 Unit product cost for ending inventory budget 56 Direct matenals 57 Direct labor 58 Variable overhead Fixed overhead 59 60 Total unit cost 61 62 Total finished goods units for end of year 63 Total ending finished goods inventory 64 Quaint Stem Company is a high-end glassware manufacturer that produces fine stemware of the highest quality. The company is completing its fourth year of operations and is preparing to build its master budget for the coming year (2020). The budget will detail each quarter's activity and the activity for the year in the total. The master budget will be based on the following information: a. Fourth-quarter sales for 2019 are 82,000 units and 68,000 for the first quarter of 2021. b. Unit sales by quarter (for 2020) are projected as follows: First quarter Second quarter Third quarter Fourth quarter 64,000 70,000 76,000 86,000 The selling price is $82 per unit. Cash sales make up 20% of all sales. Quaint collects 80 percent of the credit sales within the quarter in which they are realized; thelother 20 percent are collected in the following quarter. There are no bad debts. c. The beginning inventory of finished goods is 13,000 units. Required ending inventory is 25% of the next quarter's sales in units. d. Each stemware unit uses one and a half hours of direct labor and two units of direct materials. Laborers are paid S24.00 per hour, and one unit of direct materials costs $12. e. There are 10,400 units of direct materials in beginning inventory as of January 1, 2019. At the end of each quarter, Quaint plans to have 10 percent of the direct materials needed for next quarter's unit sales. The ending unit of direct materials on hand at the end of the year was 14,200. f. Quaint buys direct materials on account. Half of the purchases are paid for in the quarter of acquisition, and the remaining half are paid for in the following quarter. Wages and salaries are paid on the 15th and 30th of each month. g. Fixed overhead totals $576,400 for cach of the first three quarters. Of this total, $175,000 represents depreciation. During the fourth quarter, the depreciation and total fixed overhead increases by $18,750. All fixed expenses other than depreciation are paid for in cash in the quarter incurred. The fixed overhead rate is computed by dividing the year's total fixed overhead by the year's expected fixed overhead rate is computed by dividing the year's total fixed overhead by the year's expected actual units produced. h. Variable overhead is budgeted at $4.50 per direct labor hour. All variable overhead expenses are paid for in the quarter incurred. i. Fixed selling and administrative expenses total $230,000 per quarter, including $50,000 depreciation. j. Variable selling and administrative expenses are budgeted at $4 per unit sold. All selling and administrative expenses are paid for in the quarter incurred. k. The balance sheet as of December 31, 2018, is as follows: LIABILITIES and STOCKHOLDERS'EQUITY ASSETS $ 680,000 Cash Accounts Payable 52,000 Accounts Receivable 1,275,000 Raw Materials Inventory Finished Goods Inventory Plant and equipment, net 124,800 656,500 Capital Stock 9,360,000 Retained Eamings $11.468.300 9,750,000 1,038,300 $11,468,300 Total Liab. & Equity Total Assets 1. Quaint has a required cash balance of $50,000. An operating line of credit is available up to $250,000 at 10% interest. All borrowings and payments must be made in increments of $10,000 and interest is paid when principal is paid. All borrowings take place at the beginning of the quarter and all payments take place at the end of the quarter. m. Quaint will pay quarterly dividends of $45,000. At the end of the third quarter, $575,000 of equipment will be purchased and at the end of the fourth quarter, $175,000 of equipment will be purchased. n. The income tax rate is 30%. at 10% interest. All borrowings and payments must be made in increments of $10,000 and interest is paid when principal is paid. All borrowings take place at the beginning of the quarter and all payments take place at the end of the quarter. m. Quaint will pay quarterly dividends of $45,000. At the end of the third quarter, $575,000 of equipment will be purchased and at the end of the fourth quarter, $175,000 of equipment will be purchased. n. The income tax rate is 30%. Required Prepare a master budget for Quaint Stem Company for each quarter of 2019 and for the year in total. The following component budgets must be included: a. Sales budget b. Production budget c. Direct materials purchases budget d. Direct labor budget e. Overhead budget f. Ending finished goods inventory budget g. Cost of goods sold budget h. Selling and administrative expenses budget i. Cash budget j. Pro forma income statement k. Pro forma balance sheet