Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1st two slides are examples and the 3rd one is the question and i need answer 3rd slide thank you [MPS] Best Buy company forecasted

image text in transcribed

image text in transcribed

image text in transcribed

1st two slides are examples and the 3rd one is the question and i need answer 3rd slide thank you

[MPS] Best Buy company forecasted sales for 2021 for family or group of appliance such as Stove, Washer, Fridge, etc. Example 1: Step 1: MTS (Make to Stock) Group product: Appliance Season Winter Spring Summer Fall Total 300 350 300 250 1200 Forecasted demand/Sales 500 250 250 250 250 Level Production End. Inventory 450 350 300 300 Level production = (1200 + 300 - 500) / 4 = 250 units/season Lot Size = 250 Units Level Production = 250 W S S F 200 150 100 150 Season F.D End. Inv. MPS 100 -50 200 100 Stove -50 200 0 250 0 250 300 W S S F Season F.D 100 200 200 100 Fridge 150 100 End. Inv. MPS 100 350 250 -50 200 250 0 0 200 #options = (level production / lot size) + 1 = (250 / 250) + 1 = 2 Options 1 2 Stove (1x 250) 0 Fridge 0 (1x250) Total (level production) 250 250 Example 2: MTS (Make-To-Stock) (Appliance) Given info: 1. Opening Iny. : 2000 units 2. Desired End. Inv.: 4000 units Q Winter Spring Summer Fall Total Forecasted Demand/Sale 3000 3500 3500 4000 14000 Example 2: MTS (Make-To-Stock) (Appliance) Given info: 1. Opening Inv. : 2000 units 2. Desired End. Inv.: 4000 units Q Winter Spring Summer Fall Total Forecasted Demand/Sale 3000 3500 3500 4000 14000 2000 Level Production 4000 4000 4000 4000 Ending. Inv. 3000 3500 4000 4000 Level production = (14000+4000 - 2000) / 4 = 4000 units/season MPS Level production = 4000 units Lot size = 1000 units Q Winter Spring Summer Fall Forecasted Demand/Sale 1000 1500 1000 2000 stove 1000 Ending. Inv. 500 0 3000 1500 -1000 1000 2000 MPS 0 2000 3000 1000 Q Winter Spring Summer Fall Fridge Forecasted Demand/Sale 2000 2000 2500 2000 500 Ending. Inv. -1500 2500 500 2500 0 1000 -1000 2000 MPS 4000 2000 1000 3000 #options= (level production/lot size) + 1 = (4000/1000)+1 = 5 Options 1 2 3 5 Stove (4x1000) (3x1000) (2x1000) (1x1000) 0 Fridge 0 (1x1000) (2x1000) (3x1000) (4x1000) Total (L.P) 4000 4000 4000 4000 4000 Assignment MPS 2 MTS (Make-To-Stock] Family of Appliance [Stove, Fridge] Best Buy Company forecasted sales for 2021. Opening Inv. = 2000 units of all devices End. Inv. = 0 units of all devices Season Winter Spring Summer Fall Total 6000 5000 6000 5000 Forecast Demand/Sales 2000 Level (Plann ed) Production End. Inv. Level Production = MPS Lot size = 1000 units Season Winter Spring Summer Fall Forecast Demand 1500 4000 4000 4500 Stove End. Inv. MPS 800 Season Winter Summer Fall Spring 1000 Forecast Demand 4500 2000 500 End. Inv. Fridge MPS

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Fundamentals Of Human Resource Management

Authors: David A DeCenzo, Stephen P Robbins, Susan L Verhulst

12th Edition

1119032741, 9781119032748

Students also viewed these Accounting questions