Please have a look at the attached document  Compare two sales forecasting methods: · Static Forecast: Orders placed based on a single,

Please have a look at the attached document 

Compare two sales forecasting methods:

·
Static Forecast: Orders placed based on a single, initial forecast for the entire season.

·
Dynamic Forecast: Orders placed for a short initial period, then updated based on actual sales and used for the remaining season.

Data Setup:

1.
Products: Select 5-10 products (P1, P2, P3, P4, P5).

2.
Initial Forecast: Enter an initial sales forecast unit for each product. For example, 200 units for P1. 100 units for P2, 250 units for P3……

3.
Sales Period: Set the sales period to 90 days

4.
Daily Sales: Calculate daily sales for each product by dividing the forecast by the sales period. Example, P1= 200/90= 2.22 units per day.

5.

Initial Order: Specify the initial order quantity for the first 20 days. E.g. 44 units for P1

6.
Sales Monitoring Period: Define the sales monitoring period as 14 days

7.
Costs & Prices: Set a cost price for each product assuming a 63% gross margin

Dynamic Forecast Simulation:

1.
Actual Sales: Enter actual daily sales for each product during the monitoring period (14 days).

2.
Updated Forecast: Based on actual sales data, revise the initial forecast for the remaining period (Days 21-90). This can be done using various methods like historical averages, trend analysis, or simply adjusting based on observed trends. Update the forecast.

3.
Remaining Order: Calculate the remaining order quantity for each product by subtracting the initial order from the updated forecast for the remaining period.

Static Forecast Simulation:

1.
Lost Sales/Excess Inventory: In a separate section, track lost sales (opportunities missed due to insufficient stock) or excess inventory (unsold units) for the static forecast scenario based on the initial forecast and actual sales data.

Analysis:

1.
Sales Revenue: Calculate sales revenue for both scenarios by multiplying the actual daily sales (Dynamic) or forecasted daily sales (Static) by the selling price.

2.
Profit: For the dynamic scenario, calculate profit by subtracting the cost price from the sales revenue

3.
Leftover Stock: Calculate leftover inventory for the dynamic scenario by subtracting actual sales from the total received quantity (initial order + remaining order).

4.
Markdown Revenue: If there’s leftover stock, calculate markdown revenue by multiplying the leftover quantity by a markdown percentage (e.g., 50%).

5.
Total Revenue: Calculate the total revenue for the dynamic scenario by summing sales revenue and markdown revenue (if applicable).

Comparison:

Compare the total revenue, lost sales/excess inventory, and profit between the two scenarios to assess the effectiveness of the dynamic forecasting approach.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Communication Management (MGT 421) Due Date: 13/7/2024 @ 23:59 Course Name: Student’s Name: Course Code: MGT421 Student’s ID Number: Semester: Summer Semester CRN:

Concept Map Template Primary Diagnosis: ___________________________________________________________ 1. Describe the pathophysiology of the

Concept Map Template Primary Diagnosis: ___________________________________________________________ 1. Describe the pathophysiology of the primary diagnosis in your own words. What are the patient’s risk factors for this diagnosis? Pathophysiology of Primary Diagnosis Causes Risk Factors (genetic/ethnic/physical) 2. What are the patient’s signs and symptoms for this diagnosis? How does the diagnosis

See attached for directions This is an insightful examination of Andy Warhol’s work. Due to his creative thinking, his studio, became a hub for

See attached for directions This is an insightful examination of Andy Warhol’s work. Due to his creative thinking, his studio, became a hub for creativity and collaboration, attracting artists, musicians, actors, and intellectuals, fostering a vibrant cultural scene, and influencing countless movements in art, music, and fashion. Your explanation of

explain the following: Boththe neurological and musculoskeletal pathophysiologic processes that would account for the patient presenting these

explain the following: Boththe neurological and musculoskeletal pathophysiologic processes that would account for the patient presenting these symptoms. Any racial/ethnic variables that may impact physiological functioning. How these processes interact to affect the patient. Scenario:  A 58-year-old obese white male presents to ED with a chief complaint of fever, chills, pain, and

Information System Application for Decision Making Paper Goal: Identify the process for decision making regarding technology. Discuss nursing role in

Information System Application for Decision Making Paper Goal: Identify the process for decision making regarding technology. Discuss nursing role in identifying appropriate technology for practice. Your paper should include the following: 1. One technology application used in health care to facilitate decision making.2. The application’s impact on quality of decision