College: Yuba Community College Course: Accounting 1 LAB (online) Platform/Website: Cengage (cengage.com) Email: XXXXXXXXXX Password: Evangel1995 Once on the dashboard, proceed to go click on the...

1 answer below »
College: Yuba Community College
Course: Accounting 1 LAB (online)
Platform/Website: Cengage (cengage.com)
Email: [email protected]
Password: Evangel1995


Once on the dashboard, proceed to go click on the "eBook: Excel Applications for Accounting Principles". A new window will open that shows the chapters on the left-hand side of the page. Scroll down and select "P19: VARIABLE COSTING (VARCOST)." This chapter goes hand in hand with the spreadsheet you are to complete.


The name of the lab assignment for this week is "VARCOST". It is due by 11:59 on WEDNESDAY, October 13, 2021.


*****MUST INCLUDE:*****
- What if Section
- Chart Analysis Section
- Tickler Section
PLEASE READ ALL INFORMATION AND REQUIREMENTS ON PAGES 110-113 OF THE EBOOK CAREFULLY.


Worksheet VARCOST Variable Costing Data Section Actual production in units100,000 Sales in units80,000 Sales price per unit$30 Variable manufacturing costs per unit$14 Variable selling costs per unit$2 Fixed manufacturing costs$315,000 Fixed selling expenses$100,000 Answer Section Income statement: Absorption costing SalesFORMULA1 Cost of goods sold: Variable manufacturing costsFORMULA2 Fixed manufacturing costsFORMULA3 Total goods available for sale$0 Less ending inventoryFORMULA4 Cost of goods sold0 Gross profit$0 Selling expenses: Fixed selling expensesFORMULA5 Variable selling expensesFORMULA6 Total selling expenses0 Operating income$0 Income statement: Variable costing Sales$0 Cost of goods sold: Variable manufacturing costsFORMULA7 Less ending inventoryFORMULA8 Variable cost of goods sold0 Manufacturing margin$0 Variable selling expensesFORMULA9 Contribution margin$0 Fixed costs: Fixed manufacturing costsFORMULA10 Fixed selling expenses0 Total fixed costs0 Operating income$0 Sheet1 CM SPR 20 Chart Chart Data Table 70,000705000670000 80,000705000705000 90,000705000740000 100,000705000768000 Chart A B
Answered Same DayOct 13, 2021

Answer To: College: Yuba Community College Course: Accounting 1 LAB (online) Platform/Website: Cengage...

Khushboo answered on Oct 14 2021
123 Votes
Worksheet
    
    VARCOST
    Variable Costing
    Data Section
    Actual production in units    100,000
    Sales in units
    80,000
    Sales price per unit    $30
    Variable manufacturing costs per unit    $14
    Variable selling costs per unit    $2
    Fixed manufacturing costs    $315,000
    Fixed selling expenses    $100,000
    Answer Section
    Income statement: Absorption costing
    Sales        $2,400,000
    Cost of goods sold:
    Variable manufacturing costs    $1,400,000
    Fixed manufacturing costs    315,000
    Total goods available for sale    $1,715,000
    Less ending inventory    343,000
    Cost of goods sold        1,372,000
    Gross profit        $1,028,000
    Selling expenses:
    Fixed selling expenses    $100,000
    Variable selling expenses    160,000
    Total selling expenses        260,000
    Operating income        $768,000
    Income statement: Variable costing
    Sales        $2,400,000
    Cost of goods sold:
    Variable manufacturing costs    $1,400,000
    Less ending inventory    280,000
    Variable cost of goods sold        1,120,000
    Manufacturing margin        $1,280,000
    Variable selling expenses        160,000
    Contribution margin        $1,120,000
    Fixed costs:
    Fixed manufacturing...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers