{"id":8434,"date":"2023-03-06T03:12:54","date_gmt":"2023-03-06T03:12:54","guid":{"rendered":"https:\/\/www.goodacademic.com\/blog\/questions\/introduction-to-supply-chain-management-homework-1\/"},"modified":"2023-03-06T03:12:54","modified_gmt":"2023-03-06T03:12:54","slug":"introduction-to-supply-chain-management-homework-1","status":"publish","type":"questions","link":"https:\/\/www.goodacademic.com\/blog\/questions\/introduction-to-supply-chain-management-homework-1\/","title":{"rendered":"Introduction to Supply Chain Management Homework 1"},"content":{"rendered":"
\n Learning Goal: <\/b>I’m working on a mathematics exercise and need the explanation and answer to help me learn.<\/p>\n

For all the problems, to receive full score, you <\/span>must <\/span>show<\/span> your complete and accurate work, i.e., show <\/span>
how you calculated the numbers you use.<\/span> If you only provide the final answers without <\/span>computations, <\/span>
you will not receive <\/span> a full score<\/span> even if the answer you provided is correct<\/span> (<\/span>and <\/span> will miss the <\/span>
opportunity of partial credit<\/span>s<\/span> if your answer is not correct<\/span>).<\/span> The computations should show all the<\/span>
steps you use. Note that, if you use Excel and Excel formulas<\/span>\/tools<\/span> (<\/span>e.g.,<\/span> average function or <\/span>regression <\/span>
tool in Data Analysis) <\/span>to come up with solutions<\/span>, your solution steps will be included in the Excel file. <\/span>
T<\/span>he points from the bonus question <\/span>in this <\/span>homework <\/span>will count towards your Homework 1 score. <\/span> <\/p>\n

Problem 1.<\/span> (<\/span>10<\/span> points)<\/span>
A manager record<\/span>ed<\/span> the number of gallons of ice cream sold for the past six periods. He asked you to choose <\/span>
a forecasting model to predict the demand for gallons of ice cream in Period 7. You consider <\/span> applying<\/span> a <\/span>
two<\/span>–<\/span>period moving average <\/span>model <\/span>and a two<\/span>–<\/span>period weighted movi<\/span>ng average <\/span>model <\/span>with weights of 0.<\/span>6<\/span>
and 0.<\/span>4<\/span>. <\/span>
a)<\/span> Which model is better for this data set (hint<\/span>:<\/span> show all your work <\/span>including forecasts <\/span>for each period <\/span>and <\/span>
calculations using measures of forecast accuracy)<\/span>?<\/span> (9 points) <\/span>
b)<\/span> What is the forecast of demand for period 7<\/span> considering the best model<\/span>?<\/span> (1<\/span> point)<\/span>
Period<\/span> Demand<\/span>
1<\/span> 65<\/span>0<\/span>
2<\/span> 7<\/span>00<\/span>
3<\/span> 8<\/span>1<\/span>0<\/span>
4<\/span> 8<\/span>00<\/span>
5<\/span> 900<\/span>
6<\/span> 700<\/span> <\/p>\n

Problem 2. (22<\/span> points)<\/span>
An assembly line is to operate <\/span>eight <\/span>hours per day with a desired output of <\/span>24<\/span>0<\/span> units per day. The <\/span>
following table contains information on this product\u00e2\u20ac\u2122s task times and precedence relationships:<\/span>
TASK<\/span>
TASK TIME<\/span>
(SECONDS)<\/span>
IMMEDIATE<\/span>
PREDECESSOR<\/span>
A<\/span> 7<\/span>5<\/span> \u00e2\u20ac\u201d<\/span>
B<\/span> 48<\/span> A<\/span>
C<\/span> 40<\/span> A<\/span>
D<\/span> 40<\/span> A<\/span>
E<\/span> 2<\/span>7<\/span> B, C<\/span>
F<\/span> 48<\/span> C, D<\/span>
G<\/span> 7<\/span>2<\/span> E, F<\/span>
H<\/span> 9<\/span>0<\/span> G<\/span> <\/p>\n

a.<\/span> Draw the <\/span>precedence diagram. (5 points)<\/span>
b.<\/span> What is the workstation cycle time required to produce <\/span>2<\/span>4<\/span>0 units per day? (2 points)<\/span>
c.<\/span> Balance this line using the longest task time<\/span>. Use<\/span> largest number of following tasks<\/span> as a secondary <\/span>
(tiebreaker) rule<\/span>.<\/span> You <\/span>need to show <\/span>all the <\/span>assignment<\/span>s to t<\/span>he workstation<\/span>s <\/span>and the order in which <\/span>
you assign tasks. <\/span>(1<\/span>0<\/span> points)<\/span>
d.<\/span> What is <\/span>t<\/span>he <\/span>efficiency <\/span>of your line<\/span>? <\/span>(5 points)<\/span><\/p>\n

