Question
Earleton Manufacturing Company has $2 billion in sales and $800,000,000 in fixed assets. Currently, the company's fixed assets are operating at 75% of capacity. The
Earleton Manufacturing Company has $2 billion in sales and $800,000,000 in fixed assets. Currently, the company's fixed assets are operating at 75% of capacity. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
-
What level of sales could Earleton have obtained if it had been operating at full capacity? Write out your answer completely. Round your answer to the nearest cent.
$ _______
-
What is Earleton's target fixed assets/sales ratio? Round your answer to two decimal places.
_______%
-
If Earleton's sales increase 40%, how large of an increase in fixed assets will the company need to meet its target fixed assets/sales ratio? Write out your answer completely. Do not round intermediate calculations. Round your answer to the nearest dollar.
$_______
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