Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The tieps you will follow for thin project are as folow: 1) Downiload the Excel chatu fle 2 Click on the Video button on the

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
The tieps you will follow for thin project are as folow: 1) Downiload the Excel chatu fle 2 Click on the Video button on the bothom left or within the Get More Help mena for this cuestion how. This futorial video wiil wak you through this exercise, step-by-kitep. 3) Perorm the fegurements on the dats fie. 4) Check your wod in the Excel fle with these theck foures 5) Uee your Fixcel fle to antwer the alix mullple cheice quesbions below. (You will have to scrol down to see all of the questiont.) Resoures A) Iriamation on how to yodate Ercel and Office 365 c) froubleshootng FAC Requirements 1) Downioed the Fxe 2) Click on the Video 3) Perform the requi The controller for the Zilinger Corporation wants to use the What-if Analysis tool in 4) Check your worki Excel to analyze the sales price, volume, and profit related to the graphics card it 5) Use your Excel file manufactures. The sales price of the graphics card is $90.00, the variable cost is $72.50, and monthly fixed expenses are $10,500. The company is currently selling Resources 900 of the graphic cards per month. The company has a requirement that each A) Information on ho product generate monthly operating income (profit) of $15,500 or more. B) If you do not have Requirements for the Excel analysis C) Troubleshooting.:. 1. Assume that the sales price is $90.00 per unit, variable costs are $72.50. monthly fixed expenses are $10,500, with a volume of 900 units. Use formulas to calculate the contribution margin per unit, total contribution margin, and operating income. Also add $1 less than the target profit to a cell below the profit calculation. Create a data table in Excel using the What -if Analysis tool. Use volumes of 1,200 This project only has units down to 600 units in 50 -unit increments and sales prices of $90.00 up to $125.00 in $5 increments. Use conditional formatting to shade the cells in the data table that meet or exceed the compary's target profit. Using this data table, answer the folowing questions: a. How many graphics cards does the company noed to sell in a month to break even if the selling price rembins at $90.00 ? A. 700 b. Can the company reach its target profit goal? If so, approximately how many graphics cards does the company need to sell to reach is monthly target profit B. 1,200 it the seling price remains at $0.00 per graphics card? C. 650 c. Approximately how many graphics cards does the company need to sell to reach its monthly target proft if it increases the selling price to $105.00 per D. 600 graphics card? Using the Exoel file you Tpany need to self to reach its mo Requirements break even if the selling price remains at $90.00 ? b. Can the company reach its target profit goal? If so, approximately how many graphics cards does the company need to sell to reach its monthly target profit if the selling price remains at $90.00 per graphics card? c. Approximately how many graphics cards does the company need to sell to reach its monthly target profit if it increases the selling price to $105.00 per graphics card? d. What would the company's monthly profit be if it increases the selling price to $115.00 and sells 900 graphics cards? 2. Now assume that the variable cost has decreased to $60.00 and the monthly fixed expenses have increased to $18,000. All other data remains the same. Create a new profit calculation in Excel (as you did in Requirement 1) with the new variable cost and the new monthly fixed expenses. Using this new data table, answer the following questions: a. How many graphics cards does the company need to sell in a month to break even if the selling price remains at $90.00 ? b. Can the company reach its target profit gcal? If so, approximately how many graphics cards does the company need to sell to reach its monthly target profit if the selling price remains at $90.00 per graphics card? c. Approximately how many graphics cards does the company need to sell to reach its monthly target profit if it increases the selling price to $105.00 per graphics card? d. What would the company's monthly profit be if it increases the selling price D. 600 to $115.00 and sells 900 graphics cards? apany need to This project anly has one mttempt. Review the check figures with your data file results belore annwering the h,iestions. If your check figures do not mateh, do not proceed with answering the auesionit uril you have askad for assiatance trom your instuctor Uving the Excel fo you created for Zalinger and loolding at requirement 1, how many gophict cards does the compary need to sell in a monten to break even if the selling price in $90.00 per unt. varible costs are $72.50, monely focd expenset are 516,900 , with a volume of 900 units? 1. 700 B. 1,200 c. 660 D. 600 setling price to 510500 per graphics card, verable ooth are 572.50 , and monthy flued eqpences are 510,500 ? A. 790=800 1. 190500 c. Cannet b. 390=990 6. 60 c. 1300 5. 70 a. 1.110+1.366 6. 10016 h. 51476 B. 114.1300 c. 127006 0. sist Tke The tieps you will follow for thin project are as folow: 1) Downiload the Excel chatu fle 2 Click on the Video button on the bothom left or within the Get More Help mena for this cuestion how. This futorial video wiil wak you through this exercise, step-by-kitep. 3) Perorm the fegurements on the dats fie. 4) Check your wod in the Excel fle with these theck foures 5) Uee your Fixcel fle to antwer the alix mullple cheice quesbions below. (You will have to scrol down to see all of the questiont.) Resoures A) Iriamation on how to yodate Ercel and Office 365 c) froubleshootng FAC Requirements 1) Downioed the Fxe 2) Click on the Video 3) Perform the requi The controller for the Zilinger Corporation wants to use the What-if Analysis tool in 4) Check your worki Excel to analyze the sales price, volume, and profit related to the graphics card it 5) Use your Excel file manufactures. The sales price of the graphics card is $90.00, the variable cost is $72.50, and monthly fixed expenses are $10,500. The company is currently selling Resources 900 of the graphic cards per month. The company has a requirement that each A) Information on ho product generate monthly operating income (profit) of $15,500 or more. B) If you do not have Requirements for the Excel analysis C) Troubleshooting.:. 1. Assume that the sales price is $90.00 per unit, variable costs are $72.50. monthly fixed expenses are $10,500, with a volume of 900 units. Use formulas to calculate the contribution margin per unit, total contribution margin, and operating income. Also add $1 less than the target profit to a cell below the profit calculation. Create a data table in Excel using the What -if Analysis tool. Use volumes of 1,200 This project only has units down to 600 units in 50 -unit increments and sales prices of $90.00 up to $125.00 in $5 increments. Use conditional formatting to shade the cells in the data table that meet or exceed the compary's target profit. Using this data table, answer the folowing questions: a. How many graphics cards does the company noed to sell in a month to break even if the selling price rembins at $90.00 ? A. 700 b. Can the company reach its target profit goal? If so, approximately how many graphics cards does the company need to sell to reach is monthly target profit B. 1,200 it the seling price remains at $0.00 per graphics card? C. 650 c. Approximately how many graphics cards does the company need to sell to reach its monthly target proft if it increases the selling price to $105.00 per D. 600 graphics card? Using the Exoel file you Tpany need to self to reach its mo Requirements break even if the selling price remains at $90.00 ? b. Can the company reach its target profit goal? If so, approximately how many graphics cards does the company need to sell to reach its monthly target profit if the selling price remains at $90.00 per graphics card? c. Approximately how many graphics cards does the company need to sell to reach its monthly target profit if it increases the selling price to $105.00 per graphics card? d. What would the company's monthly profit be if it increases the selling price to $115.00 and sells 900 graphics cards? 2. Now assume that the variable cost has decreased to $60.00 and the monthly fixed expenses have increased to $18,000. All other data remains the same. Create a new profit calculation in Excel (as you did in Requirement 1) with the new variable cost and the new monthly fixed expenses. Using this new data table, answer the following questions: a. How many graphics cards does the company need to sell in a month to break even if the selling price remains at $90.00 ? b. Can the company reach its target profit gcal? If so, approximately how many graphics cards does the company need to sell to reach its monthly target profit if the selling price remains at $90.00 per graphics card? c. Approximately how many graphics cards does the company need to sell to reach its monthly target profit if it increases the selling price to $105.00 per graphics card? d. What would the company's monthly profit be if it increases the selling price D. 600 to $115.00 and sells 900 graphics cards? apany need to This project anly has one mttempt. Review the check figures with your data file results belore annwering the h,iestions. If your check figures do not mateh, do not proceed with answering the auesionit uril you have askad for assiatance trom your instuctor Uving the Excel fo you created for Zalinger and loolding at requirement 1, how many gophict cards does the compary need to sell in a monten to break even if the selling price in $90.00 per unt. varible costs are $72.50, monely focd expenset are 516,900 , with a volume of 900 units? 1. 700 B. 1,200 c. 660 D. 600 setling price to 510500 per graphics card, verable ooth are 572.50 , and monthy flued eqpences are 510,500 ? A. 790=800 1. 190500 c. Cannet b. 390=990 6. 60 c. 1300 5. 70 a. 1.110+1.366 6. 10016 h. 51476 B. 114.1300 c. 127006 0. sist Tke

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting And Auditing Theory And Practice

Authors: Prof. R.B. Patel

1st Edition

8188730882, 978-8188730889

More Books

Students also viewed these Accounting questions

Question

Learn how HR can foster effective change. (p. 249)

Answered: 1 week ago