Question

In: Accounting

use info to prepare a COGM statement and a COGS statement for Paradise Marina as of...

use info to prepare a COGM statement and a COGS statement for Paradise Marina as of June 30, 20XX.

Not everything listed below will be used – Pick out the relevant information

Inventories

Raw Materials, July 1 31,000

Raw Materials, June 30 25,000

Work in Process, July 1 32,750

Work in Process, June 30 35,550

Finished Goods, July 1 57,950

Finished Goods, June 30 60,000

Administrative Salaries 96,000

Depreciation Expense - Office Equip 25,800

Depreciation Expense - Delivery Vehicle 39,000

Depreciation Expense - Factory Equip 56,500

Sales Discounts 30,000

Factory maintenance 10,500

Advertising Expense 25,350

Direct Labor 270,000

Factory Supplies used 16,000

Income Tax Expense 90,000

Indirect Labor 44,000

Indirect Material 29,000

Factory insurance 14,500

Factory utilities 15,000

Raw Material Purchases 395,000

Rent Expense - Factory 55,000

Rent Expense - Office 25,000

Rent Expense - Selling 26,000

Sales salary Expense 89,500

Sales 1,852,000

Solutions

Expert Solution

Paradise Marina schedule of cost of goods manufactured and cost of goods sold are presented below.

Paradise Marina

Schedule of cost of goods sold

For the Year Ended 30th June , 20XX

Particulars $ $
Raw material purchases 395,000
Add Raw materials July 1 31,000
Raw materials available for production 426,000
Less Raw material June 30 (25,000)
Raw materials used 401,000
Direct labour 270,000
Prime cost 671,000
Manufacturing overhead:
Factory utilities 15,000
Factory rent expenses 55,000
Factory equipment depreciation expense 56,500
Indirect material 29,000
Factory maintenance 10,500
Indirect labour 44,000
Factory supplies used 16,000
Factory insurance 14,500
Total manufacturing overhead 240,500
Total manufacturing cost 911,500
Add beginning work in process 1st July 32,750
944,250
Less Ending work in process 30th June 35,550
Cost of goods manufactured 908,700

Paradise Marina

Cost of goods sold

For the Year Ended 30th June , 20XX

Particulars $
Beginning finished goods inventory 1st July 57,950
Add cost of goods manufactured 908,700
Cost of goods available for sales 966,650
Less Ending work in process inventory 30th June 60,000
Cost of goods sold 906,650

Paradise Marina depreciation expense for delivery vehicle $39,000 is selling expenses and depreciation expense Paradise Marina for office equipment $25,800 is administrative expenses. Advertising expenses $25,350 is a selling expense.

July 1st is the beginning of the period and June 30th is the end of the period.

Income tax expenses $90,000 is a non manufacturing cost, it is also a non operating expense.

$96,000 administrative expenses is a operating expense.

$906,650 is the cost of goods sold and $908,700 is the cost of goods manufactured

Rent expenses related to office $25,000 is a administrative expense and selling $26,000 is a selling expense.


Related Solutions

Question: Based on the information below info, prepare an income statement for 2018, statement of retained...
Question: Based on the information below info, prepare an income statement for 2018, statement of retained earnings for 2018, and a balance sheet on 12/31/2018 that makes sense based on the provided info. (Note: you can add additional info if desired. The below info is just the minimum required.) Background: Last year, you set up your own business in the merchandising sector. You lease a space of 6,000 square feet to open a luxury watch shop. The following is the...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC Balance Sheet as of December 31, 2015 and 2014 (in millions of dollars) 2015 2014 2015 2014   Assets   Liabilities and Equity   Current assets:   Current liabilities:      Cash and marketable securities $ 100 $ 48      Accrued wages and taxes $ 60 $ 48      Accounts receivable 110 72      Accounts payable 110 72      Inventory 301 174      Notes payable 70 60         Total $ 511 $ 294         Total $ 240...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC Balance Sheet as of December 31, 2015 and 2014 (in millions of dollars) 2015 2014 2015 2014   Assets   Liabilities and Equity   Current assets:   Current liabilities:      Cash and marketable securities $ 80 $ 42      Accrued wages and taxes $ 40 $ 30      Accounts receivable 120 66      Accounts payable 90 60      Inventory 222 168      Notes payable 50 54         Total $ 422 $ 276         Total $ 180...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC Balance Sheet as of December 31, 2015 and 2014 (in millions of dollars) 2015 2014 2015 2014 Assets Liabilities and Equity Current assets: Current liabilities: Cash and marketable securities $ 50 $ 56 Accrued wages and taxes $ 50 $ 48 Accounts receivable 60 52 Accounts payable 55 44 Inventory 205 96 Notes payable 60 40 Total $ 315 $ 204 Total $ 165...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC Balance Sheet as of December 31, 2015 and 2014 (in millions of dollars) 2015 2014 2015 2014   Assets   Liabilities and Equity   Current assets:   Current liabilities:      Cash and marketable securities $ 80 $ 42      Accrued wages and taxes $ 40 $ 30      Accounts receivable 120 66      Accounts payable 90 60      Inventory 222 168      Notes payable 50 54         Total $ 422 $ 276         Total $ 180...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC Balance Sheet as of December 31, 2015 and 2014 (in millions of dollars) 2015 2014 2015 2014 Assets Liabilities and Equity Current assets: Current liabilities: Cash and marketable securities $ 72 $ 48 Accrued wages and taxes $ 56 $ 54 Accounts receivable 80 60 Accounts payable 80 66 Inventory 294 186 Notes payable 48 54 Total $ 446 $ 294 Total $ 184...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC Balance Sheet as of December 31, 2015 and 2014 (in millions of dollars) 2015 2014 2015 2014 Assets Liabilities and Equity Current assets: Current liabilities: Cash and marketable securities $ 40 $ 30 Accrued wages and taxes $ 32 $ 24 Accounts receivable 32 39 Accounts payable 40 27 Inventory 175 60 Notes payable 32 30 Total $ 247 $ 129 Total $ 104...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC....
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC. Balance Sheet as of December 31, 2021 and 2020 (in millions of dollars) 2021 2020 2021 2020 Assets Liabilities and Equity Current assets: Current liabilities: Cash and marketable securities $ 75 $ 65 Accrued wages and taxes $ 40 $ 43 Accounts receivable 115 110 Accounts payable 90 80 Inventory 200 190 Notes payable 80 70 Total $ 390 $ 365 Total $ 210...
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC....
Use the following financial statements for Lake of Egypt Marina, Inc. LAKE OF EGYPT MARINA, INC. Balance Sheet as of December 31, 2021 and 2020 (in millions of dollars) 2021 2020 2021 2020 Assets Liabilities and Equity Current assets: Current liabilities: Cash and marketable securities $ 75 $ 65 Accrued wages and taxes $ 40 $ 43 Accounts receivable 115 110 Accounts payable 90 80 Inventory 200 190 Notes payable 80 70 Total $ 390 $ 365 Total $ 210...
Use the information presented in this worksheet to prepare an income statement, retained earnings statement, and...
Use the information presented in this worksheet to prepare an income statement, retained earnings statement, and balance sheet. Show cell references if possible. ESP Corporation Worksheet for year ended December 31, 2018 Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet Cash 5,900 $           5,900 $           5,900 Accounts Receivable 12,450 $         2,800 $         15,250 $         15,250 Office Supplies $            200 $              200 $              200 Prepaid insurance 2,400 $         1,800 $              600 $              600 Equipment 169,000 $      169,000 $      169,500...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT