Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q-Constructions has tasked you to investigate the number of construction projects per year for which the company would need to break-even and make a profit

Q-Constructionshas tasked you to investigate the number of construction projects per year for which the company would need to break-even and make a profit of $500,000 per year. The average price of a building contract is $700,000 per project. The following are the fixed and variable costs of Q-Constructionsin Table 2:

Description

Cost

Office Space

55,000

Professional Staff Salaries

205,000

Insurances

50,000

Machine Maintenance

80,000

Website Management

30,000

On-site workers salaries

$120,000 per project

Average Material Cost

60% of the project price per project

Table 2: Associated Costs of Q-Constructions

A) Use this information above to complete the requested analyses below.

i. The break-even number of projects needed by the company.

ii. The income made by the company at break-even.

b. Q-Constructionsis interested in making a profit per year to ensure the company has a positive financial outlook and new ventures can be done in the future. Calculate how many projects per year need to be completed to make a profit of $500,000 per year.

c. Q-Constructions workers have approached the building union and been informed they could be paid a higher salary and want their salaries to be determined based on a percentage of the project price. The company has reviewed their historical records on the number of projects per year and has made the decision to respect the workers demands and notice that the company would maintain a positive financial outlook if they set their break-even target at 4 projects per year. Determine the new salary percentage for the onsite workers on a project price based on the companys average project price and associated costs in Table 2.

d. Based on the new on-site workers cost per project from part , calculate the new number of projects that need to be completed to maintain a profit of $500,000 per year.

e.Due to the change in the on-site workers salaries, what is the effect on contribution margin in relation to the variable cost? Explain the effect of this change on the break-even number in part (a).

f. In Excel, produce a break-even graph for Q-Constructionsand include it here you will also include a copy in the infographic where requested.

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

Unofficial Guide To Medical Research Audit And Teaching

Authors: Ceen-Ming Tang BA BM BCh MRCGP, Colin Fischbacher, Zeshan Qureshi BM BSc MSc MRCPCH FAcadMEd MRCPS

1st Edition

0957149980, 978-0957149984

More Books

Students also viewed these Accounting questions