Blog

Case Study Chase Manhattan Bank

Case Study Chase Manhattan Bank

Question Can you provide me specific setup in excel for the Chase Manhattan Bank case study

Case Study
Chase Manhattan Bank
The workload in many areas of bank operations has the characteristics of a nonuniform distribution with respect to time of day.
For example, at Chase Manhattan Bank in New York, the number of domestic money transfer requests received from customers, if plotted against time of day, would appear to have the shape of an
inverted U curve with the peak around 1 P.M. For efficient use of resources, the personnel available should, therefore, vary correspondingly.
Figure 8.2 shows a typical workload curve and corresponding personnel requirements at different hours of the day.
A variable capacity can be achieved effectively by employing part-time personnel. Because part-timers are not entitled to all the fringe benefits, they are often more economical than fulltime
employees. Other considerations, however, may limit the extent to which part-time people can be hired in a given department.
The problem is to find an optimum workforce schedule that would meet personnel requirements at any given time and also be economical.
Some of the factors affecting personnel assignment are listed here:
1. By corporate policy, part-time personnel hours are limited to a maximum of 40% of the day’s total requirement.
2. Full-time employees work for 8 hours (1 hour for lunch
included) per day. Thus, a full-timer’s productive time is 35 hours per week.
3. Part-timers work for at least 4 hours per day but less than 8 hours and are not allowed a lunch break.
4. Fifty percent of the full-timers go to lunch between 11 A.M. and noon, and the remaining 50% go between noon and 1 P.M.
5. The shift starts at 9 A.M. and ends at 7 P.M. (i.e., overtime is
limited to 2 hours). Any work left over at 7 P.M. is considered
holdover for the next day.
6. A full-time employee is not allowed to work more than
5 hours overtime per week. He or she is paid at the normal
rate for overtime hours—not at one-and-a-half times the normal
rate applicable to hours in excess of 40 per week. Fringe
benefits are not applied to overtime hours.
In addition, the following costs are pertinent:
1. The average cost per full-time personnel hour (fringe benefits included) is $10.11.
2. The average cost per overtime personnel hour for full-timers
(straight rate excluding fringe benefits) is $8.08.
3. The average cost per part-time personnel hour is $7.82. The personnel hours required, by hour of day, are given in
Table 8.9.
The bank’s goal is to achieve the minimum possible personnel
cost subject to meeting or exceeding the hourly workforce
requirements as well as the constraints on the workers
listed earlier.
Discussion Questions
1. What is the minimum-cost schedule for the bank?
2. What are the limitations of the model used to answer question 1?
3. Costs might be reduced by relaxing the constraint that no more than 40% of the day’s requirement be met by parttimers. Would changing the 40% to a higher value significantly reduce costs?

Acc611 midterm exam

Acc611 midterm exam

Question NSTRUCTIONS:
1. This examination covers content covered through Session 6 . The exam ismeant to be an individual effort. Any sharing of answers (giving or receiving) willresult in immediate disciplinary action. You may use your textbook. However, youare not to consult with any other individual about the problems or the processesrequired to complete this exam.
2. There are 6 problems on this exam.
Answer all parts of each problem.
3. Show your work on all problems where appropriate. Label all amounts notgiven in the problem. Also, label your answers! Make it clear what youranswers are. Please show your answers clearly and separate them from
your calculations. Partial credit will be given only where these requirements aremet.
4. Problems 2 and 4 count for 3% each, problem 5 counts for 2%, andProblems 1, 3 and 6 counts for 4% each . Thus the exam counts for 20% of thecourse grade.
5. Submit your answers (not the questions) in your Assignment Portfolio. Yourexam responses are due by Sunday March 23. I strongly suggest that youcomplete this exam and submit your responses at least 24 hours before the finalsubmission deadline.
6. How to submit… Once you are ready to submit all answers, please submitONLY the answers to the questions in your Web Tyco Assignment Portfolio. Post1 individual attachment to your Assignments Folder. Simply submit oneattachment that I can open, and place your answers clearly labeled, in order.
DO NOT SUBMIT MORE THAN ONE ATTACHMENT, AND DO NOT SUBMIT
THE QUESTIONS.
7. Please be sure to follow the directions so the grading can go smoothly. Thanksand good luck on the exam.

Problem 1
Using the following information find the unknown amounts. Assume each set ofinformation is an independent case.
a. Merchandise Inventory

Purchases
Cost of goods sold
Beginning balance
Ending balance

$210,000
223,000
41,000
?

b. Direct Materials

Beginning balance
Ending balance
Purchases
Direct materials used

c. Work-in-process Inventory

