Question: Your worksheet SOLVER should look like: table [ [ A , , c , D , E , F , G ] , [
Your worksheet "SOLVER" should look like:
tableAcDEFGTable : Financial results for August REVENUE,August,September,October,November,DecemberWedding Invitations,Birthday Party Invitations,Business Party Invitations,TOTAL SALES REVENUES,EXPENSES,,,,,Printing Costs,Salaries,Administration,Advertising,Legal Fees,Shipping,TOTAL EXPENSES,Net Income before Taxes,Taxes,Net Profit loss#PROJECTED GROWTH PER MdWedding Invitations,Birthday Party Invitations,Business Party Invitations,Advertising,SOLVER,,,Legal Fees,GOAL,,,Shipping,December Increase Goal,
Use the NET Profit value for December cell G and calculate your objective value for improved December result. The increase for your group is in column G see Table Group Assignment above Store the desired value in cell D
Use Excel Solver to manipulate projected growth per month cells C:C to achieve the December goal calculated and stored in cell D
Save the Solver solution.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
