MGCR-331-F22-S12-Excel4-GoalSeek-DataTable-ANSWERS

.xlsx

School

McGill University *

*We aren’t endorsed by this school

Course

331

Subject

Industrial Engineering

Date

Jan 9, 2024

Type

xlsx

Pages

Uploaded by leo.mars

Use the goal seek to find out what grade is required on exam 4 to obtain a final grade of 80 Exam Grade exam 1 68 set cell: D9 exam 2 79 value: 80 exam 3 81 input cell: D7 exam 4 92 Final grade 80

You have a limonade store and you want to know how many glasses of lemonade you need to sell per year to You know that you want to sell the limonade $3, that you have unit cost of $0.45 anf fixed cost of $45,000. price $3.00 demand 17647 set cell: D10 unit cost $0.45 value: 0 fixed cost $45,000.00 input cell: D5 revenue $52,941.18 variable cost $7,941.18 profit $0.00

break even

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help