Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

pleas show calculation steps by handwriting, don't use excel please QUESTION 2 ( 25 marks ] Please write and label your answers clearly. Upload your

image text in transcribedimage text in transcribed pleas show calculation steps by handwriting, don't use excel please

QUESTION 2 ( 25 marks ] Please write and label your answers clearly. Upload your WRITTEN answers at the end of QUESTION 2 section (Label your answer properly and make sure the picture (pdf format) is clear for the examiner to read and mark) (a) A robot vacuum company purchases LED light for use in its vacuum production where the production runs at 240 work days per year. These LED lights are purchased from a supplier with ordering cost RM50 per order and the lead time is 5 days. The annual holding cost rate is 30% of the unit price. Sales unit for robot vacuum cleaner for 4 years with calculated seasonal index is shown in Table Q2a: Months (quarter) Jan - March April - June July - September October - December Table Q2a Year 1 Year 2 Year 3 64 66 68 103 103 104 152 160 162 73 72 78 Year 4 73 120 176 88 Seasonal Index 0.67 1.04 1.57 0.73 i- Forecast the number of unit sales for each of the quarter in year 5 (with seasonal effects) (10) ii- The company would like to know the optimal production quantity for year 5(with seasonal effects) if the cost of the LED light is RM5 per unit (set). (3) iii-What is the total inventory cost for that year (year 5)? iv-Assuming the future sales will be almost constant, determine the reorder point and the number of orders per year to be placed for year 5. (5) QUESTION 2 ( 25 marks ] Please write and label your answers clearly. Upload your WRITTEN answers at the end of QUESTION 2 section (Label your answer properly and make sure the picture (pdf format) is clear for the examiner to read and mark) (a) A robot vacuum company purchases LED light for use in its vacuum production where the production runs at 240 work days per year. These LED lights are purchased from a supplier with ordering cost RM50 per order and the lead time is 5 days. The annual holding cost rate is 30% of the unit price. Sales unit for robot vacuum cleaner for 4 years with calculated seasonal index is shown in Table Q2a: Months (quarter) Jan - March April - June July - September October - December Table Q2a Year 1 Year 2 Year 3 64 66 68 103 103 104 152 160 162 73 72 78 Year 4 73 120 176 88 Seasonal Index 0.67 1.04 1.57 0.73 i- Forecast the number of unit sales for each of the quarter in year 5 (with seasonal effects) (10) ii- The company would like to know the optimal production quantity for year 5(with seasonal effects) if the cost of the LED light is RM5 per unit (set). (3) iii-What is the total inventory cost for that year (year 5)? iv-Assuming the future sales will be almost constant, determine the reorder point and the number of orders per year to be placed for year 5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

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

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions