A summary of total charges from a small café's natural gas bills is provided below:MonthKJ CostOctober14 $187November 17187December 30230January35264February 33 27020 200MarchUsing regression analysis, the expected cost at 40 kJ would bea. $296b. $285c. $102d. $162

Answered: A summary of total charges from a small…

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

A ski resort has recorded its recent sales as follows (in $$). Season 2 years ago Last year This year Spring 700 950 900 Summer 450 500 400 Fall 1,150 1,100 1,350 Winter 1,400 1,500 1,600 The resort estimated that the annual demand for the next year will be 4,800. What would be the forecast for next Fall? Answer: _______
Show your solution. Please write down your answer. No excel please. Thank you.
Calculate the 3-month weighted moving average, consider a weight of 0.5. Year Supplies2018 502019 752020 1302021 1102022 90
Required: Calculate the arithmetic mean and the geometric mean over the three-yearperiod for the investments made.
The data shown are quarterly revenues (in Sthousands) from Roget's Books from 2013-Q1 through 2020-Q2. 6. Quarter 2013-1 2013-2 2013-3 2013-4 2014-1 2014-2 2014-3 2014-4 2015-1 2015-2 2015-3 2015-4 2016-1 2016-2 2016-3 2016-4 2017-1 2017-2 2017-3 2017-4 Revenue 2372 2740 2518 4708 2392 Quarter 2018-1 2018-2 2018-3 2018-4 2019-1 2019-2 2019-3 2019-4 2020-1 2020-2 Revenue 2725 2924 3118 5112 2777 2949 1:27:04 2811 2685 4795 2812 2893 2848 4894 2687 2903 2674 4871 2844 2933 3237 5350 3035 3028 2791 5252 Click here for the Excel Data File, Data file should open in a new browswer window. Select "File" then "Save As" to download the file to your computer and be able to use it in Excel. a. Determine the regression equation. Regression equation: ŷ = | (Round to 1 decimal places.) b. Determine the specific index for each quarter places.) dexes should be in decimal form (e.g. 1.36 not 136). Rounded to 2 decimal Quarter Quarterly Index Q1 Q2 Q3 Q4 c. What are the estimated sales (forecast) for…
March demand was pridicted at 590 units of gear cycles of trevaa ltd. But the actual demand was 400 units only so fourth the company now want to forecast the april demand using exponential smoothing model with constant alpha of 0.72., calculate the same
Calculate customer life time value for the data below. (Show Work) Purchase Occasion Transition Probability Average Basket Size 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 ΝΑ 55% 75% 78% 83% 81% 81% 86% 82% 85% 90% 93% 85% 89% 85% 91% 97% 97% 96% 85% 83% 89% 82% 79% 82% 89% 88% 86% 67% 75% $46.71 $56.71 $57.93 $56.87 $58.26 $66.90 $63.62 $70.27 $63.03 $62.60 $71.81 $76.76 $78.14 $65.65 $74.84 $81.11 $72.08 $87.30 $71.94 $75.44 $70.35 $72.86 $66.68 $79.90 $93.91 $61.08 $94.16 $100.40 $77.89 $99.70
Sales in hunderds) of XYX Cc for the previous 7 months are 80, 82. 88, 95, 103, 105 and 122 respectively. Forecast the sales by 4 point moving average method for the forthcoming penod Oa 10260 units Ob 10625 units Oc 11000 units d. 113500 units
An exponential smoothing is being used to forecast demand. Which of the following alpha value (or error weight) should be used if the demand is highly sensitive to the current events and external factors? a. 0.75 b. 0.05 c. -1.5 d. 0.0 e. 1.75
A regional distributor purchases discontinued appliances from various suppliers andthen sells them on demand to retailers in the region. The distributor operates 5 daysper week, 52 weeks per year. Only when it is open for business can orders bereceived. The following data are estimated for the mixer:Average daily demand (d) = 100 mixersStandard deviation of daily demand (d) = 30 mixersLead time (L) = 3 daysHolding cost (H) = $9.40/unit/yearOrdering cost (S) = $35/order 4 Cycle-service level = 92 percentSuppose that a periodic review (P) system is used at the distributor.a) Calculate the P (in workdays, rounded to the nearest day) that givesapproximately the same number of orders per year as the EOQ.b) It is time to review the item. On-hand inventory is 40 mixers; receipt of 440mixers is scheduled, and no backorders exist. How much should bereordered?c) What is the target inventory level, T?d) What is the total annual cost of the P system?
In order to predict pancakes, John's House of Pancakes uses a weighted moveable average process. It gives a weight of five to the demand in the preceding month, three to request two months ago and one to request three months ago. What is the prediction for August if revenues amounted to 1,000 pancakes in May, 2200 pancakes in June, and 3,000 pancakes in July?
please answer in 30 mins. answer if 100% sure.

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

A summary of total charges from a small café's natural gas bills is provided below: KJ Cost Month a. $296 b. $285 c. $102 d. $162 October 14 $187 November 17 187 December 30 230 January 35 264 February 33 270 March 20 200 Using regression analysis, the expected cost at 40 kJ would be