Answered step by step
Verified Expert Solution
Question
1 Approved Answer
All information provided in the screenshots. Answer yellow Please I See The Light Projected Income Statement For the Period Ending December 31, 20x1 Sales 25,000
All information provided in the screenshots. Answer yellow Please
I See The Light Projected Income Statement For the Period Ending December 31, 20x1 Sales 25,000 lamps @ $45.00 Cost of Goods Sold @ $28.93 Gross Profit Selling Expenses: Fixed Administrative Expenses 41,250.00 Total Selling and Administrative Expenses: Net Profit \begin{tabular}{rr} 143,000.00 \\ \hline$258,750.00 \\ \hline \hline \end{tabular} Cash Accounts Receivable $34,710.00 67,500.00 Inventory Raw Material FigurinesElectricalSetsWorkinProcessFinishedGoodsCurrentAssets500@500@03000@$9.20$1.25$28.92504,600.00625.0086,775.00$194,210.00 Fixed Assets Equipment Accumulated Depreciation $20,000.006,800.00 Total Fixed Assets Total Assets 13,200.00$207,410.00 Current Liabilities Accounts Payable Total Liabilities \begin{tabular}{cr} $ & 54,000.00 \\ \hline$54,000.00 \end{tabular} Stockholder's Equity Common Stock Retained Earnings Total Stockholder's Equity Total Liabilities and Stockholder's Equity \begin{tabular}{lr} & 153,410.00 \\ \hline$207,410.00 \\ \hline \hline \end{tabular} 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: Expected increases for 202 When calculating projected increases round to SEVEN decimal places, $0.0000000. 1. Material Costs are expected to increase by 6.50%. 2. Labor Costs are expected to increase by 5.50%. 3. Variable Overhead is expected to increase by 6.00%. 4. Fixed Overhead is expected to increase to $260,000. 5. Fixed selling expenses are expected to be $39,000 in 202. 6. Variable selling expenses (measured on a per lamp basis) are expected to increase by 2.00%. 7. Fixed Administrative expenses are expected to increase by $6,000. The total administrative expenses for 200 were $41,205.00, when 23,500 units were sold. Use the High-Low method to calculate the total fixed administrative expense. 8. Variable administrative expenses (measured on a per lamp basis) are expected to increase by 2.50%. The total administrative expenses for 200 were $41,205.00, when 23,500 units were sold. Use the High-Low method to calculate the variable administrative expense per lamp. following schedule develop the following figures: 1- 20x2 Projected Variable Manufacturing Unit Cost of a lamp. 2- 202 Projected Variable Unit Cost per lamp. 3- 202 Projected Fixed Costs. Big Al is about to begin work on the budget for 202 and they have requested that you prepare an analysis based on the following assumptions. 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 202 the selling price per lamp will be $45.00. What is the projected contribution margin and contribution marain ratio for each lamn sold? For 202 the selling price per lamp will be $45.00. How many lamps must be sold to breakeven? {5.03} For 202 the selling price per lamp will be $45.00. The desired operating income in 202 is $271,250. What would sales in units have to be in 202 to reach the profit aoal? - Sales in units (Round up to zero places, \#\#\#,\#\#\# units) {5.04} For 202 the selling price per lamp will be $45.00. The company would like to have a operating income equal to 32.00% of sales. If that is to be achieved, what would be the sales in units in 202 ? Sales in units (Round up to zero places, \#\#\#,\#\#\# units) If the company believed that it could only sell 25,000 lamps, what would the new selling price have to be so that the new contribution margin per unit is equal to last year's contribution margin per unit? New Selling Price (Round up to two places, $####### ) For 202 the selling price per lamp will be $45.00 and the effective tax rate is 37%. How many units must be sold to aenerated a oberatina income of $250.000 after taxes? Sales in units (Kound up to zero places, \#\#\#,\#\# units) If the company believes that the demand will be 27,500 units for the year. What selling price per lamp. rounded to two places, would qenerate a operating income of $826,500 ? {6.04}
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