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

Operations planner Bradley is developing a sales and operations plan that involves back orders. The company’s demand and production rates for the next four periods are as follows
Marketing system provides some useful insights regarding the sales order. Different departments use this information. For instance, the production process uses this information to forecast the expected sale for next month. The production clerk uses this to create an online production schedule. From this schedule, the system automatically prepares weekly online work orders to be used by the production department.The production supervisor assesses the work orders from his terminal and prepares the necessary paper-based move tickets and materials requisitions. Then, the move tickets and two copies of the materials requisitions are distributed to each work centre. Later, work centre employees submit the two copies of the materials requisitions to the warehouse in exchange for materials and sub-assemblies. If additional new materials are needed beyond the standard quantity, the supervisor issues additional materials requisitions. Work centre employees record their work hours on paper-based…
Use the following information for the next 3 questions: A product is to take 30 hours to be delivered to a customer and shipping costs are $2700. If the product is 8 hours or more late, the penalty is $500. Shipping costs decline at a rate of $50 for each additional hour of transit time allowed. 1. What is the optimal delivery time (y) that will minimize costs? - 33.2 hours - 31.2 hours - 32.2 hours - 30.2 hours - 34.2 hours - 35.2 hours 2. If the product is delivered in 34 hours, what is the Taguchi Loss Cost (L)? - $250 - $300 - $80 - $500 - $0 - $125 - $375 3. If the product is delivered in 36 hours, what is the Total Cost (Taguchi Loss Cost plus Process Cost)? - $2,700 - $2,681.25 - $2,400 - $2,396.75 - $2,250.30 - $2,543.50
Please from where do you get the values on part c. thank you
Please answer asap
Kenworth Company uses a job - order costing system. Only three jobs - Job 105, Job 106, and Job 107 - were worked on during November and December. Job 105 was completed on December 10; the other two jobs were still in production on December 31, the end of the company's operating year. Data from the job cost sheets of the three jobs follow: The following additional information is avallable: a. Manufacturing overhead is applled to jobs on the basis of direct labour cost. b. Balances in the inventory accounts at November 30 were as follows: \table[[Raw Materials,], [Work in Process, $40, 600 Required: 1. Prepare 1 accounts for Raw Materials, Work in Process, Finished Goods, and Manufacturing Overhead. Enter the November 30 Inventory balances given above; in the case of Work in Process, compute the November 30 balance and enter it into the Work in Process T-account Raw Materials Beg Bal End. Bal Work in Process Bey Bal End Bal 이 Finished Goods Manufacturing Overhead Beg Bal Beg Bal End…
i have attached me question
If Martha were to add recycling containers inside her store for her customers, this would Multiple Choice probably end up costing her more money and time but could result in less satisfied customers and harm her profitability. probably end up costing her more money and time but could result in more satisfied customers and future profitability. infuriate customers and investors. probably cost less money, but result in more satisfied customers. probably be a waste of time and money since her responsibility is not to become a recycling center.
PLEASE SOLVE IN EXCEL AND SHOW FORMULAS, DO NOT USE SOLVER. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
Assuming the following: Warehouse 1 has outbound goods volume - 2,500 units Warehouse 2 has outbound goods volume - 1,300 units Warehouse 3 has outbound goods volume - 5,000 units Given the assumptions and grid coordinates above, the following: d1x= 200, d2x= 300, d3x= 100, d1y= 50, d2y= 100, d3y= 150 And V1= 2,500, V2= 1,300, V3= 5,000 Which is equal to: Cx= (200 x 2,500) + (300 x 1,300) + (100 x 5,000) / (2,500 + 1,300 + 5,000) = 158 Cy= (50 x 2,500) + (100 x 1,300) + (150 x 5,000) / (2,500 + 1,300 + 5,000) = 114 Use the numerical example set up above to demonstrate how the centre of gravity location technique is used.
Solve the problem
Market Company’s policy is to have 30% of the next month's sales on hand at the end of the current month. Projected sales for August, September, and October are 26,000 units, 21,000 units, and 31,000 units, respectively. How many units must be purchased in September?