ZuoTi.Pro
Question

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!!!!!!!!

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

Homework Answers

Answer #1

1 The farmula to tind out ember at containers is, N-sior-X)jic N no of containers T-average wairing time for replenishment+ verage producrion time for a conrainer of parts(mustbe X-policy wariabieet h maet to rafient inefficiney imclase o 8, more officienr i s) C-capacity of a standard container t same wnir as D 8 D-funils used during its production timehours of production) 9 1000Wi0 10 1000 parts 1] X-30%-0.3 15 17 1 containers 19 19 hersce the nunber of cequired -13 20 21

0 0
Add a comment
Know the answer?
Add Answer to:
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN ANSWER!!!!!!!! 9. The manufacturing company...
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 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...

  • 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 work on excel spreadsheet with calculations Problem 3: Job Costing - Two Departments (20...

    please show work on excel spreadsheet with calculations Problem 3: Job Costing - Two Departments (20 points) Rhett Company has two departments, Machining and Assembly. The following estimates are for the coming year. Machining Assembly Direct manufacturing labor-hours 10,000 50,000 Machine-hours 40,000 10,000 Manufacturing overhead $400,000 $800,000 The machining department uses direct labor hours to allocate overhead while the assembly department uses machine hours. The actual data for Job # 1 is as follows: Machining 50 Assembly 20 Direct manufacturing...

  • Please show your work with the formulas/calculations written out (for example; without using excel tables). 9....

    Please show your work with the formulas/calculations written out (for example; without using excel tables). 9. If you paid $750 for an investment 25 years ago that is now worth $2000, what was your rate of return? 10. If you save $100 per month, what annual rate of interest must you earn in order to accumulate $10,000 after 10 years? 11. If you borrow $250,000 for 10 years and your monthly payment is $1000, what rate of interest are you...

  • IN AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE 1) buring the...

    IN AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE 1) buring the period of time that a local university takes phone-in registrations, calls come in at the rate of one every two minutes a. Clearly state what the random variable in this problem is? b. What is an appropriate distribution to be used for this problem and why? c. What is the expected number of calls in one hour? d. What is the probability of receiving...

  • *******Please show ALL WORK/FORMULAS IN EXCEL AND SEPARATE THE ANSWERS FOR A/B/C SO I CAN CLEARLY...

    *******Please show ALL WORK/FORMULAS IN EXCEL AND SEPARATE THE ANSWERS FOR A/B/C SO I CAN CLEARLY SEE THEM****** TAKE PICTURES OF FORMULAS IN EXCEL AND PASTE THEM HERE. SHOW WHERE EACH CORRESPONDING FORMULA BELONGS IN EACH CELL, ETC 1. Moving Average Model (please review spreadsheet model of Forecast 1.xlsx.) Given the annual sales (in $1000s) for a small business (See 1st worksheet in Assignment 2.xlsx), answer the following questions. Please use 2-period Moving Average method to forecast the sales in...

  • Please show all work. If using excel please show formulas. A proposed cost-saving device has an...

    Please show all work. If using excel please show formulas. A proposed cost-saving device has an installed cost of $695,000. The device will be used in a five-year project but is classified as three-year MACRS property for tax purposes. The required initial net working capital investment is $105,000, the marginal tax rate is 25 percent, and the project discount rate is 11 percent. The device has an estimated Year 5 salvage value of $80,000. What level of pretax cost savings...

  • N AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE Use Excel function...

    N AN EXCEL FILE USING EXCEL FUNCTIONS CALCULATIONS SHOW FORMULAS IN CELL PLEASE Use Excel function and write down the Poisson Distribution (with mean = 5.5) in a Table and plot the chart. 1) (Ctrl)" |

  • Please show all the formulas used and the calculations and not only an excel table 8.33...

    Please show all the formulas used and the calculations and not only an excel table 8.33 Three assets were purchased in February 2005 and placed in service according to the following table. Date CCA Class 10 43 Placed Capital Property Type Car Arc Welder Freezer in Service Cost Feb. 12, 2005 $15,000 Nov. 11, 2005 12,000 $8,000 Jan. 6, 2006 Compute the CCA by year for each asset up to, and including, the year 2009.

  • 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...

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
ADVERTISEMENT