To answer 2 questions of management account article

Using the information in the attached file, answer questions 1 on pages 3 of the case study. Further, prepare a second set of production and purchase budget for a constant production of 3,000 trailers per month as mentioned in question 3. Do not answer anything else from questions 2, 3 and 4. Use MS Excel to complete the solution. Show appropriate formulas in the cells to support your numbers.