Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i need help with 6.01-6.04 the rest should be all of the information you should need. thank you I See The Light Projected Balance Sheet
i need help with 6.01-6.04 the rest should be all of the information you should need. thank you
I See The Light Projected Balance Sheet As of December 31, 20x1 Current Assets Cash 34,710.00 Accounts Receivable 67,500.00 Inventory Raw Material 500 @ Lamp Kits Work in Process 8,000.00 $16.00 C 3000 @$30.00 Finished Goods Total Current Assets 90,000.00 200,210.00 Fixed Assets Equipment Accumulated Depreciation 20,000.00 6,800.00 Total Fixed Assets 13,200.00 213,410.00 Total Assets Current Liabilities Accounts Payable 54,000.00 Total Liabilities 54,000.00 Stockholder's Equity Common Stock 12,000.00 Retained Earnings Total Stockholder's Equity Total Liabilities and Stockholder's Equity 147,410.00 159,410.00 213,410.00 A D E E H PART 1 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: Lamp Kit Direct Labor $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) Variable Overhead: Fixed Overhead $30.0000000 per lamp 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 3.00 %. 2. Labor Costs are expected to increase by 6.50 %. 3. Variable Overhead is expected to increase by 2.00 % 4. Fixed Overhead is expected to increase to $295,000 expected to increase to $50,000 5. Fixed Administrative expenses are 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 $33,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. 7 Introduction 3 FAQ 1 2 4 5 6 C 10 11 12 1 Variable Manufacturing Unit Cost 20x1 Cost Projected 20x2 Cost Rounded to 2 Decimal Places Percent Increase (4.01 Lamp Kit 16 $16.48 (4.02 {4.03 65 Labor $2.13 2 Variable Overhead S2.04 (4.04) 20 Projected Variable Manufacturing Cost Per Unit $20.65 2 4 Total Variable Cost Per Unit 20x1 Cost Projected 20x2 Cost Rounded to Percent 2 Decimal Places Increase Variable Selling 4.05 You entered 3.105 please round to 2 places, round( # ##2 3.5 3.11 Variable Administrative {4.06) 2 2 10 (4.04) 20 20.69 Projected Variable Manufacturing Unit Cost {4.07) You entered 25.855 please round to 2 places, =round( # # ##,2) Projected Total Variable Cost Per Unit 25.86 25 7 0Schedule of Fixed Costs Projected 20x1 Cost 20x2 Cost Percent Increase 295,000.00 (4.08h Fixed Overhead lamps (normal capacity of S {4.09) Fixed Selling 33,000.00 {4.10 50,000.00 Fixed Administrative (4.11 Projected Total Fixed Costs 378,000.00 3 Note: Remember, that we cannot sell part of a lamp, therefore to find the number of units you have to round up to the next complete unit. Furthuremore, to find the required sales in dollars it may be easier to find the number of units and then multiply by the selling price per unit. For 20x2 the selling price per lamp will be $45.00 What is the projected contribution marqin and contribution 1 margin ratio for each lamp sold? 45-25.86 19.14/45 100 Contribution Margin per unit (Round to two places, S## # #) 5.01 $19.14 (5.02 Contribution Margin Ratio (Round to four places,% is two of those places ### # % ) 42.53% 2. For 20x2 the selling price per lamp will be $45.00. The desired net income in 20x2 is S207,500. What would sales in units have to be in 20x2 to reach the profit goal? 585500 5.03 Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if need 30,590 units For 20x2 the selling price per lamp will be $45.00. If the fixed cost increase by $40,000.00 how many lamps must be sold to breakeyen? 418000 # (5.04 Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if need 21.839 units 4. For 20x2 the selling price per lamp will be $45.00. If the variable cost increase by S4.00 a unit how many lamps must be sold to breakeven? 29.86 25.86 15.14 Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if needed) {6.01 5. For 20x2 the selling price per lamp will be $45.00. If the variable cost decreased by $4.00 a unit how m must be sold to breakeven? lamps 6.02 Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if needed) 6. If for 20x2 the selling price per lamp is increased to $49.00 a unit how many lamps must be sold to breakeven? 6.03 Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if needed) 7 If for 20x2 the selling price per lamp is decreased to $41.00 a unit how many lamps must be sold to breakeven? {6.04 Breakeven sales in units (Since we cannot sell part of a unit round up to the next unit if needed)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