Lambeth Custom Cabinets (B)

Jack Lambeth, a master cabinet maker, owns and operates a shop where he sells custom-made cabinets. At the beginning of September his business had no outstanding debt and the following amounts were on his books:

1. Raw materials inventory, $3,350.

2. Supplies inventory, $920.

3. Work-in-process inventory, $7,200.

			Overhead
Job	Materials	Labor	(50% of Labor)
A-3	$950	$ 1,300	$650
A-4	1,050	850	425
A-5	625	900	450
Total	$2,625	$3,050	$1,525	$	7,200

4. Cash as of September 1 were $16,890.

During the month, Lambeth's woodworking crew finished jobs A-3, A-4, and A-6 but did not finish A-5. Job A-7 and A-8 was started but not finished during September. Overhead costs (pertaining primarily to equipment and shop depreciation, cleaning supplies, and insurance) are applied to every job at the end of the month unless the job is finished during the month, in which case overhead is applied when the job is finished.

During September, the following direct materials and direct labor costs were incurred:

Job Direct Materials Labor

A-3 $280 $750

A-4 350 1,300

A-5 180 550

A-6 375 490

A-7 590 370

A-8 900 870

Total $2,675 $4,330

Other financial factors of importance pertaining to September were:

A. $2,675 of raw materials were purchased during the month.

B. Supplies of $780 were purchased while $590 were used and thus transferred to the manufacturing overhead account.

C. Total increases to the labor general ledger account were $6,850. (Apparently there was $2,520 indirect labor charged.)

D. General and administrative expenses for the month were $3,420.

E. Collections received from customers on jobs A-3, A-4, and A-6 amounted to $7,125, $10,600, and $2,750, respectively, for a total of $20,475.

F. At the end of the month, Lambeth Custom Cabinets had no outstanding debts.

While Jack was reviewing the September data he became very concerned about the manufacturing overhead variance (MOV). Since Jack never wanted to lay off an employee, the MOV was always large in months when business was slow. (Jack assigned unoccupied workers to general clean-up and repair worl< and charged their wages to indirect labor.) Of course, Lambeth realized why the MOV was so large. What he worried about, however, was Mrs. Carter.

Mrs. Carter, a neighbor, had stopped in the shop one day in early September to get a price on some cabinets she wanted built. Jack's son, Jack Jr., spoke with her. Jack Jr. was working in the shop while on summer vacation between his first and second year of graduate business school. Jack Jr. studied the plans that Mrs. Carter had and estimated the cost to build her cabinets at $2,050. His job estimation sheet showed:

Lumber $990

Finishing materials 100

Direct labor cost 640

Overhead 320

$2,050

When Jack Jr. quoted a price of $2,560 ($2,050 cost $510 profit) to Mrs. Carter, she said that she could get the same thing built by Walworth Custom Kitchens for $1,950.

Furthermore, she informed Jack Jr. that, "1 would throw the dumb economics books away before I would pay a penny more than $1,950 for book cabinets to store them."

Jack Jr. simply told her that his best price would be $2,560. He explained all about labor, materials, profit, overhead, and competitive capitalism. In addition, he told Mrs. Carter that Walworth couldn't make money on a $1,950 price and if Walworth was really willing to build the shelves for $1,950 she would be stealing from Mr. Walworth!

Mrs. Carter was very angry when she left. Jack Jr. later told his father the whole story and laughed as he said, "Heck, we can't build stuff that costs $2,050 and sell it at a price of $1,950, let alone $2,000 can we?" At that time Lambeth didn't think much about the incident but he began to wonder whether Jack Jr. had learned anything at graduate business school. Lambeth became especially concerned when he saw Bob Walworth, who said, "Mrs. Carter saved me last month." It seems that Walworth had just delivered Mrs. Carter's new cabinets for which she paid $1,950. Jack Lambeth wondered who was right Jack Jr. or Walworth?

Prepare journal entries for the transaction for September.

Record the beginning balances in the General Ledger. Post the September transaction from #1 into the General Ledger.

Prepare a Balance Sheet and Income Statement for September 30^th

Prepare a Variable Costing Income Statement for September 30th

Based on what you know about the cost structure of Lambeth Custom Cabinets, could Lambeth make a profit and/or a positive contribution margin on Mrs. Carter's order at a selling price of $1,950?

Hint: Use Excel to complete requirements 1-4.

So far I have:

Job Cost

