The product’s popularity and demand data
The product’s popularity is driven by its high-quality ingredients and targeted marketing campaigns, attracting pet owners across urban and suburban markets. The demand data for the past six months, carefully recorded to reflect seasonal trends, promotional discounts, and pet adoption events, is presented in the table below. Accurate forecasting is critical for the manufacturer to manage raw material procurement, schedule production runs, and coordinate logistics with distributors, ensuring pet stores are well-stocked without excess inventory that could increase storage costs. Table 1: Monthly Demand Data for Premium Dog Food
Using a 3-month simple moving average, calculate the forecasted demand for month 7 to guide the manufacturer’s production planning.
Using exponential smoothing with a smoothing constant of 0.2 and an initial forecast for month 1 of 1,200 bags, calculate the forecasted demand for month 7.
Question 4: Production Scheduling for a Furniture Assembly Workshop
A specialized furniture assembly workshop produces two types of wooden chairs, Model X and Model Y, on a single assembly line to supply home furnishing retailers. The workshop operates in a competitive market, requiring precise scheduling to meet delivery deadlines and maintain customer satisfaction. Producing Model X chairs takes 0.9 hours per unit due to detailed craftsmanship, while Model Y chairs require 1.3 hours per unit because of additional finishing processes. Switching the assembly line from Model X to Model Y requires a setup time of 3.5 hours to reconfigure tools and adjust workstations, while switching from Model Y to Model X takes 2.5 hours. The workshop must produce 90 units of Model X and 70 units of Model Y in a week to fulfill a major order, with the assembly line available for 55 hours per week. The production manager needs to calculate key scheduling metrics to optimize the production sequence, prioritizing the sequence that minimizes setup time to maximize efficiency and meet deadlines.
Calculate the total production time required for 90 units of Model X and 70 units of Model Y, excluding setup times.
Calculate the total time (production + setup) required to produce the required units, using the sequence that minimizes setup time.
Question 5: Process Flowchart for Furniture Assembly
Based on the production process described in Question 4, draw a detailed flowchart to illustrate the sequence of steps for producing Model X and Model Y chairs in the furniture assembly workshop. The flowchart should include the following steps: receiving raw materials (wood and hardware for both chair models), setting up the assembly line for Model X, producing Model X chairs, setting up the assembly line for Model Y, producing Model Y chairs, inspecting finished chairs, and packaging for delivery. Incorporate decision points for selecting which chair model to produce first, handling defective units (assume a 4% defect rate for both models), and looping to process additional units. Clearly
Leave a Reply