Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I really need help on these exercises. All the answers I've seen on Chegg for this problem are wrong when ExcelNow! grades them. Thanks! B

image text in transcribedI really need help on these exercises. All the answers I've seen on Chegg for this problem are wrong when ExcelNow! grades them.

Thanks!

B D F G 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%. Sales Tax % Net Income 29.45% Inputs Revenue Sales Tax Transaction Fee Cost of Goods Sold Cost of Labor $150,000 8.25% 2.30% $70,000 $20,000 Outputs Total Cost Net Income after Tax % Net Income 7.00% 7.25% 7.50% 7.75% 8.00% 8.25% 8.50% 8.75% 9.00% 9.25% 9.50% $105,825 $44,175 29.45% Exercise 2: Fill in the data table below to see how the % Net Income and Net Income After Tax change as the Revenue changes from $130,000 to $180,000 in increments of $5,000. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 Revenue % Net Income 29.45% Net Income after Tax $44,175 $130,000 $135,000 $140,000 $145,000 $150,000 $155,000 $160,000 $165,000 $170,000 $175,000 $180,000 Exercise 3: Fill in the data table below to see how Total Cost changes as the Transaction Fee changes from 2.0% to 3.0% in increments of 0.10% (in column B) and the Cost of Labor changes from $18,000 to $21,000 in increments of $1000 (in row 46). Cost of Labor Transaction Fee $18,000 $19,000 $20,000 $21,000 51 52 53 54 55 56 57 58 2.00% 2.10% 2.20% 2.30% 2.40% 2.50% 2.60% 2.70% 2.80% 2.90% 3.00% 59

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Estimating

Authors: Rodney D. Stewart

2nd Edition

0471857076, 978-0471857075

More Books

Students also viewed these Accounting questions