5 | Breakeven sales in units=Fixed cost/Contribution margin per unit | |||
Contribution margin per unit=Selling price-Variable cost | ||||
Variable cost decreased by $ 3 | ||||
Current variable cost=25.62-3=$ 22.62 | ||||
Contribution margin per unit=45-22.62=$ 22.38 | ||||
Breakeven sales in units=363000/22.38=16219.81=16220 | ||||
6 | Breakeven sales in units=Fixed cost/Contribution margin per unit | |||
Contribution margin per unit=Selling price-Variable cost | ||||
Selling price increased to $ 48 | ||||
Contribution margin per unit=48-25.62=$ 22.38 | ||||
Breakeven sales in units=363000/22.38=16219.81=16220 | ||||
7 | Breakeven sales in units=Fixed cost/Contribution margin per unit | |||
Contribution margin per unit=Selling price-Variable cost | ||||
Selling price decreased to $ 42 | ||||
Contribution margin per unit=42-25.62=$ 16.38 | ||||
Breakeven sales in units=363000/16.38=22161.17=22162 | ||||
4. For 20x2 the selling price per lamp will be $45.00. If the variable cost increase...
Variable Manufacturing Unit Cost 20x1 Cost Projected Percent Increase 20x2 Cost Rounded to 2 Decimal Places 2% Lamp Kit Labor Variable Overhead $16 $2 $ 2 2.50% .50% $16.32 $2.07 $2.05 {4.01) {4.02) (4.03) 2 Projected Variable Manufacturing Cost Per Unit $20.44 {4.04) Total Variable Cost Per Unit 20x1 Cost 20x2 Cost Rounded to 2 Decimal Places Projected Percent Increase 2.00% 6.00% Variable Selling Variable Administrative Projected Variable Manufacturing Unit Cost $3.00 $2.00 3.06 2.12 20.44 (4.05) {4.06) (4.04) Projected...
Variable Manufacturing Unit Cost 20x1 Cost 20x2 Cost Rounded to 2 Decimal Places Lamp Kit Labor Variable Overhead $16 $ 2 $ 2 Projected Percent Increase 2% 2 .50% 2 .50% $16.32 $2.07 $2.05 {4.01) (4.02) (4.03) Projected Variable Manufacturing Cost Per Unit $20.44 (4.04) Total Variable Cost Per Unit 20x1 Cost 20x2 Cost Rounded to 2 Decimal Places Projected Percent Increase 2.00% 6.00% Variable Selling Variable Administrative Projected Variable Manufacturing Unit Cost $3.00 $2.00 3.06 2.121 20.44 {4.05) (4.06)...
I See The Light, Inc Schedule of Projected Costs Variable Manufacturing Unit Cost 20x 1 Cost Projected Percent Increase 20x2 Cost Rounded to 2 Decimal Places 161 Lamp Kit Labor Variable Overhead 2 5% $16.64 $2.10 $2.10 {4.01) {4.02} {4.03) 2 5% Projected Variable Manufacturing Cost Per Unit $20.84 {4.04} Total Variable Cost Per Unit 20x1 Cost Projected Percent Increase 20x2 Cost Rounded to 2 Decimal Places 3 4% 3.12 Variable Selling Variable Administrative Projected Variable Manufacturing Unit Cost 2...
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...
I See The Light Projected Income Statement For the Period Ending December 31, 20x1 Sales Cost of Goods Sold Gross Profit Selling Expenses: $1,125,000.00 723,250.00 $ 401,750.00 25,000 lamps $45.00 $28.93 $23,000.00 Fixed Variable(Commission per unit)@ $3.15 78,750.00 $101,750.00 Fixed Administrative Expenses $42,000.00 Variable 1,500.00 43.9000 145,250.00 Total Selling and Administrative Expenses Net Profit 256,500.00 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...
Need help filling out the yellow cells. (10.01-10.1). Also included the extra information needed to solve and all numbers already in yellow are correct, thanks! 2 Materials Budget Lamp Kits Needed for Production Desired Ending Inventory Total Needed Less: Beginning Inventory Total Purchases Cost per piece Cost of Purchases (Round to two places, $##.##) 34,400 units 600 units 35,000 units 500 units {8.01} {8.02) {8.03} {8.04} 34,500 units 16.96 $ $ 16.96 585,120.00 {8.05) {8.06) 3 Direct Labor Budget $...
Hello I figured out some of the boxes so the yellow boxes that are filled in are correct but the other yellow boxes I am having a hard time figuring out can you help? thank you Projected Income Statement For the Period Ending December 31, 20x1 $45.00 $30.00 $ 1,125,000.00 750,000.00 $ 375,000.00 Sales 25,000 lamps @ Cost of Goods Sold @ Gross Profit Selling Expenses: Fixed Variable Commission per unit) Administrative Expenses: Fixed Variable @ Total Selling and Administrative...
only anser the yellow shaded boxes Arial B92. SM2594 [Compatibility Mode] - Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW X Cut -10A A = = = Wrap Text En Copy - BIU - 2 - Et Merge & Center - $ - % , Format Painter 8. Con Fom Clipboard Font E l Alignment Number Num - X for ABC I See The Light Projected Income Statement For the Period Ending December 31, 20x1 $ 1,125,000.00 723,250.00 $...
PAGE LAYOUT FORMULAS DATA REVIEW VIEW py Arial BIU- 10A A - Wrap Text Merge & Center - amat Painter E E $ .% , * & Co ard Font Alignment Number IX & fx - BCD I F G H I See The Light Projected Income Statement For the Period Ending December 31, 20x1 . $45.00 $28.93 $ 1.125,000.00 723,250.00 $ 401,750.00 Sales 25,000 lamps @ Cost of Goods Sold @ Gross Profit Selling Expenses: Fixed Variable (Commission per...
Please help with 9.01 - 10.10 Thank you very much!!! Let me know if you need any more information. I See The Light Projected Income Statement For the Period Ending December 31, 20x1 $ 1,125,000.00 750,000.00 375,000.00 $ Sales 25,000 lamps @ $45.00 Cost of Goods Sold @ $30.00 Gross Profit Selling Expenses: Fixed Variable (Commission per unit) @ $3.00 Administrative Expenses: Fixed Variable @ $2.00 Total Selling and Administrative Expenses: Net Profit $ 23,000.00 75,000.00 $ 98,000.00 $ 42,000.00...