using excel

1. A toy store has beginning inventory of 15 sets of paints at a cost of $1.05 each. During the year the toy store purchased 2 at $1.40; 4 at $2.00; 6 at $3.00; and 20 at $4.00. By the end of the year, 25 sets were sold. Calculate (a) the number of paint sets in stock and (b) the cost of ending inventory under LIFO, FIFO, and weighted average.

2. The Morris Co. allocates its overhead expenses to all departments on the basis of floor space (square feet) occupied by each department. The total overhead expenses for a recent year amounted to $120,000. Department A occupied 19,820 square feet; department B, 16,180; and department C, 6,000. What is the amount of the overhead allocated to department C? (Round percent to nearest hundredth in your calculation.)

3. Jansen Co. has a beginning inventory at a cost of $77,800 and an ending inventory costing $99,250. Sales were $310,000. Assume Jansens markup rate on selling price is 40 percent. Based on the selling price, what is the inventory turnover at cost? Round to nearest hundredth.