Do the task as given and solve it with Excel. Show solutions. A small construction product manufacturing company manufactures three types of constructionfasteners.a) Complete the table using Excel formulas.b) How many units of the most profitable product should at least be sold so that the company'stotal profit would increase by 5%? Profitability is measured by gross margin %.c) In addition, use Excel's chart function to draw a profitability patternBracket ABracket BBracket CTotalQuantity sold (pcs)190130350Unit price (€/piece)220,00 €98,00 €290,00 €Change (€/piece)120,00 €75,00 €150,00 €Sales (€)Change (€)Margin (€)Fixed costs (€)Margin %Result (€)Critical point (€)Safety margin (€)Safety Margin %34 300,00 €

To solve this task using Excel, we will first fill in the table with formulas for the calculations.…

Answered: A small construction product…

Structural Analysis

6th Edition

ISBN:9781337630931

Author:KASSIMALI, Aslam.

Publisher:KASSIMALI, Aslam.

Chapter2: Loads On Structures

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

need to solve the question in handwriting Q2: A father wants to save for his child's college expenses. The father opens an account with 7% annual interest. Assuming that the child enters college at age of 18 and the expenses of the college is $40,000 per year. The college is 4-year program. The father will make equal annual payments at the end of each year starting from the end of the birthing year until the age of 18. What will be the annual payment (deposit) that the father shall make? Support your answer by cash flow diagram. (
Please use given equation if you need.
Solve for each problems. Show your solution legible and neatly. Write the question, the given(also what is the given?), what to find and a cash flow diagram. Answers should be in 2 decimal places, unless stated otherwise. Solution should be hand-written. Question can be hand-written or type-written. Answer should be in 2 decimal places. 21. If the nominal interest rate is 3% of P5,000, how much worth in 15 years continuously compounded account? 22. You deposited $15,000 in a savings account five years ago. The account has earned 5.25% interest compounded continuously since then. How much money is in the account today? 23. A young engineer wants to surprise her husband with a European vacation for their tenth anniversary, which is five years from now. She determine that the trip will cost $7,000. Assuming an interest rate of 5.5% compounded daily, approximately how much money does she need to deposit today for the trip? 24. Mr. Ayala borrows P1,000. In 4 years, the money become P2,500…

Recommended textbooks for you

Structural Analysis

Civil Engineering

ISBN:

9781337630931

Author:

KASSIMALI, Aslam.

Publisher:

Cengage,

Structural Analysis (10th Edition)

Civil Engineering

ISBN:

9780134610672

Author:

Russell C. Hibbeler

Publisher:

PEARSON

Principles of Foundation Engineering (MindTap Cou…

Civil Engineering

ISBN:

9781337705028

Author:

Braja M. Das, Nagaratnam Sivakugan

Publisher:

Cengage Learning

Structural Analysis

Civil Engineering

ISBN:

9781337630931

Author:

KASSIMALI, Aslam.

Publisher:

Cengage,

Structural Analysis (10th Edition)

Civil Engineering

ISBN:

9780134610672

Author:

Russell C. Hibbeler

Publisher:

PEARSON

Principles of Foundation Engineering (MindTap Cou…

Civil Engineering

ISBN:

9781337705028

Author:

Braja M. Das, Nagaratnam Sivakugan

Publisher:

Cengage Learning

Fundamentals of Structural Analysis

Civil Engineering

ISBN:

9780073398006

Author:

Kenneth M. Leet Emeritus, Chia-Ming Uang, Joel Lanning

Publisher:

McGraw-Hill Education

Sustainable Energy

Civil Engineering

ISBN:

9781337551663

Author:

DUNLAP, Richard A.

Publisher:

Cengage,

Traffic and Highway Engineering

Civil Engineering

ISBN:

9781305156241

Author:

Garber, Nicholas J.

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS