October 5 a) Forecast the demand for the week of October 12 using a 3-week moving average. b) Use a 3-week weighted moving average, with weights of.1, .3, and .6, using .6 for the most recent week. Forecast demand for the week of October 12. c) Compute the forecast for the week of October 12 using exponential smoothing with a forecast for August 31 of 360 and a = 2. PX %3D

October 5 a) Forecast the demand for the week of October 12 using a 3-week moving average. b) Use a 3-week weighted moving average, with weights of.1, .3, and .6, using .6 for the most recent week. Forecast demand for the week of October 12. c) Compute the forecast for the week of October 12 using exponential smoothing with a forecast for August 31 of 360 and a = 2. PX %3D

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Jing's Pizza wants to know to whether customers will buy the new Fancy Feijoa pizza. You are the owner's son/daughter and your mum (the owner) knows you have just completed a paper in business analytics. She asks (or tells!) you to come up with a plan to answer her question. Luckily, she has a database of frequent customers in an excel spreadsheet. You go through your notes and decide that you will use clustering and find groups of similar customers in her spreadsheet. 1. Identify the data that might use for customers who will buy the new Pizza. 2. What plan or alternative plan might use to sell the pizza?11:35 AM
A product is produced at three plants and shipped to three warehouses. Plant capacity, warehouse demands and transportation costs per unit are shown in the table. Plant Warehouse A B C Plant Capacity 1 20 16 26 500 2 10 14 8 500 3 12 18 6 400 Warehouse Demands 200 600 600 a) Find an initial feasible solution and calculate the cost for this solution. b) If improvement can be made, make one step improvement to the solution in part a, and calculate the cost for the improved solution.
Thank you
Ana Chavarria, front office manager at The Times Hotel, has completed a yield management seminar at Keystone University and is preparing an argument to adopt this concept at The Times Hotel to present to Margaret Chu, general manager. She begins by com- piling a history of room occupancy and ADRs, which she hopes will reveal areas in which yield management could help. She prepares an electronic spreadsheet that lists rooms sold with corresponding room rates and correlates the data to tourism activities in the area. Ana sends an analysis of revenue realized and revenue potential to Ms. Chu for review prior to their discussion. After reviewing the analysis, Ms. Chu concludes, “This is just another scam; the industry is slow to adopt this,” and disregards the entire report. She knows that occupancy percentage, ADR, and RevPAR are all that you need to be efficient today, so why change? Ana passes Ms. Chu in the lobby, and Ms. Chu indicates her distrust of the yield management concept but…
allons of deionized water from each wholesaler to each distribution center is shown in the following table: Question Viewer a. Which of the following statements regarding setting up the tableau for the optimal solution for this problem is true? B. The sum of supply capacities is greater than the sum of demands, so a dummy distribution center is needed. C. The sum of supply capacities is less than the sum of demands, so a dummy wholesaler is needed. b. What is the total cost of the solution? The optimal cost is $ ((Enter your response rounded to the nearest dollar.)
Please do fast ASAP fast
Please help me with part b
The Tubular Ride Boogie Board Company has manufacturing plants in Tucson, Arizona and Toronto, Ontario. You have been given the job of coordinating distribution of the latest model, the Gladiator, to outlets in Honolulu and Venice Beach. The Tucson plant, when operating at full capacity, can manufacture 620 Gladiator boards per week, while the Toronto plant, beset by labor disputes, can produce only 410 boards per week. The outlet in Honolulu orders 500 Gladiator boards per week, while Venice Beach orders 530 boards per week. Transportation costs are as follows. Tucson to Honolulu: $10 per board; Tucson to Venice Beach: $5 per board. Toronto to Honolulu: $20 per board; Toronto to Venice Beach: $10 per board. (a) Assuming that you wish to fill all orders and ensure full capacity production at both plants, is it possible to meet a total transportation budget of $9,900? O Yes O No If so, how many Gladiator boards are shipped from each manufacturing plant to each distribution outlet? (If…
2.) Your business provides technical support for very complex and specialized machinery used by companies throughout the country, and you currently have support centers at 5 locations. However, due to a poor market, you have been forced to close your centers in Houston and San Diego. You will have to relocate all of your technicians in these two centers to your other three centers in Cleveland, Seattle, and Charlotte. Due to the varying costs of living in each city, and travel and retraining times, the cost for relocating an employee varies depending on where the employee is moving. These costs are given in the following table: To: From: Cleveland Seattle Charlotte $5,000 | $7,000 $7,000 $4,000 $6,000 $8,000 Houston San Diego You currently have 40 employees in Houston and 55 employees in San Diego, which all need to be relocated. Cleveland is able to take in at most 35 relocated employees, Seattle can take in at most 32 employees, and Charlotte is able to take in at most 50 employees.…
Give several examples of manufacturing overhead costs that are likely to be incurred by Haribo in the production of its gummy bears at the US plant.
Moody Corporation uses a job-order costing system with a plantwide predetermined overhead rate based on machine-hours. At the beginning of the year, the company made the following estimates: Machine-hours required to support estimated production 158,000 Fixed manufacturing overhead cost $ 653,000 Variable manufacturing overhead cost per machine-hour $ 4.90 Required: 1. Compute the plantwide predetermined overhead rate. 2. During the year, Job 400 was started and completed. The following information was available with respect to this job: Direct materials $ 380 Direct labor cost $ 220 Machine-hours used 36 Compute the total manufacturing cost assigned to Job 400. 3. If Job 400 includes 50 units, what is the unit product cost for this job? 4. If Moody uses a markup percentage of 110% of its total manufacturing cost, then what selling price per unit would it have established for Job 400?
Morgan Trucking Company operates a special pickup and delivery service between Chicago and six other cities located in a four-state area. When Morgan receives a request for service, it dispatches a truck from Chicago to the city requesting service as soon as possible. With both fast service and minimum travel costs as objectives for Morgan, it is important that the dispatched truck take the shortest route from Chicago to the specified city. Assume that the following network (not drawn to scale) with distances given in miles represents the highway network for this problem. Chicago 1 36 31 21 2 3 9 10 11 21 4 13 Find the shortest-route distance from Chicago to node 6. 6 5 6 16 6 21 7