Answered step by step
Verified Expert Solution
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**********
*******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 52Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started