Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can you help me with this looking at the spread sheet submit a maximum 2-page written analysis that evaluates the current health of the company..

Can you help me with this looking at the spread sheet submit a maximum 2-page written analysis that evaluates the current health of the company.. Include information you gained based on the variance analysis and the data from the financial statements.

Great Plains Energy Corporation
Variance Analysis
For the Month Ended April 2020
Breakdown (all numbers in thousands) April 2020 Actual April 2020 Budget Variance % Variance Explanation for +/- Variances exceeding 3% April 2020 YTD Actual April 2020 Budget
Total Revenue 354,167 443,750 (89,583) -20% Total Revenue 1,345,833 1,775,000
Cost of Revenue
Direct Labor (82,529) (104,315) 21,786 -21% Direct Labor (313,611) (417,259)
Direct Materials (includes Oil Depletion) (188,088) (196,273) 8,185 -4% Direct Material Cost (714,736) (785,093)
Manufacturing Overhead (20,632) (26,079) 5,446 -21% Manufacturing Overhead (78,403) (104,315)
Total Cost of Revenue (291,250) (326,667) 35,417 -11% Total Cost Revenue (1,106,750) (1,306,667)
Gross Profit 62,917 117,083 (54,167) -46% Gross Profit 239,083 468,333
Operating Expense
Sales & Administrative Compensation 45,950 46,750 (800) -2% 183,800 187,000
Depreciation and Amortization 27,124 26,966 158 1% 108,495 107,865
Selling General and Administrative Expenses 10,450 10,280 170 2% 41,800 41,119
Other Operating Expenses 4,650 4,604 46 1% 18,600 18,417
Total Operating Expenses 88,174 88,600 (427) 0% 352,695 354,401
Operating Income (25,257) 28,483 (53,740) -189% Operating Income (113,612) 113,932
Other Income / (Expense)
Interest Income (Non Operating) 833 1,250 (417) -33% Interest Income 3,333 5,000
Other Income / (Expense) (6,688) 96,875 (103,563) -107% Other Income (26,750) 387,500
Gain / (Loss) on Sale of Investments (3,563) 4,313 (7,875) -183% Sales of Investments (14,250) 17,250
Pretax Income / (Loss) before Interest & Taxes (34,674) 130,920 (165,594) -126% Pretax Income (151,278) 523,682
Interest Expense (Non Operating) 14,583 15,417 (833) -5% Interest Expense 58,333 61,667
Pretax Income / (Loss) after Interest & before Taxes (49,257) 115,504 (164,761) -143% Pretax Income (151,278) 462,015
Tax Expense (10,344) 24,256 (34,600) -143% Tax Expense 97,023
Net Income / (Loss) Continuous Operations (38,913) 91,248 (130,161) -143% Continious Operations (151,278) 364,992

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

Technical Analysis Of The Financial Markets

Authors: John J. Murphy

1st Edition

0735200661, 978-0735200661

More Books

Students also viewed these Finance questions