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 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-Constructions in 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 Use this information above to complete the requested analyses below. Calculate: The break-even number of projects needed by the company. The income made by the company at break-even. Show all working out including the modelling and solution steps. Q-Constructions is 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. 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 company’s average project price and associated costs in Table 2. Based on the new on-site workers’ cost per project from part (c), calculate the new number of projects that need to be completed to maintain a profit of $500,000 per year. 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). Hint! Your discussion should focus on the impact made by the contribution margin. You can show the calculation of the contribution margin to support your discussion, but no other calculations should be used. In Excel, produce a break-even graph for Q-Constructions and include it here – you will also include a copy in the infographic where requested.

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 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-Constructions in 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 Use this information above to complete the requested analyses below. Calculate: The break-even number of projects needed by the company. The income made by the company at break-even. Show all working out including the modelling and solution steps. Q-Constructions is 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. 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 company’s average project price and associated costs in Table 2. Based on the new on-site workers’ cost per project from part (c), calculate the new number of projects that need to be completed to maintain a profit of $500,000 per year. 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). Hint! Your discussion should focus on the impact made by the contribution margin. You can show the calculation of the contribution margin to support your discussion, but no other calculations should be used. In Excel, produce a break-even graph for Q-Constructions and include it here – you will also include a copy in the infographic where requested.

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter10: Short-term Decision Making

Section: Chapter Questions

Problem 4EB: Dimitri Designs has capacity to produce 30,000 desk chairs per year and is currently selling all...

See similar textbooks

Related questions

Concept explainers

Question

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 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-Constructions in 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

Use this information above to complete the requested analyses below.

Calculate:
1. The break-even number of projects needed by the company.
2. The income made by the company at break-even.

Show all working out including the modelling and solution steps.

Q-Constructions is 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.
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 company’s average project price and associated costs in Table 2.

Based on the new on-site workers’ cost per project from part (c), calculate the new number of projects that need to be completed to maintain a profit of $500,000 per year.
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).

Hint! Your discussion should focus on the impact made by the contribution margin. You can show the calculation of the contribution margin to support your discussion, but no other calculations should be used.

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

Expert Solution

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.