Answered step by step
Verified Expert Solution
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
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