Question: TOPIC ASSIGNMENT DIRECTION & REQUIREMENT/S Forecasting Instructions: Provide the needed data. Show you solutions in good form. You may use an extra sheet of paper.

Show you solutions in good form. You may use an extra sheet

TOPIC ASSIGNMENT DIRECTION & REQUIREMENT/S Forecasting Instructions: Provide the needed data. Show you solutions in good form. You may use an extra sheet of paper. 1. Moving Average The following is the daily sales for ascorbic acid tablet in Kareem Pharmacy; Nm 1 2 3 4 5 6 7 8 9 100 90 80 60 80 80 80 80 90 co Requirements; a. What will be the forecasted sales for day 10 using a 3-day simple moving average? (5 marks) b. What will be the forecasted sales for day 10 using a 3-day weighted moving average? (5 marks) II. Exponential Smoothing The following are the data from actual daily demand for customized furniture for Cristina Furnitures; Day Demand 1 8 2 9 3 10 4 7 5 Requirement a. Using an exponential smoothing value of 0.05, what will be the forecasted demand for day 6? (5 marks) III. Exponential Smoothing with Trend The following are the data from actual daily demand for customized furniture for Cristina Furnitures; 1 2 14 16 12 3 4 5 18 4 5 6 7 18 10 12 Requirement a. Using an alpha value of 0.10 and a beta value of 0.30, what will be the forecasted demand for day 8? Assume that the manager had an initial demand forecast of 24 and initial trend forecast of 0.2 (5 marks) IV. Least Square Method The data below shows the annual sales of condominium units at Zalaq real estate company 35 40 Year Sales 2006 2007 2008 2009 2010 45 50 60 Requirement a. Using a least square method, what will be the forecasted demand for 2011

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

I had already posted this question but the answer was not complete and was missing the steps. This is the full question and the subject is Financial Risk Management. ASSIGNMENT DIRECTION &...

Discussion Board Week 3 "Managing in the Global Economy and Outsourcing Offshore" Using Techniques to Forecast Variables of Interest to Business and Foreign Exchange During the Weekly Scenarios Herb...

I need Chapter 5 and Chapter 6 solutions to the "City of Bingham" continuous accounting problem from the 16e "Accounting for governmental & nonprofit entities" book. Instructions are posted...

I need a step by step journal entries for Chapter 5 solutions. I need to submit Chapter 6, but want to ensure Ch.5 is correct. Chapter 5 Recording Capital Asset Transactions Street Improvement...

I NEED SOLUTIONS FOR CHAPTER 4.. REQUEST ANY ADDITIONAL INFORMATION IF ITS NECESSARY. Instructions City of Smithville Full Version Computerized Cumulative Problem For use with McGraw-Hill/Irwin...

I would like to have the entries for chapter 5 of the Smithville computer case (short version) see attachment Instructions City of Smithville Short Version Computerized Cumulative Problem For use...

I need the solution Manual for chapter 9. I directions are attached. Instructions City of Smithville Full Version Computerized Cumulative Problem For use with McGrawHill Education Accounting for...

Working on the City of Smithville Short version. I need the journal entries for Chapters 5, 6, and 9 (including Budgetary) ASAP. Thank you for your help. Instructions City of Smithville Short Version...

In 2011, Borland Semiconductors entered into the transactions described below. In 2008, Borland had issued 170 million shares of its $1 par common stock at $34 per share. Required: Assuming that...

Data for the Assembly Department for April 2008 are: Work in process, beginning inventory: Direct materials (100% complete) Conversion costs (40% complete) Units started during April Work in process,...

Jim is a financial analyst at his organization and his primary role is to ensure that the Cardiology service line and the Transplant service line stay within its operational budget for the fiscal...

2. Zimmerman Electronics has the following balances in the company ledgers for the year endine 2022. Required: prepare the: - An income statement - Statement of retained earnings - Classified balance...