A-3	Materials	Labor	Overhead	Total	Transfer to FG	WIP
Beg. Bal.	950.00	1,300.00	650.00	2,900.00
Sept. Act.	280.00	750.00	375.00	1,405.00
Total	$ 1,230.00	$ 2,050.00	$ 1,025.00	$ 4,305.00	$ 4,305.00
A-4	Materials	Labor	Overhead	Total
Beg. Bal.	1,050.00	850.00	425.00	2,325.00
Sept. Act.	350.00	1,300.00	650.00	2,300.00
Total	$ 1,400.00	$ 2,150.00	$ 1,075.00	$ 4,625.00	$ 4,625.00
A-5	Materials	Labor	Overhead	Total
Beg. Bal.	625.00	900.00	450.00	1,975.00
Sept. Act.	180.00	550.00	275.00	1,005.00
Total	$ 805.00	$ 1,450.00	$ 725.00	$ 2,980.00		$ 2,980.00
A-6	Materials	Labor	Overhead	Total
Beg. Bal.	$ -	$ -	$ -	$ -
Sept. Act.	375.00	490.00	245.00	$ 1,110.00
Total	$ 375.00	$ 490.00	$ 245.00	$ 1,110.00	$ 1,110.00
A-7	Materials	Labor	Overhead	Total
Beg. Bal.				$ -
Sept. Act.	590.00	370.00	185.00	1,145.00
Total	$ 590.00	$ 370.00	$ 185.00	$ 1,145.00		$ 1,145.00
A-8	Materials	Labor	Overhead	Total
Beg. Bal.	$ -	$ -	$ -	$ -
Sept. Act.	900.00	870.00	435.00	2,205.00
Total	$ 900.00	$ 870.00	$ 435.00	$ 2,205.00		$ 2,205.00

J/E

Date	Act. #	D	C
9/2	103	$ 2,675.00
	100		$ 2,675.00
	Purchase of Raw Materials
9/4	104	$ 780.00
	100		$ 780.00
	Purchase of Supplies
	502	$ 590.00
	104		$ 590.00
	Supplies Used
9/10	110	$ 4,330.00
	502	$ 2,520.00
	100		$ 6,850.00
	Labor Incurred
9/12	501	$ 3,420.00
	100		$ 3,420.00
	Gen. and Admin. Expense
9/15	100	$ 7,125.00
	106		$ 7,125.00
	Collections Received for A-3
	100	$ 10,600.00
	106		$ 10,600.00
	Collections Received for A-4
	100	$ 2,750.00
	106		$ 2,750.00
	Collections Received for A-6

G/L

#100 Cash
	Date	Description	D	C	Balance
	9/1	Beg. Bal.			$ 16,890.00
	9/2	Purchase RM		$ 2,675.00	$ 14,215.00
	9/4	Purchase Supplies		$ 780.00	$ 13,435.00
	9/10	Labor Incurred		$ 6,850.00	$ 6,585.00
	9/12	G&A Exp.		$ 3,420.00	$ 3,165.00
	9/15	Collections Received A-3	$ 7,125.00		$ 10,290.00
	9/15	Collections Received A-4	$ 10,600.00		$ 20,890.00
	9/15	Collections Received A-6	$ 2,750.00		$ 23,640.00
#103 Raw Materials
	9/1	Beg. Bal.			$ 3,350.00
	9/2	Purchase RM	$ 2,675.00		$ 6,025.00
#104 Supplies
	9/1	Beg. Bal.			$ 920.00
	9/4	Purchase Supplies	$ 780.00		$ 1,700.00
	9/4	Supplies Used		$ 590.00	$ 1,110.00
#106 Accounts Receivable
	9/1	Beg. Bal.			$ 20,475.00
	9/15	Collections Received A-3		$ 7,125.00	$ 13,350.00
	9/15	Collections Received A-4		$ 10,600.00	$ 2,750.00
	9/15	Collections Received A-6		$ 2,750.00	$ -
#110 WIP Control
	9/1	Beg. Bal.			$ 7,200.00
	9/10	Labor Incurred	$ 4,330.00		$ 11,530.00
#112 Finished Goods
#401 Sales
#501 Gen. & Admin Exp.
	9/12	G&A Exp.	$ 3,420.00		$ 3,420.00
#502 MOH Control
	9/4	Supplies Used	$ 590.00		$ 590.00
	9/10	Labor Incurred	$ 2,520.00		$ 3,110.00
#503 MOH Allocated
#505 CGS

I need to know if what I have is correct so far and where I'm headed next. Is COGS going to be a debit of 10040? MOH All. credit of 2165?