The range of glasses that are available on has been steadily increasing over the years. the glasses, the cases that hold them for s transportation have also increased. These n and feel just as stylish as the contents insic Dunlow Ltd has only recently expanded 1 Cenario: Dunlow Ltd range (cases 13 ) and is now considering unlow Ltd has been manufacturing designer three new cases to its current range (case spectacle/glasses cases for over 35 years now. er information to be taken into consideration: forecasted sales units for the coming year expected to be as follows: Case 1:10,500, ase 2:8,750, Case 3:15,750, Case 4:6,500, ase 5:4,500, Case 6:10,750. hile there were only three cases (1-3) ing made, there was no issue regarding the ailability of the direct materials needed for pduction. Since the expansion of the range of ses (4-6), this is going to result in a restriction the availability of the direct materials to 0,000kg for the coming year. produce all six types of cases, Dunlow Ltd will ed to employ a labour force with the same skill . The concern that Dunlow Ltd has is that only 000 hours of direct labour are available for next 12 months. fixed overheads for the period are expected e approximately R1,350,000 and are orbed using the basis of number of units iuced. Practical tasks Use a spreadsheet to complete the follo 1 Calculate whether the direct materials direct labour will be a cause for concer shortfall in its availability. 2 Calculate the contribution per unit for type and show the order of priority for using the ranking method. 3 Produce a production plan which clear demonstrates the number of units tha made of each case type. 4 Calculate the profit that will be achiev Dunlow Ltd after the production plan i Task 3 is adhered to. Research and presentation Using PowerPoint, provide the following 5 Prepare and present a PowerPoint pre to the production manager and the re management team of what other issu arise from carrying out the production suggested in Task 3. Hint: Consider both quantitative and que reasons. The range of glasses that are available on has been steadily increasing over the years. the glasses, the cases that hold them for s transportation have also increased. These n and feel just as stylish as the contents insic Dunlow Ltd has only recently expanded 1 Cenario: Dunlow Ltd range (cases 13 ) and is now considering unlow Ltd has been manufacturing designer three new cases to its current range (case spectacle/glasses cases for over 35 years now. er information to be taken into consideration: forecasted sales units for the coming year expected to be as follows: Case 1:10,500, ase 2:8,750, Case 3:15,750, Case 4:6,500, ase 5:4,500, Case 6:10,750. hile there were only three cases (1-3) ing made, there was no issue regarding the ailability of the direct materials needed for pduction. Since the expansion of the range of ses (4-6), this is going to result in a restriction the availability of the direct materials to 0,000kg for the coming year. produce all six types of cases, Dunlow Ltd will ed to employ a labour force with the same skill . The concern that Dunlow Ltd has is that only 000 hours of direct labour are available for next 12 months. fixed overheads for the period are expected e approximately R1,350,000 and are orbed using the basis of number of units iuced. Practical tasks Use a spreadsheet to complete the follo 1 Calculate whether the direct materials direct labour will be a cause for concer shortfall in its availability. 2 Calculate the contribution per unit for type and show the order of priority for using the ranking method. 3 Produce a production plan which clear demonstrates the number of units tha made of each case type. 4 Calculate the profit that will be achiev Dunlow Ltd after the production plan i Task 3 is adhered to. Research and presentation Using PowerPoint, provide the following 5 Prepare and present a PowerPoint pre to the production manager and the re management team of what other issu arise from carrying out the production suggested in Task 3. Hint: Consider both quantitative and que reasons