Business, 26.03.2021 19:00 22ksotoq

A Skills Approach: Excel 2016 Chapter 8: Exploring Advanced Data Analysis 1 | Page Challenge Yourself 8.4 Last Updated 4/9/18 Challenge Yourself 8.4 In this project, you will use scenarios and a scenario summary to analyze car purchasing options. The data for this project were downloaded from: https://www. fueleconomy. gov/feg/download. shtml You will use custom filtering to find the data you are interested in and copy it from this very large data set to another worksheet. You will then use Advanced Filter, conditional formatting, sorting, and subtotals to further analyze this subset of data. You will manipulate a PivotTable created from the main vehicle data set. Finally, you will use Solver to solve a business problem to help you pay for your new car. Skills needed to complete this project: • Creating What-If Analysis Scenarios • Creating Scenario Summary Reports • Creating a Custom Filter • Using Advanced Filter • Creating New Conditional Formatting Rules • Sorting Data on Multiple Criteria • Adding Subtotals • Changing the Look of a PivotTable • Filtering PivotTable Data • Activating the Solver Add-Inn • Using Solver 1. Open the start file EX2016-ChallengeYourself-8-4. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 2. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook. 3. You want to purchase a new car. Your current car is worth $3,500 as a trade-in. The base sticker price on the car you want is $24,595. The first financing offer from the dealer is 1.9% APR for 24 months, with no cash back. The original financing offer terms are listed in cells A3:B9 on the Car Loan worksheet. Cell B10 contains a formula with a PMT function to calculate the monthly payment. Use what-if analysis tools to compare financing options. Create scenarios to compare financing options for the car loan. a. Create names for the following cells on the Car Loan worksheet to make the scenarios easier to follow: Name cell B3: Price Name cell B4: TradeIn Name cell B5: CashBack Name cell B6: Loan Name cell B8: Months Name cell B9: APR Name cell B10: Payment Name cell B12: TotalCost

Answers: 1

Show answers

Another question on Business

Business, 22.06.2019 12:50

Afirm’s production function is represented by q(m,r) = 4m 3/4r1/3, where q denotes output, m raw materials, and r robots. the firm is currently using 6 units of raw materials and 12 robots. according to the mrts, in order to maintain its output level the firm would need to give up 2 robots if it adds 9 units of raw materials. (a) true (b) false

Answers: 3

Answer

Business, 22.06.2019 15:00

1. list five staple convenience goods that you or your household buys on a regular basis. (you do not need to use complete sentences. 2.5 points) 2. list three impulse convenience goods that you or someone you know has purchased. (you do not need to use complete sentences. 2.5 points) 3. describe a shopping good that you or someone you know purchased. what kind of research did you or that person do before buying the product? (1-5 sentences. 3.0 points) 4. choose an example of a company you could start, and decide which business structure would make the most sense for that type of company (sole proprietorship, partnership, llc, c corporation, s corporation, or nonprofit corporation). explain why this structure would be good for this type of company. give at least 3 reasons. (3-6 sentences. 6.0 points) 5. if you were starting a new business, describe at least three departments to the company that you would need right away. why are these departments so important? (1-5 sentences. 3.0 points) 6. describe a product that you think has saturated its market. what makes you think it has saturated its market? (1-5 sentences. 3.0 points)

Answers: 2

Answer

Business, 22.06.2019 18:20

Now ray has had the tires for two months and he notices that the tread has started to pull away from the tire. he has already contacted the place who sold the tires and calmly and accurately explained the problem. they didn’t him because they no longer carry that tire. so he talked with the manager and he still did not get the tire replaced. his consumer rights are being violated. pretend you are ray and write a letter to the company’s headquarters. here are some points to keep in mind when writing the letter: include your name, address, and account number, if appropriate. describe your purchase (name of product, serial numbers, date and location of purchase). state the problem and give the history of how you tried to resolve the problem. ask for a specific action. include how you can be reached.

Answers: 3

Answer

Business, 22.06.2019 19:40

The following cost and inventory data are taken from the accounting records of mason company for the year just completed: costs incurred: direct labor cost $ 90,000 purchases of raw materials $ 134,000 manufacturing overhead $ 205,000 advertising expense $ 45,000 sales salaries $ 101,000 depreciation, office equipment $ 225,000 beginning of the year end of the year inventories: raw materials $ 8,100 $ 10,300 work in process $ 5,900 $ 21,000 finished goods $ 77,000 $ 25,800 required: 1. prepare a schedule of cost of goods manufactured. 2. prepare the cost of goods sold section of mason company’s income statement for the year.

Answers: 3

Answer

You know the right answer?

A Skills Approach: Excel 2016 Chapter 8: Exploring Advanced Data Analysis 1 | Page Challenge Yoursel...

Questions