Question: Hi please help me answer A and B with formulas and work shown. Thank you!! Part A Forecasting (10 Points) Background: Your company has done

Hi please help me answer A and B with formulas and work shown. Thank you!!

Part A Forecasting (10 Points) Background: Your company has done well for four straight years staring in 2017. ABC Corporation, launched a new sophisticated data collection device using unique, patented, semiconductors chips, supplied from China. As sales grew, ABC added the necessary manpower to keep pace with demand. The data is summarized below: To be done using Excel a. Given the data given above, develop a forecast for variable A and B using the exponential smoothing with an alpha value of 0.5 . What is the forecasted value of 2021(A) ? Please round to a whole number. No decimals required. b. Using the same method, but with an alpha value of 0.2 , forecast the anticipated manpower. What is the forecasted value of 2021 (M1) ? 2022 Please round to a whole number. No decimals required. c. On your spreadsheet, calculate the % change for each variable

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!

Part A Forecasting (5 Points) Background: Your company has done well for four straight years staring in 2017. ABC Corporation, launched a new sophisticated data collection device using unique,...

I will give THUMPS UP if you provide in depth answer correctly. Part A (Continued) d. Create two "line" graphs, one for Sales and one for Manpower, in the same Excel spreadsheet. The graph must be...

Part A Forecasting Background: Your company has done well for four straight years staring in 2017. ABC Corporation, launched a new sophisticated data collection device using unique, patented,...

Part A Forecasting (5 Points) Background: Your company has done well for four straight years staring in 2017. ABC Corporation, launched a new sophisticated data collection device using unique,...

1 OPM400 NZZ 2237 Student Name: Student Name: Part A Forecasting (10 Points) Background: Your company has done well for four straight years staring in 2017. ABC Corporation, launched a new...

a. Given the data given above, develop a forecast for variable A and B using the exponential smoothing with an alpha value of 0.5 . What is the forecasted value of 2021(A). ? Please round to a whole...

QUESTIONS : Based on the above case study, please kindly answer the following questions : 1. a.How do you perceive the practice of corporate entrepreneurship in SAMHOUD company above ? Please explain...

Can someone please help me with this? In this project, you will work with sales data from Topt Corn, a popcorn company with an online store, multiple food trucks, and two retail stores. You will...

Corporate Entrepreneurship: A case study 1.Introduction In todays business world, established/large enterprises have to deal with two major challenges: a responding to the technological and global...

Case Study and Exhibit #2 please please help me answer all the questions to double check my work! THANK YOU! Background In the ClearEyes Cataracts Clinic Case, we are told that Dr. Julia Connors has...

Define 'business ethics' and give three reasons why it is important for society. 2. Explain why simply following the law is not enough to ensure companies and/or individuals act ethically. 3. Is...

Repeat Prob. 1049, but replace the open feedwater heater with a closed feedwater heater. Assume that the feed water leaves the heater at the condensation temperature of the extracted steam and that...

How is a security interest in real property perfected? Question 5 options: By filing a UCC Financing Statement By signing a Perfection Agreement By signing a Security Agreement By filing a Security...

A chair was marked for sale at $240. This sale price was 25 percent less than the original price. What was the original price

Reward systems based on individual performance (pay-for-performance, individual performance and pay using an individual bonus or commission) would be more prevalent in countries with higher levels of...

Reward systems based on status (seniority-based and skills-based) would be more prevalent in countries with higher levels of uncertainty avoidance. This proposition was supported by their findings.

1 What are the key cultural variables that influence the success of motivational systems within organizations?