Order For Similar Custom Papers & Assignment Help Services

Fill the order form details - writing instructions guides, and get your paper done.

Posted: February 23rd, 2022

Chapter 6 Excel

Exp19_Excel_Ch06_Cap_High_West_Fashions

Project Description:

You are the digital marketing director for High West Fashions, a regional clothing company that specializes in custom t-shirts. Your company has decided to launch an online advertising campaign that gives customers the ability to purchase heavily discounted products. You have the task of determining the optimal amount of advertising to purchase in order to maximize profit and most effectively utilize resources.

Steps to Perform:

StepInstructionsPoints Possible
1Start Excel. Download and open the file named Exp19_Excel_Ch06_Cap_DirectMarketing.xlsx. Grader has automatically added your last name to the beginning of the filename.0
2On the Direct Marketing worksheet, create appropriate range names for Design_Fee (cell B8), Cost_Per_Ad (cell B9), Total_Clicks (cell B10), Profit_Per_Click (B11), and Gross_Profit (cell B12).5
3Edit the existing name range Design_Fee to Design_Fee2021 to reflect the current year.4
4Use the newly created range names to create a formula to calculate Gross Profit (cell B12) and Net Profit (cell B13).6
5Create a new worksheet named Range Names, paste the newly created range name information in cell A1, and resize the columns as needed for proper display. Mac users, use the Insert menu to insert a new worksheet and paste the range names.5
6On the Direct Marketing worksheet, use Goal Seek to determine the optimal click rate in order to earn a $5,000 net profit.6
7Starting in cell E4. Complete the series of substitution values ranging from 2% to 6.5% at increments of .50% vertically down column E.5
8Enter references to the Gross Profit and Net Profit in the correct location for a one-variable data table.3
9Complete the one-variable data table, and then format the results with Accounting Number Format with two decimal places.6
10Apply custom number formats to display Gross Profit in cell F3 and Net Profit in cell G3.4
11Copy the response rate substitution values from the one-variable data table, and then paste the values starting in cell I4.4
12Type 10000 in cell J3. Complete the series of substitution values from 10000 to 40000 at 5000 increments.3
13Enter the reference to net profit formula in the correct location for a two-variable data table.4
14Complete the two-variable data table and format the results with Accounting Number Format with two decimal places.7
15Apply a custom number format to make the formula reference appear as Net Profit.3
16Make the Direct Marketing 2 worksheet active. Create a scenario named Best Case, using Number of Ads and Click Rate. Enter these values for the scenario: 40000, and 6.5%.4
17Create a second scenario named Worst Case, using the same changing cells. Enter these values for the scenario: 10000, and 1%.4
18Create a third scenario named Most Likely, using the same changing cells. Enter these values for the scenario: 10000, and 6.83%.4
19Generate a scenario summary report using Gross Profit and Net Income.4
20Return to the Direct Marketing 2 worksheet. Load the Solver add-in if it is not already loaded. Launch Solver and set the objective to calculate a net profit of $20,000.4
21Use Number of Ads and Click Rate (B4:B5) as changing variable cells.4
22Set a constraint to ensure Number of Ads purchased is less than or equal to 40,000.2
23Set a constraint to ensure Click Rate is less than or equal to 7%. (Mac users should enter the value in decimal form. Example .07)2
24Solve the problem. Generate the Answer Report.3
25Create a footer on all worksheets with your name on the left side, the sheet name code in the center, and the file name code on the right side.4
26Save and close Exp19_Excel_Ch06_CAP_DirectMarketing.xlsx. Exit Excel. Submit the file as directed.0
Total Points100

Created On: 06/12/2020 1 Exp19_Excel_Ch06_Cap – High West Fashions 1.5

Order | Check Discount

Tags: best essay writing service, best nursing essay writing service, best nursing essay writing services, biology essay writing service, business essay writing service

Assignment Help For You!

Special Offer! Get 20-25% Off On your Order!

Why choose us

You Want Quality and That’s What We Deliver

Top Skilled Writers

To ensure professionalism, we carefully curate our team by handpicking highly skilled writers and editors, each possessing specialized knowledge in distinct subject areas and a strong background in academic writing. This selection process guarantees that our writers are well-equipped to write on a variety of topics with expertise. Whether it's help writing an essay in nursing, medical, healthcare, management, psychology, and other related subjects, we have the right expert for you. Our diverse team 24/7 ensures that we can meet the specific needs of students across the various learning instututions.

Affordable Prices

The Essay Bishops 'write my paper' online service strives to provide the best writers at the most competitive rates—student-friendly cost, ensuring affordability without compromising on quality. We understand the financial constraints students face and aim to offer exceptional value. Our pricing is both fair and reasonable to college/university students in comparison to other paper writing services in the academic market. This commitment to affordability sets us apart and makes our services accessible to a wider range of students.

100% Plagiarism-Free

Minimal Similarity Index Score on our content. Rest assured, you'll never receive a product with any traces of plagiarism, AI, GenAI, or ChatGPT, as our team is dedicated to ensuring the highest standards of originality. We rigorously scan each final draft before it's sent to you, guaranteeing originality and maintaining our commitment to delivering plagiarism-free content. Your satisfaction and trust are our top priorities.

How it works

When you decide to place an order with Dissertation App, here is what happens:

Complete the Order Form

You will complete our order form, filling in all of the fields and giving us as much detail as possible.

Assignment of Writer

We analyze your order and match it with a writer who has the unique qualifications to complete it, and he begins from scratch.

Order in Production and Delivered

You and your writer communicate directly during the process, and, once you receive the final draft, you either approve it or ask for revisions.

Giving us Feedback (and other options)

We want to know how your experience went. You can read other clients’ testimonials too. And among many options, you can choose a favorite writer.