Question • 4.34 The number of auto accidents in Athens, Ohio, is related to the regional number of registered automobiles in thousands ( X 1 ), alcoholic beverage sales in $10,000s ( X 2 ), and rainfall in inches ( X 3 ). Furthermore, the regression formula has been calculated as: Y = a + b 1 X 1 + b 2 X 2 + b 3 X 3 Where Y = number of automobile accidents a = 7.5 b 1 = 3.5 b 2 = 4.5 b 3 = 2.5 Calculate the expected number of automobile accidents under conditions a, b, and c:
Question • 4.34 The number of auto accidents in Athens, Ohio, is related to the regional number of registered automobiles in thousands ( X 1 ), alcoholic beverage sales in $10,000s ( X 2 ), and rainfall in inches ( X 3 ). Furthermore, the regression formula has been calculated as: Y = a + b 1 X 1 + b 2 X 2 + b 3 X 3 Where Y = number of automobile accidents a = 7.5 b 1 = 3.5 b 2 = 4.5 b 3 = 2.5 Calculate the expected number of automobile accidents under conditions a, b, and c:
Solution Summary: The author explains how forecasting is used to predict future changes or demand patterns.
• 4.34 The number of auto accidents in Athens, Ohio, is related to the regional number of registered automobiles in thousands (X1), alcoholic beverage sales in $10,000s (X2), and rainfall in inches (X3). Furthermore, the regression formula has been calculated as:
Y
=
a
+
b
1
X
1
+
b
2
X
2
+
b
3
X
3
Where
Y = number of automobile accidents
a = 7.5
b1 = 3.5
b2 = 4.5
b3 = 2.5
Calculate the expected number of automobile accidents under conditions a, b, and c:
The annual demand for water bottles at Mega Stores is 500 units, with an ordering cost of Rs. 200
per order. If the annual inventory holding cost is estimated to be 20%. of unit cost, how frequently
should he replenish his stocks? Further, suppose the supplier offers him a discount on bulk
ordering as given below. Can the manager reduce his costs by taking advantage of either of these
discounts? Recommend the best ordering policy for the store.
Order size Unit cost (Rs.)
1 – 49 pcs. 20.00
50 – 149 pcs. 19.50
150 – 299 pcs. 19.00
300 pcs. or more 18.00
Help answer showing level work and formulas
I need to forecast using a 3-Period-Moving-Average-Monthly forecasting model which I did but then I need to use my forecast numbers to generate a Master Production Schedule (MPS) I have to Start with actual sales (my own test data numbers) for August-2022 Oct-2022 i need to create MPS to supply demand starting November-2022 April 2023
I just added numbers without applying formulas to the mps on the right side of the spreadsheet because I do not know how to do it. The second image is the example of what it should look like. Thank You.
Chapter 4 Solutions
Operations Management: Sustainability and Supply Chain Management (12th Edition)
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.