The range of glasses that are availab EMPLOYABILTY has been steadily increasing over the y the glasses, the cases that hold them transportation have also increased. Th and feel just as stylish as the contents Dunlow Ltd has only recently expan Scenario: Dunlow Ltd range (cases 13 ) and is now conside unlow Ltd has been manufacturing designer three new cases to its current range spectacle/glasses cases for over 35 years now. Further information to be taken into consideration: a. The forecasted sales units for the coming year are expected to be as follows: Case 1: 10,500, Case 2: 8,750 , Case 3: 15,750, Case 4:6,500, Case 5: 4,500, Case 6: 10,750. b. While there were only three cases (1-3) being made, there was no issue regarding the availability of the direct materials needed for production. Since the expansion of the range of cases (4-6), this is going to result in a restriction in the availability of the direct materials to 100,000kg for the coming year. c. To produce all six types of cases, Dunlow Ltd will need to employ a labour force with the same skill set. The concern that Dunlow Ltd has is that only 70,000 hours of direct labour are available for Practical tasks Use a spreadsheet to complete the 1 Calculate whether the direct mate direct labour will be a cause for cc shortfall in its availability. 2 Calculate the contribution per unit type and show the order of priority using the ranking method. 3 Produce a production plan which demonstrates the number of units made of each case type. 4 Calculate the profit that will be ac Dunlow Ltd after the production p Task 3 is adhered to. The range of glasses that are availat has been steadily increasing over the the glasses, the cases that hold them transportation have also increased. Th Scenario: Dunlow Ltd and feel just as stylish as the content Dunlow Ltd has only recently expar unlow Ltd has been manufacturing designer range (cases 1-3) and is now consid spectacle/glasses cases for over 35 years now. three new cases to its current range Further information to be taken into consideration: a. The forecasted sales units for the coming year are expected to be as follows: Case 1: 10,500, Case 2: 8,750 , Case 3:15,750, Case 4: 6,500, Case 5:4,500, Case 6:10,750. b. While there were only three cases (1-3) being made, there was no issue regarding the availability of the direct materials needed for production. Since the expansion of the range of cases (4-6), this is going to result in a restriction in the availability of the direct materials to 100,000kg for the coming year. c. To produce all six types of cases, Dunlow Ltd will need to employ a labour force with the same skill set. The concern that Dunlow Ltd has is that only 70,000 hours of direct labour are available for the next 12 months. d. The fixed overheads for the period are expected to be approximately R1,350,000 and are absorbed using the basis of number of units produced. Practical tasks Use a spreadsheet to complete the 1 Calculate whether the direct mate direct labour will be a cause for c shortfall in its availability. 2 Calculate the contribution per uni type and show the order of priorit using the ranking method. 3 Produce a production plan which demonstrates the number of unit made of each case type. 4 Calculate the profit that will be ac Dunlow Ltd after the production Task 3 is adhered to. Research and presentation Using PowerPoint, provide the follo 5 Prepare and present a PowerPoir to the production manager and tt management team of what other arise from carrying out the produ suggested in Task 3. Hint: Consider both quantitative an reasons. The range of glasses that are availab EMPLOYABILTY has been steadily increasing over the y the glasses, the cases that hold them transportation have also increased. Th and feel just as stylish as the contents Dunlow Ltd has only recently expan Scenario: Dunlow Ltd range (cases 13 ) and is now conside unlow Ltd has been manufacturing designer three new cases to its current range spectacle/glasses cases for over 35 years now. Further information to be taken into consideration: a. The forecasted sales units for the coming year are expected to be as follows: Case 1: 10,500, Case 2: 8,750 , Case 3: 15,750, Case 4:6,500, Case 5: 4,500, Case 6: 10,750. b. While there were only three cases (1-3) being made, there was no issue regarding the availability of the direct materials needed for production. Since the expansion of the range of cases (4-6), this is going to result in a restriction in the availability of the direct materials to 100,000kg for the coming year. c. To produce all six types of cases, Dunlow Ltd will need to employ a labour force with the same skill set. The concern that Dunlow Ltd has is that only 70,000 hours of direct labour are available for Practical tasks Use a spreadsheet to complete the 1 Calculate whether the direct mate direct labour will be a cause for cc shortfall in its availability. 2 Calculate the contribution per unit type and show the order of priority using the ranking method. 3 Produce a production plan which demonstrates the number of units made of each case type. 4 Calculate the profit that will be ac Dunlow Ltd after the production p Task 3 is adhered to. The range of glasses that are availat has been steadily increasing over the the glasses, the cases that hold them transportation have also increased. Th Scenario: Dunlow Ltd and feel just as stylish as the content Dunlow Ltd has only recently expar unlow Ltd has been manufacturing designer range (cases 1-3) and is now consid spectacle/glasses cases for over 35 years now. three new cases to its current range Further information to be taken into consideration: a. The forecasted sales units for the coming year are expected to be as follows: Case 1: 10,500, Case 2: 8,750 , Case 3:15,750, Case 4: 6,500, Case 5:4,500, Case 6:10,750. b. While there were only three cases (1-3) being made, there was no issue regarding the availability of the direct materials needed for production. Since the expansion of the range of cases (4-6), this is going to result in a restriction in the availability of the direct materials to 100,000kg for the coming year. c. To produce all six types of cases, Dunlow Ltd will need to employ a labour force with the same skill set. The concern that Dunlow Ltd has is that only 70,000 hours of direct labour are available for the next 12 months. d. The fixed overheads for the period are expected to be approximately R1,350,000 and are absorbed using the basis of number of units produced. Practical tasks Use a spreadsheet to complete the 1 Calculate whether the direct mate direct labour will be a cause for c shortfall in its availability. 2 Calculate the contribution per uni type and show the order of priorit using the ranking method. 3 Produce a production plan which demonstrates the number of unit made of each case type. 4 Calculate the profit that will be ac Dunlow Ltd after the production Task 3 is adhered to. Research and presentation Using PowerPoint, provide the follo 5 Prepare and present a PowerPoir to the production manager and tt management team of what other arise from carrying out the produ suggested in Task 3. Hint: Consider both quantitative an reasons