SOLVE THE FOLLOWING USING EXCEL 1. Determine the utilization and efficiency for each of the following situations. a. A loan processing operation that processes an average of 7 loans per day. The operation has a design capacity of 10 loans per day and an effective capacity of 8 loans per day. b. A furnace repair team that services an average of four furnaces a day if the design capacity is six furnaces a day and the effective capacity is five furnaces a day. c. Would you say that systems that have higher efficiency ratios thai other systems will always have higher utilization ratios than those other systems? Explain.
Q: Question 5 Consider the following transactions that occurred in April 2013 for Kings: April 3…
A: JOURNAL ENTRIES Journ entries is the process of recording all Financial & Non Financial…
Q: Bonita Corporation began business by issuing 633600 shares of $5 par value common stock for $30 per…
A: A balance sheet depicts a company's assets, liabilities, and shareholder's equity at a given point…
Q: On July 1, 2018, Brent purchases a new automobile for $46,000. He uses the car 82% for business and…
A: Depreciation is the reduction in the value of the assets due to its use or wear and tear. The…
Q: In a business with financial years ended 31 December. A machine is bought for P420,000 on 1 January…
A:
Q: 5% return
A: IRR stands for Internal rate of return. It is technique used in capital budgeting to make appraisal…
Q: On August 2, Jun Company receives a $6,800, 90-day, 10.5% note from customer Ryan Albany as payment…
A: Cash is received on October 31 including interest at the rate of 10.5%. Notes receivable = $6,800
Q: The approach that requires the transfer price to be less than the market price but greater than the…
A: Standard cost is the cost that has been fixed by the company at the beginning of the period.…
Q: Question 18 The income statement of Texas Instruments contains the following information: Revenues…
A: Preparation of closing entries is a method used by the business entity to close its temporary…
Q: Use the following information to answer questions 5-20. On December 31, 2016 the following Trial…
A: Income statement provide the information about the business entities' annual gross profit or net…
Q: Chaumat Co's performance report for last month shows that actual indirect materials cost, a variable…
A: VARIABLE OVERHEADS SPENDING VARIANCE Variable overhead spending variance is the difference between…
Q: Allen Company used $71,000 of direct materials and incurred $37,000 of direct labor costs during the…
A: The cost of goods manufactured is the total cost of producing the goods. It includes direct material…
Q: Evan participates in an HSA carrying family coverage for himself, his spouse, and two children. In…
A: “Since you have asked multiple question, we will solve the first question for you. If you want any…
Q: Which of the following accounts has special tax advantages under certain conditions when used to…
A: Solution A Bond is a written agreement or contract between an issuer and the holder that requires…
Q: a. Show the effect of these transactions on the financial statements using a horizontal state- ments…
A: Jounral Entry In order to document a business transaction in the accounting records of the company,…
Q: What about the tax return preparation?
A: This is the follow-up question which is regarding the tax return preparation expenses incurred by…
Q: Case Construction Company, a three-year-old business, provides contracting and construction services…
A: The stages in the cost allocation process include cost identification, cost agglomeration, and cost…
Q: Question: briefly discuss what is an Accounting Information System? (AIS) briefly discuss.
A: An accounting information system is a mechanism for a business to keep track of all financial and…
Q: A plant asset with a cost of $40,000 and accumulated depreciation of $36,000 is sold for $6,000.…
A: Lets understand the basics. When asset is sold and if proceeds exceed the book value then asset is…
Q: Factory Overhead Cost Budget Nutty Candy Company budgeted the following costs for anticipated…
A: The factory overhead budget should include a schedule of all production costs in addition to direct…
Q: Ceramics produces large planters to be used in urban landscaping projects. A special earth clay is…
A: The variance is the difference between the actual data and standard output of the production. The…
Q: Melba's office building was foreclosed upon and the mortgage holder issued Form 1099-A, Acquisition…
A: Secured Property loan: It implies to an acknowledgement of debt by the borrower, who borrows the…
Q: Broncos Co. reports pretax financial income of $70,000 for 20x1. The following items cause taxable…
A: Solution Taxable income is the income upon which income tax impose by the income tax system. In…
Q: On January 1, 2012, Sisterakas Corporation purchased P4,000,000 10% bonds for P3,711,520. Sisterakas…
A: A bond amortization schedule is a table that shows the amount of interest expense, interest payment,…
Q: Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and…
A: FIFO means First In, First Out. Under this method goods purchased first are sold first. LIFO means…
Q: Do not round interim calculations. Round your final answer to the nearest dollar. The direct…
A: Lets understand the basics. Direct material price variance is a variance between the rate at which…
Q: Rate 10% 12% 22% 24% 32% 35% 37% Single Single Tax Rates $0-$9,875 $9,875-$40,125 $40,125-$85,525…
A: Taxes are to be paid by the citizen and but tax to paid depends on the income earned and it…
Q: Finn Enterprises manufactures celling fans that normally sell for $90 each. There are 300 defective…
A: Normal selling price = $90 Net income/(Net loss) if defectives are sold as is = Revenue from sale of…
Q: Cari’s Manufacturing Company manufactures Tye Dye Special Garment (SG), using cotton and dye as…
A: The revenue budget is the budget prepared to estimate the revenue, the expected number of units to…
Q: Four grams of musk oil are required for each bottle of Mink Caress, a very popular perfume made by a…
A: When developing a production budget, it is necessary to determine how much raw material will need to…
Q: Money Market Deposit Accounts
A: Money market accounts are financial products that are offered to customers at both traditional and…
Q: A company contemplating the acceptance of a special order has the following unit costs based on…
A: Additional cost due to accepting new order = Direct material + Direct labor + variable manufacturing…
Q: Credit unions are Group of answer choices not providers of insured deposits. mutual associations.…
A: Introduction: Usually unions are financial organizations that are arranged in a cooperative model.…
Q: If you invest $100 at 8% for one year, compounded semiannually, at the end of the year your balance…
A: The formula for calculation of the future value of the investment. A = P * (1+r)n Where, A =…
Q: 1. 2. 3. QUESTION 4 Raw materials... Packaging materials Work in progress. Finished goods.…
A:
Q: Question 1 of 5 Process costing would be used in all of the following industries except: Truck tire…
A: Lets understand the basics. Process costing is as name suggest used in industries where more than…
Q: 2 Best Buy Co. Inc. is an American multinational consumer electronics retailer headquartered in…
A: ALLOCATED REVENUE Revenue allocation is the distribution or division of total revenue. Revenue…
Q: Example 3-2 Wallington Company has 100 employees, each earning $525.25 a week. OASDI…
A: Employee Name Biweekly Taxable Wages FICA Taxes OASDI HI Castro, Manny $1,000.00 $62.00 $14.50…
Q: Flint Corporation is authorized to issue both preferred and common stock. The par value of the…
A: Journal entries are those which are reported in the books in order to record the daily transactions.…
Q: C. a. Borrowed $25,500 from a local bank; the loan is due in 9 months. b. Lent $8,200 to an…
A: The accounting equation is based on dual concept of accounting. The sum of assets if always equal to…
Q: eems 1,000 shares from Juan for $250,00 pital gain of $250,000. pital gain of $190,000. dend income…
A: Capital gain refers to the sum value of money gained by an entity while selling its asset above its…
Q: The above link pertains to 2021 annual report for the Walt Disney Company. Use the information…
A: Cash Flow statement is the statement that shows the inflow and outflow of cash in any business. This…
Q: Based on the fundamental principle of IAS2, identify two (2) circumstances where the NRV of…
A: The fundamental principles of IAS 2 are: 1) Recognition: Items should be recognized in the financial…
Q: Blossom Co. has the following transactions related to notes receivable during the last 2 months of…
A: Lets understand the basics. Journal entry is required to make to record event and transaction in…
Q: Cerulean Corporation has two equal shareholders, Marco and Avery. Marco acquired his Cerulean stock…
A: See the answer below The variety of tax regimes that may be applicable contributes to the…
Q: 1) World Coffee, Incorporated has provided the following information pertaining to the store's month…
A:
Q: exclusion be 11,700,000 assuming
A: Estate tax refers to the form of federal or state tax that is levied on certain assets whose total…
Q: Company ADF has been paying a dividend of $1.25 per quarter for several years. Its management plans…
A: Solution: To calculate the increase stock price when the company makes announcement to increase…
Q: The CEO of XYZ company has $1 million to spend to improve the company's operations. Although the…
A: Introduction: There are many ways to improve the existing business or starting a new business.…
Q: Dollar-Value LIFO Retail Intella Inc. adopted the dollar-value retail LIFO method on January 1,…
A: Solution Lifo i.e Last in first out is a method used for cost flow consumption purposes in the cost…
Q: Required Information [The following information applies to the questions displayed below.] The Air…
A: A learning rate of 70% means that a process is improved over time due to learning and it takes 70%…
SHOW FORMULAS IN EXCEL
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- Friendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?A manager must decide between two machines. The manager will take into account each machine's operating costs and initial costs, and its breakdown and repair times. Machine A has a projected average operating time of 131 hours and a projected average repair time of 4 hours. Projected times for machine B are an average operating time of 61 hours and a repair time of 5 hours. What are the projected availabilities of each machine? (Round your answers to 3 decimal places.) Answer is complete but not entirely correct. Availability 0.952 0.945 Machine A Machine BA manufacturing process can be designed for varying degrees of automation. The following is relevant cost information. Determine which is best by after-tax analysis using an income tax rate of 29%, an after-tax MARR of 16%, and SL depreciation. Assume that each has a life of six years and no BV or MV. Degree A B C D Click the icon to view the interest and annuity table for discrete compounding when the MARR is 16% per year. More Info N 1 2 3 4 5 6 7 8 9 10 Single Payment Compound Amount Factor To Find F Given P FIP 1.1600 1.3456 1.5609 1.8106 2.1003 Discrete Compounding; i = 16% Compound Amount Factor To Find F Given A FIA 1.0000 2.1600 3.5056 5.0665 6.8771 8.9775 11.4139 14.2401 17.5185 21.3215 2.4364 2.8262 3.2784 3.8030 4.4114 Present Worth Factor To Find P Given F PIF 0.8621 0.7432 0.6407 0.5523 0.4761 0.4104 0.3538 0.3050 0.2630 0.2267 Print Uniform Series Present Worth Factor To Find P Given A PIA 0.8621 1.6052 2.2459 2.7982 3.2743 3.6847 4.0386 4.3436 4.6065 4.8332 Done Sinking…
- USING EXCEL SOLVER Based on Kolesar and Blum (1973). Suppose that a company must service customers lying in an area of A square miles with n warehouses. Kolesar and Blum showed that when the warehouse(s) are located properly, the average distance between a warehouse and a customer is (Ayn)1y2. Assume that it costs the company $90,000 per year to maintain a warehouse and $400,000 to build a warehouse. Also, assume that a $5,000,000 building cost is equivalent to incurring a cost of $500,000 per year indefinitely. The company fills 180,000 orders per year, and the shipping cost per order is $1.25 per mile. If the company serves an area of 120 square miles, how many warehouses should it have? Can the formulas also be shown?The Chief Operations Officer (COO) of a manufacturing firm recommends one of the manufacturing sites to undergo a process improvement initiative. He claims that this project will enable the company to realize a net savings of at least $3.25 Mln. The Chief Financial Officer (CFO) of the company tasked you to conduct a financial analysis to verify the claims of the COO. After performing cost analysis, you estimated that the project will require an initial investment of $2 MIn today and $1 Mln in Year 1. Afterwards, the initiative will yield an annual cost savings of $850k from Year 2 to Year 10. You assume that these cost savings are realized at the end of each year. (a) Suppose that you use a discount rate of 5%. Will the resulting net savings support the claim of the COO? (b) Determine the Internal Rate of Return (IRR) of the process improvement initiative. (c) Show the NPV profile of the project.You have developed the following estimates for procuring an item for your manufacturing operations:? is 3,600 units yearly (10 units per day)? is ₱25 per item? is ₱35 per order? is 25% annuallyThe following two (2) options are available for you:Option 1: the supplier can supply all items at once.Option 2: The supplier can supply 15 items per day.Based on the information you have, which of the above options would you prefer?
- A library shelving system has a first cost of $24,500 and a useful life of 7 years. The annual maintenance is expected to be $2,900. The annual benefits to the library staff are expected to be $9,400. If the effective annual interest rate is 11.5%, what is the benefit-cost ratio of the shelving system?The textile factory is being upgraded. The expectation is that labor costs will decrease at an annual rate of 5% while overhead costs will increase at 8%. Now by the end of the first year the Labor costs $2million Material costs $3 million Overhead costs 1.6 million The time value of money rate is 11% and the time horizon is 7 years. Determine the dollar value for each cost category (labor, material, overhead) for each year and the total cost for each year. Determine the present worth of each cost category and the total cost. Determine the annual worth over 7 years that is equivalent to the present worth of the total cost.A facility has current liabilities of $448,923 and current assets of $562,244. What is the facility’s current ratio? A facility has current liabilities of $496,277 and current net assets of $199,896. What is the facility’s current ratio? Your facility has 195 residents and it requires 14 labor minutes per meal. How many labor hours are required per week? Last year’s food costs for your 130-bed facility were $172,430. Your facility had an average occupancy rate of 91% last year. What was the food cost per patient day (PPD)? If your assisted living facility needs to purchase a piece of equipment 5 years from today, and you can invest 6% compound interest, how much would your facility have to invest today to have approximately $13,382 in 5 years?
- Dilute hydrogen peroxide (H,0,) is produced in the facility where you work as an engineer. The company aims to invest in an additional concentration unit for the production of concentrated hydrogen peroxide (H,0,) in line with customer demands. For the establishment of the required unit, the finance company recommends the following financing model for 3 years: 100,000 TL will be paid every month in the first year, 150,000 TL will be paid every month in the second year and 175,000 TL will be paid every month in the third year. In addition, an additional balloon payment of 700.000 TL will be made in the 36th month. The monthly interest rate is 2.5%. a) If this proposed financing model was not chosen and all installments were paid equally, what would be the monthly equal installment amount? b) What would be the amount to be paid if no payment was made for this additional concentration facility for 3 years and it was made at the end of the 3rd year? раayment Find what is required by…Phoenix Management helps rental property owners find renters and charges the owners one-half of the first month's rent for this service. For August 2022, Phoenix expects to find renters for 100 apartments with an average first month's rent of $1,020. Budgeted cost data per tenant application for 2022 follow: ⚫ Professional labor: 1.5 hours at $20.00 per hour ⚫ Credit checks: $66.00 Phoenix expects other costs, including the lease payment for the building, secretarial help, and utilities, to be $4,600 per month. On average, Phoenix is successful in placing one tenant for every three applicants. Actual rental applications in August 2022 were 270. Phoenix paid $8,400 for 380 hours of professional labor. Credit checks went up to $71 per application. Other costs in August 2022 (lease, secretarial help, and utilities) were $5,200. The average first monthly rentals for August 2022 were $1,120 per apartment unit for 90 units. Required: 1. (a) What is the master budget variance for August 2022?…A consulting engineering company is proposing a project that it estimates will require 210hours of technical work. Their company-wide labor rate is $70.00 per hour. Based on workthe company has performed in recent years, their Labor Utilization Rate is 62.5% and theirBreak Even Multiplier is 2.1. The company wants to target a Profit of 30% for this project. I need to solve for direct labor cost, total labor cost, indirect cost, total cost, how much the company should charge, effective labor multiplier and non-labor indirect costs