Ending balance
Cost of goods manufactured
Beginning balance
Current manufacturing costs

$ 22,000
21,000
8,000
?

d. Finished Goods Inventory

Cost of goods manufactured
Ending balance
Cost of goods sold
Beginning balance

$62,000
20,000
61,000
?

$ 7,000
14,000
48,000
?

Problem 2
Sprint Manufacturing Company produces two products, X and Y. The followinginformation is presented for both products:
X
Y
Selling price per unit
$30
$20
Variable cost per unit
20
5
Total fixed costs are $292,500.
Required:
a. Calculate the contribution margin for each product.
b. Calculate breakeven point in units of both X and Y if the sales mix is 3 units of X forevery unit of Y.
c. Calculate breakeven volume in total dollars if the sales mix is 2 units of X for every 3units of Y.

Problem 3
Rachel's Pet Supply Corporation manufactures two models of grooming stations, astandard and a deluxe model. The following activity and cost information has beencompiled:
Product
Standard
Deluxe
Overhead costs

Number of
Setups
3
7

Number of
Components
30
50

$40,000

Number of
Direct Labor Hours
650
150

$120,000

Assume a traditional costing system applies the $160,000 of overhead costs based on direct labor hours.
a. What is the total amount of overhead costs assigned to the standard model?
b. What is the total amount of overhead costs assigned to the deluxe model?
Assume an activity-based costing system is used and that the number of setups and thenumber of components are identified as the activity-cost drivers for overhead.
c. What is the total amount of overhead costs assigned to the standard model?
d. What is the total amount of overhead costs assigned to the deluxe model?
Problem 4
Clothes, Inc., has an average annual demand for red, medium polo shirts of 25,000 units.
The cost of placing an order is $80 and the cost of carrying one unit in inventory for oneyear is $25.
Required:
a. Use the economic-order-quantity model to determine the optimal order size.
b. Determine the reorder point assuming a lead time of 10 days and a work year of 250days.
c. Determine the safety stock required to prevent stockouts assuming the maximum leadtime is 20 days and the maximum daily demand is 125 units.
Problem 5
The following data are available for Ruggles Company for the year ended September 30,2011.
Sales:
Expected and actual production:
Manufacturing costs incurred:
Variable:
Fixed:
Nonmanufacturing costs incurred:

24,000 units at $50 each
30,000 units
$525,000
$372,000

Variable:
Fixed:
Beginning inventories:

$144,800
$77,400
none

Required:
a. Determine operating income using the variable-costing approach.
b. Determine operating income using the absorption-costing approach.
Problem 6
Jerry's TV and Appliance Store is a small company that has hired you to perform somemanagement advisory services. The following information pertains to 2011 operations.
Sales (1,000 televisions)
$ 900,000
Cost of goods sold
400,000
Store manager's salary per year
70,000
Operating costs per year
157,000
Advertising and promotion per year 15,000
Commissions (4% of sales)
36,000
Part 1. What was the variable cost per unit sold for 2011?
A) $36
B) $436
C) $678
D) $400
Part 2 What were total fixed costs for 2011?
A) $678,000
B) $436,000
C) $242,000
D) $227,000
Part 3 What are the estimated total costs if Penny's expects to sell 3,000 units next year?
A) $1,550,000
B) $1,332,000
C) $1,671,000
D) $1,453,000
Part 4 Which cost estimation method is being used by Jerry's TV and Appliance Store?
A) the industrial engineering method
B) the conference method
C) the account analysis method
D) the quantitative analysis method

Market Equilibration Process Paper

Market Equilibration Process Paper

Question

Equilibration is the process of moving between two equilibrium points as a result of some change in supply or demand. Understanding how market equilibrium is sought following such a change is essential for business managers. It is important to understand how economic principles, and specifically supply, demand, and their determents are a part of your everyday business decisions.

Write a paper, create a video, or create a PowerPoint presentation using a real world experience in a free market (not government regulated) to describe a change that occurred in supply or demand as a result of world events that led to the need for a move between two equilibrium states. Explain the process of how that movement occurred using behaviors of consumers and suppliers. Graph the movement between the two points as well.

Required Elements:

  • Include academic research to support your ideas
  • Consider the Law of demand and the determinants of demand
  • Consider the Law of supply and the determinants of supply
  • Describe Efficient markets theory
  • Explain Surplus and shortage
  • Deliver the content in no more than a 700-word paper, OR 7- to 10-slide Microsoft PowerPoint presentation, OR 2- to 3-minute video (Please choose one of these choices, not all three),
  • Use University of Phoenix Material: Appendix A to create graphs illustrating the movement between the two equilibrium points and include this in the body of the assignment.
  • Your assignment is consistent with APA guidelines.
