The average order of an assembly part of a product in a manufacturing plant per weekday...

 

Transcribed Image Text:

The average order of an assembly part of a product in a manufacturing plant per weekday for each month are shown in Table III. Month/Day Monday Tuesday Wednesday Thursday Friday July 309 398 320 314 316 August 256 330 386 311 333 September 271 397 324 411 446 October 348 379 318 325 328 November 267 362 413 388 278 December 216 288 307 288 356 January 361 482 329 266 326 February 330 413 486 511 491 March 400 443 423 435 465 April 457 535 548 451 424 May 235 262 252 330 305 June Grand Total 3,725 275 291 286 283 281 4,580 4,392 4,313 4,349 Table I 3.a. Develop a linear regression model based on the average demand in each month. 3.b. Predict the demand for July and August. 3.c. Develop monthly and daily indexes for the demand. 3.d. Using the daily indexes technique, develop the monthly adjusted predictions for June and July as well as for Monday through Friday in these months. The average order of an assembly part of a product in a manufacturing plant per weekday for each month are shown in Table III. Month/Day Monday Tuesday Wednesday Thursday Friday July 309 398 320 314 316 August 256 330 386 311 333 September 271 397 324 411 446 October 348 379 318 325 328 November 267 362 413 388 278 December 216 288 307 288 356 January 361 482 329 266 326 February 330 413 486 511 491 March 400 443 423 435 465 April 457 535 548 451 424 May 235 262 252 330 305 June Grand Total 3,725 275 291 286 283 281 4,580 4,392 4,313 4,349 Table I 3.a. Develop a linear regression model based on the average demand in each month. 3.b. Predict the demand for July and August. 3.c. Develop monthly and daily indexes for the demand. 3.d. Using the daily indexes technique, develop the monthly adjusted predictions for June and July as well as for Monday through Friday in these months.

Answer rating: 100% (QA)

Clipboard Font Alignment Number Styles Cells Editing fe E A A B D G H K ... View the full answer