As an intern in the financial department of scandia kayaks, you assist jay chen, a financial analyst. jay has asked you to work with the company's current revenue and sales data in excel to develop scenarios and what-if analyses that identify ways to increase profits.
switch to the revenue and expenses worksheet. jay wants to know how profits would change if the company sold 5 percent fewer kayaks of each model. make a scenario to provide this information for jay as follows:
a. in the scenario manager, add a new scenario and use unit sales decrease 5% as the scenario name.
b. change the values in the range f12: h12. (hint: two scenarios are already defined for the revenue and expenses worksheet.)
c. use the information shown in table 1 below as the values for the changing cells.
table 1: unit sales decrease 5% scenario values
changing cell
value
dae_units_sold (f12)
20900
swede_units_sold (g12)
20283
finn_units_sold (h12)
19665
d. show the results of the unit sales decrease 5% scenario.

Vulcan company is a monthly depositor whose tax liability for march 2019 is $2,510. 1. what is the due date for the deposit of these taxes? march 17 2. assume that no deposit was made until april 29. compute the following penalties. assume a 365-day year in your computations. round your answers to the nearest cent. a. penalty for failure to make timely deposits. $ b. penalty for failure to fully pay employment taxes $ c. interest on late payment (assume a 5% interest rate). $ d. total penalty imposed $

Pettijohn inc. the balance sheet and income statement shown below are for pettijohn inc. note that the firm has no amortization charges, it does not lease any assets, none of its debt must be retired during the next 5 years, and the notes payable will be rolled over. balance sheet (millions of $) assets 2016 cash and securities $ 1,554.0 accounts receivable 9,660.0 inventories 13,440.0 total current assets $24,654.0 net plant and equipment 17,346.0 total assets $42,000.0 liabilities and equity accounts payable $ 7,980.0 notes payable 5,880.0 accruals 4,620.0 total current liabilities $18,480.0 long-term bonds 10,920.0 total debt $29,400.0 common stock 3,360.0 retained earnings 9,240.0 total common equity $12,600.0 total liabilities and equity $42,000.0 income statement (millions of $) 2016 net sales $58,800.0 operating costs except depr'n $54,978.0 depreciation $ 1,029.0 earnings bef int and taxes (ebit) $ 2,793.0 less interest 1,050.0 earnings before taxes (ebt) $ 1,743.0 taxes $ 610.1 net income $ 1,133.0 other data: shares outstanding (millions) 175.00 common dividends $ 509.83 int rate on notes payable 1. what is the firm's current ratio? (points : 6) 0.97 1.08 1.20 1.33 2. what is the firm's quick ratio? (points : 6) 0.49 0.61 0.73 0.87 3. what is the firm's total assets turnover? (points : 6) 0.90 1.12 1.40 1.68 4. what is the firm's inventory turnover ratio? (points : 6) 4.38 4.59 4.82 5.06 5. what is the firm's debt ratio? (points : 6) 45.93% 51.03% 56.70% 70.00% 6. what is the firm's roa? (points : 6) 2.70% 2.97% 3.26% 3.59% 7. what is the firm's roe? (points : 6) 8.54% 8.99% 9.44% 9.91%

cranium, inc., purchases term papers from an overseas supplier under a continuous review system. the average demand for a popular mode is 300 units a day with a standard deviation of 30 units a day. it costs $60 to process each order and there is a five−day lead−time. the holding cost for a paper is $0.25 per year and the company policy is to maintain a 98% service level. cranium operates 200 days per year. what is the reorder point r to satisfy a 98% cycleminus−service level? a. greater than 1,700 unitsb. greater than 1,600 units but less than or equal to 1,700 unitsc. greater than 1,500 units but less than or equal to 1,600 unitsd. less than or equal to 1,500 units