Comprehensive model formulation exercise Q1: New product development Problem A Leisure Food Company plans to develop some new products. The following table shows relevant data for six potential foods which are under considera tion. The company wants to know which projects should be selected so asto maximize total pr ofits. There are some constrains for project selection. First, the available capital is at most 170 thousand dollars, and the available researchers are no more than 35 people. Second, project 3 and project 4 are closely related, meaning that these two projects must be select ed simultaneously. Third, project 5 must be selected if project 2 or project 3 is selected. Fo urth, considering the potential risks, at most two projects could be selected among project 1, 4, and 6. Fifth, considering the future development, at least one project should be select ed among project 3, 4, and 5. Please help this company to determine the optimal combinations of new products. Table 1 Data table Capital require Researchers r Project Profit ment equirement 1 50 11 65 2 65 16 90 3 45 9. 80 4 55 7 90 40 60 90 110 24 5

Comprehensive model formulation exercise Q1: New product development Problem A Leisure Food Company plans to develop some new products. The following table shows relevant data for six potential foods which are under considera tion. The company wants to know which projects should be selected so asto maximize total pr ofits. There are some constrains for project selection. First, the available capital is at most 170 thousand dollars, and the available researchers are no more than 35 people. Second, project 3 and project 4 are closely related, meaning that these two projects must be select ed simultaneously. Third, project 5 must be selected if project 2 or project 3 is selected. Fo urth, considering the potential risks, at most two projects could be selected among project 1, 4, and 6. Fifth, considering the future development, at least one project should be select ed among project 3, 4, and 5. Please help this company to determine the optimal combinations of new products. Table 1 Data table Capital require Researchers r Project Profit ment equirement 1 50 11 65 2 65 16 90 3 45 9. 80 4 55 7 90 40 60 90 110 24 5

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

How can this situation be prevented from occurring again?
choose the correct answer for the following questions 1. When composing a risk management plan, one of the activities is to define: Group of answer choices Methods Work breakdown structure Project charter Project Resource allocation
Recently, you were assigned to manage a project for your company. You have constructed a network diagram depicting the various activities in the project (shown below to the right). In addition, you have asked your team to estimate the amount of time that they would expect each of the activities to take. Their responses are shown in the following table: D ew an example Activity A B с D Get more help. E Optimistic 4 5 4 1 Time Estimates (days) Most Likely 8 8 5 4 3 a. What is the expected completion time of the project? The expected completion time is days. (Enter your response as an integer.) 8 Pessimistic 12 12 7 5 MacBook Pro 9 Start + B D ( Finish A Q Q Clear all Check answer +
Use the weighted unit cost to determine the conceptual cost estimate (using the three- point estimate technique) for a proposed parking lot that is to contain 131 parked cars. Previous projects data are given in the table below. P.S. Consider the average of all numbers as the most likely value. Project No. Cost No. of cars 1 357,000 120 2 295,200 80 3 487,000 140 4 312,000 70 5 455,000 130 459,100 135 7 389,000 90 8 307,000 60
3.1 Use the generated information to calculate the NPV of the project, to decide whether to go ahead with the project. Investment required Expected economic lifetime R200 000 5 years. Minimum required rate of return 10% Net annual cash inflows 1st year 2nd year R40 000 R100 000 R90 000 3rd year R40 000 4th year R30 000 5th year
The chart below shows the initial investment and expected yearly payback for Project A and Project B Project A Project B Initial Investment $ 300,000 $ 450,000 Expected Yearly PayBack $ 45,000 $ 90,000 For Project A, There has been a change in the expected yearly payback. Years 1 and 2 – you are expecting $45,000 each year. For the next three years, you are expecting $70,000 each year. What would be the average ROI for this alternative?
The manager of the Oak Hills Swimming Club is planning the club’s swimming team program. The first team practice is scheduled for May 1. The activities, their immediate predecessors, and the activity time estimates (in weeks) are as follows: Activity Optimistic Most Probable Pessimistic Immediate Predecessors A 1 2 3 - B 4 6 8 A C 2 4 6 A D 1 2 3 B, C E 2 3 4 B F 1 2 3 A G 1 2 3 D H 1 2 3 G I 1 1 1 E, H, F a. Draw a project network for this problem. b. Fill in all the blanks in the following table. c. What is the expected time and variance to complete the project? Note: For variance (σ2) in activity time, keep two decimal places. Activity Expected Time t (weeks) Variance σ2 ES EF LS LF Slack Critical Path? A B C…
Case studyYou have recently been appointed as the new IT risk manager of a countrywide online tradingbusiness called DirectToCust which sells items directly to the public. Its headquarters are locatedin Cape Town, in the Western Cape and have warehouses in Gauteng, KZN, and the Free state. Thecompany employs over 200 call center agents and about 10 business managers for both inboundand outbound transactions and logistics. They work both day and night shifts in an open-planworkspace of around 40 x 38 m with each agent having their own desk, networked computers andessential office stationery to conduct business. Most, if not all, call center agents’ desktop PCs areconnected to a local network using Ethernet cabling while most line managers’ laptops arewirelessly connected to enable free movement around the premises. All the servers, switches,router, gateways, firewalls, etc., are located at the adjacent IT office and maintained by onenetwork administrator and six support technicians…
Give to objective in this situation 1. The catholic women's league plans a rummage sale at the parish activity area.
Case Study: Planning for a New Residential Development Background: A developer is planning to build a new residential development on a piece of land located on the outskirts of a growing city. The land is currently zoned for agricultural use, but the developer wants to rezone it for residential use. The development will consist of 200 single-family homes on 50 acres of land. The developer is responsible for all infrastructure, including roads, water, and sewage systems. 1. What are the main planning considerations for this residential development? 2. What are some potential challenges the developer may face during the planning process?
Text: We can develop the CSR activities for Nestle company of planting trees and cleaning the lakes. This can be done by partnering with NGOs who are already working in these areas. The company can target several trees to be planted, for example, 100,000 in a quarter and take care of them till growth. To clean the lake, it can take the help of the National scientist of environmental science and fund the project to clean some of the lakes with the target number of again 50. A long-term solution must be used by them in cleaning the lakes, like stopping the sewage inflow and creating a small recycling plant before throwing water into the water bodies. The government, municipality, NGO, and environmental scientists are the main stakeholders involved. Here, the competition must not be created, but collaboration was be done between the competitors to help the society. The competitors will be other brands like Unilever and P&G. Progress indicators can be used as the number of trees…
You are the Project Analyst for Nairobi Project Advisors who have been asked by a client to advise on which of the following two projects should be accepted. Each project costs US$ 10,000 and each entails a 12% cost of capital: Year Expected Net Cash flows Project X Project Y 0 ($ 10,000) ($ 10,000) 1 6,500 3,500 2 3,000 3,500 3 3,000 3,500 4 1,000 3,500 a) Advise on which project should be undertaken using the Pay Back Period (PBP), Net Present Value (NPV), Internal Rate of Return (IRR), and Modified Internal Rate of Return (MIRR) assuming: i. The projects are independent ii. The projects are mutually exclusive