Using Excel to Divide Income With a Salary Allowance and Fixed Ratios PROBLEM PFW Co. allows salary allowances to its partners. It reports the following net income and provides the following income Net income for year Salary allowance for Pitts Salary allowance for Filbert Salary allowance for Witten Income ratio - Pitts Income ratio - Filbert Income ratio - Witten Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references or the SUM function to the Problem or work area as indicated. Indicate the division of net income to each partner. $ 45,000 15,000 5,000 5,000 50% Net income 30% Salary allowance 20% Pitts Filbert Witten Remaining net income Fixed ratio Pitts Division of Net Income Pitts Filbert Witten Total $ 45,000 Filbert Witten Total division of net income