Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

monthsdemands (unit)
121600
222900
325500
421900
523700

a. Using the 3-year moving average method (Moving average) 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:

costmake optionbuy option
fixed cost1250005000
variable cost1117

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.

Step by Step Solution

3.48 Rating (171 Votes )

There are 3 Steps involved in it

Step: 1

a Forecast 1 4 2 5 3 6 4 7 5 AVERAGEB3B4 ABSB6C6 AVERAGEB4B5 ABSB7C7 AVERAGEB5B6 8 6 9 10 MAD 11 A B ... 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_2

Step: 3

blur-text-image_3

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

Managerial Accounting

Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer

13th Edition

978-0073379616, 73379611, 978-0697789938

More Books

Students also viewed these Accounting questions

Question

In Problems 1130, solve each equation by factoring. x 2 - 9x = 0

Answered: 1 week ago

Question

Dont smell (i.e., too much perfume/cologne).

Answered: 1 week ago

Question

4. Jobe dy -Y 2 et by

Answered: 1 week ago