Production Department Flexible Budget Performance

PART B Table 1: CWWR Purchasing Department Costs and Cost Drivers Store Locaton Purchasing Merchandise # of Dept. Cost Purchased Purchase ($) ($) Orders # of Suppliers Sheridan, WY 575,000 47,239,000 1708 61 Denver 1,226,000 102,364,000 2519 95 Salt Lake City 1,710,000 100,162,000 2506 139 Kansas City 881,000 95,760,000 1719 91 Omaha 1,544,000 51,466,000 2883 155 Milwaukee 794,000 50,631,000 647 75 Minneapolis 1,341,000 84,753,000 2978 103 Phoenix 794,000 103,464,000 3761 117 Las Vegas 2,216,000 96,162,000 2584 73 Albuquerque 2,030,000 62,364,000 5497 176 Tucson 1,338,000 65,635,000 4347 130 Houston 856,000 88,524,000 2878 62 Oklahoma City 1,122,000 72,645,000 819 129 Tulsa 863,000 61,638,000 1247 145 Dallas 1,085,000 105,666,000 2162 141 San Antonio 952,000 59,437,000 2822 105 Austin 1,134,000 38,542,000 5115 51 El Paso 1,042,000 33,020,000 382 131 Nashville 1,634,000 36,322,000 5293 172 Memphis 699,000 34,121,000 967 34 Indianapolis Requirements 875,000 31,920,000 2425 48 Joe asked you, the managerial cost specialist on his management team, to examine the data and to recommend some courses of action to reduce purchasing department costs. Prepare a statistical analysis of the costs provided. a. Plot the purchase department cost vs. each cost driver. Are they linear? Save them on one worksheet labeled Scatterplots. b. Do a High-Low analysis of each cost driver. Give the cost equation using each cost driver. Save them on one worksheet called HighLow. c. Use both simple and multiple regression analysis to develop cost models for all potential cost drivers. Put each result on a new worksheet and label the sheets. d. Identify the best model, and explain why on a worksheet called Results. Since this is an excel assignment, can you show me in excel?

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.