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?

"in my opinion, we ought to stop making our own drums and accept that outside supplier's offer," said wim niewindt, managing director of antilles refining, n.v., of aruba. "at a price of $21 per drum, we would be paying $4.70 less than it costs us to manufacture the drums in our own plant. since we use 70,000 drums a year, that would be an annual cost savings of $329,000." antilles refining's current cost to manufacture one drum is given below (based on 70,000 drums per year):

Which of the following is an example of an unsought good? a. cameron purchases a new bike. b. jordan buys paper towels. c. taylor buys cupcakes from her favorite bakery. d. riley buys new windshield wipers for her car.

Shelby company produces three products: product x, product y, and product z. data concerning the three products follow (per unit): product x product y product z selling price $ 85 $ 65 $ 75 variable expenses: direct materials 25.50 19.50 5.25 labor and overhead 25.50 29.25 47.25 total variable expenses 51.00 48.75 52.50 contribution margin $ 34.00 $ 16.25 $ 22.50 contribution margin ratio 40 % 25 % 30 % demand for the company’s products is very strong, with far more orders each month than the company can produce with the available raw materials. the same material is used in each product. the material costs $8 per pound, with a maximum of 4,400 pounds available each month. required: a. compute contribution margin per pound of materials used. (round your intermediate calculations and final answers to 2 decimal places.) contribution margin per pound product x $ product y $ product z $ b. which orders would you advise the company to accept first, those for product x, for product y, or for product z? which orders second? third? product x product y product z