please help fill in the yellow blanks!!!
can you assist with just these two? this is all of the info given
I See The Light Projected Balance Sheet As of December 31, 20x1 $ 34.710.00 67,500.00 Current Assets Cash Accounts Receivable Inventory Raw Material Figurines Electrical Sets Work in Process Finished Goods Total Current Assets 500 $9.20 500 @ $1.25 0 3000 @ $28.9250 4,600.00 625.00 86,775.00 $ 194,210.00 Fixed Assets Equipment Accumulated Depreciation Total Fixed Assets Total Assets $ 20,000.00 6,800.00 13,200.00 $207,410.00 $ $ 54,000.00 54,000.00 Current Liabilities Accounts Payable Total Liabilities Stockholder's Equity Common Stock Retained Eamings Total Stockholder's Equity Total Liabilities and Stockholder's Equity $ 12,000.00 141,410.00 153,410.00 $ 207,410.00 PART 1 Fixed and Variable Cost Determinations Unit Cost Calculations The projected cost of a lamp is calculated based upon the projected increases or decreases to current costs. The present costs to manufacture one lamp are: Figurines $9.2000000 per lamp Electrical Sets 1.2500000 per lamp Lamp Shade 6.0000000 per lamp Direct Labor 2.2500000 per lamp (4 lamps/hr.) Variable Overhead: 0.2250000 per lamp Fixed Overhead: 10.0000000 per lamp (based on normal capacity of 25,000 lamps) Cost per lamp: $28.9250000 per lamp 2 Expected increases for 20x2 3 When calculating projected increases round to SEVEN decimal places, 50.0000000. 1 1 1. Material CC are expected to increase by 3.00% 3 2. Labor Costs are expected to increase by 3.00% 4 5 3. Variable Overhead is expected to increase by 3.50% 2 3 4. Fixed Ovemead is expected to increase to $260,000 54 55 5. Fixed selling expenses are expected to be $39.000 in 20x2. 56 53 6. Variable selling expenses (measured on a per lamp basis) are expected to increase 34 by 3.50%. 35 56 7 Fixed Administrative expenses are expected to increase by $2,000. 37 The total administrative expenses for 20x0 were $40,625.00, when 74 22,500 units were sold. Use the High-Low method to calculate 75 the total fixed administrative expense. 76 JU C Variable Overhead: Fixed Overhead: D E F G H 0.2250000 per lamp 10.0000000 per lamp (based on normal capacity of 25,000 lamps) $28.9250000 per lamp Cost per lamp: Expected increases for 20x2 When calculating projected increases round to SEVEN decimal places, $0.0000000. 1. Material Costs are expected to increase by 3.00% 2. Labor Costs are expected to increase by 3.00%. 3. Variable Overhead is expected to increase by 3.50%. 3 4. Fixed Overhead is expected to increase to $260,000 5. Fixed seling expenses are expected to be $39,000 in 20x2. 6. Variable seling expenses (measured on a per lamp basis) are expected to increase by 3.50% 7 Fixed Administrative expenses are expected to increase by $2,000. The total administrative expenses for 20x0 were $40,625.00, when 22,500 units were sold. Use the High-Low method to calculate the total fxed administrative expense. B 8. Variable administrative expenses (measured on a per lamp basis) are expected to increase by 5.00%. The total administrative expenses for 20x0 were 5 $40,625.00, when 22,500 units were sold. Use the High-Low method to calculate 6 the variable administrative expense per lamp. 7 8 on the following schedule develop the following figures: 9 1- 20x2 Projected Vanable Manufacturing Unit Cost of a lamp. 6 7 2- 20x2 Projected Variable Unit Cost per lamp. 8 9 3- 20x2 Projected Fixed Costs. 0 07 08 09 Variable Manufacturing Unit Cost 20x 1 Cost 20x2 Cost Rounded to 7 Decimal Places Projected Percent Increase 3% 3% 9.2 1.25 6 3% Figurines Electrical Sets 3 Lamp Shade 5 Labor Variable Overhead 7 8 Projected Variable Manufacturing Cost Per Unit 9 -1 $9.4760000 $1.2875000 $6.1800000 $2.3175000 $0.2328750 {4.01) {4.02) (4.03) {4.04) {4.05) 3% 2.25 0.225 4% 18.925 $19.4938750 (4.06) 23 Total Variable Cost Per Unit 20x1 Cost 20x2 Cost Rounded to 7 Decimal Places Projected Percent Increase 3.50% 5% 3.15 3.2602500 (4.07) (4.08) {4.09) $19.49 18.925 22.135 {4.06) {4.10) 24 25 Variable Selling 27 Variable Administrative 20x1 28 Variable Administrative 20x2 29 330 Projected Variable Manufacturing Unit Cost 31 Projected Total Variable Cost Per Unit 33 34 35 36 Schedule of Fixed Costa 37 39 Fixed Overhead 40 normal capacity of lamps @_) 41 Fxed Seling 42 Fixed Administrative 20x1 43 Fixed Administrative 20x2 45 Projected Total Fixed costs 46 47 20x1 Cost Projected Increase 20x2 Cost Rounded to 2 Decimal Places 260,000 25000 lamps @ 10.4 (4.11) (4.12) (4.13) (4.14) (4.15) 18.925 $19.4938750 {4.06) Triumu variable Manufacturing Cost Per Unit 19 21 22 23 Total Variable Cost Per Unit 20x 1 Cost Projected Percent Increase 3.50% 20x2 Cost Rounded to 7 Decimal Places 3.15 0.0500000 3.2602500 (4.07) (4.08) (4.09) 24 25 Variable Selling 27 Variable Administrative 20x1 28 Variable Administrative 20x2 29 30 Projected Variable Manufacturing Unit Cost 31 Projected Total Variable Cost Per Unit 33 34 35 36 Schedule of Fixed Costs 18.925 22.135 $19.49 {4.06) (4.10) 20x 1 Cost Projected Increase 20x2 Cost Rounded to 2 Decimal Places lamps @_) 260,000 25000 lamps @ 10.4 {4.11) 37 39 Fixed Overhead 40 (normal capacity of 41 Fixed Selling 42 Fixed Administrative 20x1 43 Fixed Administrative 20x2 45 Projected Total Fixed Costs 46 47 39,000.00 (4.12) (4.13) (4.14) (4.15) I See The Light Projected Balance Sheet As of December 31, 20x1 $ 34,710.00 67,500.00 4,600.00 625.00 Current Assets Cash Accounts Receivable Inventory Raw Material Figurines Electrical Sets Work in Process Finished Goods Total Current Assets Fixed Assets Equipment Accumulated Depreciation Total Fixed Assets Total Assets 500 @ $9.20 500 @ $1.25 0 3000 @ $28.9250 86,775.00 194,210.00 $ 20,000.00 6,800.00 13,200.00 $207,410.00 $ $ 54,000.00 54,000.00 Current Liabilities Accounts Payable Total Liabilities Stockholder's Equity Common Stock Retained Eamings Total Stockholder's Equity Total Liabilities and Stockholder's Equity $ 12,000.00 141,410.00 153.410.00 $ 207,410.00 F E F G The projected cost of a lamp is calculated based upon the projected increases or decreases to current costs. The present costs to manufacture one lamp are: Figurines $9.2000000 per lamp Electrical Sets 1.2500000 per lamp Lamp Shade 6.0000000 per lamp Direct Labor 2.2500000 per lamp (4 lamps/hr.) Variable Overhead: 0.2250000 per lamp Fixed Overhead: 10.0000000 per lamp (based on normal capacity of 25,000 lamps 3 0 Cost per lamp: $28.9250000 per lamp 1 2 Expected increases for 20x2 3 When calculating projected increases round to SEVEN decimal places, $0.0000000 4 N- -1 1. Material Costs are expected to increase by 3.00%. -2 3 2. Labor Costs are expected to increase by 3.00%. 4 15 3. Variable Overhead is expected to increase by 3.50%. 52 53 4. Fixed Overhead is expected to increase to $260,000. 54 55 5. Fixed selling expenses are expected to be $39,000 in 20x2. 56 63 6. Variable selling expenses (measured on a per lamp basis) are expected to increase 64 by 3.50% 65 66 7 Fixed Administrative expenses are expected to increase by $2,000. 67 The total administrative expenses for 20x0 were $40,625.00, when 74 22,500 units were sold. Use the High-Low method to calculate 75 the total fixed administrative expense. 76 77 8. Vanable administrative expenses (measured on a per lamp basis) are expected to 78 increase by 5.00%. The total administrative expenses for 20x0 were 85 $40,625.00, when 22,500 units were sold. Use the High-Low method to calculate 86 the variable administrative expense per lamp. 87 88 On the following schedule develop the following figures: 89 1- 20x2 Projected Variable Manufacturing Unit Cost of a lamp. 96 97 20x2 Proiected Variable
