### Provide a total cost summary

Assignment Help Microeconomics
##### Reference no: EM13737309

Engineers are often tasked with determining the cost of manufacturing a product. Such cost modeling can be extremely detailed and extensive. You will perform a cost model analysis using an Excel Spreadsheet provided to you on BlackBoard. The spreadsheet contains all of the key costs for equipment, materials, labor, and facilities. There are 3 major process steps, and there are 3 different pieces of equipment (different vendors) available for you to use at each step. Each piece of equipment has a different cost, throughput, yield, support requirement, and space requirement. You will determine the set of equipment and the number of equipment sets to use for manufacturing. You must determine within reason the number of sets to use. For example, you might have 3 pieces of one type of equipment but not hundreds. Do not mix equipment from different vendors for the same process step, but you can certainly mix vendors for the different steps. The important factor is cost.

(1) Build your cost model but calculate labor, equipment depreciation, material, and facility costs separately. Then provide a total cost summary. You must choose the number of parts to fabricate (per year or per week). More parts results in lower depreciation costs for the facility but also requires more equipment.

(2) Use a 5 year depreciation for the equipment and 40 year for the facility

(3) Model the factory for Four shifts of 12 hrs/day and 7 days per week. Assume ONLY 20 hrs/day of actual operation for production but include labor costs for 24 hrs/day. The other 4 hrs is set aside for maintenance and down time.

(4) After creating your model to calculate the total cost, including yield, model the case by choosing the appropriate equipment sets for your factory. This process will be iterative. Find the lowest cost for each case.

(5) Note that if equipment requires 0.5 operators and if you only have one piece of equipment, you must round up to a full person.

(6) Include fringe costs for labor as given at 30%. Include "Other Factory" labor costs as provided. These costs represent administrative, accounting, management, safety, shipping, and janitorial services.

(7) Now create a summary of costs in your spreadsheet showing total labor, equipment, facility, material, and overhead costs. Use a Pie chart to show breakdown of costs by area: labor, equipment depreciation, materials, etc. Include net yield calculations.

(8) Write a short, professional quality, 5-6 page report summarizing your factory operation. The report MUST include an Executive Summary and an Introduction. Provide a summary table of equipment sets and tool costs along with labor requirements (# of people per area). Pie chart of the cost breakdown is required. Provide the final cost (table form) of the model. Provide a brief analysis of the approach that you took to minimize costs and analyze your results. What were the biggest cost factors and why?

### Previous Q& A

#### Defining the project scope

Review the project case. Determine the scope of the District 4 Production Warehouse Move project from the information provided in the case. Using the Project Scope Checklist, prepare a scope document for review and approval by the project sponsor ..

#### Write an essay on statue of an offering bearer

The analysis of Statue of an Offering Bearer should begin with an introduction of the artwork that includes the title, date, medium (material from which it is made), and the museum in which it is located.

#### Project team and stakeholder management

As the project manager for the District 4 Warehouse Move project, you will need to determine who your stakeholders and project team members are for this project.

#### What is the highest expense for business operations

What is the highest expense for business operations? How can managers monitor and keep this cost as low as possible? Explain.

#### Activity data set

how to do this activity data set?Student Gender Age Years of Work Experience Hours Spent on the HomeworkJenny F 42 27 2.5

#### Benefit of a health care organization

Determine a key benefit of a health care organization having positive employee relations. Support your rationale.

#### Explain how country differences manufacturing technology

Explain how country differences manufacturing technology and the product features affect the choice of where to locate production operations

#### Find the interest her money earned

How much would Denise have in this IRA annuity account after 18 years and Find the interest her money has earned during that 20 years

#### Problem related to international marketing

Marketing on an international level is considerably more complex and expensive than a domestic marketing plan. You will find international marketing is a diverse and complex environment that can be selective by country or region.

#### Does a localization strategy makes sense

1.In what kind of industries does a localization strategy makes sense? Why? When does a global standardization strategy make most sense? Why?

### Similar Q& A

#### Decide the after-tax equivalent present worth

A certain engine lathe can be purchased for \$330,000 and depreciated over three years to a zero salvage value with the SL method. This machine will produce metal parts that will generate revenues of \$220,000 (time zero dollars) per year.

#### What is the price elasticity of demand for gasoline

What is your price elasticity of demand for gasoline and why How important is fuel efficiency to you (particularly if you have purchased a car in the past three or four years) Do your driving habits change as the price of gasoline changes

#### How does demand impact other policy-holders

As more potentially life-saving, but expensive drugs come to market, patients and insurance companies have difficult decisions to make. While in theory people would pay anything to save their own life or that of a family member, the efficacy of so..

#### Monopoly and price fixing

Monopoly and Price Fixing

#### Relatively price elastic or relatively price inelastic

Identify and enumerate the factors affecting the supply, demand, and price for the company's products and examine whether the demand for the company's products is relatively price elastic or relatively price inelastic and explain why.

#### Income and substitution effects

What happens to the student's budget line? Illustrate the change with new books on the vertical axis. Is the student worse off or better off after the price change. Explain.

#### Problem 1 in the model of a dominant firm assume that the

problem 1 in the model of a dominant firm assume that the fringe. supply curve is given by q -1 0.2p where p is

#### Make clear the direction of the change in both price

Use supply and demand curve shifts to illustrate the effect of the following events on the market for apples. Make clear the direction of the change in both price and quantity sold

#### Credit card companies are readjusting interest rates

Credit card companies are readjusting interest rates and the amount of annual fees. Should this be allowed or should the Government limit the discretion of the credit card companies. How should the Federal Reserve Bank exercise it’s authority in this..

#### Along a downward-sloping linear demand curve

If the elasticity of demand for hamburgers equals _1.5 and the quantity demanded equals 40,000, predict what will happen to the quantity demanded of hamburgers when the price increases by 10 percent. If the price falls by 5   percent, what will happe..

#### 1 consider how unemployment would affect the solow growth

1. consider how unemployment would affect the solow growth model. suppose that output is produced according to the

#### Create the plan for managing your debt how many sources of

develop a plan for managing your debt. how many sources of debt do you current have and what are the balances owed on

#### Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!