8 91426 10 11 (CCM) builds furniture for a range of commercial customers. They build furniture...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
8 91426 10 11 (CCM) builds furniture for a range of commercial customers. They build furniture used in hotels and department stores, on cruise liners, ferries and passenger aircraft. One of their products is a luxury bedside tablo. 13 The quarterly demand for the tables during the last 3 years was as follows in Table 1. Table 1 Quarterly demand for luxury bedside tables (PART 1 OF 3) Last year's weekly demand was as follows in Table 2. Table 2 Weekly demand in 2019 for luxury bedside tables Demand Week Demand Week 1 60 14 2 34567 Year 2017 2018 2019 55 65 65 70 65 70 70 70 95 60 70 80 15 16 17 18 19 20 21 22 23 24 25 26 160 70 65 65 70 75 70 Period 1 2 3 4 70 60 75 70 75 80 5 6 7 8 9 10 11 12 Week 27 28 29 30 31 32 33 34 35 36 37 38 39 Demand 75 60 65 70 75 75 70 40 70 85 85 55 85 Demand 880 875 910 895 870 865 880 900 895 905 910 915 Week 4041 4243 44 45 46 47 48 49 50 51 52 Demand 60 65 65 60 65 75 70 70 65 65 110 75 70 Firm orders already received for this year are as follows in Table 3. Table 3 Firm orders for luxury bedside tables in the first 20 weeks of 2020 Week 11 12 e . Week 1 。 2 3 4 General Note: 5 6 7 8 9 10 Orders 60 70 50 80 40 60 80 110 13 14 15 16 17 18 19 20 PART IOF]) Orders 20 - Questions 1. Use Monte Carlo Simulation and Exponential Smoothing (plus any other techniques you feel are appropriate) to predict the weekly demand for the first 13 weeks (1st quarter) of 2020. Consider a=0.3 50 30 20 (7) 2. Combine the Forecast Demand with the Firm Orders to determine the Master Schedule. One for each technique. (5) 3. Explain the reasoning behind your answers, as well as which of the Master Schedules would represent closely the reality. (4) 4. Discuss if there are any disadvantages of using Monte Carlo Simulation, and compare your results with those of time series forecasting. (4) All calculations need to be provided. The time period of a quarter lasts for 13 weeks. You may need to make assumptions due to incomplete data. Explain your assumptions. You do not need to explain Monte Carlo Simulation or Time Series Analysis calculations. Limitations of the techniques used (e.g. Monte Carlo, time series analysis, etc.) should be focused in your problem, not the general limitations of the technique. The bedside cabinet consists of a wood case, made from 5 planks of wood, 4 aluminium legs and associated brackets and screws. The raw material for the legs is a length of aluminium profile. Each length of aluminium can make 2 legs. (раст чого) Figure 1 Luxury bedside cabinets [1] Last year the cost to run the Purchasing Department was £1050,000 (this does not include the Material Costs to purchase the components, raw materials etc.). 30,000 purchase orders were placed last year. Setting up times to build the complete bedside cabinet, the cabinet top and the legs are as follows: Cabinet wood case- 1 hour per setup at a cost of £50 per hour. Legs - 1 hour per setup at a cost of £50 per hour. Complete bedside cabinet assembly - 1 hour per setup at a cost of £50 per hour. Last year the cost to run the stores (storemen's wages, lighting, heating etc.) was £250,000. Money invested in stocks over last year was £155,000. There were 4 general stock checks where each item of stock was recorded. The total value of stock for each of the stock checks was: £1,450,000 £1,600,000 £1,500,000 £1,050,000 Table 4. Components and products related with the luxury bedside cabinets On Hand Component / Product Lead Time (weeks) Bedside Cabinet Wood case Leg Length of Aluminium Brackets and Screws Wood Plank Stock Number 101 201 202 302 203 303 2227 1 1 350 250 850 50 100 Material Costs 50 15 53 lov 2 Made or Bought Made Made Made Bought Bought Bought Questions 1. Draw the BOM for the bedside cabinet. PART 2 CF3) (2) 2. Calculate the EOQ for each of the stock items in Table 4 (rounded up to the nearest 5) apart from the brackets and screws. Note: Calculate the 2020 annual demand using linear regression of the last three years (Table 1 in coursework Part 1). The EOQ depends on the parts required to build a complete bedside cabinet (i.e. 5 planks, 4 legs) (10) 3. The company requires a service level of 95% for all stock items. Calculate the amount of safety stock required (rounded up to the nearest 5) for each of the stock items in Table 4 apart from the brackets and screws. Remember that the safety stock depends on the lead time of each item. (10) (3) 4. Explain the reasoning behind your answers. General Note: All calculations need to be provided.. You may need to make assumptions due to incomplete data. Explain your assumptions. You do not need to explain BOM or EQM. The wood supplier for the wood case of the bedside cabinets can supply planks in pallets of 200, and the aluminium supplier for the legs can only supply lengths of aluminium in pallets of 100. Table 4. Components and products related with the luxury bedside cabinets (PART 3 CF3 Component On Hand Lead Time (weeks) / Product Bedside Cabinet 2 Wood case 0 Leg Length of Aluminium Brackets and Screws Wood Plank Stock Number General Note: 101 201 202 302 203 303 2 2 1 1 350 250 850 50 100 Material Costs 50 15 5 3 2 Made or Bought Made Made Made Bought Bought Bought Questions 1. Using the EOQ's and safety stocks you have calculated plus any other relevant information, calculate when to place the Works and Purchase Orders using MRP for all the components for the first quarter of year 2020. Note: Assume that you have the stock on hand at the beginning of week 1 Use your master schedule from the Monte Carlo simulation as your gross requirement Avoid any stockouts (6) 2. Considering that each cabinet costs £500, and assuming a set up cost of £100 per lot and an annual stockholding cost of 25% of the unit cost. Calculate the cost of stock if the production rate is 15 units per day and the company operates 250 days per year. Explain how the company could calculate its costs of stock Note: Round up the product quantities to the nearest 5 3. Explain how the company could reduce its costs of stock. (2) 4. Explain what the company should do if it discovered 42 defective coffee tables before despatching them to its customer. (2) 5. Explain the reasoning behind your answers.. (3) (2) All calculations need to be provided. You may need to make assumptions due to incomplete data. Explain your assumptions. 8 91426 10 11 (CCM) builds furniture for a range of commercial customers. They build furniture used in hotels and department stores, on cruise liners, ferries and passenger aircraft. One of their products is a luxury bedside tablo. 13 The quarterly demand for the tables during the last 3 years was as follows in Table 1. Table 1 Quarterly demand for luxury bedside tables (PART 1 OF 3) Last year's weekly demand was as follows in Table 2. Table 2 Weekly demand in 2019 for luxury bedside tables Demand Week Demand Week 1 60 14 2 34567 Year 2017 2018 2019 55 65 65 70 65 70 70 70 95 60 70 80 15 16 17 18 19 20 21 22 23 24 25 26 160 70 65 65 70 75 70 Period 1 2 3 4 70 60 75 70 75 80 5 6 7 8 9 10 11 12 Week 27 28 29 30 31 32 33 34 35 36 37 38 39 Demand 75 60 65 70 75 75 70 40 70 85 85 55 85 Demand 880 875 910 895 870 865 880 900 895 905 910 915 Week 4041 4243 44 45 46 47 48 49 50 51 52 Demand 60 65 65 60 65 75 70 70 65 65 110 75 70 Firm orders already received for this year are as follows in Table 3. Table 3 Firm orders for luxury bedside tables in the first 20 weeks of 2020 Week 11 12 e . Week 1 。 2 3 4 General Note: 5 6 7 8 9 10 Orders 60 70 50 80 40 60 80 110 13 14 15 16 17 18 19 20 PART IOF]) Orders 20 - Questions 1. Use Monte Carlo Simulation and Exponential Smoothing (plus any other techniques you feel are appropriate) to predict the weekly demand for the first 13 weeks (1st quarter) of 2020. Consider a=0.3 50 30 20 (7) 2. Combine the Forecast Demand with the Firm Orders to determine the Master Schedule. One for each technique. (5) 3. Explain the reasoning behind your answers, as well as which of the Master Schedules would represent closely the reality. (4) 4. Discuss if there are any disadvantages of using Monte Carlo Simulation, and compare your results with those of time series forecasting. (4) All calculations need to be provided. The time period of a quarter lasts for 13 weeks. You may need to make assumptions due to incomplete data. Explain your assumptions. You do not need to explain Monte Carlo Simulation or Time Series Analysis calculations. Limitations of the techniques used (e.g. Monte Carlo, time series analysis, etc.) should be focused in your problem, not the general limitations of the technique. The bedside cabinet consists of a wood case, made from 5 planks of wood, 4 aluminium legs and associated brackets and screws. The raw material for the legs is a length of aluminium profile. Each length of aluminium can make 2 legs. (раст чого) Figure 1 Luxury bedside cabinets [1] Last year the cost to run the Purchasing Department was £1050,000 (this does not include the Material Costs to purchase the components, raw materials etc.). 30,000 purchase orders were placed last year. Setting up times to build the complete bedside cabinet, the cabinet top and the legs are as follows: Cabinet wood case- 1 hour per setup at a cost of £50 per hour. Legs - 1 hour per setup at a cost of £50 per hour. Complete bedside cabinet assembly - 1 hour per setup at a cost of £50 per hour. Last year the cost to run the stores (storemen's wages, lighting, heating etc.) was £250,000. Money invested in stocks over last year was £155,000. There were 4 general stock checks where each item of stock was recorded. The total value of stock for each of the stock checks was: £1,450,000 £1,600,000 £1,500,000 £1,050,000 Table 4. Components and products related with the luxury bedside cabinets On Hand Component / Product Lead Time (weeks) Bedside Cabinet Wood case Leg Length of Aluminium Brackets and Screws Wood Plank Stock Number 101 201 202 302 203 303 2227 1 1 350 250 850 50 100 Material Costs 50 15 53 lov 2 Made or Bought Made Made Made Bought Bought Bought Questions 1. Draw the BOM for the bedside cabinet. PART 2 CF3) (2) 2. Calculate the EOQ for each of the stock items in Table 4 (rounded up to the nearest 5) apart from the brackets and screws. Note: Calculate the 2020 annual demand using linear regression of the last three years (Table 1 in coursework Part 1). The EOQ depends on the parts required to build a complete bedside cabinet (i.e. 5 planks, 4 legs) (10) 3. The company requires a service level of 95% for all stock items. Calculate the amount of safety stock required (rounded up to the nearest 5) for each of the stock items in Table 4 apart from the brackets and screws. Remember that the safety stock depends on the lead time of each item. (10) (3) 4. Explain the reasoning behind your answers. General Note: All calculations need to be provided.. You may need to make assumptions due to incomplete data. Explain your assumptions. You do not need to explain BOM or EQM. The wood supplier for the wood case of the bedside cabinets can supply planks in pallets of 200, and the aluminium supplier for the legs can only supply lengths of aluminium in pallets of 100. Table 4. Components and products related with the luxury bedside cabinets (PART 3 CF3 Component On Hand Lead Time (weeks) / Product Bedside Cabinet 2 Wood case 0 Leg Length of Aluminium Brackets and Screws Wood Plank Stock Number General Note: 101 201 202 302 203 303 2 2 1 1 350 250 850 50 100 Material Costs 50 15 5 3 2 Made or Bought Made Made Made Bought Bought Bought Questions 1. Using the EOQ's and safety stocks you have calculated plus any other relevant information, calculate when to place the Works and Purchase Orders using MRP for all the components for the first quarter of year 2020. Note: Assume that you have the stock on hand at the beginning of week 1 Use your master schedule from the Monte Carlo simulation as your gross requirement Avoid any stockouts (6) 2. Considering that each cabinet costs £500, and assuming a set up cost of £100 per lot and an annual stockholding cost of 25% of the unit cost. Calculate the cost of stock if the production rate is 15 units per day and the company operates 250 days per year. Explain how the company could calculate its costs of stock Note: Round up the product quantities to the nearest 5 3. Explain how the company could reduce its costs of stock. (2) 4. Explain what the company should do if it discovered 42 defective coffee tables before despatching them to its customer. (2) 5. Explain the reasoning behind your answers.. (3) (2) All calculations need to be provided. You may need to make assumptions due to incomplete data. Explain your assumptions.
Expert Answer:
Answer rating: 100% (QA)
Firstly have to Draw a BOM and calculate the EOQ Questions 1 Draw the BOM for the bedside cabinet A BOM Bill of Materials is a hierarchical representation of the components and subassemblies required ... View the full answer
Related Book For
Cost Accounting A Managerial Emphasis
ISBN: 978-0133392883
6th Canadian edition
Authors: Horngren, Srikant Datar, George Foster, Madhav Rajan, Christ
Posted Date:
Students also viewed these mathematics questions
-
During the last 3 years Consolidated Oil Company expanded its gasoline stations into convenience food stores (CFSs) in an attempt to increase total sales revenue. The daily sales (in hundreds of...
-
PDS Manufacturing makes wooden furniture. One of their products is a wooden dresser. The exterior and some of the shelves are made of oak, a high-quality wood, but the interior drawers are made of...
-
MFD Manufacturing makes wooden furniture. One of their products is a wooden dresser. The exterior and some of the shelves are made of oak, a highquality wood, but the interior drawers are made of...
-
Necked Amber purchased a bond for $1,038.90 exactly two years ago. At that time, the bond had a maturity of five years and a coupon rate of 10% (paid semi-annually). Assuming the rates below are the...
-
Trinh Technologies Company (TTC) has two intangible assets at the end of the year. 1. Signed a 5-year lease for an office on March 1. TTC immediately spent $ 35,000 for leasehold improvements. TTC...
-
1. Analyze the data concerning voters in Table 3.2 as described below. 2. Analyze the data concerning income tax rates in Table 3.2 as described below. 3. Analyze the data concerning video rentals in...
-
What are the four concepts that are essential to the extended object-oriented approach to software development?
-
The 10-Mg helicopter carries a bucket containing 500 kg of water, which is used to fight fires, if is hovers over the land in a fixed position and then releases 50 kg/s of water at 10m/s, measured...
-
10) If the third and fourth terms of an arithmetic sequence are -7 and -10, what are the first and second terms?
-
Given a directed graph G = (V, E), explain how to create another graph G = (V, E) such that (a) G has the same strongly connected components as G, (b) G has the same component graph as G, and (c) E...
-
A portfolio has a Jensen's alpha of 0.82 percent, a beta of1.40, and a CAPM expected return of 13.7 percent. The risk-freerate is 2.5 percent. What is the actual return of the portfolio? 15.5%;...
-
The market price of a security is $92. Its expected rate of return is 20.1%. The risk-free rate is 3%, and the market risk premium is 6.4%. What will be the market price of the security if its...
-
3. Yvonne and Tanya each make regular deposits into an annuity. Yvonne deposits $150 at the end of each month at 8% per year compounded monthly Tanya deposits $450 at the end of each quarter at 8%...
-
The statement of assets and liabilities is - A . Balance sheet B . Trial balance C . Trading account D . Profit and loss account
-
You have been given the following projections for A&J Limited: _ 7 Year 1 2 3 4 5 ' Free cash flow of the firm 400 460 540 620 620 lntcrest-bearing debt 750 700 600 500 700 Interest expense 100 85 74...
-
The U.S. Central Intelligence Agency maintains an online World Factbook that is a convenient source of a wide variety of geographic, social, and economic information. You may look up information by...
-
What is the purpose of the DatagramPacket class in Java UDP socket programming ? ? a . . To represent a UDP socket b . . To handle multiple connections To implement encryption . . To store data for...
-
Determine the reactions in supports A and D and connections B and C. Sketch its shear and moment diagram and determine the magnitude ankoration of the maximum shear and moment for every member. 18 3...
-
Heather's Horse Spa (HHS) is an establishment that boards, trains, and pampers horses while their owners are on vacation. Heather sells her service as an "enchanting vacation experience for your...
-
Connor Companys budgeted prices for direct materials, direct manufacturing labour, and direct marketing (distribution) labour per attach case are $40, $8, and $12, respectively. The president is...
-
Product mix, constrained resource. Taylor Furniture produces and sells specialty mat-tresses. Production is a machine-intensive process. Taylors variable costs are direct material costs, variable...
-
A packed bed composed of crushed rock having a density of $175 \mathrm{lb}_{\mathrm{m}} / \mathrm{ft}^{3}$ is to be used as a filter. The size and shape of the rock particles is such that the average...
-
A rotary drum filter is to be installed in your plant. You run a test in the lab on the slurry to be filtered using a $0.1 \mathrm{ft}^{2}$ sample of the filter medium at a constant pressure drop of...
-
A rotary drum filter, $10 \mathrm{ft}$ in diameter and $8 \mathrm{ft}$ long, is to be used to filter a slurry of incompressible solids. The drum rotates at $1.2 \mathrm{rpm}$, and $40 %$ of its...
Study smarter with the SolutionInn App