Using the data in the student spreadsheet file ethan allen financials. xlsx (to find the student spreadsheets for financial analysis with microsoft excel, eighth edition, go to ) forecast the june 30, 2017 income statement and balance sheet for ethan allen. use the percent of sales method and the following assumptions: (1) sales in fy 2017 will be $797.3359; (2) the tax rate will be 35%; (3) each item that changes with sales will be the five-year average percentage of sales; (4) net fixed assets will increase to $300; and (5) the common dividend will be $0.75 per share.

M. cotteleer electronics supplies microcomputer circuitry to a company that incorporates microprocessors into refrigerators and other home appliances. one of the components has an annual demand of 235 units, and this is constant throughout the year. carrying cost is estimated to be $1.25 per unit per year, and the ordering (setup) cost is $21 per order. a) to minimize cost, how many units should be ordered each time an order is placed? b) how many orders per year are needed with the optimal policy? c) what is the average inventory if costs are minimized? d) suppose that the ordering cost is not $21, and cotteleer has been ordering 125 units each time an order is placed. for this order policy (of q = 125) to be optimal, determine what the ordering cost would have to be.

In the 1970s, kmart used blue light specials to encourage customers to flock to a particular department having a temporary sale. a spinning blue light activated for approximately 30 seconds, and then an in-store announcement informed shoppers of the special savings in the specific department. over time, loyal kmart shoppers learned to flock to the department with the spinning blue light before any announcement of special savings occurred. if kmart was employing classical conditioning techniques, what role did the spinning blue light play?

You are the manager of a large crude-oil refinery. as part of the refining process, a certain heat exchanger (operated at high temperatures and with abrasive material flowing through it) must be replaced every year. the replacement and downtime cost in the first year is $165 comma 000. this cost is expected to increase due to inflation at a rate of 7% per year for six years (i.e. until the eoy 7), at which time this particular heat exchanger will no longer be needed. if the company's cost of capital is 15% per year, how much could you afford to spend for a higher quality heat exchanger so that these annual replacement and downtime costs could be eliminated?