NOTE: please just help me with what can be done and I can resubmit the rest into another question.

Up to here is what I will like help on if possible the rest is just for more info and can resubmit like said before.

Parts A and b for the question.

----------------------------------------------------------------------------------------------------------

This is the budget sheet in excel: As you can see I have tried to create it but may be wrong.

And this is the place to do the assumptions:

You will probably have to recreate on excel these because cannot share the excel file here due to policy I think.

since link.

----------------------------------------------------------------------------

-----------------------------------------------------------------------------

This is parts c and d.

This here is just the stuff to keep in mind and or that can help on the first two parts:

Introduction "NYP," New York Paper Co., is using its financial results for August 2019 (Table 1) as a base for projecting the company's budget for the remaining four months of the year (September- December). Table 1: Financial results for August 2019 (000) REVENUE August Wedding Invitations 4,507 Birthday Party Invitations 3,841 Business Party Invitations 2,652 Total Sales Revenue 11,000 EXPENSES Printing Costs Salaries Administration Advertising Legal Fees Shipping Total Expenses 4,400 3,500 550 1,544 788 928 11,710 Net Income before Taxes Taxes Net Profit (loss) -710 0 -710 Enter the figures for August of 2019 in your worksheet BUDGET" in the workbook "GROUP ## EXCEL GROUP PROJECT SPRING 22". Make sure that you use formulas where appropriate for this base month. All figures should be expressed in thousands of dollars (000), amounts should be formatted with commas and no decimals. Assumptions/Assignments Following are the assumptions/assignments about how expenses relate to revenues and the growth assumptions for the next four months. These assumptions/assignments are unique for each group. Using wrong assumptions/assignments will cause zero 0 grade for the project. Table 2 below presents a partial example of the assignments. The complete table is found in the worksheet GROUP ASSIGNMENTS in the workbook GROUP ## EXCEL GROUP PROJECT SPRING 22". Table 2 Group Assignments We ddi ng Invi tati ons Bir thd ay Par ty Invi tati Bu sin ess Par ty Invi tati ons Dec emb er Goal Incr ease ro 02-2 ons # A 5.4 4 5.0 3 G Ad ver tisi ng D 4.1 9 6.6 0 B 8.4 2 7.1 5 Leg al Fee S E 4.4 1 2.8 9 3.0 6 4.7 3 1 Sh ippi ng F 6.9 6 5.9 6 20.5 4 20.2 0 2 Projected Growth Per Month1 Use VLOOKUP to copy group's individual assignments/growth assumptions to your worksheet. Place them all together in the lower left corner of your BUDGET" Worksheet with a boxed outline. 8.65 Table 3 Individual Assignments Projected Growth Per Month % Wedding Invitations 4.51 Birthday Party Invitations Business Party Invitations 4.11 Advertising 4.99 Legal Fees 2.80 Shipping 6.74 December Increase Goal 20.08 1. Sales revenue from wedding invitations, birthday party invitations and business party invitations will grow at A% (cell C24), B% (cell C25) and C% (cell C26) per month, respectively. 2. Printing costs are calculated as 40% of Sales Revenue for the month, and Administration expenses are calculated as 5% of the Sales Revenue for the month. 3. Salaries are fixed for the period. Please create an assumption table. 4. The other expense items will grow at the following rates (per month): Advertising will grow at D% (cell C27) per month, Legal Fees will grow at E% (cell C28) per month, and Shipping will grow at F% (cell C29) per month. 5. The tax rate is 28% on profits for the month. Assume that taxes are calculated and paid each month. Note that when the company loses money, it does not pay taxes. 6. Conditional Formatting. If any of the numbers for Net Income before Taxes, Taxes and Net Profit (loss) is greater than 0, then the font for that cell should be green. If any of the numbers for Net Income before Taxes, Taxes and Net Profit (loss) is less than 0, then the font for that cell should be red; otherwise, the font for that cell should be orange. A. Forecast the budget for the next four months of 2019 (Sept-Dec) in a worksheet BUDGET in the workbook GROUP ## EXCEL GROUP PROJECT SPRING 22. Include a footer on this sheet with names of all group members. B. Create a pie chart showing the proportional distribution of expenses in December. Be sure to label the chart well. Save the chart in a worksheet DISTRIBUTION in the workbook GROUP ## EXCEL GROUP PROJECT SPRING 22". The chart should not be "embedded (which looks copied with gridlines in the background), but on a new sheet clearly, large and presentable with all proper labels - similar to the one below: DISTRIBUTION OF EXPENSES IN THOUSANDS IN DECEMBER 2019 Shipping $1,205 9% Legal Fees $880 6% Printing Costs $5,538 Chart Area Advertising $1,876 14% 40% Administration $692 5% Salaries $3,500 26% D E F G B Table 1: Financial results for August 2019 (000) 1 2 3 4 REVENUE Wedding Invitations Birthday Party Invitations Business Party Invitations TOTAL SALES REVENUES August 4,507 3,841 2,652 11,000 September October November December 4,704 4,910 5,126 5,350 4,206 4,606 5,044 5,524 2,780 2,913 3,053 3,200 11,690 12,430 13,223 14,074 5 EXPENSES 6 Printing Costs 7 Salaries 8 Administration 9 Advertising 10 Legal Fees 11 Shipping 12 TOTAL EXPENSES 4,400 3,500 550 1,544 788 928 11,710 4,676 3,500 585 1,609 826 978 12,173 4,972 3,500 622 1,677 865 1,030 12,665 5,289 3,500 661 1,747 907 1,085 13,190 5,630 3,500 704 1,821 950 1,143 13,748 13 Net Income before Taxes 14 Taxes 14 Net Profit (loss) -710 0 -710 -483 0 -483 -235 0 -235 34 9 24 327 91 235 # PROJECTED GROWTH PER M 2 Wedding Invitations 3 Birthday Party Invitations 4 Business Party Invitations 5 Advertising 6 Legal Fees 7 Shipping 8 December Increase Goal % 4.38 9.51 4.81 4.21 4.79 5.35 19.85 SOLVER GOAL 281.93 C38 fx B D E F G H 1 K L M N O P R R Invitations Birthday Party Invitations dnos Business Party Invitations Advertising Legal Fees Shipping Goal Increase Deceember 1 2 # 3 1 2 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 A 5.44 5.03 4.18 3.83 5.66 4.51 4.56 5.83 4.71 4.65 4.17 3.55 5.73 4.22 4.77 5.24 3.27 4.30 4.99 3.74 5.60 3.51 5.59 5.85 4.38 5.28 4.62 4.98 4.69 4.72 5.73 4.22 4.77 5.24 3.27 B 8.42 7.15 7.69 9.82 7.61 8.65 8.21 8.44 7.88 7.31 9.37 8.33 8.27 9.22 7.57 7.92 7.19 9.38 9.55 8.22 7.53 9.06 8.82 8.34 9.51 9.99 9.06 7.19 9.42 9.28 8.65 8.21 8.44 7.88 7.31 3 3 4 4 5 6 7 8 91 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32) 331 34 35 E F G 3.06 4.19 4.41 6.96 20.54 4.73 6.60 2.89 5.96 20.20 3.27 5.59 2.67 4.28 20.96 5.93 6.25 3.98 5.94 18.34 5.40 4.29 3.21 6.54 18.36 4.11 4.99 2.80 6.74 20.08 3.69 5.47 3.44 4.50 19.53 4.77 5.89 3.12 5.80 20.16 5.08 4.68 2.15 6.86 19.16 3.54 5.64 2.33 4.15 18.58 4.21 6.74 3.62 6.66 20.92 4.75 5.92 2.81 5.21 18.92 3.69 4.36 2.46 6.51 18.82 3.47 5.54 4.09 4.17 20.08 5.90 5.65 3.40 4.24 19.31 5.55 5.68 4.64 5.26 18.34 4.37 4.43 2.165.12 18.27 4.56 6.47 3.45 5.34 19.54 3.85 6.88 2.08 4.01 20.86 5.89 4.20 3.68 6.66 19.93 5.63 4.76 3.06 4.22 19.67 4.86 4.41 3.47 5.74 20.88 5.89 6.62 2.66 4.92 20.04 5.47 6.36 3.49 5.88 18.57 4.81 4.21 4.79 5.35 19.85 3.06 4.17 4.31 4.39 19.75 3.53 5.78 4.47 4.82 19.55 3.30 5.47 3.92 4.37 18.79 4.34 4.37 2.51 5.60 19.28 4.94 6.05 4.78 4.75 20.72 4.37 4.29 3.98 5.34 19.21 4.56 4.99 3.21 4.01 20.42 3.85 5.47 2.80 6.66 18.47 5.89 5.89 3.44 4.22 19.12 5.63 4.68 3.12 5.74 18.22 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 > BUDGET GROUP ASSIGNMENTS SOLVER SALES PIVOT TABLE + Calculation Mode: Automatic Workbook Statistics C. After you finished the budget calculations copy the entire worksheet "BUDGET" to a new worksheet "SOLVER". To copy OPEN the PASTE option. When it opens up click the icon in the top row, second from the left Paste to their AAN Paste Values L123 Other Paste Options Nena Paste Special... Your worksheet "SOLVER" should look like: A B D TE F F G Table 1: Financial results for August 2019 (000) 1 2 3 4 REVENUE Wedding Invitations Birthday Party Invitations Business Party Invitations TOTAL SALES REVENUES August 4,507 3,841 2.652 11,000 September October November December 4,704 4,910 5,126 5,350 4,206 4,606 5,044 5,524 2,780 2,913 3,053 3,200 11,690 12,430 13,223 14,074 MT 5 EXPENSES 6 Printing Costs 7 Salaries 8 Administration 9 Advertising 10 Legal Fees 11 Shipping 12 TOTAL EXPENSES 4,400 3,500 550 1,544 788 928 11,710 4,676 3,500 585 1,609 826 978 12,173 4,972 3,500 622 1,677 865 1,030 12,665 5,289 3,500 661 1,747 907 1,085 13,190 5,630 3,500 704 1,821 950 1,143 13,748 TIT 13 Net Income before Taxes 14 Taxes 14 Net Profit (loss) -710 0 0 -710 -483 0 0 -483 -235 0 -235 34 9 24 327 91 235 # PROJECTED GROWTH PER M 2 Wedding Invitations Birthday Party Invitations 4 Business Party Invitations 5 Advertising 6 Legal Fees 7 Shipping 8 December Increase Goal % 4.38 9.51 4.81 4.21 4.79 5.35 19.85 SOLVER GOAL 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. D. Use the data in the "SALES" worksheet to create a PIVOT TABLE. The table must show the amount of sales and the number of units for each representative, for each year (just the year-no month, no day), for each invitation type. Your pivot table should look approximately like the table below. Name the resulting worksheet PIVOT TABLE. Total Sum of Total Total Count of Units 5 Row Labels 6 - Andrews 7 2020 8 2021 9 Gill 10 2020 11 2021 12 = Howard 13 2020 14 2021 15 Jardine 16 2020 17 2021 18 Jones 2020 2021 Kivell 22 2020 23 2021 24 Morgan 25 2020 20 2021 27 Parent 28 2020 29 Smith 30 2020 31 2021 32 Sorvino 33 2020 34 2021 35 - Thompson 36 2020 2021 Grand Total B D G H Column Lab Birthday Business Graduation Wedding Sum of Total Count of Units Sum of Total Count of Units Sum of Total Count of Units Sum of Total Count of Units 29,865 3 3,388 1 14,925 1 14,940 2 3,388 1 7,740 2 49,674 2 5,373 1 5,373 1 7,740 2 49,674 2 5,771 1 47,904 1 5,771 1 47,904 1 62,874 2 19,344 2 24,950 1 62 874 2 19,344 2 24 950 1 26,850 2 37,036 3 3 14,106 2 2 8,640 1 26 850 2 35040 2 2512 1 8640 1 1,996 1 11,594 1 17,450 1 31,344 2. 750 1 17,450 1 1 22.272 1 1 9,072 1 750 1 1 44,910 1 8,792 1 13,696 1 44,910 1 8,792 1 13,695 1 9.234 1 23,458 1 1,455 1 9.234 1 1 23.458 1 1,455 1 8,643 1 130,500 1 500 1 8,843 1 500 1 130,500 1 16,744 1 13,993 1 15,868 2. 16,744 1 13.993 1 1 15,868 2 2 6,368 1 9,804 1 6,368 1 9,804 1 203,994 13 304,986 15 107,553 7 80,490 8. 8 33,253 14,925 18,328 62,787 5,373 57.414 53,675 5.771 47,904 107,168 62,874 44 294 86,632 73042 13,590 49,544 39,722 9,822 67,397 53,702 13,695 34,147 34,147 139,643 9,143 130.500 46,605 16.744 29,861 16,172 6,368 9,804 697,023 1 3 5 1 1 4 2 1 1 5 2 3 8 6 2 4 2 2 3 2 1 3 3 3 2 1 4 1 3 2 43 BUDGET incorrect/missing formulas; hard coded numbers; incorrect formatting and conditional formatting; incorrectly copied assignments/assumptions. PIE CHART - incorrect chart; missing/incorrect labels, titles, legend. SOLVER incorrect formula, incorrect objective, incorrect variables PIVOT TABLE - hard coded table, incomplete table, incorrect fields, required information is missing. Introduction "NYP," New York Paper Co., is using its financial results for August 2019 (Table 1) as a base for projecting the company's budget for the remaining four months of the year (September- December). Table 1: Financial results for August 2019 (000) REVENUE August Wedding Invitations 4,507 Birthday Party Invitations 3,841 Business Party Invitations 2,652 Total Sales Revenue 11,000 EXPENSES Printing Costs Salaries Administration Advertising Legal Fees Shipping Total Expenses 4,400 3,500 550 1,544 788 928 11,710 Net Income before Taxes Taxes Net Profit (loss) -710 0 -710 Enter the figures for August of 2019 in your worksheet BUDGET" in the workbook "GROUP ## EXCEL GROUP PROJECT SPRING 22". Make sure that you use formulas where appropriate for this base month. All figures should be expressed in thousands of dollars (000), amounts should be formatted with commas and no decimals. Assumptions/Assignments Following are the assumptions/assignments about how expenses relate to revenues and the growth assumptions for the next four months. These assumptions/assignments are unique for each group. Using wrong assumptions/assignments will cause zero 0 grade for the project. Table 2 below presents a partial example of the assignments. The complete table is found in the worksheet GROUP ASSIGNMENTS in the workbook GROUP ## EXCEL GROUP PROJECT SPRING 22". Table 2 Group Assignments We ddi ng Invi tati ons Bir thd ay Par ty Invi tati Bu sin ess Par ty Invi tati ons Dec emb er Goal Incr ease ro 02-2 ons # A 5.4 4 5.0 3 G Ad ver tisi ng D 4.1 9 6.6 0 B 8.4 2 7.1 5 Leg al Fee S E 4.4 1 2.8 9 3.0 6 4.7 3 1 Sh ippi ng F 6.9 6 5.9 6 20.5 4 20.2 0 2 Projected Growth Per Month1 Use VLOOKUP to copy group's individual assignments/growth assumptions to your worksheet. Place them all together in the lower left corner of your BUDGET" Worksheet with a boxed outline. 8.65 Table 3 Individual Assignments Projected Growth Per Month % Wedding Invitations 4.51 Birthday Party Invitations Business Party Invitations 4.11 Advertising 4.99 Legal Fees 2.80 Shipping 6.74 December Increase Goal 20.08 1. Sales revenue from wedding invitations, birthday party invitations and business party invitations will grow at A% (cell C24), B% (cell C25) and C% (cell C26) per month, respectively. 2. Printing costs are calculated as 40% of Sales Revenue for the month, and Administration expenses are calculated as 5% of the Sales Revenue for the month. 3. Salaries are fixed for the period. Please create an assumption table. 4. The other expense items will grow at the following rates (per month): Advertising will grow at D% (cell C27) per month, Legal Fees will grow at E% (cell C28) per month, and Shipping will grow at F% (cell C29) per month. 5. The tax rate is 28% on profits for the month. Assume that taxes are calculated and paid each month. Note that when the company loses money, it does not pay taxes. 6. Conditional Formatting. If any of the numbers for Net Income before Taxes, Taxes and Net Profit (loss) is greater than 0, then the font for that cell should be green. If any of the numbers for Net Income before Taxes, Taxes and Net Profit (loss) is less than 0, then the font for that cell should be red; otherwise, the font for that cell should be orange. A. Forecast the budget for the next four months of 2019 (Sept-Dec) in a worksheet BUDGET in the workbook GROUP ## EXCEL GROUP PROJECT SPRING 22. Include a footer on this sheet with names of all group members. B. Create a pie chart showing the proportional distribution of expenses in December. Be sure to label the chart well. Save the chart in a worksheet DISTRIBUTION in the workbook GROUP ## EXCEL GROUP PROJECT SPRING 22". The chart should not be "embedded (which looks copied with gridlines in the background), but on a new sheet clearly, large and presentable with all proper labels - similar to the one below: DISTRIBUTION OF EXPENSES IN THOUSANDS IN DECEMBER 2019 Shipping $1,205 9% Legal Fees $880 6% Printing Costs $5,538 Chart Area Advertising $1,876 14% 40% Administration $692 5% Salaries $3,500 26% D E F G B Table 1: Financial results for August 2019 (000) 1 2 3 4 REVENUE Wedding Invitations Birthday Party Invitations Business Party Invitations TOTAL SALES REVENUES August 4,507 3,841 2,652 11,000 September October November December 4,704 4,910 5,126 5,350 4,206 4,606 5,044 5,524 2,780 2,913 3,053 3,200 11,690 12,430 13,223 14,074 5 EXPENSES 6 Printing Costs 7 Salaries 8 Administration 9 Advertising 10 Legal Fees 11 Shipping 12 TOTAL EXPENSES 4,400 3,500 550 1,544 788 928 11,710 4,676 3,500 585 1,609 826 978 12,173 4,972 3,500 622 1,677 865 1,030 12,665 5,289 3,500 661 1,747 907 1,085 13,190 5,630 3,500 704 1,821 950 1,143 13,748 13 Net Income before Taxes 14 Taxes 14 Net Profit (loss) -710 0 -710 -483 0 -483 -235 0 -235 34 9 24 327 91 235 # PROJECTED GROWTH PER M 2 Wedding Invitations 3 Birthday Party Invitations 4 Business Party Invitations 5 Advertising 6 Legal Fees 7 Shipping 8 December Increase Goal % 4.38 9.51 4.81 4.21 4.79 5.35 19.85 SOLVER GOAL 281.93 C38 fx B D E F G H 1 K L M N O P R R Invitations Birthday Party Invitations dnos Business Party Invitations Advertising Legal Fees Shipping Goal Increase Deceember 1 2 # 3 1 2 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 A 5.44 5.03 4.18 3.83 5.66 4.51 4.56 5.83 4.71 4.65 4.17 3.55 5.73 4.22 4.77 5.24 3.27 4.30 4.99 3.74 5.60 3.51 5.59 5.85 4.38 5.28 4.62 4.98 4.69 4.72 5.73 4.22 4.77 5.24 3.27 B 8.42 7.15 7.69 9.82 7.61 8.65 8.21 8.44 7.88 7.31 9.37 8.33 8.27 9.22 7.57 7.92 7.19 9.38 9.55 8.22 7.53 9.06 8.82 8.34 9.51 9.99 9.06 7.19 9.42 9.28 8.65 8.21 8.44 7.88 7.31 3 3 4 4 5 6 7 8 91 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32) 331 34 35 E F G 3.06 4.19 4.41 6.96 20.54 4.73 6.60 2.89 5.96 20.20 3.27 5.59 2.67 4.28 20.96 5.93 6.25 3.98 5.94 18.34 5.40 4.29 3.21 6.54 18.36 4.11 4.99 2.80 6.74 20.08 3.69 5.47 3.44 4.50 19.53 4.77 5.89 3.12 5.80 20.16 5.08 4.68 2.15 6.86 19.16 3.54 5.64 2.33 4.15 18.58 4.21 6.74 3.62 6.66 20.92 4.75 5.92 2.81 5.21 18.92 3.69 4.36 2.46 6.51 18.82 3.47 5.54 4.09 4.17 20.08 5.90 5.65 3.40 4.24 19.31 5.55 5.68 4.64 5.26 18.34 4.37 4.43 2.165.12 18.27 4.56 6.47 3.45 5.34 19.54 3.85 6.88 2.08 4.01 20.86 5.89 4.20 3.68 6.66 19.93 5.63 4.76 3.06 4.22 19.67 4.86 4.41 3.47 5.74 20.88 5.89 6.62 2.66 4.92 20.04 5.47 6.36 3.49 5.88 18.57 4.81 4.21 4.79 5.35 19.85 3.06 4.17 4.31 4.39 19.75 3.53 5.78 4.47 4.82 19.55 3.30 5.47 3.92 4.37 18.79 4.34 4.37 2.51 5.60 19.28 4.94 6.05 4.78 4.75 20.72 4.37 4.29 3.98 5.34 19.21 4.56 4.99 3.21 4.01 20.42 3.85 5.47 2.80 6.66 18.47 5.89 5.89 3.44 4.22 19.12 5.63 4.68 3.12 5.74 18.22 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 > BUDGET GROUP ASSIGNMENTS SOLVER SALES PIVOT TABLE + Calculation Mode: Automatic Workbook Statistics C. After you finished the budget calculations copy the entire worksheet "BUDGET" to a new worksheet "SOLVER". To copy OPEN the PASTE option. When it opens up click the icon in the top row, second from the left Paste to their AAN Paste Values L123 Other Paste Options Nena Paste Special... Your worksheet "SOLVER" should look like: A B D TE F F G Table 1: Financial results for August 2019 (000) 1 2 3 4 REVENUE Wedding Invitations Birthday Party Invitations Business Party Invitations TOTAL SALES REVENUES August 4,507 3,841 2.652 11,000 September October November December 4,704 4,910 5,126 5,350 4,206 4,606 5,044 5,524 2,780 2,913 3,053 3,200 11,690 12,430 13,223 14,074 MT 5 EXPENSES 6 Printing Costs 7 Salaries 8 Administration 9 Advertising 10 Legal Fees 11 Shipping 12 TOTAL EXPENSES 4,400 3,500 550 1,544 788 928 11,710 4,676 3,500 585 1,609 826 978 12,173 4,972 3,500 622 1,677 865 1,030 12,665 5,289 3,500 661 1,747 907 1,085 13,190 5,630 3,500 704 1,821 950 1,143 13,748 TIT 13 Net Income before Taxes 14 Taxes 14 Net Profit (loss) -710 0 0 -710 -483 0 0 -483 -235 0 -235 34 9 24 327 91 235 # PROJECTED GROWTH PER M 2 Wedding Invitations Birthday Party Invitations 4 Business Party Invitations 5 Advertising 6 Legal Fees 7 Shipping 8 December Increase Goal % 4.38 9.51 4.81 4.21 4.79 5.35 19.85 SOLVER GOAL 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. D. Use the data in the "SALES" worksheet to create a PIVOT TABLE. The table must show the amount of sales and the number of units for each representative, for each year (just the year-no month, no day), for each invitation type. Your pivot table should look approximately like the table below. Name the resulting worksheet PIVOT TABLE. Total Sum of Total Total Count of Units 5 Row Labels 6 - Andrews 7 2020 8 2021 9 Gill 10 2020 11 2021 12 = Howard 13 2020 14 2021 15 Jardine 16 2020 17 2021 18 Jones 2020 2021 Kivell 22 2020 23 2021 24 Morgan 25 2020 20 2021 27 Parent 28 2020 29 Smith 30 2020 31 2021 32 Sorvino 33 2020 34 2021 35 - Thompson 36 2020 2021 Grand Total B D G H Column Lab Birthday Business Graduation Wedding Sum of Total Count of Units Sum of Total Count of Units Sum of Total Count of Units Sum of Total Count of Units 29,865 3 3,388 1 14,925 1 14,940 2 3,388 1 7,740 2 49,674 2 5,373 1 5,373 1 7,740 2 49,674 2 5,771 1 47,904 1 5,771 1 47,904 1 62,874 2 19,344 2 24,950 1 62 874 2 19,344 2 24 950 1 26,850 2 37,036 3 3 14,106 2 2 8,640 1 26 850 2 35040 2 2512 1 8640 1 1,996 1 11,594 1 17,450 1 31,344 2. 750 1 17,450 1 1 22.272 1 1 9,072 1 750 1 1 44,910 1 8,792 1 13,696 1 44,910 1 8,792 1 13,695 1 9.234 1 23,458 1 1,455 1 9.234 1 1 23.458 1 1,455 1 8,643 1 130,500 1 500 1 8,843 1 500 1 130,500 1 16,744 1 13,993 1 15,868 2. 16,744 1 13.993 1 1 15,868 2 2 6,368 1 9,804 1 6,368 1 9,804 1 203,994 13 304,986 15 107,553 7 80,490 8. 8 33,253 14,925 18,328 62,787 5,373 57.414 53,675 5.771 47,904 107,168 62,874 44 294 86,632 73042 13,590 49,544 39,722 9,822 67,397 53,702 13,695 34,147 34,147 139,643 9,143 130.500 46,605 16.744 29,861 16,172 6,368 9,804 697,023 1 3 5 1 1 4 2 1 1 5 2 3 8 6 2 4 2 2 3 2 1 3 3 3 2 1 4 1 3 2 43 BUDGET incorrect/missing formulas; hard coded numbers; incorrect formatting and conditional formatting; incorrectly copied assignments/assumptions. PIE CHART - incorrect chart; missing/incorrect labels, titles, legend. SOLVER incorrect formula, incorrect objective, incorrect variables PIVOT TABLE - hard coded table, incomplete table, incorrect fields, required information is missing