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: Lamp Kit: Direct Labor: Variable Overhead: Fixed Overhead: $16.0000000 per lamp 2.0000000 per lamp (4 lamps/hr.) 2.0000000 per lamp 10.0000000 per lamp (based on normal capacity of 25,000 lamps) Cost per lamp: $30.0000000 per lamp Expected increases for 20x2 When calculating projected increases round to TWO ($0.00) decimal places. 1. Material Costs are expected to increase by 2.00% . 2. Labor Costs are expected to increase by 5.50%. 3. Variable Overhead is expected to increase by 4.00%. 4. Fixed Overhead is expected to increase to $265,000. 5. Fixed Administrative expenses are expected to increase to $50,000. 6. Variable selling expenses (measured on a per lamp basis) are expected to increase by 5.50%. 7. Fixed selling expenses are expected to be $29,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. 3- 20x2 Projected Fixed Costs. Variable Manufacturing Unit Cost 20x1 Cost 20x1 Cost Projected Percent Increase 20x2 Cost Rounded to 2 Decimal Places Lamp Kit Labor Variable Overhead $16.32 $2.11 $2.08 {4.01) {4.02) {4.03) Projected Variable Manufacturing Cost Per Unit $20.51 {4.04) Total Variable Cost Per Unit 20x1 Cost 20x1 Cost Projected Percent Increase 20x2 Cost Rounded to 2 Decimal Places Variable Selling Variable Administrative Projected Variable Manufacturing Unit Cost 1.06 1.05 {4.05) You entered 1.055 please round to 2 places, Eround(##/##,2) {4.06) {4.04) Projected Total Variable Cost Per Unit {4.07) Schedule of Fixed Costs 20x1 Cost 20x2 Cost Projected Percent Increase $ 265,000.00 {4.08) lamps @) Fixed Overhead (normal capacity of Fixed Selling Fixed Administrative $ 29,000.00 50,000.00 {4.09) {4.10) $ Projected Total Fixed Costs $ 344,000.00 {4.11)