Please Help! Managerial Accounting 201B Case Study with Excel Sheets: A. Classif

Question

Please Help! Managerial Accounting 201B Case Study with Excel Sheets:

A. Classify accounts in the trial balance by placing an X in the appropriate column(s)

B. Using the income statement accounts in the trial balance prepare a nulti-step income statement in good form

C. Using the balance sheet accounts in the trial balance prepare a classified balance sheet in good form

D. Complete the worksheet by identifying the cost as variable or fixed, placing an X in the appropriate column(s) to identify its characteristics

E. Determine if the cost is variable, fixed, or mixed, and identify for each area (where applicable) the variable cost per unit and total fixed cost and explain why you have identified it as having one of the three behaviors

Requirement A HoverCraft, Ind Trial Balance at December 31 Account Account Classification & Behavior 2017 2016 Inc Stmt Bal Sheet AssetLiab Equity RevenueExpense Fixed Variable Opportunity S 412,000 $ 527,000 12,614 Example - R & D Long-term debt Non-current capital eases Sales Parts Other current liabilities Land Travel Expenses Cost of Goods Sold Rent Marketable securities 35,344 632 273 2.100,0001,945,000 4,574 14,332 285000 67,500,00061,900,000 650,000 18,770 625000 se 800,000 ISI ses 550,000 1,000,000 4,472 Other long-term liabilities Sales - Misc nsurance Expense Other current assets Underapplied Mfg Ovhd Deferred charges Inventories Interest Expense Salaries & Wages Sales Discounts 7,065,000 3.021,000 70,000 3,005 2.500,0001,100,000 60,000 4,487 12,354 2,120,640 3,728 756,840 11.775,0005,908.000 2.225.000 3.660,000 Forgone Opportunities (1) 157,000 3.569 23,000 625,000 6.693 3,976 4,757 150,000 145,000 2,703 32,000 550,000 6389 2,977 2,957 55,000 Deposits & other assets Interest Income ncome Tax Expense Common stock Accrued expense Corp Aircraft Expense Accounts payable Sales - Vehicles Current long-term debt Retained earnings ncome taxes Depreciation Expenses Capital Trade Receivables Work In Process 94.085.00086,020,000 2,128 35666 3.360 415,000 57,856 5,725 2,335 335.000 89,027 410,000 125,000 2,265 459,000 4,185 1,278 355.000 ses Property Plant & Equip Sales Returns Maintenance Expenses 670,000 110,000 10 52A 24 50n

Explanation / Answer

Requirement A

Opportunity

Requirement B

Sorry we facing problem to create other table and therefore not able to create table. Hence unable to answer rest part of problems

Account Inc Stmt Bal Sheet Assets Liab Equity Revenue Expenses Fixed Variables

Opportunity

Long term debt X X Non current cap X X Leases X X Sales parts X X Other current liabilities X X Land X X Travel Expenses X X X Marketing Securities X X X Advertising Expenses X X X Other long term liability X X Sales misc X X Insurance expenses X X X Other current assets X X Under applied mfg ovhd X X X Deferred charges X X X Inventory X X Interest expense X X X Salary & wages X X X Sales Discount X X X Forgon opportunity X X X Deposits & Other assets X X Interest income X X Income tax expense X X X Cash X X Common Stock X X Accrued Expenses X X Corp aircraft expenses X X X Accounts payable X X Sales vehicle X X Current long term debt X X Retained Earnings X X Income taxes X X Depreciation Expenses X X X Cap Surplus X X Trade Receivable X X Work in progress X X Office Expenses X X X Property, plant & equipment X X Sales Return X X X Maintenance Expenses X X X Treasury Stock X X

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---