Select Page

## Medium to Hard Practice Test

1. To determine the cost of raw materials that must be purchased this period, a company must take

a. the quantity of raw materials on hand and add the change in raw materials inventory and multiply by the cost per unit of raw materials
b. the quantity of raw materials on hand and add beginning raw materials inventory and multiply by the cost per unit of raw materials
c. the quantity required for production and the change in finished goods inventory times the cost per each
d. units to be produced times the quantity required for each, consider the change in raw materials inventory and then multiply by the cost of each raw material

D. The formula: Units to be produced x quantity required for each unit = material quantity required. Quantity required less what is already on hand (beginning raw materials) plus what is desired to be left at the end of the period (ending inventory) equals quantity to be purchased. Quantity to be purchased is then multiplied by the cost per unit to get budgeted total materials cost for the period. The change in inventory is the same thing as ending less beginning inventory. Finished goods and raw materials are never mixed in the budget process.

2. Which of the following statements is correct relating to the preparation of the manufacturing overhead budget?

a. budgeted costs should be directly proportionate to the increase in sales over last year. If sales are increasing 20%, the manufacturing overhead
budget will be increased 20% over last year
b. cost behavior for costs must be determined
c. it is prepared prior to the sales budget
d. all manufacturing overhead costs are considered to be disbursements in the period incurred

B. Manufacturing overhead consists of both fixed and variable costs. You must determine a variable cost per unit and a fixed cost in total. The sales budget is the first budget that must be completed. (c.) Depreciation is not paid, therefore all costs are not cash disbursements. (d) (a.) describes what occurs when a company only has variable manufacturing costs which is very very rare.

`3. A company has cash sales of \$20,000 each month and has credit `
 January February March April \$69,000 \$47,000 \$73,000 \$52,000

sales as follows:
Normally, 15% of credit sales are collected in the month of the sale,
55% are collected the month following the sale, and 38% is collected
the second month following the sale. Cash receipts from customers
during April is expected to be:

a. \$85,810
b. \$47,950
c. \$65,810
d. \$66,960

```A. During April, the company will collect
15% of April sales \$52,000 =             \$  7,800
55% of March sales \$73,000 =          \$40,150
38% of February sales \$47,000 =     \$17,860
Total collected in April                \$65,810
+ Cash Sales                              \$20,000
Total Cash Collected                  \$85,810```

4. The sales price per unit is necessary to prepare the

b. cash collections budget
c. sales budget
d. both b. & c.

D. The sales price per unit is used to determine the sale budget – sales in units x price per unit. The sales budge is then used along with when funds are typically collected from customer to determine the cash collections budget.

5. A company sells a unit of product for \$20 and the total cost of production is \$12 per unit. Sales, all cash, for March are expected to be \$1,000,000, total cash  disbursements for March are budgeted at \$1,050,000. The company can borrow at a rate of 12% per year in increments of \$5,000 at the beginning of each month. All borrowings occur at the beginning of the month and interest is paid for the month at the end of the same month. The company desires a minimum cash balance of  \$20,000 and the cash balance on March 1 was \$24,000. At the end of the prior month, the company owed \$35,000. The expected amount to be borrowed on March 1st is

a. \$25,000
b. \$50,000
c. \$75,000
d. \$20,000

```B.                       Beginning cash balance                   \$     24,000
Collections from customers             \$1,000,000
Cash Disbursements                      (\$1,050,000)
Cash balance before borrowing   (\$     26,000)
Borrowings                                       \$      50,000
Interest Paid end of month              \$          (850)
Cash balance end of month              \$     23,150```
`                  Interest     \$35,000 +\$50,000 x 12% x 1/12 = \$850`

6. A company makes and sells one product for \$18 each. Each unit made requires .75 labor direct labor hours. Direct labor is paid \$10 per hour. The direct labor budget is \$38,100 for this month. The budgeted units to be produced is

a. 2,857
b. 3,810
c. 5,080
d. not enough information to determine

```C. Put in what you know into the formula:
Units to produce                            5,080    ? solved
X required for one unit                    .75
= direct labor hours required        3,810    ? solved
X rate per direct labor hour            \$10
= direct labor dollars                   \$38,100

Solve working up from the bottom```

7. Depreciation on production equipment would be used in preparing which of the following budgets?

b. cash budget
c. sales budget
d. production budget

