Answered step by step
Verified Expert Solution
Link Copied!

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?

image text in transcribed

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,065

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_2

Step: 3

blur-text-image_3

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

Public Sector Audit

Authors: Carolyn J. Cordery, David C. Hay

1st Edition

0367650622, 9780367650629

More Books

Students also viewed these Accounting questions

Question

Which of the sources is most cost effective?

Answered: 1 week ago