7-221
7-222
158.
The following information is budgeted for McCracken Plumbing Supply Corporation for next
quarter:
April
May
June
Sales
$110,000
$130,000
$180,000
Merchandise purchases
$85,000
$92,000
$105,000
Selling and administrative expenses
$50,000
$50,000
$50,000
All sales at McCracken are on credit. Forty percent are collected in the month of sale, 58% in
the month following the sale, and the remaining 2% are uncollectible. Merchandise purchases
are paid in full the month following the month of purchase. The selling and administrative
expenses above include $8,000 of depreciation on display fixtures and warehouse equipment.
All other selling and administrative expenses are paid as incurred. McCracken wants to
maintain a cash balance of $15,000. Any amount below this can be borrowed from a local
bank as needed in increments of $1,000. All borrowings are made at month end.
Required:
Prepare McCracken’s cash budget for May. McCracken expects to have $24,000 of cash on
hand at the beginning of May.
Beginning cash balance
Add cash receipts:
Total cash available before current financing
Less disbursements:
42,000
Total disbursements
Excess of cash available over disbursements
3,000
Ending cash balance
7-223
159.
The Fraley Corporation, a merchandising firm, has planned the following sales for the next
four months:
March
April
May
June
Total budgeted
sales
$50,000
$70,000
$90,000
$60,000
Sales are made 40% for cash and 60% on account. From experience, the company has
learned that a month’s sales on account are collected according to the following pattern:
Month of sale
70%
First month following month of sale
20%
Second month following month of sale
8%
Uncollectible
2%
The company requires a minimum cash balance of $4,000 to start a month.
Required:
a. Compute the budgeted cash receipts for June.
b. Assume the following budgeted data for June:
Purchases
$52,000
Selling and administrative expenses
$10,000
Depreciation
$8,000
Equipment purchases
$15,000
Beginning cash balance of June
$6,000
Using this data, along with your answer to part (a) above, prepare a cash budget for June.
Clearly show any borrowing needed during the month. The company can borrow in any dollar
amount, but will not pay any interest until the following month.
7-224
7-225
160.
Bredder Supply Corporation manufactures and sells cotton gauze. Expected sales of gauze (in
boxes) for upcoming months are as follows:
June
35,000
July
39,000
August
41,000
September
37,000
October
34,000
November
33,000
December
36,000
Management likes to maintain a finished goods inventory equal to 20% of the next month’s
estimated sales.
Required:
Prepare the company’s production budget for the third quarter of this year (the months of July,
August and September). Include a column for each month and a total column for the entire
quarter.
7-226
161.
A sales budget is given below for one of the products manufactured by the OMI Co.:
January
25,000 units
February
40,000 units
March
65,000 units
April
45,000 units
May
35,000 units
June
30,000 units
The inventory of finished goods at the end of each month must equal 20% of the next month’s
sales. However, on December 31 the finished goods inventory totaled only 4,000 units.
Each unit of product requires three pounds of specialized material. Since the production of
this specialized material by OMI’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:
a. Prepare a budget showing the required production each month for January, February,
March, and April.
b. Prepare a budget showing the quantity of switches to be purchased each month for
January, February, and March.
7-227
7-228
162.
Chow Corporation manufactures children’s chairs made of PVS plastic tubing and heavy
canvas material. Each chair requires eight feet of the PVC tubing and three yards of material.
Budgeted sales are 20,000 chairs for June, 25,000 chairs for July and 30,000 chairs for
August. Ending finished goods inventory is budgeted at 10% of the current month’s sales.
Ending materials inventories are budgeted at 10% of the current month’s production.
Required:
a. Prepare a production budget for each of the months of June, July and August. Assume the
beginning inventory of chairs in June will be 2,500 units.
b. Prepare schedules showing purchase requirements for PVC tubing and for material for
each of the months of June, July and August. Assume 16,000 feet of PVC tubing and 6,000
yards of material are on hand at the beginning of June.
7-229
7-230
163.
Two yards of a fabric are required for each blouse produced by Northern Shirt Corporation.
The cost of the fabric is $4 per yard. Budgeted production of blouses is given below for the
fourth quarter and the first month of the following quarter.
October
November
December
January
Required production blouses
18,000
16,000
15,000
12,000
Required production (blouses)
16,000
15,000
Yards of fabric required per blouse
2
Add desired ending inventory of fabric
2,400
Total needs
35,000
32,400
Fabric to be purchased (yards)
31,800
29,400
To prevent against stock outs of the fabric, the company maintains an ending inventory each
month equal to 10% of the next month’s production needs. The beginning inventory of the
fabric in October will be 3,600 yards.
Required:
Prepare a direct materials budget for the fabric, by month and in total for the fourth quarter.
Be sure to include both the quantity to be purchased and its cost for each month.
7-231
164.
The production department of Tadris Corporation has submitted the following forecast of units
to be produced by quarter for the upcoming fiscal year.
1st
Qtr
2nd
Qtr
3rd
Qtr
4th
Qtr
Units to be
produced
12,000
11,500
11,000
10,500
Each unit requires 0.25 direct labor-hours at $18.00 per hour.
Required:
Prepare a direct labor budget for the upcoming fiscal year, assuming that the direct labor work
force is adjusted each quarter to match the number of hours required to produce the budgeted
production.
7-232
165.
Rehmer Corporation is working on its direct labor budget for the next two months. Each unit of
output requires 0.61 direct labor-hours. The direct labor rate is $8.90 per direct labor-hour. The
production budget calls for producing 2,600 units in June and 2,100 units in July.
Required:
Construct the direct labor budget for the next two months, assuming that the direct labor work
force is fully adjusted to the total direct labor-hours needed each month.
7-233
166.
Kouba Corporation is working on its direct labor budget for the next two months. Each unit of
output requires 0.23 direct labor-hours. The direct labor rate is $11.20 per direct labor-hour.
The production budget calls for producing 4,000 units in April and 3,400 units in May. The
company guarantees its direct labor workers a 40-hour paid work week. With the number of
workers currently employed, that means that the company is committed to paying its direct
labor work force for at least 920 hours in total each month even if there is not enough work to
keep them busy.
Required:
Construct the direct labor budget for the next two months.
7-234
167.
The direct labor budget of Faier Corporation for the upcoming year contains the following
details concerning budgeted direct labor-hours.
1st Qtr
2nd Qtr
3rd Qtr
4th Qtr
Budgeted direct labor-hours
8,000
8,200
8,500
8,800
The company’s variable manufacturing overhead rate is $3.50 per direct labor-hour, and the
company’s fixed manufacturing overhead is $65,000 per quarter. The only noncash item
included in the fixed manufacturing overhead is depreciation which is $22,000 per quarter.
Required:
Prepare Faier Corporation’s manufacturing overhead budget for the upcoming fiscal year.
Show both manufacturing overhead expense and cash disbursements for manufacturing
overhead.
7-235
168.
Edgington Inc. bases its manufacturing overhead budget on budgeted direct labor-hours. The
variable overhead rate is $4.90 per direct labor-hour. The company’s budgeted fixed
manufacturing overhead is $39,590 per month, which includes depreciation of $5,920. All
other fixed manufacturing overhead costs represent current cash flows. The November direct
labor budget indicates that 3,700 direct labor-hours will be required in that month.
Required:
a. Determine the cash disbursements for manufacturing overhead for November.
b. Determine the predetermined overhead rate for November.
7-236
169.
The manufacturing overhead budget of Paparella Corporation is based on budgeted direct
labor-hours. The November direct labor budget indicates that 6,000 direct labor-hours will be
required in that month. The variable overhead rate is $2.00 per direct labor-hour. The
company’s budgeted fixed manufacturing overhead is $79,200 per month, which includes
depreciation of $21,000. All other fixed manufacturing overhead costs represent current cash
flows.
Required:
a. Determine the cash disbursements for manufacturing overhead for November. Show your
work!
b. Determine the predetermined overhead rate for November. Show your work!
7-237
170.
The selling and administrative expense budget of Gullette Corporation is based on the number
of units sold, which are budgeted to be 2,700 units in April. The variable selling and
administrative expense is $1.90 per unit. The budgeted fixed selling and administrative
expense is $35,640 per month, which includes depreciation of $7,290. The remainder of the
fixed selling and administrative expense represents current cash flows.
Required:
Prepare the selling and administrative expense budget for April.
7-238
171.
Skeete Inc. bases its selling and administrative expense budget on the number of units sold.
The variable selling and administrative expense is $1.70 per unit. The budgeted fixed selling
and administrative expense is $57,720 per month, which includes depreciation of $9,360. The
remainder of the fixed selling and administrative expense represents current cash flows. The
sales budget shows 3,900 units are planned to be sold in November.
Required:
Prepare the selling and administrative expense budget for November.
7-239
172.
Parliman Corporation is preparing its cash budget for August. The budgeted beginning cash
balance is $12,000. Budgeted cash receipts total $159,000 and budgeted cash disbursements
total $162,000. The desired ending cash balance is $20,000. The company can borrow up to
$160,000 at any time from a local bank, with interest not due until the following month.
Required:
Prepare the company’s cash budget for August in good form.
173.
Freet Inc. is preparing its cash budget for November. The budgeted beginning cash balance is
$11,000. Budgeted cash receipts total $126,000 and budgeted cash disbursements total
$130,000. The desired ending cash balance is $20,000. The company can borrow up to
$170,000 at any time from a local bank, with interest not due until the following month.
Required:
Prepare the company’s cash budget for November in good form. Make sure to indicate what
borrowing, if any, would be needed to attain the desired ending cash balance.
7-240