MAT 240 Module Three Assignment Joshua Rivera
.docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
240
Subject
Economics
Date
Apr 3, 2024
Type
docx
Pages
5
Uploaded by LieutenantCrowPerson668
Selling Price and Area Analysis for D.M. Pan National Real Estate Company
1
Report: Selling Price and Area Analysis for D.M. Pan National Real Estate Company
Joshua Rivera
Southern New Hampshire University
Selling Price Analysis for D.M. Pan National Real Estate Company
2
Introduction
Hired as a junior analyst by D.M. Pan Real Estate Company, I’ve been tasked with preparing a report that
examines the relationship between the selling price of properties and their size in square feet. For this examination, I’ve selected a random sample of 30 from the East North Central region to conduct a complete initial analysis report to provide to the team. Representative Data Sample
East North Central
Square Feet
Listing Price
1,693 278,700 1,307 163,000 2,081 218,300 1,986 256,700 1,688 207,500 1,493 225,300 1,789 226,200 2,033 226,400 1,201 139,200 1,463 154,300 1,230 201,000 1,783 197,600 1,294 181,400 1,666 184,900 2,014 243,200 1,157 174,500 2,081 324,400 1,692 236,700 1,752 240,500 1,853 265,700 1,978 270,600 1,494 192,400 1,777 222,500 1,651 221,600 1,441 203,800 1,550 227,600 1,416 160,800
Selling Price Analysis for D.M. Pan National Real Estate Company
3
3,581 461,400 1,676 225,900 1,434 187,900
Square Feet
Listing Price
mean
median
standard deviation
mean
median
standard deviation
1,708 1,682 443.8321159
224,000 222,050 60186.06208
Data Analysis
The regional sample created shows only 3% of the national market. Comparing the regional sample with the national sample, the trend is very similar. In both samples, the larger the square feet, the higher the price of the home. In contrast, the 3% of the regional sample does not accurately represent the overall mean of square feet and home prices. The national average homes are approximately $100,000 higher than the regional sample; and the square feet is 400 greater than the ladder. To get a random regional sample, I randomized all 100 of the East North Central region homes using excel macros then selected the first 30 samples to chart. To get a truly random sample for the East North Central region, I would have used all 100 samples to better represent the national population, increasing it from 3% to 10%. Scatterplot
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
[The following information applies to the questions displayed below.]
Pete’s Tennis Shop has the following transactions related to its top-selling Wilson tennis racket for the month of August. Pete’s Tennis Shop uses a periodic inventory system.
Date Transactions Units Unit Cost Total Cost August 1 Beginning inventory 8 $ 160 $ 1,280 August 4 Sale ($225 each) 5 August 11 Purchase 10 150 1,500 August 13 Sale ($240 each) 8 August 20 Purchase 10 140 1,400 August 26 Sale ($250 each) 11 August 29 Purchase 11 130 1,430 $ 5,610 For the specific identification method, the August 4 sale consists of rackets from beginning inventory, the August 13 sale consists of rackets from the August 11 purchase, and the August 26 sale consists of one racket from beginning inventory and 10 rackets from the August 20 purchase.
3. Using LIFO, calculate ending inventory and cost of goods sold at August 31.
arrow_forward
Complete the inventory table by calculating the total cost of purchases, the goods available for sale, the cost of the goods available for sale, and the
ending inventory.
Date of purchase
Beginning inventory
Units
Cost per
purchased unit
41
$830
Total cost
Retail price Total retail
per unit
value
$975
arrow_forward
Tamarisk, Inc. reported net sales $880.000: cost of goods sold $572.000: operating expenses $231.000: and net income $74,800.
Calculate the profit margin and gross profit rate. (Round answers to 1 decimal place, eg. 10.2%)
Profit margin
Gross profit rate
arrow_forward
Question 13
You have an assignment to appraise a dairy heifer feedlot and discovered one recent sale that is
highly comparable to your subject property. The unit of comparison for these types of facilities has
consistently been based on the total linear feet (LF) of feeding space available. The property is 50
acres and sold for $1,400,000 and contained sixteen pens that each included 120 linear feet of
feeding space and measured 120' by 200.
Based on this information, what is the sales price per unit of comparison identified by the market?
arrow_forward
Davis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. The following data were collected from last year’s operations (revenues and costs in thousands of dollars).
Store Revenues Costs
101 $4,120 $4,244
102 2,247 2,934
103 5,768 5,211
104 4,022 4,048
105 2,944 3,736
106 4,063 3,389
107 6,914 5,059
108 1,809 2,474
109 5,516 4,768
110…
arrow_forward
1)Use the following information to answer the question(s) below.
Rearden Metals is considering opening a strip mining operation to provide some of the raw materials needed in producing Rearden metal. The initial purchase of the land and the associated costs of opening up mining operations will cost $100 million today. The mine is expected to generate $16 million worth of ore per year for the next 12 years. At the end of the 12th year Rearden will need to spend $20 million to restore the land to its original pristine nature appearance.The payback period for Rearden's mining operation is closest to:
2) Which of the following statements is false/true? If you believe that it is incorrect explain with its reasons.
A-Future dividend payments and stock prices are not known with certainty; rather these values are based on the investor’s expectations at the time the stock is purchased.
T/F……………………………………………………………………………………………………………………………………………………………………………
B-The capital gain…
arrow_forward
If the company does not change its current supply chain, what will its distributioncosts be for the following quarter?
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
Based on the following data for Al-Aqsa Company: (5 Marks)
- Price = $10
- Average total cost = $6
- number of units produced = 1000 unit
Calculate
Profit per unit
Total profit
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
Q24
arrow_forward
The government of the Republic of Zambia plans to implement an irrigation project to increase maize production in your district. Answer the following questions.
List the possible secondary costs of the project [5 marks]
arrow_forward
Q1:
Interglobal Paper Company has asked for your help in comparing its present computer systems with a new
one. Its board of directors would like to see implemented. Proposed system and present system costs are as
follows:
Item
Year 1
Equipment Lease
Salaries
Overhead
Development
Year 2
Equipment Lease
Salaries
Overhead
Development
Year 3
Equipment Lease
Salaries
Overhead
Development
Year 4
Equipment Lease
Salaries
Overhead
Development
Proposed System Costs
20,000
30,000
4,000
30,000
20,000
33,000
4,400
12,000
20,000
36,000
4,900
10000
20,000
39,000
5,500
8,000
a. Graph the costs and show the break-even point.
b. Explain your recommendation.
Present System Costs
11,500
50,000
3,000
8,000
10,500
55,000
3,300
10,000
10,500
60,000
3,600
16,000
10,500
66,000
4,000
12,000
arrow_forward
what is the terminology for this definition below:
Year serving as point of comparison for other years
arrow_forward
Please give me correct answer with full explanation and calculation
Note:-
Please avoid using ChatGPT and refrain from providing handwritten solutions; otherwise, I will definitely give a downvote. Also, be mindful of plagiarism.
Answer completely and accurate answer.
Rest assured, you will receive an upvote if the answer is accurate.
arrow_forward
Inventory Costing Methods—Periodic MethodThe Luann Company uses the periodic inventory system. The following July data are for an item in Luann's inventory:
July
1
Beginning inventory
30
units @
$9
per unit
10
Purchased
50
units @
$11
per unit
15
Sold
60
units
26
Purchased
25
units @
$13
per unit
Calculate the cost of goods sold for July and ending inventory at July 31 using (a) first-in, first-out, (b) last-in, first-out, and (c) the weighted-average cost methods.
Note: Round your cost per unit to three decimal places, if needed. Then round your final answers to the nearest dollar.
A.
First-in, First-out:
Ending Inventory
Answer
Cost of Goods Sold:
Answer
B.
Last-in, first-out:
Ending Inventory
Answer
Cost of Goods Sold:
Answer
C.
Weighted-average cost:
Ending Inventory
Answer
Cost of Goods Sold
Answer
arrow_forward
Case Study
Alison Mitchell joined The Look three months ago. The Look is a high street clothes retailer that is
mainly based in the UK, but has some stores in continental Europe. Alison is a management trainee
who recently finished her history degree at university. She has just come back from a management
presentation in which the annual results of the company were announced. She left feeling slightly
worried and a little confused.
I know the economy has been doing badly and this has hit customer spending. Customers are
worried about their jobs, which is not surprising given the high unemployment figures, and many
of them have had their wealth hit hard by falling house prices. The economic climate is making
everyone a little more cautious. This year's profits for the company were nearly £6 million, which
is higher than our competitors. But the board of directors is apparently unhappy with this return,
given the investment that has been made into the business. It wants a significant…
arrow_forward
#15
Expenses for a Pizza restaurant include raw material for pizza at $4.00 per slice, $119.00 as monthly rental and $41.00
monthly as insurance. Lost sale expense is considered to be $5.00 per unhappy customer. Leftover Pizza can be sold for
$3. The restaurant is open 25 days in a month.
Today the restaurant prepared 200.00 pizza slices and sells them for $11.00/slice. There was a party at a nearby office
so the demand for pizza went up to 223.00 slices. How much profit did the restaurant earn today?
Submit
Answer format: Currency: Round to: 0 decimal places.
arrow_forward
FOREIGN OBJECTS — AND INSECTS
During 2017 inspections of the Mars Inc. canning facility in Columbus, Ohio, where Pedigree, Iams and Cesar pet foods are manufactured, along with other brands, Mars told inspectors it was hearing consumer complaints about foreign objects — including insects — in the pet food.But the company insisted it was working to fully implement corrective actions.Pest control records at the facility noted damaged cans covered in flies, and dozens of employees had complained about cockroaches in the area, especially at night. Different employees described seeing “multiple roaches,” an “invasion of roaches,” “roaches everywhere” and even “millions of roaches” — which we hope was an exaggeration.Inspectors from the U.S. Food and Drug Administration (FDA) themselves observed 2 live roaches. The FDA stressed the seriousness of the pest problem, and the company “promised correction.”
Around 2015, we started hearing reports of so-called “wires” or plastic…
arrow_forward
40
arrow_forward
16. The following figures relate to one year work in a manufacturing business :
Fixed overheads
Variable overheads
Direct wages
Direct materials
Sales
12,000
20,000
15,000
41,000
1,00,000
Represent each of the above figures on a break-even-chart, and determine from the chart
the break-even point.
[Ans. 50,000]
arrow_forward
RMC, Inc., is a small firm that produces a variety of chemical products. In a particular
production process, three raw materials are blended to produce two products: a fuel additive and
a solvent base. Each ton of fuel additive is a mixture of 2/5 ton of material 1 and 3/5 ton of
material 3. A ton of solvent base is a mixture of ½ ton of material 1, 1/5 ton of material 2, and
3/10 ton of, material 3. After deducting relevant costs, the profit contribution is $40 for every
ton of fuel additive produced and $30 for every ton of solvent base produced. RMC’s production
is constrained by a limited availability of the three raw materials. For the current production
period, RMC has 20 tons of material 1, 5 tons of material 2, and 21 tons of material 3 that are
available for production. Assuming that RMC is interested in maximizing the total profit
contribution, answer the following:
a. Find the optimal solution. How many tons of each product should be produced, and
what…
arrow_forward
There has been a small increase in the price per pound for the prosciutto, and Mister Dee is concerned that the current menu selling price of $20 for the Pizza Arrabbiata may have to be increased. Therefore, he wants you to update the Recipe Cost Card for Pizza Arrabiata and complete a Plate Cost Card and give him your recommendation for the updated.
Menu Item: Pizza Arrabbiata Quantity Sold: 142 Sales Total: 3,500.50
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Economics (12th Edition)
Economics
ISBN:9780134078779
Author:Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:9780134870069
Author:William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:PEARSON
Principles of Economics (MindTap Course List)
Economics
ISBN:9781305585126
Author:N. Gregory Mankiw
Publisher:Cengage Learning
Managerial Economics: A Problem Solving Approach
Economics
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-...
Economics
ISBN:9781259290619
Author:Michael Baye, Jeff Prince
Publisher:McGraw-Hill Education
Related Questions
- [The following information applies to the questions displayed below.] Pete’s Tennis Shop has the following transactions related to its top-selling Wilson tennis racket for the month of August. Pete’s Tennis Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost August 1 Beginning inventory 8 $ 160 $ 1,280 August 4 Sale ($225 each) 5 August 11 Purchase 10 150 1,500 August 13 Sale ($240 each) 8 August 20 Purchase 10 140 1,400 August 26 Sale ($250 each) 11 August 29 Purchase 11 130 1,430 $ 5,610 For the specific identification method, the August 4 sale consists of rackets from beginning inventory, the August 13 sale consists of rackets from the August 11 purchase, and the August 26 sale consists of one racket from beginning inventory and 10 rackets from the August 20 purchase. 3. Using LIFO, calculate ending inventory and cost of goods sold at August 31.arrow_forwardComplete the inventory table by calculating the total cost of purchases, the goods available for sale, the cost of the goods available for sale, and the ending inventory. Date of purchase Beginning inventory Units Cost per purchased unit 41 $830 Total cost Retail price Total retail per unit value $975arrow_forwardTamarisk, Inc. reported net sales $880.000: cost of goods sold $572.000: operating expenses $231.000: and net income $74,800. Calculate the profit margin and gross profit rate. (Round answers to 1 decimal place, eg. 10.2%) Profit margin Gross profit ratearrow_forward
- Question 13 You have an assignment to appraise a dairy heifer feedlot and discovered one recent sale that is highly comparable to your subject property. The unit of comparison for these types of facilities has consistently been based on the total linear feet (LF) of feeding space available. The property is 50 acres and sold for $1,400,000 and contained sixteen pens that each included 120 linear feet of feeding space and measured 120' by 200. Based on this information, what is the sales price per unit of comparison identified by the market?arrow_forwardDavis Stores sells clothing in 15 stores located around the southwestern United States. The managers at Davis are considering expanding by opening new stores and are interested in estimating costs in potential new locations. They believe that costs are driven in large part by store volume measured by revenue. The following data were collected from last year’s operations (revenues and costs in thousands of dollars). Store Revenues Costs 101 $4,120 $4,244 102 2,247 2,934 103 5,768 5,211 104 4,022 4,048 105 2,944 3,736 106 4,063 3,389 107 6,914 5,059 108 1,809 2,474 109 5,516 4,768 110…arrow_forward1)Use the following information to answer the question(s) below. Rearden Metals is considering opening a strip mining operation to provide some of the raw materials needed in producing Rearden metal. The initial purchase of the land and the associated costs of opening up mining operations will cost $100 million today. The mine is expected to generate $16 million worth of ore per year for the next 12 years. At the end of the 12th year Rearden will need to spend $20 million to restore the land to its original pristine nature appearance.The payback period for Rearden's mining operation is closest to: 2) Which of the following statements is false/true? If you believe that it is incorrect explain with its reasons. A-Future dividend payments and stock prices are not known with certainty; rather these values are based on the investor’s expectations at the time the stock is purchased. T/F…………………………………………………………………………………………………………………………………………………………………………… B-The capital gain…arrow_forward
- If the company does not change its current supply chain, what will its distributioncosts be for the following quarter?arrow_forwardhelp please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all workingarrow_forwardBased on the following data for Al-Aqsa Company: (5 Marks) - Price = $10 - Average total cost = $6 - number of units produced = 1000 unit Calculate Profit per unit Total profitarrow_forward
- help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all workingarrow_forwardQ24arrow_forwardThe government of the Republic of Zambia plans to implement an irrigation project to increase maize production in your district. Answer the following questions. List the possible secondary costs of the project [5 marks]arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Economics (12th Edition)EconomicsISBN:9780134078779Author:Karl E. Case, Ray C. Fair, Sharon E. OsterPublisher:PEARSONEngineering Economy (17th Edition)EconomicsISBN:9780134870069Author:William G. Sullivan, Elin M. Wicks, C. Patrick KoellingPublisher:PEARSON
- Principles of Economics (MindTap Course List)EconomicsISBN:9781305585126Author:N. Gregory MankiwPublisher:Cengage LearningManagerial Economics: A Problem Solving ApproachEconomicsISBN:9781337106665Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike ShorPublisher:Cengage LearningManagerial Economics & Business Strategy (Mcgraw-...EconomicsISBN:9781259290619Author:Michael Baye, Jeff PrincePublisher:McGraw-Hill Education
Principles of Economics (12th Edition)
Economics
ISBN:9780134078779
Author:Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:9780134870069
Author:William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:PEARSON
Principles of Economics (MindTap Course List)
Economics
ISBN:9781305585126
Author:N. Gregory Mankiw
Publisher:Cengage Learning
Managerial Economics: A Problem Solving Approach
Economics
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-...
Economics
ISBN:9781259290619
Author:Michael Baye, Jeff Prince
Publisher:McGraw-Hill Education