Roger Co. implemented activity-based costing in the current year. To select the appropriate driver for Cost Pool A, Roger performed regression analyses for twoindependent variables, Driver 1 and Driver 2, using monthly operating data. The monthly levels of Cost Pool A were the dependent variables in both regressions.Output results from the regression analyses were as follows:Driver 1R squaredInterceptX variable (slope)At the budgeted production level for next month, the levels of Driver 1 and Driver 2 are expected to be 5,880 and 7,000, respectively. Based on this information,what is the budgeted amount for Cost Pool A for next month?O A. $3,280OB. $2,624O C. $3,464O D. $3,7850.46$551.00Driver 2$0.550.80$970.00$0.33

Given: Budgeted production levels for next month - Driver 1 = 5,880 Driver 2 = 7,000 Output…

Answered: Roger Co. implemented activity-based…

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

Prepare a Demand Forecast for “Year 5” using Excel. Quarterly Data for Cars Sales Yt Year Quarter Sales (1000s) Year 1 1 4.80 2 4.10 3 6.00 4 6.50 Year 2 1 5.80 2 5.20 3 6.80 4 7.40 Year 3 1 6.00 2 5.60 3 7.50 4 7.80 Year 4 1 6.30 2 5.90 3 8.00 4 8.40 Year 5 1 2 3 4
The consulting agency begins collecting data on actual population demand utilization. The first year s data is: Period March 2020 April 2020 May 2020 June 2020 Demand 31,550 40,125 38,243 35,311 32,207 32,125 35,700 40,620 n Period Demand September 41,482 2020 October 2020 November 2020 December 2020 January 2021 38,450 February 2021 33,330 38,348 34,722 36,190 July 2020 42,810 August 2020 44,230 What is the forecast demand for March 2021 considering trend and seasonality?
part b)
A store’s demand figures are given in the table. According to this, what is the linear regression forecast for Week 12?
Q: Provide a structured persona and related withdraw amount and check balance scenarios of an ATM for elder user having minor visual and reflexive impairments (problem in vision and movement of limb). Also suggest a low-fidelity paper-based working prototype of an ATM machine to support the mentioned withdraw amount and check balance scenarios. Note: this question is related from HCI subject kindly solved this corectly and in detail.
1.1 Consider the planned construction of a new office building in a downtown area of a large city when office space is in surplus demand. Construct a risk analysis that examine the various form of risk related to the creation of this office building. 1.2 Explain how the analysis would change if office space were in high demand
In past 4 weeks, AOC (Arab oil company) started producing and distributing national engine oil to substitute French Total and Esso brands. Production reported to be in thousands: 2, 4, 3, 5 TG Thousand Gallons). AOC production will be calculated after 5 more weeks.
Table Q4. Average monthly discharge of Athi River City, m³/s Year Jan Feb Mar 1987 2.92 5.10 1.95 Apr 4.42 May Jun 3.31 2.24 Jul Aug 1.05 Sep 0.74 1.02 Oct Nov Dec 1.08 3.09 7.62 2 1988 24.3 11.5 17.2 12.6 7.28 7.53 3.03 10.2 10.9 17.6 16.7 3 1989 15.3 13.3 14.2 36.3 13.5 3.62 1.93 1.83 1.93 4 1990 11.5 4.81 8.61 27.0 4.19 2.07 1.15 2.04 5 1991 11.1 7.90 41.1 6.77 8.27 4.76 2.78 2.10 1.70 1.44 4.02 3.29 5.98 12.7 3.12 2.97 4.45 4.45 3.03 12.2 7.22 1.98 6 1992 2.92 5.10 28.7 0.91 0.67 1.33 2.38 2.69 3.03 7 1993 7.14 10.7 9.63 21.1 10.2 5.13 3.03 10.9 3.12 2.61 3.00 3.82 14.0 14.2 8 1994 4.96 7.36 47.4 29.4 2.29 1.70 1.56 1.56 2.04 2.35 9 1995 2.89 9.57 17.7 16.4 6.83 3.74 1.60 1.13 1.13 1.42 1.98 2.12 24.7 10 1996 1.78 1.95 7.25 6.26 8.92 3.57 1.98 1.95 3.09 3.94 12.7 11 1997 13.8 6.91 12.9 11.3 3.74 1.98 1.33 1.16 0.85 2.63 6.49 5.52 12 1998 4.56 8.47 59.8 9.80 6.06 5.32 2.14 1.98 2.17 3.40 8.44 11.5 13 1999 13.8 29.6 38.8 13.5 37.2 22.8 6.94 3.94 2.92 2.89 6.74 3.09 14 2000 2.51 13.1…
On Week a) Item: P24 hand 1 2 3 4 5 6 7 8 Forecast 30 30 30 40 40 40 45 45 Customer Orders 13 8 4 PAB 20 Available to Promise MPS b) Determine if each customer order will be accepted. Order Amount Week Accept (Y/N) 1 40 2 30 3 4 30 25 462M 3 Update the MPS time-phased record for accepted orders. Item: P24 Forecast Customer Orders Problem 3: The MPS planner at Murphy Motors uses MPS time-phased records for planning end-item production. The planner is currently working on a schedule for the P24, one of Murphy's top-selling motors. The planner uses a production lot size of 70 and a safety stock of 5 for the P24 motor. a) Complete the MPS time-phased record for product P24. Use the table on the left. b) Determine if Murphy Motors can accept each of the following customer orders. Update the MPS time- phased record for accepted orders. Order 1234 Amount 40 Desired Week 4 30 30 25 623 8 4 On Week hand 1 2 3 4 5 6 30 30 30 40 40 40 74 45 45 PAB 20 Available to Promise MPS On hand = 20
Problem 12-15 (Algo) Given the data shown below, calculate the slope and intercept using simple linear regression. (Round your intermediate calculations and final answers to 1 decimal place.) Period: Demand: 1 2 3 4 5 6 22 29 42 50 54 61 Slope Intercept
1

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