A. Depreciation expense must be considered in the manufacturing overhead budget. Depreciation is not paid and must be subtracted to determine cash paid for the period. Production units only is used in the manufacturing overhead budget. The cash budget shows only cash inflows and cash outflows and depreciation is not a cash flow.

8. Which of the following won’t be affected just because sales in units are lower at the end of this month than expected?

a. cash receipts for next month
b. finished goods inventory at the end of this month
c. the level of production next month
d. the level of production this month

D. The company will determine the level of production this month based on projected sales for next month and future months, not actual sales. Cash receipts will be less if sales are less (a.), inventory will be higher if sales are less (b), and the company will most likely produce less next month if inventory levels are higher than planned. (c.)

9. When a company produces the same quantity each month and sales randomly fluctuate each month it

a. will always have more funds tied up in inventory than necessary
b. will have volatile inventory balances
c. will have a stable cash balance
d. will have a volatile purchases budget

B. Inventory will go up when sales are lower and will go down when sales are higher when production is constant. Sometimes inventory will be too low and other times it will be too high. Lower levels of inventory will not tie up as much cash. (a.) The cash balance will fluctuate as funds are tied up and released from inventory. (c.) Purchases will be constant if production is constant. (d.)

10. Which of the following will be impacted less if actual production for the month is higher than budgeted production for the month?

a. materials disbursements for next month
b. inventory levels at the end of the month
c. direct labor costs for the month
d. sales for the month

D. The quantity of units produced will impact the amount of materials that are purchased and direct labor used in production and how much inventory is left at the end of the period. If you produce more than expected you will have more units left than expected given sales are as expected. Sales are not typically impacted when production is higher than budgeted, given there are enough units to fill orders from customers.

11. A company makes a product using wire and nylon material. Each product requires 1.5 feet of wire and 2.3 yards of nylon material. Ending finished goods is budgeted at 60% of next months sales. Ending raw materials quantity is budgeted at 120% of next months production in units. Wire costs \$4 per foot and nylon costs \$6.50 per yard.
Purchases are paid 20% in the month following the purchase and 80% in the second month following the purchase. Accounts Payable at the end of February is \$279,000. The product is sold for \$16. Budgeted sales are:

 Units January 10,000 February 15,000 March 18,000 April 14,000 May 11,000 June 12,000

Prepare the following budgets for the months of March and April:
A. Production budget
B. Materials requirement budget for both wire and nylon
C. Materials purchases budget for both wire and nylon

`A. Production Budget`
 February March April May Budgeted Sales in Units 15,000 18,000 14,000 11,000 + Desired Ending Inventory in Units 10,800 8,400 6,600 7,200 – Beginning Inventory in Units (9,000) (10,800) (8,400) (6,600) = Required Production in Units 16,800 15,600 12,200 11,600

February beginning units is January ending which is equal to Feb sales x 60%
May ending inventory is June sales of 12,000 x 60% = 7,200

B. Materials Budget Wire

 February March April Required Production in Units 16,800 15,600 12,200 X Quantity Required Per Unit (yards) 1.5 1.5 1.5 = Units of Raw Mat. for Production 25,200 23,400 18,300 + Desired Ending Inventory of Raw Mat. 18,720 14,640 13,920 – Beginning Inventory of Raw Materials (18,720) (14,640) = Raw Materials to be Purchased – units 19,320 17,580 X cost per yard \$4.00 \$4.00 = Raw materials dollars – purchased \$77,280 \$70,320

Raw materials ending inventory is 120% of next months production in units, not raw materials required for production. Read the problem carefully.
April ending inventory is May units to produce of 11,600 x 1.2 = \$13,920

B. Materials Budget
Nylon

 February March April Required Production in Units 16,800 15,600 12,200 X Quantity Required Per Unit (yards) 2.3 2.3 2.3 = Units of Raw Mat. for Production 38,640 35,880 28,060 + Desired Ending Inventory of Raw Mat. 18,720 14,640 13,920 – Beginning Inventory of Raw Materials (18,720) (14,640) = Raw Materials to be Purchased – units 31,800 27,340 X cost per yard \$6.50 \$6.50 = Raw materials dollars – purchased \$206,700 \$177,170

C. Materials Purchase Budget:

