Answered step by step
Verified Expert Solution
Question
1 Approved Answer
It seems like a lot of work but is not. I've work a lot of the answers and most of the pictures are background information!
It seems like a lot of work but is not. I've work a lot of the answers and most of the pictures are background information! I just need the answers for the YELLOW EMPTY BOXES!!! PLEASE address the answers with the cell number, EXAMPLE: Lamp Kit $16.40 {4.01}
I'm missing the answers: {5.03} , {6.02} and {6.03} , {8.05} and {8.06} , {9.09} {9.1} {9.11} {9.12} {9.13} , {10.01} {10.02} {10.03} {10.04} {10.05} {10.06} {10.07} {10.08} {10.09} {10.10} , {15.01} all the way down to {17.07}. Thank you in advance!:)
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: $16.0000000 per lamp Lamp Kit: Direct Labor: Varable Overhead Fixed Overhead: 2.0000000 per lamp (4 lamps/hr.) 2.0000000 per lamp 0.0000000 per lamp (based on normal capacity of 25,000 lamps) Cost per lamp: Expected increases for 20x2 When calculating projected increases round to TWO (S0.00) decimal places. 1. Material Costs are expected to increase by 2.50% 2. Labor Costs are expected to increase by 5.00%. 3. Variable Overhead is expected to increase by 5.50%. 4. Fixed Overhead is expected to increase to $300,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 3.00%. 7. Fixed selling expenses are expected to be $35,000 in 20x2. 8. Variable administrative expenses (measured a per lamp basis) are expected to increase by 2.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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started