Chapter 14: Applying Excel Data Example E Cost of equipment needed $60,000 Working capital needed $100,000 Overhaul of equipment in four years $5,000 Salvage value of the equipment in five years $10,000 Annual revenues and costs: Sales revenues $200,000 Cost of goods sold $125,000 Out-of-pocket operating costs $35,000 Discount rate 14% Enter a formula into each of the cells marked with a

What are the general categories of capital budget scenarios? describe the overall decision-making context for each.

Croy inc. has the following projected sales for the next five months: month sales in units april 3,850 may 3,875 june 4,260 july 4,135 august 3,590 croy’s finished goods inventory policy is to have 60 percent of the next month’s sales on hand at the end of each month. direct material costs $2.50 per pound, and each unit requires 2 pounds. raw materials inventory policy is to have 50 percent of the next month’s production needs on hand at the end of each month. raw materials on hand at march 31 totaled 3,741 pounds. 1. determine budgeted production for april, may, and june. 2. determine the budgeted cost of materials purchased for april, may, and june. (round your answers to 2 decimal places.)

Cherokee inc. is a merchandiser that provided the following information: amount number of units sold 20,000 selling price per unit $ 30 variable selling expense per unit $ 4 variable administrative expense per unit $ 2 total fixed selling expense $ 40,000 total fixed administrative expense $ 30,000 beginning merchandise inventory $ 24,000 ending merchandise inventory $ 44,000 merchandise purchases $ 180,000 required: 1. prepare a traditional income statement. 2. prepare a contribution format income statement.