I have attached Microsoft word which displays the scenario and the questions are below. Remember the questions should be answered in Microsoft Excel and any calculations should show the formula of how it is worked out.
1. Write up the stock card for Fertiliser WX12 for the month of April 2017.
Consider the information provided in relation to the control of the stock levels of Fertiliser WX12, complete any calculations you feel are relevant and comment on any action you feel the Manager should be taking.
Briefly discuss the effect that different stock valuation methods can have on the stock valuation in times of rising prices.
2. For each week of June and for the month in total, you are to calculate the total pay for the groundsmen, showing the split between direct and indirect pay for the week and in total for the month. Also, indicate the total of any overtime premium paid in the month.
Explain how you have classified the hours worked into direct and indirect including an explanation of the treatment of overtime premium.