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

Calculate the projected income for 2021 and perform a sensitive analysis for the projected change Develetech Sales Projections Totals Sales 2020 $1,560,000 Projected Increase 2021 2% Expenses 2021 $1,500 Projected Income 2021 $1,581,900 Projected Change Projected increase 2021 $1,581,900 1.0% 1.5% 2.0% 2.5% 3.0% 3.5% 4.0% 4.5% 5.0%

This is a one-way data table. Values to enter are organized in a column Column input cell is D7

Calculate the projected income for 2021 and perform a sensitive analysis for the projected change Develetech Sales Projections Totals Sales 2020 $1,560,000 Projected Increase 2021 2% 10% Projected Income 2021 $1,427,400 Projected Change Projec $1,427,400 5% 10% 1.0% 1.5% 2.0% 2.5% 3.0% 3.5% 4.0% 4.5% 5.0% Projected Expenses 2021 (as a percent of previous year sales) Projected increase 2021

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

This is a two-way data table. Values to enter are organized in a column (projected increase) and in a row (projected expenses) Row input cell is D8 Column input cell is D7 cted Expense for 2021 15% 20% 25%

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

Related Documents