Exam 22: The Master Budget and Responsibility Accounting

Lan Corporation had beginning inventory of $42,000 and expects cost of sales of $96,000 units during the month. Desired ending inventory is $31,000. How much inventory should Lan Corporation purchase?

California Products Company has the following data as part of its budget for the 2^nd quarter: Apr May Jun Cash collections \ 30,000 \ 32,000 \ 36,000 Cash payments: Purchases of inventory 4,500 4,600 3,800 Operating expenses 7,200 7,600 8,000 Capital expenditures 0 24,500 5,200 The cash balance at April 1 is forecast to be $8,200. -Assume that there will be no financing transactions or costs during the quarter. Based on the above information only, what will the cash balance be at April 30?

Michael McNaulty is responsible for running the accounting department of a large manufacturing company. The company has multiple divisions and multiple products. McNaulty's business unit would most accurately be described as a(n):

Henderson Industrial Products uses a centralized service department for procurement of raw materials, servicing all three of its divisions-Construction, Manufacturing, and Military. The Construction Division has been allocated a total of $192,000 of costs from the procurement department. Of that amount, 75% is considered traceable to the three product types within the division-Civil Construction, Residential Construction, and Commercial Construction. The division will calculate an allocation rate to assign the traceable costs to each of the three product types based on number of purchase orders processed within each product type. Please refer to the following information: Construction Division Product lines Revenues Variable Expenses Purchase Orders Civil \ 36,000 \ 24,000 450 Residential \ 98,000 \ 41,000 900 Commerdal \ 216,000 \ 60,000 1,850 Total \ 360,000 \ 125,000 3,200 -The allocation rate for the three product lines should be:

When a company is preparing a budgeted statement of cash flows and they wish to calculate the payments for operating expenses, they should refer to which of the following?

AAA Company is preparing its 3rd quarter budget and provides the following data: Jul Aug Sep Cash collections \ 50,000 \ 40,000 \ 48,000 Cash payments: Purchases of inventory 31,000 22,000 18,000 Operating expenses 12,000 9,000 11,600 Capital expenditures 13,000 25,000 0 Cash balance at June 30 is projected to be $4,000. The company is required to maintain a minimum cash balance of $5,000 and is authorized to borrow at the end of each month to make up any shortfalls. It may borrow in increments of $5,000 and pays interest monthly at an annual rate of 5%. All financing transactions are assumed to take place at the end of the month. Loan balance should be repaid in increments of $5,000 when there is surplus cash. - How much cash shortfall will the company have at the end of July, before financing?

A company has prepared the operational budget and the cash budget and is now preparing the budgeted balance sheet. To provide the balance for the Cash account, which document should be used?

AAA Company is preparing its 3rd quarter budget and provides the following data: Jul Aug Sep Cash collections \ 50,000 \ 40,000 \ 48,000 Cash payments: Purchases of inventory 31,000 22,000 18,000 Operating expenses 12,000 9,000 11,600 Capital expenditures 13,000 25,000 0 Cash balance at June 30 is projected to be $4,000. The company is required to maintain a minimum cash balance of $5,000 and is authorized to borrow at the end of each month to make up any shortfalls. It may borrow in increments of $5,000 and pays interest monthly at an annual rate of 5%. All financing transactions are assumed to take place at the end of the month. Loan balance should be repaid in increments of $5,000 when there is surplus cash. - What is the projected cash shortfall at the end of August, before financing transactions have been taken into consideration?

Norton Company prepared the following sales budget: Month Budgeted Sales March \ 200,000 April \ 180,000 May \ 220,000 June \ 260,000 Cost of goods sold is budgeted at 60% of sales, and the inventory at the end of February was $36,000. Desired inventory levels at the end of each month are 30% of the next month's cost of goods sold. - What is the desired beginning inventory on June 1?

The capital expenditure budget is part of the operating budget.

