ACCOUNTING homework

Nolan Johnson is CFO for a newly formed furniture manufacturing company. Below is the anticipated monthly production for the first year of operation, and beyond. Nolan is interested in learning which of the first twelve months will require cash outlays of more than $100,000 toward the purchase of lumber.

Each unit requires 20 board feet of lumber at $5.80 per board foot. All lumber is purchased in the month prior to its expected use. Lumber purchases are paid for 10% in the month of purchase, 40% in the month following the month of purchase, and 50% in the second month following the month of purchase.

Month Units

January 0

February 800

March 500

April 1,200

May 700

June 900

July 300

August 600

September 800

October 1,300

November 400

December 400

January 600

Which months will require cash outlays in excess of the $100,000 amount? Does the production in any given month necessarily correspond to the cash flow for that same month? What are the business implications of your observation?

Scheduling anticipated cash payments B-21.05

Anticipated cash payments:

CASH PAYMENTS

Units Purchasing

Activity

Total Board Feet

(20 per unit)

Total Cost of Lumber ($5.80 per

foot)

Paid in Month (10%)

Paid in Month

Relating to Prior Month

(40%)

Paid in Month Relating to

Two Months Prior

(50%)

Total

January 0

February 800

March 500

April 1,200

May 700

June 900

July 300

August 600

September 800

October 1,300

November 400

December 400

January 600

Scheduling anticipated cash payments B-21.05