Exercise 1: The model below calculates several outputs from the given inputs. (This model is used...

 

Transcribed Image Text:

Exercise 1: The model below calculates several outputs from the given inputs. (This model is used in all of the exercises.) Fill in the data table to its right to see how the % Net Income changes as the Sales Tax changes from 7.0% to 9.5% in increments of 0.25%. Inputs Revenue Sales Tax $150,000 Sales Tax % Net Income 29.45% 8.25% 7.00% Transaction Fee 2.30% 7.25% Cost of Goods Sold $70,000 7.50% Cost of Labor $20,000 7.75% 8.00% Outputs 8.25% Total Cost $105,825 8.50% Net Income after Tax $44,175 8.75% % Net Income 29.45% 9.00% 9.25% 9.50% Exercise 1: The model below calculates several outputs from the given inputs. (This model is used in all of the exercises.) Fill in the data table to its right to see how the % Net Income changes as the Sales Tax changes from 7.0% to 9.5% in increments of 0.25%. Inputs Revenue Sales Tax $150,000 Sales Tax % Net Income 29.45% 8.25% 7.00% Transaction Fee 2.30% 7.25% Cost of Goods Sold $70,000 7.50% Cost of Labor $20,000 7.75% 8.00% Outputs 8.25% Total Cost $105,825 8.50% Net Income after Tax $44,175 8.75% % Net Income 29.45% 9.00% 9.25% 9.50%