Shown below is a partially completed MPS record for ball bearings. a. Develop the MPS for ball bearings. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: Ball bearings Order Policy: 500 units Lead Time: 1 week Quantity Week on Hand: 400 1 2 3 4 5 6 7 8 9 10 Forecast 550 250 400 500 350 350 250 250 400 450 Customer 300 350 250 200 250 150 150 50 100 100 orders (booked) Projected on-hand 350 0 100 100 inventory MPS quantity 500 0 500 500 MPS start 0 500 500 500 Available-to- promise (ATP) 250 0 250 300 inventory

On the Data Tables - Student tab in your Excel spreadsheet, update the given information section of the Income Statement for Hello Company with the data below:   Income Statement Product A   Product B   Product C   Max Capacity Units   42,000       7,000       3,000       52,000   Price per unit $ 11.00     $ 8.00     $ 60.00           Variable expense per unit $ 4.00     $ 2.00     $ 20.00           Total Fixed Costs $ 20,000     $ 40,000     $ 10,000               Required: 2. Using the Data Table What-If Analysis tool in Excel, determine the Units and Operating Income (Loss) for each product based on the following scenarios. (Hint: Don't forget that the warehouse can only hold up to 52,000 units.)   Scenario 1: Pete wants to find the mix of units that will result in the highest overall Operating Income, perform this analysis using a two variable data table. Product A can vary between 39,000 units and a maximum of 44,000 units. Product B can vary between 5,000 units…

Answer BOTH of the required questions

help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working