Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help PLEASEEEE! Please show step by step so I can understand! *******I KEEP GETTING NOTIFICATIONS THAT MY QUESTION NEEDS MORE INFORMATION, THERE IS NO

Need help PLEASEEEE! Please show step by step so I can understand!

*******I KEEP GETTING NOTIFICATIONS THAT MY QUESTION NEEDS MORE INFORMATION, THERE IS NO MORE INFORMATION. CALCULATE LINEAR TREND EQUATION BASED ON 27-52 WEEKS DATA**********

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

*******CALCULATE LINEAR TREND EQUATION BASED ON 26 DATA**********

3. Product E is a new product and manufactured by the Alpha company itself. This product was introduced to the market in July 2019 and the feedback of the market was very positive. Mary had provided the 2019 historical sale data of product E in the attached file. She wanted Jason to determine the optimal production plan for the first 4 weeks of 2020 for product E. Some information is given here: 2019 last week's output =2,800 Beginning inventory = 0 Inventory holding cost = $40 per unit per week Hiring employees = $40 per unit Terminating employee = $80 per unit Subcontracting cost =$60 per unit Unit cost on regular time = $30 per unit Overtime cost = $15 extra per unit Jason's job is to develop an aggregate plan. The three initial options he wants to evaluate are: a. Plan A: a chase strategy that hires and fires personnel as necessary to meet the forecast 1 b. Plan B: a level strategy. c. Plan C: a level strategy that produces 2,800 units per week and meets the forecasted demand with inventory and subcontracting. Which strategy Jason should choose to get the lowest expected cost? (30 points) A B D E 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 N/A 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Week of 2019 Sales of Product E 1 N/A 2 N/A 3 N/A 4 N/A 5 N/A 6 N/A 7 N/A 8 N/A 9 N/A 10 11 N/A 12 NA 13 N/A 14 N/A 15 N/A 16 N/A 17 N/A 18 N/A 19 N/A 20 N/A 21 N/A 22 N/A 23 N/A 24 N/A 25 N/A 26 N/A 27 1544 28 1597 29 1661 30 1703 31 1746 32 1802 33 1850 34 1902 35 1950 36 2003 37 2043 38 2097 39 2160 40 2202 41 2246 42 2295 43 2349 Sales History 2019 43 44 Order History 2019 P 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 N/A N/A N/A N/A N/A N/A 1544 1597 1661 1703 1746 1802 1850 1902 1950 2003 2043 2097 2160 2202 2246 2295 2349 2397 2450 2499 2550 2603 2648 2691 2754 2808 40 41 42 43 44 45 46 47 48 49 50 51 52 3. Product E is a new product and manufactured by the Alpha company itself. This product was introduced to the market in July 2019 and the feedback of the market was very positive. Mary had provided the 2019 historical sale data of product E in the attached file. She wanted Jason to determine the optimal production plan for the first 4 weeks of 2020 for product E. Some information is given here: 2019 last week's output =2,800 Beginning inventory = 0 Inventory holding cost = $40 per unit per week Hiring employees = $40 per unit Terminating employee = $80 per unit Subcontracting cost =$60 per unit Unit cost on regular time = $30 per unit Overtime cost = $15 extra per unit Jason's job is to develop an aggregate plan. The three initial options he wants to evaluate are: a. Plan A: a chase strategy that hires and fires personnel as necessary to meet the forecast 1 b. Plan B: a level strategy. c. Plan C: a level strategy that produces 2,800 units per week and meets the forecasted demand with inventory and subcontracting. Which strategy Jason should choose to get the lowest expected cost? (30 points) A B D E 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 N/A 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 Week of 2019 Sales of Product E 1 N/A 2 N/A 3 N/A 4 N/A 5 N/A 6 N/A 7 N/A 8 N/A 9 N/A 10 11 N/A 12 NA 13 N/A 14 N/A 15 N/A 16 N/A 17 N/A 18 N/A 19 N/A 20 N/A 21 N/A 22 N/A 23 N/A 24 N/A 25 N/A 26 N/A 27 1544 28 1597 29 1661 30 1703 31 1746 32 1802 33 1850 34 1902 35 1950 36 2003 37 2043 38 2097 39 2160 40 2202 41 2246 42 2295 43 2349 Sales History 2019 43 44 Order History 2019 P 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 N/A N/A N/A N/A N/A N/A 1544 1597 1661 1703 1746 1802 1850 1902 1950 2003 2043 2097 2160 2202 2246 2295 2349 2397 2450 2499 2550 2603 2648 2691 2754 2808 40 41 42 43 44 45 46 47 48 49 50 51 52

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Brain Audit Why Customers Buy And Why They Dont

Authors: Sean D'Souza, John Forde

1st Edition

0473175045, 978-0473175047

More Books

Students also viewed these Accounting questions

Question

Explain the nature of human resource management.

Answered: 1 week ago

Question

Write a note on Quality circles.

Answered: 1 week ago

Question

Describe how to measure the quality of work life.

Answered: 1 week ago

Question

4. Does cultural aptitude impact ones emotional intelligence?

Answered: 1 week ago