Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Quiz Company reported the following costs for various levels of monthly output. Units produced Total cost 10,000 327,000 12,000 380,000 9,000 297,000 10,500 330,000 11,250
- Quiz Company reported the following costs for various levels of monthly output.
Units produced | Total cost |
10,000 | 327,000 |
12,000 | 380,000 |
9,000 | 297,000 |
10,500 | 330,000 |
11,250 | 363,000 |
9,800 | 319,000 |
11,000 | 350,000 |
10,250 | 333,000 |
10,750 | 347,000 |
9,500 | 315,000 |
Using the regression functions in Excel, determine an estimate of total fixed cost.
Note: Give your answer using dollar signs and commas but no decimal points (cents).
Round your answer to the nearest dollar.
Example: $12,345
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started