PROBLEM ONE The following information pertains to Life Corporation

Month Sales (units) Sales (dollars)

July 1,500 $30,000

August 1,700 34,000

September 1,600 32,000

October 1,700 40,800

November 2,100 54,600

December 2,350 51,700

January 2,300 57,000

February 1,900 51,000

March 1,750 44,000

April 1,600 41,600

May 1,500 30,000

June 1,400 32,200

Of sales, 30% are in cash with the remainder on account.

Accounts Receivable is collected from customers in the following manner:

Month of sale 30%

Month following sale 60%

Second month following sale 10%

Life Corporation desires ending inventory for finished goods to be 30% of next months sales.

Each unit requires three pounds of material, each pound costs $2.75. Life Corporation desires ending inventory of raw materials should be 50% of next months needs. Materials are purchased on account. Payments are 40% in the month of purchase with the remainder paid in the following month. The previous months ending Accounts Payable balance was $11,162. In addition, each unit requires one hour of labor, each labor hour costs $15.

REQUIRED:

1. Prepare a Revenue budget for December, including revenue, cash collections, and accounts receivable.

2. Prepare a Production Budget for December.

3. Prepare a Raw Materials Purchases Budget for December, including cash disbursements.

4. Prepare the Direct Labor Budget including payments.