20221007ReviewForStudents

xlsx

School

Marist College *

*We aren’t endorsed by this school

Course

388

Subject

Economics

Date

Jun 19, 2024

Type

xlsx

Pages

30

Uploaded by AdmiralDiscovery11948

Report
A CPA firm has two branch offices: downtown branch and suburban branch. During the last m to 14 April), the firm recruits college accounting majored students to meet the heavy demand. structure for each branch during the month's activities (only variable costs incurred): Downtown branch Large size 10 $6,000 4 $4,000 $1,200 Medium si 15 $4,000 3 $4,000 $1,200 Small size 20 $2,000 4 $4,000 $1,200 Suburban branch Large size 5 $5,000 2 $3,500 $1,200 Medium si 10 $3,500 3 $3,500 $1,200 Small size 30 $2,000 4 $3,500 $1,200 1. Downtown's productivity (multi-factor)? 2. Suburban's productivity (multi-factor)? 3. Overall's productivity (both branches together)? 4. Which group of students has the highest productivity (multi-factor)? # of customers processed Per customer's charge ($ inflow) # students needed Salary per month Health insurance per student # of customers processed Per customer's charge ($ inflow) # students needed Salary per month Health insurance per student
large size downtown? Medium size downtown? Small size downtown? Or, L.size suburban, M 5. This CPA firm believes Downtown Branch's low productivity from the small size's students size customers. Based on the productivity you have found in question 4, how many more sma students process (in addition to 20) to reach the same productivity as the one you have found f are allowed to process a fraction of an integer firm. 6. What is the new total productivity once the firm can process additional small size customer in question 5? 7. Which group of students has the highest productivity based on # firm/per student?
month of the tax season (say, 15 March . The followings are the cost and revenue $100 $103 $100 $100 $103 $100 Software cost per customer Software cost per customer
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
M. size suburban, S. size suburban? s is due to not having enough small all size customers should this group of from question 4? Assuming we rs from the answer you have found suburban small size
Lower bou Vlookup Frequency If function If(D10>H9 End Inv= (if(BE-SD> Begin Inv= Demand Day Unit recd Begin Inv Low limit Up limit Demand Prob. 25 0 0 1 0 2 25 3 0 4 0 5 6 Sum 0
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
und of cumulative probability n 9,D10,H9) If begin inventory > demand, then your end inv = begin inv - demand, otherwise your end inv shou >0, BE-SD, 0) previous Begin Inv + Unit recd - previous demand Random # End Inv Simulated demand
uld be 0.
Jane can complete her #4 assembly job with 33.75 minutes and her learning curve rate is 75%. Another techinician's, say, John, #32 assembly job takes an identical time as that of Jane's John's learning curve rate is 85%. What is the time needed for John's #33 assembly job? Can you show a graph to visualize their performance?
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
t (X) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 1. The yellow-colored sales data's CMA should start from which cell # and end at whic 19 Cell # 20 Start: 21 End 22 23 24 Cell # 25 Start: 26 End 27 28 3. The yellow-colored sales data's regression output should have how many observatio 29 and how many degree of freedom? 30 # 31 Observation 32 df 33 34 4. The green-colored sales data's regression output should have how many observation 35 and how many degree of freedom? # Observation df 5. Which color's dales data will have fewer seasonal peaks if both of them exhibits a significant seasonal demand? 2. The green-colored sales data's CMA should start from which cell # and end at which
Which one? 6.If I know period #40's forecast value (Y) and I know slope (m), what is the formula to solve the Intercept (b)? (list the formula, express it as Y=mx+b. In this case you need to writhe a formula starting with b=? In this formula you cannot show x as x, it must have a number. Your formula:
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
Week Day t (X) Year Month Week 1 1 1 Year 1 1 2 2 2 3 3 3 4 4 4 5 5 5 6 6 6 7 7 7 Week 2 1 8 8 2 9 9 3 10 10 4 11 11 5 12 12 6 13 Year 2 1 7 14 2 Week 3 1 15 3 2 16 4 3 17 5 4 18 6 5 19 7 6 20 8 7 21 9 Week 4 1 22 10 2 23 11 3 24 12 4 25 Year 3 1 5 26 2 6 27 3 7 28 4 Week 5 1 29 5 2 30 6 3 31 7 4 32 8 5 33 9 6 34 10 7 35 11 36 12
A B Expected Completion Time a 99% chance of on-time comple 1. What is the probability that this project can finish at 15 weeks? Answer: (what %?) 2. If the formula shown in the green box can be shorten as this: answer for point A? Answer: (what week?) 2.2 The answer you get in C33 is which variable in the formula given in the blue box (line 29)? Answer: (which variable?) 2.3 Write the formula to express the point B. Answer: (not writing the answer, lay out the formula) Due date = Expected completion time + (Z * σ ) 2.1 If we know the σ = 1.76 weeks, can you figure out what is the
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.4 what is the procedure to answer the following question? If a project's 71.57% chance of on-time completion time is 16 weeks, what is a 99% chance of on-time completion time? 1st step: Solve what variable? 2nd step: Solve what variable?
etion
1. Name the possible critical path: 2. What is the expected completion Time? 3. At which period (periods), the project needs most resources in each period? 4. Name the period (periods), the project needs the least resource. 5. Which of the following three time estimates for each activity cannot possibly happen to all these activities listed on the above Gantt chart? a m b A 10 20 30
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
B 14 18 22 C 20 30 40 D 14 23 44 E 4 11 12 F 9 16 17 G 17 20 29
A. 10 B. 15 C. 10 D. 20 E. 20 F. 15 G.25 H. 10 Answer: Answer: Answer: Answer: Answer: (list any impossible
time estimates among A, B, C,D,E,F, G)
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
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
A B C D E F G H Path Length 1. List all paths (critical and noncritical) 2. Crash the whole project to 12 weeks. What tasks? Tasks How many times? How many Total $ Sum
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
Principle 1 cheapest one goes first 2 if a common task $ > sum $ of 2 or 3 indivi Crash allo Cost per week 3 if sum $ of each individual task is > a comm 1 $100 4 only critcal path counts. Along the crash pr 1 $200 not impact the critical path 0 5 easiest way is to list all of them systematica 2 $100 2 $150 0 2 $900 1 $500
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
idual task $, then crash the indiviual task on each path mon task $, then crash the common task rocess, if the non-critical path's length reduces, that does ally; or, you will be confused easily.
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
1. Before you graph the breakeven graph, which two variables are required? 1. Know w Variable 1Variable 2 2. Know w Answer: 3. Don't fo 4. Know ho 2. Formula for total cost: 5. Pay atten (code for quantity is Q) very comm Answer: 3. Breakeven point's formula: Answer: 4. Identify the lowest cost frontier line on the graph (using color of the line to identify: (Total 3 communities here: Green, Blue and Red) Answer:
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
which formula to use for the optimal location selection; which formula to use to calculate the appropriate distance; orget the solver to solve location's coordinates must be non-linear ow to build the formula for the total cost (Solver has to be MIN); ntion to the function key, F4 to freeze the cell. This is a mon mistake everyone made.
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
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
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
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