Question: What is the correct format to put into an excel spreadsheet? I think I am missing something: 8-31 Cost Relationships The following costs are for

What is the correct format to put into an excel spreadsheet? I think I am missing something:

8-31 Cost Relationships The following costs are for Optical View Inc., a contact lens manufacturer: Output in Units 250 300 350 400 Fixed Costs $4,750 4,750 4,750 4,750 Variable Costs $ 7,500 9,000 10,500 12,000 Total Costs $12,250 13,750 15,250 16,750 Required 1. Calculate and graph total costs, total variable cost, and total fixed cost. 2. For each level of output calculate the per-unit total cost, per-unit variable cost, and per-unit fixed cost. 3. Using the results from requirement 2, graph the per-unit total cost, per-unit variable cost, and per-unit fixed cost, and discuss the behavior of the per-unit costs over the given output levels
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
