PRACTICAL MGT. SCIENCE (LL)-W/MINDTAP
6th Edition
ISBN: 9781337610278
Author: WINSTON
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 4, Problem 81P
You want to take out a $450,000 loan on a 20-year mortgage with end-of-month payments. The annual rate of interest is 3%. Twenty years from now, you will need to make a $50,000 ending balloon payment. Because you expect your income to increase, you want to structure the loan so at the beginning of each year, your monthly payments increase by 2%.
- a. Determine the amount of each year’s monthly payment. You should use a lookup table to look up each year’s monthly payment and to look up the year based on the month (e.g., month 13 is year 2, etc.).
- b. Suppose payment each month is to be the same, and there is no balloon payment. Show that the monthly payment you can calculate from your spreadsheet matches the value given by the Excel PMT function PMT(0.03/12,240, −450000,0,0).
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The Clothing Shack is an online retailer of men's, women's, and children's clothing. The company has
been in business for four years and makes a modest profit from its online sales. However, in an effort
to compete successfully against online retailing heavyweights, the Clothing Shack's marketing
director, Makaya O'Neil, has determined that the Clothing Shack's marketing information systems
need improvement.
Ms. O'Neil feels that the Clothing Shack should begin sending out catalogs to its customers, keep
better track of its customer's buying habits, perform target marketing, and provide a more
personalized shopping experience for its customers. Several months ago, Ms. O'Neil submitted a
systems service request (SSR) to the Clothing Shack's steering committee. The committee
unanimously approved this project. You were assigned to the project at that time and have since
helped your project team successfully complete the project initiation and planning phase. Your team
is now ready to move…
b-1.
Activity
ES
EF
LS
LF
Slack
1
2
3
4
5
6
7
8
9
b-2. Identify the critical activities, and determine the duration of the project.
The critical activities are .
The forecast for each week of a four-week schedule is 50 units. The MPS rule is to schedule production if the projected on-hand
Inventory would be negative without it. Customer orders (committed) are follows:
Week
Customer Order
1
52
35
20
12
Use a production lot size of 75 units and no beginning Inventory. Determine the available-to-promise (ATP) quantities for each period.
Note: Leave no cells blank - be certain to enter "0" wherever required.
Period
ATP
1
2
3
Chapter 4 Solutions
PRACTICAL MGT. SCIENCE (LL)-W/MINDTAP
Ch. 4.2 - Prob. 1PCh. 4.2 - Prob. 2PCh. 4.2 - Prob. 3PCh. 4.2 - Prob. 4PCh. 4.2 - Prob. 5PCh. 4.2 - Prob. 6PCh. 4.3 - Prob. 7PCh. 4.3 - Prob. 8PCh. 4.3 - Prob. 9PCh. 4.3 - Prob. 10P
Ch. 4.3 - Prob. 11PCh. 4.3 - Prob. 12PCh. 4.4 - Prob. 13PCh. 4.4 - Prob. 14PCh. 4.4 - Prob. 15PCh. 4.4 - Prob. 16PCh. 4.4 - Prob. 17PCh. 4.4 - Prob. 18PCh. 4.4 - Prob. 19PCh. 4.5 - Prob. 20PCh. 4.5 - Prob. 21PCh. 4.5 - Prob. 22PCh. 4.5 - Prob. 23PCh. 4.5 - Prob. 24PCh. 4.5 - Prob. 25PCh. 4.6 - Prob. 26PCh. 4.6 - Prob. 27PCh. 4.6 - Prob. 28PCh. 4.6 - Prob. 29PCh. 4.7 - Prob. 30PCh. 4.7 - Prob. 31PCh. 4.7 - Prob. 32PCh. 4.7 - Prob. 33PCh. 4.7 - Prob. 34PCh. 4.7 - Prob. 35PCh. 4.7 - Prob. 36PCh. 4.7 - Prob. 37PCh. 4.7 - Prob. 38PCh. 4.7 - Prob. 39PCh. 4.7 - Prob. 40PCh. 4.8 - Prob. 41PCh. 4.8 - Prob. 42PCh. 4.8 - Prob. 43PCh. 4.8 - Prob. 44PCh. 4 - Prob. 45PCh. 4 - Prob. 46PCh. 4 - Prob. 47PCh. 4 - Prob. 48PCh. 4 - Prob. 49PCh. 4 - Prob. 50PCh. 4 - Prob. 51PCh. 4 - Prob. 52PCh. 4 - Prob. 53PCh. 4 - Prob. 54PCh. 4 - Prob. 55PCh. 4 - Prob. 56PCh. 4 - Prob. 57PCh. 4 - Prob. 58PCh. 4 - Prob. 59PCh. 4 - Prob. 60PCh. 4 - Prob. 61PCh. 4 - Prob. 62PCh. 4 - Prob. 63PCh. 4 - Prob. 64PCh. 4 - Prob. 65PCh. 4 - Prob. 66PCh. 4 - Prob. 67PCh. 4 - Prob. 68PCh. 4 - Prob. 69PCh. 4 - Prob. 70PCh. 4 - Prob. 71PCh. 4 - Prob. 72PCh. 4 - Prob. 73PCh. 4 - Prob. 74PCh. 4 - Prob. 75PCh. 4 - Prob. 76PCh. 4 - Prob. 77PCh. 4 - Prob. 78PCh. 4 - Prob. 79PCh. 4 - Prob. 80PCh. 4 - You want to take out a 450,000 loan on a 20-year...Ch. 4 - Prob. 82PCh. 4 - Prob. 83PCh. 4 - Prob. 84PCh. 4 - Prob. 85PCh. 4 - Prob. 86PCh. 4 - Prob. 87PCh. 4 - Prob. 88PCh. 4 - Prob. 89PCh. 4 - Prob. 90PCh. 4 - Prob. 91PCh. 4 - Prob. 92PCh. 4 - Prob. 93PCh. 4 - Prob. 94PCh. 4 - Prob. 95PCh. 4 - Prob. 96PCh. 4 - Prob. 97PCh. 4 - Prob. 98PCh. 4 - Prob. 99PCh. 4 - Prob. 100PCh. 4 - Prob. 101PCh. 4 - Prob. 102PCh. 4 - Prob. 103PCh. 4 - Prob. 104PCh. 4 - Prob. 105PCh. 4 - Prob. 106PCh. 4 - Prob. 107PCh. 4 - Prob. 108PCh. 4 - Prob. 109PCh. 4 - Prob. 110PCh. 4 - Prob. 111PCh. 4 - Prob. 112PCh. 4 - Prob. 113PCh. 4 - Prob. 114PCh. 4 - Prob. 115PCh. 4 - Prob. 116PCh. 4 - Prob. 117PCh. 4 - Prob. 118PCh. 4 - Prob. 119PCh. 4 - Prob. 120PCh. 4 - Prob. 121PCh. 4 - Prob. 122PCh. 4 - Prob. 123PCh. 4 - Prob. 124PCh. 4 - Prob. 125PCh. 4 - Prob. 126PCh. 4 - Prob. 127PCh. 4 - Prob. 128PCh. 4 - Prob. 129PCh. 4 - Prob. 130PCh. 4 - Prob. 131PCh. 4 - Prob. 132PCh. 4 - Prob. 133PCh. 4 - Prob. 134PCh. 4 - Prob. 135P
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 60 units. The MPS rule is to schedule production if the projected on-hand Inventory would be negative without it. Customer orders (committed) are as follows: Week Customer Orders 1 2 36 28 4 1 Use a production lot size of 85 units and no beginning inventory. Note: In the ATP row, enter a value of 0 (zero) in any periods where ATP should not be calculated. Leave no cells blank - be certain to enter "0" wherever required. June July 1 2 3 4 5 8 7 8 Forecast 60 60 60 60 60 60 60 60 Customer Orders 38 28 4 1 0 0 0 0 Projected On-Hand Inventory MPS ATParrow_forwardSales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week 1 2 3 4 5 6 7 8 9 10 Demand 21 21 27 38 25 30 35 24 25 30 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.50 and a week 1 initial forecast of 21.0 are (round your responses to two decimal places): Week 1 2 3 4 5 6 7 8 9 10 Demand 21 21 27 38 25 30 35 24 25 30 Forecast 21.0 21 21 24 31 28 29 32 28 26.50 b) For the forecast developed using exponential smoothing (a = 0.50 and initial forecast 21.0), the MAD = |||||sales (round your response to two decimal places).arrow_forwardSales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week Demand 1 2 3 4 5 6 7 8 9 10 21 21 27 38 25 30 35 24 25 30 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.50 and a week 1 initial forecast of 21.0 are (round your responses to two decimal places): Week 1 2 3 4 5 Demand 21 21 27 38 Forecast 21.0 ☐ G ☐ ☐ 6 7 25 30 35 ∞ ☐ 8 9 10 24 25 30arrow_forward
- Each machine costs $3 Million. Building the room with all its attendant safety protection and other ancillary costs increases the spending by an additional $2.0 million dollars per MRI suite. Each machine can perform 2000 scans per year. Each reading of an MRI scan by a radiologist, along with other per-scan-related costs, is $500 per scan. The machine will last five years. Don’t worry about discount rates for this problem Graph the total costs over 5 years as a function of sales for 0-3000 patients annually. Hint: you may need to add a second MRI at some point. Suppose that you want to make a profit of $500 per scan at a target volume of 1000 patients per year, and you purchase only one machine. Superimpose the total revenue curve on top of the total cost curve in (1).arrow_forwardI need the answer to requirement C.arrow_forwardImagine you are Susan Kim and are faced with a difficult choice to either follow the orders she was given, or refusing to do so. Using each lens determine what the ethical response would be. Suppot your answer with materials from readings and lectures. For example, using Universalism what would the ethical response be? Do the same for all four lenses.arrow_forward
- Answer all these questions, selecting any company of your choice. Choose a specific type of food company. Select a specific product. Develop all the inputs that are part of the process. Develop the transformation process in a graphic (diagram, etc.). Develop all the outputs or finished products that are part of the process. Describe all the processes involved in one line of production in any manufacturing facility. Also describing how good management is the center of any part of a production company.arrow_forwardUsing exponential smoothing with α =0.2, forecast the demand for The initial forecast for January is 2000 tons. Calculate the capacity utilization for June, July and Discuss the implications of underutilized or over utilized capacity for Green Harvestarrow_forwardIn organizational development when results are improving but relationships are declining, what leadership style is appropriate? directing delegating supporting coachingarrow_forward
- What is the first thing a leader should do when moving through a cultural change? conduct an assessment comparing the practices to other high-performing organizations learn about the current organizational culture continue to monitor key metrics define expectationsarrow_forwardThe third change leadership strategy, Collaborate on Implementation, is designed to address what type of concerns? impact concerns personal concerns refinement concerns collaboration concernsarrow_forwardIf team members are concerned with specifics such as their tasks, contingency plans, resources, and timeline, what concerns do they have? implementation concerns impact concerns refinement concerns personal concernsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License