Prepare a direct materials budget. SingaStone Industries has adopted the following production budget for the first 4 months of 2019:- Month Units Month Units January 10,000 March 6,000 February 8,000 April 4,000 Each unit requires 5 kgs of raw materials costing $1.50 per kg. On 31 December, 2018, the ending raw materials inventory was 25,000 kgs. Management wants to have a raw materials inventory at the end of each month equal to 45% of next month's production requirements. Required Prepare a direct materials budget by months for the first quarter.

Assessment 2: Tutorial/Lab tasks Computer Lab (Submit in Tutorial 5 - 14 March 2019) Prepare a direct materials budget SingaStone Industries has adopted the following production budget for the first 4 months of 2019: Month anuary February 8,000 10,000 March April 6,000 4,000 ry Each unit requires 5 kgs of raw materials costing $1.50 per kg. On 31 December, 2018, the ending raw materials inventory was 25,000 kgs. Management wants to have a raw materials inventory at the end of each month equal to 45% of next month's production requirements. Required Prepare a direct materials budget by months for the first quarter. The question must be answered in Excel. Handwritten answer will NOT be accepted