What the Scrap Steel Co. produces and sells steel doors with budgeted or standard costs as follows: Inputs: Direct Materials Direct Labor Variable Overhead Rate Fixed Overhead Costs Standards: 100 lbs per door; $0.40 per pound 10 hrs per door; $23.00 per hour 10 hrs per door; $27.60 per hour $26,000 per month Depreciation is a non-cash expense and is valued at $1,000 and is included in the Fixed OH cost above. Unit Sales for the prior and future months are budgeted as follows: July 280 August 250 September 270 The desired Ending Inventory of Materials is 5% of the materials needed for production for the following month. The desired Ending Inventory of Finished Goods is 10% of production for the following month. The Ending Inventory for June was 28 units. The cost per unit for June was $ 386 per unit. The budgeted sales price is $1,200 per steel door. Sales are budgeted as 100% credit sales. According to previous recorded collections, Scrap Steel determined that 55% of sales are collected during the month of sale; 43% are collected in the following month; 2% are uncollectible. June Accounts receivable were $129,000 and will be collected in full during July. The materials purchases are 100% credit 70% in month of purchase and 30% in the following month. The beginning Accounts Payable is $5,500. Selling and Administrative expenses are: Variable Selling and Administrative Expenses Fixed Selling and Administrative Expenses $50 per unit sold $15,000 per month Selling and Administrative depreciation is a noncash expense that is at a rate of $750 per month that is included in the fixed expenses above. The following information for the cash account follows: Beginning Cash Balance Dividend Paid Capital Expenditures $165,000 30,000 153,000 Scrap Steel requires a minimum ending cash balance of $1,500. Required: A partial master budget for July as follows. 1. Sales budget for August 2. Production budget for August 3. Direct material quantity needed for production Budgeted cost of direct material purchases for August Budgeted cost of direct materials used in August 4. Direct material quantity to be purchased for August 5. 6. 7. 8. Direct labor needed for production Budgeted cost of direct labor 9. Budgeted factory overhead costs 10. Budgeted cost of goods sold 11. Budgeted selling and administrative costs 12. Budgeted income statement 13. Prepare a cash budget; include cash receipts and disbursements Keep track of the tougher aspects