Question: Your worksheet SOLVER should look like: table [ [ A , , c , D , E , F , G ] , [

Your worksheet "SOLVER" should look like:
\table[[A,,c,D,E,F,G],[Table 1: Financial results for August 2019(000),,,],[,REVENUE,August,September,October,November,December],[?bar(1),Wedding Invitations,4,507,4,704,4,910,5,126,5,360],[2,Birthday Party Invitations,3,841,4,206,4,606,5,044,5,524],[3,Business Party Invitations,2,652,2,780,2,913,3,053,3,200],[4,TOTAL SALES REVENUES,11,000,11,690,12,430,13,223,14,074],[5,EXPENSES,,,,,],[6,Printing Costs,4,400,4,676,4,972,5,289,5,630],[7,Salaries,3,500,3,500,3,500,3,500,3,500],[8,Administration,550,585,622,661,,704],[9,Advertising,1,544,1,609,1,677,1,747,1,821],[10,Legal Fees,788,,826,865,907,950],[11,Shipping,928,978,1,030,1,085,1,143],[12,TOTAL EXPENSES,11,710,12,173,12,665,13,190,13,748],[13,Net Income before Taxes,-710,-10,-483,-235,34,327],[14,Taxes,0,0,0,9,91],[14,Net Profit (loss),-710,-483,-235,24,235],[#,PROJECTED GROWTH PER Md,%,,,,],[2,Wedding Invitations,4.38,,,,],[3,Birthday Party Invitations,9.51,,,,],[4,4-2.2.,Business Party Invitations,4.81,,,,],[5,Advertising,4.21,SOLVER,,,],[6,Legal Fees,4.79,GOAL,,,],[7,Shipping,5.35,,,,],[,December Increase Goal,19.85,281.93,,,]]
Use the NET Profit value for December (cell G20) and calculate your objective value for improved December result. The increase % for your group is in column G (see Table 2 Group Assignment above). Store the desired value in cell D30.
Use Excel Solver to manipulate projected growth per month (cells C24:C29) to achieve the December goal calculated and stored in cell D30.
Save the Solver solution.
 Your worksheet "SOLVER" should look like: \table[[A,,c,D,E,F,G],[Table 1: Financial results for

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 General Management Questions!