Question
Toro Cutlery company wants to forecast the demand for bicycles in June 2020 to have a plan to prepare the source of goods to suit
Toro Cutlery company wants to forecast the demand for bicycles in June 2020 to have a plan to prepare the source of goods to suit the consumption demand of the market. Given that the demand for Bicycles in the previous 5 months is as follows:
months | demands (unit) |
1 | 21600 |
2 | 22900 |
3 | 25500 |
4 | 21900 |
5 | 23700 |
a.Using the 3-year moving average method (Movingaverage) to forecast the demand for Bicycles in 2021. Determine the error value according to this method.
b. (1.5) Using the Linear Trend method to forecast the demand for bicycles in the future
year 2021. Determine the error value according to this method.
c. (1.0) Rate the above two forecasting methods and indicate the company should apply the price
What is the forecast value for 2021?
2) In 2021, in order to have the forecasted number of Bicycles (using the results obtained from Question 1c), the Company is considering manufacturing or importing from suppliers to achieve optimal costs, knowing that the cost to manufacture the Bicycle and purchase the Bicycle from the supplier is as follows:
cost | make option | buy otion |
fixed cost | 125000 | 5000 |
variable cost | 11 | 17 |
a)Determine the amount of Bicycle consumption at the break-even point and the total cost that the Company needs to pay corresponding to this amount
b) 1.0) Please help the Company make the decision to manufacture or import vehicles from suppliers in the following 02 cases:
1. The number of Bikes needed is 80% of the forecast value of 2021
1. The number of Bicycles required is equal to the forecast value of 2021
c. (1.0) From the results of Question 2a & Question 2b, please give advice to the Company on the issue that the Company is considering.
Solve it by hand,not Excel.Thank you,guys
Step 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