Question $2$

Let$$s assume that we want to make a vacuum that requires $2$ parts of Metal and $5$ parts of Plastic each unit. Each unit also requires $1$ hour of labor. The factory space costs $$2,000$ in rent and requires a supervisor who is paid $$1,000.$ The factory space costs and supervisor$$s pay are unrelated to the number of units produced. Electricity costs $$500$ and this expense is fixed.

Assume that the cost of each part of Metal $=$ $$30$

Assume that the cost of each part of Plastic $=$ $$15$

Cost of labor $=$ $$50$ per hour

Note: Questions A$-$E can all be answered using one large table for convenience, following the example in the Excel file uploaded.

Question A $(2$ points$)$:

Produce a table showing the total costs of production for the following range of units produced: $5-50($please use increments of $5$ i$.$e$.,51015...4550)$

Question B $(2$ points$)$:

Produce a table showing the fixed and variable costs of production for the following range of units produced: $5-50$

Question C $(2$ points$)$:

Produce a table showing the fixed and variable costs per unit of production for the following

range of units produced: $5-50$

Question D $(2$ points$)$:

At what price should we sell each vacuum if our goal is to break even $($i$.$e$.,$ profit $=$ zero$)$ assuming we are selling $50$ vacuums. You can use either formulas for Contribution Margin or Goal$-$Seek in Excel.

Question E $(2$ points$)$:

Let$$s say that we are producing $50$ vacuums, but we don$$t know what the price of Metal nor the price of Plastic will be$.$ All we know is that the price of Metal can be anywhere between $$20$ and $$40$ and the price of Plastic can be anywhere between $$10$ and $$20.$

Produce a table that shows the total cost of production based on the varying prices of both Metal and Plastic. Use $$2$ increments for Metal and $$1$ increments for Plastic when modeling the table.