e table below represents the actual demand over the years 2013-2019. Perform 3-year weighted moving average by using these two combinations. W1 = 0.3, w2 = 0.6, w3 = 0.1 - Calculate MAPE variation method. ite formula and show your solution step by step.
Q: a. Suppose that the weekly demand forecast of 95 bags is incorrect and actual demand averages only…
A: Given, Actual demand = 95 bags/ week Annual demand D = 95*50 = 4750 bags Order cost S = $50 Holding…
Q: MGMT Bakehouse Inc supplies bread, cakes and other specialty products, to a large percentage of the…
A: given, There have been complaints that some product lines and/or customers are experiencing high…
Q: If you have a third option for the data in Problem( Your options for shipping $100,000 of machine…
A: a)given,in order to ship $100,000 of machine it will take 30 days at a cost of $3800estimated…
Q: I need a detailed assistance to solve the following problem in: Operations Analysis. 1) A trucking…
A: Step1: Calculating the value of monthly carrying cost per truck. We have,Monthly carrying cost per…
Q: G E D в A Application of weights 1month oder quantity 20 weights the month 0.3 1 2month 0.4 15 2…
A: This is the information given:
Q: 3. Consider the supply chain illustrated below: 1200 600 1150 Manufacturer Wholesaler Retailer 500…
A:
Q: Requlred: 1. Calculate the Blending Department's equivalent units of production for materials and…
A: As per the guidelines of Bartleby, only 2 questions have been answered. For getting answers to the…
Q: Over the past 5 weeks, demand for wine at Winston's Winery has averaged 1,940 bottles, and the…
A: The bullwhip effect refers to the fluctuations caused in demand and supply. These fluctuations can…
Q: c) (i) A company manufactures a component which it sells for £100. The variable cost associated with…
A: (c) (i) Let x be the quantity Selling price = 100 euros Equation = 100*x Fixed cost = 384,000 euros…
Q: Occupancy Percentage ADR (Average Daily Rate) RevPAR (Revenue per Available Room)
A: Below is the solution:-
Q: 43 & 44
A: Determine the seasonality variation in public bank:Public bank would experience the seasonality…
Q: Demand for devil’s food whipped-cream layer cake at a local pastry shop can be approximatedusing a…
A: Mean (M) = 6 per day Cost (C) = $9 per cake Selling price (P) = $12 Salvage value (S) = $9
Q: The Rainwater Brewery produces Rainwater Light Beer, which it stores in barrels in its warehouse and…
A: Economic order quantity (EOQ) EOQ = 2*Sc*DH Sc = Setup cost D = Demand H = Holding cost Annual…
Q: Consider a two-stage plant-retailer supply chain. Lead time for orders is two weeks. Safety stock is…
A: Production planning refers to the module that utilizes the allocate the resource with the materials,…
Q: RevPAR This month Last 3 months Last 12 months
A: Here, we need to learn about various important formula, First, we would calculate the Index value,…
Q: Cindy’s favorite product in the store is the carrot cookie. Healthy Goods started selling carrot…
A: Maximum demand = 204 Minimum demand = 49 Planned stock = 85 Probability of not fulfilling all the…
Q: Suppose the demand for garlic bread falls. Illustrate the effect this has on the market for garlic…
A: An economy is where transaction occurs for profits. Many entity are present in an economy affecting…
Q: Kooyman hardware sells 35 different types of drills. They had demand for 29 of the drills and…
A: Fill rate is the proportion between total demand delivered and total demand of requested. Here, we…
Q: Consider a two-stage plant-retailer supply chain. Lead time for orders is two weeks. Safety stock is…
A: The planning for production as well as manufacturing modules in a firm or industry is known as…
Q: A company has the following actual and forecasted demand history for eight periods: Period Actual 26…
A: Solution Tracking signal is calculated as the ratio of cumulative error divided by the mean absolute…
Q: apolis, makes weekily shipments to area. Each customers order weighs, on average, 2,000 pounds. A…
A: Given, Number of customers = 25 Weight of each order = 2,000 pounds Cost of a direct truck shipment…
Q: Identify several industries that have highly variable demandpatterns. Explore how they adjust…
A: For certain industries, the demand-pattern is extremely uncertain. It becomes highly cumbersome to…
Q: In exponential smoothing method, which one of the following statements is true? O a. Alpha is…
A: Exponential smoothing is a predictable method of time series that can be extended to support data…
Q: PLEASE PROVIDE DETAILED EXPLANATIONS
A: Production is the process of manufacturing the finished products using the raw materials and…
Q: Greenfield's Tannery supplies leather to the South Fork Boot Company on a monthly basis for…
A: From the given data: Here is the excel Formulation for Three month and Five month moving average
Q: Samsung implements a Continuous Inventory System for an electronic component. The inventory manager…
A:
Q: snip
A: Forecasting is a technique that predicts the occurrence of some event in the future. In operations…
Q: Demand for walnut fudge ice cream at the Sweet Cream Dairy can be approximated by a normal…
A: a1. Given Data, Lead time = 2 days Daily Order = 24/7 = 3.428 Gallon Before we apply the reorder…
Q: Consider the supply chain illustrated here:Last year, the retailer's weekly variance of demand was…
A: Note - Hi! Thank you for the question, As per the honour code, we are allowed to answer three…
Q: Sapphire Aerospace operates 52 weeks per year, and its cost of goods sold last year was $6,500,000.…
A: 52 weeks per year COGS = $6,500,000
Q: Calculate a forecast of the above demand using a three-month and a five-month moving average in a…
A: A moving average refers to a calculation for analyzing the data through the creation of average…
Q: Togo makes riding lawn mowers and tractors. The company's expected quarterly demand is given below…
A: Given- Production cost per unit = $210Inventory carrying cost = $30Hiring cost per worker =…
Q: Greenfield’s Tannery supplies leather to the South Fork Boot Company on a monthly basis for…
A: Find the Given details below: Given Details: Month Demand (in square yards) January 1300…
Q: Director of legal services of ABC Company must decide whether to hire another full-time lawyer or to…
A: Given data is
Q: Knights Ltd Wayne tells you he is planning the 30 June 2021 Audit of Knights Ltd, a company that…
A: Below will be the business risk effects for Knights Ltd: There will be an effect of financial risk…
Q: The following lots of a particular commodity were available for sale during the year Beginning…
A: Calculation of cost of goods available for sale Date Units Unit cost Total cost Beginning…
Q: 1) Assume that you are a manager of one of the hotels in the UAE. As you know, UAE has an excellent…
A: 1) Demand for room in Hotels increases in UAE in a specific period of time and then decreases once…
Q: A firm’s cost of goods sold last year was $3,410,000, and the firm operates 52 weeks per year. It…
A: COGS = 3,410,000 52 weeks per year
Q: Demand of Hairdryer from January to July Month Demand January 2800 February 2870 March…
A: a) 3 months simple moving average Given data: Month Demand 3 months simple moving average…
Q: Consider that a company produces a certain component in batches of 795 units (Q) for its computer…
A: Batch Size (Q) = 795 units Production rate = P = 13,655 units / year The rest of the data is…
Q: Elite Distributor magazine is currently working on determining the number of publications they…
A: From the question, I would determine how many magazines are to be printed before the trade show,…
Q: Last year, the retailer's weekly variance of demand was 100 units. The variance of orders was 250,…
A: Bullwhip effect: Bullwhip effect is known as a distribution problem where forecasts used to cause…
Q: Consider the supply chain illustrated below: Last year, the retailer’s weekly variance of demand…
A: "Since you have posted a question with multiple sub-parts, we will solve the first three sub-parts…
Q: Manufacturer Distributor Wholesaler Retailer Last year the retailer's weekly variance of demand was…
A: Given, Demand - 210 units Variance order- 470,610,770,1300 units.
Q: As manager of the St. Cloud Theatre Company, you have decided that concession sales will support…
A: We know that, Contribution margin pu = SP per unit – VC per unit – Waste allowance per unit Assuming…
Q: A firm’s cost of goods sold last year was $3,410,000, and the firm operates 52 weeks per year. It…
A:
please try to provide solution in 30 min
Step by step
Solved in 2 steps with 2 images
- 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.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.
- A manager uses this equation to predict demand for landscaping services: Ft = 14 + 4t. Over the past eight periods, demand has been as follows: Period, t: 1 2 3 4 5 6 7 8 Demand: 20 25 25 35 35 40 45 50 Compute the tracking signals for Periods 1-8. (Negative values should be indicated by a minus sign. Round your intermediate calculations and final answers to 3 decimal places.) Period t Tracking Signal 1 2 3 4 5 6 7 8North Dakota Electric Company estimates its demand trend line (in millions of kilowatt hours) to be: D = 77.0 +0.43Q, where Q refers to the sequential quarter number and Q = 1 for winter of Year 1. In addition, the multiplicative seasonal factors are as follows: Quarter Winter Spring Summer Fall In year 26 (quarters 101-104), the energy use for each of the quarters beginning with winter is (round your response to one decimal place): Quarter Winter Factor (Index) 0.80 1.20 1.40 0.60 Spring Summer Fall Energy UseNorth Dakota Electric Company estimates its demand trend line (in millions of kilowatt hours) to be: D = 80.0 + 0.43Q, where Q refers to the sequential quarter number and Q = 1 for winter of Year 1. In addition, the multiplicative seasonal factors are as follows: Quarter Factor (Index) Winter 0.80 Spring 1.25 Summer 1.45 Fall 0.50 In year 26 (quarters 101-104), the energy use for each of the quarters beginning with winter is (round your response to one decimal place): Quarter Energy Use Winter 98.798.7 Spring nothing
- North Dakota Electric Company estimates its demand trend line (in millions of kilowatt hours) to be: D = 80.0 + 0.43Q, where Q refers to the sequential quarter number and Q = 1 for winter of Year 1. In addition, the multiplicative seasonal factors are as follows: Quarter Factor (Index) Winter 0.80 Spring 1.25 Summer 1.45 Fall 0.50 In year 26 (quarters 101-104), the energy use for each of the quarters beginning with winter is (round your response to one decimal place):North Dakota Electric Company estimates its demand trend line (in millions of kilowatt hours) to be: D = 80.0 + 0.50Q, where Q refers to the sequential quarter number and Q = 1 for winter of Year 1. In addition, the multiplicative seasonal factors are as follows: Quarter Factor (Index) Winter 0.80 Spring 1.25 Summer 1.50 Fall 0.45 In year 26 (quarters 101-104), the energy use for each of the quarters beginning with winter is (round your response to one decimal place): Quarter Energy Use Winter Spring Summer FallA manager uses this equation to predict demand for landscaping services: Ft= 10 + 5t Over the past eight periods, demand has been as follows: Period, t: 1 Demand: 15 2 21 Period, t Tracking signal 1 2 3 4 5 6 7 8 3 23 30 5 32 6 38 42 Click here for the Excel Data File Compute the tracking signals for Periods 1-8. (Negative values should be indicated by a minus sign. Round your intermediate calculations and final answers to 3 decimal places.) 8 47
- A newsvendor keeps careful records of the number of papers he sells each day and thevarious costs that are relevant to his decision regarding the optimal number of newspapers to purchase. For what reason might his results be inaccurate? What would heneed to do in order to accurately measure the daily demand for newspapers?Fresh Food has recently carried out a survey of the demand for their seasonal fruits. They observed the followingoutcomes over the last seven months:QuantitySold Price Advertising8500 $ 2 $ 2,8004700 $ 5 $ 2005800 $ 3 $ 4007400 $ 2 $ 5006200 $ 5 $ 3,2007300 $ 3 $ 1,8005600 $ 4 $ 900Regression (Equation)QSold = 8536.213882 - 835.7223514 Price + 0.592228496 AdvertisingA. 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 derivein terms of revenues and profits?A careful analysis of the cost of operating an automobile was conducted by accounting manager Dia Bandaly. The following model was developed: y = 3,600+ 0.16x, where y is the annual cost and x is the miles driven. a) If the car is driven 15,000 miles this year, the forecasted cost of operating this automobile = $ b) If the car is driven 26,000 miles this year, the forecasted cost of operating this automobile = $ (enter your response as a whole number). (enter your response as a whole number).