subject
Business, 12.02.2020 05:38 juniorgutierrez997

Using the Goal Seek function in Microsoft Excel, prepare an Excel spreadsheet to answer the following questions: Warner Clothing is considering the introduction of a new baseball cap for sales by local vendors. The company has collected the following price and cost characteristics:

Sales Price$15 per unit
Variable cost 3 per unit
Fixed cost 42,000 per month

Required
a. What number must Warner sell per month to break even?
b. What number must Warner sell per month to make an operating profit of $30,000?

ansver
Answers: 2

Other questions on the subject: Business

image
Business, 21.06.2019 12:30, erickasmith1988
After copy is written, a menu designer focuses on the of menu items. prices descriptions placement sequence
Answers: 1
image
Business, 22.06.2019 11:00, hgfgu829
When partners own different portions of the business, the terms should be stated clearly in what document? the articles of incorporation the executive summary the business summary the partnership agreement
Answers: 3
image
Business, 22.06.2019 21:40, summerhumphries3
Engberg company installs lawn sod in home yards. the company’s most recent monthly contribution format income statement follows: amount percent of sales sales $ 80,000 100% variable expenses 32,000 40% contribution margin 48,000 60% fixed expenses 38,000 net operating income $ 10,000 required: 1. compute the company’s degree of operating leverage. (round your answer to 1 decimal place.) 2. using the degree of operating leverage, estimate the impact on net operating income of a 5% increase in sales. (do not round intermediate calculations.) 3. construct a new contribution format income statement for the company assuming a 5% increase in sales.
Answers: 3
image
Business, 23.06.2019 00:00, areanna02
An attorney came to work on a saturday. when he signed in, he was advised by the morning security guard employed by the building management that he must be out of the building by 5 p. m., when it closes. however, he stayed past 5 p. m. to complete a brief that had to be filed on monday morning. at 5: 15 p. m., the afternoon security guard set the locks on all the doors of the building and left. because she was in a hurry, she did not check the sign-in sheet to make sure that everyone had signed out, contrary to mandatory procedures. when the attorney tried to exit 15 minutes later, he discovered that the doors were all locked and could not be opened from the inside. he used his cell phone to call for , and a supervisor from the building arrived and let him out shortly thereafter. if the attorney sues the building management for false imprisonment, is he likely to win?
Answers: 1
You know the right answer?
Using the Goal Seek function in Microsoft Excel, prepare an Excel spreadsheet to answer the followin...

Questions in other subjects:

Konu
English, 23.10.2020 18:40