Super Bike Company (SBC) is a whole sale distributor of bicycles. Its distribution center in the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Super Bike Company (SBC) is a whole sale distributor of bicycles. Its distribution center in the town serves many retail stores within a 200-mile radius of the town. The data of bicycles ordered by the stores each month (i.e., monthly bicycle demand) during the last 5 years (year 1 ~ year 5) is shown in the table below. The management saw a recurring pattern of seasonal variation within the year (see the chart below), and decided to use the multiplicative seasonal variation method to forecast monthly demands of bicycles for next year, year 6. Answer the questions, Q1 & Q2. Bicycles demands Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Year Month 7 1 Month 8 Month 9 Month 10 Month 11 Month 12 Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Year 2 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Month 1 Month 2 Month 3 Month 4 Month 5 Year 3 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 1244 878 1053 1080 1541 871 1001 1265 879 1147 988 1355 1200 1046 1025 871 1173 1269 808 1396 1030 963 899 1034 1339 1164 991 1009 1148 1037 986 1453 1093 1003 823 1406 Monthly demands of year 1 through year 5 Emmwch www 1600 1200 800 400 0 Month 1 Month 5 Month 9 Month 1 Month 5 Month 9 Month 1 Month 5 Month 9 Month 1 Month 5 Month 9 Month 1 Month 5 Month 9 Q1: Aggregate the month demands to the yearly demands for year 1 through year 5. Forecast next year's yearly demand using trend projection. Show your calculation below. Q2: Continued from Q1, calculate the monthly demand forecasts of next year. Show your calculation and result below. Year Year 5 Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 1541 1058 1074 959 1526 1052 903 1127 1057 1086 999 1243 1342 1225 1015 1007 1562 1109 884 1111 1081 907 1067 1143 Super Bike Company (SBC) is a whole sale distributor of bicycles. Its distribution center in the town serves many retail stores within a 200-mile radius of the town. The data of bicycles ordered by the stores each month (i.e., monthly bicycle demand) during the last 5 years (year 1 ~ year 5) is shown in the table below. The management saw a recurring pattern of seasonal variation within the year (see the chart below), and decided to use the multiplicative seasonal variation method to forecast monthly demands of bicycles for next year, year 6. Answer the questions, Q1 & Q2. Bicycles demands Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Year Month 7 1 Month 8 Month 9 Month 10 Month 11 Month 12 Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Year 2 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Month 1 Month 2 Month 3 Month 4 Month 5 Year 3 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 1244 878 1053 1080 1541 871 1001 1265 879 1147 988 1355 1200 1046 1025 871 1173 1269 808 1396 1030 963 899 1034 1339 1164 991 1009 1148 1037 986 1453 1093 1003 823 1406 Monthly demands of year 1 through year 5 Emmwch www 1600 1200 800 400 0 Month 1 Month 5 Month 9 Month 1 Month 5 Month 9 Month 1 Month 5 Month 9 Month 1 Month 5 Month 9 Month 1 Month 5 Month 9 Q1: Aggregate the month demands to the yearly demands for year 1 through year 5. Forecast next year's yearly demand using trend projection. Show your calculation below. Q2: Continued from Q1, calculate the monthly demand forecasts of next year. Show your calculation and result below. Year Year 5 Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 1541 1058 1074 959 1526 1052 903 1127 1057 1086 999 1243 1342 1225 1015 1007 1562 1109 884 1111 1081 907 1067 1143
Expert Answer:
Answer rating: 100% (QA)
The first part of the question involves aggregating the monthly demands to calculate the yearly demands for years 1 through 5 To do this we simply nee... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these general management questions
-
Q1. A CSTR is used to produce a desired product C. The reactants, A and B, are kept in two separate storage tanks. In the tanks the reactants are stored at high concentration at 5 and 8 mol/L for A...
-
A large manufacture company is considering the purchase of a $300,000 inventory management system. The system will be depreciated straight-line to zero over its 5- year life. It will be worth $40,000...
-
1. Based on the forecasts above, use the spreadsheet below to construct a pro forma income statement for Idexo over the next five years. What is the annual growth rate of the firm's net income over...
-
The following information provides details of costs, volume and cost drivers for a particular period in respect of ABC plc, a hypothetical company: ( Details Direct Material $25 Cost Direct Labor 4/3...
-
Refer to The Journal of Finance (December 2011) study of whether the decision to invest in the stock market is dependent on IQ, Exercise 3.46 (p. 158). Recall that an IQ score (from a low score of 1...
-
If Malaysia experiences a decline in economic growth (and experiences a decline in inflation and nominal interest rates as a result), what would the probable impact on its currency be when it is...
-
\(\sqrt{2,940}\) Simplify the square root by expressing it in lowest terms.
-
Given the following network for a stock repurchase project with outside consulting resource demands, construct a modified Gantt AOA chart with resources and a resource load diagram. Suggest how to...
-
M. Lewis opened an Innovation Furniture shop on 01 August.During August, the following transactions of the business tookplace. (Note GST is ignored). 1. The owner invested cash of $22,000to start t 2...
-
You have been hired as the new controller for Paulson Paint, Inc. You will have the opportunity to utilize your financial and managerial accounting experience. You will be responsible for preparing...
-
Discuss Disclosure of Adverse Events from both a quality and ethical perspective in healthcare.
-
Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides data concerning the company's costs: Cleaning supplies...
-
A has contributed 3 billion VND, B 2 billion VND and C 1 billion VND to create a company operating in plastics. With 6 billion VND of charter capital, the company will initially finance its...
-
The average temperature in San Francisco, California, forDecember, January, and February is 11C (52F). During the samethree-month period the average temperature in Richmond Virginia, is4C (39F), yet...
-
Hemming Company reported the following current-year purchases and sales for its only product. Date January 1 January 10 March 14 March 15 July 301 October 5 October 26 Sales Purchase Sales Purchase...
-
Price of the house: $360,000, Mortgage Interest Rate: 5.6%, Term of Mortgage in years: 15. 1. What will your monthly mortgage payment be? Do not round any intermediate computations. Round your final...
-
Business people point out that the documentation for capital budgeting proposals is often quite impressive. Cash flows are projected down to the last thousand dollars (or even the last dollar) for...
-
Solve for the equilibria of the following discrete-time dynamical systems Pr pt+1 = Pr+2.0(I-Pr)
-
Provide several examples of the differences between high- and low-cost-to-serve customers.
-
The mix of salary and commission Belleville Fashions sells high-quality womens, mens, and childrens clothing. The store employs a sales staff of 11 full-time employees and 12 part-time employees....
-
1. What is the difference between flexible and capacity-related resources? 2. A student develops a spending plan for a school semester. Is this budgeting? Why?
-
During the year to 30 September 2007, Kammer plc made a new offer of shares. The details of the offer were as follows: 1. 100,000 ordinary shares of 1 each were issued payable in instalments as...
-
Applications were invited by the directors of Grobigg Ltd for 150,000 of its 1 ordinary shares at 1.15 per share payable as follows: Applications were received for 180,000 shares and it was decided...
-
A companys balance sheet appears as follows: Required: (a) If 10,000 of the ordinary shares were purchased at par, there being no new issue of shares for the purpose, show the journal entries to...
Study smarter with the SolutionInn App