Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Custom units in excel

29/03/2021 Client: saad24vbs Deadline: 2 Day

New Perspectives Excel 2013| Tutorial 10: SAM Project 1a

New Perspectives Excel 2013

Tutorial 10: SAM Project 1a

Firestone Clock Company

WHAT-IF ANALYSES AND SCENARIOS

Project Goal

M Project Name

Project Goal

PROJECT DESCRIPTION
Walter Silva runs operations at Firestone Clock Company. The company currently owns and operates its own manufacturing facilities that produce three lines of clocks, Desktop Models, Wall Units, and Custom Clocks. Manufacturing and other costs have been rising, and profits are being squeezed. Walter has asked you to create a workbook that details the financial components of each product line, then analyze a number of scenarios that involve cutting expenses and/or raising prices. You are trying to find the most profitable mix of products using the most cost-effective means of production.

GETTING STARTED
· Download the following file from the SAM website:

· NP_Excel2013_T10_P1a_FirstLastName_1.xlsx

· Open the file you just downloaded and save it with the name:

· NP_Excel2013_T10_P1a_FirstLastName_2.xlsx

· Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically.

· With the file NP_Excel2013_T10_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website.

· This project requires the use of the Solver add-in. If this add-in is not available in the Analysis group (or if the Analysis group is not available) on the DATA tab, install Solver by following the steps below.

· In Excel, click the FILE tab, and then click the Options button in the left navigation bar.

· Click the Add-Ins option in the left pane of the Excel Options window.

· Click on the arrow next to the Manage box, click the Excel Add-Ins option, and then click the Go button.

· In the Add-Ins window, click the check box next to the Solver Add-In option and then click the OK button.

· Follow any remaining prompts to install Solver.

PROJECT STEPS
Go to the Desktop Models worksheet. In cell C28, use Goal Seek to perform a break-even analysis for Desktop Models by calculating the number of units the company needs to sell (represented by the value in cell C27), at the price per unit listed in cell C25, in order to break even, or reach a Gross Profit of $0. (Hint: The number format applied to cell C25 will make a value of $0 display as $ -)

Create a one-variable data table to display values for Sales, Expenses, and Profits based on the Number of Clocks sold by completing the following actions:

a. In cell E5, enter a formula to reference cell C5, which is the input cell to be used in the data table.

b. In cell F5, enter a formula that references cell C20, which is the expected total sales for this product.

c. In cell G5, enter a formula that references cell C21, which is the expected total expenses for this product.

d. In cell H5, enter a formula that references cell C22, which is the expected gross profit for this product.

e. Select the range E5:H10 and then complete the one-variable data table, using cell C5 as the Column input cell for your data table.

Select range E14:L19. Create a two-variable data table to display values for gross Profit based on Units Sold and Price per Unit (Hint: Use cell C6 as the Row input cell and cell C5 as the Column input cell).

Apply a custom format to cell E14 to display the text “Units Sold/Price” in place of the cell value.

Go to the Wall Units worksheet. Create a Scatter with Straight Lines chart based on range E4:G14 in the data table Wall-Units – Break-Even Analysis. Modify the chart as described below:

f. Resize and reposition the chart so the upper-left corner is in cell E15 and the lower-right corner is in cell H28.

g. Remove the chart title from the chart.

h. Add Sales and Expenses as the Vertical Axis title and Units Sold as the Horizontal Axis title.

i. For the Vertical Axis, change the Minimum Bounds to 300000 and the Maximum Bounds to 550000. Change the Number format of the Vertical Axis to Currency with 0 decimal places.

j. For the Horizontal Axis, change the Minimum Bounds to 5000 and the Maximum Bounds to 9000.

k. Use the Change Colors option to change the color set for the chart to Color 14 (the 4th entry from the bottom in the gallery of color choices).

Open the Scenario Manager and add two scenarios for the data in the Wall Units worksheet based on the data shown in Table 1. The changing cells for both scenarios are the non-adjacent cells C12, and C15. Close the Scenario Manager without showing any of the scenarios.

Table 1: Wall Unit Scenario Values

Values

Scenario 1

Scenario 2

Scenario Name

Standard Materials

Green Materials

Wall_Unit_Variable_Cost (C12)

33.75

42.50

Wall_Unit_Fixed_Cost (C15)

175000

225000

Copyright © 2014 Cengage Learning. All Rights Reserved.

