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.

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.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

A franchise operation that sells frozen custardintends to open one or more new stores in amedium-sized metropolitan area. Three sitesare under consideration. Each site hassomewhat different projected profitcontribution and different supervisionrequirements. The first site has an estimateddaily profit of $200 and a weekly supervisionrequirement of 48 hours; the second site has aprojected profit of $100 per day and a weeklysupervision requirement of 30 hours; and thethird site has an estimated daily profit of $150and a weekly supervision requirement of 20hours. The firm will have 65 hours available forper week for supervision.Use Excel to determine which site or sitesshould be selected in order to obtain thehighest projected daily profit?
4.1REQUIREDStudy the information given below and calculate the following if the sales manager’s proposal is accepted:4.1.1 Break-even quantity.4.1.2 The number of units that must be sold to achieve the company’s profit objective. INFORMATIONSirloin Enterprises manufactures a product that sells for R9 each. The company presently produces and sells 90 000 units per year. Total variable manufacturing costs and selling costs are R405 000 and R81 000 (10% of sales) respectively. Fixed costs are R226 440 for manufacturing overheads and R97 200 for selling and administrative activities.The sales manager has proposed that the price be increased to R10.80 per unit. The company’s profit objective is 10% of sales. 4.2 ENO Ltd, a pharmaceutical company, is seeking finance for the development of a vaccine aimed at reducing the spread the Corona virus. The company is seeking funding only from the public in the form of equity as well as long-term borrowing.In light of the above, critically discuss…
A manufacturing company has the following financial information (in millions of $)Sales $562Cost of goods soldDirect labor 43Purchased materials 267Overhead 35All other costs 142Pretax earnings 75a. What is the profit leverage effect of purchasing in this company?b. What is the percent increase in earnings from a 5 percent savings in purchasing?
1) Which of the following translates business plan into productionplanningAPPMPSMRPNone of the Above2) Master production schedule is a medium-range planning and it isused for quantity and timing ofcomponents and raw materialFinished goodsBoth A & B3) The manufacturing strategy which deploys hiring and laying ofworkers in order to match its production rate to demand is calledLevel Production StrategyChase Production StartegyHybrid StrategyNone of the above4) "In a level production strategy, if the firm makes annual 120,00units per annum, the permonth production can be estimatted by""120,00 /12""120,00 / 365"The information is not complete5) The Bill of material is an engineering documments that showsinclusive listing and sub-components to be used for end productTRUEFALSE6) A lead capacity usually increases or decreases its capacity in anticipation of demand, this is known as "Match strategyLead Capacity StrategyLag capacity strategy7) The most important output of MRP isBOMPlanned…
You are the owner of Caché, a chain of women's clothing boutiques. Your state has a sales tax of 7%, and your city has an additional sales tax of 1.5%. Each quarter you are responsible for making these tax deposits to the city and state. Last quarter your stores had total revenue, including sales tax, of $488,250. a) How much of this revenue was sales (in $) and how much was sales tax (in $)? sales sales tax b) How much sales tax (in $) should be sent to the city? c)How much sales tax (in $) should be sent to the state?
9.5 Capital Healthplans Inc. is evaluating two different methods for providing home health services to its members. Both methods involve contracting out for services, and the health outcomes and revenues are not affected by the method chosen. Therefore, the net cash flows for the decision are all outflows. Here are the projected flows: Year Method A ($) Method B ($) 0 (300,000) (120,000) 1 (66,000) (96,000) 2 (66,000) (96,000) 3 (66,000) (96,000) 4 (66,000) (96,000) 5 (66,000) (96,000) What is each alternative’s IRR? If the opportunity cost of capital for both methods is 9 percent, which method should be chosen? Why?
As a result of its consultants' wonderful guidance in 1901, Smithfield Custom Furniture has continued to do extremely well financially. It is now 1987, and the company has been headed by the founder's grandson, Jonas Smithfield III. He has run the company for the past twenty years. The company now has 247 retail stores. 220 stores are spread throughout the 50 states, and 27 stores are located in England, France, and Germany. Each country has 9 stores. In total, the company employs 13,000 people. Approximately 40% are manufacturing, distribution, quality control, design, delivery, administrative, and back-office work. Approximately 60% of the employees are in retail stores. It has been Smithfield Custom Furniture's mission to target the wealthiest segments of the market. The company does all its manufacturing in the United States at six facilities, recently modernized with the latest equipment. They use the finest and most exotic woods to make distinctive furniture for their clientele.…
As a result of its consultants' wonderful guidance in 1901, Smithfield Custom Furniture has continued to do extremely well financially. It is now 1987, and the company has been headed by the founder's grandson, Jonas Smithfield III. He has run the company for the past twenty years. The company now has 247 retail stores. 220 stores are spread throughout the 50 states, and 27 stores are located in England, France, and Germany. Each country has 9 stores. In total, the company employs 13,000 people. Approximately 40% are manufacturing, distribution, quality control, design, delivery, administrative, and back-office work. Approximately 60% of the employees are in retail stores. It has been Smithfield Custom Furniture's mission to target the wealthiest segments of the market. The company does all its manufacturing in the United States at six facilities, recently modernized with the latest equipment. They use the finest and most exotic woods to make distinctive furniture for their clientele.…
As a result of its consultants' wonderful guidance in 1901, Smithfield Custom Furniture has continued to do extremely well financially. It is now 1987, and the company has been headed by the founder's grandson, Jonas Smithfield III. He has run the company for the past twenty years. The company now has 247 retail stores. 220 stores are spread throughout the 50 states, and 27 stores are located in England, France, and Germany. Each country has 9 stores. In total, the company employs 13,000 people. Approximately 40% are manufacturing, distribution, quality control, design, delivery, administrative, and back-office work. Approximately 60% of the employees are in retail stores. It has been Smithfield Custom Furniture's mission to target the wealthiest segments of the market. The company does all its manufacturing in the United States at six facilities, recently modernized with the latest equipment. They use the finest and most exotic woods to make distinctive furniture for their clientele.…
Variable cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $B$6 Activity 1 3 0 30 23 17 $C$6 Activity 2 6 0 40 50 10 $D$6 Activity 3 0 –7 20 7 1E+30 Constraints Cell Name Final Value Shadow Price Constraint R.H. Side Allowable Increase Allowable Decrease $E$2 Resource A 20 7.78 20 10 12.5 $E$3 Resource B 30 6 30 50 10 $E$4 Resource C 18 0 40 1E+30 22 What is the optimal objective function value for this problem?
Course: Management Information Systems 1 MGMT Mobile Company (MMC) offers mobile services to users on a monthly subscription basis.Special discounts are given to customers for frequently using their pre- or post-paid mobile service.Customers can also sign up online or visit one of ten outlets stationed at various locations around thecountry. Customers can opt to receive their bills either through the post or online but all payments are21stdue by the of each month. An 18.5% mobile tax is applied to the cost of all services. All transactions, customer calls and other data are captured in a database, where specific data can beextracted for decision making. As a new employee of a team in the IS Department of this corporation, your manager wants you to produce some reports for him to review for the next quarter, such as which types of customers should be targeted for special offers and how much money is received for taxes.Reports reaching Executive management revealed that all of the…
Course: Management Information Systems 1 MGMT Mobile Company (MMC) offers mobile services to users on a monthly subscription basis.Special discounts are given to customers for frequently using their pre- or post-paid mobile service.Customers can also sign up online or visit one of ten outlets stationed at various locations around thecountry. Customers can opt to receive their bills either through the post or online but all payments are21stdue by the of each month. An 18.5% mobile tax is applied to the cost of all services. All transactions, customer calls and other data are captured in a database, where specific data can beextracted for decision making. As a new employee of a team in the IS Department of this corporation, your manager wants you to produce some reports for him to review for the next quarter, such as which types of customers should be targeted for special offers and how much money is received for taxes.Reports reaching Executive management revealed that all of the…