Hi, can you help me? kindly show the step by step on excel since I'm going to follow it. thank you so much! BENEFIT 1 2 MINIMUM ACCEPTABLE LEVEL 1 5 3 60 2 2 2 30 3 7 9 126 UNIT COST $60 $50 (A) Formulate a linear programming model for this problem ON A SPREADSHEET. (b) find the optimal solution
Q: please answer both the questions. and what is the correct answer for this ?
A:
Q: Which of the following would not be a strong barrier to entry for a telecom service provider?…
A: The telecommunications sector is one of the controllers of financial growth and cooperation. As so,…
Q: Opening Case More information has been released on the case related to the Great Eastern Hotel we…
A: The marketing environment relates to the forces that impact the functioning of an organization. It…
Q: for California Cement Company for 2013 and an expected sales growth rate of 6.67% for 2014,…
A: Please find the attached income statement below
Q: Effective financial management is dependent upon a trustworthy budgeting system. Discuss budget in…
A: We can say that where the efficient and effective use of these resources requires planning. We can…
Q: Describe product flow, financial flow, information flow, value flow and risk flow in the light of…
A: Pepsi is a carbonated soft drink manufactured by PepsiCo with multiple variants.
Q: describe the business model for three different organizations, namely a typical brick-and-mortar…
A: The term "brick-and-mortar" refers to a traditional street-side business that offers products and…
Q: Tshepo is the Marketing manager for Eureka hardware. Tshepo is very successful in his career and…
A: The role of a marketing manager is achieve a particular target set by the organization and bring the…
Q: To what extent is logistics a strategic function? Does it really have a long-term effect on an…
A: Logistics is simply the transportation of goods from source to destination. While it has the main…
Q: I'm still not able to get $304,000. Instead, I get $314,963. What am I doing wrong?
A: Linear programming, often known as linear optimization, is a method for obtaining the best result…
Q: The pizza delivery business is very competitive, with both local businesses and national chains…
A: Q.no 1. The company papa john’s used both traditional and modern techniques of marketing Q.no 2.…
Q: 10) Which of the following is the basic objective of financial management? a. All b. Timely payment…
A: Financial management refers to managing the funds of an organization by planning, organizing, and…
Q: In carrying out operations and finances in a business, entrepreneurs usually review again decide on…
A: A harvest strategy is a business and marketing strategy that comprises of reduction or termination…
Q: setting should b
A: Talking about the objectives then, if there are five components in the objective then, only it is…
Q: perform a PEST analysis. From the readings this week, reflect on the list of key questions to help…
A: Every company is always influenced by many factors around it. These factors can be micro as well as…
Q: Sarah is small entepreuner she just started her business selling cookies at home, the market is new…
A: The business started by entrepreneurs will be based on new ideas or products or services. It is…
Q: COMPANY NAME: FINTEC GLOBAL BERHAD MALAYSIA REQUIREMENTS NEEDED FOR DETAILED INTRODUCTION 1. BRIEF…
A: Ans. Introduction Fintec Global Berhad was established in year 2007 under the name of Asia Bioenergy…
Q: Lako Systems is calculating the firm's training costs. While they were able to easily account for…
A: Lako Systems is calculating the firm's training costs. While they were able to easily account for…
Q: American Airline has an arrangement with a foreign airline headquartered in Argentina. American…
A: A market entry in another country is the designed method of delivering goods or services to a new…
Q: Assess the impact of the environment on the Great Eastern Hotel. Make assumptions where necessary.
A: Hotels are an integral part of every community's economic structure. External environment challenges…
Q: As a manager what strategy, style, or action plan in Scope for Reducing Costs in terms of the…
A: Below is the solution:
Q: evaluate Caterpillar’s current competitive advantages and disadvantages.
A: Competitive Advantage Competitive advantage refers to all of the factors that enable a certain…
Q: I need help with my business plan, here's a summery of my executive summary to help you out: "The…
A: For its smooth running, every business draws up a business plan which summarizes what it sells, who…
Q: In today’s fast-paced world, new laws and technologies come along that can change the way a business…
A: Given, Fixed cost- $10000 Variable cost- 60% pf selling price
Q: 40) The combination between Google Maps with real estate data, is an example of: * O A) cloud…
A: When it comes to information access, then internet is a double-edged sword. At very less time we…
Q: Explain the factors that hinder the success of 5S 1.)Project sponsor is not decision maker 2.)…
A: The 5S methodology is the method to change attitudes among employee and help them engage in…
Q: How can Dell minimize the risks brought by outsourcing based on the attributes of service provision?
A: Dell is an American worldwide computer or PC innovation company that creates, sells, fixes, and…
Q: .How are entrepreneurs behaviorally different from managers? When can we expect entrepreneurs to…
A: "Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: Santiago wants to thoroughly understand the issues that created the severe economic straits Boeing…
A: Survey research is a process in which we collect information by taking responses or answers directly…
Q: Colleen Stevens is the North Carolina senior account manager for a national medical equipment…
A: A sales center is the most known example of revenue center. Colleen is mostly likely in charge of…
Q: 3. What service provided from the SBA site would you like to see improved? How?
A: 3. The SBA is working to meet the most pressing needs of the small business community by…
Q: of Ford’s external and internal environments. organize your response by classifying external trends…
A: A project's SWOT analysis measures its strengths and weaknesses, as well as its opportunities and…
Q: 1) What was AlphaCo's issue(s)? 2) How did AlphaCo address their issues? 3) After reviewing this…
A: AlphaCo is a successful apparel retailer that has developed from a catalog-based background. The…
Q: Miss. Sara is a Marketing Manager of a large events management company. The company arranges…
A: There are various business organizations that have been established in the world. This has been made…
Q: Situation 1 You want to start an online clothing store and need information about the size of the…
A: Case: I want to start an online clothing store, and need information regarding size of the market…
Q: Read and analyze the following case: Limpio Mucho, Inc. has just merged with HPS # 1 and has assumed…
A: Job analysis could also be a scientific process of collecting the knowledge on nature of employment,…
Q: In what type of industry do you see linear programming as the most beneficial? Why is that?
A: IntroductionLinear programming is a mathematical technique that is used to determine the best…
Q: More information has been released on the case related to the Great Eastern Hotel we saw in the…
A: The strategy is the art of framing a general plan to attain the long-term plans or the goals under…
Q: Explain Starbuck's success or lack thereof using at least three performance measures (use at least…
A: Starbucks is a leading coffee brand around the world. It has extended the concept of coffee variety…
Q: FACTS: N Bank, with nearly 150 branches (from Napa Valley, California, to Seattle, Washington) and…
A: The business is run by the entrepreneur mostly for increasing the profits. The profits will be the…
Q: Domino’s Pizza is fighting a lawsuit based on disparate treatment and Round Table Pizza is fighting…
A: Every employee should be fairly treated at the workplace. It is unlawful and illegal to treat…
Q: More information has been released on the case related to the Great Eastern Hotel we saw in the…
A: The market positioning is the brand’s ability to influence the perception of consumers from other…
Hi, can you help me? kindly show the step by step on excel since I'm going to follow it. thank you so much!
BENEFIT | 1 | 2 | MINIMUM ACCEPTABLE LEVEL |
1 | 5 | 3 | 60 |
2 | 2 | 2 | 30 |
3 | 7 | 9 | 126 |
UNIT COST | $60 | $50 |
(A) Formulate a linear programming model for this problem ON A SPREADSHEET.
(b) find the optimal solution
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 3 images
- An automobile manufacturer is considering whether to introduce a new model called the Racer. The profitability of the Racer depends on the following factors: The fixed cost of developing the Racer is triangularly distributed with parameters 3, 4, and 5, all in billions. Year 1 sales are normally distributed with mean 200,000 and standard deviation 50,000. Year 2 sales are normally distributed with mean equal to actual year 1 sales and standard deviation 50,000. Year 3 sales are normally distributed with mean equal to actual year 2 sales and standard deviation 50,000. The selling price in year 1 is 25,000. The year 2 selling price will be 1.05[year 1 price + 50 (% diff1)] where % diff1 is the number of percentage points by which actual year 1 sales differ from expected year 1 sales. The 1.05 factor accounts for inflation. For example, if the year 1 sales figure is 180,000, which is 10 percentage points below the expected year 1 sales, then the year 2 price will be 1.05[25,000 + 50( 10)] = 25,725. Similarly, the year 3 price will be 1.05[year 2 price + 50(% diff2)] where % diff2 is the percentage by which actual year 2 sales differ from expected year 2 sales. The variable cost in year 1 is triangularly distributed with parameters 10,000, 12,000, and 15,000, and it is assumed to increase by 5% each year. Your goal is to estimate the NPV of the new car during its first three years. Assume that the company is able to produce exactly as many cars as it can sell. Also, assume that cash flows are discounted at 10%. Simulate 1000 trials to estimate the mean and standard deviation of the NPV for the first three years of sales. Also, determine an interval such that you are 95% certain that the NPV of the Racer during its first three years of operation will be within this interval.Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.In Example 11.1, the possible profits vary from negative to positive for each of the 10 possible bids examined. a. For each of these, use @RISKs RISKTARGET function to find the probability that Millers profit is positive. Do you believe these results should have any bearing on Millers choice of bid? b. Use @RISKs RISKPERCENTILE function to find the 10th percentile for each of these bids. Can you explain why the percentiles have the values you obtain?
- W. L. Brown, a direct marketer of womens clothing, must determine how many telephone operators to schedule during each part of the day. W. L. Brown estimates that the number of phone calls received each hour of a typical eight-hour shift can be described by the probability distribution in the file P10_33.xlsx. Each operator can handle 15 calls per hour and costs the company 20 per hour. Each phone call that is not handled is assumed to cost the company 6 in lost profit. Considering the options of employing 6, 8, 10, 12, 14, or 16 operators, use simulation to determine the number of operators that minimizes the expected hourly cost (labor costs plus lost profits).The annual demand for Prizdol, a prescription drug manufactured and marketed by the NuFeel Company, is normally distributed with mean 50,000 and standard deviation 12,000. Assume that demand during each of the next 10 years is an independent random number from this distribution. NuFeel needs to determine how large a Prizdol plant to build to maximize its expected profit over the next 10 years. If the company builds a plant that can produce x units of Prizdol per year, it will cost 16 for each of these x units. NuFeel will produce only the amount demanded each year, and each unit of Prizdol produced will sell for 3.70. Each unit of Prizdol produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. a. Among the capacity levels of 30,000, 35,000, 40,000, 45,000, 50,000, 55,000, and 60,000 units per year, which level maximizes expected profit? Use simulation to answer this question. b. Using the capacity from your answer to part a, NuFeel can be 95% certain that actual profit for the 10-year period will be between what two values?The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
- Play Things is developing a new Lady Gaga doll. The company has made the following assumptions: The doll will sell for a random number of years from 1 to 10. Each of these 10 possibilities is equally likely. At the beginning of year 1, the potential market for the doll is two million. The potential market grows by an average of 4% per year. The company is 95% sure that the growth in the potential market during any year will be between 2.5% and 5.5%. It uses a normal distribution to model this. The company believes its share of the potential market during year 1 will be at worst 30%, most likely 50%, and at best 60%. It uses a triangular distribution to model this. The variable cost of producing a doll during year 1 has a triangular distribution with parameters 15, 17, and 20. The current selling price is 45. Each year, the variable cost of producing the doll will increase by an amount that is triangularly distributed with parameters 2.5%, 3%, and 3.5%. You can assume that once this change is generated, it will be the same for each year. You can also assume that the company will change its selling price by the same percentage each year. The fixed cost of developing the doll (which is incurred right away, at time 0) has a triangular distribution with parameters 5 million, 7.5 million, and 12 million. Right now there is one competitor in the market. During each year that begins with four or fewer competitors, there is a 25% chance that a new competitor will enter the market. Year t sales (for t 1) are determined as follows. Suppose that at the end of year t 1, n competitors are present (including Play Things). Then during year t, a fraction 0.9 0.1n of the company's loyal customers (last year's purchasers) will buy a doll from Play Things this year, and a fraction 0.2 0.04n of customers currently in the market ho did not purchase a doll last year will purchase a doll from Play Things this year. Adding these two provides the mean sales for this year. Then the actual sales this year is normally distributed with this mean and standard deviation equal to 7.5% of the mean. a. Use @RISK to estimate the expected NPV of this project. b. Use the percentiles in @ RISKs output to find an interval such that you are 95% certain that the companys actual NPV will be within this interval.You now have 10,000, all of which is invested in a sports team. Each year there is a 60% chance that the value of the team will increase by 60% and a 40% chance that the value of the team will decrease by 60%. Estimate the mean and median value of your investment after 50 years. Explain the large difference between the estimated mean and median.A common decision is whether a company should buy equipment and produce a product in house or outsource production to another company. If sales volume is high enough, then by producing in house, the savings on unit costs will cover the fixed cost of the equipment. Suppose a company must make such a decision for a four-year time horizon, given the following data. Use simulation to estimate the probability that producing in house is better than outsourcing. If the company outsources production, it will have to purchase the product from the manufacturer for 25 per unit. This unit cost will remain constant for the next four years. The company will sell the product for 42 per unit. This price will remain constant for the next four years. If the company produces the product in house, it must buy a 500,000 machine that is depreciated on a straight-line basis over four years, and its cost of production will be 9 per unit. This unit cost will remain constant for the next four years. The demand in year 1 has a worst case of 10,000 units, a most likely case of 14,000 units, and a best case of 16,000 units. The average annual growth in demand for years 2-4 has a worst case of 7%, a most likely case of 15%, and a best case of 20%. Whatever this annual growth is, it will be the same in each of the years. The tax rate is 35%. Cash flows are discounted at 8% per year.
- Which of the following types of mortgage loans is presumed to feature points or fees not excending 3%, a maximum term not to exceed 30 years, and no risky features (such as negative amortization, interest-only, or balloon loans)? A) A qualified mortgage B) A conventional mortgage C) A non-qualified mortgage D) A home equity line of credit (HELOC) mortgageCAN YOU EXPLAIN THREE OUTPUTS OF MARTRIX MODEL CONNNNUNICATION WITH SOME EXAMPLES?4. Explain how the logit model overcomes the problems associated with the Linera Probability Model in binary dependent variaraile model.