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

Related questions

Q: 4. XYZ Brownies is a culinary business that specializes in making brownie cakes with various flavors…

A: Find the given details below: Given details Output 18000 Brownies Effective Capacity (Current…

Q: Culinary Creations caters weddings, office parties, and the like. Monica, the owner of Culinary…

A: A one-stop shop that endows your themed dinners and parties with all the necessary culinary…

Q: Pascal James is an avid Toronto sports fan and is invited by his best friend to a Toronto Raptors…

A: The objective of the question is to provide legal advice to Pascal, who has suffered serious…

Q: What are the minimum and maximum cycle times?

A: Cycle times are described as a total amount of time required to complete a process. It includes the…

Q: Solve all

A: Step 1: Step 2: Step 3: Step 4:

Q: Describe the advantages of finite capacity scheduling

A: To be determined: the advantages of finite capacity scheduling

Q: Appendix 1 Passenger Forecasts for the New Gate Area at Newark (To be used for facility and…

A: Forecasting of given data can be done using a seasonal index. Description Mon Tue Wed Thu Fri Sat…

Q: The Company makes TSHIRTS at their facility in chicago and Minnesota. The process involves three…

A: Capacity utilization = (Available time hours / used time hours) x 100 %

Q: Shelves Unlimited is interested in estimating the additional machine center capacities for a new…

A: Ans1.The bookshelf is made up of 2 end panels and 3 shelves.Hence, the number of end panel required…

Q: Instead of using excel, how would we solve this by hand?

A: Linear programming is a mathematical technique that is also used in operations management…

Q: L.P. Model: Maximize Subject to: Z= 8X+6Y 1X+2Y≤8 5X+4Y ≤20 X,Y 20 (C₁) (C₂) On the graph on right,…

A: Given LP- Max Z = 8X + 6YSubject to-X + 2Y≤ 85X + 4Y≤ 20X, Y≥0

Q: Is this a program or a project? Does this fit into the realm of IT projects/Programs? Who are the…

A: Recently, the mayor and director of the library in Somewhere, New Jersey met with the library's…

Q: Refer to Matrix 15.1. What is the cost to ship a 5,000 pound item in freight class 65?

A: supply chain management is manufacturing the goods and services and overseeing what is reached to…

Q: EXPLAIN THE THEORY OF CONSTRAINTS AND THE PROBLEMS ABOUT WHAT TO PRODUCE

A: The theory of constraints is more of a management philosophy that helps in managing the operations…

Q: A local bakery makes custom cakes for special events such as weddings and graduations. Making cakes…

A: The below excel approach to this is that we create two endings of a pipe and then keep assigning…

Q: The Somewhere, NJ library advising board, along with the local mayor and head of the library,…

A: ANSWER : This is a project. Yes, this falls into the realm of IT projects. The stakeholders in this…

Q: How might minimum stays (2 nights, 3 nights) help maximize revenue in a hotel?

A: Revenue management would mean to predict the customer behavior to sell the product at an optimal…

Q: 4.- A real estate agent is considering changing his cell phone plan. There are three plans to choose…

A: Given data is Fixed cost = $20 per month Morning call cost under plan A = $0.45 per min Afternoon…

Question

Please solve exact, acurate with complete details

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
a) 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 September
forecast of 18.
v) A trend projection.
c) With the data given, which method would allow you to fore-
cast next March's sales? PX

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 8 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Can someone please help solve.
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
Please do not give solution in image formate thanku.
Draw a schedule for a brief comparison in points between a convenience store and a supermarket in : Front, parking, checkout, shelving
Minimize Subject to z = 3x + y 3y + 5x > 30 6y + 4x 40 y + x 8 X 0 Y > 0 Solve this using the graphical method. Be sure to clearly show all steps: • Sketch the feasible region ● Determine the corner points Determine the minimum of the objective function ● Upload a picture showing your work here: Choose File No file chosen
3. Eddie Irwin works in the data processing department at the local medical center. He is required to keep a weekly time card. Please fill out the time card Date Out Sun. Mon. Tues. Wed. Thur. Fri. Sat. 12/13 In 12/14 8:15am 12:30pm 12/15 8:35am 12:50pm 12/16 8:15am 12:10pm 1:15pm 8:30am 12 noon 12/17 8:25am In 12:30pm 1:10pm 1:30pm 12:45pm 1:50pm Out 4:30pm 5:10pm 5:00pm 4:20pm 5:30pm Total Hours>>> Hours
Jays Tech Shop has the following repair orders it must complete in the next week (40 hours). The jobs are as follows: Number of Repairs to Repair Type Complete Setup Time/Repair Type (hours) Processing Time/Repair (hours) Laptop Repair 15 2 1.2 Smartphone Repair 20 1 0.8 Tablet Repair 10 1.5 1.1 All repairs of the same type are processed together. Is 40 hours enough capacity? If not, what short-term capacity solution would you recommend?
To determine the scope of a bookkeeping clean-up engagement, you are reviewing the Client Overview tab for a potential client. You notice that there is a large amount in the Opening Balance Equity account. Which 3 reasons could be causing this balance?(Select all that apply) A. The client added transactions in the Banking Center without assigning an account to them B. Opening balance for an inventory item was entered during the setup process C. The client entered an Opening Balance when creating an Other Current Asset account D. Opening balances were included when importing customers using the Import data tool E. The client forced a bank reconciliation when the difference was not zero
Ann Archibald has ambition to be on the County Governing Board. Her staff has determined the breakdown of tasks needed to secure the election. The following network depicts the breakdown. ( see atttached picture ) Her staff also has estimated the normal and crash times and costs for tasks involved in the breakdown. The information is summarized below. The campaign starts on 4/1/2022. Task Time Estimates (Weeks) Cost Estimates ($) Normal Crash Normal Crash A1 6 4 5,000 10,000 B2 3 3 4,000 4,000 C 10 8 4,000 7,000 D 4 2 1,000 2,000 E 2 1 1,000 2,000 F 3 1 4,000 7,600 G 5 4 7,000 12,000 H 7 5 8,000 14,000 I 2 2 1,200 1,200 J 4 3 5,000 5,800 K 8 6 13,000 15,000 L 5 5 6,000 6,000 M 4 4 2,500 2,500 1 Task A can be crashed by 2 weeks at an additional cost of $5000 ($2,500/week). 2 Task B cannot be crashed. Ann has…
b. The Healthy Food Restaurant, a 24-hour restaurant, faces changing requirements from hour tohour. More workers are needed for peak hours, and fewer are needed in between. The followingTable 6 (below) shows the worker requirement for the first 12 hours in the restaurant:Table 6. Staff Requirement at the Healthy Food RestaurantTime Period 10AM11AM12PM1PM2PM3PM4PM5PM6PM7PM8PM9PMRequirement 8 10 12 12 9 7 6 7 9 10 12 8AssignedOn DutyOverstaffed8(i) You are required to apply the first-hour principle to staff each hour with the required number ofcafeteria staff, showing how many staff are on duty each given hour, the number of staffyou have assigned to work each hour and any overstaffing for each hour. i. Schedule the staff to work in 8-hour shifts.