The Grommet is manufactured in Thailand. Orders take 30 days to arrive via sea freight. With the costs of communications, customs, and freight, each order placed incurs an expenditure of $935. Once the boards arrive at the warehouse, the inventory carrying cost is 15% per year/per unit of the COGS.
Based on the information provided in this case study, you will create a 2021 inventory plan for Surf Shaper. Using the spreadsheet provided and the formulas you learned and practiced last week.
1. Create a Sales Forecast showing a 15% increase in sales over 2020.
2. Using your 2021 Sales Forecast, determine the amount of Safety Stock Surf Shapers should keep on hand to meet their service level goal.
3. Utilizing the EOQ method, identify:
a. The optimal order quantity (0)
b. The number of orders to be completed
c. The Re-Order Point
d. Total ordering cost
The best-selling board for Surf Shaper is the Grommet, their 8-foot foam wide board, that is suitable for beginners and casual surfers. The Grommet retails for $400, and COGS is $150 per unit. The popularity of the Grommet has been steadily increasing over the past three years. The unit sales report is displayed below.
2018 2019 2020
January 790 853 929
February 800 864 944
March 1,300 1,404 1,544
April 1,560 1,685 1,943
May 1,620 1,750 2,469
June 1,970 2,128 2,584
July 2,140 2,311 2,539
August 2,230 2,408 2,541
September 1,560 1,685 2,426
October 1,280 1,382 1,573
November 1,070 1,156 1,271
December 940 1,015 976
Total 17,260 18,641 21,740
Answers: 3
Other questions on the subject: Business
Business, 22.06.2019 11:40, sriggins1375
Manipulation manufacturing's (amm) standards anticipate that there will be 5 pounds of raw material used for every unit of finished goods produced. amm began the month of maymay with 8,000 pounds of raw material, purchased 25,500 pounds for $ 15,300 and ended the month with 7,400 pounds on hand. the company produced 4,9004,900 units of finished goods. the company estimates standard costs at $ 1.10 per pound. the materials price and efficiency variances for the month of maymay were:
Answers: 1
Business, 22.06.2019 20:00, adriannacomrosenbark
Modern firms increasingly rely on other firms to supply goods and services instead of doing these tasks themselves. this increased level of is leading to increased emphasis on management.
Answers: 2
Business, 22.06.2019 20:40, MyaMya12
Asmall town wants to build some new recreational facilities. the proposed facilities include a swimming pool, recreation center, basketball court and baseball field. the town council wants to provide the facilities which will be used by the most people, but they face budget and land limitations. the town has $400,000 and 14 acres of land. the pool requires locker facilities which would be in the recreation center, so if the swimming pool is built the recreation center must also be built. also, the council has only enough flat land to build the basketball court or the baseball field. the daily usage and cost of the facilities (in $1,000) are shown below. which facilities should they build? facilityusagecost ($1,000)landswimming pool4001002recreation center5002003basketball court3001504baseball field2001005
Answers: 1
Do you know the correct answer?
The Grommet is manufactured in Thailand. Orders take 30 days to arrive via sea freight. With the cos...
Questions in other subjects:
Mathematics, 07.01.2020 19:31
Health, 07.01.2020 19:31
Physics, 07.01.2020 19:31
Social Studies, 07.01.2020 19:31
