Modify the accompanying credit risk data using if functions to include new columns, classifying the checking and savings account balances as low if the balance is less than $250, medium if at least $250 but less than $2000, and high otherwise.

Suppose that a firm is considering moving from a batch process to an assembly-line process to better meet evolving market needs. what concerns might the following functions have about this proposed process change: marketing, finance, human resources, accounting, and information systems?

Fanning company is considering the addition of a new product to its cosmetics line. the company has three distinctly different options: a skin cream, a bath oil, or a hair coloring gel. relevant information and budgeted annual income statements for each of the products follow. skin cream bath oil color gel budgeted sales in units (a) 110,000 190,000 70,000 expected sales price (b) $8 $4 $11 variable costs per unit (c) $2 $2 $7 income statements sales revenue (a × b) $880,000 $760,000 $770,000 variable costs (a × c) (220,000) (380,000) (490,000) contribution margin 660,000 380,000 280,000 fixed costs (432,000) (240,000) (76,000) net income $228,000 $140,000 $204,000 required: (a) determine the margin of safety as a percentage for each product. (b) prepare revised income statements for each product, assuming a 20 percent increase in the budgeted sales volume. (c) for each product, determine the percentage change in net income that results from the 20 percent increase in sales. (d) assuming that management is pessimistic and risk averse, which product should the company add to its cosmetics line? (e) assuming that management is optimistic and risk aggressive, which product should the company add to its cosmetics line?

Over the past decade, brands that were once available only to the wealthy have created more affordable product extensions, giving a far broader range of consumers a taste of the good life. jaguar, for instance, launched its x-type sedan, which starts at $30,000 and is meant for the "almost rich" consumer who aspires to live in luxury. by marketing to people who desire a luxurious lifestyle, jaguar is using: