Group assignment 1. Use excel to forecast the monthly sales figures using multiplicative models based on the information given in Appendix A.

Sales forecast Based on the market research by a consultant company, CH has produced the following sales trend for the furniture for the new subsidiary. Y=80 units + 2D, where D is a monthly number, if D=1 represent January in 2022, and D=2 represent February in 2022 and so on) and the respective seasonal variation (multiplicative models) for each month is as below: Month Oct Nov Dec Jan Feb Mar Apr May Jun July Aug Sep Selling price per unit 3,840 3,840 3,900 4,000 4,010 4,020 4,030 4,060 4,100 4,130 4,200 4,200 of furniture set Estimated Closing 6 7 8 8 8 8 9 9 9 100 100 100 inventory (unit) Purchase cost per unit 2,860 2.860 2,870 2.910 2.910 2.930 2.930 2.940 3.040 3,020 3,100 3,100 of Racing bicycle Seasonal variation 1.03 1.03 0.99 0.96 0.96 1.04 1.15 1.14 1.15 1.01 1.01 0.53Prepare a REPORT to the management of CH on this proposal. Your report must include the following: Group assignment 1. Use excel to forecast the monthly sales figures using multiplicative models based on the information given in Appendix A.Agenda for the coming Quarterly Management Meeting (QMM) The coming QMM meeting will be held in March 2023 to review the company latest quarterly financial performance and formulate the strategic plans for the next two years. The following issues has been identified by William to be deliberated in the meeting: Agenda (1): Expansion plan As part of the expansion plan, William is evaluating the feasibility of importing readymade furniture for office use from China and assemble it locally using its own existing plant and assembly line. He had requested you to carry out a detailed study on the financial impact of his proposal. The company decided to incorporate a new company (CH Trading Son. Bhd.) for the proposed expansion plan by injecting RM500,000 as share capital of the new subsidiary