Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can some one please correct this P&L for me. The numbers from Revenue ($) column to Labor cost are correct. The rest of the P&LI

Can some one please correct this P&L for me. The numbers from Revenue ($) column to Labor cost are correct. The rest of the P&LI i need help figuring out.

image text in transcribed

Residential w Blackstone CMR Customer P&L Total CMR Commercia Residential Blackstone Revenue (S) 3 8,868,000 1S 7,270,000 1,596,000 1,292,783 303 237 34% 14.6% 26% 28,928 Share of Revenue (%) Cost of Goods Sold 82.0% 34% 81,003 18 Materials as a % of Sales 26% Materials ($) S 2,888,760 S 2,471,800 414,960 336,118 78.842 6,785 1,867.458S 1,298,048 571,408 482,848 108.580 4,754.216 3,767,848 s 986,368 798,966 |s 187402 116,716 35,713 Labor (Hrs. Variable Manufacturing Cost (5) Manufacturing Contribution ($ 1784 3.502.152 -609632 40 -115-35 Manufacturing 46% 38 Scenario 1 Distribute SG&A based on revenue Sales, General and Administration (SG&A) (S Earnings Before Interests and Taxes (S) EBIT Earnings Before Interests and Taxes (% o, Sales, EBIT Share of EBIT by Segment Sconario 2-Assign indirect labor cost to corresponding segment, distribute SG&A based on revenue $ 2,900,000 S 2,378,000$ 522,000 422,820 $ 99.180 13.7% 15.5% 5.5% 5.5% 5.5% 43 35 50,000 0000Is 0.000s 0,000 Is 50.000 S 2.150,000 1,750,000 400,000 350,000 $ 50,000 Average Salary Total assignable indirect labor Controllable Margin by Sogment ($) Other SG&A EBIT 1,961,784 1,752,152 209,632 143,797I 65,835 Earnings Before Interests and Taxes (S) EBIT Earnings Before Interests and Taxes( of Sales) EBIT Share of EBIT byS Scenario 3-No Assign SG&A Indrectlabor (# of people) nt 43 Average Salary Total assignable indirect labor 50,000 $ 2,150,000 able Margin by Segment (3) EBIT Contribution to controllable Marginby Segment(%ofSales) Share of Contribution by Segment Other Indirect Costs (SG&A) EBIT (S) EBIT Residential w Blackstone CMR Customer P&L Total CMR Commercia Residential Blackstone Revenue (S) 3 8,868,000 1S 7,270,000 1,596,000 1,292,783 303 237 34% 14.6% 26% 28,928 Share of Revenue (%) Cost of Goods Sold 82.0% 34% 81,003 18 Materials as a % of Sales 26% Materials ($) S 2,888,760 S 2,471,800 414,960 336,118 78.842 6,785 1,867.458S 1,298,048 571,408 482,848 108.580 4,754.216 3,767,848 s 986,368 798,966 |s 187402 116,716 35,713 Labor (Hrs. Variable Manufacturing Cost (5) Manufacturing Contribution ($ 1784 3.502.152 -609632 40 -115-35 Manufacturing 46% 38 Scenario 1 Distribute SG&A based on revenue Sales, General and Administration (SG&A) (S Earnings Before Interests and Taxes (S) EBIT Earnings Before Interests and Taxes (% o, Sales, EBIT Share of EBIT by Segment Sconario 2-Assign indirect labor cost to corresponding segment, distribute SG&A based on revenue $ 2,900,000 S 2,378,000$ 522,000 422,820 $ 99.180 13.7% 15.5% 5.5% 5.5% 5.5% 43 35 50,000 0000Is 0.000s 0,000 Is 50.000 S 2.150,000 1,750,000 400,000 350,000 $ 50,000 Average Salary Total assignable indirect labor Controllable Margin by Sogment ($) Other SG&A EBIT 1,961,784 1,752,152 209,632 143,797I 65,835 Earnings Before Interests and Taxes (S) EBIT Earnings Before Interests and Taxes( of Sales) EBIT Share of EBIT byS Scenario 3-No Assign SG&A Indrectlabor (# of people) nt 43 Average Salary Total assignable indirect labor 50,000 $ 2,150,000 able Margin by Segment (3) EBIT Contribution to controllable Marginby Segment(%ofSales) Share of Contribution by Segment Other Indirect Costs (SG&A) EBIT (S) EBIT

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions