Exam 9: Profit Planning

Pardise Company plans the following beginning and ending inventory levels (in units) for July: Two units of raw material are needed to produce each unit of finished product. -If Pardise Company plans to sell 480,000 units during July, the number of units it would have to manufacture during July would be:

The beginning cash balance is not included on the cash budget because the cash budget deals exclusively with cash flows rather than with balance sheet amounts.

The Tobler Company has budgeted production for next year as follows: Four pounds of raw materials are required for each unit produced. Raw materials on hand at the start of the year total 4,000 pounds. The raw materials inventory at the end of each quarter should equal 10% of the next quarter's production needs. Budgeted purchases of raw materials in the third quarter would be:

Dano Inc. bases its manufacturing overhead budget on budgeted direct labor-hours. The variable overhead rate is $1.50 per direct labor-hour. The company's budgeted fixed manufacturing overhead is $110,200 per month, which includes depreciation of $28,880. All other fixed manufacturing overhead costs represent current cash flows. The direct labor budget indicates that 7,600 direct labor-hours will be required in December. -The December cash disbursements for manufacturing overhead on the manufacturing overhead budget should be:

The Waverly Company has budgeted sales for next year as follows: The ending inventory of finished goods for each quarter should equal 25% of the next quarter's budgeted sales in units. The finished goods inventory at the start of the year is 3,000 units. Scheduled production for the third quarter should be:

Super Drive is a computer hard drive manufacturer. The company's balance sheet for the fiscal year ended on November 30 appears below: Additional information regarding Super Drive's operations appear below: • Sales are budgeted at $520,000 for December and $500,000 for January. • Collections are expected to be 60% in the month of sale and 40% in the month following sale. There are no bad debts. • 80% of the disk drive components are purchased in the month prior to the month of the sale, and 20% are purchased in the month of the sale. Purchased components comprise 40% of the cost of goods sold. • Payment for components purchased is made in the month following the purchase. • Assume that the cost of goods sold is 80% of sales. -The budgeted cash collections for the upcoming December should be:

The Adams Company, a merchandising firm, has budgeted its activity for November according to the following information: $\bullet$ Sales at $450,000, all for cash $\bullet$ Merchandise inventory on October 31 was $200,000. $\bullet$ The cash balance November 1 was $18,000. $\bullet$ Selling and administrative expenses are budgeted at $60,000 for November and are paid for in cash. $\bullet$ Budgeted depreciation for November is $25,000. $\bullet$ The planned merchandise inventory on November 30 is $230,000. $\bullet$ The cost of goods sold is 70% of the selling price. $\bullet$ All purchases are paid for in cash. -The budgeted cash receipts for November are:

Crose Inc. is working on its cash budget for November. The budgeted beginning cash balance is $22,000. Budgeted cash receipts total $118,000 and budgeted cash disbursements total $116,000. The desired ending cash balance is $40,000. -To attain its desired ending cash balance for November, the company needs to borrow:

Castil Corporation makes and sells a product called a Miniwarp. One Miniwarp requires 2.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 20% of the following month's production needs. On July 31, this requirement was not met since only 9,700 kilograms of Jurislon were on hand. The cost of Jurislon is $5.00 per kilogram. The company wants to prepare a Direct Materials Purchase Budget for the next five months. -The total cost of Jurislon to be purchased in August is:

In the manufacturing overhead budget, the non-cash charges (such as depreciation) are added to the total budgeted manufacturing overhead to determine the expected cash disbursements for manufacturing overhead.

The selling and administrative expense budget of Hiser Corporation is based on the number of units sold, which are budgeted to be 1,900 units in August. The variable selling and administrative expense is $6.10 per unit. The budgeted fixed selling and administrative expense is $22,420 per month, which includes depreciation of $5,130. The remainder of the fixed selling and administrative expense represents current cash flows. Required: Prepare the selling and administrative expense budget for August.

ABC Company has a cash balance of $9,000 on April 1. The company must maintain a minimum cash balance of $6,000. During April expected cash receipts are $45,000. Expected cash disbursements during the month total $52,000. During April the company will need to borrow:

A sales budget is given below for one of the products manufactured by the Key Co.: The inventory of finished goods at the end of each month must equal 20% of the next month's sales. On December 31, the finished goods inventory totaled 4,000 units. Each unit of product requires three specialized electrical switches. Since the production of these specialized switches by Key's suppliers is sometimes irregular, the company has a policy of maintaining an ending inventory at the end of each month equal to 30% of the next month's production needs. This requirement had been met on January 1 of the current year. Required: Prepare a budget showing the quantity of switches to be purchased each month for January, February, and March and in total for the quarter.

Roberts Enterprises has budgeted sales in units for the next five months as follows: Past experience has shown that the ending inventory for each month must be equal to 10% of the next month's sales in units. The inventory on May 31 contained 410 units. The company needs to prepare a production budget for the second quarter of the year. -The total number of units to be produced in July is:

Detmer Enterprises has budgeted sales for the next five months as follows: Past experience has shown that the ending inventory for each month should be equal to 10% of the next month's sales in units. The inventory on December 31 contained 400 units, which was in excess of the desired level of inventory. The company needs to prepare a Production Budget for the first quarter of the year. -The total number of units to be produced in January is:

Dilom Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow: Sales are budgeted at $260,000 for November, $230,000 for December, and $210,000 for January. Collections are expected to be 55% in the month of sale, 40% in the month following the sale, and 5% uncollectible. The cost of goods sold is 80% of sales. The company purchases 50% of its merchandise in the month prior to the month of sale and 50% in the month of sale. Payment for merchandise is made in the month following the purchase. Other monthly expenses to be paid in cash are $21,700. Monthly depreciation is $17,000. Ignore taxes. -The net income (loss) for December would be:

In the selling and administrative budget, the non-cash charges (such as depreciation) are deducted from the total budgeted selling and administrative expenses to determine the expected cash disbursements for selling and administrative expenses.

Payment Inc. is preparing its cash budget for February. The budgeted beginning cash balance is $27,000. Budgeted cash receipts total $136,000 and budgeted cash disbursements total $128,000. The desired ending cash balance is $50,000. The company can borrow up to $110,000 at any time from a local bank, with interest not due until the following month. Required: Prepare the company's cash budget for February in good form. Make sure to indicate what borrowing, if any, would be needed to attain the desired ending cash balance.

Marple Company's budgeted production in units and budgeted raw materials purchases over the next three months are given below: Two pounds of raw materials are required to produce one unit of product. The company wants raw materials on hand at the end of each month equal to 30% of the following month's production needs. The company is expected to have 36,000 pounds of raw materials on hand on January 1. Budgeted production for February should be:

A self-imposed budget or ________________ budget is a budget that is prepared with the full cooperation of managers at all levels.