Precision Products specializes in custom-manufactured metal parts. The production manager has asked you to create an Excel
Question:
Precision Products specializes in custom-manufactured metal parts. The production manager has asked you to create an Excel spreadsheet to help manage operations. The company needs a way to calculate staffing requirements (number of employees) based on different levels of production. The five manufacturing operations are fabrication, welding, machining, assembly, and packaging. One unit of production requires 1.5 hours for fabrication, 2.25 hours for welding, 0.7 hours for machining, 3.2 hours for assembly, and 0.5 hours for packaging. Create the Excel spreadsheet shown in Figure 1-18 to calculate the weekly manpower required, at 40 hours per week, for production levels of 200, 300, 400, and 500 units. How does the total required for each level of production change if Precision Products operates a 45-hour production schedule?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 72% (11 reviews)
tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style43 msonumberformat 000 000 00220022 msostylenameComma msostyleid3 style0 msonumberformatGeneral textaligngeneral vertical...View the full answer
Answered By
ANDREW KIPRUTO
Academic Writing Expert
I have over 7 years of research and application experience. I am trained and licensed to provide expertise in IT information, computer sciences related topics and other units like chemistry, Business, law, biology, biochemistry, and genetics. I'm a network and IT admin with +8 years of experience in all kind of environments.
I can help you in the following areas:
Networking
- Ethernet, Wireless Airmax and 802.11, fiber networks on GPON/GEPON and WDM
- Protocols and IP Services: VLANs, LACP, ACLs, VPNs, OSPF, BGP, RADIUS, PPPoE, DNS, Proxies, SNMP
- Vendors: MikroTik, Ubiquiti, Cisco, Juniper, HP, Dell, DrayTek, SMC, Zyxel, Furukawa Electric, and many more
- Monitoring Systems: PRTG, Zabbix, Whatsup Gold, TheDude, RRDtoo
Always available for new projects! Contact me for any inquiries