4. Natural gas usageMonth Period Gas Usage OJan1242Feb2230Mar3156AprMay14255Jun6.34Jul731AugSepOctNov8.2792810411190Dec1213197Jan232Feb1423915161718Mar247AprMayJun1323332Jul1927AugSepOct202721272239Nov2388Dec24186PrintDone The accompanying dataset provides data on the monthly usage of natural gas (in millions of cubic feet) for a certain region over two years. Implement theHolt-Winters multiplicative seasonality model with no trend to find the forecast for periods 13-26, where a = 0.6 and y = 0.8. Then find the MAD for periods 13-24.Click the icon to view the monthly use of natural gas data.Use the Holt-Winters multiplicative seasonality model with no trend to find the forecast for periods 13-18, periods 19-24, and then for periods 25 and 26.(Type integers or decimals rounded to two decimal places as needed.)PeriodForecast131415161718

Given data is Alpha = 0.6 Gamma = 0.8

Answered: The accompanying dataset provides data…

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

Termination from a job is an unpleasant experience which most employees have to go through at some point during their professional career. Getting terminated from the job may have psychological, professional and financial consequences on the employees. Suppose as an MBA student, you decide to investigate the experience of termination from job of employees working in the banking sector as part of your thesis research. Plan a qualitative study to investigate banking sector employee’s experience of termination from job by answering the following questions: Q.3 What steps will you take before, during and after this study to comply with research ethics? Write at least 7 steps.
please explain the 4 types of business research with examples a) exploratory b) descriptive c) analytical d) predictive Please provide a unique answer of your own
QUESTION 3a. Delightful Coffee Limited (DCLL) purchases coffee from Hopeful Harvest Plantations (HHP)in Santa Cruz, Trinidad. HHP sells coffee at four (4) different prices, depending on the size ofthe order, as shown in Table 3 (below):Table 3. Hopeful Harvest Plantations - Coffee pricesWeight of Coffee Price ($USD)Less than 45 kilograms $18 per kilogram45 to 449 kilograms $17 per kilogram,450 to 1000 kilograms $16 per kilogramMore than 1000 kilograms $15 per kilogramThe cost to place an order at DCLL is $50. Annual demand is 4,500 units. The holding (orcarrying) cost is 20 percent of the material price. (iii) What is the economic order quantity that DCLL should buy each time? Please answer the above question
Q.2.2 Compare and contrast between the grassroots forecasting technique and the Delphi method. Q.2.2 Explain integrated service providers in logistics management. Q.2.3 Explain how distribution requirements planning (DRP) is used. Q.2.4 An organisation produces customised wooden furniture. In your opinion, can the organisation utilise triple bottom line (3BL) to improve its production of wooden furniture? Justify your answer by discussing at least 3 key points.
A candy company has 144 kg of chocolate-covered nuts and 78 kg of chocolate-covered raisins to be sold as two 3 different mixes. One mix will contain half nuts and half raisins and will sell for $7 per kg. The other mix will contain 4 nuts and raisins and will sell for $9.50 per kg. Complete parts a. and b. 1 4 (a) How many kilograms of each mix should the company prepare for the maximum revenue? Find the maximum revenue. The company should prepare kg of the first mix and kg of the second mix for a maximum revenue of $
D & R A1 10 - 6 Question 10. Minimum Variance Commodity Hedge Choc Full of Good Inc., a producer of powdered hot chocolate, has just received a large order that will require the purchase of 800 metric tons of cocoa in 3 months. The current spot price of cocoa is US $3,055 per metric ton. The standard deviation of the change in spot cocoa price is 0.2. Mr. Dulce, the CFO of Choc Full, is considering a minimum-variance hedge of this future cocoa purchase using the three-month cocoa futures contract. The contract size is 10 metric tons. The standard deviation of the change in cocoa futures price is 0.25. The covariance between the change in the spot and futures cocoa price is 0.035. The annually compounded interest rate faced by the company is 5%, the three-month storage cost is $2.5 per metric ton, and the convenience yield is $0.5 per metric ton. What is the estimated effectiveness of this minimum variance hedge?
Question 10.6 Storage Limited operates a 50-week working year. It produces a product called "GENERAL' for which demand any week in the year is described by the probability distribution below: Demand 2 3 4. 7 8. 9 Probability 0.07 0.10 0.11 0.13 0.15 0.17 0.13 0.08 0.04 0.02 Demand can only be satisfied (if at all) from stocks. The stockholding costs are N4 per item per year. Fixed costs per re-order are N16 and the variable, re-order costs are N30 per unit Lead time is one week. The costs of being out of stock are N12 per unit short. You are required to calculate: (i) The average weekly demand; [i] The Economic Order Quantity; [iv] The number of ordering cycles in the year; and [v] State briefly the main reason for holding inventory, and explain why good inventory management is a very important aspect of overall company management. [ii The average annual demand;
Q1. Dallas Mavericks’ owner Mark Cuban proved his business intelligence once again with the acquisition of star player Kristaps Porzingis. To benefit from this blockbuster trade even further, Cuban plans to sell one-time-only special edition Porzingis jerseys at a price of $380 each during the first month of the season (i.e., during October 2019 only). The production cost for each of these jerseys would be $100 thanks to their golden details, and any unsold jersey during October will be sold for $80 during November 2019. Knowing the fan base for years, Cuban estimates demand for these special edition jerseys to follow a normal distribution with a mean of 10,000 units and a standard deviation of 2,000. partc. Cuban also plans to sell these special edition jerseys in his vacation resort. Knowing that people are wealthier in the resort, he sets a price of $500 for each jersey (although production cost stays the same). This time however, he cannot sell any unsold jerseys outside the…
Q.2 AI Muhannad Industrial and Domestic Services, Oman requires on average 4000 sheets of A4 size papers per day at its different office locations in Muscat. Each time the purchase manager orders centrally the A4 size papers, the total expenses incurred to the company are estimated to be 10.6 OMR per order. Presently the company orders 350 reams of papers per order at a flat rate of 2.1 OMR per ream (one ream contains 500 A4 size papers). It takes almost a day for the local supplier to deliver the order. Considering the overall cost of the inventory and the manpower involved, the annual carrying costs for the company is estimated to be 35% of the cost for each ream of the paper. The company operates on 5 days a week over 46 weeks per year. (i) Is the present purchase policy economical for the company? If not, guide the purchase manager in selecting the best economical policy in terms of expected number of orders annually, ordered quantity per order, reorder point and the expected time…
Subject Name: Simulation & Modelling Q. Describe the following : • Simulation of a Multi-server queueing system • Simulation of an inventory system
Q1. General Appliance Corp. produces refrigerators at three plants: Marietta, Minneapolis and Phoenix. They ship them to major retail outlets in Chicago, Los Angeles and New York City. The accounting, production and marketing departments have provided the following information in the given tables; Plant capacities over the next planning period, retail outlet demand and unit cost of shipping between any plant and retail outlet. The company would like to minimize the cost of their transportation network by identifying how many units to ship between each plant and retail outlet. 1. Formulate this linear optimization problem by clearly listing the decision variables, objective function and constraints. 2. Create a spreadsheet model for this problem and solve it using Solver. What is the minimum cost? Plant Supply Marietta 1200 Minneapolis 800 Phoenix 1600 Retail Outlet Demand Chicago 650 Los Angeles 1450 New York City 1500…
N-2

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS