4.04 &4.05 answered
Cut in Copy Format Painter Clipboard MS Sans Serif 10A BIU - A Font A = = = EE 9 E Paste Wrap Text Merge & Center - $ - % Alignment Numb H B C D E F G Fixed and Variable Cost Determinations Unit Cost Calculations 8 The projected cost of a lamp is calculated based upon the projected increases or decreases to 9 current costs. The present costs to manufacture one lamp are Figurines Electrical Sets Lamp Shade Direct Labor Variable Overhead: Fixed Overhead $9.2000000 per lamp 1.2500000 per lamp 6.0000000 per lamp 2.2500000 per lamp (4'lamps/hr.) 0.2250000 per lamp 10.0000000 per lamp (based on normal capacity of 25,000 lamps) Cost per lamp: $28.9250000 per lamp 32 Expected increases for 20x2 39 When calculating projected increases round to SEVEN decimal places 50.0000000 1. Material Costs are expected to increase by 2.00% 43 . 2. Labor Costs are expected to increase by 3.00%. ... 2 3 4 5 6 7 8 9 10 11 12 13 13 14 15 16 17 READY FORMULAS DATA REVIEW VIEW E HOME INSERT PAGE LAYOUT 1 X Cut MS Sans Serif -10 Copy Paste BIU Format Painter Clipboard Font AAEE A EEE Wrap Text Merge & Center - S - % Alignment BICAD EFG 2 Expected increases for 20x2 9 When calculating projected increases round to SEVEN decimal places, 50.0000000 1. Material Costs are expected to increase by 2.00% 2. Labor Costs are expected to increase by 3.00%. IU OWN 3. Variable Overhead is expected to increase by 4.50% 4. Fixed Overhead is expected to increase to $270,000. 5. Fixed Administrative expenses are expected to increase to $60,000 6. Variable selling expenses (measured on a per lamp basis) are expected to increase by 3.50% 7. Fixed selling expenses are expected to be $39,000 in 20x2. 8. Variable administrative expenses (measured a per lamp basis) are expected to increase by 5.00% On the following schedule develop the following figures 1. 20x2 Projected Variable Manufacturing Unit Cost of a lamp. 2- 20x2 Projected Variable Unit Cost per lamp ... 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 DATA FORMULAS REVIEW VIEW A A 9. 3. FILE HOME INSERT PAGE LAYOUT % Cut MS Sans Serif - 10 ED Copy Paste BIU - A Format Painter Clipboard Font S Ee Wrap Text Merge & Center - ale Alignment F G C D E 2. Labor Costs are expected to increase by 3.00%. 3. Variable Overhead is expected to increase by 4.50%. 4. Fixed Overhead is expected to increase to $270,000. 5. Fixed Administrative expenses are expected to increase to $60,000. 6. Variable selling expenses (measured on a per lamp basis) are expected to increase by 3.50%. 7. Fixed selling expenses are expected to be $39.000 in 20x2. 8. Variable administrative expenses (measured a per lamp basis) are expected to increase by 5.00% 83 On the following schedule develop the following figures: 1- 20x2 Projected Variable Manufacturing Unit Cost of a lamp. 2- 20x2 Projected Variable Unit Cost per lamp. 3- 20x2 Projected Fixed Costs FORMULAS DATA REVIEW VIEW 2. W Copy A A A. FILE HOME INSERT PAGE LAYOUT A X Cut Arial -10 Paste Format Painter BIUB. Clipboard D15 X fr 2.295 Wrap Text Merge & Center - $ - %, 898 Co Number Font Alignment 9 Variable Manufacturing Unit Cost 20x1 Cost Projected Percent Increase 11 Figurines 13 Electrical Sets 14 Lamp Shade 15 Labor 16 Variable Overhead 20x2 Cost Rounded to 7 Decimal Places 9.3840000 (4.01} 1.2750000 4.02} 6.1200000 (4.03} 2.2950000{4.04) 0.2295000 4.05} 19 Projected Variable Manufacturing Cost Per Unit D 1 9.3035000 (406) FORMULAS DATA REVIEW VIEW 2. W Copy A A A. FILE HOME INSERT PAGE LAYOUT A X Cut Arial -10 Paste Format Painter BIUB. Clipboard D15 X fr 2.295 Wrap Text Merge & Center - $ - %, 898 Co Number Font Alignment 9 Variable Manufacturing Unit Cost 20x1 Cost Projected Percent Increase 11 Figurines 13 Electrical Sets 14 Lamp Shade 15 Labor 16 Variable Overhead 20x2 Cost Rounded to 7 Decimal Places 9.3840000 (4.01} 1.2750000 4.02} 6.1200000 (4.03} 2.2950000{4.04) 0.2295000 4.05} 19 Projected Variable Manufacturing Cost Per Unit D 1 9.3035000 (406)
