Exam 8: Flexible Budgets, Standard Costs, and Variance Analysis

Sioux Corporation is estimating the following sales for the first four months of next year: Sales are normally collected 60% in the month of sale, 35% in the month following the sale, and the remaining 5% being uncollectible. Based on this information, how much cash should Sioux expect to collect during the month of April?

The sales budget often includes a schedule of expected cash collections.

Roberts Corporation manufactures home cleaning products. One of the products, Quickclean, requires 2 pounds of Material A and 5 pounds of Material B per unit manufactured. Material A is purchased from the supplier for $0.30 per pound and Material B is purchased for $0.50 per pound. The finished goods inventory on hand at the end of each month should equal 4,000 units plus 25% of the next month's sales. The raw materials inventory on hand at the end of each month (for either Material A or Material B) should equal 80% of the following month's production needs. The production budget calls for 26,000 units of Quickclean to be manufactured in June and 32,000 units of Quickclean to be manufactured in July. On May 31 there will be 41,600 pounds of Material A and 104,000 pounds of Material B in inventory. The number of pounds of Material A needed for production during June would be:

For May, Young Corporation has budgeted its cash receipts at $125,000 and its cash disbursements at $138,000. The company's cash balance on May 1 is $17,000. If the desired May 31 cash balance is $20,000, then how much cash must the company borrow during the month (before considering any interest payments)?

The manufacturing overhead budget of Paparella Corporation is based on budgeted direct labor-hours. The November direct labor budget indicates that 6,000 direct labor-hours will be required in that month. The variable overhead rate is $2.00 per direct labor-hour. The company's budgeted fixed manufacturing overhead is $79,200 per month, which includes depreciation of $21,000. All other fixed manufacturing overhead costs represent current cash flows. Required: a. Determine the cash disbursements for manufacturing overhead for November. Show your work! b. Determine the predetermined overhead rate for November. Show your work!

The Gerald Corporation makes and sells a single product called a Clop. Each Clop requires 1.1 direct labor-hours at $8.20 per direct labor-hour. The direct labor workforce is fully adjusted each month to the required workload. The company is preparing a Direct Labor Budget for the first quarter of the year. If the budgeted direct labor cost for February is $162,360, then the budgeted production of Clops for February is:

Carter Lumber sells lumber and general building supplies to building contractors in a medium-sized town in Montana. Data regarding the store's operations follow: o Sales are budgeted at $380,000 for November, $390,000 for December, and $400,000 for January. O Collections are expected to be 70% in the month of sale, 27% in the month following the sale, and 3% uncollectible. O The cost of goods sold is 65% of sales. O The company desires to have an ending merchandise inventory equal to 80% of the following month's cost of goods sold. Payment for merchandise is made in the month following the purchase. O Other monthly expenses to be paid in cash are $22,000. O Monthly depreciation is $20,000. O Ignore taxes. The net income for December would be:

Trumbull Corporation budgeted sales on account of $120,000 for July, $211,000 for August, and $198,000 for September. Experience indicates that none of the sales on account will be collected in the month of the sale, 60% will be collected the month after the sale, 36% in the second month, and 4% will be uncollectible. The cash receipts from accounts receivable that should be budgeted for September would be:

Bracken Corporation is a small wholesaler of gourmet food products. Data regarding the store's operations follow: o Sales are budgeted at $330,000 for November, $340,000 for December, and $340,000 for January. O Collections are expected to be 80% in the month of sale, 17% in the month following the sale, and 3% uncollectible. O The cost of goods sold is 75% of sales. O The company would like to maintain ending merchandise inventories equal to 70% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase. O Other monthly expenses to be paid in cash are $21,800. O Monthly depreciation is $19,000. O Ignore taxes. December cash disbursements for merchandise purchases would be:

The selling and administrative expense budget of Ruffing Corporation is based on budgeted unit sales, which are 4,800 units for February. The variable selling and administrative expense is $8.10 per unit. The budgeted fixed selling and administrative expense is $71,520 per month, which includes depreciation of $16,800 per month. The remainder of the fixed selling and administrative expense represents current cash flows. The cash disbursements for selling and administrative expenses on the February selling and administrative expense budget should be:

Richards Corporation has the following budgeted sales for the first half of next year: The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: The accounts receivable balance on January 1 is $70,000. Of this amount, $60,000 represents uncollected December sales and $10,000 represents uncollected November sales. What is the budgeted accounts receivable balance on May 30?

The Prattle Corporation makes and sells only one product called a Deb. The company is in the process of preparing its Selling and Administrative Expense Budget for next year. The following budget data are available: All of these expenses (except depreciation) are paid in cash in the month they are incurred. If the company has budgeted to sell 20,000 Debs in March, then the average budgeted selling and administrative expenses per unit sold for March is closest to:

On a cash budget, the total amount of budgeted cash payments for manufacturing overhead should not include any amounts for depreciation on factory equipment.