Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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)....

1 answer below »
Solve
        Table 1: Fiancial results from August XXXXXXXXXX)
        REVENUE    AUGUST    SEPTEMBER    OCTOBER    NOVEMBER    DECEMBER
    1    Wedding Invitations    $4,507.00    $4,697.20    $4,895.42    $5,102.00    $5,317.31
    2    Birthday Party Invitations    $3,841.00    $4,195.14    $4,581.93    $5,004.39    $5,465.79
    3    Business Party Invitations    $2,652.00    $2,744.02    $2,839.24    $2,937.76    $3,039.70
    4    TOTAL SALES REVENUE    $11,000.00    $11,636.36    $12,316.59    $13,044.15    $13,822.80
    5    EXPENSES
    6    Printing Costs    $4,400.00    $4,654.54    $4,926.64    $5,217.66    $5,529.12
    7    Salaries    $3,500.00    $3,500.00    $3,500.00    $3,500.00    $3,500.00
    8    Administration    $550.00    $581.82    $615.83    $652.21    $691.14
    9    Adverstising    $1,544.00    $1,629.54    $1,719.81    $1,815.09    $1,915.65
    10    Legal Fees    $788.00    $820.23    $853.78    $888.70    $925.04
    11    Shipping    $928.00    $966.70    $966.70    $966.70    $966.70
    12    TOTAL EXPENSES    $11,710.00    $12,152.83    $12,582.75    $13,040.35    $13,527.65
    13    Net Income before Taxes    ($710.00)    ($516.47)    ($266.16)    $3.80    $295.15
    14    Taxes    0    0    0    $1.06    $82.64
    14    Net Profit (loss)    ($710.00)    ($516.47)    ($266.16)    $2.74    $212.51
    #    PROJECTED GROWTH PER MONTH    %
    2    Wedding Invitations    4.22
    3    Birthday Party Invitations    9.22
    4    Business Party Invitations    3.47
    5    Adverstising    5.54
    6    Legal Fees    4.09
    7    Shipping    4.17
    8    December Increase Goal    20.08
Groupe Assignment
    Group    Wedding Invitations    Birthday Party Invitations    Business Party Invitations    Advertising    Legal Fees    Shipping    December Goals Increas
    #    A    B    C    D    E    F    G
    1    4.22    9.22    3.47    5.54    4.09    4.17    20.08
    2    3.74    8.22    5.89    4.2    3.68    6.66    19.93
    3    4.17    9.37    4.21    6.74    3.62    6.66    20.92
    4    4.77    8.44    3.85    5.47    2.8    6.66    18.47
    5    5.24    7.88    5.89    5.89    3.44    4.22    19.12
    6    3.55    8.33    4.75    5.92    2.81    5.21    18.92
    7    4.56    8.21    3.69    5.47    3.44    4.5    19.53
    8    5.73    8.65    4.37    4.29    3.98    5.34    19.21
    9    5.83    8.44    4.77    5.89    3.12    5.8    20.16
    10    4.3    9.38    4.56    6.47    3.45    5.34    19.54
    11    4.22    8.21    4.56    4.99    3.21    4.01    20.42
    12    5.24    7.92    5.55    5.68    4.64    5.26    18.34
    13    4.51    8.65    4.11    4.99    2.8    6.74    20.08
    14    4.71    7.88    5.08    4.68    2.15    6.86    19.16
    15    4.77    7.57    5.9    5.65    3.4    4.24    19.31
    16    5.44    8.42    3.06    4.19    4.41    6.96    20.54
    17    5.66    7.61    5.4    4.29    3.21    6.54    18.36
    18    3.51    9.06    4.86    4.41    3.47    5.74    20.88
    19    5.85    8.34    5.47    6.36    3.49    5.88    18.57
    20    4.18    7.69    3.27    5.59    2.67    4.28    20.96
    21    5.03    7.15    4.73    6.6    2.89    5.96    20.2
    22    4.99    9.55    3.85    6.88    2.08    4.01    20.86
    23    4.62    9.06    3.53    5.78    4.47    4.82    19.55
    24    5.59    8.82    5.89    6.62    2.66    4.92    20.04
    25    3.83    9.82    5.93    6.25    3.98    5.94    18.34
    26    3.27    7.31    5.63    4.68    3.12    5.74    18.22
    27    5.28    9.99    3.06    4.17    4.31    4.39    19.75
    28    4.69    9.42    4.34    4.37    2.51    5.6    19.28
    29    3.27    7.19    4.37    4.43    2.16    5.12    18.27
    30    4.72    9.28    4.94    6.05    4.78    4.75    20.72
    31    4.65    7.31    3.54    5.64    2.33    4.15    18.58
    32    5.73    8.27    3.69    4.36    2.46    6.51    18.82
    33    4.38    9.51    4.81    4.21    4.79    5.35    19.85
    34    4.98    7.19    3.3    5.47    3.92    4.37    18.79
    35    5.6    7.53    5.63    4.76    3.06    4.22    19.67
Answered Same Day Sep 17, 2022

Solution

Rochak answered on Sep 17 2022
77 Votes
Solve
        Table 1: Fiancial results from August 2019 (000)
        REVENUE    AUGUST    SEPTEMBER    OCTOBER    NOVEMBER    DECEMBER
    1    Wedding Invitations    $4,507.00    $5,054.43    $5,668.36    $6,356.85    $7,128.98
    2    Birthday Party Invitations    $3,841.00    $4,307.54    $4,830.74    $5,417.50    $6,075.53
    3    Business Party Invitations    $2,652.00    $2,974.12    $3,335.36    $3,740.49    $4,194.82
    4    TOTAL SALES REVENUE    $11,000.00    $12,336.09    $13,834.47    $15,514.84    $17,399.32
    5    EXPENSES
    6    Printing Costs    $4,400.00    $4,400.00    $4,400.00    $4,400.00    $4,400.00
    7    Salaries    $3,500.00    $3,500.00    $3,500.00    $3,500.00    $3,500.00
    8    Administration    $550.00    $550.00    $550.00    $550.00    $550.00
    9    Adverstising    $1,544.00    $1,544.00    $1,544.00    $1,544.00    $1,544.00
    10    Legal Fees    $788.00    $788.00    $788.00    $788.00    $788.00
    11    Shipping    $928.00    $928.00    $928.00    $928.00    $928.00
    12    TOTAL...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here