Problem 3A-5 Transaction Analysis [LO3-5]

Star Videos, Inc., produces short musical videos for sale to retail outlets. The companys balance sheet accounts as of January 1 are given below.

Star Videos, Inc.
Balance Sheet
January 1
Assets
Cash				$	76,200
Accounts receivable					104,200
Inventories:
Raw materials (film, costumes)	$	35,600
Videos in process		49,000
Finished videos awaiting sale		82,600			167,200
Prepaid insurance					8,500
Studio and equipment (net)					595,000
Total assets				$	951,100
Liabilities and Stockholders Equity
Accounts payable				$	238,000
Retained earnings					713,100
Total liabilities and stockholders equity				$	951,100

Because the videos differ in length and in complexity of production, the company uses a job-order costing system to determine the cost of each video produced. Studio (manufacturing) overhead is charged to videos on the basis of camera-hours of activity. The companys predetermined overhead rate for the year ($40 per camera-hour) is based on a cost formula that estimated $280,000 in manufacturing overhead for an estimated allocation base of 7,000 camera-hours. Any underapplied or overapplied overhead is closed to cost of goods sold. The following transactions were recorded for the year:

1. Film, costumes, and similar raw materials purchased on account, $204,500.
2. Film, costumes, and other raw materials issued to production, $232,000 (85% of this material was considered direct to the videos in production, and the other 15% was considered indirect).
3. Utility costs incurred (on account) in the production studio, $93,200.
4. Depreciation recorded on the studio, cameras, and other equipment, $107,600. Three-fourths of this depreciation related to actual production of the videos, and the remainder related to equipment used in marketing and administration.
5. Advertising expense incurred (on account), $134,000.
6. Salaries and wages paid in cash as follows:

Direct labor (actors and directors)	$	92,800
Indirect labor (carpenters to build sets, costume designers, and so forth)	$	71,000
Administrative salaries	$	95,400

1. Prepaid insurance expired during the year, $7,600 (70% related to production of videos, and 30% related to marketing and administrative activities).
2. Miscellaneous marketing and administrative expenses incurred (on account), $11,550.
3. Studio (manufacturing) overhead was applied to videos in production. The company recorded 7,250 camera-hours of activity during the year.
4. Videos that cost $546,000 to produce according to their job cost sheets were transferred to the finished videos warehouse to await sale and shipment.
5. Sales for the year totaled $954,000 and were all on account.
6. The total cost to produce the videos that were sold according to their job cost sheets was $589,670.
7. Collections from customers during the year totaled $904,000.
8. Payments to suppliers on account during the year, $558,000.
9. Underapplied or overapplied overhead $__?__.

Required:

1. Prepare a transaction analysis that records all of the above transactions. Calculate the ending balances at December 31 for all balance sheet accounts.

2. Prepare a schedule of cost of goods manufactured for the year.

3. Prepare a schedule of cost of goods sold for the year.

4. Prepare an income statement for the year.