Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 12, Problem 3P
Spencer Enterprises is attempting to choose among a series of new investment alternatives. The potential investment alternatives, the net present value of the future stream of returns, the capital requirements, and the available capital funds over the next three years are summarized as follows:
- a. Develop and solve an integer programming model for maximizing the net present value.
- b. Assume that only one of the warehouse expansion projects can be implemented. Modify your model from part (a).
- c. Suppose that if test marketing of the new product is carried out, the advertising campaign also must be conducted. Modify your formulation from part (b) to reflect this new situation.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
If a company has excess capacity, it is contemplating whether a special order should be accepted.
The order will not impact regular sales. If the company accepts the special order, what will occur?
O Both fixed and variable costs will increase.
Net income will increase if the special sales price per unit exceeds the unit variable costs.
There are no incremental revenues.
Incremental costs will not be affected.
First Securities, Inc., an investment firm, has $380,000 on account. The chief investment officer would like to reinvest the $380,000 in a portfolio that would maximize return on investment while at the same time maintaining a relatively conservative mix of stocks and bonds. The following table shows the investment opportunities and rates of return.
Investment Opportunity
Rate of Return
Municipal Bonds (X1)
0.095
High Tech Stock (X2)
0.146
Blue Chip Stock (X3)
0.075
Federal Bonds (X4)
0.070
a) The Board of Directors has mandated that at least 60 percent of the investment consist of a combination of municipal and federal bonds, at least 25 percent Blue Chip Stock, no more than 30 percent High Tech and Blue Chip Stock, and no more than 15 percent High Tech Stock.
Based on above problem, how many constraints are in this problem?
A) 3
B) 4
C) 5
D) 2
b) Based on part a, which of the…
A retired couple wishes to invest $750,000, diversifying the investment in three areas: a high-risk stock that has an expected annual rate of return (or interest) of 12%, a low-risk stock that has an expected annual return of 8%, and government-issued bonds that pay annual interest of 4% and involve no risk. To protect the value of the investment, the couple wishes to place at least twice as much in the low-risk stock as in the high-risk stock and use the remainder to buy bonds. How should the money be invested to maximize the expected annual return?
Chapter 12 Solutions
Essentials of Business Analytics (MindTap Course List)
Ch. 12 - STAR Co. provides paper to smaller companies with...Ch. 12 - The following questions refer to a capital...Ch. 12 - Spencer Enterprises is attempting to choose among...Ch. 12 - Hawkins Manufacturing Company produces connecting...Ch. 12 - Grave City is considering the relocation of...Ch. 12 - Hart Manufacturing makes three products. Each...Ch. 12 - Galaxy Cloud Services operates several data...Ch. 12 - East Coast Trucking provides service from Boston...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- If during the following year it is predicted that each comedy skit will generate 30 thousand and each musical number 20 thousand, find the maximum income for the year. A television program director must schedule comedy skits and musical numbers for prime-time variety shows. Each comedy skit requires 2 hours of rehearsal time, costs 3000, and brings in 20,000 from the shows sponsors. Each musical number requires 1 hour of rehearsal time, costs 6000, and generates 12,000. If 250 hours are available for rehearsal and 600,000 is budgeted for comedy and music, how many segments of each type should be produced to maximize income? Find the maximum income.arrow_forwardFederated Electronics, Ltd., manufactures display screensand monitors for computers and televisions, which it sellsto companies around the world. It wants to construct a new warehouse and distribution center in Asia to serve emerg-ing markets there. It has identified potential sites in the port cities of Shanghai, Singapore, Pusan, Kaohsiung, and HongKong and has estimated the possible revenues for each(minus construction costs which are higher in some citieslike Hong Kong). At each site the projected revenues are primarily based on these factors, (1) the economic condi-tions at the port including the projected traffic, infrastruc-ture, labor rates and availability; and expansion and modernization; and (2) the future government situationwhich includes the political stability, fees, tariffs, duties,and trade regulations. Following is a payoff table thatshows the projected revenues (in $ billions) for six years given the four possible combinations for positive and nega-tive port and…arrow_forwardSouthland Corporation's decision to produce a new line of recreational products has resulted in the need to choose one of two automated manufacturing systems based on proposals from two vendors, A and B. The economics of this decision depends on the market reaction to the new product line. The possible long-run demand has been defined as low, medium, or high. Based on detailed financial analyses of system costs as a function of volume and sales under each demand scenario, the following payoff table gives the projected profits in millions of dollars. million. Decision Vendor A Vendor B million. Low $70 $160 Long-Run Demand Medium $150 $150 a. Determine the best decisions using the maximax, maximin, and opportunity loss decision criteria. Using the maximax criterion, choose -Select- Using the maximin criterion, choose -Select- To minimize the maximum opportunity loss, choose -Select- b. Assume that the best estimate of the probability of low long-run demand is 0.15, of medium long-run…arrow_forward
- An investment broker is instructed by her client to invest $20,000 in two funds based on their average annual returns for 5 years ending December 31, 2009: a Global Bond fund yielding 9% and the Yachtman fund yielding 7%. The client wants to invest at least $8000 in the Yachtman fund and no more than $12,000 in the Global Bond fund. (a) How much should the broker recommend that the client place in each investment to maximize income if the client insists that the amount invested in the Yachtman fund must equal or exceed the amount placed in the Global Bond fund? (b) How much should the broker recommend that the client place in each investment to maximize income if the client insists that the amount invested in the Yachtman fund must not exceed the amount placed in the Global Bond fund?arrow_forwardHoosier Power needs to determine a capacity expansion plan to meet Bloomington’s power needs for thenext 20 years. The current capacity is 5000 kwh. The demand for the current year is 4000 kwh, and demand is expected to increase by 1000 kwh in each succeeding year. At the beginning of each year, Hoosier Power must determine the amount of capacity to add, given the following inputs: ■ Any year in which capacity is added, a fixed cost of $120,000 is incurred plus a cost of $120 per kwh of capacity. ■ At most 10,000 kwh of capacity can be added in a single year. ■ It costs $25 per year to maintain a unit of capacity. ■ It costs $12 per year to produce a kwh. ■ If production does not meet demand, a shortage cost of $80 per kwh short is incurred. Develop a linear integer model to help Hoosier Power minimize its costs for the next 20 years.arrow_forwardThe Arctic Air Company produces residential air conditioners. The manufacturing manager wants to develop a sales and operations plan for the next year based on the following demand and capacity data (in hundreds of product units): Undertime is unpaid, and no cost is associated with unused overtime or subcontractor capacity. Producing one air conditioning unit on regular time costs $1,000, including $300 for labor. Producing a unit on overtime costs $1,150. A subcontractor can produce a unit to Arctic Air specifications for $1,250. Holding an air conditioner in stock costs $60 for each 2-month period, and 200 air conditioners are currently in stock. The plan calls for 400 units to be in stock at the end of period 6. No backorders are allowed. Use the transportation method to develop a plan that minimizes costs.arrow_forward
- Oerstman, Inc., uses a standard costing system and develops its overhead rates from the current annual budget. The budget is based on an expected annual output of 121,000 units requiring 484,000 direct labor hours. (Practical capacity is 504,000 hours.) Annual budgeted overhead costs total $788,920, of which $571,120 is fixed overhead. A total of 119,200 units using 482,000 direct labor hours were produced during the year. Actual variable overhead costs for the year were $262,000, and actual fixed overhead costs were $555,250. Required: 1. Compute the fixed overhead spending and volume variances. X Fixed Overhead Spending Variance Favorable Fixed Overhead Volume Variance Unfavorable 2. Compute the variable overhead spending and efficiency variances. Do not round intermediate calculations Variable Overhead Spending Variance Unfavorable Variable Overhead Efficiency Variance Unfavorable X x ✓arrow_forwardFrijo-Lane Food Products own farms in the Southwest and Midwest, where it grows and harvest potatoes. It then ships these potatoes to three processing plants in Atlanta, Baton Rouge, and Chicago, where different varieties of products, including chips, are produced. Recently, the company has experienced a growth in its product demand, so it wants to buy one or more new farms to produce more potato products. The company is considering six new farms with the following annual fixed costs and projected harvest: Farm Fixed Annual Costs ($1,000s) Projected Annual Harvest (thousands of tons) 1 $405 11.2 2 390 10.5 3 450 12.8 4 368 9.3 5 520 10.8 6 465 9.6 The company currently has the following additional available production capacity (tons) at its three plants, which it wants to utilize: Plant Available Capacity (thousands of tons) A 12 B 10 C 14 The shipping costs ($) per ton from the farms…arrow_forwardABC Condominium Corp. of Baguio City, recently purchased land and is attempting to determine the size of the condominiumdevelopment it should build. It is considering three sizes of development: small (D1); medium (D2); and large (D3). With the threelevels of demand- low (S1), medium (S2) and high (S3), the company’s management has prepared the following profit payoff table: Decision Alternatives Low (S1) Medium (S2) High (S3) D1- Small Condo 400,000 400,000 400,000 D2- Medium Condo 100,000 600,000 600,000 D3- Large Condo (300,000) 300,000 900,000 Required:9. Assuming the probabilities for the state of nature are P(S1)=0.20; P(S2)=0.35 and P(S3)= 0.45, what decision should ABCCondominium Corp make?10. Using the information from No. 9, what is the relevant income in ABC's decision?11. Using information in No. 9 , at how much will the "Medium condo, high demand" payoff would be indifferent between the"Medium condo" and "Large condo” decisions, given all other…arrow_forward
- ABC Condominium Corp. of Baguio City, recently purchased land and is attempting to determine the size of the condominiumdevelopment it should build. It is considering three sizes of development: small (D1); medium (D2); and large (D3). With the threelevels of demand- low (S1), medium (S2) and high (S3), the company’s management has prepared the following profit payoff table: Decision Alternatives Low (S1) Medium (S2) High (S3) D1- Small Condo 400,000 400,000 400,000 D2- Medium Condo 100,000 600,000 600,000 D3- Large Condo (300,000) 300,000 900,000 Required:1. At how much will the "Medium condo, high demand" payoff would be indifferent between the"Medium condo" and "Large condo” decisions, given all other applicable data input items remain the same?2. Compute for the Expected Value of Perfect Information.arrow_forwardXYZ Manufaturing company has hired a new VP (D.A.King) for managing capacity investment decisions. Mr. King reviews the situation after he comes on board and decides that he can invest in Batch manufacturing, Custom manufacturing or Group technology. Mr. King will not be able to forecast demand accurately till after the technology choices are made. Demand will be classified into four scenarios: poor, fair, good and excellent. The table below indicates the payoffs for each combination of technology choice and demand scenario. POOR FAIR GOOD EXCELLENT PROBABILITY 0.1 0.4 0.3 0.2 Batch - $200,000 $1,000,000 $1,200,000 $1,300,000 Custom $100,000 $300,000 $700,000 $800,000 Group Technology - $1,000,000 -$500,000 $500,000 $2,000,000 1.What is the expected monetary value of choosing the Group Technology option? 2.What is the expected monetary value of choosing the Batchoption? 3What is the BEST decision based on…arrow_forwardFormulate but do not solve the problem.The management of a private investment club has a fund of $200,000 earmarked for investment in stocks. To arrive at an acceptable overall level of risk, the stocks that management is considering have been classified into three categories: high-risk, medium-risk, and low-risk. Management estimates that high-risk stocks will have a rate of return of 14%/year; medium-risk stocks, 9%/year; and low-risk stocks, 6%/year. The investment in low-risk stocks is to be twice the sum of the investments in stocks of the other two categories. If the investment goal is to have an average rate of return of 9%/year on the total investment, determine how much the club should invest in each type of stock. (Assume that all the money available for investment is invested. Let x, y, and z denote the amount, in dollars, invested in high-, medium-, and low-risk stocks, respectively.) = 200,000 = z = .09(200,000)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Solve ANY Optimization Problem in 5 Steps w/ Examples. What are they and How do you solve them?; Author: Ace Tutors;https://www.youtube.com/watch?v=BfOSKc_sncg;License: Standard YouTube License, CC-BY
Types of solution in LPP|Basic|Multiple solution|Unbounded|Infeasible|GTU|Special case of LP problem; Author: Mechanical Engineering Management;https://www.youtube.com/watch?v=F-D2WICq8Sk;License: Standard YouTube License, CC-BY
Optimization Problems in Calculus; Author: Professor Dave Explains;https://www.youtube.com/watch?v=q1U6AmIa_uQ;License: Standard YouTube License, CC-BY
Introduction to Optimization; Author: Math with Dr. Claire;https://www.youtube.com/watch?v=YLzgYm2tN8E;License: Standard YouTube License, CC-BY