,
Attachments
(30.5 KB)

ACT350 Portfolio Project-The Coca-Cola Company and PepsiCo, Inc., answer the following questions

ACT350 Portfolio Project-The Coca-Cola Company and PepsiCo, Inc., answer the following questions

Question

ACT350 Portfolio Project

Using these 2007 annual reports for The Coca-Cola Company and PepsiCo, Inc., answer the following questions. Write these up in a Word document, clearly identifying your response to each lettered item.

Show supporting calculations for the items lettered c, f, h, l, m, o, p, r, s and u.

a. What are the primary lines of business of these two companies as shown in their notes to the financial statements?

b. Which company has the dominant position in beverage sales?

c. Which company has the greater percentage increase in total assets from 2006 to 2007?

d. Which company had more depreciation and amortization expense for 2007? Provide a rationale as to why there is a difference in these amounts between the two companies.

e. What type of income format(s) is used by these two companies? Identify any differences in income statement format between these two companies.

f. What are the gross profits, operating profits, and net incomes for these two companies over the three-year period 2005-2007? Which company has had better financial results over this period of time?

g. What format(s) did these companies use to present their balance sheets?

h. How much working capital did each of these companies have at the end of 2007? Speculate as to their rationale for the amount of working capital they maintain.

i. What is the most significant difference in the asset structure of the two companies? What causes this difference?

j. What were the two companies’ trends in net cash provided by operating activities over the period 2005 to 2007?

k. What were the cash and cash equivalents reported by Coca-Cola and PepsiCo at the end of

2007? What does each company classify as cash equivalents?

l. What were the accounts receivable (net) for Coca-Cola and PepsiCo at the end of 2007? Which company reports the greater allowance for doubtful accounts receivable (amount and percentage of gross receivable) at the end of 2007?

m. What is the amount of inventory reported by Coca-Cola at December 31, 2007, and by PepsiCo at December 29, 2007? What percent of total assets is invested in inventory by each company?

n. What inventory costing methods are used by Coca-Cola and PepsiCo? How does each company value its inventories?

o. Compute and compare the inventory turnover ratios and days to sell inventory for Coca-Cola and PepsiCo for 2007. Indicate why there might be a significant difference between the two companies. ACT350 Portfolio Project


What depreciation methods are used by Coca-Cola and PepsiCo for property, plant, and equipment? How much depreciation was reported by Coca-Cola and PepsiCo in 2007, 2006, and

2005?

r. Compute and compare the following ratios for Coca-Cola and PepsiCo for 2007: Asset turnover,

Profit margin on sales, and Rate of return on assets.

t. On what basis and over what periods of time did Coca-Cola and PepsiCo amortize their intangible assets?

u. What were Coca-Cola’s and PepsiCo’s net revenues (sales) for the year 2007? Which company increased its revenues more (dollars and percentage) from 2006 to 2007?

v. Are the revenue recognition policies of Coca-Cola and PepsiCo similar? Explain

ECONOMICS ASSIGNMENT

ECONOMICS ASSIGNMENT

Question

1. Say that real money demand, which is Md / P, is 1000 + .6Y – 100i.

a. Do income, prices, and nominal interest rates have the same positive or negative impact on real money demand that we described in class? That is, if income, etc. increases, does real money demand increase or decrease as we described?

b. If Y was 100 and i = .05, what would the real demand for money be?

c. Given the values in b, what would the nominal demand for money be if P = 100?

d. Given the above description for the demand for money, if income rose, what would happen to the demand for non-money assets?

e. Is this form of money demand consistent with money demand in the Quantity Theory that we did in class and in previous homeworks? Why or why not?

2. Say that the face value on a one-year maturity Treasury Bill is $1,000 and its interest rate was 2%.

a. What would its price be?

b. Now, say that its interest rate rises to 4%. Consider the face value and price of this bond – how many of these two things would change and what would be the new value or values?

3. Consider this part of the Quantity Theory: M V = P Y. Say that V is fixed, that Y is at full employment, and that M is controlled by this country’s central bank.

a. What does the above equation now describe?


4. Let’s start this question with no currency in the economy, the reserve to deposit ratio (“res”) is fixed at .1, and banks have $100 billion on deposit at the Fed.

a. Say that the Fed wished to increase M1 by $10 billion. What would they do to achieve this goal?

b. Now let’s add currency to the economy; say that the public holds $50 billion and banks hold $20 billion. All other values are as there were in the previous question. Finally, assume that the currency to deposit ratio (“cu”) is .2. Now, say that the Fed wished to increase M1 by the same $10 billion as above. What would it do in this case?

