View the step-by-step solution to:

# Candy Factory Machines Cost \$100 each. Workers charge \$150 each The following table describes all feasible combinations of capital and labor and the...

Part 1

This spreadsheet shows a table compiled by an industrial engineer in a chocolate factory. The table contains all feasible combinations of machines and labor and the associated output of candy.

Using Excel graphical methods (isoquants and isocosts) calculate the optimal combination of inputs to produce 20 tons of candy.

•Explain your methodology and the result.
•Accomplish an Excel Isoquant - Isocost graph of the 20 tons data.
Part 2

Use the same data in the above spreadsheet to answer the following question.

•Using Excel, calculate the optimal combination of inputs to produce 20 tons of candy.
•Accomplish Excel tables to calculate the combination of capital and labor that minimizes cost for producing 20 tons.
•Use regression to determine the mathematical equation for candy output (with capital and labor as your input/independent variables, and candy output as your dependent).
Use the Excel solver tool to calculate the combination of capital and labor that minimizes cost of 20 tons of production.

Candy Factory Machines Cost \$100 each. Workers charge \$150 each The following table describes all feasible combinations of capital and labor and the resulting output. Candy Machines Labor Output (tons) 10 26.9 10 20 20 10 30 16.8 10 40 14.9 10 50 13.5 10 60 12.5 10 70 11.7 10 80 11 10 90 10.5 10 100 10 10 110 9.6 10 120 9.3 10 130 9 10 140 8.7 10 150 8.4 10 10 72.5 20 20 53.8 20 30 45.2 20 40 40.0 20 50 36.4 20 60 33.6 20 70 31.5 20 80 29.7 20 90 28.3 20 100 27.0 20 110 25.9 20 120 25.0 20 130 24.1 20 140 23.4 20 150 22.7 20 10 129.3 30 20 96.1 30 30 80.8 30 40 71.4 30 50 64.9 30 60 60.0 30 70 56.2 30 80 53.0 30 90 50.4 30 100 48.2 30 110 46.3 30 120 44.6 30 130 43.1 30 140 41.7 30 150 40.5 30

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents