Assignment
Question 1
A local government board hired you to recommend which of the two possible sites should be chosen for a new recycling facility. Location A is much closer to the city center, and thus the average hauling distance would only be 2 miles, while Location B being outside of the city would result in an average hauling distance of 5 miles. Public funds will have to be used to pay for the leasing cost of the site, which would be $50,000 a year for Location A and $10,000 a year for Location B, as well as for the hauling cost which is $200 per mile for each trip. Assuming 3,000 trips will be made per year, which location should be chosen based on the overall cost?
Question 2
Metal ABC produces sheets of metal. Its fixed cost in year 2019 is $1,000,000. The variable cost is $400 per sheet.
a. Find the break-even quantity assuming the selling price is $500 per sheet.
b. Find the price and quantity that will result in maximum profit, assuming the demand function is P = $10,000 - 6Q. How much profit will be made using the profit-maximizing price and quantity values?
Question 3
A package delivery company is contemplating building a new shipping center. The most recent shipping center, 10,000 square feet large, was built in 2005, at a cost of $500,000. The new shipping center will be 15,000 square feet large. Using the power-sizing cost-estimating model, estimate the cost of building a new shipping center now, using the assumptions below to construct a weighted cost index value for 2005 and for today. Use 0.90 for the cost-capacity factor.
The dollar cost of building a shipping center can be broken down into the cost of labor (20%), materials (35%), and equipment (45%). The cost index for labor is 120 in 2005, and 150 today. The cost index for materials is 180 in 2005 and 170 today. The cost index for equipment is 140 in 2005 and 200 today.
Question 4
Milana just deposited $10,000 in her account. Assuming the annual interest rate is 8%, how many years will it take before her account balance reaches $23,000? (Make sure you use the time value of money Excel functions)
Question 5
Ali wants to retire in 15 years. Earlier today, he opened an account and deposited $25,000. In addition, he will deposit $5,000 at the end of each year until he is ready to retire. Once he retires, he wants to be able to withdraw the same amount at the end of each year, for 25 years. Assuming a 7% annual interest rate in his account, what is the maximum amount he will be able to withdraw each year after he retires?
(Hint: this problem needs to be done in 2 steps, using the time value of money Excel functions.)
Question 6
Chandra is considering borrowing $150,000 to buy a house, using a 15-year fixed-rate mortgage. Assuming quoted annual interest rate (APR) of 3.9%, put together an amortization table showing all of the monthly payments broken down into the amount going toward paying interest and the amount going toward paying down the mortgage loan balance. You should also have the beginning and ending balance for each month in your table. Make sure you use cell references and copying and pasting to fill in the rest of the table once you enter the necessary formulas for the first and the beginning of the second month.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.