5. Say that Cd = 300 – 300r + .2Y, I = 500 – 500r and G = 40.

a. Find the equation for the IS curve. That is, the combination of r and Y where the goods market is in equilibrium. To be a bit more specific, you’ll need an equation of the form r = … and this equation includes the concept of equilibrium in the goods market (i.e. S = I or Y = C + I + G).

b. What would happen to the IS curve if G increased from the above value of 40 to 60? That is, what happens to the equation for the IS curve and how is the curve placed compared to the previous question?

6. Now, consider the money market. The Fed has set the nominal money supply to 15,000 and the price level is 3. Next, real money demand is 5000 + .7Y – 10,000i and ?e = .02.

a. Find the LM curve. That is, find an equation for r = … when the money market is in equilibrium. Hint: be careful about the distinction between real and nominal interest rates.

b. What happens to the LM equation and curve if the nominal money supply increases by 10% from its initial value of 15,000?

7. Now, consider the IS and LM curves generated in the last two questions (specifically, from 5a and 6a).
a. What values of r and Y solve both the IS and LM curve? That is, what combination of r and Y put both the money market and goods market in equilibrium?

b. Please graph the IS and LM curves as well as your answer.

c. Starting from the initial equilibrium (from 7a), what would be the new values of r and Y if G rose from the initial 40 to 60?

d. Please graph the new IS and LM curves as well as your answer.

e. Starting again from the initial equilibrium (from 7a), what would happen to r and Y if the money supply rose by 10%?

f. Please graph the new IS and LM curves as well as your answer.

ECONOMICS ASSIGNMENT

Madrasa Inc. made the following determinations about three depreciable assets.

Madrasa Inc. made the following determinations about three depreciable assets.

Question on December 31, 2012, before the books were closed, the management and accountants of Madrasa Inc. made the following determinations about three depreciable assets.


1. Depreciable asset A was purchased January 2, 2009. It originally cost $590,000 and, for depreciation purposes, the straight-line method was originally chosen. The asset was originally expected to be useful for 10 years and have a zero salvage value. In 2012, the decision was made to change the depreciation method from straight-line to sum-of-the-years’ digits, and the estimates relating to useful life and salvage value remained unchanged.
2. Depreciable asset B was purchased January 3, 2008. It originally cost $168,000 and, for depreciation purposes, the straight-line method was chosen. The asset was originally expected to be useful for 15 years and have a zero salvage value. In 2012, the decision was made to shorten the total life of this asset to 9 years and to estimate the salvage value at $3,100.
3. Depreciable asset C was purchased January 5, 2008. The asset’s original cost was $122,400, and this amount was entirely expensed in 2008. This particular asset has a 10-year useful life and no salvage value. The straight-line method was chosen for depreciation purposes.

Additional data:


1. Income in 2012 before depreciation expense amounted to $354,000.
2. Depreciation expense on assets other than A, B, and C totaled $58,200 in 2012.
3. Income in 2011 was reported at $390,000.
4. Ignore all income tax effects.
5. 112,800 shares of common stock were outstanding in 2011 and 2012.





































(a)



Prepare all necessary entries in 2012 to record these determinations. (Credit account titles are automatically indented when amount is entered. Do not indent manually.)



No.

Account Titles and Explanation


Stacey Small has a small salon

Stacey Small has a small salon

Question Stacey Small has a small salon that she has run for a few years as a sole proprietorship. The proprietorship uses the cash method of accounting and the calendar year as its tax year. Stacey needs additional capital for expansion and knows two people who might be interested in investing. One would like to practice hairdressing in the salon. The other would only invest.
Stacey wants to know the tax consequences of incorporating the business. Her business assets include a building, equipment, accounts receivable and cash. Liabilities include a mortgage on the building and a few accounts payable, which are deductible when paid.

Write a memo to Stacey explaining the tax consequences of the incorporation. As part of your memo examine the possibility of having the corporation issue common and preferred stock and debt for the shareholders’ property and money.

trident acc202 module 4 casestudy and SLP

trident acc202 module 4 casestudy and SLP

Question module 4 case study

This case has two separate parts.

Part I

How can activity based management and activity based costing (ABC) benefit an organization? Specifically, address the following points.

  • How does ABC differ from other allocation methods?
  • Describe the main characteristics of ABC.
  • What type of companies tends to benefit from ABC?
  • Comment on a company (research Internet) that has implemented ABC.
    • What type of company is it?
    • Was it successful?

Part II

