Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

solve it step by step please Luxe is a new optic store located in Florence which has been operating for a couple of years. Luxe

image text in transcribed

image text in transcribed

solve it step by step please

Luxe is a new optic store located in Florence which has been operating for a couple of years. Luxe is open for 6 days in a week and assume there are 48 weeks in a year. There are two types of glasses that Luxe sells: regular glasses and sunglasses. The distributor of the glasses is in China. It costs 3000 to place an order for regular glasses and 4000 to place an order for sunglasses. The lead time of the orders is expected to be six weeks. The orders of the regular glasses and sunglasses are independent from each other. For the regular glasses, Luxe records the demand data daily. However, it is almost always the case that the ordering decisions are given over the weekend. Luxe purchases one regular glasses for 40 and it costs 8 to keep one regular glasses for one year in the inventory. For the sunglasses, Luxe keeps the data of monthly sales. The unit cost of sunglasses is 60 and Luxe sells them for 150 per unit. Any unsold sunglasses on season is sold at discount for 40. The holding cost for sunglasses is 6 per unit per month. Regular Glasses . . A) You are given the daily demand data about the last year's sales of regular glasses at the end of this document. Analyze the data to determine an appropriate method for forecasting weekly demands. Steps (Following the Note of Forecasting" course document): Consider different forecasting methods that are applicable for the given data. Determine the initial parameter values of these methods based on the data available in the first 36 weeks. Compare these forecasting methods by calculating the one-step-ahead forecast errors from week 37 through week 48. Use the MAD as the basis to compute forecast error. Find the most appropriate method and its parameter values. B) Using the best method found above, forecast the demand for week 49. Also, forecast the total demand over the lead-time (from week 49 through week 54). Sunglasses A) You are given the monthly demand data about the last three years' sales of sunglasses at the end of this document. Analyze the data to determine an appropriate method for forecasting monthly demands. Steps (Following the Note of Forecasting" course document): Consider different forecasting methods that are applicable for the given data. Determine the initial parameter values of these methods based on the data available in the first two years. Compare these forecasting methods by calculating the one-step-ahead forecast errors in the third year. Use the MAD as the basis to compute forecast error. Find the most appropriate method and its parameter values. B) Using the best method found above, forecast the demand for January and February of the fourth year. Also, forecast the total demand over the fourth year. . Regular Glasses: 6 8 9 1 23 5 21 22 27 2 23 19 24 28 11 23 18 16 28 22 30 26 16 3 20 21 22 24 26 21 4 24 21 22 27 27 30 23 27 33 29 7 24 21 22 18 26 29 18 29 30 28 10 22 24 20 27 29 19 19 21 20 23 23 21 18 17 17 24 30 22 27 29 25 12 20 19 22 28 24 22 30 23 22 17 23 23 13 23 20 28 28 30 26 14 24 24 17 21 19 30 15 24 15 23 23 29 28 16 27 21 24 25 29 23 19 18 24 24 28 25 24 26 19 24 20 22 26 30 27 20 26 24 21 27 23 25 21 26 26 19 31 24 24 22 20 26 20 26 26 21 23 25 23 24 25 28 28 24 20 21 23 21 22 19 31 27 26 Week Day Monday Tuesday Wednesday Thursday Friday Saturday Week Day Monday Tuesday Wednesday Thursday Friday Saturday Week Day Monday Tuesday Wednesday Thursday Friday Saturday Week Day Monday Tuesday Wednesday Thursday Friday Saturday 25 28 22 19 23 21 30 26 22 20 21 32 30 25 27 27 25 20 20 22 25 28 22 24 23 28 25 26 29 26 25 24 23 23 24 30 23 29 26 21 26 34 31 21 25 19 22 33 17 32 21 15 24 22 21 31 33 21 16 25 28 20 30 34 22 27 20 27 21 22 35 19 21 21 36 20 24 18 19 24 31 19 30 22 38 41 44 37 19 28 23 22 26 23 17 18 25 30 25 39 23 28 27 27 40 22 23 14 27 21 30 27 19 26 42 22 20 21 32 24 25 43 20 23 23 24 29 34 21 21 23 21 33 26 45 20 23 20 15 22 27 46 18 23 18 31 23 23 47 23 18 24 19 25 22 48 22 19 18 36 33 22 29 26 27 28 18 26 Sunglasses: Month January February March April May June July August September October November December Year 1 89 105 55 55 82 179 Year 3 108 82 90 80 76 Year 2 116 4 48 86 70 0 103 143 107 44 2 100 99 86 148 36 87 20 149 75 58 51 54 41 56

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Financial Reporting

Authors: Alan Melville

7th Edition

1292293128, 9781292293127

More Books

Students also viewed these Accounting questions