Antonio Banderos & Scarves make headwear that is very popular in the fall-winter season. Units sold are anticipated as follows:

October

1,250

November

2,250

December

4,500

January

3,500

Total units

11,500

If seasonal production is used, it is assumed that inventory will directly match sales for each month and there will be no inventory build-up.

However, Antonio decides to go with level production to avoid being out of merchandise. He will produce the 11,500 items over four months at a level of 2,875 per month.

a. What is the ending inventory at the end of each month? Compare the units sales to the units produced and keep a running total.

b. If the inventory costs $8 per unit and will be financed at the bank at a cost of 12 percent, what is the monthly financing cost and the total for the four months? (Use 1 percent or the monthly rate.)

Short Answer

Expert verified

The ending inventory at the end of October is 1,625 units, November is 2,250 units, December is 625 units, and January is 0 units. The total cost of financing is $360.

Step by step solution

01

Calculation of ending inventory at the end of each month

Month

Units sold

Units produced

Change in inventory

Ending inventory

October

1,250

2,875

1,625

1,625

November

2,250

2,875

625

2,250

December

4,500

2,875

(1,625)

625

January

3,500

2,875

(625)

0

02

Expected sales for next year

Month

Ending inventory

Total cost per unit ($8 per unit)

Inventory financing cost (at 1% per month)

October

1,650

13,000

130

November

2,250

18,000

180

December

625

5,000

50

January

0

0

0

The total financing cost is $360.

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Barney’s Antique Shop has annual credit sales of \(1,620,000 and an accounts receivable balance of \)157,500. Calculate the average collection period (use 360 days in a year).

Esquire Products Inc. expects the following monthly sales:

January

\(28,000

February

\)19,000

March

\(12,000

April

\)14,000

May

\(8,000

June

\)6,000

July

\(22,000

August

\)26,000

September

\(29,000

October

\)34,000

November

\(42,000

December

\)24,000

Total annual sales

\(264,000

Cash sales are 40 percent in a given month, with the remainder going into accounts receivable. All receivables are collected in the month following the sale. Esquire sells all of its goods for \)2 each and produces them for \(1 each. Esquire uses level production, and average monthly production is equal to annual production divided by 12.

b. Determine a cash receipts schedule for January through December. Assume that dollar sales in the prior December were \)20,000. Work part b using dollars.

Route Canal Shipping Company has the following schedule for aging of accounts receivable:

d. Disregarding your answer to part c and considering the aging schedule for accounts receivable, should the company be satisfied?

Orbital Communications has operating plants in over 100 countries. It also keeps funds for transactions purposes in many foreign countries. Assume in 2010 it held 150,000 kronas in Norway worth \(40,000. The funds drew 13 percent interest, and the krona increased 6 percent against the dollar. What is the value of the holdings, based on U.S. dollars, at year-end?

(Hint: Multiply \)40,000 times 1.13 and then multiply the resulting value by 106 percent.)

In Problem 12, assume the term structure of interest rates becomes inverted, with short-term rates going to 11 percent and long-term rates 5 percentage points lower than short-term rates. If all other factors in the problem remain unchanged, what will earnings after taxes be?

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free