A developer has requested your advice for the selling price per sg.m. of flats in an area of your choice. You should retrieve 20 asking prices for residential flats in your preferred area from agents' websites. Proceed with all necessary adjustments and estimate a value per sg m, for a typical 2 bedroom flat that he is aiming to build. Additionally, retrieve asking rental prices for the same area and proceed with the necessary adjustments in order to estimate the ARY. Present your analysis and the way of thinking in 500 words and also support your opinion with an excel table showing your adjustments.
Q: A manufacturing firm has developed a skills test, the scores from which can be used to predict…
A:
Q: Using the trend projection manual method, forecast demand for transmission repairs for periods 11…
A: 1 Mission: We can say that it is called as a general statement of how you will achieve your vision…
Q: In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,200 radials each…
A: A seasonal index is how much amendment is required in a period series to adapt to the period of the…
Q: In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,000 radials each…
A: THE ANSWER IS AS BELOW:
Q: a) b) would have applied the Naïve Model, calculate the Naïve Forecast values for the months of…
A: Answers of all parts is below:-
Q: Problem #1- The table below shows the actual sales of a Product X sold by Compa January to December…
A: This question is related to the topic -Forecasting approach and this topic falls under The…
Q: Some companies import and export flowers worldwide. It is one of the very competitive businesses in…
A: Inco term: Inco terms are set of standards and it regulates the international sales.…
Q: Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the…
A: Given data, Year Sales 1 455 2 510 3 518 4 570 5 590
Q: The Ladies Professional Golf Association (LPGA) maintains data on performance for members of the…
A: Regression analysis can be done using the statistical package SPSS. Steps involved in analysis are :
Q: A manufacturer forecasted demand for year 2014 of 40,000 units of rera products where as the actual…
A: Given: Previous years forecast (Ft-1) = 40,000 Actual years demand (At-1) = 51,000 Alpha = 0.40…
Q: Which are the six major reasons to accept Exponential smoothing techniques?
A: The six major reasons to accept Exponential smoothing techniques are:
Q: a) The 2-month Simple Moving Average (SMA) forecast for Month 6 would be: A. 565 haircuts B.…
A: In simple moving average, we take forecasted values from the previous two, three or four months as…
Q: RDB Company wishes to assign a real estate brokers to one of its 6 sales districts. Based on the…
A: The assignment problem is solved to find out the maximized sales or the minimum cost that the…
Q: 1. Your parents want to invest in the hospitality business . The profits your parents will get will…
A: Note: Since you have posted multiple parts in the same questions, we will be answering the first…
Q: he treasury manager of a chain of clothing stores wants to develop a medium-term forecast.…
A: The certainty equivalent is a certain payment that someone would choose now over risking a greater,…
Q: Data collected on the yearly registration for a Six Sigma seminar at the Quality College are shown…
A: MAD and MAPE for the 4-year moving average, 4-year weighted moving average, and exponential…
Q: Franklin Company makes fine jewelry that it sells to department stores throughout the United States.…
A: Fixed cost will be advertising and depreciation. Bracelet A: Advertising cost per year = 8,800…
Q: What the best suitable model (either you adopt or propose). You will do the following: Suggest a…
A: It is a set of concepts that is the representation of a system. The model helps people understand,…
Q: Write the three-point estimates for the six key input variables?
A: The three-time estimates are: Optimistic estimate (a): It is the minimum amount of time under which…
Q: What are her forecasted sales for year 8 using a 3 year moving average? What are her forecasted…
A: Since you have posted a question with multiple sub-parts, we will solve the first three subparts for…
Q: The lease of Theme Park, Inc., is about to expire. Management must decide whether to renew the lease…
A: Formula: Answer:
Q: Explain the Simple Linear Regression?
A: Forecasting is used to predict future changes or demand patterns. It involves different approaches…
Q: An Amazon marketplace retailer is planning to rent one of the following three storage spaces for…
A: The minimax regret strategy is the one that limits the most extreme regret. It is helpful for a…
Q: Lori Cook has developed the following forecasting model: y = 45.0 + 4.50x, where y = demand for Kool…
A: Given equation for the forecasting model, y=45+4.50×x y= Demand for Kol air conditioners x=the…
Q: Lori Cook has developed the following forecasting model: y = 40.0 + 4.20x, where y = demand for Kool…
A: Y = 40 + 4.20x Where, Y = Demand for Air Conditioners X = Outside temperature
Q: Sales of a particular product (in the thousands of dollars) for the year of 2015 through 2018 have…
A: Serial no. Years Sales Weights Forecast sales(simple four year moving average) Forecast…
Q: What is the five period moving average for 2002_Q2 (round off to one decimals).
A: The answer is as below:
Q: The number of disk drives (in millions) made at a plant in Taiwan during the past 5 years follows:…
A: The forecast of disks to be produced next year can be computed as follows:
Q: The manager of Carpet City outlet needs to make an accurate forecast of demand for Soft Shag Carpet…
A: Find the Given details below: Given details: Month Demand 1 8 2 12 3 7 4 9 5 15 6…
Q: Using multiple regression, you have identified P12,000 of unit level costs for 3,000 units, P1,000…
A: Cost is the total payment or money incurred to produce products and services in an organization.
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: The dean of a school of business is forecasting total student enrollment for this year's summer…
A: For Period t, let the particular enrollment be At and Forecast be Ft For 3 year moving average,-Ft =…
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: , namely when demand will exceed 16000 births
A: Regression is a tool wherever you want to fit a linear trend line and get an equation with minimum…
Q: The number of heart surgeries performed at HeartvilleGeneral Hospital has increased steadily over…
A: Note: - As we can answer up to three subparts, we will answer the first three here. If answers are…
Q: The Charbondale Hospital is considering the purchase of a new ambulance. The decision will rest…
A: Forecast for 2013 = 3799
Q: utensil. The firm has conducted significant market research and estimated the following pattern for…
A: Given, Average cost $50000 Desire cost- $3.50
Q: In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,000 radials each…
A: The forecast is as below
Q: Explain how the analyst will obtain data in a auto repair shop
A: To be determined: how the analyst will obtain data in a auto repair shop
Q: What would be the cost of the loyalty program?
A: The answer is as below:
Q: Below is data of lobster sales volume from a seafood company. We are using exponential smoothing (α…
A: Forecasting is the process of estimating future demands and sales using the previous years of…
Q: Cool Beans is a locally owned coffee shop that competes with two large coffee chains, PlanetEuro and…
A: Specialty coffee drink price = $4.08 Profit Margin = 74% Cost of Printing and distributing of the…
Q: Cool Beans is a locally owned coffee shop that competes with two large coffee chains, PlanetEuro and…
A: Given, Selling price- $4.08 Profit margin-74%
Q: 4. "Family Man," a construction company, is considering whether to bid on a contract for a new…
A: a)
Q: regression analysis to forecast the point at which Swanson needs to “build out” the top two floors…
A: Regression is a tool wherever you want to fit a linear trend line and get an equation with minimum…
Q: What are the advantages as a prediction tool over the moving averages of exponential smoothing?
A: Exponential smoothing is more adaptable than moving midpoints in that changing the assessment of the…
Q: ales from her lemonade stand as a pie chart, tracking how much she sells each day to track the…
A: Gretchen's plan for presenting the sales for her lemonade will not be going to work as: The pie…
Q: The Charbondale Hospital is considering the purchase of a new ambulance. The decision will rest…
A: Error = Actual demand - Forecast Actual of 2012 = 3700 Forecast of 2012 = 3739
Q: KTOC/ Kuwait-Tunis Oil Co. started 4 months ago. KTOC noticed that its production increased…
A: Month Production Weights 1 5 0.2 2 7 0.3 3 20 0.1 4 90 0.4 Forecast production for the…
Q: Explain which data collection method would be the most fitted choice for Bart’s study and justify…
A: Below is the solution:-
Step by step
Solved in 2 steps
- Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?Demand for stereo headphones and MP3 players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for last year was as follows: a. Using linear regression analysis, what would you estimate demand to be for each month next year? (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 2 standard errors of estimate for safety. How many additional units should be held to meet this level of confidence? (Do not round intermediate calculations. Round your answer to the nearest whole number.)
- After plotting demand for four periods, an emergency room manager has concluded that a trend-adjusted exponential smoothing model is appropriate to predict future demand. The initial estimate of trend is based on the net change of 37 for the three periods from 1 to 4, for an average of +12.33 units.Period Actual Period Actual 1 201 6 268 2 238 7 283 3 233 8 293 4 238 9 298 5 258 10Use α=0.50 and β=0.10, and TAF of 250 for period 5. Obtain forecasts for periods 6 through 10.(b) Demand history of five different products of a company is shown below. Products 2012 2013 2014 2015 2016 2017 2018 2019 2020 A 37 40 41 45 49 26 34 30 26 23 33 28 32 C 58 55 32 38 45 56 62 70 77 86 95 83 88 81 92 85 i. Name the methods that is suitable to forecast the demand of the above five products? ii. Forecast demand of the product B or D with error for the year 2021. If you need a value of a then consider it 0.7.In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,200 radials each year. In the past 2 years, 240 and 260, respectively were sold in fall, 350 and 310 in winter, 140 and 165 in spring, and 300 and 635 in summer. With a major expansion planned, Kelle projects sales next year to increase to 1,200 radials. Based on next year's projected sales, what is the demand for summer going to be (enter your responses as whole numbers): 468 250 330 153
- Camille forecasts to sell 575 units of the perfume she is selling by the first week of December. At the end of the 1st week of December, she was able to disposed 500 perfumes at Php150 each. Of these 500 units, she gave a total of 20 giveaways. The total cost for each perfume is Php120. Determine Camille’s net sales volume. * a. 75 b. 480 c. 500 d. 20 2. The amount of your product that you will need to produce and sell to cover total costs of production. * a. Break even sales volume b. Sales volume percentage c. Sales volumeHistorical demand for a product is as follows: DEMAND April 75 May 60 June 90 July 75 August 95 September 88 Using a simple four-month moving average, calculate a forecast for October. Note: Round your answer to 2 decimal places. Using single exponential smoothing with α = 0.10 and a September forecast = 80, calculate a forecast for October. Note: Round your answer to 2 decimal places.Forecast deliveries for one of Cadbury Schweppes' subsidiaries for period 10 using the exponential smoothing with trend adjustment method. Let the beginning trend value be 4 and the initial prediction be 200, and set alpha and beta to 0.4 and 0.2, respectively. Period 01 = Actual Demand 200 Period 02 = Actual Demand 212 Period 03 = Actual Demand 214 Period 04 = Actual Demand 222 Period 05 = Actual Demand 236 Period 06 = Actual Demand 221 Period 07 = Actual Demand 240 Period 08 = Actual Demand 244 Period 09 = Actual Demand 250 Period 10 = Actual Demand 266
- 3. A toy manufacturer makes stuffed kittens and puppies which have relatively lifelike motions. There are three different mechanisms that can be installed in these "pets." These toys will sell for the same price regardless of the mechanism installed, but each mechanism has its own variable cost and setup cost. Profit, therefore, is dependent upon the choice of mechanism and upon the level of demand. The manufacturer has in hand a forecast of demand that suggests a 0.2 probability of light demand, a 0.45 probability of moderate demand, and a probability of 0.35 of heavy demand. Payoffs for each mechanism-demand combination appear in the table below. Wind-up action Pneumatic action Electronic action Demand Light Moderate $250,000 $90,000 -$100,000 400,000 440,000 400,000 Heavy 650,000 740,000 780,000 Construct the appropriate decision tree to analyze this problem. Use standard symbols for the tree. Analyze the tree to select the optimal decision for the manufacturer.Lenovo uses the ZX-81 chip in some of its laptopcomputers. The prices for the chip during the past 12 monthswere as follows: a) Use a 2-month moving average on all the data and plot theaverages and the prices.b) Use a 3-month moving average and add the 3-month plot tothe graph created in part (a).c) Which is better (using the mean absolute deviation): the2-month average or the 3-month average?d) Compute the forecasts for each month using exponentialsmoothing, with an initial forecast for January of $1.80. Use a= .1, then a = .3, and finally a = .5. Using MAD, which ais the best?Historical demand for a product is DEMAND January 12 February 11 March 15 April 12 May 16 June 15 Using simple linear regression analysis, calculate the regression equation for the preceding demand data. Note: Round your intercept value to 1 decimal place and slope value to 2 decimal places. Using the regression equation in d, calculate the forecast for July. Note: Round your answer to 1 decimal place.