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

Muecke Inc. is working on its cash budget for April. The budgeted beginning cash balance is $40,000. Budgeted cash receipts total $150,000 and budgeted cash disbursements total $158,000. The desired ending cash balance is $50,000. The excess (deficiency) of cash available over disbursements for April will be:

The manufacturing overhead budget at Amrein Corporation is based on budgeted direct labor-hours. The direct labor budget indicates that 4,900 direct labor-hours will be required in August. The variable overhead rate is $9.40 per direct labor-hour. The company's budgeted fixed manufacturing overhead is $96,040 per month, which includes depreciation of $7,350. All other fixed manufacturing overhead costs represent current cash flows. The August cash disbursements for manufacturing overhead on the manufacturing overhead budget should be:

The first budget a company prepares in a master budget is the production budget.

For July, White Corporation has budgeted production of 6,000 units. Each unit requires 0.10 direct labor-hours at a cost of $8.50 per direct labor-hour. How much will White Corporation budget for labor in July?

On November 1, Barnes Corporation has 8,000 units of Product A on hand. During the month, the company plans to sell 30,000 units of Product A, and plans to have 6,500 units on hand at end of the month. How many units of Product A must be produced during the month?

The following are budgeted data: One pound of material is required for each finished unit. The inventory of materials at the end of each month should equal 20% of the following month's production needs. Purchases of raw materials for February would be budgeted to be:

Planning involves gathering feedback to ensure that the plan is being properly executed or modified as circumstances change.

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. Assume that on January 1 the inventory of Quickclean was 8,000 units. Expected sales in January are 14,000 units and expected sales in February are 18,000 units. The number of units needed to be produced in January would be:

Dilbert Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow: o Sales are budgeted at $260,000 for November, $230,000 for December, and $210,000 for January. O Collections are expected to be 80% in the month of sale, 19% in the month following the sale, and 1% uncollectible. O The cost of goods sold is 65% of sales. O The company desires to have an ending merchandise inventory at the end of each month equal to 60% 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 $20,300. O Monthly depreciation is $20,000. O Ignore taxes. Expected cash collections in December are:

Laurey Inc. is working on its cash budget for May. The budgeted beginning cash balance is $45,000. Budgeted cash receipts total $129,000 and budgeted cash disbursements total $124,000. The desired ending cash balance is $60,000. To attain its desired ending cash balance for May, the company needs to borrow:

Cashan Corporation makes and sells a product called a Miniwarp. One Miniwarp requires 1.5 kilograms of the raw material Jurislon. Budgeted production of Miniwarps for the next five months is as follows: The company wants to maintain monthly ending inventories of Jurislon equal to 30% of the following month's production needs. On July 31, this requirement was not met since only 10,400 kilograms of Jurislon were on hand. The cost of Jurislon is $4.00 per kilogram. The company wants to prepare a Direct Materials Purchase Budget for the next five months. The desired ending inventory of Jurislon for September is:

Dilbert Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow: o Sales are budgeted at $260,000 for November, $230,000 for December, and $210,000 for January. O Collections are expected to be 80% in the month of sale, 19% in the month following the sale, and 1% uncollectible. O The cost of goods sold is 65% of sales. O The company desires to have an ending merchandise inventory at the end of each month equal to 60% 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 $20,300. O Monthly depreciation is $20,000. O Ignore taxes. The accounts receivable balance, net of uncollectible accounts, at the end of December would be:

Chow Corporation manufactures children's chairs made of PVS plastic tubing and heavy canvas material. Each chair requires eight feet of the PVC tubing and three yards of material. Budgeted sales are 20,000 chairs for June, 25,000 chairs for July and 30,000 chairs for August. Ending finished goods inventory is budgeted at 10% of the current month's sales. Ending materials inventories are budgeted at 10% of the current month's production. Required: a. Prepare a production budget for each of the months of June, July and August. Assume the beginning inventory of chairs in June will be 2,500 units. b. Prepare schedules showing purchase requirements for PVC tubing and for material for each of the months of June, July and August. Assume 16,000 feet of PVC tubing and 6,000 yards of material are on hand at the beginning of June.

In a merchandising company, the required merchandise purchases for a period are determined by subtracting the desired ending inventory from the sum of the units to be sold during the period and the units in beginning inventory.

Starg Corporation, a retailer, plans to sell 25,000 units of Product X during the month of August. If the company has 9,000 units on hand at the start of the month, and plans to have 7,000 units on hand at the end of the month, how many units of Product X must be purchased from the supplier during the month?

Sparks Corporation has a cash balance of $7,500 on April 1. The company must maintain a minimum cash balance of $6,000. During April, expected cash receipts are $48,000. Cash disbursements during the month are expected to total $52,000. Ignoring interest payments, during April the company will need to borrow:

Which of the following might be included as a disbursement on a cash budget?

Bredder Supply Corporation manufactures and sells cotton gauze. Expected sales of gauze (in boxes) for upcoming months are as follows: Management likes to maintain a finished goods inventory equal to 20% of the next month's estimated sales. Required: Prepare the company's production budget for the third quarter of this year (the months of July, August and September). Include a column for each month and a total column for the entire quarter.

Milano Corporation is working on its direct labor budget for the next two months. Each unit of output requires 0.50 direct labor-hours. The direct labor rate is $9.80 per direct labor-hour. The production budget calls for producing 6,400 units in October and 6,300 units in November. If the direct labor work force is fully adjusted to the total direct labor-hours needed each month, what would be the total combined direct labor cost for the two months?

Vandel Inc. bases its selling and administrative expense budget on budgeted unit sales. The sales budget shows 6,600 units are planned to be sold in April. The variable selling and administrative expense is $9.70 per unit. The budgeted fixed selling and administrative expense is $127,380 per month, which includes depreciation of $8,580 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 April selling and administrative expense budget should be: