23a4 p1 g05 Scor

xlsx

School

Baruch College, CUNY *

*We aren’t endorsed by this school

Course

2200

Subject

Economics

Date

Jan 9, 2024

Type

xlsx

Pages

22

Uploaded by MateComputer16122

Report
Task Execution Allocation Matrix Member responsibility codes: Primary: write Prime Performed m Secondary: write Sec Corrected, ed Matrix completion instructions and required distribution of responsibilities: Initialization: Whoever opens this workbook first fills in the group's number in cell O All group members fill in their first and last names in range F18:N19 in The group is collectively responsible for ensuring that Planning: Each group member codes or leaves blank their activity for a given ste Distribute responsibilities so that each member is a primary on at leas prelim: This task has one primary and up to two Step A: Each task has one primary and one secon Steps B-E: Each step can have up to two primary an Execution: If member(s) do not execute their selected tasks, other member(s) wh Regardless of the distribution of tasks, all members are jointly respons 1 2 Prime 2 3 2 3 Sec 3 2 3 2 Group Member #: 1 2 3 4 First: Awa Charles Prabin Rayya Last: Lowe Robbins Shrestha Tabina S# Step Task 1 prelim 0.1 Lookup table 2 A 1.1 Wedding Sec Sec 3 A 1.2 Birthday party Prime Sec 4 A 1.3 Business party Prime 5 A 2.1 Printing Prime 6 A 2.2 Admin 7 A 3.1 Salaries 8 A 4.1 Advertising Prime 9 A 4.2 Legal Sec 10 A 4.3 Shipping Sec 11 A 5.1 Taxes Sec Prime 12 A 6.1 Conditional F Prime 13 B Trend chart Prime Prime 14 C Pie chart Sec Prime Prime 15 D Solver Sec Sec 16 E Pivot Table Sec
majority of formula/function writing, copying/pasting, and range formatting dited, or advised on activities of primary task performer O16. n the column corresponding to their group serial number as shown in the group member roster all names are in ascending alphabetical order (L to R) by last name and that no member is omitted (even if that ep/task in range F11:N25 according to the definitions of primary and secondary responsibility described at top st one task in the 0.1-6.1 range and at least one step in the B-E range, and a secondary on at least one different o secondary members ndary member (except for task 3.1, which is so simple it doesn't count) nd two secondary members ho do execute those tasks must substitute their names for the non-contributing member(s) names on all such "t sible for understanding all tasks and executing any other work required to complete the project 3 2 2 3 0 Group ## 2 3 3 2 0 5 5 6 7 8 9 Count Emily Yi Dennis David 8 Vizhnay Yang Yazici Zheng 8 Sec Prime 2 Prime 3 2 Sec 2 Sec 2 Prime Sec 2 Prime Sec 2 Prime 2 Prime 2 2 Sec 2 Sec Sec 4 Sec 4 Prime Prime 4 Sec Prime Prime 4
t member is completely absent from project execution) task and one different step transferred" tasks
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Project Scoring Tables Group ##: Deductions Budget 60 Trend Chart 8 Pie Chart 8 Solver 12 Pivot Table 12 Gross Score 100 Group Member Names max -5 Blank/Extra Worksheets -2/sheet File/Tab Naming Protocol max -5 Multiple Submissions (>2) -5/sub Late submission -5/day [Other issues] variable Gross Deductions Net Score , Group Member {P.S} Tasks Lowe, Awa 2,3 0 Robbins, Charles 3,2 0 Shrestha, Prabin 2,3 0 Tabina, Rayya 3,2 0 Vizhnay, Emily 3,2 0 Yang, Yi 2,3 0 Yazici, Dennis 2,3 0 Zheng, David 3,2 0 , 0,0 0 (Group Collective) Project Scoring Components Full Score Value Point Value of Deductions Deviation from Workload Distribution Non- Participation Deduction
5 Deduction Item # & Issue 60 8 8 12 12 100 0 0 0 0 0 0 0 100 No deductions - great job! 100 100 100 100 100 100 100 100 100 Net Score after Deductions Net Member Score after NPD
Group Advertising Legal Fees Shipping # 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.20 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.80 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.50 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.80 20.16 10 4.30 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.80 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.90 5.65 3.40 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.40 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.60 2.89 5.96 20.20 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.60 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.30 5.47 3.92 4.37 18.79 35 5.60 7.53 5.63 4.76 3.06 4.22 19.67 Wedding Invitations Birthday Party Invitations Business Party Invitations Deceember Goal Increase
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Region Representative Total 01/06/20 East Jones Birthday 95 1.99 18,905 01/23/20 Central Kivell Business 50 3.49 17,450 02/09/20 Central Jardine Birthday 36 4.99 17,964 02/26/20 Central Gill Wedding 27 1.99 5,373 03/15/20 West Sorvino Birthday 56 2.99 16,744 04/01/20 East Jones Business 60 4.99 29,940 04/18/20 Central Andrews Birthday 75 1.99 14,925 05/05/20 Central Jardine Birthday 90 4.99 44,910 05/22/20 West Thompson Birthday 32 1.99 6,368 06/08/20 East Jones Business 60 0.85 5,100 06/25/20 Central Morgan Birthday 90 4.99 44,910 07/12/20 East Howard Business 29 1.99 5,771 07/29/20 East Parent Business 81 1.14 9,234 08/15/20 East Jones Birthday 35 2.27 7,945 09/01/20 Central Smith Wedding 2 2.5 500 09/18/20 East Jones Graduation 16 1.57 2,512 10/05/20 Central Morgan Business 28 3.14 8,792 10/22/20 East Jones Wedding 64 1.35 8,640 11/08/20 East Parent Wedding 15 0.97 1,455 11/25/20 Central Kivell Graduation 96 2.32 22,272 12/12/20 Central Smith Birthday 67 1.29 8,643 12/29/20 East Parent Graduation 74 3.17 23,458 01/15/21 Central Gill Business 46 8.99 41,354 02/01/21 Central Smith Business 87 15 130,500 02/18/21 East Jones Business 4 4.99 1,996 03/07/21 West Sorvino Business 7 19.99 13,993 03/24/21 Central Jardine Graduation 50 4.99 24,950 04/10/21 Central Andrews Birthday 66 1.99 13,134 04/27/21 East Howard Wedding 96 4.99 47,904 05/14/21 Central Gill Birthday 53 1.29 6,837 05/31/21 Central Gill Business 80 1.04 8,320 06/17/21 Central Kivell Wedding 5 1.5 750 07/04/21 East Jones Graduation 62 1.87 11,594 07/21/21 Central Morgan Graduation 55 2.49 13,695 08/07/21 Central Kivell Graduation 42 2.16 9,072 08/24/21 West Sorvino Wedding 3 2.48 744 09/10/21 Central Gill Birthday 7 1.29 903 09/27/21 West Sorvino Wedding 76 1.99 15,124 10/14/21 West Thompson Business 57 1.72 9,804 10/31/21 Central Andrews Birthday 14 1.29 1,806 11/17/21 Central Jardine Business 11 0.58 638 Order Date Invitation type Units (100) Unit Cost
12/04/21 Central Jardine Business 94 1.99 18,706 12/21/21 Central Andrews Business 28 1.21 3,388
Financial results for August 2019 (000) GROUP ##: 5 LI# Summary Income Statement August September October November December Revenues 1 Wedding Invitations 4,507 4,743 4,992 5,253 5,529 2 Birthday Party Invitations 3,841 4,144 4,470 4,822 5,202 3 Business Party Invitation 2,652 2,808 2,974 3,149 3,334 Total Revenues 11,000 11,695 12,436 13,224 14,065 Expenses 4 Printing Costs 4,400 4,678 4,974 5,290 5,626 5 Salaries 3,500 3,500 3,500 3,500 3,500 6 Administration 550 585 622 661 703 7 Advertising 1,544 1,635 1,731 1,833 1,941 8 Legal Fees 788 815 843 872 902 9 Shipping 928 967 1,008 1,051 1,095 Total Expenses 11,710 12,180 12,678 13,207 13,768 Income 10 Net Income before Taxes -710 -485 -243 18 298 11 Taxes 0 0 0 5 83 12 Net Profit (Loss) -710 -485 -243 13 214 % 2 Wedding Invitations 5.24 (no penalty) VLOOKUP function would have been more flexible if A24:A30 ref 3 Birthday Party Invitations 7.88 …had been used as third VLOOKUP argument (# of column 4 Business Party Invitations 5.89 …as a rule, avoid static values whenever dynamic referenc 5 Advertising 5.89 6 Legal Fees 3.44 7 Shipping 4.22 8 December Increase Goal 19.12 VLKP Col# Projected Growth Per Month (PGM)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
(no penalty) Yellow August September October November December -2,000 0 2,000 4,000 6,000 8,000 10,000 12,000 14,000 16,000 11,000 11,695 12,436 13,224 14,065 11,710 12,180 12,678 13,207 13,768 -710 -485 -243 13 214 Trends in Revenues, Expenses, and Net Income Total Revenues Total Expenses Net Profit (Loss) Month Total $ in Thousands
ferences… ns to look across)… ces are available
w for a lineon a chart is often difficult for readers to see, but otherwise, fine graph
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
3 703 5.11% 4 1,941 14.10% 5 902 6.55% Distribution of Expens
1 5,626 40.86% 6 1,095 7.95% ses as of December 2019 ($ Amounts in 000s)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
2 3,500 25.42%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Target financial results through December 2019 (000) LI# Summary Income Statement August September October Revenues 1 Wedding Invitations 4,507 4,749 5,003 2 Birthday Party Invitations 3,841 4,153 4,491 3 Business Party Invitation 2,652 2,811 2,979 Total Revenues 11,000 11,713 12,473 Expenses 4 Printing Costs 4,400 4,685 4,989 5 Salaries 3,500 3,500 3,500 6 Administration 550 586 624 7 Advertising 1,544 1,633 1,728 8 Legal Fees 788 815 843 9 Shipping 928 967 1,007 Total Expenses 11,710 12,186 12,691 Income 10 Net Income before Taxes -710 -473 -218 11 Taxes 0 0 0 12 Net Profit (Loss) -710 -473 -218 % 2 Wedding Invitations 5.36 3 Birthday Party Invitations 8.13 4 Business Party Invitations 5.98 5 Advertising 5.79 6 Legal Fees 3.42 7 Shipping 4.19 8 December Increase Goal 19.12 Manual Solution Check ^ Solver Goal (formula) 255 Solver Goal input Solver Goal (value) 255 Initial Net Profit Initial Net Profit (value) 214 Output - Input difference Output/INP quotient VLKP Col# Projected Growth Per Month (PGM)
GROUP ##: 5 November December 5,272 5,554 4,857 5,252 3,157 3,346 13,285 14,152 5,314 5,661 3,500 3,500 664 708 1,828 1,934 872 902 1,050 1,094 13,228 13,797 57 354 16 99 41 255 Initial PGM (%) Difference** 5.24 0.12 7.88 0.25 5.89 0.09 5.89 -0.10 3.44 -0.02 4.22 -0.03 19.12 0.00 Pre Iteration 1 Post 1 (Pre 2)* 255.3118 254.9168 214.3316 254.9168 40.9802 0.0000 0.1912 0.0000 Excellent job - not even a rounding error!
Invitation type Data Birthday Business Graduation RepresentativeYears Sum - Total Count - UnitsSum - Total Count - UnitsSum - Total Andrews 29,865 3 3,388 1 2020 14,925 1 2021 14,940 2 3,388 1 Gill 7,740 2 49,674 2 2020 2021 7,740 2 49,674 2 Howard 5,771 1 2020 5,771 1 2021 Jardine 62,874 2 19,344 2 24,950 2020 62,874 2 2021 19,344 2 24,950 Jones 26,850 2 37,036 3 14,106 2020 26,850 2 35,040 2 2,512 2021 1,996 1 11,594 Kivell 17,450 1 31,344 2020 17,450 1 22,272 2021 9,072 Morgan 44,910 1 8,792 1 13,695 2020 44,910 1 8,792 1 2021 13,695 Parent 9,234 1 23,458 2020 9,234 1 23,458 Smith 8,643 1 130,500 1 2020 8,643 1 2021 130,500 1 Sorvino 16,744 1 13,993 1 2020 16,744 1 2021 13,993 1 Thompson 6,368 1 9,804 1 2020 6,368 1 2021 9,804 1 Total Result 203,994 13 304,986 15 107,553
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Wedding Total Sum - Total Total Count - Units(100) Count - UnitsSum - Total Count - Units(100) 33,253 4 14,925 1 18,328 3 5,373 1 62,787 5 5,373 1 5,373 1 57,414 4 47,904 1 53,675 2 5,771 1 47,904 1 47,904 1 1 107,168 5 62,874 2 1 44,294 3 2 8,640 1 86,632 8 1 8,640 1 73,042 6 1 13,590 2 2 750 1 49,544 4 1 39,722 2 1 750 1 9,822 2 1 67,397 3 53,702 2 1 13,695 1 1 1,455 1 34,147 3 1 1,455 1 34,147 3 500 1 139,643 3 500 1 9,143 2 130,500 1 15,868 2 46,605 4 16,744 1 15,868 2 29,861 3 16,172 2 6,368 1 9,804 1 7 80,490 8 697,023 43
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

