Please solve a and b part using excel method and explain the all steps. Luxe Glasses Part
Fantastic news! We've Found the answer you've been seeking!
Question:
Please solve a and b part using excel method and explain the all steps.
Transcribed Image Text:
Luxe Glasses Part I 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. 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. | Luxe Glasses Part I 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. 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. |
Expert Answer:
Answer rating: 100% (QA)
Im sorry but I am unable to interact with or demonstrate the use of software including Excel However I can guide you on how to approach the problem an... View the full answer
Related Book For
Financial Accounting
ISBN: 978-1259222139
9th edition
Authors: Robert Libby, Patricia Libby, Frank Hodge
Posted Date:
Students also viewed these general management questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Review the Robatelli's Pizzeria Case Study. Develop another internal controls system, but this time, in the purchases and fixed assets business areas. Prepare a 12- to 16-slide presentation...
-
a. SMC recently re-named itself from Silo Manufacturing Corporation to give the impression they were a modern manufacturer. Located in Blacksburg, Virginia, SMC is a regional provider of grain...
-
What is the payback period? Name and discuss three possible reasons that the payback period is used to help make capital investment decisions.
-
Galactose, a constituent of the disaccharide lactose found in dairy products, is metabolized by a pathway that includes the isomerization of UDP-galactose to UDP-glucose, where UDP = uridylyl...
-
Write down the displacement thickness of the boundary layer, the thickness of the momentum loss, and the thickness of the energy loss. Explain the physical meaning.
-
When parties must arbitrate their disputes?
-
Speedys Scooters plans to sell a standard scooter for $ 55 and a chrome scooter for $ 70. Speedys purchases the standard scooter for $ 30 and the chrome scooter for $ 40. Speedy expects to sell one...
-
Can you help create an outline for my economics? I chose to create a presentation on the economics of concert tickets. I want to highlight how Ticketmaster/Live Nation is a Monopoly and how their...
-
Spears was seeking employment and negotiating both with Amazon.com and with a firm called Intelligrated. Amazon made 2 offers to Spears which he rejected, because he believed they did not pay enough,...
-
Write a paper about multinational working capital management: common issues and strategies citation should be declared
-
Some argue that certain HR practices create sustained competitive advantage (best practices approach) while others argue that what is more important in the match between HR practices and other...
-
Hans Olo Bros. has developed a new product that will be marketed for the first time next year. Although the marketing department estimates that 35,000 units could be sold at $36 per unit, Hans Olos...
-
As an HR Manager, what changes do you think should be implemented to increase the productivity of your department? What are the three standards developed by the American Psychological Association for...
-
As of December 3 1 , 2 0 2 2 , Stand Still Industries had $ 7 0 0 of raw materials inventory. At the beginning of 2 0 2 2 , there was $ 3 , 0 0 0 of materials on hand. During the year, the company...
-
A retailer has net annual sales of $ 3 , 0 0 0 , 0 0 0 . Retail expenses are $ 2 6 0 , 0 0 0 . Net profit is $ 4 0 0 , 0 0 0 . . For the retailer in this problem, the retail selling price is $ 1 0 ....
-
(a) Draw a 4-bit ALU designed from the unlabeled 1-bit ALU shown below (the same one as in Problem 1). Label all the input and output signals on your diagran.. ALUO (b) Assume that a[3:0] = 3, b[3:0]...
-
For all of the following words, if you move the first letter to the end of the word, and then spell the result backwards, you will get the original word: banana dresser grammar potato revive uneven...
-
Quick Fix-It Corporation was organized at the beginning of this year to operate several car repair busi nesses in a large metropolitan area. The charter issued by the state authorized the following...
-
Exxon Mobil Corporation explores, produces, refines, markets, and supplies crude oil, natural gas, and petroleum products in the United States and around the world. The following are accounts from a...
-
Refer to the annual report for American Eagle Outfitters in Appendix B. Required: 1. The annual report or 10-K report for American Eagle Outfitters provides selected financial data for the last five...
-
A heavy machine tool is transported by a helicopter. The crate containing the machine tool weighs \(12,000 \mathrm{~N}\) and is supported by a steel cable, of length \(5 \mathrm{~m}\) and diameter...
-
The natural frequency of a spring-mass system is found to be \(2 \mathrm{~Hz}\). When an additional mass of \(1 \mathrm{~kg}\) is added to the original mass \(m\), the natural frequency is reduced to...
-
A heavy machine weighing \(9810 \mathrm{~N}\) is being lowered vertically down by a winch at a uniform velocity of \(2 \mathrm{~m} / \mathrm{s}\). The steel cable supporting the machine has a...
Study smarter with the SolutionInn App