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 studyCase StudyChase Manhattan BankThe 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 aninverted 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 fulltimeemployees. 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 lunchincluded) 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 islimited to 2 hours). Any work left over at 7 P.M. is consideredholdover for the next day.6. A full-time employee is not allowed to work more than5 hours overtime per week. He or she is paid at the normalrate for overtime hours—not at one-and-a-half times the normalrate applicable to hours in excess of 40 per week. Fringebenefits 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 inTable 8.9.The bank’s goal is to achieve the minimum possible personnelcost subject to meeting or exceeding the hourly workforcerequirements as well as the constraints on the workerslisted earlier.Discussion Questions1. 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 fromyour 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 SUBMITTHE QUESTIONS.7. Please be sure to follow the directions so the grading can go smoothly. Thanksand good luck on the exam.Problem 1Using the following information find the unknown amounts. Assume each set ofinformation is an independent case.a. Merchandise InventoryPurchasesCost of goods soldBeginning balanceEnding balance$210,000223,00041,000?b. Direct MaterialsBeginning balanceEnding balancePurchasesDirect materials usedc. Work-in-process InventoryEnding balanceCost of goods manufacturedBeginning balanceCurrent manufacturing costs$ 22,00021,0008,000?d. Finished Goods InventoryCost of goods manufacturedEnding balanceCost of goods soldBeginning balance$62,00020,00061,000?$ 7,00014,00048,000?Problem 2Sprint Manufacturing Company produces two products, X and Y. The followinginformation is presented for both products:XYSelling price per unit$30$20Variable cost per unit205Total 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 3Rachel's Pet Supply Corporation manufactures two models of grooming stations, astandard and a deluxe model. The following activity and cost information has beencompiled:ProductStandardDeluxeOverhead costsNumber ofSetups37Number ofComponents3050$40,000Number ofDirect Labor Hours650150$120,000Assume 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 4Clothes, 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 5The 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 each30,000 units$525,000$372,000Variable:Fixed:Beginning inventories:$144,800$77,400noneRequired:a. Determine operating income using the variable-costing approach.b. Determine operating income using the absorption-costing approach.Problem 6Jerry'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,000Cost of goods sold400,000Store manager's salary per year70,000Operating costs per year157,000Advertising and promotion per year 15,000Commissions (4% of sales)36,000Part 1. What was the variable cost per unit sold for 2011?A) $36B) $436C) $678D) $400Part 2 What were total fixed costs for 2011?A) $678,000B) $436,000C) $242,000D) $227,000Part 3 What are the estimated total costs if Penny's expects to sell 3,000 units next year?A) $1,550,000B) $1,332,000C) $1,671,000D) $1,453,000Part 4 Which cost estimation method is being used by Jerry's TV and Appliance Store?A) the industrial engineering methodB) the conference methodC) the account analysis methodD) 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 ideasConsider the Law of demand and the determinants of demandConsider the Law of supply and the determinants of supplyDescribe Efficient markets theoryExplain Surplus and shortageDeliver 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.
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 studyThis case has two separate parts.Part IHow 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 IIThe 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 manufacturingJust-in-timeTheory of constraintsTotal quality controlValue chainThe 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 ExpectationsIt 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 SLPHerrestad 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 AProd BBeginning inventory 0 Units produced 10,000 2,500 7,500Units sold 8,000 2,000 6,000Selling price per unit $255 480 180Variable 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 9Fixed costs Fixed manufacturing overhead 200,000 Fixed selling and administrative 100,000Production runs (not $)1006535Number of sales reps (not $) 25 1510Here 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 CompanySegmented Income StatementFor the period ending Dec. 31, 2011 A B TotalSales $960,000 $1,080,000 $2,040,000Variable costs: Direct material 560,000 240,000 800,000The 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 averageProblem 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 1Which one of the following is not a characteristic generally evaluated in ratio analysis?liquidityprofitabilitysolvencymarketability Question 2A loss on disposal of a segment would be reported in the income statement as a(n)administrative expenseother expensededuction from income from continuing operationsselling expense Question 3Based 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,000Cost of merchandise sold during year300,000Accounts receivable, beginning of year45,000Accounts receivable, end of year35,000Inventory, beginning of year90,000Inventory, end of year110,0007.32.514.625 Question 4An extraordinary item results froma 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 5Which of the following is a measure of the liquid position of a corporation?earnings per shareinventory turnovercurrent rationumber of times interest charges earned Question 6Hsu Company reported the following on its income statement:Income before income taxes$420,000Income tax expense120,000Net income$300,000An analysis of the income statement revealed that interest expense was $80,000. Hsu Company's times interest earned was8 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 thatcontains 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 thedevelopment 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