Data needed for spreadsheet input:

Input Budget Spreadsheet: (pt 2)

preparing a budget for 3rd Quarter, 2021 Budgeted Sales (in units) July August 40,000 45,000 September October November 60,000 35,000 20,000 Per Unit Selling Price $12.00 Cash Collections WTC sales are all on account with the following pattern of collection is: 65% Collected in the month of the sale 30% Collected in the month following the sale 5% Uncollectible June's sales were $360,000 Production Budget Ending inventory is to be equal to 15% of the following month's budgeted sales. Direct Materials 10 pounds of material is required per unit of product 10% of the following month's production for Materials on hand at month end $0.25 cost per pound of material Cash Disbursement for Materials Cash Disbursement for Materials WTC paid for purchases as follows: 55% is paid in the month the materials are purchased 45% is paid in the following month June 30 Accounts Payable balance of $33,187.50 is to be paid in full in July (or 6 minutes) Direct Labor Part of an hour of direct labor to produce one unit of product 0.1 WTC has a "no layoff" policy so all employees are paid for 40 hours of work each week The hourly rate per hour for regular time employees $15 The minimum number of hours to be paid each month 3,000 Manufacturing Overhead Manufacturing overhead is applied to units of product based on direct labor hours The viable overhead rate per direct hour $25 Fixed Manufacturing Overhead per month $75,000 Non-cash costs included in Fixed Manaufacturing Overhead $25,000 Selling and Administrative Expenses WTC has both fixed and variable selling and administrative expenses Rate per unit for Variable Selling and Administrative expenses Fixed Selling and Administrative expenses per month Non-cash costs included in Fixed Selling and Administrative expenses $0.25 $75,000 $15,000 Cash Budget Maintain a minimum month end cash balance of $40,000 Maintains a 15% open line of credit for $125,000 Borrowing happens on the first day of the month Repayments are made on the last day of the month Cash dividend paid in August Equipment purchases made in Q3 2021 Equipment purchased with cash in July Equipment purchased with cash in September June 30 ending cash balance was $40,000 $60,000 $55,000 $150,000 Budgeted Financial Staments WTC Balance Sheet as of June 30 showed the following balances: Accounts Receivable $137,627.00 Equipment $195,000.00 $50,000.00 Common Stock $300,000.00 Retained Earnings Land Construer Direer Labor Budger July Quarter 3, 2021 August September Total 1 Units of Production Direct Labor berit Labor hours equired Ga How Labor Hours Pud Total Direct Labor Costs Construer Manufacturing Overhead Budget Quarter 3, 2021 August September July Toral Budgeted DLH Variable MOH te Variable IOH costs Pised MOH costs Total MOH costs Predetermined Orerhead Rate (POHR) Total MOH costs Les bones cott Cash disbursements for MOH Toral Construer Ending Finished Goods Inventory Budger Quarter 3, 2021 Production cost per unit Cast Direct Materials lbs. Direct Labor hrs. Manufacturing Orechead hes Product Cost per hit Budgeted Finished Goods Inventory Ending inventory in units Unit product cost Ending finished goods inventory Construer Selling and Administrative Expense Budger Quarter 3. 2021 July August September Budgeted Sales Toral Variable expenses Pised $ & costs Tools & A costs Les noncash costs Cash S & A Expenses Construer Cash Budger Quarter 2, 2021 August September July Total Beginning Cash Bulace Add: Cash collections Totalcahamable Less: Cash disbursements Direct labor banufacturing O/H Selling and Admin Equipment purchase Dividend Toral disbursement Excess Deficiency) Pinancing Borrowing Repayments Interest Toral aa Ending Cash Balance Budgered Income Surement Sales Cost of Goods Sold Gross Margin Selling and Administrative expenses Operating Income Interest expense Net Income Construer Budgeted Income Statement Budgeted Balance Sheer ASSETS: Cash Accounts receivable Raw materials inventory Finished goods inventory Land Equipment Total Assets LIABILITIES AND STOCKHOLDERS' EQUITY: Accounts Payable Notes Payable Common Stook Retained earnings Total Liabilities and Stockholders Equi