Calculate the weekly staffing required at 40 hours per week

Assignment Help Management Information Sys

Reference no: EM13762845

EXCEL APPLICATION: Manpower Planning Spreadsheet

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 staffing 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?

Reference no: EM13762845

Questions Cloud

Strategies for testing internal controls : Briefly describe three strategies for testing internal controls when information technology is used for significant accounting processing.

Polymorphism concepts : Explain polymorphism concepts in java

Problem related to foreign tax credits : Your client is a U.S.-based company that owns a foreign subsidiary. Your client understands that there are foreign tax credits of which they may be able to take advantage. Based on the e-Activity, recommend a strategy to optimize the use of foreig..

Ecological theories to explore this co-existence : Write a reflective commentary The course concepts are evident in all of the readings--you just have to look carefully and with an open mind. Consider the following in making your reading choice.

Calculate the weekly staffing required at 40 hours per week : Create the Excel spreadsheet shown in Figure 1-18 to calculate the weekly staffing required, at 40 hours per week, for production levels of 200, 300, 400, and 500 units

The estrada company uses cost-plus pricing : The Estrada Company uses cost-plus pricing with a 0.32 markup. The company is currently selling 100,000 units. Each unit has a variable cost of $3.80. In addition, the company incurs $184,400 in fixed costs annually. If demand falls to $76,000 units ..

Critical infrastructure protection : According to the text, Critical Infrastructure Protection (CIP) is an important cybersecurity initiative that requires careful planning and coordination in protecting our infrastructure.

Calculate the revenue from the groupon campaign : A local dental practice decides to run a Groupon campaign. The campaign offered $365 worth of dental services (such as teeth whitening) for $165. For the total campaign, 235 coupons were sold.

Problem related to the tax exemptions : You are a CPA and a client has asked you to advise them on how to exclude U.S. income tax on money earned while he was working in a foreign country. Recommend a strategy to your client that will minimize the U.S. tax obligations. Support your reco..

User Account

All Pages