Having a really difficult time with these need help finding the blanks and everything really
B C D E M N O Q R S Financial Statement Manufacturing / Cost Cost Amount Classification Non-manufacturing Behavior Requirement 1: Classify Costs According to Purpose: Classify the costs shown according to Financial Statement, Manufacturing/Non-Manufacturing, and Cost Behavior type. 2 Equipment depreciation: commercial kitchen $ 20,000 Requirement 2: Pivot Tables and Charts: 3 Furniture depreciation: storefront $ 12,000 a. Create a new pivot table and pivot chart (stacked column chart) on a new worksheet that shows total product and period costs Production supervision: commercial kitchen $ 50,000 (financial statement classification) broken down by manufacturingon-manufacturing type. Name that worksheet Req 2a. Sales supervision: retail storefront 35,000 Answer the following questions: Indirect labor: maintenance & repairs 6,000 1. What are the total selling costs? Indirect labor: raw materials sourcing $ 15,000 2. What are the total administrative costs? 8 Indirect labor: online shipping $ 20,000 3. What are the total period costs? 9 Indirect materials: spices $ 55,000 4. What are the total product costs? 10 Indirect materials: hairnets 3,500 5. What is the grand total of all costs? 11 Indirect materials: gloves $ 5,500 b. Create a new pivot table and pivot chart (stacked column chart) on a new worksheet that shows total variable and fixed costs 12 Indirect materials: testing supplies $ 18,000 4 13 Utilities: electricity (commercial kitchen) (cost behavior) broken down by manufacturingon-manufacturing type. Name that worksheet Req 2b. Answer the following $ 15,000 questions: 14 Utilities: electricity (retail storefront) 2,400 1. What are the total fixed costs? 15 Utilities: heating (commercial kitchen) 4,500 2. What are the total variable costs? 16 Utilities: heating (retail storefront) S 8,000 3. What are the total direct materials costs? 17 Insurance: property (commercial kitchen) $ 3,000 4. What are the total direct labor costs? 18 Insurance: liability (retail storefront) 2,500 5. What are the total MOH costs? 19 Insurance: delivery van 3,500 Requirement 3: Use the Pivot Tables and Charts to Complete Income Statements 20 Insurance: medical (all employees) $ 16,500 a. Use the two pivot tables and charts created in Requirement 2 to complete both the traditional and contribution format 21 Insurance: workers' compensation (all employees) $ 3,900 income statement on the Req 3 worksheet. Assume a sales volume of $950,000. What do you notice about total net operating 22 Property taxes: commercial kitchen $ 6,000 income between the two formats? 23 Payroll taxes: production staff $ 4,500 24 Payroll taxes: retail storefront $ 5,500 1. Net Income is the between the two formats. 25 Other salaries: retail store manager $ 4,000 26 Other salaries: retail staff $ 75,000 27 Other salaries: accounting staff $ 30,000 28 Direct materials (primary ingredients) $ 165,000 29 Direct labor (commercial kitchen production staff) $ 89,000 30 Marketing & advertising $ 22,000 31 Retail store supplies $ 18,000 32 Owner salary $ 100,000 33 34
