following outcomes over the last seven months: Quantity Sold Price Advertising 8500 $ 2 $ 2,800 4700 $ 5 $ 200 5800 $ 3 $ 400 7400 $ 2 $ 500 6200 $ 5 $ 3,200 7300 $ 3 $ 1,800 5600 $ 4 $ 900 Regression (Equation) QSold = 8536.213882 - 835.7223514 Price + 0.592228496 Advertising A. Estimate sales when the price is $50 and advertising is $100,000, stating any assumption that you need to make. B. If the firm charges $50 and cost per unit is $30 but increases advertising to $110,000, what conclusions can you derive
Q: An xbar chart is to be established based on x- doublebar=100 and sbar=8 with n=4. The control limits…
A:
Q: What decision should be made by the optimist? What decision should be made by the conservative? What…
A: Solution 1:- Step 1:- Find the maximum value from each row. Step 2:- Find the maximum value from all…
Q: Which approach to quality states that the voice of the customer must be brought into the design…
A: To be determined: Choose the correct option - which approach to quality state that the voice of the…
Q: Using a Venn Diagram, write down the similarities and differences of Value Chain and Supply Chain.
A: The value chain is a business model that transforms the idea of products and services into real…
Q: Gifts-r-us" is a 'gift-wrapping' business. Bobby, Jack, Wesley, Jermaine, and Tom are the…
A:
Q: The management of the Executive Furniture Corporation decided to expand the production capacity at…
A: Transportation problem is a problem wherein the main objective is to minimise the cost of…
Q: Transport LP model formulation The Alfa company produces a single item in three plants, P1, P2 and…
A: Given data is
Q: Neverland Company, a retailer, plans to sell 15,000 units of Product X during the month of August.…
A:
Q: her police departments across the United States, and the CompStat approach has been credited with…
A: It is the acronym of Computer Statistics or Relative Statistics that is very inclusive, system…
Q: The following network describes a transportation scenario in which there are four sources A, B, C,…
A: Given data is
Q: Harriet McNeil, proprietor of McNeil’s Auto Mall, believes that it is good business for her…
A: given, Harriet McNeil, proprietor of McNeil’s Auto Mall, believes that it is good business for her…
Q: Suppose you have been employed by Kam Steels Corporation as a financial manager. You want to change…
A: Just in time(JIT) is an inventory management system where materials or goods are ordered to the…
Q: What do you think is the most important shift in thinking that a project manager needs to make to…
A: An agile workplace can be stated as the type of work environment sketched around entire flexibility.…
Q: Juicy-Juice Ltd. is planning to increase its juice supply for the fiscal year 2021 – 2022. With the…
A: Find the Decision tree below:
Q: LM.91 XYZ Company is rethinking the way it ships to its 74 customers in another city 222 miles away.…
A: Given data is Number of customers(N) = 74 Cost of each order shipped(A) = $126 Average order…
Q: Please outline or bold the answer
A: X1 = Number of one person boats X2 = Number of two persons boats X3 = Number of four-person boats
Q: The problem below looks at forecasting methodologies to determine which forecasting model results in…
A: Formulae: For 3 period moving average (SMA) Simple moving average(Ft) = At-1+At-2+At-33Weighted…
Q: Single time estimate vs. Three-time estimate
A: Time estimation can be stated as the technique of appropriately guessing how long an activity will…
Q: Draw a diagram that illustrates all phases of the business process life cycle and their key…
A:
Q: Explain Warehouse process in detail
A: Warehouse is not limited to storing the materials more than that there are a lot happens in a…
Q: The production planning perjod for flat-screen monitors at Louisiana's Rao Electronics, Inc., is 4…
A: Find the Given details below:
Q: How does EVM operationalize or put into practice the management of trade-offs implied by the triple…
A: Having the triple constraints of doing the deliverables or having the scope, having a time to…
Q: If your forecast for 2022 is 40, using the seasonal index below, what is your forecast for 2nd…
A: Seasonal forecast = Forecast for a period * Seasonal index of that period Given, Total forecast = 40…
Q: Dave's Bar-B-Q operated a moble kitchen that serviced construction sites, office buildings, and…
A: From the given data, Let F3 = forecast value for third week of june Y2= 6 F2=4.7…
Q: MGMT Mobile Company (MMC) offers mobile services to users on a monthly subscription basis. Special…
A: given, MGMT Mobile Company (MMC) offers mobile services to users on a monthly subscription basis.…
Q: 2. 888 Chapter 3 Problems 113 A total of 60 forklift trucks are produced and shipped per week. Each…
A: Note: - Since the exact question that has to be answered is not specified we will answer 3.30 and…
Q: Q7.An example of a leading performance measure is: a. Number of new customers b. Production cycle…
A: Leading performance measure means the measures or the tactics used by the firm which will attract…
Q: 1. The method which usually gives a good basic feasible solution to a transportation problem is •…
A: The transportation method is applied to reach the solution to the problem of efficient…
Q: Consider a project with seven tasks. Three tasks - tasks 3, 4, and 5 - require a specific resource…
A:
Q: 23.Performance measures that allow a company to monitor the capabilities of the employee, the…
A: Learning and growth measures refers to the measures which are taken by the firms to increase the…
Q: Explain why an organization should consider changing from old ways of doing things to new improved…
A: Operational Changes in organizations is required with new improved methods which can leads to…
Q: You have been hired by an inventor of a new power cell for cars, trucks and boats, who has some…
A: A patent is a selective right granted for a creation, which is an item or a strategy that offers…
Q: Consider a volleyball net that consists of a mesh with m squares on the horizontal dimension and n…
A: Determining the proper volleyball net height for your team is crucial for a multitude of reasons.…
Q: What is transaction model and maintenance strategy in operation management?
A: The transaction model and maintenance strategy in operation management are important for organized…
Q: Neverland Company, a retailer, plans to sell 15,000 units of Product X during the month of August.…
A:
Q: Draw a diagram that illustrates all phases of the business process life cycle and their key…
A:
Q: Which category of ethical dilemma the above situation represents? a. Employee safety issue b. Human…
A: Ethical issues occur when a certain decision /scenario / deed builds a conflict with a society’s…
Q: In quality assurance, to monitor characteristics that have discrete values and can be counted, we…
A: Quality assurance is the process of preventing and controlling defects in the products and services…
Q: In the project considered below, activity crashing can take place over a wide range of reduction…
A: given,
Q: In quality assurance, reduction of variations allows us to increase the control limits and have a…
A: Reduction of Variation: Reduction of variation is defined as reduce the product…
Q: Billy is looking to find a new supplier for flour for his bakery. He wants to access a platform that…
A: E-MARKET PLACE: An e-marketplace is an e-commerce website, an online marketplace that would connect…
Q: Q3) The cost for a product B is 18 TL per unit. Holding cost is 16 TL per unit per quarter and order…
A: Find the Given details below: Given details: Product cost (k) 18 TL per Unit Holding cost…
Q: When crashing a project, the general guideline is to concentrate on the path with? a. The least…
A: A project crashing is the process of reducing the total duration of the project completion based on…
Q: Consider the following LP problem. Minimire 2- 9.20x, + 5.90x2 Subject toi Constraint 1 Sx1 + 3x2…
A: a.
Q: Operating decisions can include: A.measuring performance against benchmarks B.deciding whether to…
A: Operational decisions are also called operating decisions, these decisions are made to handle…
Q: Quetion in picture
A: A benefit-cost ratio (BCR) defined as a ratio which is use in cost benefit analysis and its…
Q: The materials handling manager of a manufacturing company is trying to forecast the cost of…
A: a)The POS for Windows regression model is as follows
Q: Attendance at Orlando's newest Disneylike attraction, Lego World, has been as follows: Guests (in…
A: Seasonal indices identify the seasonal variations and helps to forecast upcoming years based while…
Q: 13.42 Activity Ais worth $100, is complete, and actually cost $150. Activity B is worth $500, is 75%…
A:
Q: dentify resources and capabilities emerging out of different functional areas for a company of your…
A: A Small Introduction to Resources and Capabilities Assets are the association's resources,…
Fresh Food has recently carried out a survey of the demand for their seasonal fruits. They observed the following
outcomes over the last seven months:
Quantity
Sold Price Advertising
8500 $ 2 $ 2,800
4700 $ 5 $ 200
5800 $ 3 $ 400
7400 $ 2 $ 500
6200 $ 5 $ 3,200
7300 $ 3 $ 1,800
5600 $ 4 $ 900
Regression (Equation)
QSold = 8536.213882 - 835.7223514 Price + 0.592228496 Advertising
A. Estimate sales when the price is $50 and advertising is $100,000, stating any assumption that you need to make.
B. If the firm charges $50 and cost per unit is $30 but increases advertising to $110,000, what conclusions can you derive
in terms of revenues and profits?
Step by step
Solved in 5 steps with 1 images
- 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.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.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?
- Dilberts Department Store is trying to determine how many Hanson T-shirts to order. Currently the shirts are sold for 21, but at later dates the shirts will be offered at a 10% discount, then a 20% discount, then a 40% discount, then a 50% discount, and finally a 60% discount. Demand at the full price of 21 is believed to be normally distributed with mean 1800 and standard deviation 360. Demand at various discounts is assumed to be a multiple of full-price demand. These multiples, for discounts of 10%, 20%, 40%, 50%, and 60% are, respectively, 0.4, 0.7, 1.1, 2, and 50. For example, if full-price demand is 2500, then at a 10% discount customers would be willing to buy 1000 T-shirts. The unit cost of purchasing T-shirts depends on the number of T-shirts ordered, as shown in the file P10_36.xlsx. Use simulation to determine how many T-shirts the company should order. Model the problem so that the company first orders some quantity of T-shirts, then discounts deeper and deeper, as necessary, to sell all of the shirts.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?It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.
- Suppose you have invested 25% of your portfolio in four different stocks. The mean and standard deviation of the annual return on each stock are shown in the file P11_46.xlsx. The correlations between the annual returns on the four stocks are also shown in this file. a. What is the probability that your portfolios annual return will exceed 30%? b. What is the probability that your portfolio will lose money during the year?Based on Babich (1992). Suppose that each week each of 300 families buys a gallon of orange juice from company A, B, or C. Let pA denote the probability that a gallon produced by company A is of unsatisfactory quality, and define pB and pC similarly for companies B and C. If the last gallon of juice purchased by a family is satisfactory, the next week they will purchase a gallon of juice from the same company. If the last gallon of juice purchased by a family is not satisfactory, the family will purchase a gallon from a competitor. Consider a week in which A families have purchased juice A, B families have purchased juice B, and C families have purchased juice C. Assume that families that switch brands during a period are allocated to the remaining brands in a manner that is proportional to the current market shares of the other brands. For example, if a customer switches from brand A, there is probability B/(B + C) that he will switch to brand B and probability C/(B + C) that he will switch to brand C. Suppose that the market is currently divided equally: 10,000 families for each of the three brands. a. After a year, what will the market share for each firm be? Assume pA = 0.10, pB = 0.15, and pC = 0.20. (Hint: You will need to use the RISKBINOMLAL function to see how many people switch from A and then use the RISKBENOMIAL function again to see how many switch from A to B and from A to C. However, if your model requires more RISKBINOMIAL functions than the number allowed in the academic version of @RISK, remember that you can instead use the BENOM.INV (or the old CRITBENOM) function to generate binomially distributed random numbers. This takes the form =BINOM.INV (ntrials, psuccess, RAND()).) b. Suppose a 1% increase in market share is worth 10,000 per week to company A. Company A believes that for a cost of 1 million per year it can cut the percentage of unsatisfactory juice cartons in half. Is this worthwhile? (Use the same values of pA, pB, and pC as in part a.)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.
- Suppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semifragile, and durable. Costs for 15 randomly chosen packages of approximately the same weight and same distance shipped, but of different cargo types, are provided in the file P13_16.xlsx. a. Estimate a regression equation using the given sample data, and interpret the estimated regression coefficients. b. According to the estimated regression equation, which cargo type is the most costly to ship? Which cargo type is the least costly to ship? c. How well does the estimated equation fit the given sample data? How might the fit be improved? d. Given the estimated regression equation, predict the cost of shipping a package with semifragile cargo.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.)The DC Cisco office is trying to predict the revenue it will generate next week. Ten deals may close next week. The probability of each deal closing and data on the possible size of each deal (in millions of dollars) are listed in the file P11_55.xlsx. Use simulation to estimate total revenue. Based on the simulation, the company can be 95% certain that its total revenue will be between what two numbers?