1) Using Goal Seek 2) Fill in the formulas for Net Profit and Actual Profit 3)...

 

Transcribed Image Text:

1) Using Goal Seek 2) Fill in the formulas for Net Profit and Actual Profit 3) Assuming everything else remains the same, how much will I have to charge to make $500 in actual profit Answer Bagel Store Ingredient Cost /unit Rent/Day Labor/Day Price/Unit Units Sold Net Profit Tax Actual Profit 50.25 $75.00 $100.00 $1.00 400 $125.00 15% $106.25 1) Using Goal Seek 2) Fill in the formulas for Net Profit and Actual Profit 3) Assuming everything else remains the same, how much will I have to charge to make $500 in actual profit Answer Bagel Store Ingredient Cost /unit Rent/Day Labor/Day Price/Unit Units Sold Net Profit Tax Actual Profit 50.25 $75.00 $100.00 $1.00 400 $125.00 15% $106.25

Answer rating: 100% (QA)

Step 1 Open you excel spread sheet and enter the given values Step 2 In the Data tab from the data t... View the full answer