Hayworth Corporation has Just segmented last year's income statement into its ten product lines. The chief executive officer (CEO) is curlous as towhat effect dropping one of the product lines at the beginning of last year would have had on overall company profit. What is the best number for theCEO to look at to determine the effect of this elimination on the net operating income of the company as a whole?Multiple Choicethe product line's sales dollarsthe product line's contribution marginthe product line's segment marginthe product line's segment mergin minus an allocated portion of common fixed expenses

Introduction: Contribution margin: Formula: Contribution margin = Selling price per unit -…

Answered: Hayworth Corporation has Just segmented…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 40P

See similar textbooks

Similar questions

When you use a RISKSIMTABLE function for a decision variable, such as the order quantity in the Walton model, explain how this provides a fair comparison across the different values tested.
Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?
A company manufacturers a product in the United States and sells it in England. The unit cost of manufacturing is 50. The current exchange rate (dollars per pound) is 1.221. The demand function, which indicates how many units the company can sell in England as a function of price (in pounds) is of the power type, with constant 27556759 and exponent 2.4. a. Develop a model for the companys profit (in dollars) as a function of the price it charges (in pounds). Then use a data table to find the profit-maximizing price to the nearest pound. b. If the exchange rate varies from its current value, does the profit-maximizing price increase or decrease? Does the maximum profit increase or decrease?
An automobile manufacturer is considering whether to introduce a new model called the Racer. The profitability of the Racer depends on the following factors: The fixed cost of developing the Racer is triangularly distributed with parameters 3, 4, and 5, all in billions. Year 1 sales are normally distributed with mean 200,000 and standard deviation 50,000. Year 2 sales are normally distributed with mean equal to actual year 1 sales and standard deviation 50,000. Year 3 sales are normally distributed with mean equal to actual year 2 sales and standard deviation 50,000. The selling price in year 1 is 25,000. The year 2 selling price will be 1.05[year 1 price + 50 (% diff1)] where % diff1 is the number of percentage points by which actual year 1 sales differ from expected year 1 sales. The 1.05 factor accounts for inflation. For example, if the year 1 sales figure is 180,000, which is 10 percentage points below the expected year 1 sales, then the year 2 price will be 1.05[25,000 + 50( 10)] = 25,725. Similarly, the year 3 price will be 1.05[year 2 price + 50(% diff2)] where % diff2 is the percentage by which actual year 2 sales differ from expected year 2 sales. The variable cost in year 1 is triangularly distributed with parameters 10,000, 12,000, and 15,000, and it is assumed to increase by 5% each year. Your goal is to estimate the NPV of the new car during its first three years. Assume that the company is able to produce exactly as many cars as it can sell. Also, assume that cash flows are discounted at 10%. Simulate 1000 trials to estimate the mean and standard deviation of the NPV for the first three years of sales. Also, determine an interval such that you are 95% certain that the NPV of the Racer during its first three years of operation will be within this interval.
AutoTime, a manufacturer of electronic digital timers, has a monthly fixed cost of $50,000 and a production cost of $7 for each timer manufactured. The timers sell for $15 each. (a) What is the cost function C(x)?C(x) = (b) What is the revenue function R(x)?R(x) = (c) What is the profit function P(x)?P(x) = (d) Compute the profit (loss) corresponding to production levels of 3000, 6000, and 11,000 timers, respectively. (Input a negative value to indicate a loss.) 3000 timers $ 6000 timers $ 11,000 timers $
XYZ Corporation manufactures two products, Simple and Complex. The following annual information was gathered: Simple Complex Selling price per unit P47.00 P26.00 Variable cost per unit 42.00 22.00 Total annual fixed costs are P18,000. Assume XYZ Corporation can produce and sell any mix of Simple or Complex at full capacity. It takes 1.5 hours to make one unit of Complex. However, Simple takes 50% longer to manufacture when compared to Complex. Only 120,000 hours of plant capacity are available. How many units of Simple and Complex should XYZ Corporation produce and sell in a year to maximize profits?
You have an idea for a new web service that offers customized workouts for subscribers. Build a spreadsheet to calculate 1) the number of new customers each month and 2) the total customer base (cumulative number of customers signed up) each month. Mimic what we did in the class to project the subscription volumes for 60 months under the following sets of assumptions. a)Total market potential is 1,000,000 customers. Each month, you sign up 2% of customers in the market that have not yet signed up. b)Total market potential is initially 1,000,000 customers, but grows at 1% per month. Each month, you sign up 2% of customers in the market that have not yet signed up. Use the graph wizard to make a graph comparing total customer base under each of the two scenarios. Which type of graph is appropriate?
McDonald wants to increase its total revenue. One strategy is to offer a 10% discount on every customer that they sell. MacDonald knows that their customers can be divided into two distinct groups according to their likely responses to the discount. The table shows how the two groups respond to the discount. Discount Group A: family (sales per week) Group B: school children (sales per week) Volume of sales before the 10% discount 1.55 million 1.50 million Volume of sales after the 10% discount 1.65 million 1.70 million If McDonald wants to increase its total revenue, should discounts be offered to group A or to group B? Explain
You are the owner of Caché, a chain of women's clothing boutiques. Your state has a sales tax of 7%, and your city has an additional sales tax of 1.5%. Each quarter you are responsible for making these tax deposits to the city and state. Last quarter your stores had total revenue, including sales tax, of $488,250. a) How much of this revenue was sales (in $) and how much was sales tax (in $)? sales sales tax b) How much sales tax (in $) should be sent to the city? c)How much sales tax (in $) should be sent to the state?
Chris LeBlanc estimates that if he does five hours of research using datathat will cost $175, there is a good chance that he can improve hisexpected return on a $10,000, one-year investment from 6% to 9%. Chrisfeels that he must earn at least $30 per hour on the time he devotes to hisresearch.a. Find the cost of Chris’s research.b. By how much (in dollars) will Chris’s return increase as a result ofthe research?c. On a strict economic basis, should Chris perform the proposed reserach?
The general manager of XXX Factoring is about to decide whether to enterinto the small and medium enterprise (SME) market. XX Company's customers so far have been mostly big-size companies. The decision to provide factoring to SMEs would mean entering into a new market. Turkey's economy increasingly rely on SMEs, and XX Company doesn't want to jeopardize Company’s position in the market. However, the company also wants to grow fast. Conduct an industry analysis using Porter’s 5 Forces.
One of your staff members developed the following excel optimal production plan. You must now review this optimal plan and write a memo to the VP of Operations (Mr. Monroe) with recommendations as to how this optimal production plan can be improved to increase the Total Profit. What are three recommendations you have to the VP of operations based on the attached optimal production plan? These three options must be based only on information present in the excel production plan and components of LP modeling [decision variables, objective function (prices and variable cost), and resource constraints].

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS