Create an Excel spreadsheet to record, in proper form, the journal entries for each of the following events and transactions.

a. Purchased, on open account, 4,000 pounds of direct materials at a total cost of $20,200. The standard cost of these materials, at $5.00 per pound, was $20,000. The company records any price variance for direct materials at point of purchase.

b. During the current month 1,000 units of output were produced. Each unit of output, at standard, requires 2 pounds of direct materials, at $5.00 per pound. A total of 1,950 pounds of material was consumed in production during the month.

c. The direct labor payroll for the period was $25,000 and has yet to be paid. The standard direct labor hours to produce each unit is 2 and the standard wage rate per hour is $11. The actual wage rate per hour was $10.

d. The standard direct manufacturing cost for each unit is $32. During the month, 1,000 units were produced.

e. During the month, 900 units were sold, at a cost of $50 per unit. Give the summary journal entry to record each of the following:

1. The cost of the units sold (direct manufacturing costs only).

2. The sales revenue for the period.