The following information pertains to the budgeting process for Beach, Inc. SALES: Beach, Inc. sells one type of designer all-purpose beach bag for $45 per bag. Based on various sales forecasting models, Beach expects to sell 4,000 units in quarter 1, 6,000 in quarter 2, 7,500 in quarter 3 and 5,000 in quarter 4. The beginning accounts receivable balance was $40,000. Assuming all sales are made on credit, about 70% of the quarterly sales are collected in that quarter; the remaining 30% are collected in the following quarter. PRODUCTION (UNITS): Beach would like for ending inventory for each quarter to be 10% of the following quarter's sales. Beginning of year inventory included 400 units. Assume desired inventory at the end of the year is 700 units. DIRECT MATERIALS: Beach needs 2 pounds of material for each bag produced. Each pound of material costs $4.00. Ending raw materials inventory should equal 10% of the following quarter's production. Beginning raw materials inventory is 500 pounds. Desired end-of-year inventory is 650 pounds. Beginning accounts payable is $24,000. For purchases, assume 50% are paid for in the same quarter as purchased; 50% are paid for in the following quarter. DIRECT LABOR: Direct labor hours per unit = 1 Direct labor cost per hour = $13. MANUFACTURING OVERHEAD: Based on estimates and research, the variable overhead rate is $2 per hour. Total fixed manufacturing overhead is $100,000. Assume this is spread evenly over the four quarters. Depreciation on all factory assets = $36,000. ENDING FINISHED GOODS INVENTORY BUDGET: See Beach's previous budget schedules for information needed to prepare this schedule. SELLING AND ADMINISTRATIVE EXPENSE BUDGET: Beach estimates that the variable selling and administrative expenses will be $1.50 per unit. The following fixed expenses were provided by Beach's various departments: advertising $50,000; salaries $100,000; insurance $32,000; legal and professional fees $26,000; taxes $40,000; depreciation $18,000. CASH BUDGET: Beach's cash policy requires a minimum cash balance of $20,000. Per a loan agreement with the local bank, Beach must pay 5% per quarter interest on any borrowings. Assume that borrowings occur on the first day of the period and repayments occur on the last day of the period. Borrowings must be made in $1,000 increments, and interest is paid when the loan repayments are made. The cash balance at the beginning of the year was $60,000. Beach is expecting to purchase new machinery costing $70,000 in the second quarter and $30,000 in the third quarter. Beach is expecting to pay dividends of $12,000 in the fourth quarter. BUDGETED INCOME STATEMENT: See Beach's previous budget schedules for information needed to prepare this schedule. BUDGETED BALANCE SHEET: Beginning Buildings & Equipment = $435,000; Beginning Accumulated Depreciation = $236,000 (assume no fixed assets were sold) Common stock balance is $30,000 (this did not change throughout the year) Beginning of year retained earnings = $258,048 BASED ON THE ABOVE BUDGETING ASSUMPTIONS, PREPARE THE FOLLOWING: 6. 2. 1. SALES BUDGET PRODUCTION BUDGET 3. DIRECT MATERIALS BUDGET 4. DIRECT LABOR BUDGET 5. MANUFACTURING OVERHEAD BUDGET ENDING FINISHED GOODS INVENTORY BUDGET 7. SELLING AND ADMINISTRATIVE EXPENSE BUDGET 8. CASH BUDGET 9. BUDGETED INCOME STATEMENT 10. BUDGETED BALANCE SHEET DIRECT LABOR BUDGET: 1 Quarter 2 3 4 Year MANUFACTURING OVERHEAD BUDGET: 1 Quarter 2 3 4 Year ENDING FINISHED GOODS INVENTORY BUDGET (ABSORPTION COSTING): Quantity $ Cost Production cost per unit: Budgeted finished goods inventory: Overhead applied based on direct labor hours. ** From production budget (desired ending inventory). lbs. hours hours Total cost Fixed S&A expenses: Total fixed S&A expenses Add cash receipts: Cash available SELLING AND ADMINISTRATIVE EXPENSE BUDGET: From budget: Sales Less cash payments: DM DL MOH S&A (given) (given) Total cash payments Financing: Total financing Ending cash balance 1 Quarter 2 3 4 Year CASH BUDGET Quarter 1 2 3 4 Year Current Assets: Cash BUDGETED INCOME STATEMENT Assets: Budget: Sales Sales, FGI S&A Exp. Cash BUDGETED BALANCE SHEET Accounts Receivable Raw materials inventory Finished goods inventory Total current assets Property, Plant & Equipment: Buildings and Equipment Accumulated depreciation Net property, plant & equipment Total assets Liabilities & Equity: Current Liabilities: Accounts payable (raw materials) Line of credit Total current liabilities Stockholders' Equity: Common stock Retained earnings Total stockholders' equity Total liabilities & stockholders' equity