Answered step by step
Verified Expert Solution
Question
1 Approved Answer
how do i load an excel file? Change the Bounds Axis Options for the new chart as follows: a. Change the Minimum Bounds of the
how do i load an excel file?
Change the Bounds Axis Options for the new chart as follows: a. Change the Minimum Bounds of the vertical axis to -100000 and the Maximum Bounds to 620000. b. Change the number format of the vertical axis to Currency with o decimal places and $ as the symbol. C. Change the Minimum Bounds of the horizontal axis to 10500 and the Maximum Bounds to 14500. Edit the chart series names as follows: a. For Series 1, set the series name to cell E5. (Hint: The series name should automatically update to "='Earphones'!$E$5".) For Series 2, set the series name to cell F5. C. For Series 3, set the series name to cell G5. d. For Series 4, set the series name to cell H5. e. For Series 5, set the series name to cell 15. Hurdy Headphones - Personalized Earphones Units Sold Price Per Unit Total Sales 12.500 99.00 1,237,500.00 5 6 S $ $ Units Sold 10.500 11,000 11.500 12,000 12,500 13,000 13.500 14,000 14,500 & Expenses 9 Variable Expenses 10 Units Manufactured 11 Variable Cost per Unit 12 Total Variable Costs 13 Fixed Costs 14 Total Fixed Cost 15 Expenses - Total 16 Total Expense Per Unit Sold Personalized Earphones - Net Income Analysis Average Price per Unit 79.00 $ 89.00 $ 99.00 $ 109.00 155.250 49,750 154.750 145,500) 64,500 174.500 284.500 (35,750) 79,250 194.250 309 250 (26,000) 94,000 214,000 334 000 (16,250) 108,750 233,750 358,750 16,500) 123.500 253.500 383.500 3.250 138.250 273,250 40B 250 13,000 153.000 293.000 433.000 22.750 167.750 312.750 457.750 119.00 364.750 394,500 424,250 454,000 483.750 513,500 543,250 573,000 602.750 12.500 59.50 743,750.00 $ $ $ S 260,000.00 1,003,750.00 80.30 18 Profit 19 Total Sales 20 Total Expenses 21 Gross Profit 1,237.500.00 1,003,750.00 233.750.00 23 Break-even Analysis 24 Price per Unit Cost Per Unit Units Sold Gross Profit 99.00 80.30 12.500 233,750.00 $ Change the Bounds Axis Options for the new chart as follows: a. Change the Minimum Bounds of the vertical axis to -100000 and the Maximum Bounds to 620000. b. Change the number format of the vertical axis to Currency with o decimal places and $ as the symbol. C. Change the Minimum Bounds of the horizontal axis to 10500 and the Maximum Bounds to 14500. Edit the chart series names as follows: a. For Series 1, set the series name to cell E5. (Hint: The series name should automatically update to "='Earphones'!$E$5".) For Series 2, set the series name to cell F5. C. For Series 3, set the series name to cell G5. d. For Series 4, set the series name to cell H5. e. For Series 5, set the series name to cell 15. Hurdy Headphones - Personalized Earphones Units Sold Price Per Unit Total Sales 12.500 99.00 1,237,500.00 5 6 S $ $ Units Sold 10.500 11,000 11.500 12,000 12,500 13,000 13.500 14,000 14,500 & Expenses 9 Variable Expenses 10 Units Manufactured 11 Variable Cost per Unit 12 Total Variable Costs 13 Fixed Costs 14 Total Fixed Cost 15 Expenses - Total 16 Total Expense Per Unit Sold Personalized Earphones - Net Income Analysis Average Price per Unit 79.00 $ 89.00 $ 99.00 $ 109.00 155.250 49,750 154.750 145,500) 64,500 174.500 284.500 (35,750) 79,250 194.250 309 250 (26,000) 94,000 214,000 334 000 (16,250) 108,750 233,750 358,750 16,500) 123.500 253.500 383.500 3.250 138.250 273,250 40B 250 13,000 153.000 293.000 433.000 22.750 167.750 312.750 457.750 119.00 364.750 394,500 424,250 454,000 483.750 513,500 543,250 573,000 602.750 12.500 59.50 743,750.00 $ $ $ S 260,000.00 1,003,750.00 80.30 18 Profit 19 Total Sales 20 Total Expenses 21 Gross Profit 1,237.500.00 1,003,750.00 233.750.00 23 Break-even Analysis 24 Price per Unit Cost Per Unit Units Sold Gross Profit 99.00 80.30 12.500 233,750.00 $ 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