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

Use goal seek to perform a break even analysis

16/11/2021 Client: muhammad11 Deadline: 2 Day

1. 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

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 av­ailable) on the DATA tab, install Solver by following the steps below.

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

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

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

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

o Follow any remaining prompts to install Solver.

PROJECT STEPS
1. 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 $ -)

2. 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.

3. 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).

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

5. 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:

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

b. Remove the chart title from the chart.

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

d. 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.

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

f. 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).

6. 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.

7. 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:

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

b. Remove the chart title from the chart.

c. Reposition the chart legend to the Right of the chart.

d. Add the title Net Income as the Vertical Axis title and Units Sold as the Horizontal Axis title.

e. For the Vertical Axis, change the Minimum Bounds to -150000 and the Maximum Bounds to 250000. Change the Number format of the Vertical Axis to Currency with 0 decimal places.

f. For the Horizontal Axis, change the Minimum Bounds to 3000 and the Maximum Bounds to 7500.

8. In the Scatter with Straight Lines chart created in the previous step, edit the chart series names as described below:

a. For Series 1, set the series name to cell F5 (Hint: The series name should automatically update to =’Custom Clocks’!$F$5).

b. For Series 2, set the series name to cell G5.

c. For Series 3, set the series name to cell H5.

d. For Series 4, set the series name to cell I5.

e. For Series 5, set the series name to cell J5.

9. Firestone Clocks is considering subcontracting the construction of their Custom Clock line to other woodshops in the area. Walter wants to determine if this option will reduce the costs associated with this product line.

Go to the Custom Clock – Suppliers worksheet. Run Solver to minimize the value in cell F11 (Total Cost) by adjusting number of units produced by each woodshop (Hint: Changing cells will be C5:E5) assuming the four (4) manufacturing constraints below:

a. F5=5500

b. F11 <=560000

c. C5:E5 <=3500

d. C5:E5 should be an Integer

Run Solver, keep the Solver Solution, and then return to the Solver Parameters Dialog box. Save the model to the range B15:B22. Close the Solver Parameters Dialog box.

10.Go to the All Products worksheet. Open the Scenario Manager and create a Scenario Summary report for the resultant cells C18:E18. The Scenario Summary report will summarize the impact of the following three scenarios: Status Quo, Outsource Manufacturing, Raise Prices 5%.

11.Go back to the All Products worksheet. Open the Scenario Manager and create a Scenario PivotTable report for result cells C18:E18. Format the Scenario PivotTable as described below:

a. Remove the Filter field from the PivotTable.

b. Change the number format of the Profit_per_Unit_Sold_Desktop, Profit_per_Unit_Sold_Wall_Units, and Profit_per_Unit_Sold_Custom fields (located in the Values box of the PivotTable Field List) to Currency (with 2 decimal places).

c. In cell A1, enter the value All Products Scenario PivotTable and format the cell with the Title cell style.

12.Go back to the All Products worksheet. Open the Scenario Manager and view the Outsource Manufacturing scenario in the worksheet.

Your workbook should look like the Final Figure on the following page. Note that some of the outcome values have been intentionally blanked out. Save your changes, close the workbook, and exit Excel. Follow the directions on the SAM website to submit your completed project.

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:

Accounting & Finance Master
Top Writing Guru
Exam Attempter
Supreme Essay Writer
Accounting Homework Help
Maths Master
Writer Writer Name Offer Chat
Accounting & Finance Master

ONLINE

Accounting & Finance Master

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$32 Chat With Writer
Top Writing Guru

ONLINE

Top Writing Guru

I can assist you in plagiarism free writing as I have already done several related projects of writing. I have a master qualification with 5 years’ experience in; Essay Writing, Case Study Writing, Report Writing.

$26 Chat With Writer
Exam Attempter

ONLINE

Exam Attempter

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$46 Chat With Writer
Supreme Essay Writer

ONLINE

Supreme Essay Writer

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$30 Chat With Writer
Accounting Homework Help

ONLINE

Accounting Homework Help

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$31 Chat With Writer
Maths Master

ONLINE

Maths Master

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$31 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

Purchase order approval process flowchart - Discussion forum on Article readings - Silver nitrate and copper experiment - Swot analysis lululemon athletica inc - Svedka how to pronounce - G - The autocomplete truth (campaign) - Different account titles under expenses - Legacy of racism reflection essay - Piaget and vygotsky venn diagram - As nzs 7000 2010 - 1652 kj to calories - The frost of death was on the pane analysis - Binomial theorem on ti 84 - Mentoring program design and reflection - Was andrew jackson a great president - Barwon heads primary school - City of joondalup security patrol - Calculate δg for the following reaction at 298 k - Darwin's finch beak lab answer key - Sean blanda the other side is not dumb - Do cold receptors adapt quickly - Go back n protocol simulation - Brisbane ranges national park victoria - Airline industry average financial ratios 2018 - Marketplace live simulation tips quarter 4 - Gold coast council number - The perfect picture james thom pdf - An independent measures t hypothesis test is appropriate when ____ - Money vs currency mike maloney - Depth of field refers to - Electrolysis of potassium iodide - Nuclear medicine technologist schools virginia - Partial key dependencies - Benefits of generalized audit software - Dr gerard testa miranda - Cisco finesse not ready reason codes - Pros and cons of the behaviourist approach - Discussion due 8/22 5pm - Global wine wars new world challenges old - What is rock n roll worksheet answers - How did greyhound bridge lancaster get its name - Leaky barrel model - How to create a project network diagram in excel - Tuesday - Do all federal court opinions have parallel cites - The goldfinch cda - Juvenile court proceedings were originally conceptualized as civil proceedings - Psych - Law university of salford - Assignment: Practicum: Cover Letter, Resume, and Portfolio (Due in Week 10) - Principles of Ethics 445N - Angle of impact blood spatter - Mcafee advanced threat defense - Www mentalhealth gov au - Why does othello start in the middle of a conversation - Education should be free for everyone argumentative essay - 3d systems corporation investor relations - Data Objects PPT - Statistics - Measurement of three phase power with the 2 wattmeter method - Density of a glass - Eating disorder plan medicare template - Ethical principles in nursing essay - Creating Graphic Organizers Using Microsoft Word (Links to an external site.) to demonstrate universal learning and behavior characteristics and strategies for a disability. - Tpg home phone and internet bundles - Isabella of castile timeline - Steel river marketing pyramid scheme - Compare and contrast servant leadership and followership - Sidereal day vs solar day - Clinical performance measures for nurse practitioners - Slippery slope fallacy examples commercials - Types of conflict worksheet - How to calculate edp - Which of the following best describes the delaney clause - The absorption spectrum of chlorophyll - Criminal justice - Theorem 10.9 class 9 - Dental abbreviations symbols and acronyms - Strength and weaknesses of perfume - Grim reaper skulls and pentagrams hourglass sand timer - Drexel university chemical engineering - Footpriting - Arcair k3000 parts breakdown - When was marketing first introduced to the healthcare field - George eliot hospital chronic fatigue - The default view that powerpoint opens in is called - Protons electrons and neutrons in neon - Self Esteem intended for brilliant answers only - Macquarie equities limited chess sponsor - Human body systems crossword puzzle answers - Vark analysis paper - Essentials of investments 10th edition pdf - Dulux electro dark bronze - How to calculate after tax yield on preferred stock - Whale watching cruise batemans bay - Expression of interest for phd - Gst collected credit or debit - Hhmi org biointeractive virus explorer - 13.1 tangent ratio answer key