The below concepts are all applied by many business in an attempt to be more efficient and reduce costs. Create a table describing at least three of the concepts below and how implementation may benefit an organization.

  • Lean manufacturing
  • Just-in-time
  • Theory of constraints
  • Total quality control
  • Value chain

The submission should be 3 to 5 pages and need to include answers to all the questions listed above. Include references in APA format.

Modular Case Expectations

It is important to answer the questions above. The discussion should be three to five pages and written in a clear and concise manner. Support your discussion with references in APA format. You are encouraged to use Excel or other compatible spreadsheet when computations are involved.


module 4 SLP


Herrestad Company does produce and sell two products and the details below will be used to prepare a segmented income statement (showing the income for each product and the total) for the company. Use ABC to allocate all fixed costs to the two products.

Background information

Total

Prod A

Prod B

Beginning inventory

0

Units produced

10,000

2,500

7,500

Units sold

8,000

2,000

6,000

Selling price per unit

$255

480

180

Variable costs per unit

Direct material

100

280

40

Direct labor

60

60

60

Variable overhead

25

40

20

Variable selling and admin. exp.

10

13

9

Fixed costs

Fixed manufacturing overhead

200,000

Fixed selling and administrative

100,000


Production runs (not $)

100

65

35

Number of sales reps (not $)

25

15

10

Here are the first few lines of the segmented income statement to help you get started. Complete the statement in good format and make sure you allocate the fixed costs to the two products. When done, comment on the information and the relative profitability of the two products.

Herrestad Company

Segmented Income Statement

For the period ending Dec. 31, 2011

A

B

Total

Sales

$960,000


$1,080,000

$2,040,000

Variable costs:

Direct material

560,000

240,000

800,000

The submission should be 2 to 4 pages and need to include answers to all the questions listed above. Show computations, discuss the results and include references in APA format.

Saint MBA560 Test 3

Saint MBA560 Test 3

Question

Problem 1. Maple Company started the year with no inventory. During the year, it purchased two identical inventory items at different times. The first unit cost $800 and the second, $700. One of the items was sold during the year.

Required:

Based on this information, how much product cost would be allocated to cost of goods sold and ending inventory, assuming use of:

a. LIFO
b. FIFO
c. Weighted average

Problem 2. Teague Company purchased a new machine on January 1, 2012, at a cost of $150,000. The machine is expected to have an eight-year life and a $15,000 salvage value. The machine is expected to produce 675,000 finished products during its eight-year life. Smith produced 70,000 units in 2012 and 110,000 units during 2013.

Required:

1) Determine the amount of depreciation expense to be recorded on the machine for the years 2012 and 2013 under each of the following methods:

ACCOUNTING TEST QUIZ

ACCOUNTING TEST QUIZ

Question

Question 1

Which one of the following is not a characteristic generally evaluated in ratio analysis?

liquidity

profitability

solvency

marketability

Question 2

A loss on disposal of a segment would be reported in the income statement as a(n)

administrative expense

other expense

deduction from income from continuing operations

selling expense

Question 3

Based on the following data for the current year, what is the number of days' sales in accounts receivable?

Net sales on account during year
$584,000
Cost of merchandise sold during year
300,000
Accounts receivable, beginning of year
45,000
Accounts receivable, end of year
35,000
Inventory, beginning of year
90,000
Inventory, end of year
110,000

7.3

2.5

14.6

25

Question 4

An extraordinary item results from

a segment of the business being sold.

corporate income tax being paid.

a change from one accounting method to another acceptable accounting method.

a transaction or event that is unusual and occurs infrequently.

Question 5

Which of the following is a measure of the liquid position of a corporation?

earnings per share

inventory turnover

current ratio

number of times interest charges earned

Question 6

Hsu Company reported the following on its income statement:

Income before income taxes
$420,000

Income tax expense
120,000

Net income
$300,000

An analysis of the income statement revealed that interest expense was $80,000. Hsu Company's times interest earned was

8 times.

6.25 times.

5.25 times.

5 times.

What is the price earnings ratio for this company? Round your answer to one decimal point.

8.0 times

2.5 times

4.0 times

6.0 times

question 9:
A company that is leveraged is one that

contains debt financing.

contains equity financing.

has a high current ratio.

has a high earnings per share.

ques 10:
Which of the following is required by the Sarbanes-Oxley Act of 2002?

A price-earnings ratio.

A report on internal control.

A vertical analysis.

A common-sized statement.

ques 11:
Horizontal analysis of comparative financial statements includes the

development of common size statements.

calculation of liquidity ratios.

calculation of dollar amount changes and percentage changes from the previous to the current year.

evaluation of financial statement data