Please make excel to show as follow:

Sales Budget for the quarter ending June

Production Budget for the quarter ending June

Direct Materials Budget for the quarter ending June

Direct Labour Budget for the quarter ending June

Please use excel to show it, thank you

Sales April May June Units 67,500 54,000 Unit sellingprioe $6,200 60,750 July 81,000 Actual Sales Volume 3-moths to June 162,200 The desired finished goods inventory for each month is The full absorption cost of the opening finished goods inventory is The variable manufacturing cost of the opening finished goods inventory is Finished goods inventory on April 1 is Materials required to be on hand at the beginning of the month to produce 60% of the next month's sales $4,730 per unit $1,930 per unit 43,2\") units 20% of that month's estimated sales Direct Material used per unit Rotor Blades. Quantity 4 5 Cost per unit $81 $108 Actual Material Used - 3 months to June Rotor Blades 750,800 729,100 Actual cost ofmatetial Used - 3 months to June $48,651,840 $80,883,680 Budgeted Direct Labour time per ma 8 hours Actual Labour Used - 3 months to June 1,662,590 Direct Labour cost per hour $50 Actual cost of labour Used - 3 months to June $70,660,100