Question

In: Operations Management

A clothing retailer is selling a fashion print tee that retails for $22.95 and has a...

A clothing retailer is selling a fashion print tee that retails for $22.95 and has a total landed cost of $15.35 per unit. A new print is released each month, and any leftover inventory from the previous month is deeply discounted to $6.95 to clear space for new product. Assume that all units sell at the clearance price.

Based on sales in previous months, you've determined that full-price demand for each fashion tee is normally distributed with mean 1,380 and standard deviation 478. You expect demand this month to follow the same distribution.

Calculate the optimal order quantity using the newsvendor model. Round your answer to the nearest integer.

Suppose you had ordered the quantity from the previous question in each month of 2018. Actual demand values in each month are shown in the table below, and in the attached Excel file. Calculate total profit for the year by calculating and summing the profit in each month. On the revenue side, be sure to include both full-price and clearance-price sales. On the cost side, assume that the total landed cost per unit is the only relevant cost for this calculation.

Month Demand
January 1130
February 2151
March 1342
April 1700
May 993
June 663
July 1204
August 677
September 1776
October 1980
November 1593
December 1351

Solutions

Expert Solution

Cost of Underage Cu = Price - Cost = 22.95 - 15.35 = 7.60

Cost of overage Co = Cost - Salvage Value = 15.35 - 6.95 = 8.40

Service Level = Cu/(Co+Cu)

Service Level = 7.60/(7.60+8.40) = 0.475

Corresponding z value = -0.06271

Q = Mean + z*SD

Q = 1380 + (-0.06271*478)

Q = 1350.025

Q = 1350 unit

Below is the calculation of profit -

Month January February March April May June July August September October November December
Demand 1130 2151 1342 1700 993 663 1204 677 1776 1980 1593 1351
Q 1350 1350 1350 1350 1350 1350 1350 1350 1350 1350 1350 1350
Profit 8588 10260 10199.2 10260 7546.8 5038.8 9150.4 5145.2 10260 10260 10260 10260
Loss on leftover 0 6728.4 0 2940 0 0 0 0 3578.4 5292 2041.2 8.4
Final Profit 8588 3531.6 10199.2 7320 7546.8 5038.8 9150.4 5145.2 6681.6 4968 8218.8 10251.6
Total Profit 86640

Below is the screenshot of the formula applied to get the result -


Related Solutions

Dear Auditor: Hi-Tech Fashion Inc. (“Fashion”) is a retailer of women’s clothes and clothing accessories. Fashion’s...
Dear Auditor: Hi-Tech Fashion Inc. (“Fashion”) is a retailer of women’s clothes and clothing accessories. Fashion’s operations are based in Seattle, WA, with retail stores located in the nearby suburbs and throughout northwestern United States. Fashion is actively developing opportunities to expand its operations in the surrounding region, including construction of several new retail stores in California. Fashion intends to complete construction and open new stores over the next four years. Fashion anticipates incurring significant expenses and making short-term cash...
Fashion Inc. (“Fashion” or “the Company”), an SEC registrant, is a fashion retailer that sells men’s...
Fashion Inc. (“Fashion” or “the Company”), an SEC registrant, is a fashion retailer that sells men’s and women’s clothing and accessories. As an incentive to its employees, the Company established a compensation incentive plan in which a total of 100,000 options were granted on January 1, 20X0. On that date (the grant date), Fashion’s stock price was $15.00 per share.   The significant terms of the incentive plan are as follows: The options have a $15.00 “strike” or exercise price (the...
Fashion Inc. (“Fashion” or “the Company”), an SEC registrant, is a fashion retailer that sells men’s...
Fashion Inc. (“Fashion” or “the Company”), an SEC registrant, is a fashion retailer that sells men’s and women’s clothing and accessories. As an incentive to its employees, the Company established a compensation incentive plan in which a total of 100,000 options were granted on January 1, 2020. On that date (the grant date), Fashion’s stock price was $15.00 per share. The significant terms of the incentive plan are as follows: The options have a $15.00 “strike” or exercise price (the...
DEFINE the listed types of retails and the wholesalers? Convenience Retailer Discount Retailer Category Specialists Off-Price...
DEFINE the listed types of retails and the wholesalers? Convenience Retailer Discount Retailer Category Specialists Off-Price Retailers ---- Merchant Wholesalers Merchandise Agent/Brokers
Why is there a need for adaptive clothing in todays fashion industry
Why is there a need for adaptive clothing in todays fashion industry
Margaret is a supervisor in the online sales division of a large clothing retailer. She has...
Margaret is a supervisor in the online sales division of a large clothing retailer. She has let it be known that she is devoted to the firm and plans to build her career there. Margaret is hard-working and reliable, has volunteered for extra projects, has taken in-house development courses, and joined a committee dedicated to improving employee safety on the job. She undertook an assignment to research ergonomic office furniture for the head of the department and gave up several...
1.     Fashion Trends, Inc., a regional fashion apparel retailer, wants to prepare a 2018 Pro Forma...
1.     Fashion Trends, Inc., a regional fashion apparel retailer, wants to prepare a 2018 Pro Forma Income Statement and a 2018 Balance Sheet using the following 2017 and 2016 data: Fashion Trends, Inc. Fashion Trends, Inc. income statement Balance Sheet For the Period Ended Dec. 31, 2017 As of Dec. 31, 2017 2017 2016 Assets 2017 2016 Sales 6,148,000 5,134,000 Cash and Equivalents 862,000 678,000 Cost of Goods Sold 4,176,000 3,422,000 Accounts Receivable 1,006,000 730,000 Gross Profit 1,972,000 1,712,000 Inventory...
Ashby clothing is a female clothing line selling high end winter apparel. The company has four...
Ashby clothing is a female clothing line selling high end winter apparel. The company has four brick and mortar locations in central Pa. All locations share the use of the professional back office staff personnel at the company's headquarters. In 2018 the cost of the marketing department was $133,500. The cost of the accounting department was $184,850. The cost of the information technology department was $61,155. Lastly, the customer service call center had a cost of $77,020. Below you will...
1. Ellen Lee, human resource manager of High Fashion Clothing Company, a manufacturer of women’s clothing...
1. Ellen Lee, human resource manager of High Fashion Clothing Company, a manufacturer of women’s clothing and accessories, had just returned from a management development seminar on work motivation. She felt that the company could immediately make use some of the theories she learnt to enhance the workers’ productivity. She was able to convince the executive committee of the company to launch a “high pay reward scheme” – giving extra bonus to those hard working staff members. After the program...
H&M is a clothing retailer founded in 1947. In the last decade, the company has exploded...
H&M is a clothing retailer founded in 1947. In the last decade, the company has exploded to $20.3 billion in annual sales. The company has 3,500 stores spread across 55 countries, and a huge warehousing and logistics to manage. While the success of H&M is mainly due to following the latest fashion trends, the secret to its success is low production cost and reduced lead times or how fast they get their products to market. H&M stores are refreshed daily...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT