Computing budgeted accounts payable and purchases%u2014sales forecast in dollars LO P1, P2

Big Sound, a merchandising company specializing in home computer speakers, budgets its monthly cost of goods sold to equal 60% of sales. Its inventory policy calls for ending inventory in each month to equal 30% of the next month’s budgeted cost of goods sold. All purchases are on credit, and 40% of the purchases in a month is paid for in the same month. Another 20% is paid for during the first month after purchase, and the remaining 40% is paid for in the second month after purchase. The following sales budgets are set: July, $200,000; August, $140,000; September, $170,000; October, $125,000; and November, $115,000.

Electro Company manufactures an innovative automobile transmission for electric cars. Management predicts that ending finished goods inventory for the first quarter will be 71,280 units. The following unit sales of the transmissions are expected during the rest of the year: second quarter, 216,000 units; third quarter, 496,000 units; and fourth quarter, 250,000 units. Company policy calls for the ending finished goods inventory of a quarter to equal 33% of the next quarter’s budgeted sales. (Ending inventory for the first quarter does not comply with company policy.) Each transmission requires 0.69 pounds of a key raw material. Electro Company aims to end each quarter with an ending inventory of direct materials equal to 33% of next quarter’s budgeted materials requirements. Direct materials cost $183 per unit.

Prepare a direct materials budget for the second quarter.

Jasper Company has sales on account and for cash. Specifically, 55% of its sales are on account and 45% are for cash. Credit sales are collected in full in the month following the sale. The company forecasts sales of $519,000 for April, $529,000 for May, and $554,000 for June. The beginning balance of Accounts Receivable is $304,500 on April 1.

Prepare a schedule of budgeted cash receipts for April, May, and June.

Karim Corp. requires a minimum $10,000 cash balance. If necessary, loans are taken to meet this requirement at a cost of 1% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on July 1 is $10,400 and the company has no outstanding loans. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) are:

July

August

September

  Cash receipts

$

26,000   

$

34,000   

$

42,000   

  Cash disbursements

31,000   

32,000   

34,000   

Prepare a cash budget for July, August, and September.

Foyert Corp. requires a minimum $6,100 cash balance. If necessary, loans are taken to meet this requirement at a cost of 2% interest per month (paid monthly). Any excess cash is used to repay loans at month-end. The cash balance on October 1 is $6,100 and the company has an outstanding loan of $2,100. Forecasted cash receipts (other than for loans received) and forecasted cash payments (other than for loan or interest payments) follow.

October

November

December

  Cash receipts

$

22,100   

$

16,100   

$

20,100   

  Cash disbursements

24,150   

15,100   

15,900   

Prepare a cash budget for October, November, and December

Castor, Inc. is preparing its master budget for the quarter ended June 30. Budgeted sales and cash payments for merchandise for the next three months follow:

April

May

June

  Budgeted sales

$

31,500  

$

40,500  

$

24,500  

  Budgeted cash payments for merchandise

21,200  

16,300  

16,700  

Sales are 60% cash and 40% on credit. All credit sales are collected in the month following the sale. The March 30 balance sheet includes balances of $12,500 in cash, $12,500 in accounts receivable, $11,000 in accounts payable, and a $2,500 balance in loans payable. A minimum cash balance of $12,500 is required. Loans are obtained at the end of any month when a cash shortage occurs. Interest is 2% per month based on the beginning of the month loan balance and is paid at each month-end. If an excess balance of cash exists, loans are repaid at the end of the month. Operating expenses are paid in the month incurred and consist of sales commissions (5% of sales), shipping (4% of sales), office salaries ($3,500 per month) and rent ($5,500 per month).

Prepare a cash budget for each of the months of April, May, and June.

The following information is available for Zetrov Company:

a.

The cash budget for March shows an ending bank loan of $15,000 and an ending cash balance of $61,000.

b.

The sales budget for March indicates sales of $130,000. Accounts receivable are expected to be 65% of the current-month sales.

c.

The merchandise purchases budget indicates that $90,000 in merchandise will be purchased on account in March. Purchases on account are paid 100% in the month following the purchase. Ending inventory for March is predicted to be 700 units at a cost of $35 each.

d.

The budgeted income statement for March shows net income of $49,000. Depreciation expense of $2,000 and $27,000 in income tax expense were used in computing net income for March. Accrued taxes will be paid in April.

e.

The balance sheet for February shows equipment of $83,000 with accumulated depreciation of $31,000, common stock of $30,000, and ending retained earnings of $9,000. There are no changes budgeted in the equipment or common stock accounts.

Prepare a budgeted balance sheet for March.

Fortune, Inc., is preparing its master budget for the first quarter. The company sells a single product at a price of $25 per unit. Sales (in units) are forecasted at 40,000 for January, 60,000 for February, and 50,000 for March. Cost of goods sold is $12 per unit. Other expense information for the first quarter follows.

  Commissions

9

%

 of sales

  Rent

$

18,000

 per month

  Advertising

15

%

 of sales

  Office salaries

$

76,000

 per month

  Depreciation

$

49,000

 per month

  Interest

12

%

 annually on a $230,000 note payable

  Tax rate

30

%

Prepare a budgeted income statement for this first quarter.

The production budget for Manner Company shows units to be produced as follows: July, 600; August, 660; September, 520. Each unit produced requires two hours of direct labor. The direct labor rate is currently $15 per hour but is predicted to be $15.75 per hour in September.

Prepare a direct labor budget for the months July, August, and September. (Round your “Labor rate” to 2 decimal places.)

Hospitable Co. provides the following sales forecast for the next four months:

April

May

June

July

  Sales (units)

690  

770  

720  

720  

The company wants to end each month with ending finished goods inventory equal to 20% of next month’s sales. Finished goods inventory on April 1 is 138 units. Assume July’s budgeted production is 730 units.

Hospitable Co. provides the following sales forecast for the next four months:

April

May

June

July

  Sales (units)

580  

660  

610  

610  

The company wants to end each month with ending finished goods inventory equal to 20% of next month’s sales. Finished goods inventory on April 1 is 116 units. Assume July’s budgeted production is 620 units. Assume each finished unit requires five pounds of raw materials and the company wants to end each month with raw materials inventory equal to 20% of next month’s production needs. Beginning raw materials inventory for April was 596 pounds.

Prepare a direct materials budget for April, May, and June.