subject
Business, 20.06.2020 22:57 laurenlay156

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: In cell B27, use Goal Seek to set cell B27 to a value of 0.
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.
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.
Create a two-variable data table to calculate the gross profit based on the number of wireless headphones sold and the price per unit:
For the range D14:K19, create a two-variable data table using the price per unit (cell B5) as the Row input cell.
se the units sold (cell B4) as the Column input cell.
Apply a custom format to cell D14 to display the text Units Sold/Price in place of the cell value.
Switch to the Noise-Cancelling worksheet. Create a Scatter with Straight Lines chart based on range D4:F14 in the data table Noise-Cancelling – Break-Even Analysis.
Modify the new chart as follows:
Resize and reposition the chart so that it covers the range D15:H32.
Add Sales and Expenses as the vertical axis title and Units Sold as the horizontal axis title.
Change the Bounds Axis Options as follows:
Change the Minimum Bounds of the vertical axis to 1750000 and the Maximum Bounds to 2650000.
Change the number format of the vertical axis to Currency with 0 decimal places and $ as the symbol.
Change the Minimum Bounds of the horizontal axis to 8500. (Hint: The Maximum Bounds should automatically change to 12,500.)
Create two scenarios to compare the costs for standard components and green components in the noise-cancelling headphones as follows:
In the Scenario Manager, add two scenarios using the data shown in bold in Table 1 below.
The changing cells for both scenarios are the nonadjacent cells B11 and B14.
Close the Scenario Manager without showing any of the scenarios.

ansver
Answers: 2

Other questions on the subject: Business

image
Business, 22.06.2019 07:00, ronnie7898
Amarket that consists of all possible consumers regardless of their specific needs or wants is a
Answers: 1
image
Business, 22.06.2019 19:20, cathydaves
Bcorporation, a merchandising company, reported the following results for october: sales $ 490,000 cost of goods sold (all variable) $ 169,700 total variable selling expense $ 24,200 total fixed selling expense $ 21,700 total variable administrative expense $ 13,200 total fixed administrative expense $ 33,600 the contribution margin for october is:
Answers: 1
image
Business, 22.06.2019 22:00, mdaniella522
In 2018, laureen is currently single. she paid $2,800 of qualified tuition and related expenses for each of her twin daughters sheri and meri to attend state university as freshmen ($2,800 each for a total of $5,600). sheri and meri qualify as laureen’s dependents. laureen also paid $1,900 for her son ryan’s (also laureen’s dependent) tuition and related expenses to attend his junior year at state university. finally, laureen paid $1,200 for herself to attend seminars at a community college to her improve her job skills. what is the maximum amount of education credits laureen can claim for these expenditures in each of the following alternative scenarios? a. laureen's agi is $45,000.b. laureen’s agi is $95,000.c. laureen’s agi is $45,000 and laureen paid $12,000 (not $1,900) for ryan to attend graduate school (i. e, his fifth year, not his junior year).
Answers: 2
image
Business, 23.06.2019 01:00, F00Dislife
What are the benefits of different types of career education, like community colleges, vocational training programs, and four-year colleges?
Answers: 3
You know the right answer?
Kylie and Derek Hurdy own Hurdy Headphones, a company that manufactures wireless and noise-cancellin...

Questions in other subjects:

Konu
English, 12.03.2021 17:30