Please solve exact, acurate with complete details follows:The monthly sales for Yazici Batteries, Inc., were asMONTHJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberSALES202115141316171820202123a) Plot the monthly sales data.b) Forecast January sales using each of the following:i) Naive method.ii) A 3-month moving average.iii) A 6-month weighted average using .1, .1, .1, .2, .2, and .3,with the heaviest weights applied to the most recent months.iv) Exponential smoothing using an a = .3 and a Septemberforecast of 18.v) A trend projection.c) With the data given, which method would allow you to fore-cast next March's sales? PX

Answered: follows: The monthly sales for Yazici…

follows: The monthly sales for Yazici Batteries, Inc., were as MONTH January February March April May June July August September October November December SALES 20 21 15 14 13 16 17 18 20 20 21 23

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

Can someone please help solve.
What is Linear programming model? * This is a required question What is Linear functions? * What is Feasible region? * What is a Constraint? * What is Nonnegativity constraints? * What is Slack variable? * What is Extreme point? What is Alternative optimal solutions? * What is Infeasibility? *
Currently a company that designs Web sites has five customers in its backlog. The time since the order arrived, processing time, and promised due dates are given in the following table. The customers are ready to be scheduled today, which is the start of day 190. Customer Time Since Order Arrived (days ago) Processing Time (days) Due Date (days from now) Upper AA 6 18 66 Upper BB 3 24 58 Upper CC 2 32 100 Upper DD 10 22 26 Upper EE 8 12 50 a. Develop separate schedules by using the FCFS and EDD rules. Compare the schedules on the basis of average flow time and average days past due. Part 2 Using the FCFS (first come, first served) decision rule for sequencing the customers, the order is: Sequence 1 2 3 4 5 Customer D E A B C Part 3 Using…
mestion Completion Status: The Hilton Hotel at Dallas has 100 total rooms available for Dec 31. There are two types of customers, business customers and leisure customers. Hilton charges a high rate of $300/night and a low rate of $120/night. High-rate guests do not need pre-booking and has time flexibilities; low-rate guests need pre booking. Assume businesSS customers always take the high rate option and leisure customers always take the low rate option. Leisure customers always book far earlier before business customers and there are. sufficient leisure customers. The total number of business customers is uncertain, and its demand distribution for business customers on Dec 31st is given in the following table: Number of business customers Probability 56 0.06 57 0.03 58 0.12 59 014. 60 0.2 61 0.16 62 0.14 63 0. How many rooms should Hilton sell in advance to maximize its revenue? 39 O a. b 40 ard" ヘ a
Problem 14-8 (Algo) What cycle time would match capacity and demand if demand is 162 units a day, there are 2 shift(s) of 447 minutes each, and workers are given four 40 minute breaks during each shift, one of which is for lunch or dinner? (Round your answer to 2 decimal places.) Cycle time minutes per cycle
Fast solve plz
Please do not give solution in image formate thanku.
What are the advantages to finite capacity scheduling?
A commercial facility employs 1,090 people and they are to eat in two equal 45 minute lunch breaks. The employees will use 48" by 48" square tables. The facility management will develop a full kitchen, serving lines, cafeteria, and vending machines for the employees. Answer the following questions and show all work please. The floor area of the cafeteria will be __________________ The number of serving lines will be _____________________ The floor area for the serving lines will be _________________ The floor area for the full kitchen will be ____________________ The floor area for the vending machines will be _______________________ The total floor area required for the full-service food service facility will be __________________
New students who join the university, should visit cer-tain departments in their first day, as part of the registration and induction process. Students are usually allocated to groups of ten,and their visits and their timings are as follows:DEPARTMENT DURATION FOR EACHGROUP (MINUTE)Registration/Finance 60IT 45Library 90Social Club 30Sport Centre 30Student Support Service 45Medical Centre 45Campus Services (banks, restaurant, etc.) 30During the visit, at least one person from the university student support team should be with each team of students. The stu-dent support team has allocated the visit of every two depart-ments to one person as follows: Deborah (Registration and IT), Gemma (Library and Social Club), Frank (Sport Centreand Student support service), and Raj (Medical centre and Campus services). The visits of the departments can be done inany sequence. Based on the current arrangements,a) What is the cycle timeb) What is the throughput per hourc) Total idle time in each…
Draw a schedule for a brief comparison in points between a convenience store and a supermarket in : Front, parking, checkout, shelving
A local toy manufacturer is using a production line that runs 8 hours per day and produces a toy that requires a total of 7 tasks to be performed . The daily demand is 120 toys. Times of the tasks are 2.73,2.01 1, 2.13, 2.0, 2.61, 2.71 , and 2.95 minutes for A ,B,C,D,E,F, , and G, respectively . However, due to the nature of product there are precedence rules that must be observed . Such that Task A does not need any predecessors ; task B requires task be completed. To start task C and task D, each require task B to be completed . Task C must be completed prior to stating task E. Task F needs both task D and task Eto be completed . Finally, task G can start only once task F is completed . What is the minimum number of workstations needed? a. 4 b. 5 c. 6 d. None of them e. 8