Question

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 Accounts receivable Inventories: $ 88,000 114,600 Raw materials (film, costumes) $20,000 51,800 97,200 Videos in process Finished videos awaiting sale Prepaid insurance Studio and equipment (net) Total assets Liabilities and Stockholders Equity Accounts payable Retained earnings Total liabilities and stockholders equity 169,000 10,750 598,000 $ 980,350 $189,000 791,350 980,350 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: a. Film, costumes, and similar raw materials purchased on account, $189,500. b. Film, costumes, and other raw materials issued to production, $200,000(85% of this material was considered direct to the videos in production, and the other 15% was considered indirect). c. Utility costs incurred (on account) in the production studio, $93,800. d. Depreciation recorded on the studio, cameras, and other equipment, $112,400. Three-fourths of this depreciation related to actual production of the videos, and the remainder related to equipment used in marketing and administration. e. Advertising expense incurred (on account), $153,000 f. Salaries and wages paid in cash as follows:Direct labo(actors and directors) $102,800 $ 71,500 97,800 Indirect labor (carpenters to build sets, costume designers, and so forth) Administrative salaries g. Prepaid insurance expired during the year, $8,550 (70% related to production of videos, and 30% related to marketing and administrative activities). h. Miscellaneous marketing and administrative expenses incurred (on account), $11,700 i. Studio (manufacturing) overhead was applied to videos in production. The company recorded 7,250 camera-hours of activity duringg the year j. Videos that cost $586,000 to produce according to their job cost sheets were transferred to the finished videos warehouse to await sale and shipment. k. Sales for the year totaled $998,000 and were all on account. . The total cost to produce the videos that were sold according to their job cost sheets was $632,470 m. Collections from customers during the year totaled $948,000 n. Payments to suppliers on account during the year, $538,000. o. Underapplied or overapplied overhead $ Required: 1. Prepare a transaction analysis that records all of the above transactions 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 yearTransaction Analysis For the Year Ended December 31 Studio 8 Equipment ne Videos in Accounts Receivable Raw Materials Finished Manufacturing Prepaid Overhead Cash Goods Insurance Beginning balance@1/1 (a) Raw material purchases (b) Raw materials used (c) Utility costs (d) Depreciation charges (e) Advertising () Salaries & wages (9) Prepaid insurance (h) Miscellaneous marketing (i) Applied overhead ) Transfer completed videos to finished goods (k) Sales () Transfer finished goods to cost of goods sold (m) Cash collections from customers (n) Payment to suppliers 88,000 114,600 S 20,000 51,800$ 10,750 $ 598,000 Ending balances 12/31Transaction Analysis For the Year Ended December 31 Studio & Accounts Raw Materials Process Videos in Finished Manufacturing Prepaid Retained Earnings Cash Receivable Raw Materials Goods Overhead I Insurance Equipment Accounts (net) $ 88,000114,60020,000 51,800 97,200 1000189,000791,350 10,750 S598,Prepare a schedule of cost of goods manufactured for the year. Star Videos, Inc. Schedule of Cost of Goods Manufactured For the Year Ended December 31 0 Total manufacturing costs 0 Cost of goods manufactured 0Prepare a schedulisold for the year. Star Videos, Inc Schedule of Cost of Goods Sold For the Year Ended December 31Star Videos, Inc Income Statement For the Year Ended December 31PLEASE FILL IN THE ANSWERS, THIS IS MY SECOND TIME POSTING THIS.

0 1
Add a comment Improve this question Transcribed image text
Answer #1

Ans-Transaction Analysis:-

No. Particulars Cash Accounts Receivable Raw Materials Videos in Process Finished Goods Manufacturing Overhead Prepaid Insurance Studio & Equipment (net) = Accounts Payable Retained Earnings
Beginning Balance $ 88,000

$114,600

$20,000 $51,800 $97,200 $10,750 $598,000 = $189,000 $791,350
a. Raw material purchased 189,500 189,500
b. Raw material consumed -200,000 170,000 30,000
c. Utility cost incurred 93,800 93,800
d. Depreciation on equipment 84,300 -112,400 -28,100
e. Advertisement incurred 153,000 -153,000
f. Salaries and wages paid -272,100 102,800 71,500 -97,800
g. Prepaid insurance expired 5,985 -8,550 -2,565
h. Misc. marketing and administrative expense 11,700 -11,700
i. Manufacturing overhead applied 290,000 -290,000
j. Cost of goods manufactured -586,000 586,000
k. Sales on account 998,000 998,000
l. Cost of goods sold -632,470 -632,470
m. Cash collections 948,000 -948,000
n. Payment to suppliers -538,000 -538,000
o. Over-applied overhead 4,415 4,415
Ending Balance 12/31 $225,900 $164,600 $9,500 $28,600 $50,730 0 $2,200 $485,600 = $99,000 868,130

