Question: Use the goal seek function in Excel to determine how many customer meals ( in total and by product line ) must be sold to

Use the "goal seek" function in Excel to determine how many customer meals (in total and by product line) must be sold to earn
$126,000 in net operating income. Hint: Use the "goal seek" function to change net operating income to $126,000 by changing only
the cell that contains the total number of customer meals sold.
a. How many total meals must be sold to earn $126,000 in net operating income?
Total meals
b. How much total sales is required to earn $126,000 in net operating income?
 Use the "goal seek" function in Excel to determine how many

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!