Master Budget (P9-57A) InstructionsDue at the end of Week 6 (100 points)1.Complete problem P9-57A from the textbook using the attached template.The templatemust be used to complete this project (no points will be given if submitted in adifferentformat or file).2.You must show your work. This is done by inputting formulas/calculations directly intothe cells where necessary. If formulas/calculations are not used, points may be deducted(a max of 10 points) at the discretion of the instructor.3.The blue shaded areas are for data input.4.Look out for a red triangle in the upper right-hand corner of a cell. If you hover over thecell you will see a hint or instructions for that cell.5.To the right of the budget schedules is the grading area that is beingcalculated as youinput information. Please use this area to see where any mistakes are being made.6.The template begins with the Sales Budget.Thisis not a required schedulebut is includedas you will need to reference this information to complete otherschedules.7.Please make sure to put your name at the top of the sheet AND also save the file withyour name before uploading.8.With the exception of the Budgeted Manufacturing Cost per Unit schedule, round allnumbers to thenearestwhole dollar.9.Helpful Resourcesa.The textbook andPowerPointslides for Chapter 9 include detailed examples ofhow to complete the requiredschedulesb.In My Accounting Lab, on the left side menu, click 'Multimedia Library.' Select'Chapter 9',click 'Select All', and click 'Find Now.' There is a Try it in Excelvideo that you may find usefulc.You can search Youtube for videos explaining how to inputfor