Craig Manufacturing Company's budgeted income statement includes the following data: Data extracted from budgeted income statement Mar Apr May Jun Sales \ 120,000 \ 90,000 \ 95,000 \ 100,000 Commission exp. - 15\% of sales 18,000 13,500 14,250 15,000 Salary exp 30,000 30,000 30,000 30,000 Miscellaneous expense - 4\% of sales 4,800 3,600 3,800 4,000 Rent expense 3,600 3,600 3,600 3,600 Utility expense 1,900 1,900 1,900 1,900 Insurance expense 2,100 2,100 2,100 2,100 Depreciation expense 4,400 4,400 4,400 4,400 The budget assumes that 60% of commission expenses are paid in the month they were incurred and the remaining 40% are paid one month later. In addition, 50% of salary expenses are paid in the month incurred and the remaining 50% are paid one month later. Miscellaneous expenses, rent expense and utility expenses are assumed to be paid in the same month in which they are incurred. Insurance was prepaid for the year on January 1. - How much is the total of the budgeted cash payments for operating expenses for the month of June?

California Products Company has the following data as part of its budget for the 2^nd quarter: Apr May Jun Cash collections \ 30,000 \ 32,000 \ 36,000 Cash payments: Purchases of inventory 4,500 4,600 3,800 Operating expenses 7,200 7,600 8,000 Capital expenditures 0 24,500 5,200 The cash balance at April 1 is forecast to be $8,200. -Assume that there will be no financing transactions or costs during the quarter. Based on the above information only, what will the cash balance be at June 30?

Argyle Company forecasts sales of $50,000 in January, $60,000 in February, $70,000 in March, and $75,000 in April. The inventory balance at January 1 is $12,000. Cost of goods sold is budgeted at 40% of sales revenue. Argyle wishes to have inventory levels at the end of each month equal to 60% of cost of goods sold for the following month, plus a "safety cushion" of $1,000. How much should be budgeted for inventory purchases in February?

Mudbug International has budgeted inventory purchases as follows: Apr May Jun Budgeted purchases \ 80,000 \ 75,000 \ 70,000 The budget assumes that 50% of a given month's purchases are paid in the month of purchase, and the remaining 50% is paid out one month later. Accounts payable to inventory suppliers at March 31 was $38,000. Please use the format below and prepare the budgeted cash payments for inventory purchases. Budgeted Cash Payments for Inventory Apr May Jun Purchases 50\% of previous month purchases 50\% of current month purchases Total cash payments

Charter Company is preparing their budget for the 1^st quarter of 2012. The following data is provided: Inventory, Purchases and COGS Budget Jan Feb Mar Cost of goods sold (a) \ 30,000 \ 28,500 \ 22,500 Desired ending inventory(b) 10,700 9,500 9,800 Total inventory required 40,700 38,000 32,300 ess Beginning inventory (11,000 (10,700) (9,500 Purchases 29,700 27,300 22,800 (a) $\operatorname{COGS}=75 \%$ of sales (b) $\$ 5.000+20 \%$ of COGS for next month For the budgeted balance sheet at March 31, what amount should be shown for Inventory?

The production budget must be prepared before any other component of the operating budget.

Dahl Manufacturing is making its operating budget for the 4^th quarter of 2012. Sales are forecast at $60,000 in October, $65,000 in November, and $70,000 in December. Cost of goods sold it 40% of sales. Expenses are budgeted as follows: Variable: Miscellaneous: 5\% of sales Fixed: Salary expense: \ 12,600 per month Rent expense: \ 5,200 per month Depreciation expense: \ 4,000 per month Admin expense: \ 5,000 per month - How much are the total operating expenses in November?

The capital expenditure budget stands alone and is not part of either the operating budget or the financial budget.

Berkeley Products has a cash balance of $20,000 at April 1, 2011. They are now preparing the cash budget for the second quarter. Budgeted cash collections and payments are as follows: Apr May Jun Cash collections \ 12,000 \ 9,000 \ 10,500 Cash payments: Purchases of inventory 4,600 4,200 4,000 Operating expenses 5,000 5,200 4,800 There are no budgeted capital expenditures or financing transactions during the quarter. - Based on the above data, what is the projected cash balance at the end of April?

Henderson Industrial Products uses a centralized service department for procurement of raw materials, servicing all three of its divisions-Construction, Manufacturing, and Military. The total monthly costs of the procurement department are $480,000. Of these costs, 80% are traceable to the divisions, and 20% are considered untraceable. Henderson has decided to assign the traceable costs to the divisions based on number of purchase orders processed. Below is a list of the purchase orders per division. Divisions Purchase Orders Construction 3,200 Manufacturing 2,400 Military 800 Total 6,400 - How much of the procurement department's cost should be assigned to the Construction Division?