Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please so how you got the answers thanks for you help ELS - Hurdy Headphones Wireless Models Wire Units Mes plenes Pront Analys Totales Total
please so how you got the answers thanks for you help
ELS - Hurdy Headphones Wireless Models Wire Units Mes plenes Pront Analys Totales Total Gris Profit 4 5 0 Units Sold Price Per Unit Total Sales 25,000 120.00 ,475.000.00 5 4 15,000 5 2.425,000 $2,520,000 20,000 53.530,000 3,250,000 25,000 5 4.475,000 $4,010,0005 30,000 $9,270,000 $4.700.000 $ 15.000 56,205,000 5 5510,000 5 175,000 30,000 455,000 10.000 155,000 8 Expenses 9 Varia Expand 10 Un Manufactured 11 Variable Cost per un 12 Total Vari Costs 13 Fed Expenses 14 Towed Cost 15 Expert - Total 16 Total Expose Per Unit Sold $ 3,750,000.00 200 16900 S Photos 171. 00 0 4,010,000.00 $ 5 1B Profit 19 Tot Sales 20 Total Expenses 21 Gross Pron 405.000.00 24 2 26 Price per Unit Cost Per Unit Uni Sot Grosi Profit OLIUILIS Styles 1. Kylie and Derek Hurdy own Hurdy Headphones, a company that manufactures wireless and noise-cancelling headphones and personalized earphones in Pittsburgh, Pennsylvania. As an intern at the company, you are developing a workbook that includes the financial details of each product line. Kylie and Derek have asked you to use the data to analyze scenarios that involve cutting expenses and raising prices. They want you to find the most profitable mix of products using the most cost-effective means of production. Switch to the Wireless worksheet. Perform a break-even analysis for wireless headphones as follows: a. In cell B27, use Goal Seek to set cell B27 to a value of 0. New Perspectives Excel 2016 | Module 10: SAM Project la b. Change the number of units sold in cell B26 to break even, or reach a Gross Profit of $0. (Hint: The number format applied to cell B27 will display the value of $0 as $ -.) Create a one-variable data table to calculate sales, expenses, and profits based on the number of wireless headphones sold as follows: In cell D5, enter a formula that references cell B4, which is the expected units sold for this product. b. In cell E5, enter a formula that references cell B19, which is the expected total sales for this product. In cell F5, enter a formula that references cell B20, which is the expected total expenses for this product. In cell G5, enter a formula that references cell B21, which is the expected gross profit for this product. Select the range D5: G10 and then complete the one-variable data table, using cell B4 as the Column input cell for your data table. Create a two-variable data table to calculate the gross profit based on the number of wireless headphones sold and the price per unit: a For the range D14:K19, create a two-variable data table using the price per unit (cell B5) as the Row input cell. b. Use the units sold (cell B4) as the Column input cell. Apply a custom format to cell D 14 to display the text Units Sold/Price in place of the cell valueStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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