A company needs to produce widgets. Two machines are able to make the widgets. Machine A costs $20 to set up to begin production. Machine B cost $50 to set up. Machine A can make widgets at a cost of $2 each; Machine B can make widgets at a cost of $1.50 each. Machine A is stopped every time it has made 15 widgets for maintenance. This costs $5. (200 POINTS)
a. Prepare a table or chart in Microsoft Word to compare costs.
b. Using the table or chart and Microsoft Excel, and identify the break-even point.
c. Determine the least costly method and the cost to produce 40 widgets.
d. Determine the least costly method and the cost to produce 10 widgets.