Well Water Inc. wants to produce and sell a new flavored water. In order to penetrate the market, the product will have to sell at $2.00 per 12 oz. bottle. The following data has been collected: Annual sales 50,000 bottles Projected selling and administrative costs $8,000 Desired profit $70,000 The target cost per bottle is
Q: Aqua Man Company manufactures and sells a single product. Planned and actual production in its first…
A: Given information, Actual a Production = 100,000 units Sales = 85000 units Manufacturing -…
Q: Given the following conditional value table: States of Nature Very Favorable Unfavorable Average…
A: The decision-making process includes identifying a decision, gathering information, and evaluating…
Q: Movieflix, an online movie streaming service that offers a wide variety of award-winning TV shows,…
A: Given data, Year 2013 2014 2015 2016 2017 2018 2019 2020 2021Membership…
Q: A national census bureau predicts that a certain population will increase from 34.1 million in 2000…
A: Population increase from 34.1 to 58.2 million Time duration (t) = 2070-2000 = 70
Q: Killian Corporation makes hot chocolate erly forecasts are in following Table. Year 2019 2020 2021…
A: Forecast for the sales for the spring of 2022 is calculated as, FS22 = 100+150+200÷3 = 150…
Q: 10IVE VI ES BEL C XXXX XXXXX0X18a baiv 130A DVIENITME ISYOLSOS Tstotdu2 101 Diecoru Xsl AMOHA JHO…
A: A level plan means same production every period. The optimal production level is determined by…
Q: Sales are 30 000 units in September of 2021. The seasonal index for the month of September is 0.75.…
A: The computing method of seasonal adjustment was simple and easy and can lend to spreadsheets to…
Q: Which of the products should be processed further? Product A Product C Product B All three products
A:
Q: Omar has heard from some of his customers that they will probably cut back on order sizes in the…
A: Ans 4: Business forecasts help every stakeholder of the organization have a sensation or perception…
Q: t in dollars per month? What is the expected number of meals each day if
A: Given, Fixed cost = $1,800 Fixed cost for entertainment = $2,000 Therefore, the total fixed cost =…
Q: A bank manager notices that by the time customers get to the teller,they seem irritated and…
A: Customer- A person or organization that buys products or services from another organization is…
Q: Sarah Smith is the marketing manager for Activa. She decides to run a sales promotion to boost the…
A: The promotion lift is indicated as the percentage increase in the sales during the given promotional…
Q: States of Nature Alternatives Very Favorable Market Average Market Unfavorable Market Build new…
A: Maximax Criteria is the decision-making criteria in which an optimistic decision is taken where…
Q: Company XYZ produces and sells two types of calculators: Basic and Scientific. The Basic has a lower…
A: Contribution Margin: It is defined as the difference between revenues and variable costs.…
Q: e Petit Fleur is a French style bakery that specializes in creating gourmet pastries, cakes and…
A: a) In this particular case, Le Petit Fleur forgot to remove the banner and this had created…
Q: The company uses the additive model and seasonal variations as follows: SV Q1 -18 Q2 2 Q3 30 Q4 -14…
A: Given data is
Q: The owner of Catamount Ice Cream needs to decide which size shop to rent in a new strip mall. He…
A: Given, Size of the shop Profit of ice cream (low demand) profit of ice cream ( High demand)…
Q: The supply chain manager seeks a better way to forecast the demand for door hinges and believes…
A: The regression equation can be formed using excel as follows: Step 1: Put the data onto the…
Q: An airline decided to offer direct service from City A to City B. Management must decide between a…
A: Thank you for posting the question,As per our guidelines we will be answering the first 3 sub parts…
Q: Camille forecasts to sell 575 units of the perfume she is selling by the first week of December. At…
A: It is very clear from the given question that 500 units was sold and out of which 20 units is the…
Q: Based on a sample of 80 recent MBA graduates (40 male and 40 female), the following information was…
A: a) Mean Salary within 10,000 means within 40000/4 = σ/4 = 0.25σ Lets assume the Standard normal…
Q: The Pert Mustang
A: Given data, Cost (Telephone calls and labor) = $1001) Cost = $2.100Time = 30days 2) Cost = $800Time…
Q: Draw a decision tree for Mr. Sakala indicating all choices and events What decision Mr. Sakala…
A: Below is the solution-
Q: Digital Controls, Inc. (DCI), manufactures tvo models of a radar gun used by police to monitor the…
A: Range is the imit for which the optimal solution stays same and does not change unless the values go…
Q: In what management practice control sheets would be least likely used? Feasibility analysis…
A: The Management is bound in with getting sorted out people and processes in a way that assists the…
Q: Mr. Rashid is a farmer. He grows a variety of vegetables. He also runs a vegetable shop where he…
A: Farmer- The term farmer refers to the person who mainly deals with cultivation of crops. Retailer –…
Q: What Jay think Catalina’s legal practice of targeting shoppers based on past buying behaviors is…
A: A concept of marketing goods and services not only for the welfare of the customer but also for the…
Q: Well water inc. wants to produce and sell a new flavored water in order to penetrate the market,…
A: The target value or cost is the overall value whereas eliminating a specific share or % of the…
Q: 1. Explain whether Catalina’s approach to storing customer buyer information and using it to target…
A: Every business that collects and uses the information of customers should and must inform their…
Q: . A furniture company makes two products: book shelves selling for ₱5,000 and cabinets selling for…
A: Profit from book shelves = 5000-3000 = 2000 Profit from Cabinets = 8000 - 4000 = 4000 LP model…
Q: Joseph owns a medium sized business that has been increasingly successful over the past several…
A: INTRODUCTION: A pension plan is an investment strategy for retirement that offers benefits to…
Q: The following table gives the number of pints of type A blood used at Damascus Hospital in the past…
A: C) Exponential smoothing method of forecasting; F(t+1) = Ft + Alpha*(At-Ft)
Q: Myrtle Air Express decided to offer direct service from Cleveland to Mrytle Beach. Management must…
A: The type of service to be provided is the decision that need to be made. The chance event is the…
Q: Sunblessed Juice Company sells bags of oranges and cartons of orange juice. Sunblessed grades…
A: Revenue and variable cost: Grades of oranges that are available: least average quality that is…
Q: 2. MULTIPRODUCT BREAK-EVEN ANALYSIS The finance manager of Jolimac Fastfood, Inc., wants to…
A: Given, Fixed cost = $2,850 chicken mojoy cheese burger french fries ice tea Canned tuna…
Q: The state-of-nature probabilities are P(S₁) = 0.35, P(S₂) = 0.35, and P(S3) = 0.30. a. Use a…
A: A decision tree is a diagram that shows all of the possible outcomes of a decision and the…
Q: A shop will decide to sell either product A or B or C in the coming season. Demand in that season…
A: Given data is
Q: John is interested in finding a ute car. Below is the summary of his criteria and the choices that…
A: Find the Given details below: Given Details: Criteria Weight Ford Ranger Mitsubishi Triton…
Q: Mike Thatcher is a sales manager for an automobile dealership in Alberta. Mike earns a bonus each…
A: 1. Yes, Mike Thatcher faces an ethical dilemma as a result of the warranty accrual decision because…
Q: As a prospective owner of a club known as the Red Rose, you are interested in determining the…
A: ANSWER IS GIVEN BELOW:
Q: A manager intends to order a new machine and must now decide on the number of spare parts to order…
A: The answer is as below:
Q: Develop a spreadsheet for the question. The vice president of finance has looked at your ooriginal…
A: In the weighted scoring model, different criteria are assigned different relative weights by the…
Q: The supply chain manager seeks a better way to forecast the demand for door hinges and believes…
A: Advertising, X Sales, Y 2.5 264 1.3 116 1.4 165 1.0 101 2.0 209 In…
Q: A brand manager for a certain company must determine how much time to allocate between radio and…
A: Decision Variable: Let, R be the time spent on radio ads T be the time spent on TV ads
Q: Golden Company is in the period of budgeting for 2022. The Sales manager forecasted the number of…
A: Given that: Forecast units to be sold = 30000 units Selling Price = 40 OMR Decrease in Selling Price…
Q: A restaurant wants to forecast its weekly sales. Historical data (in dollars) for 15 weeks are…
A: 1. The mean squared error (MSE) for two periods moving average forecast can be calculated as…
Well Water Inc. wants to produce and sell a new flavored water. In order to penetrate the market, the product will have to sell at $2.00 per 12 oz. bottle. The following data has been collected:
Annual sales 50,000 bottles
Projected selling and administrative costs $8,000
Desired profit $70,000
The target cost per bottle is
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?Stock market analysts are continually looking for reliable predictors of stock prices. Consider the problem of modeling the price per share of electric utility stocks (Y). Two variables thought to influence this stock price are return on average equity (X1) and annual dividend rate (X2). The stock price, returns on equity, and dividend rates on a randomly selected day for 16 electric utility stocks are provided in the file P13_15.xlsx. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Also, interpret the standard error of estimate and the R-square value for these data.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.)
- 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.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.The file P14_01.xlsx contains data on 100 consumers who drink beer. Some of them prefer light beer, and others prefer regular beer. A major beer producer believes that the following variables might be useful in discriminating between these two groups: gender, marital status, annual income level, and age. a. Use logistic regression to classify the consumers on the basis of these explanatory variables. How successful is it? Which variables appear to be most important in the classification? b. Consider a new customer: Male, Married, Income 42,000, Age 47. Use the logistic regression equation to estimate the probability that this customer prefers Regular. How would you classify this person?
- The file P13_19.xlsx contains the weekly sales of a particular brand of paper towels at a supermarket for a one-year period. a. Using a span of 3, forecast the sales of this product for the next 10 weeks with the moving averages method. How well does this method with span 3 forecast the known observations in this series? b. Repeat part a with a span of 10. c. Which of these two spans appears to be more appropriate? Justify your choice.The file P13_27.xlsx contains yearly data on the proportion of Americans under the age of 18 living below the poverty level. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Create a chart of the series with the forecasts superimposed from this optimal smoothing constant. Does it make much of an improvement over the model in part b? d. Write a short report to summarize your results. Considering the chart in part c, would you say the forecasts are good?The file P13_26.xlsx contains the monthly number of airline tickets sold by the CareFree Travel Agency. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Does it make much of an improvement over the model in part b?
- 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.The file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?The following table shows quarterly sales (in thousand units) for a product over 4 years. The overall sales average for the entire 4 years is 126.0625 (thousand units).Fill in the missing values assuming there is no trend.Round seasonal indexes to 4 decimal places.Report Averages accurate to at most 2 decimal places.Report Actual sales ('000) accurate to the nearest integer. Year 1 Year 2 Year 3 Year 4 Average Seasonal Index Quarter 1 92 93 95 106 Quarter 2 105 106 105 101 Quarter 3 197 187 196 1.5211 Quarter 4 106 116 121 0.8865 PART BSuppose actual quarterly sales (in thousands) for Year 5 are 93, 123, 206, and 126 respectively. Assuming there is no trend, forecast sales for the four quarters of Year 5.Use seasonal indexes (rounded to 4 decimal places) from Part A.Report forecast answers as integers accurate to the nearest thousand.Quarter 1 forecast = thousandQuarter 2 forecast = thousandQuarter 3 forecast = thousandQuarter 4 forecast =…