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.

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.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter3: Cost Behavior

Section: Chapter Questions

Problem 2CE: Corazon Manufacturing Company has a purchasing department staffed by five purchasing agents. Each...

See similar textbooks

Similar questions

Keleher Industries manufactures pet doors and sells them directly to the consumer via their web site. The marketing manager believes that if the company invests in new software, they will increase their sales by 10%. The new software will increase fixed costs by $400 per month. Prepare a forecasted contribution margin income statement for Keleher Industries reflecting the new software cost and associated increase in sales. The previous annual statement is as follows:
Corazon Manufacturing Company has a purchasing department staffed by five purchasing agents. Each agent is paid 28,000 per year and is able to process 4,000 purchase orders. Last year, 17,800 purchase orders were processed by the five agents. Required: 1. Calculate the activity rate per purchase order. 2. Calculate, in terms of purchase orders, the: a. total activity availability b. unused capacity 3. Calculate the dollar cost of: a. total activity availability b. unused capacity 4. Express total activity availability in terms of activity capacity used and unused capacity. 5. What if one of the purchasing agents agreed to work half time for 14,000? How many purchase orders could be processed by four and a half purchasing agents? What would unused capacity be in purchase orders?
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?
In a new, highly automated factory, labor costs are expected to decrease at an annual rate of 5%; material costs will increase at an annual rate of 4%; overhead costs will increase at 8%. The labor, material, and overhead costsat the end of the first year are $2 million, $3 million, and $1.6 million, respectively. The time value of money rate is 11% and the time horizon is 7years. a. Determine the dollar value for each cost category (labor, material,overhead) for each year and the total cost for each year. b. Determine the present worth of each cost category and the total cost. c. Determine the annual worth over 7 years that is equivalent to the present worth of the total cost.
A consulting engineer is considering two pumps to meet a demand of 15,000 gallons/minute at 12 feet total dynamic head. The specific gravity of the liquid being pumped is 1.50. Pump A operates at 70% efficiency and costs $12,000; pump B operates at 75% efficiency and costs $18,000. Power costs $0.015/kilowatt-hour. Continuous pumping for 365 days/year is required (i.e., 24 hours/day). Using a MARR of 10% and assuming equalsalvage values for both pumps, how many years of service are required forpump B to be justified economically? (Note: Dynamic head times gallon/ minute times specific gravity divided by 3960 equals horsepower required. Horsepower times 0.746 equals kilowatts required.)
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 Mln 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.
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?
A publishing company is planning on developing an SPSS Manual for graduatestudents in doctoral programs. The book will cost $16 to produce and will sell for$24; fixed costs will be $160,000. The company estimates that sales will beapproximately 60,000.a) What is the company’s breakeven point?b) Find the estimated profit.
Consider the following: A factory can produce 150,000 units of a good/year at a cost of $100/unit may produce the good for 2 years Retail price is initially $500/unit, but will either increase or decrease by $100 during year 1, and then subsequently increase or decrease by $200 during year 2. Each year, the increase or decrease is equally likely Fixed costs of running the factory are $50M per year if the factory is implemented (not including rent) Rent is $10M, whether or not the factory is set-up We will assume risk neutrality and a 10% cost of capital For simplicity, we will assume that there is no initial (year 0) cashflow associated with the factory The production technology of the factory allows for flexible starting (but not stopping). This means that in year 1, the factory may be operated or not. If the factory is operational in year 1, it will also be operational in year 2. If the factory is not operational in year 1, then it may either be operated or not in year 2. What is…
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?
Sara James Bakery, described in Examples S1 and S2, has decided to increase its facilities by adding one additional process line. The firm will have two process lines, each working 7 days a week, 3 shifts per day, 8 hours per shift, with effective capacity of 300,000 rolls. This addition, however, will reduce overall system efficiency to 85%. Compute the expected production with this new effective capacity.
XYZ Company has two divisions, the logistics division and foods division. Suppose that the foods division has the opportunity to invest in two projects for the coming year. The first project is a new cheese-coated corn chip that requires additional factory space and special coating machinery. The second project is star-shaped corn chips. That project will require special extruding machinery to create the desired shapes. The outlay required for each investment, the dollar returns, and the ROI are as follows: Project I: Investment - $10,000,000, Operating income - $1,500,000, and ROI – 15% Project II: Investment - $4,000,000, Operating income - $760,000, and ROI – 19% The division is currently earning an ROI of 18 percent, using operating assets of $10 million to generate operating income of $1.8 million. Corporate…