Go to Custom Clocks worksheet. Create a Scatter with Straight Lines chart based on range E6:J14 in the data table Custom Clocks – Net Income Analysis. Make the following modifications to the chart:

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Essay Writing Help
Exam Attempter
Top Academic Guru
Financial Solutions Provider
Professor Smith
Top Quality Assignments
Writer Writer Name Offer Chat
Essay Writing Help

ONLINE

Essay Writing Help

I will cover all the points which you have mentioned in your project details.

$24 Chat With Writer
Exam Attempter

ONLINE

Exam Attempter

Give me a chance, i will do this with my best efforts

$47 Chat With Writer
Top Academic Guru

ONLINE

Top Academic Guru

I have read and understood all your initial requirements, and I am very professional in this task.

$33 Chat With Writer
Financial Solutions Provider

ONLINE

Financial Solutions Provider

You can award me any time as I am ready to start your project curiously. Waiting for your positive response. Thank you!

$16 Chat With Writer
Professor Smith

ONLINE

Professor Smith

I will cover all the points which you have mentioned in your project details.

$47 Chat With Writer
Top Quality Assignments

ONLINE

Top Quality Assignments

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$50 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Epass nt schools net - Class diagram for smart parking system - Days of working capital capsim - Current key trends in data warehousing - Pasco basic optics system - Lab report - Media and Public Opinion - 2 short essay questions - Danish shoe company based in bredebro denmark - Week 2 Assignment - N492 Discussion Mod 1: - Siemens gamma lighting control - Which of the following statements accurately describes the swot analysis? - Cloud computing assign - Caravan weight calculator spreadsheet - Order # 9207 - Figurative language and literary devices - Importance of good documentation - Katy perry pizza phnom penh - Long case closing statement - Module 1 Quiz - Ti-nspire calculus cheat sheet - Bending 11 gauge steel - A desolation called peace voices from kashmir - 400 kb to mb - What is the rf of a map - A common problem with talent management information systems is that - The alfred deakin centre mildura - Why does macbeth kill banquo - Stockport homes mutual exchange - Arlene g orejana biography - Monetary unit sampling excel template - My zombie myself why modern life feels rather undead - Wk 1 – Signature Assignment: Professional Goals Paper - Hr assignment 15 - A level business grade boundaries - The sociological imagination includes the ability to - Tonga toys manufactures and distributes a number - Economic factors affecting recruitment - Ted bundy height weight - Www rbs com ir - Comparison of the DNP and PhD Roles in Nursing - What is a post and lintel system of construction - Matthew 5 43 48 relevance to other worldviews - Juice plus virtual office - Unit 16 procedural programming assignment 2 - 9. read 1 corinthians 15:42-57 and list three characteristics of the glorified state. - Human body research project - Public Policy - International standard bible encyclopedia vol 7 pdf - Cost Estimation and Analysis Methods - Continuous function on a closed interval - International conference on harmonization guidelines for good clinical practice - Wuthering heights chapter 5 summary - Access chapter 3 northwind traders - Delta airlines case analysis - The traditionalistic subculture was brought to texas by - Lorne medical centre oban - Trane cvhe performance data - Thebarton community centre booking - Report t test apa - Dhcp excluded address cisco - First data non qualifying transactions - Mark carcasole gay - JOHANNESBURG SAFE ABORTION CLINIC +27835179056 PILLS IN JOHANNESBURG musina limpopo polokwane - Bond j has a coupon rate of 4 percent - Lump sum sales of stock with preferred stock - How does social class effect education? - Order 2275496: 13th Documentary Summary - Hyundai iload leaf springs - Nickel and dimed quotes and analysis - Name and explain two types of prewriting weegy - Database - Cuáles son tres formas de decir headset - First article inspection procedure - 5/9 tristania street rivett - Ebay inc 2009 case study - Higgins 5 factor model - Similarities and differences between freud's and jung's theories of personality - Cons of continuous training - Globalization challenges and opportunities a flattened world - Lesson 13.2 dot plots answers - Assignment-10 - The new trophy wife by deborah siegel summary - Cook door menu 2017 egypt - Chavez company most recently reconciled - Article review example mla - 150 word ,1 or 2 pages - Substitution property of congruence - The customer is always right 1993 - River north wine fest groupon - Paper on COSO framework - Suppose the quantity x of super titan - 2013 new belgium fat tire cruiser - NUR601- CASE STUDY 7 - Hollensen s 2017 global marketing - Dbms lab assignment with solutions - Av mym blackrock 50 50 global equity index tracker - 7 characteristics of life - Economics