Working Note-

Overhead Applied

Camera hours worked= 7,250

Pre determined overheads=40

Overhead absorted= $290,000

Total Overhead incurred=$285,585

Over-applied Overhead= $290,000-$285,585= $4,415

2- Preparing a schedule of cost of goods manufactured for the year:-

Star Videos, Inc.

Schedule of Cost of Goods Manufactured

For the Year Ended December 31

Particulars Amount Amount
Beginning inventory of raw material 20,000
Add": Purchases 189,500
Less: Ending inventory 9,500
Raw material consumed 200,000
Less: Indirect material consumed 30,000
Direct material consumed 170,000
Direct wages incurred 102,800
Manufacturing Overhead applied (7,250@ 40) 290,000
Total Manufacturing Cost 562,800
Add: Beginning balance of work in process 51,800
Less: Ending balance of work in process 28,600
Cost of Goods Manufactured $586,000

3- Preparing a schedule of cost of goods sold for the year:-

Star Videos, Inc.

Schedule of Cost of Goods Sold

For the Year Ended December 31

Particulars Amount ($)
Cost of goods manufactured (as computed above) 586,000
Add: Beginning inventory balance of Finished Goods 97,200
Cost of Goods available for sale $683,200
Less: Ending inventory of Finished Goods $50,730
Cost of goods to be sold $632,470
Less: Over-applied Overhead $4,415
Adjusted Cost of Goods Sold $628,055

4- Star Videos, Inc.

Income Statement

For the Year Ended December 31

Particulars Amount ($) Amount ($)
Sales Revenue $998,000
Less: Cost of goods sold (as computed above) 628,055
Gross Margin $369,945
Less: Expenses
Depreciation on Equipment 28,100
Advertisement 153,000
Administrative Salaries 97,800
Insurance Expenses 2,565
Misc. Marketing and administrative expenses 11,700 $293,165
Net Income earned during the period $76,780

Kindly give thumbsup if u like my answer...Thanks!!!

