I need help for the following question. Please solve in excel and show formula sheet please. I want excel soln with formula sheet showing. Solve all parts.

6. The following data have been prepared for master production scheduling purposes at the Shaster Golf Club Company. Assume 40 hours per week for the assembly-line capacity. END PRODUCT BEGINNING INVENTORY WEEKLY FORECAST LOT SIZE HOURS PER LOT SIZE A B 60 20 30 10 5 15 30 20 50 30 20 50 Current capacity = 40 hours per week a. Prepare the master production schedule for these items during the next four weeks using a scheduling method of your choice. b. Should Shaster Company increase or decrease the capacity of the final assembly line? Justify your answer. c. Suppose that the Shaster master production schedule is frozen for the next three weeks. What specific impact would the policy have on the firm's performance