Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do I create the required income statements, plus a segmented income statement and a budget plan? Todd's Car Repair Income Statement: 2020 Actual $1,060,500
How do I create the required income statements, plus a segmented income statement and a budget plan?
Todd's Car Repair Income Statement: 2020 Actual $1,060,500 20201 Budget| $1,101,600 EXPENSE BREAKOUT: Variable: Material, Labor and Disposal Fixed: Rent, Utilities, Supervision, Depreciation, Maintenance, Insurance, IT/Phone, Supplies, Advertising Revenues Tires 918 700 Three Products: Oil Changes Brakes Tires 4.50 25 BUDGET # of activities Sales Price Labor hours Labor cost per hour Material cost Disposal cost Direct Material Direct Labor Disposal Rent Utilities Supervision Depreciation Maintenance Cost of Goods Sold Gross Profit Oil Brakes 6,120 1,530 25 200 0.35 2.00 25 $ 25 $ 6 $ 70 $ 2 $ - $ 475,250 224,680 35,000 42,000 22,000 50,000 50,000 12,000 $ 910,930 $ 149,570 511,020 233,325 35,190 42,000 24,000 50,000 50,000 7,000 $ 952,535 $ 149,065 400 $ $ $ 25 Selling & Administrative Insurance 12,000 IT/Phone 3,250 Supplies 2,800 Advertising 6,000 Total Selling & Administrative $ 24,050 10,000 3,000 3,000 5,000 $ 21,000 ACTUAL Oil Brakes Tires # of activities 7,000 1,400 800 Average Sales Price 24 210 748.12 Average Material Cost 7.25 65 416.88 Average Labor Hours 0.32 2.115 4.3 Average Labor Cost per hr 26 26 26 Average Disposal Cost 2.5 0 21.88 Put any rounding in Tires REQUIREMENTS Reqt 1a - Prepare Contribution Margin Income Statements from actual and budgeted 2020 in proper columns Reqt 1b - Prepare a Flexible Budget for 2020 in proper column of the Flexible Budget Report. Reqt 1c - Review the report and identify which variances should be investigated further and why. Operating Income $ 125,520 $ 128,065Step 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