Add a comment
Know the answer?
Add Answer to:
PLEASE FILL IN THE ANSWERS, THIS IS MY SECOND TIME POSTING THIS. Star Videos, Inc., produces...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • All one problem, THANK YOU!! Star Videos, Inc., produces short musical videos for sale to retail...

    All one problem, THANK YOU!! Star Videos, Inc., produces short musical videos for sale to retail outlets. The company's balance sheet accounts as of January 1 are given below. $ 92,000 115,600 Star Videos, Inc. Balance Sheet January 1 Assets Cash Accounts receivable Inventories: Raw materials (film, costumes) Videos in process Finished videos awaiting sale Prepaid insurance Studio and equipment (net) Total assets Liabilities and Stockholders' Equity Accounts payable Retained earnings Total liabilities and stockholders' equity $ 17,809 60,200 91,200...

  • Star Videos, Inc., produces short musical videos for sale to retail outlets. The company's balance sheet...

    Star Videos, Inc., produces short musical videos for sale to retail outlets. The company's balance sheet accounts as of January 1 are given below. $ 89,000 107,600 Star Videos, Inc. Balance Sheet January 1 Assets Cash Accounts receivable Inventories: Raw materials (film, costumes) Videos in process Finished videos awaiting sale Prepaid insurance Studio and equipment (net) Total assets Liabilities and Stockholders' Equity Accounts payable Retained earnings Total liabilities and stockholders' equity $ 10,600 50,600 91,800 153,000 10,000 583,000 $ 942,600...

  • Star Videos, Inc., produces short musical videos for sale to retail outlets. The company's balance sheet...

    Star Videos, Inc., produces short musical videos for sale to retail outlets. The company's balance sheet accounts as of January 1 are given below. Star Videos, Inc. Balance Sheet January 1 Assets $ 78, 600 103,400 Cash Accounts receivable Inventories: $ 19,800 Raw materials (film, costumes) Videos in process Finished videos awaiting sale Prepaid insurance Studio and equipment (net) Total assets Liabilities and Stockholders' Equity Accounts payable Retained earnings Total liabilities and stockholders' equity 62,600 84,400 166, 000 9,250 610,...

  • Star Videos, Inc., produces short musical videos for sale to retail outlets. The company's balance sheet...

    Star Videos, Inc., produces short musical videos for sale to retail outlets. The company's balance sheet accounts as of January 1 are given below Star Videos, Inc. Balance Sheet January 1 Assets Cash $ 81,800 100.000 Skipped $17,200 57,400 85,800 Roos Accounts receivable Inventories: Raw materials (Film, costumes) Videos in process Finished videos awaiting sale Prepaid insurance Studio and equipment (net) Total assets Liabilities and Stockholders' Equity Accounts payable Betained earnings Total liabilities and stockholders' equity 160,00 12.650 588. $947,258...

  • Star Videos, Inc., produces short musical videos for sale to retail outlets. The company's balance sheet...

    Star Videos, Inc., produces short musical videos for sale to retail outlets. The company's balance sheet accounts as of January 1 are given below. $ 91,200 109,400 Star Videos, Ine. Balance Sheet January 1 Assets Cash Accounts receivable Inventories: Raw materials (film, costumes ) Videos in process Finished videos awaiting sale Prepaid insurance Studio and equipment (net) Total assets Liabilities and Stockholders' Equity Accounts payable Retained earnings Total liabilities and stockholders' equity $12,000 51,600 86.600 150,200 10,600 627,000 $ 988,400...

  • Star Videos, Inc., produces short musical videos for sale to retail outlets. The company’s balance sheet...

    Star Videos, Inc., produces short musical videos for sale to retail outlets. The company’s balance sheet accounts as of January 1 are given below. Star Videos, Inc. Balance Sheet January 1 Assets Cash $ 90,200 Accounts receivable 96,200 Inventories: Raw materials (film, costumes) $ 20,200 Videos in process 56,800 Finished videos awaiting sale 81,800 158,800 Prepaid insurance 12,700 Studio and equipment (net) 542,000 Total assets $ 899,900 Liabilities and Stockholders’ Equity Accounts payable $ 156,000 Retained earnings 743,900 Total liabilities...

  • Star Videos, Inc., produces short musical videos for sale to retail outlets. The company’s balance sheet...

    Star Videos, Inc., produces short musical videos for sale to retail outlets. The company’s balance sheet accounts as of January 1 are given below. Star Videos, Inc. Balance Sheet January 1 Assets Cash $ 81,800 Accounts receivable 104,400 Inventories: Raw materials (film, costumes) $ 17,200 Videos in process 57,400 Finished videos awaiting sale 85,800 160,400 Prepaid insurance 12,650 Studio and equipment (net) 588,000 Total assets $ 947,250 Liabilities and Stockholders’ Equity Accounts payable $ 203,000 Retained earnings 744,250 Total liabilities...

  • Star Videos, Inc., produces short musical videos for sale to retail outlets. The company’s balance sheet...

    Star Videos, Inc., produces short musical videos for sale to retail outlets. The company’s balance sheet accounts as of January 1 are given below. Star Videos, Inc. Balance Sheet January 1 Assets Cash $ 74,600 Accounts receivable 115,400 Inventories: Raw materials (film, costumes) $ 10,000 Videos in process 49,000 Finished videos awaiting sale 88,600 147,600 Prepaid insurance 8,200 Studio and equipment (net) 588,000 Total assets $ 933,800 Liabilities and Stockholders’ Equity Accounts payable $ 244,000 Retained earnings 689,800 Total liabilities...

  • Star Videos, Inc., produces short musical videos for sale to retail outlets. The company’s balance sheet...

    Star Videos, Inc., produces short musical videos for sale to retail outlets. The company’s balance sheet accounts as of January 1 are given below. Star Videos, Inc. Balance Sheet January 1 Assets Cash $ 81,800 Accounts receivable 104,400 Inventories: Raw materials (film, costumes) $ 17,200 Videos in process 57,400 Finished videos awaiting sale 85,800 160,400 Prepaid insurance 12,650 Studio and equipment (net) 588,000 Total assets $ 947,250 Liabilities and Stockholders’ Equity Accounts payable $ 203,000 Retained earnings 744,250 Total liabilities...

  • Star Videos, Inc., produces short musical videos for sale to retail outlets. The company’s balance sheet...

    Star Videos, Inc., produces short musical videos for sale to retail outlets. The company’s balance sheet accounts as of January 1 are given below. Star Videos, Inc. Balance Sheet January 1 Assets Cash $ 84,600 Accounts receivable 103,600 Inventories: Raw materials (film, costumes) $ 52,800 Videos in process 48,000 Finished videos awaiting sale 80,200 181,000 Prepaid insurance 8,850 Studio and equipment (net) 541,000 Total assets $ 919,050 Liabilities and Stockholders’ Equity Accounts payable $ 169,000 Retained earnings 750,050 Total liabilities...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT