Exam 7: Master Budgets and Performance Planning

Bengal Co. provides the following unit sales forecast for the next three months: The company wants to end each month with ending finished goods inventory equal to 25% of the next month's sales. Finished goods inventory on June 30 is 1,250 units. The budgeted production units for July are:

Part of the budgeting process is summarizing the financial statement effects on the budgeted income statement and the budgeted balance sheet.

Todd Enterprises is preparing a cash budget for the second quarter of the coming year. The following data have been forecasted: Additional data: (1) Sales are 40% cash and 60% credit. The collection pattern for credit sales is 50% in the month following the sale and 50% in the month thereafter. Total sales in March were $125,000. (2) Purchases are all on credit, with 40% paid in the month of purchase and 60% paid in the following month. (3) Operating expenses are paid in the month they are incurred. (4) A minimum cash balance of $25,000 is required at the end of each month. (5) Loans are used to maintain the minimum cash balance. At the end of each month, interest of 1% per month is paid on the outstanding loan balance as of the beginning of the month. Repayments are made at the end of the month if the cash balance exceeds $25,000. Prepare the company's cash budget for May. Show the ending loan balance at May 31.

Trago Company manufactures a single product and has a JIT policy that ending inventory must equal 5% of the next month's sales. It estimates that May's ending inventory will consist of 14,000 units. June and July sales are estimated to be 280,000 and 290,000 units, respectively. Trago assigns variable overhead at a rate of $1.80 per unit of production. Fixed overhead equals $400,000 per month. Compute the total budgeted overhead for June.

The sales budget is derived from the production budget.

Ruiz Co. provides the following unit sales forecast for the next three months: The company wants to end each month with ending finished goods inventory equal to 10% of the next month's sales. Finished goods inventory on December 31 is 300 units. The budgeted production units for January are:

Flagstaff Company has budgeted July production of 7,900 units. Variable factory overhead is $1.20 per unit. Budgeted fixed factory overhead is $19,000, which includes $3,000 of factory equipment depreciation. Compute the total budgeted overhead for July.

Lafayette Company's experience shows that 20% of its sales are for cash and 80% are on credit. An analysis of credit sales shows that 50% are collected in the month following the sale, 45% are collected in the second month, and 5% prove to be uncollectible. Calculate the following items (1) through (10).

The budgeted balance sheet is prepared primarily from data contained in the previously prepared components of the master budget.

Operating budgets include all the following budgets except the:

A merchandiser, provides the following information for its December budgeting process: The November 30 inventory was 1,800 units. Budgeted sales for December are 4,000 units. Desired December 31 inventory is 2,840 units. Budgeted purchases are:

The selling expenses budget is normally prepared before the sales budget because selling expenses affect the amount of sales.

Oxford, Inc., is preparing its master budget for the quarter ended June 30. It sells a single product for $40 each. Sales are 60% cash and 40% on credit. All credit sales are collected in the month following the sale. At March 31, the balance in accounts receivable is $12,000, which represents the uncollected balance on March sales. Budgeted unit sales for the next four months follows: The product cost is $20 per unit, and desired ending inventory is 60% of the following month's sales in units. Inventory at March 31 is 480 units. Purchases are paid 50% in the month of purchase and 50% in the following month. At March 31, the balance in accounts payable is $11,000, which represents the unpaid purchases from March. Operating expenses are paid in the month incurred and consist of: · Commissions (10% of sales) · Shipping (3% of sales) · Office salaries ($3,000 per month) · Rent ($5,000 per month) Depreciation is $2,000 per month. Income taxes are 40%, and will be paid on July 1. There are no taxes payable at March 31. A minimum cash balance of $12,000 is required, and the beginning cash balance is $12,000. Loans are obtained at the end of any month when a cash shortage occurs. Interest is 1% per month based on the beginning of the month loan balance and is paid at each month end. If the ending cash balance exceeds the minimum, the excess will be applied to repaying any outstanding loan balance. At March 31, the loan balance is $2,000. Prepare a master budget (round all dollar amounts to the nearest whole dollar) for each of the months of April, May, and June that includes the: · Sales budget · Schedule of cash receipts · Merchandise purchases budget · Schedule of cash payments for purchases of merchandise · Schedule of cash payments for selling and administrative expenses (combined) · Cash budget, including information on the loan balance · Budgeted income statement for the quarter

There are at least five benefits from budgeting. Identify two of these benefits: (1) ________ (2) ________

A plan that states the number of units to be produced in a future period, based on the projected unit sales and inventory considerations, is the: