hello, i need help with my assignment for my supply chain class.

User Generated

zb7nnn

Business Finance

Description

This homework needs to be EXcel.



20150219065307homework_1.docx 


Unformatted Attachment Preview

BUS ADM 370 Introduction to Supply Chain Management Homework 1 (25 points) For all the problems, to receive full scores, you have to show your complete and accurate work. If you only provide the final answers without showing your computations, you will not be assigned a full score (or you will miss the opportunity of receiving partial credit). All homework is to be turned in on time through D2L. Problem 1: Line Balancing (13 points) First shift employees at Toyota work from 6am to 2pm Monday through Friday. Everyone on the assembly line is allowed a 30 minute lunch and two 20 minute breaks. Other cross-trained associates cover lunches and breaks for the associates on the assembly line so the line doesn’t stop. After three weeks at Toyota, you record the processes of the assembly line are laid out in the following manner: Task A B C D E F G H Predecessor none none A B B C D, E F, G Average Time (sec) 100 150 93 120 86 84 65 15 The Plant Manager needs first shift to achieve an output of 100 units per shift. a) b) c) d) Compute the Takt time for the line (2 points). What is the theoretical minimum number of workstations? (2 points) Draw the precedence diagram (2 points). Assign tasks to work stations and you must use the largest eligible task heuristic rule to break any ties. Show which tasks are assigned to each workstation (3 points). e) Compute the efficiency and percent idle time for the system (2 points). f) What is the maximum output that could be achieved by a single assembly line in 8 hours? (2 points) Problem 2: Forecasting (6 points) Units Sold Jun 255 Jul 305 Aug 298 Sept 268 Oct 321 Nov 359 Dec 319 Given these sales figures over the last 7 months, your boss needs you to create a forecast model that can be used to forecast sales in the future. Use three different forecasting methods (last period, 2 period moving average and 3 period moving average) to determine which forecasting method would be best to forecast future sales. For your measure of “best”, recommend the company use the method with the lowest mean absolute deviation (MAD). a) Calculate the MAD for each of the 3 forecasts (4 points). b) After you have selected the best forecasting method, what would you tell your boss is the forecasted sales for January? (2 points). Problem 3: Forecast Accuracy (6 points) Your company released a new product in December last year. Prior to December, the Marketing Department provided their forecasted sales. The product has been on the market for 5 weeks now and the table below shows the actual sales and Marketing’s forecast of units sold. Week 1 2 3 4 5 Actual Sales Forecasted (units) Sales (units) 3,221 4,000 4,788 4,500 5,372 5,200 6,051 5,900 6,716 6,200 a) Calculate the MFE for the forecast (3 points). b) Calculate the MAPE for the forecast (3 points).
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
Nice! Really impressed with the quality.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags