Question: PLEASE answer the WHOLE question, this is all one question. The email doesn't haven't to be exact, but maybe just some guidance on what to

PLEASE answer the WHOLE question, this is all one question. The email doesn't haven't to be exact, but maybe just some guidance on what to write.

PLEASE answer the WHOLE question, this is all one

The basic model of pens is manufactured in large batches several times a year. Pens R Us needs to determine the number of "production runs that will be needed in 2022 and 2023 schedules. They have collected the following information: Past 3 Years Number of Production Runs 5 8 10 Number of Pre-Order Customers 6 2 2 2019 2020 2021 As you can see, the number of production runs has doubled over the last three years despite the number of preorders decreasing by a lot. Getting a forecast will help with the resource planning process. You have been hired to help Lisa Simpson and will need to use trend analysis and regression analysis to determine the most accurate number production runs needed for the next two years, 2022 and 2023. For the regression forecast, it is also known that the number of customers that have placed pre-orders in 2022 is 7 and in 2023 there are 5. In addition, if the standard deviation for production runs is 2, find the 80% confidence interval for your best 2022 forecast and a 90% confidence interval for your best 2023 forecast. Note: You may solve this by hand or in an Excel spread sheet. Either way, you MUST show your evidence IN the exam Word document. In addition, if you used Excel, please turn-in the Excel spreadsheet with your exam (it also has document properties). Forecast for 2022 and 2023: Please provide evidence of your "hand-written or Excel solution. Pearson's Correlation Analysis (r): Please provide evidence of your hand-written or Excel solution. Confidence Interval Analysis: Please provide evidence of your "hand-written or Excel solution. Write a memo to Lisa that identifies the best forecasting method and your best forecasts for the number of production runs needed in 2022 and 2023. In addition, suggest a TWO qualitative model that could be used to enhance the forecasting process. The memo must have at least 10 GREAT sentences of with your opinions, decision, and your reasons why. Please Type Your Answer Below. Dear Ms. Lisa Simpson

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

PLEASE answer the WHOLE question, this is all one puestion. The email doesn't haven't to be exact, but maybe just some guidance on what to write. The basic model of pens is manufactured in large...

PLEASE answer the WHOLE question, this is all one question. The email doesn't haven't to be exact, but maybe just some guidance on what to write. Question 1 --- (100 points) Pen's R Us produces many...

Please Answer 2a thru 2f Required: 1a. For the Assemble and Pack activity: What percentage of the cost is allocated to the Basic Model? What percentage of the cost is allocated to the Advanced Model?...

Please write the selecting tools and approaches (according to the subject R esearch Method ) for this topic SECOND LANGUAGE ACQUISITION: LEVEL OF INTEREST IN LEARNING MANDARIN CHINESE LANGUAGE AS A...

Please answer the following question after reading the case study which is attached below: How much PM is enough PM? How much PMO support is enough PMO support? The AtekPC Project Management Office...

please answer the fourth question please answer the 4th question... Attached is a Functional Requirement Document, your assignment is as follows: 1. Write a note on the strategy for testing this...

Please answer only "Discussion Question" at the end. Western States Stationery Case Western States Stationery was founded in the late 1800s in the San Francisco area as a one-man operation producing...

This is a question critical thinking subject. Please answer all the question at the end I need it urgently. Thanku INTRODUCTION E-commerce is increasingly becoming an important avenue to conduct...

The resulting bar chart shows that when HMK is the AR Clerk and FKL is the Cash Receipts Clerk, CT is the GL Accounting Clerk for $226,851 of current AR balances. However, there are $25,352 of...

Experts has received a consulting engagement from Sunny Service Station to design a system (simulation) that would help them predict gasoline demand, order quantity, and profits. Sunnys is a service...

Compare the two companies by converting their condensed income statements to common-size statements. Which company earned more net income? Which company's net income was a higher percentage of its...

Section 1 1 : Review Questions The biological effect of radiation is measured in what units? A . Roentgen B . Rad C . Rem D . Curies The amount of x - rays received in the course of employment by an...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...