Question

In: Accounting

McFadden's department store has been a profitable family-owned retail business (consisting of several stores in the...

McFadden's department store has been a profitable family-owned retail business (consisting of several stores in the Pacific Coast region) since its beginning in 1910. The last five years have been rough due to the economy, and McFadden's has been losing ground to national department and discount stores moving into the area.

The executive team is hopeful that a turnaround is finally occurring. Last year's sales volume for the entire retail store chain was $50 million. The National Retail Federation (NRF) predicts an increase in retail sales due to positive economic projections being felt throughout the country (e.g., unemployment has been dropping, the stock market is up, so investors have more money in their pockets, working hours have been steadily increasing, and there is an expectation of pent-up consumer demand after a number of years of lower sales and belt-tightening in households). Overall, retailers are expecting one of the best holiday seasons in a long time!

The NRF estimates a 5.5% increase in sales during the July to December 2019 season for the Pacific Coast, where McFadden's operates. Upper management believes that this increase in sales will be felt throughout all of its departments.

You are the buyer for Department 121, which sells young men's clothing. This department has been one of the more profitable departments for the company. Last year (2018), sales from Department 121 for the July-December season reached $750,000. Your sales forecast for this year (2019) must take into consideration the NRF's prediction for an increase in sales this period, and be based on an initial markup percentage of 52%.

Reductions for this period in 2018 totaled $105,000. Management expects the dollar amount of reductions to increase this season by 2% in an attempt to spur additional sales. The following reduction percentages are planned for November and December:

November: 21%

December: 35%

Relying on information from the last three years, you forecast that 28% of seasonal sales will occur in November and 38% in December:

November:28%

December: 38%

You have the following additional information on the historical stock-to-sales ratio for this type of department:

July: 3.0

August: 1.9

September: 2.1

October: 2.2

November: 3.0

December: 3.2

Today is November 11, 2019. Your inventory database has record of an additional merchandise order valued at $300,000 that has yet to be delivered. It's on a container ship arriving at one of the Pacific ports in five days. Also, the distribution center just notified you via the in-house inventory alert system that another large shipment has just arrived on the loading docks for Department 121. This shipment contains merchandise valued at $190,000 and has yet to be scanned into the computer system.

Finally, your reports show that your desired beginning-of-the-month stock (BOM) for December is $962,160.

Given the NRF's retail trend forecast for 2019, you need to project planned seasonal sales (July-December) for Department 121 for 2019.
Calculate Department 121's projected monthly sales for November.
Calculate Department 121's existing inventory or BOM inventory for November.
Calculate Department 121's desired ending inventory or EOM inventory for November.

Expert Solution

Answer:

1. CALCULATION OF DEPARTMENT 121'S DESIRED EOM INVENTORY FOR NOVEMBER

Given: Department 121 Desired BOM Inventory for Dec.month is = $ 962 160.

Hence, Department 121 Desired EOM Inventory for Nov month is = $ 962 160 (Next month's Opening balance is Current month's Closing balance).

2. CALCULATION OF DEPARTMENT 121'S PROJECTED MONTHLY SALES FOR NOVEMBER

GIVEN: Historical stock-to-sales ratio for Nov. = 3

Stock to Sales Ratio = Monthly Stock / Monthly Sales = 962160/ Monthly Sales = 3.

Therefore, Projected Monthly Sales for November = 962160/3 = $ 320 720.

3. CALCULATION OF DEPARTMENT 121'S EXISTING INVENTORY OR BOM INVENTORY FOR NOV.

BOM Inventory for Nov. = EOM Inventory + Sales - Purchases

= $ 962 160 + $ 320 720 - ($ 300 000 + $ 190 000)

= $ 1 282 880 - $ 490 000

= $ 1 772 880

4.CALCULATION OF DEPARTMENT 121'S PLANNED SEASONAL SALES (JULY - DEC.2019)

= 750 000 X 5% OF 750 000 = $ 791 250

ekkarill92 answered 2 years ago

Acme Manufacturing, Inc. was originally a family owned operation that has been in business for several...

