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
- If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?This problem is based on Motorolas online method for choosing suppliers. Suppose Motorola solicits bids from five suppliers for eight products. The list price for each product and the quantity of each product that Motorola needs to purchase during the next year are listed in the file P06_93.xlsx. Each supplier has submitted the percentage discount it will offer on each product. These percentages are also listed in the file. For example, supplier 1 offers a 7% discount on product 1 and a 30% discount on product 2. The following considerations also apply: There is an administrative cost of 5000 associated with setting up a suppliers account. For example, if Motorola uses three suppliers, it incurs an administrative cost of 15,000. To ensure reliability, no supplier can supply more than 80% of Motorolas demand for any product. A supplier must supply an integer amount of each product it supplies. Develop a linear integer model to help Motorola minimize the sum of its purchase and administrative costs.
- 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.Another way to derive a demand function is to break the market into segments and identify a low price, a medium price, and a high price. For each of these prices and market segments, we ask company experts to estimate product demand. Then we use Excels trend curve fitting capabilities to fit a quadratic function that represents that segments demand function. Finally, we add the segment demand curves to derive an aggregate demand curve. Try this procedure for pricing a candy bar. Assume the candy bar costs 0.55 to produce. The company plans to charge between 1.10 and 1.50 for this candy bar. Its marketing department estimates the demands shown in the file P07_47.xlsx (in thousands) in the three regions of the country where the candy bar will be sold. What is the profit-maximizing price, assuming that the same price will be charged in all three regions?The eTech Company is a fairly recent entry in the electronic device area. The company competes with Apple. Samsung, and other well-known companies in the manufacturing and sales of personal handheld devices. Although eTech recognizes that it is a niche player and will likely remain so in the foreseeable future, it is trying to increase its current small market share in this huge competitive market. Jim Simons, VP of Production, and Catherine Dolans, VP of Marketing, have been discussing the possible addition of a new product to the companys current (rather limited) product line. The tentative name for this new product is ePlayerX. Jim and Catherine agree that the ePlayerX, which will feature a sleeker design and more memory, is necessary to compete successfully with the big boys, but they are also worried that the ePlayerX could cannibalize sales of their existing productsand that it could even detract from their bottom line. They must eventually decide how much to spend to develop and manufacture the ePlayerX and how aggressively to market it. Depending on these decisions, they must forecast demand for the ePlayerX, as well as sales for their existing products. They also realize that Apple. Samsung, and the other big players are not standing still. These competitors could introduce their own new products, which could have very negative effects on demand for the ePlayerX. The expected timeline for the ePlayerX is that development will take no more than a year to complete and that the product will be introduced in the market a year from now. Jim and Catherine are aware that there are lots of decisions to make and lots of uncertainties involved, but they need to start somewhere. To this end. Jim and Catherine have decided to base their decisions on a planning horizon of four years, including the development year. They realize that the personal handheld device market is very fluid, with updates to existing products occurring almost continuously. However, they believe they can include such considerations into their cost, revenue, and demand estimates, and that a four-year planning horizon makes sense. In addition, they have identified the following problem parameters. (In this first pass, all distinctions are binary: low-end or high-end, small-effect or large-effect, and so on.) In the absence of cannibalization, the sales of existing eTech products are expected to produce year I net revenues of 10 million, and the forecast of the annual increase in net revenues is 2%. The ePIayerX will be developed as either a low-end or a high-end product, with corresponding fixed development costs (1.5 million or 2.5 million), variable manufacturing costs ( 100 or 200). and selling prices (150 or 300). The fixed development cost is incurred now, at the beginning of year I, and the variable cost and selling price are assumed to remain constant throughout the planning horizon. The new product will be marketed either mildly aggressively or very aggressively, with corresponding costs. The costs of a mildly aggressive marketing campaign are 1.5 million in year 1 and 0.5 million annually in years 2 to 4. For a very aggressive campaign, these costs increase to 3.5 million and 1.5 million, respectively. (These marketing costs are not part of the variable cost mentioned in the previous bullet; they are separate.) Depending on whether the ePlayerX is a low-end or high-end produce the level of the ePlayerXs cannibalization rate of existing eTech products will be either low (10%) or high (20%). Each cannibalization rate affects only sales of existing products in years 2 to 4, not year I sales. For example, if the cannibalization rate is 10%, then sales of existing products in each of years 2 to 4 will be 10% below their projected values without cannibalization. A base case forecast of demand for the ePlayerX is that in its first year on the market, year 2, demand will be for 100,000 units, and then demand will increase by 5% annually in years 3 and 4. This base forecast is based on a low-end version of the ePlayerX and mildly aggressive marketing. It will be adjusted for a high-end will product, aggressive marketing, and competitor behavior. The adjustments with no competing product appear in Table 2.3. The adjustments with a competing product appear in Table 2.4. Each adjustment is to demand for the ePlayerX in each of years 2 to 4. For example, if the adjustment is 10%, then demand in each of years 2 to 4 will be 10% lower than it would have been in the base case. Demand and units sold are the samethat is, eTech will produce exactly what its customers demand so that no inventory or backorders will occur. Table 2.3 Demand Adjustments When No Competing Product Is Introduced Table 2.4 Demand Adjustments When a Competing Product Is Introduced Because Jim and Catherine are approaching the day when they will be sharing their plans with other company executives, they have asked you to prepare an Excel spreadsheet model that will answer the many what-if questions they expect to be asked. Specifically, they have asked you to do the following: You should enter all of the given data in an inputs section with clear labeling and appropriate number formatting. If you believe that any explanations are required, you can enter them in text boxes or cell comments. In this section and in the rest of the model, all monetary values (other than the variable cost and the selling price) should be expressed in millions of dollars, and all demands for the ePlayerX should be expressed in thousands of units. You should have a scenario section that contains a 0/1 variable for each of the binary options discussed here. For example, one of these should be 0 if the low-end product is chosen and it should be 1 if the high-end product is chosen. You should have a parameters section that contains the values of the various parameters listed in the case, depending on the values of the 0/1 variables in the previous bullet For example, the fixed development cost will be 1.5 million or 2.5 million depending on whether the 0/1 variable in the previous bullet is 0 or 1, and this can be calculated with a simple IF formula. You can decide how to implement the IF logic for the various parameters. You should have a cash flows section that calculates the annual cash flows for the four-year period. These cash flows include the net revenues from existing products, the marketing costs for ePlayerX, and the net revenues for sales of ePlayerX (To calculate these latter values, it will help to have a row for annual units sold of ePlayerX.) The cash flows should also include depreciation on the fixed development cost, calculated on a straight-line four-year basis (that is. 25% of the cost in each of the four years). Then, these annual revenues/costs should be summed for each year to get net cash flow before taxes, taxes should be calculated using a 32% tax rate, and taxes should be subtracted and depreciation should be added back in to get net cash flows after taxes. (The point is that depreciation is first subtracted, because it is not taxed, but then it is added back in after taxes have been calculated.) You should calculate the company's NPV for the four-year horizon using a discount rate of 10%. You can assume that the fixed development cost is incurred now. so that it is not discounted, and that all other costs and revenues are incurred at the ends of the respective years. You should accompany all of this with a line chart with three series: annual net revenues from existing products; annual marketing costs for ePlayerX; and annual net revenues from sales of ePlayerX. Once all of this is completed. Jim and Catherine will have a powerful tool for presentation purposes. By adjusting the 0/1 scenario variables, their audience will be able to see immediately, both numerically and graphically, the financial consequences of various scenarios.