Posted: February 23rd, 2022

Chapter 6 Excel

Exp19_Excel_Ch06_Cap_High_West_Fashions

Venture Description:

You’re the digital advertising and marketing director for Excessive West Fashions, a regional clothes firm that makes a speciality of customized t-shirts. Your organization has determined to launch an internet promoting marketing campaign that offers clients the power to buy closely discounted merchandise. You’ve got the duty of figuring out the optimum quantity of promoting to buy as a way to maximize revenue and most successfully make the most of sources.

Steps to Carry out:

Step	Directions	Factors Attainable
1	Begin Excel. Obtain and open the file named Exp19_Excel_Ch06_Cap_DirectMarketing.xlsx. Grader has robotically added your final identify to the start of the filename.	zero
2	On the Direct Advertising and marketing worksheet, create acceptable vary 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
three	Edit the prevailing identify vary Design_Fee to Design_Fee2021 to mirror the present 12 months.	four
four	Use the newly created vary names to create a system to calculate Gross Revenue (cell B12) and Internet Revenue (cell B13).	6
5	Create a brand new worksheet named Vary Names, paste the newly created vary identify info in cell A1, and resize the columns as wanted for correct show. Mac customers, use the Insert menu to insert a brand new worksheet and paste the vary names.	5
6	On the Direct Advertising and marketing worksheet, use Purpose Search to find out the optimum click on charge as a way to earn a $5,000 web revenue.	6
7	Beginning in cell E4. Full the collection of substitution values starting from 2% to 6.5% at increments of .50% vertically down column E.	5
eight	Enter references to the Gross Revenue and Internet Revenue within the right location for a one-variable information desk.	three
9	Full the one-variable information desk, after which format the outcomes with Accounting Quantity Format with two decimal locations.	6
10	Apply customized quantity codecs to show Gross Revenue in cell F3 and Internet Revenue in cell G3.	four
11	Copy the response charge substitution values from the one-variable information desk, after which paste the values beginning in cell I4.	four
12	Kind 10000 in cell J3. Full the collection of substitution values from 10000 to 40000 at 5000 increments.	three
13	Enter the reference to web revenue system within the right location for a two-variable information desk.	four
14	Full the two-variable information desk and format the outcomes with Accounting Quantity Format with two decimal locations.	7
15	Apply a customized quantity format to make the system reference seem as Internet Revenue.	three
16	Make the Direct Advertising and marketing 2 worksheet energetic. Create a state of affairs named Greatest Case, utilizing Variety of Advertisements and Click on Fee. Enter these values for the state of affairs: 40000, and 6.5%.	four
17	Create a second state of affairs named Worst Case, utilizing the identical altering cells. Enter these values for the state of affairs: 10000, and 1%.	four
18	Create a 3rd state of affairs named Most Doubtless, utilizing the identical altering cells. Enter these values for the state of affairs: 10000, and 6.83%.	four
19	Generate a state of affairs abstract report utilizing Gross Revenue and Internet Earnings.	four
20	Return to the Direct Advertising and marketing 2 worksheet. Load the Solver add-in if it isn’t already loaded. Launch Solver and set the target to calculate a web revenue of $20,000.	four
21	Use Variety of Advertisements and Click on Fee (B4:B5) as altering variable cells.	four
22	Set a constraint to make sure Variety of Advertisements bought is lower than or equal to 40,000.	2
23	Set a constraint to make sure Click on Fee is lower than or equal to 7%. (Mac customers ought to enter the worth in decimal type. Instance .07)	2
24	Remedy the issue. Generate the Reply Report.	three
25	Create a footer on all worksheets along with your identify on the left aspect, the sheet identify code within the middle, and the file identify code on the appropriate aspect.	four
26	Save and shut Exp19_Excel_Ch06_CAP_DirectMarketing.xlsx. Exit Excel. Submit the file as directed.	zero

Whole Factors

100

Created On: 06/12/2020 1 Exp19_Excel_Ch06_Cap – Excessive 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, Expert Nursing Assignment Help Online