SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 1 Day Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 19 Nov 2017 My Price 10.00

Complete the tasks below and upload your completed file via Blackboard.

Need help completing this Excel assignment. The Word document is the steps for the assignment and the Excel file is what I am provided to start my work.

 

This is due by June 26th at midnight.

 

Please and thank you!

CSC 141:  http://biztoolspro.com/functions/Breake1.jpgHWK #8:  One Variable Data Table & Goal Seek

 

 

Instructions:  Download the Light workbook and rename it as:  lastname_hwk7 (replacing your last name).  Complete the tasks below and upload your completed file via Blackboard.

 

Scenario:  You have been asked to analyze cost-volume-profit relationship for product sales of Light Styk.

Tasks:

1.  Complete the Documentation worksheet.  Input the date as a function that will display the current date when opened.

2.  Create a one-variable data table (beginning in the E column) in the Income Statement worksheet that calculates Revenue, Expenses and Net Income (hint:  create three separate columns) for sales volumes ranging from 0 units sold to 30,000 units sold in increments of 5,000 units. Format the resulting values appropriately and build custom formats as appropriate.

3.  Copy the Income Statement worksheet into a new worksheet and name it “Goal Seek”.  Using Goal Seek, determine the number of Units that would need to be sold in order to generate Revenue of $170,000.  Format the cell that displays the calculated number of Units with yellow fill.

4.  Rename your worksheet:  lastname_hwk8  (replacing your own last name) and upload it via the assignment link in Blackboard.

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 19 Nov 2017 09:11 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)