Acme Manufacturing, Inc. was originally a family owned operation that has been in business for several generations. It has grown steadily and is now listed on the stock exchange with family members still owning a substantial portion of the shares. Over the years, the company has acquired a reputation for exceptional quality and has won awards from major customers. The firm is 75% equity financed; shares currently trade at $37 and do not pay a dividend. Debt capital is provided...

Ross Company has been in business for several years, during which time it has been profitable....

Ross Company has been in business for several years, during which time it has been profitable. For each of those years, Ross reported (and paid taxes on) taxable income in the same amount as pretax financial income based on the following revenues and expenses: Revenues Expenses 2012 $182,000 $150,000 2013 220,000 170,000 2014 253,000 180,000 2015 241,000 196,000 Ross was subject to the following income tax rates during this period: 2012, 20%; 2013, 25%; 2014, 30%; and 2015, 25%. During...

Gonzales Food Stores, a family-owned grocery store chain headquartered in El Paso, has hired you to...

Gonzales Food Stores, a family-owned grocery store chain headquartered in El Paso, has hired you to make recommendations concerning financing needs for the following two situations. Part I: Initial Expansion Gonzales is a closely held corporation considering a major expansion. The proposed expansion would require the firm to raise $10 million in additional capital. Because Gonzales currently has 50 percent debt and because the family members already have all their funds tied up in the business, the owners cannot supply...

ABC Limited is a family owned business that has been in operation for the past ten...

ABC Limited is a family owned business that has been in operation for the past ten years. The company based in Kabwe manufactures one product: desks. ABC limited Managing Director, Mr. Aubrey Bwalwa Chuungu has been away on a business trip to China for the past three months. He is worried that the current outbreak of the Corona virus and the subsequent restrictions imposed on commerce by the Zambian government may have had adverse financial consequences for the company. You...

True Fit operates a chain of 10 retail department stores. Each department store makes its own...

True Fit operates a chain of 10 retail department stores. Each department store makes its own purchasing decisions. Haulton ,assistant to the president of True Fit ,is interested in better understanding the drivers of purchasing department costs. For many years,True Fithas allocated purchasing department costs to products on the basis of the dollar value of merchandise purchased. A $100 item is allocated 10 times as many overhead costs associated with the purchasing department as a $10 item. Haulton recently attended...

Modern Limited. The Company Modern Limited is a family-owned and managed, department store situated in Breezyfield,...

Modern Limited. The Company Modern Limited is a family-owned and managed, department store situated in Breezyfield, a city in the North of England. The store was established some sixty years ago by the current owner’s father, who passed on the business to his three sons on his death. All three sons are still deeply involved in the running of the business, even though they are now in their sixties, and none of them have children to whom to pass on...

SOA Case Study: Retail company, shopOnline, with an online web store and 900 retail stores, has...

SOA Case Study: Retail company, shopOnline, with an online web store and 900 retail stores, has the following characteristics: • Strategic objective: become the most profitable retailer in the industry through aggressive growth with minimal risk • Delivering a unique, seamless, cross channel experience. • Being the first to offer popular products that match customer desires. • Capabilities needed according to Business Process Analysis: – share consistent product information across multiple channels. – quickly and accurately incorporate new products. –...

Charlie’s Furniture Store has been in business for several years. The firm's owners have described the...

Charlie’s Furniture Store has been in business for several years. The firm's owners have described the store as a "high-price, high-service" operation that provides lots of assistance to its customers. Margin has averaged a relatively high 30% per year for several years, but turnover has been a relatively low 0.6 based on average total assets of $1,200,000. A discount furniture store is about to open in the area served by Charlie's, and management is considering lowering prices to compete effectively....

Larry's Farm Equipment Store has been in business for several years. The firm's owners have described...

Larry's Farm Equipment Store has been in business for several years. The firm's owners have described the store as a "high-price, high-service" operation that provides lots of assistance to its customers. Margin has averaged a relatively high 25% per year for several years, but turnover has been a relatively low 0.6 based on average total assets of $1,200,000. A discount Farm Equipment Store is about to open in the area served by Larry's, and management is considering lowering prices to...

The retail store Macy's is closing a bunch of stores. How does the store closures affect...

The retail store Macy's is closing a bunch of stores. How does the store closures affect employees? How do these factors affect wages and spending? How do these factors affect the demand curve? Will these factors cause the curve to move or shift? Explain.