File Home Insert Draw Page Layout Formulas Data Review A1 X fx A B D E 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: $16.0000000 per lamp 2.0000000 per lamp (4 lamps/hr.) 10 11. Lamp Kit 16 Direct Labor 17 Variable Overhead: 2.0000000 per lamp 18 Fixed Overhead 19 20 Cost per lamp: 23 24 Expected increases for 20x2 10.0000000 per lamp (based on normal capacity of 25,000 lamps) $30,0000000 per lamp 25 When calculating projected increases round to TWO ($0.00) decimal places. 26 27 30 31 32 33 34 37 38 39 40 41 44 45 46 47 48 51 52 1. Material Costs are expected to increase by 2.00% 2. Labor Costs are expected to increase by 4.50% 3. Variable Overhead is expected to increase by 2.00% 4. Fixed Overhead is expected to increase to $260,000. 5. Fixed Administrative expenses are expected to increase to $54,000. 6. Variable selling expenses (measured on a per lamp basis) are expected to increase by 4.50% + 7. Fixed selling expenses are expected to be $31,000 in 20x2 8 Variable administrative expenses (measured a per lamp basis) are expected to increase by 6.50%. 53 On the following schedule develop the following figures: 54 55 58 59 60 61 62 65 1- 20x2 Projected Variable Manufacturing Unit Cost of a lamp. 2-20x2 Projected Variable Unit Cost per lamp. 3- 20x2 Projected Fixed Costs 3 4 5 6 7 8 10 11 12 13 14 15 Ready Accessibility Investigate