Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
1) Propose a level plan for the next 12 months, October 2017-September 2018. 2) Propose a chase plan for the next 12 months, October 2017-September
1) Propose a level plan for the next 12 months, October 2017-September 2018.
2) Propose a chase plan for the next 12 months, October 2017-September 2018.
Discuss the main characteristics of these two plans in contrast with each other. Between these two plans, which plan would you recommend the company to choose? Justify your recommendation.
Please help ASAP.
2017 701 2018 ? ? Historical Demand Data: Month January February March April May June July August September October November December 2014 437 605 722 893 901 1311 1055 975 822 893 599 608 2015 712 732 829 992 1148 1552 927 1284 1118 737 983 872 2016 613 984 812 1218 1187 1430 1392 1481 940 994 807 527 1291 1162 1088 1497 1781 1843 839 1273 ? ? ? nnnnnn. ? ? ? ? ? ? ? They currently hold on the average 653 units of monthly inventory and produce a total of 757 units in overtime, resulting in a total cost of $2,048,761 (which includes Labour, Hiring, Layoff, Inventory and Overtime costs). Here is some additional data: Number of working days Oct-Sept: 22 15 23 20 20 20 20 21 23 20 22 22 Beginning inventory: 260 units Holding cost: $10 per bike per month Regular time labour cost: $240 per working day Overtime cost: $240 per bike Hiring cost $1800 per employee. 1. Your MS Word file (not the PDF file) - One file for both assignments containing the analysis of your results and explanation of your recommendation. 2. One Excel file for your solutions. This is a continuation of the Raleigh bikes problem given in Assignment 1. Read the given information carefully and use the forecast given below to answer the following questions. Assignment 2. Propose a level plan for the next 12 months, October 2017-September 2018. Assignment 3. Propose a chase plan for the next 12 months, October 2017-September 2018. Discuss the main characteristics of these two plans in contrast with each other. Between these two plans, which plan would you recommend the company to choose? Justify your recommendation. The forecast for t=46-57 (Oct 2017-Sept 2018) are given below. Forecasts for t=58 (Oct 2018) is also given just in case you need it. T=46 T=47 T=49 T=50 T=51 T=52 T=53 T=55 T=56 T=58 T=48 896 T=54 1884 T=57 1238 1068 984 808 1077 1085 1355 1440 1491 1507 1120 2017 701 2018 ? ? Historical Demand Data: Month January February March April May June July August September October November December 2014 437 605 722 893 901 1311 1055 975 822 893 599 608 2015 712 732 829 992 1148 1552 927 1284 1118 737 983 872 2016 613 984 812 1218 1187 1430 1392 1481 940 994 807 527 1291 1162 1088 1497 1781 1843 839 1273 ? ? ? nnnnnn. ? ? ? ? ? ? ? They currently hold on the average 653 units of monthly inventory and produce a total of 757 units in overtime, resulting in a total cost of $2,048,761 (which includes Labour, Hiring, Layoff, Inventory and Overtime costs). Here is some additional data: Number of working days Oct-Sept: 22 15 23 20 20 20 20 21 23 20 22 22 Beginning inventory: 260 units Holding cost: $10 per bike per month Regular time labour cost: $240 per working day Overtime cost: $240 per bike Hiring cost $1800 per employee. 1. Your MS Word file (not the PDF file) - One file for both assignments containing the analysis of your results and explanation of your recommendation. 2. One Excel file for your solutions. This is a continuation of the Raleigh bikes problem given in Assignment 1. Read the given information carefully and use the forecast given below to answer the following questions. Assignment 2. Propose a level plan for the next 12 months, October 2017-September 2018. Assignment 3. Propose a chase plan for the next 12 months, October 2017-September 2018. Discuss the main characteristics of these two plans in contrast with each other. Between these two plans, which plan would you recommend the company to choose? Justify your recommendation. The forecast for t=46-57 (Oct 2017-Sept 2018) are given below. Forecasts for t=58 (Oct 2018) is also given just in case you need it. T=46 T=47 T=49 T=50 T=51 T=52 T=53 T=55 T=56 T=58 T=48 896 T=54 1884 T=57 1238 1068 984 808 1077 1085 1355 1440 1491 1507 1120Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started