Question: This is what i got,but it says im wrong please let me know what i did wrong. Righetti Homes, a custom home builder in Arizona,

This is what i got,but it says im wrong please let me know what i did wrong.

This is what i got,but it says im wrong please let meknow what i did wrong. Righetti Homes, a custom home builder inArizona, is currently offering three models in a newly developed residential neighborhood

Righetti Homes, a custom home builder in Arizona, is currently offering three models in a newly developed residential neighborhood in Scottsdale. The accompanying Specs worksheet includes the information about the three models, including selling prices, material costs, labor costs, buyer incentives (percent of the selling price), and average buyer upgrades (percent of the selling price). Righetti Homes plans to build 50 homes in the neighborhood, and it would like to estimate its total sales and profits in the new residential neighborhood. Click here for the Excel Data File a. Build a spreadsheet model to help Righetti Homes estimate its total sales and profits in the new residential neighborhood. If Righetti b. Based on initial market analysis, Righetti Homes projects that it will build 15 model A homes, 25 model B homes, and 20 model C homes. What are the total sales and profits for Righetti Homes for the neighborhood? \begin{tabular}{|l|r|r|r|} \hline & Model A Model B & Model C \\ \hline Selling Price & 431,300 & 464,400 & 674,800 \\ \hline Material Costs & 120,000 & 150,000 & 200,000 \\ \hline Labor Costs & 150,000 & 200,000 & 330,000 \\ \hline Buyer Incentives (percent of the selling price) & 3% & 5% & 6% \\ \hline Average Buyer Upgrades (percent of the selling pri & 12% & 10% & 8% \\ \hline \end{tabular} Righetti Homes, a custom home builder in Arizona, is currently offering three models in a newly developed residential neighborhood in Scottsdale. The accompanying Specs worksheet includes the information about the three models, including selling prices, material costs, labor costs, buyer incentives (percent of the selling price), and average buyer upgrades (percent of the selling price). Righetti Homes plans to build 50 homes in the neighborhood, and it would like to estimate its total sales and profits in the new residential neighborhood. Click here for the Excel Data File a. Build a spreadsheet model to help Righetti Homes estimate its total sales and profits in the new residential neighborhood. If Righetti b. Based on initial market analysis, Righetti Homes projects that it will build 15 model A homes, 25 model B homes, and 20 model C homes. What are the total sales and profits for Righetti Homes for the neighborhood? \begin{tabular}{|l|r|r|r|} \hline & Model A Model B & Model C \\ \hline Selling Price & 431,300 & 464,400 & 674,800 \\ \hline Material Costs & 120,000 & 150,000 & 200,000 \\ \hline Labor Costs & 150,000 & 200,000 & 330,000 \\ \hline Buyer Incentives (percent of the selling price) & 3% & 5% & 6% \\ \hline Average Buyer Upgrades (percent of the selling pri & 12% & 10% & 8% \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!