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
- Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher’s model. The firm has 900 hours of production time available in its cutting and sewing department, 300 hours available in its finishing department, and 100 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table Production Time Model Cutting and Sewing Finishing Packaging and Shipping Profit / Glove Regular Model 1 1/2 1/8 $5 Catcher Model 3/2 1/3 1/4 $8 Assuming that the company is interested in maximizing the total profit contribution, answer the following: What is the linear programming model for this problem? Find the optimal solution using the graphical solution procedure. How many gloves of each model should Kelson Manufacture? What is the total profit contribution Kelson can earn with…arrow_forwardThe Acme Manufacturing Company is concerned about its warehouse needs and how they can best be met. The company produces a line of spare parts for appliance. Due to the combination of production policies and demand patterns, warehousing space requirement vary considerably throughout the year. Space requirements are known with a great deal of certainty because the product line satisfies a replacement market. Growth, or decline, in production and sales is not anticipated in the near future. Monthly sales rates for a typical year are as follows: Month Sales, S Jan, 5,000,000 Feb. 4,000,000 Mar. 3,000,000 Aprг. 2,000,000 May 1,000,000 June 250,000 July 1,250,000 Aug. 2,250,000 Sept. 3,000,000 Oct 3,500,000 Nov. 4,000,000 Dec. 4,500,000 Total 33,750,000 Warehouse inventory turns at the rate of two times per month. The price of merchandise is $5 per Ib. On average, merchandise occupies 0.1 cubic feet of warehouse space per lb and can be stacked 10 ft. high. Given aisles, administrative…arrow_forwardThe Acme Manufacturing Company is concerned about its warehouse needs and how they can best be met. The company produces a line of spare parts for appliance. Due to the combination of production policies and demand patterns, warehousing space requirement vary considerably throughout the year. Space requirements are known with a great deal of certainty because the product line satisfies a replacement market. Growth, or decline, in production and sales is not anticipated in the near future. Monthly sales rates for a typical year are as follows: Month Sales, $ Jan. 5,000,000 Feb. 4,000,000 Mar. 3,000,000 Apr. 2,000,000 May 1,000,000 June 250,000 July 1,250,000 Aug. 2,250,000 Sept. 3,000,000 Oct. 3,500,000 Nov. 4,000,000 Dec. 4,500,000 Total 33,750,000 Warehouse inventory turns at the rate of two times per month. The price of merchandise is $5 per lb. On average, merchandise occupies 0.1 cubic feet of warehouse space per lb and can be stacked 10 ft. high. Given…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
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