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. Select Chapter 2 and scroll down and select "P16: MANUFACTURING ACCOUNTING (MFG)." This chapter goes hand in hand with the spreadsheet you are to complete.
The name of the lab assignment for this week is "MFG". It is due by 11:59 on MONDAY, September 6, 2021.
*****MUST INCLUDE:*****
- What if Section
- Chart Analysis Section
- Tickler Section
Worksheet MFG Manufacturing Accounting Data Section Depreciation--equipment$180,000 Direct labor2,568,000 Direct materials inventory, 1/1366,000 Direct materials inventory, 12/31372,000 Factory rent305,640 Finished goods, 1/1528,000 Finished goods, 12/31690,000 Indirect labor150,000 Indirect materials105,000 Purchases of direct materials2,580,720 Work in process, 1/1121,200 Work in process, 12/31114,660 Answer Section Twisp Industries Schedule of Cost of Goods Manufactured and Sold For the Year Ended December 31, 2011 Direct materials Direct materials inventory, 1/1$366,000 Add:TITLE AFORMULA1 Cost of direct materials available$0 Less:TITLE BFORMULA2 Cost of direct materials usedFORMULA3 Direct labor2,568,000 Manufacturing overhead: Factory rent$305,640 TITLE CFORMULA4 TITLE DFORMULA5 TITLE EFORMULA60 Total manufacturing costsFORMULA7 Work in process, 1/1121,200 Total work in process available$0 Less:TITLE FFORMULA8 Cost of goods manufacturedFORMULA9 TITLE GFORMULA10 Cost of goods available for saleFORMULA11 Less:Finished goods, 12/31690,000 TITLE HFORMULA12 Sheet1 CM SPR 20 Chart Chart Data Table MaterialsFORMULA3 Labor2568000 Overhead0 Chart Tickler Data Table 20112012 Materials Labor Overhead Components of Manufacturing Costs MaterialsLaborOverhead025680000