```                                              March                 April
Wire                                    \$ 77,280           \$70,320
Nylon				  \$206,700          \$177,710
Total Purchased		  \$283,980           248,030

Amounts Paid In:
Dollars owed	   	  March			April```
```February A/P:	             279,000                  279,000
March purchases             283,980                   56,796                 227,184
April purchases                248,030                                                49,606
Total Disbursements:			        \$335,796                \$276,790

```

12. A company has budgeted sales and production for a 3 month period as follows:

 July August September Units Sold 10,000 20,000 15,000 Units to produce 22,000 18,000 14,000
 Additional information that is available: Sales price per unit \$10 Direct material cost per unit \$3.00 Direct labor cost per unit \$1.50 Paid manufacturing overhead cost per unit \$  2.00 Cash on hand on August 1 \$51,750

The quantity of inventory does not change from month to month.
Inventory purchases are paid 20% current month, 80% following month
Accounts receivable is collected 10% current month, 90% following month

Disbursements for selling and administrative is \$45,000, which includes \$3,000 for depreciation on furniture.

The company borrows monthly at a rate of 12% annually in order to keep the cash balance at a minimum of \$50,000. Borrowings are in increments of \$1,000 and are made at the beginning of the month. Interest is paid at the end of the month. The company owed \$62,000 on July 31st.

Prepare a cash budget for the month of August.

 August Cash Balance, Beginning \$51,750 + Receipts for the Period (Cash Collections) \$110,000 = Total Cash Available \$161,750 – Disbursements for Material (Cash Disb.) \$63,600 – Disbursements for Labor and O/H \$63,000 – Disbursements for Selling and Administrative \$42,000 = Cash Available (\$6,850) + Borrowings \$59,000 – Repayment of Borrowings 0 – Interest Expense Paid (\$1,210) = Cash Balance, Ending \$50,940
```Receipts: July sales 10,000 units x \$10= \$100,000 x 90% =        \$90,000
August sales 20,000 units x \$10 = \$200,000 x 10% = \$20,000
Total cash collections in August                     \$110,000```
```When the quantity in inventory does not change purchased units are equal to units
produced.```
```Materials disbursements:
July production 22,000 units x \$3= \$66,000 x 80%        = \$52,800
August production 18,000 units x \$3 = \$54,000 x 20% = \$10,800
Total cash disbursements in August                  \$63,600```
`Labor & O/H:   August production 18,000 x \$3.50 per unit = 63,000`
`Interest Expense   \$62,000 + \$59,000 = \$121,000 owed x 12% x 1/12 = \$1,210`

13. A company is preparing budgets and has progressed far enough to gather the following information:

 Jan Feb Mar April May Sales \$ \$42,000 \$59,000 \$62,000 \$39,000 \$36,000 Material Purchase \$ \$41,000 \$47,000 \$37,000 \$32,000 \$49,000

The company expects to collect accounts receivable as follows: 5% in the current
month, 35% in the month following the sale, and 55% in the second month after sale

The company expects to pay for inventory as follows: 25% in the current month and
70% in the month after purchase, and 5% in the second month following purchase

A. Prepare the cash disbursements schedule for March and April

B. Prepare the cash receipts schedule for March and April

A. Cash Disbursements:

 Amounts Paid In: Dollars owed March April January purchases \$41,000 5% February purchases \$47,000 70% 5% March purchases \$37,000 25% 70% April purchases \$32,000 25%
```Now that you know what percent is coming in, take the amount on the left in the row
times the % on the same row to get the dollars that will be collected during that month.```
 Amounts Paid In: Dollars owed January February January purchases \$41,000 2,050 February purchases \$47,000 32,900 2,350 March purchases \$37,000 9,250 25,900 April purchases \$32,000 ______ 8,000 Total \$44,200 \$36,250
`B. Cash Receipts Schedule: `
`Set up the schedule as follows:`
 Amounts Paid In: Dollars owed March April January sales \$42,000 55% February sales \$59,000 35% 55% March sales \$62,000 5% 35% April sales \$39,000 5%

Now that you know what percent is coming in, take the amount on the left in the row times the % on the same row to get the dollars that will be collected during that month.

 Amounts Paid In: Dollars owed March April January sales \$42,000 \$23,100 February sales \$59,000 \$20,650 \$32,450 March sales \$62,000 \$3,100 \$21,700 April sales \$39,000 ______ \$1,950 Total: \$46,850 \$56,100