construction going on in the assumptions for future on past O The Davidson Company sells lumber and wants to decide how much inventory it will need over the next year. There is a significant amount of new community. To assess the need for lumber, The Davidson Company looked at the data for lumber sales over the past several years and based his Odata. This example shows that it's always a risky to predict growth, but a smart technique is to OO a gather data on the income level of the targeted segment Ob obtain sales data in the industry for several years and draw a conclusion through a moving average Ocuse the census data to see household trends Od obtain data on the age of potential home buyers
Q: Define brand and what are the essentials of a good brand name ?
A: What Is a Brand? The term brand give to a business and marketing term that helps individual identify…
Q: Based on a retail store that sells clothing for the age between 8 and 40 years . Construct a…
A: Like any other item, Clothing also has its fashion life cycle. Fashions are temporary recurring…
Q: our own words write a clear Online Value Proposition for Zara
A: Company will create value for customers and get profits in return. This profit provides growing…
Q: Use the attached image to answer the following question. Audi relies heavily on, ‘Home Country as…
A: Audi, a German automotive car manufacturing company headquartered in Ingolstadt, Bavaria, Germany.…
Q: how do marketers use data from consumer activities on social media to influence purchase behavior?
A: Social media occupies an important position as a communication tool. People all over the world use…
Q: Comprehensively analyse Porter’s Generic Strategies and for each generic strategy,provide detailed…
A: Porter’s Generic Strategies are the standard common strategies that a Business can implement. These…
Q: What is trade? Explain the importance of international trade? Is the Philippine government have a…
A: Trade The movement of commodities and goods from one individual or organization to another,…
Q: Explain the marketing mix(4 Ps) that is being used in the advertisement
A: The marketing mix elements if properly utilized assist in facing competition, promoting sales, and…
Q: what concerns exust whenever personally identifable informationvor other setsitive information is…
A: Consumers get to see a lot of product recommendations when browsing the internet. On the basis of…
Q: For the assignment purposes, students are required to develop a comprehensive business plan that…
A: A business plan can be indicated as a document that contains the details regarding the core…
Q: What are techniques of conducting after sales service in marketing?
A: After-sales support or after-sales service can be referred to as the assistance or services that a…
Q: If a sale staff is found not verbally disclosed specific features and materials risks of a high…
A: Introduction: It is very important for the company to communicate both the features and risks of…
Q: You have been informed by the management of Falls Church General Hospital of their intention to…
A: Service quality is basically seen as the service distribution system's output, typically in terms of…
Q: Analyse how interrelationships are defined by the structure of the organisation
A: In order for an organization to function smoothly, it is essential to maintain good relations among…
Q: Explain the concept of customer value
A: Value-based pricing is the type of pricing that is used by companies to set prices of a product or…
Q: What risks do you think McDonald’s will face in the future?
A: One of the largest franchises in the world and the United States is McDonald's fast food…
Q: Market Research Introduction about Analysis of Social Media marketing to increase brand awareness
A: Introduction: In order increase brand awareness in the market, doing market research plays a very…
Q: From your personal experience of when You have purchased a computer, describe each step you went…
A: Customer buying behavior - The process depicts the decision-making and actions of customers while…
Q: As a customer, what is most important to you? Brand Value, Product Value, or Relationship Value?…
A: As per the Bartleby Honor code we are not supposed to answer more than 3 questions at a time. Please…
Q: Enumerate the steps involved in product positioning process
A: Product positioning is defined as a process where the marketer identifies the needs of different…
Q: Need details on Amazon (Need all answers) 1. Introduction 2. Factors driving Standardisation 3.…
A: Disclaimer: Since you have posted a question with multiple sub-parts, so we will solve first three…
Q: (IT) sophistication within the Financial Service Industry has alienated customers and created…
A: The availability of ready data, low-cost storage capacity, and strong methods for extracting…
Q: A company has approached you for advice due to problems experienced while attempting to convince…
A: Sales Force Automation (SFA) A sales force automation system is intended to build a turmoil process…
Q: commercial approach to product development includes the process of taking a new financial product or…
A: Every company will create value for customers in terms of products and services. Customer will have…
Q: Provide at least two (2) examples/case studies of international strategies of multinational…
A: Walmart success in China: Through the implementation of the foreign market expansion plan, Wal-Mart…
Q: Based on the international strategies discussed in the course which strategy could Audi use to…
A: Please find the answer below. CUSTOMERS: An individual or business that purchases goods or…
Q: Audi relies heavily on, ‘Home Country as Largest Production Country’. Discuss the benefits and risks…
A: Audi is a German automobile brand which has production facility in nine locations. Comfort, class…
Q: Based on the international strategies, discuss which strategy could Audi use to attract customers in…
A: Audi stands for Audi AG Aktiengesellschaft, is a German luxury automobile manufacturer. With nine…
Q: Prepare the sales dialogue Brenda might employ to use as an example and an anecdote to communicate…
A: Disclaimer: Since you have posted a question with multiple sub-parts, so we will solve first three…
Q: Explain introduction to 'Asnaf' entrepreneurs in Malaysia.
A: Disclaimer: Since you have asked multiple question, so we will solve the first question for you. If…
Q: Please pick an industry and find out a trend within that industry and discuss what the trend is and…
A: To answer this question we have chosen fashion industry for the reference and we would try our best…
Q: Candace is planning to open a business disposing of dangerous hospital waste. She has contacted…
A: Introduction:- Hospital waste include those waste which are related to Hospital patients, waste of…
Q: In case, you were hired by a well-known marketing Agency, if your boss ask you to write a plan in…
A: A plan is a step by step guide to solve all the challenges in the path and achieve the desired…
Q: how McDonalds implements the 5 performance objectives
A: Performance Objective An individual is required to complete or produce a performance target, which…
Q: How consumer behaviour contributes to the marketing mix?
A: Consumer behavior is the study of customers and the processes they go through to choose, use…
Q: List the techniques of studying buying motives .
A: Introduction Studying the buying motive helps your organisation as you don’t waste money on…
Q: eeting today with the office manager at the law firm Abercrombie and Wilson (A&W). A&W is a la ve…
A: Customer is a person who will take part in the exchange with the company. Different customers will…
Q: Market for a portable fan: Which group of consumers is the product targeted
A: Marketing is the primary activity of any company along with production. Marketing consists of many…
Q: EveryDay Co. is a 24-hours grocery chain operated by you and other 2 partners. It is said that after…
A: Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…
Q: s dialogue Brenda might employ to use as an example and an anecdote to communi y of NCC copiers to…
A: A sales personal is the person who will communicate with individual customer to create an exchange…
Q: Discuss how can Zara use its subscriber data access for email marketing to its advantage for the…
A: Customer acquisition is the process to gain new customer for your product. Companies will use…
Q: seller can reach an agreement, and explain why each issue might be important to the buyer or seller.…
A: Business is a legal entity created under law. It has its own rights and responsibilities as any…
Q: According to this unit, asking a customer what they are willing to pay tells you which of the…
A: Price is the monetary value of the product or service set by the company. It helps the company to…
Q: can help Make advertising more informative and less predatory
A: Marketing helps the company to create customers while production helps to create products and…
Q: When would a good marketing researcher use closed-ended versus open-ended questions? Justify your…
A: Researches the method to create hypothesis and carry out experience in the real world to understand…
Q: Describe how each strategy differs between introduction, growth, maturity, and decline.
A: Product Introduction: In this stage, product will be introduced or launched in the market. The…
Q: What is the importance of buying motive ?
A: Please find the answer below. BUYING MOTIVE: A buyer's purchasing motivations are the forces that…
Q: You have been appointed as a claims underwriter responsible for settlement of losses with clients.…
A: Ans 1. Risk Risk denotes future uncertainty regarding divergence from projected profits or outcome.…
Q: Name the 3 main environments in marketing, 1bWhich one do you have the most control over 1cWhich one…
A: The marketing environment refers to the forces that drive the customer relationship and marketing…
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
- The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?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 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?
- The file P13_21.xlsx contains the weekly sales of rakes at a hardware store for a two-year period. Use the moving averages method, with spans of your choice, to forecast sales for the next 30 weeks. Does this method appear to track sales well? If not, what might be the reason?The file P13_20.xlsx contains the monthly sales of iPod cases at an electronics store for a two-year period. Use the moving averages method, with spans of your choice, to forecast sales for the next six months. Does this method appear to track sales well? If not, what might be the reason?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_02.xlsx contains five years of monthly data on sales (number of units sold) for a particular company. The company suspects that except for random noise, its sales are growing by a constant percentage each month and will continue to do so for at least the near future. a. Explain briefly whether the plot of the series visually supports the companys suspicion. b. By what percentage are sales increasing each month? c. What is the MAPE for the forecast model in part b? In words, what does it measure? Considering its magnitude, does the model seem to be doing a good job? d. In words, how does the model make forecasts for future months? Specifically, given the forecast value for the last month in the data set, what simple arithmetic could you use to obtain forecasts for the next few months?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.To better plan for future growth of the restaurant, Karen needs to develop a system that will enable her to forecast food and beverage sales by month for up to one year in advance. Table shows the value of food and beverage sales ($1000s) for the first three years of operation. Food and Beverage Sales for the Vintage Restaurant ($1000s) Month First Year Second Year Third Year January 242 263 282 February 235 238 255 March 232 247 265 April 178 193 205 May 184 193 210 June 140 149 160 July 145 157 166 August 152 161 174 September 110 122 126 October 130 130 148 November 152 167 173 December 206 230 235 Managerial Report Perform an analysis of the sales data for the Vintage Restaurant. Prepare a report for Karen that summarizes your findings, forecasts, and recommendations. Include the following: A time series plot. Comment on the underlying pattern in the time series.…
- Engage: Inventory Planning: Forecasting during Uncertainty Inventory Planning: Forecasting During Uncertainty COVID-19 has unleashed unprecedented consumer demand and exposed fractures in the just-in-time supply chain model. In the span of just a few months, your supply chain may have changed drastically. Supplier shutdowns in China. Increased shipping demands. Decreased working capital. These evolving conditions impact your go-forward inventory strategy. Forecasting inventory requirements have always included a mix of past trends, sound predictions, and supplier relationships. But the uncertainties we are facing right now make this process more challenging. This includes Evolving consumer demands Product availability, and Predictable transportation Let's look at these inputs and how they may impact inventory planning. Uncertainties in Consumer Demand Consumer demand is on a roller coaster and the ride doesn’t seem to be slowing down soon. Shelter at home requirements have led…Engage: Inventory Planning: Forecasting during Uncertainty Inventory Planning: Forecasting During Uncertainty COVID-19 has unleashed unprecedented consumer demand and exposed fractures in the just-in-time supply chain model. In the span of just a few months, your supply chain may have changed drastically. Supplier shutdowns in China. Increased shipping demands. Decreased working capital. These evolving conditions impact your go-forward inventory strategy. Forecasting inventory requirements have always included a mix of past trends, sound predictions, and supplier relationships. But the uncertainties we are facing right now make this process more challenging. This includes Evolving consumer demands Product availability, and Predictable transportation Let's look at these inputs and how they may impact inventory planning. Uncertainties in Consumer Demand Consumer demand is on a roller coaster and the ride doesn’t seem to be slowing down soon. Shelter at home requirements have led…Use Excel to make calculations Given the following sales data: Quarter Year 1 Year 2 1 120 150 2 160 200 3 210 250 4 130 170 Compute the seasonal index for each quarter and forecast quarterly demand for year 3 with a projected annual demand of 1000. The efficiency of a production unit is 70 percent. The unit produces an average of 100 products per day. Determine the effective capacity of the unit. The utilization of a machine is 60 percent. The machine has a design capacity of 150 units per hour and an effective capacity of 100 units per hour. Find the efficiency of the machine. FloorsRUs is considering new locations for its manufacturing plants. Costs for constructing a new facility in Huntsville are $1,100,000 and the company estimates that for every product from its new line, there would be an additional cost of $3. If the company were to locate in Hays, the new facility would cost $1,800,000 and each product would incur a $2…