Exam 23: Master Budgets and Planning

Barrett's Fashions forecasts sales of $125,000 for the quarter ended December 31. Its gross profit rate is 20% of sales, and its September 30 inventory is $32,500. If the December 31 inventory is targeted at $41,500, budgeted purchases for the fourth quarter should be:

A budget is best described as:

The Palos Company expects sales for June, July, and August of $48,000, $54,000, and $44,000, respectively. Experience suggests that 40% of sales are for cash and 60% are on credit. The company collects 50% of its credit sales in the month following sale, 45% in the second month following sale, and 5% are not collected. What are the company's expected cash receipts for August from its current and past sales?

Keegan Company manufactures a single product and has a JIT policy that ending inventory must equal 10% of the next month's sales. It estimates that May's ending inventory will consist of 20,000 units. June and July sales are estimated to be 280,000 and 290,000 units, respectively. Compute the number of units to be produced that would appear on the company's production budget for the month of June.

The task of preparing a budget should be the sole task of the most important department in an organization.

A ________________________ is a continuously revised budget that adds future months or quarters to replace months or quarters that have lapsed.

A company's history indicates that 20% of its sales are for cash and the rest are on credit. Collections on credit sales are 20% in the month of the sale, 50% in the next month, and 30% the following month. Projected sales for January, February, and March are $75,000, $92,000 and $60,000, respectively. The March expected cash receipts from all current and prior credit sales are $80,500.

Bentels Co. desires a December 31 ending inventory of 2,840 units. Budgeted sales for December are 4,000 units. The November 30 inventory was 1,800 units. Budgeted purchases are:

The financial budgets include the cash budget and the capital expenditures budget.

Grafton is preparing a cash budget for June. The company has $25,000 cash at the beginning of June and anticipates $95,000 in cash receipts and $111,290 in cash disbursements during June. Compute the amount the company must borrow, if any, to maintain a $20,000 cash balance. The company has no loans outstanding on June 1.

The most useful budget figures are developed:

Long-term liability data for the budgeted balance sheet is derived from:

Use the following information to prepare a budgeted income statement for Arbor Company for the month of June. a. Beginning cash balance on June 1 is $52,000. b. Cash receipts from sales: 40% is collected in the month of sale, 50% in the next month, and 10% in the second month after sale (uncollectible accounts are negligible and can be ignored). Sales amounts are: April (actual), $1,450,000, May (actual), $1,600,000, and June (budgeted), $1,700,000. c. Payments on merchandise purchases: 80% in the month of purchase and 20% in the month following purchase. Purchases amounts are May (actual), $830,000; and June (budgeted), $867,000. d. Budgeted cash disbursements for salaries in June: $260,000. Salaries payable on May 31 are $60,000 and are expected to be $50,000 on June 30. e. Budgeted depreciation expense for June: $24,000. f. Other cash expenses budgeted for June: $282,000. g. Accrued income taxes due in June: $48,000. h. Bank loan interest due in June: $8,000 which represents the 1% monthly expense on a bank loan of $800,000. i. Loan payment of $50,000 if the preliminary cash balance is greater than $100,000. j. Cost of goods sold is 53% of sales. k. The income tax rate applicable to the company is 30%.

Briefly describe a master budget and the sequence in which the individual budgets within the master budget are prepared.

Use the following data to determine the company's cash disbursements for each month of August and September:

The practice of preparing budgets for each of several future periods and revising those budgets as each period is completed, adding a new budget each period so that the budgets always cover the same number of future periods, is called:

The sales budget for Carmel shows that 20,000 units of Product A and 22,000 units of Product B are going to be sold for prices of $10 and $12, respectively. The desired ending inventory of Product A is 20% higher than its beginning inventory of 2,000 units. The beginning inventory of Product B is 2,500 units. The desired ending inventory of B is 3,000 units. Total budgeted sales of both products for the year would be:

Clic, Inc., provides the following data for the next four months: Desired Ending Inventory: Raw Materials = 30% of next month's production needs Finished Goods = 20% of next month's sales Pounds of raw material required for each finished Unit = 5 lbs. Required: Calculate the amount of purchases of raw materials in pounds for April and May.

The manufacturing budget shows only the direct materials needed for production.

Harold's expects its September sales to be 20% higher than its August sales of $150,000. Purchases were $100,000 in August and are expected to be $120,000 in September. All sales are on credit and are collected as follows: 30% in the month of the sale and 70% in the following month. Merchandise purchases are paid as follows: 25% in the month of purchase and 75% in the following month. The beginning cash balance on September 1 is $7,500. The ending cash balance on September 30 would be: