
Essentials Of Investments
11th Edition
ISBN: 9781260013924
Author: Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Question
Subject:- finance

Transcribed Image Text:Excel Online Structured Activity: Excess capacity
Earleton Manufacturing Company has $2 billion in sales and $700,000,000 in fixed assets. Currently, the company's fixed assets are operating at 75% of capacity. The data has
been collected the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
Open spreadsheet
a. 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.
$
b. What is Earleton's target fixed assets/sales ratio? Round your answer to two decimal places.
11
12
c. If Earleton's sales increase 35%, 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.
$
%
Check My Work
Reset Problem
1 Excess capacity
2
3
4
5
Sales
Fixed assets
% Fixed assets capacity
6
7
8
9
10 Calculation of Target Fixed Assets-to-Sales Ratio:
Target fixed assets-to-sales ratio
Cacluation of Full Capacity Sales:
Full capacity sales
% Sales increase
A
13
14
15
16 New sales level
17
18
Calculation of Fixed Assets Increase Needed:
Increase in fixed assets
B
$2,000,000,000.00
$700,000,000.00
75.00%
35.00%
с
D
Formulas
#N/A
#N/A
#N/A
#N/A
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 5 steps with 2 images

Knowledge Booster
Similar questions
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education

Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,



Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,

Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education