Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with #5 and #6. 4 5 Below is the budgeted P&L Statement for Pittsburgh Tools, Inc - Cordless Division. Pittsburgh Tools -

I need help with #5 and #6. image text in transcribed
image text in transcribed
image text in transcribed
4 5 Below is the budgeted P&L Statement for Pittsburgh Tools, Inc - Cordless Division. Pittsburgh Tools - Cordless Division Budgeted Quarterly Product Line Contribution Margin Analysis 18v Drill/Driver 18v Circular Saw 18V Light Total Sales Volume (units) 4,300 3,100 5,590 12,990 Revenue $537,500 $125.00 $465,000 $150.00 $279,500 $50.00 $1,282,000 Variable costs 223,600 52.00 210 800 68.00 156,520 28.00 590, 920 Contrbution Margin $313,900 $73.00 $254,200 $82.00 $122,980 $22.00 $691,080 Assigned Foxed Costs Production costs 128.000 132,000 113,000 373,000 Segment Margin $185,900 $122.200 $9,980 $318,080 Common Fixed Production 30,000 Fixed SG&A expenses 200.000 Operating income $88,080 Income taxes (21%) 18,497 Net Operating income 69,583 1. Referring to the original Budgeted P&L and using DOL, estimate the increase in pretax operating income if sales volume increased by 5%. 2. Determine the breakeven point, in units, for the Circular Saw product line individually. 3. Determine the budgeted weighted average contribution margin ratio (WACM%) for the cordless division 4. Determine the budgeted sales mix based on revenue 1. Referring to the original Budgeted P&L and using DOL, estimate the increase in pretax operating income if sales volume increased by 5%. 2. Determine the breakeven point, in units, for the Circular Saw product line individually. I 3. Determine the budgeted weighted average contribution margin ratio (WACM%) for the cordless division. 4. Determine the budgeted sales mix based on revenue. 5. Assume the current sales mix remains the same as expected in the quarter; determine the sales revenue (in total and by product line) necessary for the division to achieve $80,000 after-tax profit. I 6. CHALLENGE! Pittsburgh Tools is considering increasing its advertising for the quarter, adding $10,000 of advertising expenses. Historically, sales volume increases uniformly across the product lines by 1% for each $5,000 of additional advertising budget. Is this worthwhile? Document your analysis and comment on the results

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Auditing Assurance And Risk

Authors: W. Robert Knechel, Steve Salterio, Brian Ballou

3rd Edition

0324313187, 9780324313185

More Books

Students also viewed these Accounting questions

Question

Who may qualify for a Guaranteed Income Supplement (GIS)?

Answered: 1 week ago

Question

=+7. What is the big message you want them to know?

Answered: 1 week ago