Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE USE EXCEL TO SOLVE. I NEED SOLUTION IN EXCEL WITH FORMULAS. THANKS!! Ponderosa Development Corporation (PDC) is a small real estate developer that builds

PLEASE USE EXCEL TO SOLVE. I NEED SOLUTION IN EXCEL WITH FORMULAS. THANKS!!

image text in transcribed

Ponderosa Development Corporation (PDC) is a small real estate developer that builds only one style cottage. The selling price of the cottage is $115,000. The cost per cottage includes land for $55,000 and lumber, supplies, and other materials run another for $28,000. Total labor costs are approximately $20,000 per cottage. The one salesperson of PDC is paid a commission of $2,000 on the sale of each cottage. Ponderosa leases office space for $2,000 per month. The cost of supplies, utilities, and leased equipment runs another $3,000 per month. PDC has seven permanent office employees whose monthly salaries are $35,000. a- Calculate the breakeven quantity for the company b- Develop a one-way data table to examine the effect of the change in the land price from 50000 to 60000 with increments of 1000 on the breakeven point c- Develop a two-way table to examine the change in the monthly salaries and selling price on the breakeven quantity. Use values from 100,000 to 120,000 with increments of 2,000 for the selling price and values from 30,000 to 40,000 with increments of 2000 for the monthly salaries

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

The Credit Risk Of Complex Derivatives

Authors: Erik Banks

3rd Edition

1403916691, 9781403916693

More Books

Students also viewed these Accounting questions

Question

How does the concept of hegemony relate to culture?

Answered: 1 week ago