UNIT 4 IDRL 215 EXAM PREP.docx
final exam econ 101.docx
18.png
20.png
Bobst_ArynFix3_M04.docx
disc10.docx
Christelle Badillo Case 3.docx
Final Case 1.xlsx
Dated 10-21-2023 ECN 201 Thought Question Assignment 2 (4) (2).doc
Business Winter Work.pdf
Percent.pdf
Data Interpretation.pdf
Recommended textbooks for you
Text book image
Managerial Economics: Applications, Strategies an...
Economics
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:Cengage Learning
Text book image
Managerial Economics: A Problem Solving Approach
Economics
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Cengage Learning
Text book image
MACROECONOMICS FOR TODAY
Economics
ISBN:9781337613057
Author:Tucker
Publisher:CENGAGE L
Text book image
Micro Economics For Today
Economics
ISBN:9781337613064
Author:Tucker, Irvin B.
Publisher:Cengage,
Text book image
Economics For Today
Economics
ISBN:9781337613040
Author:Tucker
Publisher:Cengage Learning
Text book image
Survey Of Economics
Economics
ISBN:9781337111522
Author:Tucker, Irvin B.
Publisher:Cengage,
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Managerial Economics: Applications, Strategies an...
Economics
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:Cengage Learning
Text book image
Managerial Economics: A Problem Solving Approach
Economics
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Cengage Learning
Text book image
MACROECONOMICS FOR TODAY
Economics
ISBN:9781337613057
Author:Tucker
Publisher:CENGAGE L
Text book image
Micro Economics For Today
Economics
ISBN:9781337613064
Author:Tucker, Irvin B.
Publisher:Cengage,
Text book image
Economics For Today
Economics
ISBN:9781337613040
Author:Tucker
Publisher:Cengage Learning
Text book image
Survey Of Economics
Economics
ISBN:9781337111522
Author:Tucker, Irvin B.
Publisher:Cengage,
SEE MORE TEXTBOOKS