Question: need excel help Easy Electronics produces an easy-to-use high-end compact disc player that sells for $1,500. Total operating expenses for the past 12 months are
need excel helpEasy Electronics produces an easy-to-use high-end compact disc player that sells for $1,500. Total operating expenses for the past 12 months are as follows: Required: 1. Using the high-low method, create a total cost formula for the production of the compact disc player. 2. Using the cost formula created from requirement 1 , what would next month's predicted cost be if 675 units are produced? 3. Using Excel, run a regression analysis on the data above. Make sure to turn in the file with your homework. 4. Create a cost formula using the results from your regression analysis (round out to 4 decimals places when creating your formula). Using this new cost formula, what would next month's predicted cost be if 675 units are produced? 5. What is R squared based on your results? Do you think that units produced is a good indicator of total cost
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
