140) PLEASE HELP ME with this!! a. Find the equation of a simple linear regression line using Excel.Note: Round your answers to 3 decimal places.Y =Last Yearb. Compute trend and seasonal factor from a linear regression line obtained with Excel.Note: Do not round intermediate calculations. Round your answers to 3 decimal places.This Year+Next YearPeriod1||[IIIVI|||||IVtPeriodI||IIIIVTrend Forecastc. Forecast sales for next year using the above seasonal factors.Note: Do not round intermediate calculations. Round your answers to 2 decimal places.SeasonalFactorsForecast (Units) Tucson Machinery, Incorporated, manufactures numerically controlled machines, which sell for an average price of $13.0 million each.Sales for these NCMs for the past two years were as follows: Use Exhibit 3.10.QUARTER LAST QUANTITY QUARTER THIS(UNITS)YEAR13152313YEARIIIIIIIVY =a. Find the equation of a simple linear regression line using Excel.Note: Round your answers to 3 decimal places.Last YearThis Yearb. Compute trend and seasonal factor from a linear regression line obtained with Excel.Note: Do not round intermediate calculations. Round your answers to 3 decimal places.PeriodI|||||IV1IIIIIIV+IIIIIIVPeriodQUANTITY(UNITS)1721251911tTrend Forecastc. Forecast sales for next year using the above seasonal factors.Note: Do not round intermediate calculations. Round your answers to 2 decimal places.SeasonalFactorsForecast (Units)

Find the Calculation methods below:

Answered: Tucson Machinery, Incorporated,…

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

Q23 all of these pictures are from the same initial question and I need help please!! Help with a b c d e f and g which is not shown but here is the question: g-
Q.1 CUU is planning to procure an administrative building for its students, and design a contract document for this task clearly showing the key requirements and how they should be executed.
Q 28 please help me all info is there Owners of a local restaurant are concerned about their ability to provide quality service as they continue to grow and attract more customers. They have collected data from Friday and Saturday nights, their busiest times of the week. During these time periods, about 97 customers arrive per hour for service. Given the number of tables and chairs, and the typical time it takes to serve a customer, the owners estimate they can serve, on average, about 144 customers per hour. Use Exhibit 4.6 Furthermore, the owners anticipate that in one year their demand will double as long as they can provide good service to their customers. b. Next year, after demand doubles, what must the service capacity increase to (at minimum) to stay out of the critical zone? Note: Round up your answer to the next nearest whole number
QUESTION 2 With quantity competition, horizontal mergers might be socially efficient but not profitable for the firms. O True O False
How to communicate requirement for a project
Question 9
How would you determine which orders have not yet been shipped to the customer?
15.1.1See picture to solve
Business Name: CV Water Refill Location: 3rd Street Chula Vista, CA 91911 Financial Management: a. Accounting (How will you manage your business accounting?): b. Professional Resources (List all to be used): c. Credit and Financing (List resources for financing your business venture): d. Billable Rate/Break-Even Sales
Question 16 MONTH EXPECTED DEMAND PRODUCTION DAYS Jan 800 21 Feb 500 18 Mar 600 18 Apr 1050 22 May 1150 19 June 1100 20 Cost Information: Subcontracting cost = SR 17 per unit per month Average pay rate = SR 10 per hour Labor-hours to produce a unit = 4 hours per unit Daily working hours = 8 hours a) Using excel, caleulate the total cost of the following plan : - Plan : is to maintain a constant workforce at a level necessary to meet the lowest demand month and to meet all demand above this level by subcontracting. (Answer in Field ) Attach your solutions.
3) Amelia Ltd. makes a plastic tricycle that is composed of three major components: a handlebar-front wheel-pedal assembly, a seat and frame unit, and rear wheels. The company has orders for 48,000 of these trikes. Current schedules yield the following information. Requirements Cost to Cost to Component Plastic Time Space Manufacture Purchase Front 12 40 8 16 24 Seat/Frame 16 24 8 12 18 Rear wheel (each) .20 8 .4 2 6 Available 100000 320000 60000 The company obviously does not have the resources available to manufacture everything needed for the completion of 24000 tricycles so has gathered purchase information for each component. Develop a linear programming model to tell the company how many of each component should be manufactured and how many should be purchased in order to provide 24000 fully completed tricycles at the minimum cost.
6. What is bottleneck in operation?

SEE MORE QUESTIONS

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