A manufacturer of kitchen appliances is preparing to set the price on a new blender. Demand is thought to depend on the price and is represented by the model D = 3,000-3P. The accounting department estimates that the total costs can be represented by C= 4,000 + 2D. Develop a model for the total profit. Implement the model on a spreadsheet and use nonlinear optimization with Solver to find the price that maximizes profit. The price that maximizes profit is P = $47.81 (Round to the nearest cent as needed.)
Q: Store A Store C $6.70 $3.30 $7.90 $7.20 $4.10 $4.60 740 400 Formulate a linear optimization model…
A: let me state the table data, Plant Store AStore BStore…
Q: 1. Given the inputs below, fill in the projected costs in rows 28-34 with copyable formulas. 2.…
A: The costs and requirements for making a bookshelf are stated below:
Q: Eaglin Company's quality cost report is to be based on the following cata Disposal of defective…
A: Internal failure costs represent the expenses incurred by a company due to quality issues discovered…
Q: Explain. What role does real estate market analysis play in determining the feasibility of specific…
A: Real estate market analysis serves as a pivotal tool for businesses when evaluating potential…
Q: Import the hotel rooms from the downloaded text file a01 grader_a1_Rooms.csv, appending it to…
A: The objective of the question is to import a CSV file into a database, establish relationships…
Q: The following figure shows the product structure tree of product A. A D (2) B (2) E (1) C | D (3)…
A: Operations planning and control is a four-level structure consisting of S&OP, MPS, materials…
Q: Consider the following linear program: Max 1A + 2B 1A <5 1B < 5 2A + 2B = 12 Show the…
A: Find the given details below:Objective Function:Constraints:Subject to
Q: Sales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past…
A: Find the given details below:
Q: Assume you are the chief operating officer of the fast food chain with 5,000 stores in North…
A: Number of stores: 5,000Number of dryers per restroom: 1Number of restrooms: 2Dryer operations: 190
Q: arter of this year using a three-quarter, weighted moving average. Weight the most recent quarter.5,…
A: GivenLAST YEARTHIS…
Q: You are the district manager for the NCDNR aka the Game Wardens. You staff your law enforcement…
A: Linear programming is a mathematical method used to find the best possible outcome or solution from…
Q: I am doing a Project Study so please prepare a journal entry sharing your reflections on your…
A: The center issue recognized for this examining project revolves around figuring out the diverse…
Q: You work for the Brad's Nailer Company which manufactures two types of nai pneumatic model and a…
A: Here, we would use scenario 2. We want to know how much to produce while trying to meet sales…
Q: Mueller & Associates is a urban planning firm that is designing a new public park in an Omaha…
A: The objective of this question is to determine the critical path, expected project completion time,…
Q: Assume an initial starting Ft of 200 units, a trend (Tt) of 8 units, an alpha of 0.30, and a delta…
A: The objective of the question is to calculate the forecast including trend for the next period using…
Q: Henrique Correa's bakery prepares all its cakes between 4 A.M.and 6 A.M.so they will be fresh when…
A: Cs=Sales price per unit−Cost per unit = 8-5 = 3Co=Cost per unit−Salvage value per unit…
Q: Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a…
A: The objective of the question is to determine the objective coefficient ranges, interpret these…
Q: Construct a 3-sigma X-bar chart for the length in centimeters of a part from the following tabble .…
A: Sampleobservation 1observation 2observation 3observation…
Q: Develop Xbar and R charts for the 1st 10 days of monitoring. Plot the data for the 1st 10 days on…
A:
Q: A professor records the number of students who complain each week throughout the semester. If the…
A: Week Complaints152237415362788193105114126133141154
Q: a professor records the number of students who complains each week throughout the semester. if the…
A: The professor records the number of students for recording purposes using statistical methods such…
Q: answer
A: Lean methodologies, rooted in Toyota's innovative practices, are a holistic approach aimed at…
Q: What defines a robust process strategy within an organization?
A: A robust process strategy is fundamental to organizational success, as it defines the framework for…
Q: Multiple Choice: If the bakery had to produce at least one chocolate cake for every four apple pies,…
A: The issue requires characterizing a numerical limitation that precisely addresses a situation in a…
Q: 4) A perishable product is purchased by a retailer for #800 and sold at a price of #900. Because the…
A:
Q: Visiting an applicant's social media pages can be used to screen a candidate. True or False?
A: Social media has become an integral part of modern life, with platforms like Facebook, Twitter,…
Q: Please identify and discuss any two diversity management issues in the workplace. The discussion…
A: Firm includes the area of a healthy environment in the workplace Management or Diversity plays a big…
Q: Identify the example that would not usually be considered a project. A. Building a car B. Developing…
A: Understanding what constitutes a project is essential in various fields, from business management to…
Q: Phillip Witt, president of Witt Input Devices, wishes to create a portfolio of local suppliers for…
A: Given details:Shut down cost $ 4,00,000Probability of Super event0.5%Probability of a Unique…
Q: .A.1 Given the following conditional value table, determine the appropriate decision under…
A: Let me state the information given by table data, AlternativesVery favorable marketAverage…
Q: ow many of each type of delivery vehicle should Speed-E-Deliveries operate in rder to meet these…
A: To minimize greenhouse gas emissions while meeting the delivery requirements, we set up a system of…
Q: The defect rate for a project has histoically been 2.0%. what are the upper and lower control chart…
A: Upper and lower control limits define the allowable ranges of process performance for statistical…
Q: Among the following forecasting techniques, which one utilizes both past time period forecast and…
A: The objective of the question is to identify the forecasting technique that uses both past time…
Q: Explain the logic underlying the Gary Becker model, maximum fine/low probability result. Identify a…
A: Gary Beckers's model is also called the crime and punishment model Basic knowledge about the model…
Q: Using the crossover mileage between the hybrid vehicle and the alternative vehicle from a competing…
A: Let me state the given data, Hybrid vehicleAlternate vehicleVehicle purchase…
Q: W hat role does real estate market analysis play in determining the feasibility of specific…
A: For businesses, It is necessary to find the right location, because by choosing the right location,…
Q: The Northwest Flower Company owns a greenhouse, which furnishes roses and carnations to florists in…
A: Linear programming is a mathematical method used to find the best possible outcome or solution from…
Q: What is the role of KPIs in performance measurement? A. To identify data sources B. To set…
A: Identify data sources: KPIs rely on pre-existing data gathered from various sources; they do not…
Q: The supply capacities at each origin (factory) and demand at each destination (warehouse) are shown…
A: Find the given details below:
Q: A company must perform a maintenance project consisting of seven activities. The activities, their…
A:
Q: In the following table the activities with their precedence sequence and expected time (days) are…
A: The given question is regarding the project network diagram. The given table shows the list of…
Q: Briefly describe a project you know that failed in Botswana. Which of the reasons considered in the…
A: Despite Botswana's stable economy and conducive business environment, projects can still encounter…
Q: Discuss the impact of misreporting of revenue at Xerox and consequences of organisational…
A: Distorting of income at Xerox alludes to the unscrupulous practice where the organization swells its…
Q: Don't give AI answer Explain the significance of good supply chain for an organization
A: A supply chain is an arrangement of interdependent systems, resources, capacities, and technologies…
Q: Given is a PERT project network diagram as shown below. Start A B C D E F H End
A: Find the given details below:
Q: Which one of the following is considered a cost of quality? Penalty costs Direct costs…
A: The issue here is to identify which of the given choices addresses a kind of cost that is directly…
Q: Your insured lives in an apartment but takes a temporary position in another city and must store…
A: The objective of the question is to determine what a Tenant's insurance policy would cover in the…
Q: The desired daily output for an assembly line is 300 units. This assembly line will operate 575…
A:
Q: The effects of climate related risks on insurance companies. - Identify the climate related risks…
A: St Kitts and Nevis are highly recommended because they have a lot of knowledge about single-risk…
Q: the backorder cost per outage is $12.00/unit, and the lead-time is 1 month.
A: Apologies for the mistake. let's recalculate the safety stock using the correct formula and…
Step by step
Solved in 3 steps with 7 images
- When you use a RISKSIMTABLE function for a decision variable, such as the order quantity in the Walton model, explain how this provides a fair comparison across the different values tested.A company manufacturers a product in the United States and sells it in England. The unit cost of manufacturing is 50. The current exchange rate (dollars per pound) is 1.221. The demand function, which indicates how many units the company can sell in England as a function of price (in pounds) is of the power type, with constant 27556759 and exponent 2.4. a. Develop a model for the companys profit (in dollars) as a function of the price it charges (in pounds). Then use a data table to find the profit-maximizing price to the nearest pound. b. If the exchange rate varies from its current value, does the profit-maximizing price increase or decrease? Does the maximum profit increase or decrease?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.
- 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%.In Problem 12 of the previous section, suppose that the demand for cars is normally distributed with mean 100 and standard deviation 15. Use @RISK to determine the best order quantityin this case, the one with the largest mean profit. Using the statistics and/or graphs from @RISK, discuss whether this order quantity would be considered best by the car dealer. (The point is that a decision maker can use more than just mean profit in making a decision.)The IRR is the discount rate r that makes a project have an NPV of 0. You can find IRR in Excel with the built-in IRR function, using the syntax =IRR(range of cash flows). However, it can be tricky. In fact, if the IRR is not near 10%, this function might not find an answer, and you would get an error message. Then you must try the syntax =IRR(range of cash flows, guess), where guess" is your best guess for the IRR. It is best to try a range of guesses (say, 90% to 100%). Find the IRR of the project described in Problem 34. 34. Consider a project with the following cash flows: year 1, 400; year 2, 200; year 3, 600; year 4, 900; year 5, 1000; year 6, 250; year 7, 230. Assume a discount rate of 15% per year. a. Find the projects NPV if cash flows occur at the ends of the respective years. b. Find the projects NPV if cash flows occur at the beginnings of the respective years. c. Find the projects NPV if cash flows occur at the middles of the respective years.
- 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.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.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.
- 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?Sometimes curvature in a scatterplot can be fit adequately (especially to the naked eye) by several trend lines. We discussed the exponential trend line, and the power trend line is discussed in the previous problem. Still another fairly simple trend line is the parabola, a polynomial of order 2 (also called a quadratic). For the demand-price data in the file P13_10.xlsx, fit all three of these types of trend lines to the data, and calculate the MAPE for each. Which provides the best fit? (Hint: Note that a polynomial of order 2 is still another of Excels Trend line options.)Rerun the new car simulation from Example 11.4, but now use the RISKSIMTABLE function appropriately to simulate discount rates of 5%, 7.5%, 10%, 12.5%, and 15%. Comment on how the outputs change as the discount rate decreases from the value used in the example, 10%.