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
Solver Table 1: Fiancial results from August 2019 (000) REVENUEAUGUSTSEPTEMBEROCTOBERNOVEMBERDECEMBER 1Wedding Invitations$4,507.00$4,697.20$4,895.42$5,102.00$5,317.31 2Birthday Party Invitations$3,841.00$4,195.14$4,581.93$5,004.39$5,465.79 3Business Party Invitations$2,652.00$2,744.02$2,839.24$2,937.76$3,039.70 4TOTAL SALES REVENUE$11,000.00$11,636.36$12,316.59$13,044.15$13,822.80 5EXPENSES 6Printing Costs$4,400.00$4,654.54$4,926.64$5,217.66$5,529.12 7Salaries$3,500.00$3,500.00$3,500.00$3,500.00$3,500.00 8Administration$550.00$581.82$615.83$652.21$691.14 9Adverstising$1,544.00$1,629.54$1,719.81$1,815.09$1,915.65 10Legal Fees$788.00$820.23$853.78$888.70$925.04 11Shipping$928.00$966.70$966.70$966.70$966.70 12TOTAL EXPENSES$11,710.00$12,152.83$12,582.75$13,040.35$13,527.65 13Net Income before Taxes($710.00)($516.47)($266.16)$3.80$295.15 14Taxes000$1.06$82.64 14Net Profit (loss)($710.00)($516.47)($266.16)$2.74$212.51 #PROJECTED GROWTH PER MONTH% 2Wedding Invitations4.22 3Birthday Party Invitations9.22 4Business Party Invitations3.47 5Adverstising5.54 6Legal Fees4.09 7Shipping4.17 8December Increase Goal20.08 Groupe Assignment GroupWedding InvitationsBirthday Party InvitationsBusiness Party InvitationsAdvertisingLegal FeesShippingDecember Goals Increas #ABCDEFG 14.229.223.475.544.094.1720.08 23.748.225.894.23.686.6619.93 34.179.374.216.743.626.6620.92 44.778.443.855.472.86.6618.47 55.247.885.895.893.444.2219.12 63.558.334.755.922.815.2118.92 74.568.213.695.473.444.519.53 85.738.654.374.293.985.3419.21 95.838.444.775.893.125.820.16 104.39.384.566.473.455.3419.54 114.228.214.564.993.214.0120.42 125.247.925.555.684.645.2618.34 134.518.654.114.992.86.7420.08 144.717.885.084.682.156.8619.16 154.777.575.95.653.44.2419.31 165.448.423.064.194.416.9620.54 175.667.615.44.293.216.5418.36 183.519.064.864.413.475.7420.88 195.858.345.476.363.495.8818.57 204.187.693.275.592.674.2820.96 215.037.154.736.62.895.9620.2 224.999.553.856.882.084.0120.86 234.629.063.535.784.474.8219.55 245.598.825.896.622.664.9220.04 253.839.825.936.253.985.9418.34 263.277.315.634.683.125.7418.22 275.289.993.064.174.314.3919.75 284.699.424.344.372.515.619.28 293.277.194.374.432.165.1218.27 304.729.284.946.054.784.7520.72 314.657.313.545.642.334.1518.58 325.738.273.694.362.466.5118.82 334.389.514.814.214.795.3519.85 344.987.193.35.473.924.3718.79 355.67.535.634.763.064.2219.67