Problem <\/span>3<\/span>. <\/span>(<\/span>18<\/span> points)<\/span>
The f<\/span>ollowing data were collected <\/span>for <\/span>1<\/span>2<\/span> month<\/span>s<\/span> using <\/span>a company\u00e2\u20ac\u2122s sales reports. The report shows<\/span>,<\/span> for <\/span>
each month, <\/span>the amount of money <\/span>the company spent for advertising (x) and <\/span>the amount of <\/span>sales <\/span>(y) made<\/span>
after th<\/span>os<\/span>e advertising <\/span>expenditures<\/span>.<\/span> Both the advertising and sales dollars are in units of <\/span>thousand dollars<\/span>. <\/span>
The Chief Executive Officer of the company is interest<\/span>ed in the impact of the advertising spending on the <\/span>
actual sales. <\/span>
Month<\/span> x<\/span> y<\/span>
1<\/span> 90<\/span> 8,400<\/span>
2<\/span> 116<\/span> 9,980<\/span>
3<\/span> 138<\/span> 12,640<\/span>
4<\/span> 150<\/span> 14,100<\/span>
5<\/span> 166<\/span> 16,420<\/span>
6<\/span> 164<\/span> 13,800<\/span>
7<\/span> 156<\/span> 13,180<\/span>
8<\/span> 130<\/span> 12,280<\/span>
9<\/span> 108<\/span> 9,280<\/span>
10<\/span> 102<\/span> 9,760<\/span>
11<\/span> 68<\/span> 6,850<\/span>
12<\/span> 84<\/span> 7,720<\/span> <\/p>\n

(a)<\/span> Provide the scatter plot for <\/span>advertising vs sales dollars <\/span>with the trend line. (4<\/span> points)<\/span>
(b)<\/span> Obtain a linear regression line for the data. (Hint: You need to calculate a and b to get the linear <\/span>
regression equation: y= a + bx) <\/span>(<\/span>8<\/span> points)<\/span> You need to show all the work in Excel or ma<\/span>nually <\/span>
when you computed <\/span>the line equation. <\/span>
(c)<\/span> Predi<\/span>ct the sales fig<\/span>ures in months 1<\/span>3<\/span> and 1<\/span>4<\/span> if the advertising<\/span> budgets allocated for months 13<\/span>
and 1<\/span>4<\/span> are $<\/span>12<\/span>0<\/span>,000 <\/span>a<\/span>nd <\/span>$<\/span>1<\/span>1<\/span>8<\/span>,000<\/span>, respectively. (6<\/span> points)<\/span> <\/p>\n

Bonus Problem<\/span> (6 points)<\/span> (Bonus points will be added to your homework score).<\/span>
a)<\/span> A supplier of instrument gauge clusters uses a <\/span>K<\/span>anban system to control material flow. The gauge cluster <\/span>
housings are transported <\/span>five<\/span> at a time. A fabrication center produces approximately <\/span>18<\/span> gauges per hour. <\/span>
It takes approximately <\/span>two <\/span>hours for the hous<\/span>ing to be replenished. Due to variations in processing times, <\/span>
management has decided to keep <\/span>3<\/span>5<\/span> percent of the needed inventory as safety stock. How many <\/span>Kanban<\/span>
card sets are needed?<\/span> (3 points)<\/span>
b)<\/span> Transmissions are delivered to the fabrication line <\/span>s<\/span>i<\/span>x<\/span> at <\/span>a time<\/span>. It takes <\/span>1<\/span>8<\/span>0<\/span> minutes <\/span>for transmissions <\/span>
to be delivered. Approximately <\/span>eighteen <\/span>vehicles are produced each hour, and management has decided <\/span>
that <\/span>20<\/span> percent of expected demand should be maintai<\/span>ned as safety stock. How many <\/span>K<\/span>anban card sets <\/span>
are needed?<\/span> (3 points)<\/span><\/p>\n


<\/span><\/p>\n


<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Learning Goal: I’m working on a mathematics exercise and need the explanation and answer to help me learn. For all the problems, to receive full score, you must show your complete and accurate work, i.e., show how you calculated the numbers you use. If you only provide the final answers without computations, you will not […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[529],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/8434"}],"collection":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/comments?post=8434"}],"version-history":[{"count":0,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/questions\/8434\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/media?parent=8434"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/disciplines?post=8434"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/paper_types?post=8434"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.goodacademic.com\/blog\/wp-json\/wp\/v2\/tagged?post=8434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}