HomeworkLib
Question

Please complete all work in excel. Use excel to make the calculations and be sure to...

Please complete all work in excel. Use excel to make the calculations and be sure to identify your answer, including units.

3. The utilization of a machine is 70 percent. The machine has a design capacity of 240 units per hour and an effective capacity of 200 units per hour. Find the efficiency of the machine.

business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Utilization = (Actual Output/Design capacity)*100

70 = (Actual Output/240)*100

Actual Output = (70*240)/100

= 168

Efficiency = (Actual Output/Effective Capacity)*100

= (168/200)*100

= 84%

0 0
Add a comment
Know the answer?
Add Answer to:
Please complete all work in excel. Use excel to make the calculations and be sure to...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Please complete all work in excel. Use excel to make the calculations (cells can be clicked...

    Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. Upload one excel file for your submission. Delights Company is designing a production layout for a new product. They plan to use this production line 10 hours a day in order to meet forecasted demand of 80,000 units per day. For output to equal forecasted demand, what should the...

  • HW 1 (50 pts) – Please complete all work in excel. Use excel to make the...

    HW 1 (50 pts) – Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. 1. ProHaul specializes in trans-American shipments for businesses through the delivery of containers. For every container the company loads on its trucks, ProHaul estimates the haul costs $1,000. In addition, containers are weighed and for each pound, there are hauling fees of $0.15. ProHaul...

  • PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN ANSWER!!!!!!!! 9. The manufacturing company...

    PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN ANSWER!!!!!!!! 9. The manufacturing company uses 10,000 units of raw material at its workstations each 10 hours of production. The cycle time for a standard container, which holds 50 units, averages 30 minutes. If management uses an efficiency factor of 30 percent, how many containers should be used? PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN ANSWER!!!!!!!!

  • Please show all work in an Excel spreadsheet, showing all calculations in each cell. 3. CSM...

    Please show all work in an Excel spreadsheet, showing all calculations in each cell. 3. CSM Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for S485,000 is estimated to result in S184,000 in Sales minus Costs. The press falls in the MACRS five-year class, and it will have a salvage value at the end of the project of S55,000. The press also requires an initial investment in spare parts inventory of...

  • Complete the following calculations in an Excel file. Be sure to show and label your work...

    Complete the following calculations in an Excel file. Be sure to show and label your work for full credit. Grizzly Company produces stuffed bears. Based on its history, it typically uses 3 pounds of material for each bear, costing $6 per pound. Each bear is expected to have direct labor of 1 hour at a rate of $10.50. In the month of January, the company produced 155,000 bears. They had direct materials of 470,000 pounds, costing on average $5.95. Direct...

  • Please don’t use Excel and answer all the parts of the questions. Make sure to show your work!! Problem 3 Machine...

    Please don’t use Excel and answer all the parts of the questions. Make sure to show your work!! Problem 3 Machine Useful Life 20 yrs II 25 yrs Initial Cost Salvage Value Annual Operating Cost $80,000 $20,000 $18.000 $100,000 $25,000 $15,000 first 10 years 20,000 thereafter A company is considering buying a new piece of machinery. A 10 percent interest rate will be used in the computations. Two models of the machine are available. a. Determine which machine should be...

  • PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! PLEASE SHOW ALL WORK...

    PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! HW 4- All work must be completed in 1 excel file that, when necessary, includes cells that make calculations. 1) Information on a project's activities is shown in the following table ctivity Immediate Predecessor Activity Time (wks) Total Budgeted Cost 25,000 4 28,000 16,000 10 44,000 36,000 B, D, E 55,000 B, D, E 80,000 21,000...

  • pleas provide excel spreadsheet showing calculations thank you Read each question carefully! Make sure that you...

    pleas provide excel spreadsheet showing calculations thank you Read each question carefully! Make sure that you have answered all parts of each question. Please write your final answers in the spaces provided. Please attach any supporting documents for your answers. Spreadsheets should be well labelled and easy to read. Good Luck! Problem 1 - Master Budget Jensen Manufacturing has the following information relating to their master budget for 2020 Units Sold Selling Price 5,000 units $210 per unit Pounds of...

  • Please make sure you show ALL of your math, and please make sure your handwriting is...

    Please make sure you show ALL of your math, and please make sure your handwriting is clear. Capital (machines per hour) Q= 50,000 Labor (workers per hour) 10,000 5. Refer to the figure above. A firm has a budget of $200,000 to spend on labor and capital. It is currently producing 50,000 units of output using input bundle "A". The price of capital is $50 per machine hour. The slope of the isocost line (in absolute value) is and at...

  • Please use kinematic equation t cases Make sure to show all work in complete detail, NO...

    Please use kinematic equation t cases Make sure to show all work in complete detail, NO CREDIT will be given if no work is 1. A ball rolls off a table and falls 1.0 m to the floor, landing with a speed of 5.0 m/s. a) What was the initial speed of the ball when it rolls off the table? shown!l (10 pts) b) Calculate how far away from the base of the table does the ball hit the floor...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT